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

error log is spammed with "[ERROR] Got error 123 when reading table .." when running sysbench-tpcc

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 12.1
    • None
    • Server
    • None

    Description

      When running sysbench tpcc with more than a single thread, the error log is filled with

      2025-06-25 22:38:33 3 [ERROR] Got error 123 when reading table '.\sbtest\district1'
      2025-06-25 22:38:59 4 [ERROR] Got error 123 when reading table '.\sbtest\district7'
      ...
      

      More threads means more such entries
      I run tpcc with

      sysbench tpcc  --mysql-user=root --threads=2 --tables=10 --scale=10 --time=100 --report-interval=1 run
      

      No other bad effects are observed.

      The error log entry comes originates from the query

      SELECT d_next_o_id, d_tax   FROM district7   WHERE d_w_id = 9   AND d_id = 4 FOR UPDATE
      

      with this stacktrace

       Index  Function 
      --------------------------------------------------------------------------------
       1      server.dll!my_error(unsigned int nr, unsigned long MyFlags, ...) 
      *2      server.dll!handler::print_error(int error, unsigned long errflag) 
       3      server.dll!report_error(TABLE * table, int error) 
       4      server.dll!join_read_const_table(THD * thd, st_join_table * tab, POSITION * pos) 
       5      server.dll!make_join_statistics(JOIN * join, List<TABLE_LIST> & tables_list, st_dynamic_array * keyuse_array) 
       6      server.dll!JOIN::optimize_inner() 
       7      server.dll!JOIN::optimize() 
       8      server.dll!mysql_select(THD * thd, TABLE_LIST * tables, List<Item> & fields, Item * conds, unsigned int og_num, st_order * order, st_order * group, Item * having, st_order * proc_param, unsigned __int64 select_options, select_result * result, st_select_lex_unit * unit, st_select_lex * select_lex) 
       9      server.dll!handle_select(THD * thd, LEX * lex, select_result * result, unsigned __int64 setup_tables_done_option) 
       10     server.dll!execute_sqlcom_select(THD * thd, TABLE_LIST * all_tables) 
       11     server.dll!mysql_execute_command(THD * thd, bool is_called_from_prepared_stmt) 
       12     server.dll!mysql_parse(THD * thd, char * rawbuf, unsigned int length, Parser_state * parser_state) 
       13     server.dll!dispatch_command(enum_server_command command, THD * thd, char * packet, unsigned int packet_length, bool blocking) 
       14     server.dll!do_command(THD * thd, bool blocking) 
       15     [Inline Frame] server.dll!threadpool_process_request(THD *) 
       16     server.dll!tp_callback(TP_connection * c) 
      

      report_error is called with error=123 (HA_ERR_RECORD_CHANGED)

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              wlad Vladislav Vaintroub
              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.