BUG #4669: pg_dump reports error about multiple rows

From: "Vitaly Lopatin" <vitaly(dot)lopatin(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4669: pg_dump reports error about multiple rows
Date: 2009-02-20 18:47:29
Message-ID: 200902201847.n1KIlTCS087705@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4669
Logged by: Vitaly Lopatin
Email address: vitaly(dot)lopatin(at)gmail(dot)com
PostgreSQL version: 8.3.6
Operating system: Red Hat Enterprise Linux 5.2
Description: pg_dump reports error about multiple rows
Details:

1. In start I used 8.3.1. Once, I got error:
ERROR: database is not accepting commands to avoid wraparound data loss in
database "ppcs_ts"
HINT: Stop the postmaster and use a standalone backend to vacuum database
"ppcs_ts".

2. I'd stopped postgresql and upgrade to 8.3.6

3. I've started postgres in stanalone mode and run 'vacuum full'.

4. I've started postgres in standart mode without any errors.

5. I've run pg_dump and I've got:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: more than one row returned by a
subquery used as an expression
pg_dump: The command was: SELECT tableoid, oid, typname, typnamespace,
(SELECT rolname FROM pg_catalog.pg_roles WHERE oid = typowner) as rolname,
typinput
::oid as typinput, typoutput::oid as typoutput, typelem, typrelid, CASE WHEN
typrelid = 0 THEN ' '::"char" ELSE (SELECT relkind FROM pg_class WHERE oid
=
typrelid) END as typrelkind, typtype, typisdefined, typname[0] = '_' AND
typelem != 0 AND (SELECT typarray FROM pg_type te WHERE oid =
pg_type.typelem) =
oid AS isarray FROM pg_type

6. I run this query
ppcs_ts=# select oid,count(*) from pg_class group by oid having count(*) >
1;
oid | count
-------+-------
23744 | 2
(1 row)

and this query

ppcs_ts=# select ctid,xmin,xmax,cmin,cmax,oid,* from pg_class where
oid=23744;
ctid | xmin | xmax | cmin | cmax | oid |
relname | relnamespace | reltype | relowner | relam | relfilenode |
reltablespace | relpages | reltuples | reltoastrelid | reltoastidxid |
relhasindex | relisshared | relkind | relnatts | relchecks | reltriggers |
relukeys | relfkeys | relrefs | relhasoids | relhaspkey | relhasrules |
relhassubclass | relfrozenxid | relacl | reloptions
----------+------------+------+------------+------------+-------+-----------
--------------+--------------+---------+----------+-------+-------------+---
------------+----------+-----------+---------------+---------------+--------
-----+-------------+---------+----------+-----------+-------------+---------
-+----------+---------+------------+------------+-------------+-------------
---+--------------+--------+------------
(253,51) | 1713217376 | 0 | 6 | 6 | 23744 |
ppcsc_ip_clicks_analyze | 16394 | 23746 | 16391 | 0 |
121017126 | 0 | 1 | 2 | 0 |
0 | t | f | r | 2 | 0 |
1 | 0 | 0 | 0 | f | t | f |
f | 1713217349 | |
(237,3) | 1650691925 | 0 | 1672983373 | 1672983373 | 23744 |
ppcsc_ip_clicks_analyze | 16394 | 23746 | 16391 | 0 |
119761918 | 0 | 1 | 1 | 0 |
0 | t | f | r | 2 | 0 |
1 | 0 | 0 | 0 | f | t | f |
f | 1650691905 | |
(2 rows)

How I can to fix this problem?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2009-02-20 19:41:52 Re: BUG #4669: pg_dump reports error about multiple rows
Previous Message Prachi 2009-02-20 18:07:34 BUG #4668: Windows installer package