| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Michael Paquier <michael(at)paquier(dot)xyz> |
| Cc: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: pgsql: Add pg_relation_check_pages() to check on-disk pages of a relati |
| Date: | 2020-10-28 04:26:29 |
| Message-ID: | 1226629.1603859189@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Michael Paquier <michael(at)paquier(dot)xyz> writes:
> Add pg_relation_check_pages() to check on-disk pages of a relation
Seems to have some issues according to florican:
2020-10-28 00:04:40.336 EDT [27040:3] 022_page_check.pl LOG: statement: SELECT relname, failed_block_num FROM (SELECT relname, (pg_catalog.pg_relation_check_pages(oid)).* FROM pg_class WHERE relkind in ('r','i', 'm') AND oid >= 16384) AS s
2020-10-28 00:04:53.191 EDT [27031:4] LOG: server process (PID 27040) was terminated by signal 11: Segmentation fault
2020-10-28 00:04:53.191 EDT [27031:5] DETAIL: Failed process was running: SELECT relname, failed_block_num FROM (SELECT relname, (pg_catalog.pg_relation_check_pages(oid)).* FROM pg_class WHERE relkind in ('r','i', 'm') AND oid >= 16384) AS s
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2020-10-28 04:41:01 | Re: pgsql: Add pg_relation_check_pages() to check on-disk pages of a relati |
| Previous Message | Michael Paquier | 2020-10-28 03:15:53 | pgsql: Add pg_relation_check_pages() to check on-disk pages of a relati |