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 обсуждение исходный текст |
Ответы |
Re: BUG #16662: pgbench: error: client 418 script 0 aborted in command 5 query 0: ERROR: invalid page in block 4830
|
Список | pgsql-bugs |
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 по дате отправления: