ubuntu-bots team mailing list archive

[m4v <lambdae2@xxxxxxxxx>]

** Changed in: ubuntu-bots
       Status: Confirmed => Triaged

** Description changed:

- Dunno the cause, but now out of the blue all MySQL tests fail. Logs
- shows something like:
+ So until now I have been working thinking that either SQLite and MySQL
+ were enforcing foreign keys, but it turns out they weren't. "PRAGMA
+ foreign_keys = ON" doesn't work with storm
+ (https://bugs.launchpad.net/storm/+bug/676702) and apparently I was
+ using MyISAM with my MySQL server.
  
- ERROR: (1005, "Can't create table 'stormyfacts.facts' (errno: 150)")
- 
- Maybe it was the MySQL update I had last week.
+ The result is that the code can't even create a table without upsetting
+ the constraint rules, if you're using InnoDB with MySQL then you aren't
+ going to go far with Stormyfacts.

** Description changed:

- So until now I have been working thinking that either SQLite and MySQL
- were enforcing foreign keys, but it turns out they weren't. "PRAGMA
+ So until now I have been working thinking that SQLite and MySQL were
+ enforcing foreign keys, but it turns out they weren't. "PRAGMA
  foreign_keys = ON" doesn't work with storm
  (https://bugs.launchpad.net/storm/+bug/676702) and apparently I was
  using MyISAM with my MySQL server.
  
  The result is that the code can't even create a table without upsetting
  the constraint rules, if you're using InnoDB with MySQL then you aren't
  going to go far with Stormyfacts.

-- 
You received this bug notification because you are a member of Ubuntu
IRC Bots, which is subscribed to Ubuntu IRC Bots.
https://bugs.launchpad.net/bugs/990919

Title:
  [stormyfacts] The code doesn't enforce foreign keys anywhere

Status in The official Ubuntu IRC bots:
  Triaged

Bug description:
  So until now I have been working thinking that SQLite and MySQL were
  enforcing foreign keys, but it turns out they weren't. "PRAGMA
  foreign_keys = ON" doesn't work with storm
  (https://bugs.launchpad.net/storm/+bug/676702) and apparently I was
  using MyISAM with my MySQL server.

  The result is that the code can't even create a table without
  upsetting the constraint rules, if you're using InnoDB with MySQL then
  you aren't going to go far with Stormyfacts.

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu-bots/+bug/990919/+subscriptions