pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feed From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: 1726002692@qq.com
Subject: BUG #16662: pgbench: error: client 418 script 0 aborted in command 5 query 0: ERROR: invalid page in block 4830
Date: Thu, 08 Oct 2020 15:49:58 +0000
Message-ID: <16662-3a8edb25b118fb28@postgresql.org> (raw )
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 |
view thread (3+ messages) latest in thread
Message-ID: <16662-3a8edb25b118fb28@postgresql.org>
Permalink: ../16662-3a8edb25b118fb28@postgresql.org/
Also on: postgresql.org/message-id/16662-3a8edb25b118fb28@postgresql.org
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, 1726002692@qq.com
Subject: Re: BUG #16662: pgbench: error: client 418 script 0 aborted in command 5 query 0: ERROR: invalid page in block 4830
In-Reply-To: <16662-3a8edb25b118fb28@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox