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

Assertion `read_only' failed in mariadb_error_read_only

    XMLWordPrintable

Details

    Description

      See the comments for the analysis.

      9c1bb00c182f7cc653a6c8f462874e0deb35a413

      mysqld: /server/sql/lock.cc:113: void mariadb_error_read_only(): Assertion `read_only' failed.
      260728 20:19:19 [ERROR] /server/sql/mysqld got signal 6 ;
       
      #7  0x00007fc602e33420 in ?? () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x000055df5f92b506 in mariadb_error_read_only () at /server/sql/lock.cc:113
      #9  0x000055df5d921d88 in mysql_execute_command (thd=0x77c598000d60, is_called_from_prepared_stmt=false) at /server/sql/sql_parse.cc:3685
      #10 0x000055df5d9627ef in mysql_parse (thd=0x77c598000d60, rawbuf=0x77c598016060 "/* WRK-1 QNO 18258 */  UPDATE `test`.`local_7_1` SET `f2` = REPEAT(CHAR(65 + ( 50 % 26)), 10000 + (144 % 5) * 2000) WHERE id = 38", length=129, parser_state=0x77c5d1cf4130) at /server/sql/sql_parse.cc:7945
      #11 0x000055df5d9016a6 in dispatch_command (command=COM_QUERY, thd=0x77c598000d60, packet=0x77c59800b901 "/* WRK-1 QNO 18258 */  UPDATE `test`.`local_7_1` SET `f2` = REPEAT(CHAR(65 + ( 50 % 26)), 10000 + (144 % 5) * 2000) WHERE id = 38", packet_length=129, blocking=true) at /server/sql/sql_parse.cc:1903
      #12 0x000055df5d8f8dde in do_command (thd=0x77c598000d60, blocking=true) at /server/sql/sql_parse.cc:1437
      #13 0x000055df5e27a088 in do_handle_one_connection (connect=0x55df8cf4dba0, put_in_cache=true) at /server/sql/sql_connect.cc:1503
      #14 0x000055df5e2794d2 in handle_one_connection (arg=0x55df8cf4dba0) at /server/sql/sql_connect.cc:1415
      #15 0x000055df5ffde37b in pfs_spawn_thread (arg=0x55df8cf7a530) at /server/storage/perfschema/pfs.cc:2198
       
      Connection ID (thread ID): 9
      Status: NOT_KILLED
      Query (0x77c598016060): /* WRK-1 QNO 18258 */  UPDATE `test`.`local_7_1` SET `f2` = REPEAT(CHAR(65 + ( 50 % 26)), 10000 + (144 % 5) * 2000) WHERE id = 38
      Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,duplicateweedout=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off,hash_join_cardinality=on,cset_narrowing=on,sargable_casefold=on,reorder_outer_joins=off
      

      combo-683-46

      Attachments

        Issue Links

          Activity

            People

              monty Michael Widenius
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.