[MDEV-5915] [Draft] Assertion `cache_mngr' failed in MYSQL_BIN_LOG::remove_pending_rows_event(THD*, bool) Created: 2014-03-20  Updated: 2014-12-09  Resolved: 2014-12-09

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Cannot Reproduce Votes: 0
Labels: None


 Description   

10.0/sql/log.cc:5405: int MYSQL_BIN_LOG::remove_pending_rows_event(THD*, bool): Assertion `cache_mngr' failed.
140320 19:38:58 [ERROR] mysqld got signal 6 ;

#6  0x00007fc3720da621 in *__GI___assert_fail (assertion=0xffc3bd "cache_mngr", file=<optimized out>, line=5405, function=0xffecc0 "int MYSQL_BIN_LOG::remove_pending_rows_event(THD*, bool)") at assert.c:81
#7  0x00000000009325e3 in MYSQL_BIN_LOG::remove_pending_rows_event (this=0x1882c60, thd=0x7fc3543d4070, is_transactional=true) at 10.0/sql/log.cc:5405
#8  0x0000000000641a37 in THD::binlog_remove_pending_rows_event (this=0x7fc3543d4070, clear_maps=true, is_transactional=true) at 10.0/sql/sql_class.cc:5705
#9  0x0000000000929851 in binlog_reset_cache (thd=0x7fc3543d4070) at 10.0/sql/log.cc:2061
#10 0x000000000065e64a in select_create::abort_result_set (this=0x7fc345c4af40) at 10.0/sql/sql_insert.cc:4348
#11 0x00000000006a6122 in handle_select (thd=0x7fc3543d4070, lex=0x7fc3543d7cb0, result=0x7fc345c4af40, setup_tables_done_option=0) at 10.0/sql/sql_select.cc:378
#12 0x000000000067429b in mysql_execute_command (thd=0x7fc3543d4070) at 10.0/sql/sql_parse.cc:3032
#13 0x000000000067d66b in mysql_parse (thd=0x7fc3543d4070, rawbuf=0x7fc345c4a088 "CREATE OR REPLACE TEMPORARY TABLE `tmp` AS SELECT * FROM `table10_myisam`", length=73, parser_state=0x7fc370f6b610) at 10.0/sql/sql_parse.cc:6447
#14 0x0000000000670438 in dispatch_command (command=COM_QUERY, thd=0x7fc3543d4070, packet=0x7fc3543da071 "CREATE OR REPLACE TEMPORARY TABLE `tmp` AS SELECT * FROM `table10_myisam` ", packet_length=74) at 10.0/sql/sql_parse.cc:1308
#15 0x000000000066f7da in do_command (thd=0x7fc3543d4070) at 10.0/sql/sql_parse.cc:1005
#16 0x0000000000789e72 in do_handle_one_connection (thd_arg=0x7fc3543d4070) at 10.0/sql/sql_connect.cc:1379
#17 0x0000000000789bc5 in handle_one_connection (arg=0x7fc3543d4070) at 10.0/sql/sql_connect.cc:1293
#18 0x0000000000a2f174 in pfs_spawn_thread (arg=0x7fc34d2d7ef0) at 10.0/storage/perfschema/pfs.cc:1853
#19 0x00007fc373c7eb50 in start_thread (arg=<optimized out>) at pthread_create.c:304
#20 0x00007fc372189a7d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

Query (0x7fc345c4a088): CREATE OR REPLACE TEMPORARY TABLE `tmp` AS SELECT * FROM `table10_myisam`
Connection ID (thread ID): 18
Status: KILL_QUERY

revision-id: svoj@mariadb.org-20140320071113-ql1nx7dc9h22odx3
date: 2014-03-20 11:11:13 +0400
build-date: 2014-03-20 20:55:53 +0400
revno: 4071
branch-nick: 10.0

revision-id: elenst@wheezy-64.home-20140317184117-je0d1badzet7wtrf
date: 2014-03-17 22:41:17 +0400
build-date: 2014-03-20 20:57:17 +0400
revno: 931
branch-nick: randgen-mariadb-patches

/home/elenst/bzr/randgen-mariadb-patches/runall-new.pl --queries=100000000 --no-mask --seed=1395094972 --threads=12 --duration=300 --queries=100M --reporters=QueryTimeout,Backtrace,ErrorLog,Deadlock,Shutdown --redefine=conf/mariadb/general-workarounds.yy --redefine=conf/mariadb/10.0-features-redefine.yy --mysqld=--binlog_commit_wait_count=10 --mysqld=--binlog_commit_wait_usec=1000000 --use-gtid=current_pos --skip-shutdown --genconfig=/home/elenst/tmp/my.cnf --views --grammar=conf/replication/replication.yy --gendata=conf/replication/replication-5.1.zz --rpl_mode=statement --mysqld=--slave-skip-errors=1054,1317,1049,1305,1539,1505 --mysqld=--log-output=FILE --mtr-build-thread=73 --mask=51472 --basedir1=/home/elenst/bzr/10.0 --vardir1=/home/elenst/test_results/analyze3

my.cnf:

[mariadb.runtime]
 
loose-innodb_io_capacity                                               = 1478
loose-innodb_io_capacity_max                                           = 3380
loose-innodb_max_bitmap_file_size                                      = 54970788
loose-innodb_max_dirty_pages_pct                                       = 46
loose-innodb_max_dirty_pages_pct_lwm                                   = 18
loose-innodb_open_files                                                = 529
loose-innodb_page_hash_locks                                           = 12
loose-innodb_priority_purge                                            = ON 



 Comments   
Comment by Elena Stepanova [ 2014-12-09 ]

Can't reproduce on the current 10.0 tree (10.0.15+)

Generated at Thu Feb 08 07:08:00 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.