From: | nbuduroi(at)gmail(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #8515: Random 'relation "..." does not exist' |
Date: | 2013-10-09 17:35:11 |
Message-ID: | E1VTxfD-0005qx-MI@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: 8515
Logged by: Nicolas Buduroi
Email address: nbuduroi(at)gmail(dot)com
PostgreSQL version: 9.2.4
Operating system: ArchLinux
Description:
We've recently migrated an application from MySQL to Postgres and I've been
experiencing some really strange and random bugs. The application is a
pretty simple Rails application and the Postgres setup is the default one
provided by ArchLinux.
Basically, at some point a query, update or insert will not work and
complain about a table not existing, but that table was used without any
issue previously. Closing the running connection to the database and
reconnecting make that error disappear. Two concurrent connections (one from
a console and another from the app) could be contradicting themselves, one
giving the error and the other not.
This only happen on a development machine which is running version 9.2.4 of
Postgres. We've not encountered this error on our production/staging/ci
servers which are running Postgres 9.1.9 version.
From | Date | Subject | |
---|---|---|---|
Next Message | dwayne | 2013-10-09 20:58:46 | BUG #8516: Calling VOLATILE from STABLE function |
Previous Message | shahtejas2811 | 2013-10-09 16:24:38 | BUG #8514: cache lookup failed for relation 421062806 |