Error in log file after database crash - Mailing list pgsql-general

From Rob Cowell
Subject Error in log file after database crash
Date
Msg-id AM4PR0201MB155595436B522D8223CBA7BB9F700@AM4PR0201MB1555.eurprd02.prod.outlook.com
Whole thread Raw
Responses Re: Error in log file after database crash
List pgsql-general
Hi,

One of my test databases "crashed" over the weekend after one of the sysadmin's in the team shut down the systemd
containerbefore stopping the database. 
My question is, how bad is this :)

Some background :
I have an application that uses Postgres as it's database.
Both the application, and postgres will be upgraded to newer versions in the coming weeks.
As part of a test-run I've upgraded the application to ensure that works, before I upgrade the database.
The application is undergoing some UAT testing prior to having the database upgraded.
Currently I'm running 9.1.10, and will be upgrading to the latest release of 9.3.x (not my choice of version, but the
applicationcurrently doesn't support 9.5.x) 

I've taken a full file-system backup of the database directories (with the database shut down), and a pg_dumpall.
Having restarted the database everything seems okay until the logs start showing these errors :


[2016-05-05 20:08:55 UTC]    LOCATION:  AbortBufferIO, bufmgr.c:2799
[2016-05-05 20:08:56 UTC]    ERROR:  XX000: xlog flush request 36D0/E8301358 is not satisfied --- flushed only to
36CA/94E12DC0
[2016-05-05 20:08:56 UTC]    CONTEXT:  writing block 0 of relation pg_tblspc/16395/PG_9.1_201105231/16400/33044487_vm
[2016-05-05 20:08:56 UTC]    LOCATION:  XLogFlush, xlog.c:2171
[2016-05-05 20:08:56 UTC]    WARNING:  58030: could not write block 0 of
pg_tblspc/16395/PG_9.1_201105231/16400/33044487_vm
[2016-05-05 20:08:56 UTC]    DETAIL:  Multiple failures --- write error might be permanent.
[2016-05-05 20:08:56 UTC]    LOCATION:  AbortBufferIO, bufmgr.c:2799
[2016-05-05 20:08:57 UTC]    ERROR:  XX000: xlog flush request 36D0/E8301358 is not satisfied --- flushed only to
36CA/94E12DC0
[2016-05-05 20:08:57 UTC]    CONTEXT:  writing block 0 of relation pg_tblspc/16395/PG_9.1_201105231/16400/33044487_vm
[2016-05-05 20:08:57 UTC]    LOCATION:  XLogFlush, xlog.c:2171
[2016-05-05 20:08:57 UTC]    WARNING:  58030: could not write block 0 of
pg_tblspc/16395/PG_9.1_201105231/16400/33044487_vm
[2016-05-05 20:08:57 UTC]    DETAIL:  Multiple failures --- write error might be permanent.
[2016-05-05 20:08:57 UTC]    LOCATION:  AbortBufferIO, bufmgr.c:2799
[2016-05-05 20:08:58 UTC]    ERROR:  XX000: xlog flush request 36D0/E8301358 is not satisfied --- flushed only to
36CA/94E12DC0
[2016-05-05 20:08:58 UTC]    CONTEXT:  writing block 0 of relation pg_tblspc/16395/PG_9.1_201105231/16400/33044487_vm
[2016-05-05 20:08:58 UTC]    LOCATION:  XLogFlush, xlog.c:2171
[2016-05-05 20:08:58 UTC]    WARNING:  58030: could not write block 0 of
pg_tblspc/16395/PG_9.1_201105231/16400/33044487_vm
[2016-05-05 20:08:58 UTC]    DETAIL:  Multiple failures --- write error might be permanent.
[2016-05-05 20:08:58 UTC]    LOCATION:  AbortBufferIO, bufmgr.c:2799
[2016-05-05 20:08:59 UTC]    ERROR:  XX000: xlog flush request 36D0/E8301358 is not satisfied --- flushed only to
36CA/94E12DC0
[2016-05-05 20:08:59 UTC]    CONTEXT:  writing block 0 of relation pg_tblspc/16395/PG_9.1_201105231/16400/33044487_vm
[2016-05-05 20:08:59 UTC]    LOCATION:  XLogFlush, xlog.c:2171
[2016-05-05 20:08:59 UTC]    WARNING:  58030: could not write block 0 of
pg_tblspc/16395/PG_9.1_201105231/16400/33044487_vm
[2016-05-05 20:08:59 UTC]    DETAIL:  Multiple failures --- write error might be permanent.
[2016-05-05 20:08:59 UTC]    LOCATION:  AbortBufferIO, bufmgr.c:2799
[2016-05-05 20:09:00 UTC]    ERROR:  XX000: xlog flush request 36D0/E8301358 is not satisfied --- flushed only to
36CA/94E12DC0
[2016-05-05 20:09:00 UTC]    CONTEXT:  writing block 0 of relation pg_tblspc/16395/PG_9.1_201105231/16400/33044487_vm
[2016-05-05 20:09:00 UTC]    LOCATION:  XLogFlush, xlog.c:2171
[2016-05-05 20:09:00 UTC]    WARNING:  58030: could not write block 0 of
pg_tblspc/16395/PG_9.1_201105231/16400/33044487_vm
[2016-05-05 20:09:00 UTC]    DETAIL:  Multiple failures --- write error might be permanent.
[2016-05-05 20:09:00 UTC]    LOCATION:  AbortBufferIO, bufmgr.c:2799

Cheers,
Rob.


pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Create index concurrently hanging with big table on pgsql 9.3.12
Next
From: Melvin Davidson
Date:
Subject: Re: Create index concurrently hanging with big table on pgsql 9.3.12