130101 11:04:32 InnoDB: Assertion failure in thread 395134720 in file buf0flu.c line 482
InnoDB: Failing assertion: bpage->in_flush_list
Just after giving errors like these:
==19340== Invalid read of size 8
==19340== at 0x8E9F6B: buf_flush_page_and_try_neighbors (buf0flu.c:480)
==19340== by 0x8EC87E: buf_flush_batch (buf0flu.c:1740)
==19340== by 0x8ED41D: buf_flush_list (buf0flu.c:2047)
==19340== by 0x8734D6: srv_master_thread (srv0srv.c:3512)
==19340== by 0x3DA1807D13: start_thread (in /usr/lib64/libpthread-2.15.so)
==19340== by 0x3DA14F168C: clone (in /usr/lib64/libc-2.15.so)
==19340== Address 0x4c5da00 is 128 bytes inside a block of size 192 free'd
==19340== at 0x4A06666: free (vg_replace_malloc.c:446)
==19340== by 0x8A9543: ut_free (ut0mem.c:221)
==19340== by 0x8E1E78: buf_page_get_gen (buf0buf.ic:886)
==19340== by 0x8E386B: buf_page_create (buf0buf.c:3760)
==19340== by 0x940759: fsp_page_create (fsp0fsp.c:1546)
==19340== by 0x941899: fseg_alloc_free_page_low (fsp0fsp.c:2833)
==19340== by 0x9426E2: fseg_alloc_free_page_general (fsp0fsp.c:2907)
==19340== by 0x8B05FF: btr_page_alloc (btr0btr.c:993)
==19340== by 0x8C5918: btr_store_big_rec_extern_fields (btr0cur.c:4509)
==19340== by 0x9CA4B3: row_ins_index_entry_low (row0ins.c:2237)
==19340== by 0x9CDE87: row_ins_index_entry (row0ins.c:2297)
==19340== by 0x9CEBCD: row_ins_step (row0ins.c:2373)
==19340== by 0x84014F: row_insert_for_mysql (row0mysql.c:1255)
==19340== by 0x81CDDB: ha_innobase::write_row(unsigned char*) (ha_innodb.cc:6061)
==19340== by 0x6BA555: handler::ha_write_row(unsigned char*) (handler.cc:5395)
==19340== by 0x585B2E: write_record(THD*, TABLE*, st_copy_info*) (sql_insert.cc:1788)
Backtrace:
Thread 5 (LWP 19421):
+bt
#0 0x0000003da180c60c in pthread_kill () from /lib64/libpthread.so.0
#1 0x00000000007dbe18 in my_write_core (sig=6) at /ssd/BT-16724-xtradb-bmp-requests-5.5-BUILD-TREE/Percona-Server-5.5.28-rel29.1/mysys/stacktrace.c:433
#2 0x00000000006b1a68 in handle_fatal_signal (sig=6) at /ssd/BT-16724-xtradb-bmp-requests-5.5-BUILD-TREE/Percona-Server-5.5.28-rel29.1/sql/signal_handler.cc:249
#3 <signal handler called>
#4 0x0000003da1435935 in raise () from /lib64/libc.so.6
#5 0x0000003da14370e8 in abort () from /lib64/libc.so.6
#6 0x00000000008e9fab in buf_flush_ready_for_flush (flush_type=BUF_FLUSH_LIST, bpage=0x4c5d980) at /ssd/BT-16724-xtradb-bmp-requests-5.5-BUILD-TREE/Percona-Server-5.5.28-rel29.1/storage/innobase/buf/buf0flu.c:482
#7 buf_flush_page_and_try_neighbors (bpage=bpage@entry=0x4c5d980, flush_type=flush_type@entry=BUF_FLUSH_LIST, n_to_flush=n_to_flush@entry=22, count=count@entry=0x178d3668) at /ssd/BT-16724-xtradb-bmp-requests-5.5-BUILD-TREE/Percona-Server-5.5.28-rel29.1/storage/innobase/buf/buf0flu.c:1587
#8 0x00000000008ec87f in buf_flush_flush_list_batch (lsn_limit=277030465, min_n=22, buf_pool=0x5dc0c28) at /ssd/BT-16724-xtradb-bmp-requests-5.5-BUILD-TREE/Percona-Server-5.5.28-rel29.1/storage/innobase/buf/buf0flu.c:1740
#9 buf_flush_batch (buf_pool=buf_pool@entry=0x5dc0c28, flush_type=flush_type@entry=BUF_FLUSH_LIST, min_n=min_n@entry=22, lsn_limit=lsn_limit@entry=277030465) at /ssd/BT-16724-xtradb-bmp-requests-5.5-BUILD-TREE/Percona-Server-5.5.28-rel29.1/storage/innobase/buf/buf0flu.c:1830
#10 0x00000000008ed41e in buf_flush_list (min_n=<optimized out>, min_n@entry=22, lsn_limit=lsn_limit@entry=277030465) at /ssd/BT-16724-xtradb-bmp-requests-5.5-BUILD-TREE/Percona-Server-5.5.28-rel29.1/storage/innobase/buf/buf0flu.c:2047
#11 0x00000000008734d7 in srv_master_thread (arg=<optimized out>) at /ssd/BT-16724-xtradb-bmp-requests-5.5-BUILD-TREE/Percona-Server-5.5.28-rel29.1/storage/innobase/srv/srv0srv.c:3512
#12 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0
#13 0x0000003da14f168d in clone () from /lib64/libc.so.6
In Debug + Valgrind, the sever asserts with:
130101 11:04:32 InnoDB: Assertion failure in thread 395134720 in file buf0flu.c line 482 in_flush_ list
InnoDB: Failing assertion: bpage->
Just after giving errors like these:
==19340== Invalid read of size 8 page_and_ try_neighbors (buf0flu.c:480) libpthread- 2.15.so) libc-2. 15.so) malloc. c:446) free_page_ low (fsp0fsp.c:2833) free_page_ general (fsp0fsp.c:2907) big_rec_ extern_ fields (btr0cur.c:4509) index_entry_ low (row0ins.c:2237) for_mysql (row0mysql.c:1255) :write_ row(unsigned char*) (ha_innodb.cc:6061) :ha_write_ row(unsigned char*) (handler.cc:5395) cc:1788)
==19340== at 0x8E9F6B: buf_flush_
==19340== by 0x8EC87E: buf_flush_batch (buf0flu.c:1740)
==19340== by 0x8ED41D: buf_flush_list (buf0flu.c:2047)
==19340== by 0x8734D6: srv_master_thread (srv0srv.c:3512)
==19340== by 0x3DA1807D13: start_thread (in /usr/lib64/
==19340== by 0x3DA14F168C: clone (in /usr/lib64/
==19340== Address 0x4c5da00 is 128 bytes inside a block of size 192 free'd
==19340== at 0x4A06666: free (vg_replace_
==19340== by 0x8A9543: ut_free (ut0mem.c:221)
==19340== by 0x8E1E78: buf_page_get_gen (buf0buf.ic:886)
==19340== by 0x8E386B: buf_page_create (buf0buf.c:3760)
==19340== by 0x940759: fsp_page_create (fsp0fsp.c:1546)
==19340== by 0x941899: fseg_alloc_
==19340== by 0x9426E2: fseg_alloc_
==19340== by 0x8B05FF: btr_page_alloc (btr0btr.c:993)
==19340== by 0x8C5918: btr_store_
==19340== by 0x9CA4B3: row_ins_
==19340== by 0x9CDE87: row_ins_index_entry (row0ins.c:2297)
==19340== by 0x9CEBCD: row_ins_step (row0ins.c:2373)
==19340== by 0x84014F: row_insert_
==19340== by 0x81CDDB: ha_innobase:
==19340== by 0x6BA555: handler:
==19340== by 0x585B2E: write_record(THD*, TABLE*, st_copy_info*) (sql_insert.
Backtrace:
Thread 5 (LWP 19421): libpthread. so.0 16724-xtradb- bmp-requests- 5.5-BUILD- TREE/Percona- Server- 5.5.28- rel29.1/ mysys/stacktrac e.c:433 16724-xtradb- bmp-requests- 5.5-BUILD- TREE/Percona- Server- 5.5.28- rel29.1/ sql/signal_ handler. cc:249 ready_for_ flush (flush_ type=BUF_ FLUSH_LIST, bpage=0x4c5d980) at /ssd/BT- 16724-xtradb- bmp-requests- 5.5-BUILD- TREE/Percona- Server- 5.5.28- rel29.1/ storage/ innobase/ buf/buf0flu. c:482 page_and_ try_neighbors (bpage= bpage@entry= 0x4c5d980, flush_type= flush_type@ entry=BUF_ FLUSH_LIST, n_to_flush= n_to_flush@ entry=22, count=count@ entry=0x178d366 8) at /ssd/BT- 16724-xtradb- bmp-requests- 5.5-BUILD- TREE/Percona- Server- 5.5.28- rel29.1/ storage/ innobase/ buf/buf0flu. c:1587 flush_list_ batch (lsn_limit= 277030465, min_n=22, buf_pool=0x5dc0c28) at /ssd/BT- 16724-xtradb- bmp-requests- 5.5-BUILD- TREE/Percona- Server- 5.5.28- rel29.1/ storage/ innobase/ buf/buf0flu. c:1740 buf_pool@ entry=0x5dc0c28 , flush_type= flush_type@ entry=BUF_ FLUSH_LIST, min_n=min_ n@entry= 22, lsn_limit= lsn_limit@ entry=277030465 ) at /ssd/BT- 16724-xtradb- bmp-requests- 5.5-BUILD- TREE/Percona- Server- 5.5.28- rel29.1/ storage/ innobase/ buf/buf0flu. c:1830 lsn_limit@ entry=277030465 ) at /ssd/BT- 16724-xtradb- bmp-requests- 5.5-BUILD- TREE/Percona- Server- 5.5.28- rel29.1/ storage/ innobase/ buf/buf0flu. c:2047 16724-xtradb- bmp-requests- 5.5-BUILD- TREE/Percona- Server- 5.5.28- rel29.1/ storage/ innobase/ srv/srv0srv. c:3512 libpthread. so.0
+bt
#0 0x0000003da180c60c in pthread_kill () from /lib64/
#1 0x00000000007dbe18 in my_write_core (sig=6) at /ssd/BT-
#2 0x00000000006b1a68 in handle_fatal_signal (sig=6) at /ssd/BT-
#3 <signal handler called>
#4 0x0000003da1435935 in raise () from /lib64/libc.so.6
#5 0x0000003da14370e8 in abort () from /lib64/libc.so.6
#6 0x00000000008e9fab in buf_flush_
#7 buf_flush_
#8 0x00000000008ec87f in buf_flush_
#9 buf_flush_batch (buf_pool=
#10 0x00000000008ed41e in buf_flush_list (min_n=<optimized out>, min_n@entry=22, lsn_limit=
#11 0x00000000008734d7 in srv_master_thread (arg=<optimized out>) at /ssd/BT-
#12 0x0000003da1807d14 in start_thread () from /lib64/
#13 0x0000003da14f168d in clone () from /lib64/libc.so.6
PS Version: 5.5.28- rel29.1- debug-log (x64)