BUG #9430: Strange error during pg_dump with concurrent alter table working

From: maxim(dot)boguk(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #9430: Strange error during pg_dump with concurrent alter table working
Date: 2014-03-03 23:36:16
Message-ID: 20140303233616.1916.67689@wrigleys.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: 9430
Logged by: Maxim Boguk
Email address: maxim(dot)boguk(at)gmail(dot)com
PostgreSQL version: 9.2.7
Operating system: Linux
Description:

Hi,

Today during performing database schema migration, I got strange error from
concurrently working
pg_dump -F p -s:

pg_dump: [archiver (db)] query failed: ERROR: cache lookup failed for
constraint 18543
pg_dump: [archiver (db)] query was: SELECT tableoid, oid, conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc, conislocal, convalidated
FROM pg_catalog.pg_constraint WHERE conrelid = '26756'::pg_catalog.oid
AND contype = 'c' ORDER BY conname

This constraint was defined as:
[local]:5432 postgres(at)sports=# SELECT tableoid, oid, conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc, conislocal, convalidated
FROM pg_catalog.pg_constraint WHERE conrelid = '26756'::pg_catalog.oid
AND contype = 'c' ORDER BY conname;
-[ RECORD 1
]+--------------------------------------------------------------
tableoid | 2606
oid | 97238286
conname | fb_rate_account_sport_user_id_cookie_check
consrc | CHECK (((sport_user_id IS NOT NULL) OR (cookie IS NOT
NULL)))
conislocal | t
convalidated | t

Concurrent ALTER command:
/*65851105*/alter table stat.fb_rate_account alter column sport_user_id type
int8;

I will try create self-containing test case in few hours.

Kind Regards,
Maksym

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2014-03-03 23:52:42 Re: BUG #9416: Setting up postgresql-9.1 (9.1.12-0wheezy1) Fails Configuration
Previous Message Tomas Vondra 2014-03-03 23:02:22 Re: BUG #9416: Setting up postgresql-9.1 (9.1.12-0wheezy1) Fails Configuration