Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
12.1
-
None
-
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
- relates to
-
MDEV-35124 Set innodb_snapshot_isolation=ON by default
-
- Closed
-