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

 · 

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