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 |
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 |