From: | Soni M <diptatapa(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error |
Date: | 2021-01-15 09:13:10 |
Message-ID: | CAAMgDXnH3dTxUK9C_v6pwL+qjumxHgSK6Diag6W4fTxKVTZ9Mw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2021-01-15 09:33:36 | Re: could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error |
Previous Message | Andrus | 2021-01-15 07:45:15 | REASSIGN OWNED BY in current database only |