BUG #16932: Database Crash with : ERROR: cache lookup failed for type 0
От | PG Bug reporting form |
---|---|
Тема | BUG #16932: Database Crash with : ERROR: cache lookup failed for type 0 |
Дата | |
Msg-id | 16932-fc795566ddd4a5f1@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #16932: Database Crash with : ERROR: cache lookup failed for type 0
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 16932 Logged by: Vlad Email address: github@vlqubed.com PostgreSQL version: 10.11 Operating system: Windows Description: The database is running on Azure (postgres as a service) select version(): PostgreSQL 10.11, compiled by Visual C++ build 1800, 64-bit We have also seen this error on an 11.6 version of the database. We have a nightly process which builds a set of tables with static data for reporting purposes. Randomly, we see this error in the logs: 2021-03-18 07:52:32 UTC-6052fa73.12638-ERROR: cache lookup failed for type 0 ... then database crashes, then new log file: ... 2021-03-18 07:55:58 UTC-60530700.18-LOG: could not bind socket for statistics collector: A socket operation was attempted to an unreachable host. 2021-03-18 07:55:58 UTC-60530700.18-LOG: trying another address for the statistics collector 2021-03-18 07:55:59 UTC-6053078f.24-LOG: database system was interrupted; last known up at 2021-03-18 07:47:04 UTC 2021-03-18 07:56:00 UTC-6053078f.24-LOG: database system was not properly shut down; automatic recovery in progress Our process is as follows ( pseudo code simplified ): begin trans; call a procedure that drops and re-creates a table. commit; begin trans loop 1000 rows insert into table above.... end loop; commit; when the error occurs, it always occurs on inserting the first row into the new table; Re-running the above usually succeeds the second try.
В списке pgsql-bugs по дате отправления: