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

Assertion `thd->m_transaction_psi == __null' failed in trans_commit_implicit

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.5, 10.6, 10.7
    • 10.5, 10.6
    • Replication
    • None

    Description

      to repeat - replay binlog, that is attached in a1.7z with -mysqld=log-bin=mysql-bin --mysqld=-slave-skip-errors=all

      preview-10.8-MDEV-11675-rpl-lag-free-alter 3fb5ca75f228f49

      /10.8/sql/transaction.cc:336: bool trans_commit_implicit(THD*): Assertion `thd->m_transaction_psi == __null' failed.
      220112 14:01:31 [ERROR] mysqld got signal 6 ;
       
      Server version: 10.8.0-MariaDB-debug-log
       
      ??:0(__assert_fail)[0x7f8225b98f36]
      sql/transaction.cc:344(trans_commit_implicit(THD*))[0x55d30739d21c]
      sql/sql_sequence.cc:371(sequence_insert(THD*, LEX*, TABLE_LIST*))[0x55d30758b197]
      sql/sql_table.cc:4700(mysql_create_table_no_lock(THD*, st_ddl_log_state*, st_ddl_log_state*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, Table_specification_st*, Alter_info*, bool*, int, TABLE_LIST*))[0x55d30718bcaf]
      sql/sql_table.cc:4798(mysql_create_table(THD*, TABLE_LIST*, Table_specification_st*, Alter_info*))[0x55d30718c830]
      sql/sql_table.cc:12198(Sql_cmd_create_table_like::execute(THD*))[0x55d3071c3b30]
      sql/sql_parse.cc:5989(mysql_execute_command(THD*, bool))[0x55d306ed4161]
      sql/sql_parse.cc:8028(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55d306ee1987]
      sql/log_event_server.cc:2148(Query_log_event::do_apply_event(rpl_group_info*, char const*, unsigned int))[0x55d307b4bc16]
      sql/log_event_server.cc:1613(Query_log_event::do_apply_event(rpl_group_info*))[0x55d307b474c9]
      sql/log_event.h:1518(Log_event::apply_event(rpl_group_info*))[0x55d306c455b7]
      sql/slave.cc:3881(apply_event_and_update_pos_apply(Log_event*, THD*, rpl_group_info*, int))[0x55d306c26954]
      sql/slave.cc:4078(apply_event_and_update_pos_for_parallel(Log_event*, THD*, rpl_group_info*))[0x55d306c2786a]
      sql/rpl_parallel.cc:62(rpt_handle_event(rpl_parallel_thread::queued_event*, rpl_parallel_thread*))[0x55d3074d70f3]
      sql/rpl_parallel.cc:1409(handle_rpl_parallel_thread)[0x55d3074df3cf]
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55d3080081df]
      nptl/pthread_create.c:478(start_thread)[0x7f82260b1609]
      ??:0(clone)[0x7f8225c84293]
       
      Query (0x613000122393): CREATE /* QNO 326 CON_ID 18 */ TEMPORARY SEQUENCE seq6 MINVALUE = -1242993497154256896 NOCYCLE
      

      Attachments

        Activity

          People

            Elkin Andrei Elkin
            alice Alice Sherepa
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.