Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5915

[Draft] Assertion `cache_mngr' failed in MYSQL_BIN_LOG::remove_pending_rows_event(THD*, bool)

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Cannot Reproduce
    • Affects Version/s: None
    • Fix Version/s: N/A
    • Component/s: OTHER
    • 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 
      

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            elenst Elena Stepanova added a comment -

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

            Show
            elenst Elena Stepanova added a comment - Can't reproduce on the current 10.0 tree (10.0.15+)

              People

              • Assignee:
                elenst Elena Stepanova
                Reporter:
                elenst Elena Stepanova
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: