[MDEV-6651] MariaDB galera cluster crashes Created: 2014-08-27 Updated: 2014-09-03 Resolved: 2014-09-03 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | 10.0.12-galera |
| Fix Version/s: | 10.0.13-galera |
| Type: | Bug | Priority: | Major |
| Reporter: | Michael Spector | Assignee: | Nirbhay Choubey (Inactive) |
| Resolution: | Fixed | Votes: | 1 |
| Labels: | galera | ||
| Attachments: |
|
| Description |
|
|
| Comments |
| Comment by Johnny Antonsen [ 2014-09-02 ] |
|
I'm having a very similar problem on MariaDB 10.0.12. Here are the details: galera 25.3.5-wheezy WSREP: FK key len exceeded 8 36 16 To report this bug, see http://kb.askmonty.org/en/reporting-bugs We will try our best to scrape up some info that will hopefully help Server version: 10.0.12-MariaDB-1~trusty-wsrep-log Thread pointer: 0x0x7f7e9657c008 Trying to get some variables. Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains |
| Comment by Jan Lindström (Inactive) [ 2014-09-03 ] |
|
Hi, Is it possible to get full unedited error log and show create table for table neutron/ipallocations and if it has foreign keys, table where it references or table that references to this table. |
| Comment by Jan Lindström (Inactive) [ 2014-09-03 ] |
|
Hmm, I could not repeat with 10.0.13-galera, let me see if this is repeatable with 10.0.12-galera. |
| Comment by Jan Lindström (Inactive) [ 2014-09-03 ] |
|
No, it does not repeat. |
| Comment by Johnny Antonsen [ 2014-09-03 ] |
|
You are trying both 10.0.13 and 10.0.12 galera with replication? It works fine on a single node, but fails once we run with replication. |
| Comment by Jan Lindström (Inactive) [ 2014-09-03 ] |
|
Both runs with 2-node galera cluster. |
| Comment by Jan Lindström (Inactive) [ 2014-09-03 ] |
|
Hmm, that key used on delete does not exists on database, that could be the why it does not fail, I would need database before the delete. |
| Comment by Johnny Antonsen [ 2014-09-03 ] |
|
I'm a bit uncertain on how to produce that data for you. Is there any more I can provide you with to help out in the investigation? This is a development system we are working on, so there are no backups run of the databases, which means I can't produce a database from prior to the delete query. |
| Comment by Jan Lindström (Inactive) [ 2014-09-03 ] |
|
Ok, using the key on query, I generated data and I was able to repeat the problem on 10.0.12-galera |
| Comment by Jan Lindström (Inactive) [ 2014-09-03 ] |
|
File fk.test should be copied to mysql-test/suite/galera/t directory and datafile.dat to mysql-test/std_data directory |
| Comment by Jan Lindström (Inactive) [ 2014-09-03 ] |
|
Problem is already fixed on 10.0.13-galera. |