| From: | Emanuel Calvo <postgres(dot)arg(at)gmail(dot)com> |
|---|---|
| To: | pgsql-testers(at)postgresql(dot)org |
| Subject: | [PG 9.1 beta] Could not open relation |
| Date: | 2011-05-24 11:49:55 |
| Message-ID: | BANLkTi=i5p8Kv84k0hUSScQMwHMQmn8NkA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-testers |
I configured Sync servers just for a test, and sometimes it appears the
following error during a SELECT statement in the slave node:
ERROR: could not open relation with OID 16395
LINE 1: select * from prueba where i in (1,1000)
I have Ubuntu Linux dell-desktop 2.6.32-27-generic #49-Ubuntu SMP Wed
Dec 1 23:52:12 UTC 2010 i686 GNU/Linux
To replicate the error I'm executing a simple script:
bin/psql -p6666 -Upostgres -c 'DROP TABLE prueba; create table prueba
as select i, clock_timestamp() from generate_series(1,1000) i(i)'
for v in 6666 6667 ; do
bin/psql -p${v} -Upostgres -c 'select * from prueba where i in (1,1000)'
done
bin/psql -1 -p6666 -Upostgres << _QUERY_
BEGIN ;
DROP TABLE prueba;
SET synchronous_commit=local;
create table prueba (
ahora timestamp PRIMARY KEY,
ahorita timestamp
);
insert into prueba values (now(), clock_timestamp()) returning
ahora, ahorita;
insert into prueba values (clock_timestamp(), clock_timestamp())
returning ahora, ahorita;
select pg_sleep(1);
COMMIT;
_QUERY_
echo Prueba Async
for v in 6666 6667 ; do
bin/psql -p${v} -Upostgres -c 'select * from prueba'
done
I will enable logging_collector and try to reproduce the error with more output.
Regards,
--
--
Emanuel Calvo
Helpame.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Satpal Yadav | 2011-05-24 12:39:00 | Dear friends |
| Previous Message | Póka Balázs | 2011-05-12 23:20:11 | Re: PostGIS 1.5.2 Doesn't compile with PG 9.1Beta1 |