Postgres PANIC when it could not open file in pg_logical/snapshots directory

Поиск
Список
Период
Сортировка
От Mike Yeap
Тема Postgres PANIC when it could not open file in pg_logical/snapshots directory
Дата
Msg-id CAMVYW_4QhjZ-19Xpr2x1B19soRCNu1BXHM8g1mOnAVtd5VViDw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Postgres PANIC when it could not open file in pg_logical/snapshots directory  (Vijaykumar Jain <vijaykumarjain.github@gmail.com>)
Re: Postgres PANIC when it could not open file in pg_logical/snapshots directory  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-general
Hi all,

I have a Postgres version 11.11 configured with both physical replication slots (for repmgr) as well as some logical replication slots (for AWS Database Migration Service (DMS)). This morning, the server went panic with the following messages found in the log file:

2021-06-22 04:56:35.314 +08 [PID=19457 application="[unknown]" user_name=dms database=** host(port)=**(48360)] PANIC:  could not open file "pg_logical/snapshots/969-FD606138.snap": Operation not permitted

2021-06-22 04:56:35.317 +08 [PID=1752 application="" user_name= database= host(port)=] LOG:  server process (PID 19457) was terminated by signal 6: Aborted

2021-06-22 04:56:35.317 +08 [PID=1752 application="" user_name= database= host(port)=] LOG:  terminating any other active server processes


The PG server then terminates all existing PG processes.

The process with 19457 is from one of the DMS replication tasks, I have no clue why it suddenly couldn't open a snapshot file. I checked the server load and file systems and didn't find anything unusual at that time.

Appreciate if you can give me some guidance on troubleshooting this issue

Thanks

Regards,
Mike Yeap

В списке pgsql-general по дате отправления:

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: cpu-intensive immutable function and parallel scan
Следующее
От: Nicolas Seinlet
Дата:
Сообщение: second CTE kills perf