could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error

Поиск
Список
Период
Сортировка
От Soni M
Тема could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error
Дата
Msg-id CAAMgDXnH3dTxUK9C_v6pwL+qjumxHgSK6Diag6W4fTxKVTZ9Mw@mail.gmail.com
обсуждение исходный текст
Ответы Re: could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-general
Hi All,
Postgres 11 on RHEL 7.9
We filled out the wal archive disk, and then those messages appear

2021-01-15 01:18:47.284 CST,"replicator","consprod",3510,"[local]",5fdebf22.db6,21,"SELECT",2020-12-19 21:04:02 CST,35/46792889,437317854,PANIC,58030,"could not fsync file ""pg_wal/xlogtemp.3510"": Input/output error",,,,,,"select ""_consprod_replication"".forwardConfirm(2, 3, '6233786669', '2021-01-15 00:32:32.828355-06'); ",,,"slon.remoteWorkerThread_2"
2021-01-15 01:18:47.508 CST,,,2461,,5fdebf20.99d,23,,2020-12-19 21:04:00 CST,,0,LOG,00000,"server process (PID 3510) was terminated by signal 6: Aborted","Failed process was running: select ""_consprod_replication"".forwardConfirm(2, 3, '6233786669', '2021-01-15 00:32:32.828355-06'); ",,,,,,,,""
2021-01-15 01:18:47.508 CST,,,2461,,5fdebf20.99d,24,,2020-12-19 21:04:00 CST,,0,LOG,00000,"terminating any other active server processes",,,,,,,,,""
2021-01-15 01:18:47.508 CST,"monitoring","consprod",14606,"10.2.5.12:48018",6001416d.390e,3,"SELECT",2021-01-15 01:17:01 CST,122/339910,0,WARNING,57P02,"terminating connection because of crash of another server process","The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.","In a moment you should be able to reconnect to the database and repeat your command.",,,,,,,"psql"


And now I cannot start postgres 

2021-01-15 03:04:19.972 CST,,,23229,,6001550d.5abd,6,,2021-01-15 02:40:45 CST,,0,PANIC,58030,"could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error",,,,,,,,,""2021-01-15 03:04:19.979 CST,,,23226,,6001550d.5aba,2,,2021-01-15 02:40:45 CST,,0,LOG,00000,"startup process (PID 23229) was terminated by signal 6: Aborted",,,,,,,,,""
2021-01-15 03:04:19.979 CST,,,23226,,6001550d.5aba,3,,2021-01-15 02:40:45 CST,,0,LOG,00000,"aborting startup due to startup process failure",,,,,,,,,""
2021-01-15 03:04:20.041 CST,,,23226,,6001550d.5aba,4,,2021-01-15 02:40:45 CST,,0,LOG,00000,"database system is shut down",,,,,,,,,""

Any idea to solve this ?

--
Regards,

Soni Maula Harriz

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

Предыдущее
От: Andrus
Дата:
Сообщение: REASSIGN OWNED BY in current database only
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error