DBT2 database load fails
Bug #512550 reported by
Seppo Jaakola
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL patches by Codership |
Fix Released
|
Critical
|
Seppo Jaakola |
Bug Description
Loading of 30 warehouse DBT2 test database fails in 3 node cluster.
The command to load was:
mysql -uroot -prootpass -habyssinian dbt2 < dbt2_30wh.sql
Where dbt2_30wh.sql is mysqldump from a 30 warehouse DBT2 database
As a result, the first node hangs in alter table command:
| 6 | root | 10.0.0.101:58402 | dbt2 | Query | 6353 | freeing items | /*!40000 ALTER TABLE `order_line` ENABLE KEYS */ ||
Changed in codership-mysql: | |
status: | In Progress → Fix Committed |
Changed in codership-mysql: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
Appears that the master node crashed:
100125 22:39:08 [ERROR] WSREP: failed to allocate write set items 1483033697-0 for 780 mysql-5. 1.42-galera- 0.7.2-x86_ 64/mysql/ libexec/ mysqld: corrupted double-linked list: 0x00007f1f2153d5a0 *** so.6[0x7f1f4a65 acb8] so.6[0x7f1f4a65 e333] so.6(__ libc_malloc+ 0x98)[0x7f1f4a6 5f828] mysql-5. 1.42-galera- 0.7.2-x86_ 64/galera/ lib/libwsdb. so.2[0x7f1f2971 6282] mysql-5. 1.42-galera- 0.7.2-x86_ 64/galera/ lib/libwsdb. so.2(wsdb_ get_write_ set+0x1e5) [0x7f1f297169c5 ] mysql-5. 1.42-galera- 0.7.2-x86_ 64/galera/ lib/libmmgalera .so[0x7f1f29928 9a2] mysql-5. 1.42-galera- 0.7.2-x86_ 64/mysql/ libexec/ mysqld[ 0x741d18] mysql-5. 1.42-galera- 0.7.2-x86_ 64/mysql/ libexec/ mysqld( _Z19ha_ commit_ one_phaseP3THDb +0x7c)[ 0x6a2a76] mysql-5. 1.42-galera- 0.7.2-x86_ 64/mysql/ libexec/ mysqld( _Z15ha_ commit_ transP3THDb+ 0x181)[ 0x6a2cdb] mysql-5. 1.42-galera- 0.7.2-x86_ 64/mysql/ libexec/ mysqld( _Z25ha_ autocommit_ or_rollbackP3TH Di+0x22) [0x6a2f44] mysql-5. 1.42-galera- 0.7.2-x86_ 64/mysql/ libexec/ mysqld( _Z16dispatch_ command19enum_ server_ commandP3THDPcj +0x28e) [0x5c4c5c] mysql-5. 1.42-galera- 0.7.2-x86_ 64/mysql/ libexec/ mysqld( _Z10do_ commandP3THD+ 0x1fb)[ 0x5c6ae1] mysql-5. 1.42-galera- 0.7.2-x86_ 64/mysql/ libexec/ mysqld( handle_ one_connection+ 0x5a9)[ 0x5b3873] .so.0[0x7f1f4b2 373ba] so.6(clone+ 0x6d)[0x7f1f4a6 c8fcd] mysql-5. 1.42-galera- 0.7.2-x86_ 64/mysql/ libexec/ mysqld mysql-5. 1.42-galera- 0.7.2-x86_ 64/mysql/ libexec/ mysqld 7f1e9c000000 rw-p 7f1e98000000 00:00 0 7f1ea3ffe000 rw-p 7f1ea0000000 00:00 0 7f1ea4000000 ---p 7f1ea3ffe000 00:00 0 7f1eee920000 rw-p 7f1eec000000 00:00 0 7f1ef0000000 ---p 7f1eee920000 00:00 0 7f1f07778000 rw-p 7f1f05f6f000 00:00 0 7f1f1c000000 rw-p 7f1f18000000 00:00 0 7f1f1f455000 rw-p 7f1f1f223000 00:00 0 7f1f24000000 rw-p 7f1f20000000 00:00 0 7f1f27064000 rw-p 7f1f25064000 00:00 0 7f1f27078000 r-xp 00000000 fc:00 2187299 /lib/libresolv- 2.9.so 7f1f27278000 ---p 00014000 fc:00 2187299 /lib/libresolv- 2.9.so 7f1f27279000 r--p 00014000 fc:00 2187299 /lib/libresolv- 2.9.so 7f1f2727a000 rw-p 00015000 fc:00 2187299 /lib/libresolv- 2.9.so 7f1f2727c000 rw-p 7f1f2727a000 00:00 0 7f1f27281000 r-xp 00000000 fc:00 2187292 /lib/libnss_ dns-2.9. so 7f1f27480000 ---p 00005000 fc:00 2187292 /lib/libnss_ dns-2.9. so 7f1f27481000 r--p 00004000 fc:00 2187292 /...
*** glibc detected *** /home/galera/
======= Backtrace: =========
/lib/libc.
/lib/libc.
/lib/libc.
/home/galera/
/home/galera/
/home/galera/
/home/galera/
/home/galera/
/home/galera/
/home/galera/
/home/galera/
/home/galera/
/home/galera/
/lib/libpthread
/lib/libc.
======= Memory map: ========
00400000-00ae6000 r-xp 00000000 fc:00 3621239 /home/galera/
00ce6000-00d45000 rw-p 006e6000 fc:00 3621239 /home/galera/
00d45000-00d5d000 rw-p 00d45000 00:00 0
00e0a000-02b6e000 rw-p 00e0a000 00:00 0 [heap]
7f1e98000000-
7f1ea0000000-
7f1ea3ffe000-
7f1eec000000-
7f1eee920000-
7f1f05f6f000-
7f1f18000000-
7f1f1f223000-
7f1f20000000-
7f1f25064000-
7f1f27064000-
7f1f27078000-
7f1f27278000-
7f1f27279000-
7f1f2727a000-
7f1f2727c000-
7f1f27281000-
7f1f27480000-