TeslaCN commented on issue #10273: URL: https://github.com/apache/shardingsphere/issues/10273#issuecomment-849351421
``` sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3) Running the test with following options: Number of threads: 12 Report intermediate results every 5 second(s) Initializing random number generator from current time Initializing worker threads... Threads started! [ 5s ] thds: 12 tps: 1001.38 qps: 1001.38 (r/w/o: 0.00/1001.38/0.00) lat (ms,99%): 5.99 err/s: 0.00 reconn/s: 0.00 [ 10s ] thds: 12 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 15s ] thds: 12 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 12 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 25s ] thds: 12 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 12 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 35s ] thds: 12 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 12 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 45s ] thds: 12 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 12 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 55s ] thds: 12 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 12 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 65s ] thds: 12 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 12 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 75s ] thds: 12 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 12 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 85s ] thds: 12 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 12 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 95s ] thds: 12 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 12 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 105s ] thds: 12 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 12 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 115s ] thds: 12 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 120s ] thds: 12 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 FATAL: PQexecPrepared() failed: 7 Lock wait timeout: thread 139759619143424 on node gaussdb waiting for ShareLock on transaction 3488720 after 119917.300 ms FATAL: `thread_run' function failed: /usr/local/share/sysbench/oltp_common.lua:465: SQL error, errno = 0, state = 'YY003': Lock wait timeout: thread 139759619143424 on node gaussdb waiting for ShareLock on transaction 3488720 after 119917.300 ms FATAL: PQexecPrepared() failed: 7 Lock wait timeout: thread 139760003708672 on node gaussdb waiting for ShareLock on transaction 3488720 after 119917.503 ms FATAL: `thread_run' function failed: /usr/local/share/sysbench/oltp_common.lua:465: SQL error, errno = 0, state = 'YY003': Lock wait timeout: thread 139760003708672 on node gaussdb waiting for ShareLock on transaction 3488720 after 119917.503 ms FATAL: PQexecPrepared() failed: 7 Lock wait timeout: thread 139758244001536 on node gaussdb waiting for ShareLock on transaction 3488732 after 119917.483 ms FATAL: `thread_run' function failed: /usr/local/share/sysbench/oltp_common.lua:465: SQL error, errno = 0, state = 'YY003': Lock wait timeout: thread 139758244001536 on node gaussdb waiting for ShareLock on transaction 3488732 after 119917.483 ms FATAL: PQexecPrepared() failed: 7 Lock wait timeout: thread 139759918249728 on node gaussdb waiting for ShareLock on transaction 3488743 after 119917.323 ms FATAL: `thread_run' function failed: /usr/local/share/sysbench/oltp_common.lua:465: SQL error, errno = 0, state = 'YY003': Lock wait timeout: thread 139759918249728 on node gaussdb waiting for ShareLock on transaction 3488743 after 119917.323 ms FATAL: PQexecPrepared() failed: 7 Lock wait timeout: thread 139759858476800 on node gaussdb waiting for ShareLock on transaction 3488746 after 119917.468 ms FATAL: `thread_run' function failed: /usr/local/share/sysbench/oltp_common.lua:465: SQL error, errno = 0, state = 'YY003': Lock wait timeout: thread 139759858476800 on node gaussdb waiting for ShareLock on transaction 3488746 after 119917.468 ms FATAL: PQexecPrepared() failed: 7 Lock wait timeout: thread 139757668853504 on node gaussdb waiting for ShareLock on transaction 3488728 after 119917.507 ms FATAL: `thread_run' function failed: /usr/local/share/sysbench/oltp_common.lua:465: SQL error, errno = 0, state = 'YY003': Lock wait timeout: thread 139757668853504 on node gaussdb waiting for ShareLock on transaction 3488728 after 119917.507 ms FATAL: PQexecPrepared() failed: 7 Lock wait timeout: thread 139759803954944 on node gaussdb waiting for ShareLock on transaction 3488735 after 119917.828 ms FATAL: `thread_run' function failed: /usr/local/share/sysbench/oltp_common.lua:465: SQL error, errno = 0, state = 'YY003': Lock wait timeout: thread 139759803954944 on node gaussdb waiting for ShareLock on transaction 3488735 after 119917.828 ms FATAL: PQexecPrepared() failed: 7 Lock wait timeout: thread 139759231559424 on node gaussdb waiting for ShareLock on transaction 3488725 after 119917.403 ms FATAL: `thread_run' function failed: /usr/local/share/sysbench/oltp_common.lua:465: SQL error, errno = 0, state = 'YY003': Lock wait timeout: thread 139759231559424 on node gaussdb waiting for ShareLock on transaction 3488725 after 119917.403 ms FATAL: PQexecPrepared() failed: 7 Lock wait timeout: thread 139757685634816 on node gaussdb waiting for ShareLock on transaction 3488722 after 119917.783 ms FATAL: `thread_run' function failed: /usr/local/share/sysbench/oltp_common.lua:465: SQL error, errno = 0, state = 'YY003': Lock wait timeout: thread 139757685634816 on node gaussdb waiting for ShareLock on transaction 3488722 after 119917.783 ms FATAL: PQexecPrepared() failed: 7 Lock wait timeout: thread 139759946036992 on node gaussdb waiting for ShareLock on transaction 3488725 after 119917.462 ms FATAL: `thread_run' function failed: /usr/local/share/sysbench/oltp_common.lua:465: SQL error, errno = 0, state = 'YY003': Lock wait timeout: thread 139759946036992 on node gaussdb waiting for ShareLock on transaction 3488725 after 119917.462 ms FATAL: PQexecPrepared() failed: 7 Lock wait timeout: thread 139759558256384 on node gaussdb waiting for ShareLock on transaction 3488732 after 119918.332 ms FATAL: `thread_run' function failed: /usr/local/share/sysbench/oltp_common.lua:465: SQL error, errno = 0, state = 'YY003': Lock wait timeout: thread 139759558256384 on node gaussdb waiting for ShareLock on transaction 3488732 after 119918.332 ms sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3) Running the test with following options: Number of threads: 12 Report intermediate results every 5 second(s) Initializing random number generator from current time Initializing worker threads... Threads started! FATAL: PQexecPrepared() failed: 7 SearchCatCacheCheck:current transaction is aborted, commands ignored until end of transaction block, firstChar[B] FATAL: `thread_run' function failed: /usr/local/share/sysbench/oltp_common.lua:476: SQL error, errno = 0, state = '25P02': SearchCatCacheCheck:current transaction is aborted, commands ignored until end of transaction block, firstChar[B] FATAL: PQexecPrepared() failed: 7 SearchCatCacheCheck:current transaction is aborted, commands ignored until end of transaction block, firstChar[B] FATAL: `thread_run' function failed: /usr/local/share/sysbench/oltp_common.lua:476: SQL error, errno = 0, state = '25P02': SearchCatCacheCheck:current transaction is aborted, commands ignored until end of transaction block, firstChar[B] FATAL: PQexecPrepared() failed: 7 SearchCatCacheCheck:current transaction is aborted, commands ignored until end of transaction block, firstChar[B] FATAL: `thread_run' function failed: /usr/local/share/sysbench/oltp_common.lua:476: SQL error, errno = 0, state = '25P02': SearchCatCacheCheck:current transaction is aborted, commands ignored until end of transaction block, firstChar[B] FATAL: PQexecPrepared() failed: 7 SearchCatCacheCheck:current transaction is aborted, commands ignored until end of transaction block, firstChar[B] FATAL: `thread_run' function failed: /usr/local/share/sysbench/oltp_common.lua:476: SQL error, errno = 0, state = '25P02': SearchCatCacheCheck:current transaction is aborted, commands ignored until end of transaction block, firstChar[B] FATAL: PQexecPrepared() failed: 7 SearchCatCacheCheck:current transaction is aborted, commands ignored until end of transaction block, firstChar[B] FATAL: `thread_run' function failed: /usr/local/share/sysbench/oltp_common.lua:476: SQL error, errno = 0, state = '25P02': SearchCatCacheCheck:current transaction is aborted, commands ignored until end of transaction block, firstChar[B] FATAL: PQexecPrepared() failed: 7 SearchCatCacheCheck:current transaction is aborted, commands ignored until end of transaction block, firstChar[B] FATAL: `thread_run' function failed: /usr/local/share/sysbench/oltp_common.lua:476: SQL error, errno = 0, state = '25P02': SearchCatCacheCheck:current transaction is aborted, commands ignored until end of transaction block, firstChar[B] FATAL: PQexecPrepared() failed: 7 SearchCatCacheCheck:current transaction is aborted, commands ignored until end of transaction block, firstChar[B] FATAL: `thread_run' function failed: /usr/local/share/sysbench/oltp_common.lua:476: SQL error, errno = 0, state = '25P02': SearchCatCacheCheck:current transaction is aborted, commands ignored until end of transaction block, firstChar[B] FATAL: PQexecPrepared() failed: 7 SearchCatCacheCheck:current transaction is aborted, commands ignored until end of transaction block, firstChar[B] (last message repeated 1 times) FATAL: `thread_run' function failed: /usr/local/share/sysbench/oltp_common.lua:476: SQL error, errno = 0, state = '25P02': SearchCatCacheCheck:current transaction is aborted, commands ignored until end of transaction block, firstChar[B] sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3) Running the test with following options: Number of threads: 12 Report intermediate results every 5 second(s) Initializing random number generator from current time Initializing worker threads... Threads started! FATAL: PQexecPrepared() failed: 7 SearchCatCacheCheck:current transaction is aborted, commands ignored until end of transaction block, firstChar[B] FATAL: `thread_run' function failed: /usr/local/share/sysbench/oltp_delete.lua:33: SQL error, errno = 0, state = '25P02': SearchCatCacheCheck:current transaction is aborted, commands ignored until end of transaction block, firstChar[B] FATAL: PQexecPrepared() failed: 7 SearchCatCacheCheck:current transaction is aborted, commands ignored until end of transaction block, firstChar[B] FATAL: `thread_run' function failed: /usr/local/share/sysbench/oltp_delete.lua:33: SQL error, errno = 0, state = '25P02': SearchCatCacheCheck:current transaction is aborted, commands ignored until end of transaction block, firstChar[B] FATAL: PQexecPrepared() failed: 7 SearchCatCacheCheck:current transaction is aborted, commands ignored until end of transaction block, firstChar[B] FATAL: `thread_run' function failed: /usr/local/share/sysbench/oltp_delete.lua:33: SQL error, errno = 0, state = '25P02': SearchCatCacheCheck:current transaction is aborted, commands ignored until end of transaction block, firstChar[B] FATAL: PQexecPrepared() failed: 7 SearchCatCacheCheck:current transaction is aborted, commands ignored until end of transaction block, firstChar[B] FATAL: `thread_run' function failed: /usr/local/share/sysbench/oltp_delete.lua:33: SQL error, errno = 0, state = '25P02': SearchCatCacheCheck:current transaction is aborted, commands ignored until end of transaction block, firstChar[B] FATAL: PQexecPrepared() failed: 7 SearchCatCacheCheck:current transaction is aborted, commands ignored until end of transaction block, firstChar[B] (last message repeated 1 times) FATAL: `thread_run' function failed: /usr/local/share/sysbench/oltp_delete.lua:33: SQL error, errno = 0, state = '25P02': SearchCatCacheCheck:current transaction is aborted, commands ignored until end of transaction block, firstChar[B] (last message repeated 1 times) FATAL: PQexecPrepared() failed: 7 SearchCatCacheCheck:current transaction is aborted, commands ignored until end of transaction block, firstChar[B] FATAL: `thread_run' function failed: /usr/local/share/sysbench/oltp_delete.lua:33: SQL error, errno = 0, state = '25P02': SearchCatCacheCheck:current transaction is aborted, commands ignored until end of transaction block, firstChar[B] [ 5s ] thds: 11 tps: 4.20 qps: 4.20 (r/w/o: 0.00/4.20/0.00) lat (ms,99%): 7.70 err/s: 1.40 reconn/s: 0.00 [ 10s ] thds: 11 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 15s ] thds: 11 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 11 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 25s ] thds: 11 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 11 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 35s ] thds: 11 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 11 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 45s ] thds: 11 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 11 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 55s ] thds: 11 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 11 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 65s ] thds: 11 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 11 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 75s ] thds: 11 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 11 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 85s ] thds: 11 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 11 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 95s ] thds: 11 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 11 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 105s ] thds: 11 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 11 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 115s ] thds: 11 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 120s ] thds: 11 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00 FATAL: PQexecPrepared() failed: 7 Lock wait timeout: thread 139759558256384 on node gaussdb waiting for ShareLock on transaction 3488722 after 120228.402 ms FATAL: `thread_run' function failed: /usr/local/share/sysbench/oltp_delete.lua:33: SQL error, errno = 0, state = 'YY003': Lock wait timeout: thread 139759558256384 on node gaussdb waiting for ShareLock on transaction 3488722 after 120228.402 ms sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3) Dropping table 'sbtest1'... ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected]
