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 |