BUG #16662: pgbench: error: client 418 script 0 aborted in command 5 query 0: ERROR: invalid page in block 4830

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: 1726002692(at)qq(dot)com
Subject: BUG #16662: pgbench: error: client 418 script 0 aborted in command 5 query 0: ERROR: invalid page in block 4830
Date: 2020-10-08 15:49:58
Message-ID: 16662-3a8edb25b118fb28@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 16662
Logged by: 强 魏
Email address: 1726002692(at)qq(dot)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 |

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2020-10-08 17:30:10 Re: BUG #16661: Changing columns after the rule is created leads to an error when the RETURNING is used
Previous Message Tom Lane 2020-10-08 15:28:53 Re: WIDTH_BUCKET inconsistency