## generated
## Ping
--source include/have_debug_sync.inc
--source include/xplugin_preamble.inc
--source include/xplugin_create_user.inc
--source ../include/have_performance_schema_events_waits_history.inc

##
## Bug#23057045: CRASH WHEN RUNNING SHOW PROCESSLIST AFTER SYSBENCH RUN
##

CREATE TABLE x(id INT);
## Test starts here
--write_file $MYSQL_TMP_DIR/bug_23057045.tmp
## Test data
-->newsession con1	x_root
-->newsession con2	x_root

-->setsession con1
-->sql
SET DEBUG_SYNC= 'bgc_after_enrolling_for_sync_stage SIGNAL opened WAIT_FOR xxxx_new';
-->endsql

Mysqlx.Sql.StmtExecute {
  stmt: "INSERT INTO x(id) VALUES(2);"
  namespace: "sql"
}


-->setsession con2

-->sql
SET DEBUG_SYNC= 'bgc_after_enrolling_for_sync_stage SIGNAL xxxx_new';
-->endsql

Mysqlx.Sql.StmtExecute {
  stmt: "INSERT INTO x(id) VALUES(2);"
  namespace: "sql"
}

-->recvresult
-->setsession con1
-->recvresult
EOF

--exec $MYSQLXTEST -ux_root --password='' --schema=test --file=$MYSQL_TMP_DIR/bug_23057045.tmp 2>&1

#make sure only one process is shown in the list even in slower builds(valgrind)
--sleep 0.5

--replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME>
--replace_result "init" STATE "starting" STATE "cleaning up" STATE
--sorted_result
SHOW PROCESSLIST;

## Cleanup
DROP TABLE x;
--remove_file $MYSQL_TMP_DIR/bug_23057045.tmp
--source include/xplugin_drop_user.inc