table with no PK but still having UK, can cause crash in slave using PA
Bug #1003929 reported by
Seppo Jaakola
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| MySQL patches by Codership |
Fix Released
|
Medium
|
Seppo Jaakola | ||
| 5.5 |
Fix Released
|
Medium
|
Seppo Jaakola | ||
Bug Description
Confused? You won't be after reading this description:
If a table has no primary key (PK) assigned, but defines one or several unique keys (UK), then certain transactions on this table can cause problems with slaves which have parallel applying (PA) configured.
This issue surfaced with Drupal6 application using apache-solr module connected to a solr server.
A separate regression test has been implemented and it can reproduce this problem in just few secs.
Related branches
Revision history for this message
| Seppo Jaakola (seppo-jaakola) wrote | #1 |
To post a comment you must log in.
Fix pushed in: http://