Data Corruption Errors
От | Ferrell, Denise SDC |
---|---|
Тема | Data Corruption Errors |
Дата | |
Msg-id | 1538051973729.67553@sdc-world.com обсуждение исходный текст |
Ответ на | Re: Reversing pg_logical replication (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>) |
Ответы |
Re: Data Corruption Errors
Re: Data Corruption Errors |
Список | pgsql-admin |
Using Linux/PostgreSQL 9.5 & setup on a VM. I'm receiving the following errors during an insert using a function but this does not happen every time. When this doesoccur the database/system is unavailable until the processes are killed or the service is restarted. "LOG: server process (PID xxxxx) was terminated by signal 9: Killed DETAIL: Failed process was running select insert_data ($1, $2,....) WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because anotherserver process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect .... LOG: connection received FATAL: the database system is in recovery mode" The last 2 lines are repeated and logging is not available. How can I determine data/table/shared memory corruption? Thank you in advance for your responses. D. Ferrell
В списке pgsql-admin по дате отправления: