PGError: ERROR: could not open relation with OID?
| От | Jay Levitt |
|---|---|
| Тема | PGError: ERROR: could not open relation with OID? |
| Дата | |
| Msg-id | 4ECD5D04.4000001@gmail.com обсуждение исходный текст |
| Список | pgsql-general |
Running Postgresql 9.0.5 on Ubuntu 10.10, we just saw: PGError: ERROR: could not open relation with OID 39008 SELECT questions.*, r.relevance as score, r.explanation as explanation FROM "questions" INNER JOIN "users" ON "users"."id" = "questions"."user_id" JOIN relevance(13218) AS r ON questions.id = r.question_id WHERE (questions.user_id != 467) AND (questions.user_id != 13218) ORDER BY r.relevance DESC LIMIT 10 OFFSET 0 This same query run manually from psql doesn't yield any error, so it must have been a transitive thing. We use no explicit locking statements, we weren't creating or dropping tables and haven't in the past week or so, and we have no replication, sharding or partitioning set up - it's pretty much a stock single-machine install, save for the typical postgresql.conf RAM tweaking. Our volume is fairly low, the tables are fairly small, we have complete logs. How can I troubleshoot to see what might have happened? Or is this a known bug in 9.0.5? Jay Levitt
В списке pgsql-general по дате отправления: