*** glibc detected *** /usr/sbin/mysqld: corrupted double-linked list: 0x00007ff72801bff0 *** ======= Backtrace: ========= /lib/libc.so.6[0x7ffa48cf1928] /lib/libc.so.6[0x7ffa48cf4679] /lib/libc.so.6(__libc_malloc+0x98)[0x7ffa48cf5a58] /usr/sbin/mysqld(_Z16get_quick_selectP5PARAMjP7SEL_ARGP11st_mem_root+0x13b)[0x68cfab] /usr/sbin/mysqld(_ZN9TRP_RANGE10make_quickEP5PARAMbP11st_mem_root+0x13)[0x695eb3] /usr/sbin/mysqld(_ZN10SQL_SELECT17test_quick_selectEP3THD6BitmapILj64EEyyb+0xab1)[0x693021] /usr/sbin/mysqld[0x631c60] /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0x4bf)[0x63247f] /usr/sbin/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xa1)[0x63af11] /usr/sbin/mysqld(_Z13handle_selectP3THDP6st_lexP13select_resultm+0x169)[0x63b8f9] /usr/sbin/mysqld[0x5cc204] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x4c1)[0x5cf3b1] /usr/sbin/mysqld(_Z11mysql_parseP3THDPKcjPS2_+0x1fa)[0x5d49ca] /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x100b)[0x5d59eb] /usr/sbin/mysqld(_Z10do_commandP3THD+0xe4)[0x5d5fb4] /usr/sbin/mysqld(handle_one_connection+0x6f0)[0x5c9010] /lib/libpthread.so.0[0x7ffa498aefc7] /lib/libc.so.6(clone+0x6d)[0x7ffa48d4d59d] ======= Memory map: ======== 00400000-00b1d000 r-xp 00000000 09:01 156664 /usr/sbin/mysqld 00d1c000-00d7e000 rw-p 0071c000 09:01 156664 /usr/sbin/mysqld 00d7e000-18258000 rw-p 00000000 00:00 0 [heap] 401e4000-401e5000 ---p 00000000 00:00 0 401e5000-40265000 rw-p 00000000 00:00 0 40349000-4034a000 ---p 00000000 00:00 0 4034a000-403ca000 rw-p 00000000 00:00 0 40406000-40407000 ---p 00000000 00:00 0 40407000-40c07000 rw-p 00000000 00:00 0 40c07000-40c08000 ---p 00000000 00:00 0 40c08000-41408000 rw-p 00000000 00:00 0 41408000-41409000 ---p 00000000 00:00 0 41409000-41c09000 rw-p 00000000 00:00 0 41c09000-41c0a000 ---p 00000000 00:00 0 41c0a000-41c8a000 rw-p 00000000 00:00 0 41d0a000-41d0b000 ---p 00000000 00:00 0 41d0b000-4250b000 rw-p 00000000 00:00 0 4250b000-4250c000 ---p 00000000 00:00 0 4250c000-42d0c000 rw-p 00000000 00:00 0 42d0c000-42d0d000 ---p 00000000 00:00 0 42d0d000-4350d000 rw-p 00000000 00:00 0 4350d000-4350e000 ---p 00000000 00:00 0 4350e000-43d0e000 rw-p 00000000 00:00 0 43d0e000-43d0f000 ---p 00000000 00:00 0 43d0f000-4450f000 rw-p 00000000 00:00 0 4450f000-44510000 ---p 00000000 00:00 0 44510000-44d10000 rw-p 00000000 00:00 0 44d10000-44d11000 ---p 00000000 00:00 0 44d11000-44d91000 rw-p 00000000 00:00 0 44d91000-44d92000 ---p 00000000 00:00 0 44d92000-44e12000 rw-p 00000000 00:00 0 44e12000-44e13000 ---p 00000000 00:00 0 44e13000-44e93000 rw-p 00000000 00:00 0 44e93000-44e94000 ---p 00000000 00:00 0 44e94000-44f14000 rw-p 00000000 00:00 0 44f14000-44f15000 ---p 00000000 00:00 0 44f15000-44f95000 rw-p 00000000 00:00 0 44f95000-44f96000 ---p 00000000 00:00 0 44f96000-45016000 rw-p 00000000 00:00 0 45016000-45017000 ---p 00000000 00:00 0 45017000-45097000 rw-p 00000000 00:00 0 45097000-45098000 ---p 00000000 00:00 0 45098000-45118000 rw-p 00000000 00:00 0 45118000-45119000 ---p 00000000 00:00 0 45119000-45199000 rw-p 00000000 00:00 0 45199000-4519a000 ---p 00000000 00:00 0 4519a000-4521a000 rw-p 00000000 00:00 0 4521a000-4521b000 ---p 00000000 00:00 0 4521b000-4529b000 rw-p 00000000 00:00 0 4529b000-4529c000 ---p 00000000 00:00 0 4529c000-4531c000 rw-p 00000000 00:00 0 4531c000-4531d000 ---p 00000000 00:00 0 4531d000-4539d000 rw-p 00000000 00:00 0 4539d000-4539e000 ---p 00000000 00:00 0 4539e000-4541e000 rw-p 00000000 00:00 0 4541e000-4541f000 ---p 00000000 00:00 0 4541f000-4549f000 rw-p 00000000 00:00 0 4549f000-454a0000 ---p 00000000 00:00 0 454a0000-45520000 rw-p 00000000 00:00 0 45520000-45521000 ---p 00000000 00:00 0 45521000-455a1000 rw-p 00000000 00:00 0 455a1000-455a2000 ---p 00000000 00:00 0 455a2000-45622000 rw-p 00000000 00:00 0 45622000-45623000 ---p 00000000 00:00 0 45623000-456a3000 rw-p 00000000 00:00 0 456a3000-456a4000 ---p 00000000 00:00 0 456a4000-45724000 rw-p 00000000 00:00 0 45724000-45725000 ---p 00000000 00:00 0 45725000-457a5000 rw-p 00000000 00:00 0 457a5000-457a6000 ---p 00000000 00:00 0 457a6000-45826000 rw-p 00000000 00:00 0 45826000-45827000 ---p 00000000 00:00 0 45827000-458a7000 rw-p 00000000 00:00 0 458a7000-458a8000 ---p 00000000 00:00 0 458a8000-45928000 rw-p 00000000 00:00 0 45928000-45929000 ---p 00000000 00:00 0 45929000-459a9000 rw-p 00000000 00:00 0 459a9000-459aa000 ---p 00000000 00:00 0 459aa000-45a2a000 rw-p 00000000 00:00 0 45a2a000-45a2b000 ---p 00000000 00:00 0 45a2b000-45aab000 rw-p 00000000 00:00 0 45aab000-45aac000 ---p 00000000 00:00 0 45aac000-45b2c000 rw-p 00000000 00:00 0 45b2c000-45b2d000 ---p 00000000 00:00 0 45b2d000-45bad000 rw-p 00000000 00:00 0 45bad000-45bae000 ---p 00000000 00:00 0 45bae000-45c2e000 rw-p 00000000 00:00 0 45c2e000-45c2f000 ---p 00000000 00:00 0 45c2f000-45caf000 rw-p 00000000 00:00 0 45caf000-45cb0000 ---p 00000000 00:00 0 45cb0000-45d30000 rw-p 00000000 00:00 0 45d30000-45d31000 ---p 00000000 00:00 0 45d31000-45db1000 rw-p 00000000 00:00 0 45db1000-45db2000 ---p 00000000 00:00 0 45db2000-45e32000 rw-p 00000000 00:00 0 45e32000-45e33000 ---p 00000000 00:00 0 45e33000-45eb3000 rw-p 00000000 00:00 0 45eb3000-45eb4000 ---p 00000000 00:00 0 45eb4000-45f34000 rw-p 00000000 00:00 0 45f34000-45f35000 ---p 00000000 00:00 0 45f35000-45fb5000 rw-p 00000000 00:00 0 45fb5000-45fb6000 ---p 00000000 00:00 0 45fb6000-46036000 rw-p 00000000 00:00 0 46036000-46037000 ---p 00000000 00:00 0 46037000-460b7000 rw-p 00000000 00:00 0 460b7000-460b8000 ---p 00000000 00:00 0 460b8000-46138000 rw-p 00000000 00:00 0 46138000-46139000 ---p 00000000 00:00 0 46139000-461b9000 rw-p 00000000 00:00 0 461b9000-461ba000 ---p 00000000 00:00 0 461ba000-4623a000 rw-p 00000000 00:00 0 4623a000-4623b000 ---p 00000000 00:00 0 4623b000-462bb000 rw-p 00000000 00:00 0 462bb000-462bc000 ---p 00000000 00:00 0 462bc000-4633c000 rw-p 00000000 00:00 0 7ff6d07e3000-7ff6d367e000 rw-p 00000000 00:00 0 7ff720000000-7ff720c39000 rw-p 00000000 00:00 0 7ff720c39000-7ff724000000 ---p 00000000 00:00 0 7ff724000000-7ff7249bb000 rw-p 00000000 00:00 0 7ff7249bb000-7ff728000000 ---p 00000000 00:00 0 7ff728000000-7ff728a55000 rw-p 00000000 00:00 0 7ff728a55000-7ff72c000000 ---p 00000000 00:00 0 7ff72c513000-7ff72c523000 r-xp 00000000 09:01 262489 /lib/libresolv-2.7.so 7ff72c523000-7ff72c723000 ---p 00010000 09:01 262489 /lib/libresolv-2.7.so 7ff72c723000-7ff72c725000 rw-p 00010000 09:01 262489 /lib/libresolv-2.7.so 7ff72c725000-7ff72c727000 rw-p 00000000 00:00 0 7ff72c727000-7ff72c72b000 r-xp 00000000 09:01 262490 /lib/libnss_dns-2.7.so 7ff72c72b000-7ff72c92a000 ---p 00004000 09:01 262490 /lib/libnss_dns-2.7.so 7ff72c92a000-7ff72c92c000 rw-p 00003000 09:01 262490 /lib/libnss_dns-2.7.so 7ff72c92c000-7ff72c92e000 r-xp 00000000 09:01 262415 /lib/libnss_mdns4_minimal.so.2 7ff72c92e000-7ff72cb2d000 ---p 00002000 09:01 262415 /lib/libnss_mdns4_minimal.so.2 7ff72cb2d000-7ff72cb2e000 rw-p 00001000 09:01 262415 /lib/libnss_mdns4_minimal.so.2 7ff72cb2e000-7ffa48448000 rw-p 00000000 00:00 0 7ffa48448000-7ffa48452000 r-xp 00000000 09:01 262475 /lib/libnss_files-2.7.so 7ffa48452000-7ffa48652000 ---p 0000a000 09:01 262475 /lib/libnss_files-2.7.so 7ffa48652000-7ffa48654000 rw-p 0000a000 09:01 262475 /lib/libnss_files-2.7.so 7ffa48654000-7ffa4865d000 r-xp 00000000 09:01 262472 /lib/libnss_nis-2.7.so 7ffa4865d000-7ffa4885d000 ---p 00009000 09:01 262472 /lib/libnss_nis-2.7.so 7ffa4885d000-7ffa4885f000 rw-p 00009000 09:01 262472 /lib/libnss_nis-2.7.so 7ffa4885f000-7ffa48866000 r-xp 00000000 09:01 262477 /lib/libnss_compat-2.7.so 7ffa48866000-7ffa48a65000 ---p 00007000 09:01 262477 /lib/libnss_compat-2.7.so 7ffa48a65000-7ffa48a67000 rw-p 00006000 09:01 262477 /lib/libnss_compat-2.7.so 7ffa48a67000-7ffa48a7d000 r-xp 00000000 09:01 262433 /lib/libgcc_s.so.1 7ffa48a7d000-7ffa48c7d000 ---p 00016000 09:01 262433 /lib/libgcc_s.so.1 7ffa48c7d000-7ffa48c7e000 rw-p 00016000 09:01 262433 /lib/libgcc_s.so.1 7ffa48c7e000-7ffa48dc8000 r-xp 00000000 09:01 262488 /lib/libc-2.7.so 7ffa48dc8000-7ffa48fc7000 ---p 0014a000 09:01 262488 /lib/libc-2.7.so 7ffa48fc7000-7ffa48fca000 r--p 00149000 09:01 262488 /lib/libc-2.7.so 7ffa48fca000-7ffa48fcc000 rw-p 0014c000 09:01 262488 /lib/libc-2.7.so 7ffa48fcc000-7ffa48fd1000 rw-p 00000000 00:00 0 7ffa48fd1000-7ffa49053000 r-xp 00000000 09:01 262493 /lib/libm-2.7.so 7ffa49053000-7ffa49252000 ---p 00082000 09:01 262493 /lib/libm-2.7.so 7ffa49252000-7ffa49254000 rw-p 00081000 09:01 262493 /lib/libm-2.7.so 7ffa49254000-7ffa49269000 r-xp 00000000 09:01 262487 /lib/libnsl-2.7.so 7ffa49269000-7ffa49468000 ---p 00015000 09:01 262487 /lib/libnsl-2.7.so 7ffa49468000-7ffa4946a000 rw-p 00014000 09:01 262487 /lib/libnsl-2.7.so 7ffa4946a000-7ffa4946c000 rw-p 00000000 00:00 0 7ffa4946c000-7ffa49474000 r-xp 00000000 09:01 262486 /lib/libcrypt-2.7.so 7ffa49474000-7ffa49674000 ---p 00008000 09:01 262486 /lib/libcrypt-2.7.so 7ffa49674000-7ffa49676000 rw-p 00008000 09:01 262486 /lib/libcrypt-2.7.so 7ffa49676000-7ffa496a4000 rw-p 00000000 00:00 0 7ffa496a4000-7ffa496a6000 r-xp 00000000 09:01 262480 /lib/libdl-2.7.so 7ffa496a6000-7ffa498a6000 ---p 00002000 09:01 262480 /lib/libdl-2.7.so 7ffa498a6000-7ffa498a8000 rw-p 00002000 09:01 262480 /lib/libdl-2.7.so 7ffa498a8000-7ffa498be000 r-xp 00000000 09:01 262491 /lib/libpthread-2.7.so 7ffa498be000-7ffa49abe000 ---p 00016000 09:01 262491 /lib/libpthread-2.7.so 7ffa49abe000-7ffa49ac0000 rw-p 00016000 09:01 262491 /lib/libpthread-2.7.so 7ffa49ac0000-7ffa49ac4000 rw-p 00000000 00:00 0 7ffa49ac4000-7ffa49ae0000 r-xp 00000000 09:01 262482 /lib/ld-2.7.so 7ffa49c52000-7ffa49cd7000 rw-p 00000000 00:00 0 7ffa49cdb000-7ffa49cdf000 rw-p 00000000 00:00 0 7ffa49cdf000-7ffa49ce1000 rw-p 0001b000 09:01 262482 /lib/ld-2.7.so 7fffe9a77000-7fffe9a8c000 rw-p 00000000 00:00 0 [stack] 7fffe9bdd000-7fffe9bde000 r-xp 00000000 00:00 0 [vdso] ffffffffff600000-ffffffffff601000 r--p 00000000 00:00 0 [vsyscall] 100619 19:20:07 - mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=402653184 read_buffer_size=8388608 max_used_connections=44 max_threads=128 threads_connected=40 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1705237 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0x7ff72809e350 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x457a3f20 thread_stack 0x80000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x85032e] /usr/sbin/mysqld(handle_segfault+0x322)[0x5c1e92] /lib/libpthread.so.0[0x7ffa498b6a80] /lib/libc.so.6(gsignal+0x35)[0x7ffa48cafed5] /lib/libc.so.6(abort+0x183)[0x7ffa48cb13f3] /lib/libc.so.6[0x7ffa48cec388] /lib/libc.so.6[0x7ffa48cf1928] /lib/libc.so.6[0x7ffa48cf4679] /lib/libc.so.6(__libc_malloc+0x98)[0x7ffa48cf5a58] /usr/sbin/mysqld(_Z16get_quick_selectP5PARAMjP7SEL_ARGP11st_mem_root+0x13b)[0x68cfab] /usr/sbin/mysqld(_ZN9TRP_RANGE10make_quickEP5PARAMbP11st_mem_root+0x13)[0x695eb3] /usr/sbin/mysqld(_ZN10SQL_SELECT17test_quick_selectEP3THD6BitmapILj64EEyyb+0xab1)[0x693021] /usr/sbin/mysqld[0x631c60] /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0x4bf)[0x63247f] /usr/sbin/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xa1)[0x63af11] /usr/sbin/mysqld(_Z13handle_selectP3THDP6st_lexP13select_resultm+0x169)[0x63b8f9] /usr/sbin/mysqld[0x5cc204] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x4c1)[0x5cf3b1] /usr/sbin/mysqld(_Z11mysql_parseP3THDPKcjPS2_+0x1fa)[0x5d49ca] /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x100b)[0x5d59eb] /usr/sbin/mysqld(_Z10do_commandP3THD+0xe4)[0x5d5fb4] /usr/sbin/mysqld(handle_one_connection+0x6f0)[0x5c9010] /lib/libpthread.so.0[0x7ffa498aefc7] /lib/libc.so.6(clone+0x6d)[0x7ffa48d4d59d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0x7ff72401e870 is an invalid pointer thd->thread_id=41777 thd->killed=NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. mysqld: my_new.cc:51: int __cxa_pure_virtual(): Assertion `! "Aborted: pure virtual method called."' failed. 100619 19:20:08 mysqld_safe Number of processes running now: 0 100619 19:20:08 mysqld_safe mysqld restarted 100619 19:20:08 [Note] Plugin 'FEDERATED' is disabled. InnoDB: Log scan progressed past the checkpoint lsn 51 1527940932 100619 19:20:11 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... InnoDB: Doing recovery: scanned up to log sequence number 51 1533183488 InnoDB: Doing recovery: scanned up to log sequence number 51 1538426368 InnoDB: Doing recovery: scanned up to log sequence number 51 1543669248 InnoDB: Doing recovery: scanned up to log sequence number 51 1548912128 InnoDB: Doing recovery: scanned up to log sequence number 51 1554155008 InnoDB: Doing recovery: scanned up to log sequence number 51 1559397888 InnoDB: Doing recovery: scanned up to log sequence number 51 1564640768 InnoDB: Doing recovery: scanned up to log sequence number 51 1569883648 InnoDB: Doing recovery: scanned up to log sequence number 51 1574236911 InnoDB: Transaction 0 506246895 was in the XA prepared state. InnoDB: 1 transaction(s) which must be rolled back or cleaned up InnoDB: in total 0 row operations to undo InnoDB: Trx id counter is 0 506247168 100619 19:20:19 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed InnoDB: Last MySQL binlog file position 0 103014966, file name /ssd/logs_binaires/mysql-bin.002605 InnoDB: Starting in background the rollback of uncommitted transactions 100619 19:22:17 InnoDB: Rollback of non-prepared transactions completed 100619 19:22:17 InnoDB: Started; log sequence number 51 1574236911 100619 19:22:17 [Note] Recovering after a crash using /ssd/logs_binaires/mysql-bin 100619 19:22:18 [Note] Starting crash recovery... 100619 19:22:18 InnoDB: Starting recovery for XA transactions... 100619 19:22:18 InnoDB: Transaction 0 506246895 in prepared state after recovery 100619 19:22:18 InnoDB: Transaction contains changes to 2 rows 100619 19:22:18 InnoDB: 1 transactions in prepared state after recovery 100619 19:22:18 [Note] Found 1 prepared transaction(s) in InnoDB 100619 19:22:18 [Note] Crash recovery finished.