BUG #16662: pgbench: error: client 418 script 0 aborted in command 5 query 0: ERROR: invalid page in block 4830
От
PG Bug reporting form
Тема
BUG #16662: pgbench: error: client 418 script 0 aborted in command 5 query 0: ERROR: invalid page in block 4830
Дата
Msg-id
16662-3a8edb25b118fb28@postgresql.org
Список
Дерево обсуждения
BUG #16662: pgbench: error: client 418 script 0 aborted in command 5 query 0: ERROR: invalid page in block 4830 PG Bug reporting form <noreply@postgresql.org>
Re: BUG #16662: pgbench: error: client 418 script 0 aborted in command 5 query 0: ERROR: invalid page in block 4830 Michael Paquier <michael@paquier.xyz>
Re: BUG #16662: pgbench: error: client 418 script 0 aborted in command 5 query 0: ERROR: invalid page in block 4830 "两个孩子的爹" <1726002692@qq.com>
The following bug has been logged on the website: Bug reference: 16662 Logged by: 强 魏 Email address: 1726002692@qq.com PostgreSQL version: 13.0 Operating system: CentOS 7 X86_64 Description: During the pressure test using pgbench, the following error occurred, but the object with oid=16396 was queried through pg_class, and it did not exist. Is this a bug? pgbench -c 512 -j 8 -M simple -P 2 -T 600 -n ...... WARNING: page verification failed, calculated checksum 22845 but expected 3622 pgbench: error: client 418 script 0 aborted in command 5 query 0: ERROR: invalid page in block 48309 of relation base/14103/16396 progress: 74.0 s, 3145.2 tps, lat 159.570 ms stddev 91.381 progress: 76.0 s, 3247.4 tps, lat 154.893 ms stddev 87.175 progress: 78.0 s, 3327.4 tps, lat 151.347 ms stddev 90.210 progress: 80.0 s, 3461.3 tps, lat 146.127 ms stddev 80.133 progress: 82.0 s, 3375.2 tps, lat 149.019 ms stddev 84.425 WARNING: page verification failed, calculated checksum 22570 but expected 38935 pgbench: error: client 359 script 0 aborted in command 5 query 0: ERROR: invalid page in block 48183 of relation base/14103/16396 WARNING: page verification failed, calculated checksum 22845 but expected 3622 pgbench: error: client 66 script 0 aborted in command 5 query 0: ERROR: invalid page in block 48309 of relation base/14103/16396 progress: 84.0 s, 3379.2 tps, lat 148.318 ms stddev 94.854 progress: 86.0 s, 3541.5 tps, lat 131.812 ms stddev 82.052 ....... Object information in the database: postgres=# select * from pg_class where oid=16396; (0 rows) postgres=# select * from pg_database; -[ RECORD 1 ]-+------------------------------------ oid | 14103 datname | postgres datdba | 10 encoding | 6 datcollate | zh_CN.UTF-8 datctype | zh_CN.UTF-8 datistemplate | f datallowconn | t datconnlimit | -1 datlastsysoid | 14102 datfrozenxid | 478 datminmxid | 1 dattablespace | 1663 datacl |
В списке pgsql-bugs по дате отправления
От: Tom Lane
Дата: