You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/05/27 06:05:47 UTC
[GitHub] [shardingsphere] TeslaCN commented on issue #10273: FATAL occurred while sysbenching PostgreSQL Proxy
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:
users@infra.apache.org