2012-04-29 06:05:12 |
m4v |
bug |
|
|
added bug |
2012-04-30 03:14:20 |
m4v |
summary |
[stormyfacts] MySQL support is fubar in Precise |
[stormyfacts] MySQL fails with InnoDB engine |
|
2012-04-30 03:17:20 |
m4v |
summary |
[stormyfacts] MySQL fails with InnoDB engine |
[stormyfacts] The code doesn't enforce foreign keys anywhere |
|
2012-04-30 03:17:34 |
m4v |
ubuntu-bots: importance |
High |
Medium |
|
2012-04-30 03:26:26 |
m4v |
ubuntu-bots: status |
Confirmed |
Triaged |
|
2012-04-30 03:26:28 |
m4v |
description |
Dunno the cause, but now out of the blue all MySQL tests fail. Logs shows something like:
ERROR: (1005, "Can't create table 'stormyfacts.facts' (errno: 150)")
Maybe it was the MySQL update I had last week. |
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.
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. |
|
2012-04-30 03:26:43 |
m4v |
description |
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.
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. |
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. |
|
2012-06-03 06:48:04 |
m4v |
ubuntu-bots: importance |
Medium |
Low |
|
2012-06-03 06:48:14 |
m4v |
summary |
[stormyfacts] The code doesn't enforce foreign keys anywhere |
[stormyfacts] The code doesn't enforce foreign keys in Sqlite |
|