RE: WAL Master error - Mailing list pgsql-admin

From Ahmed, Nawaz
Subject RE: WAL Master error
Date
Msg-id BAAE097528E6CB4FB2BE65AEFA6EEE0495432B73@SYD1217
Whole thread Raw
In response to WAL Master error  (arvind chikne <arvind.chikne@gmail.com>)
List pgsql-admin

I think you are missing some of the commit logs from pg_clog directories or have been wiped off. I ran into that issue ages ago but I can’t recollect what I did to bring the database back up.

 

Just touching the files under that directory is not the solution, although it may/may not work. But I believe, you may have to reset logs (or even force reset logs), which can sometimes cause loss of data.

 

 

Best Regards,

 

Nawaz Ahmed
Software Development Engineer

Fujitsu Australia Software Technology Pty Ltd

14 Rodborough Road, Frenchs Forest NSW 2086, Australia
T +61 2 9452 9027
Nawaz@fast.au.fujitsu.com
fastware.com.au


 

From: arvind chikne [mailto:arvind.chikne@gmail.com]
Sent: Monday, 15 October 2018 6:10 PM
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: WAL Master error

 

Hi All, 

 

I am getting the following error while restarting the master server

 

2018-10-15 12:34:49 IST [32747-1] LOG:  database system was interrupted; last known up at 2018-10-15 12:34:37 IST

2018-10-15 12:34:49 IST [32748-1] [unknown]@[unknown] LOG:  incomplete startup packet

2018-10-15 12:34:49 IST [32747-2] LOG:  database system was not properly shut down; automatic recovery in progress

2018-10-15 12:34:50 IST [32747-3] LOG:  invalid record length at 7A/3E000338

2018-10-15 12:34:50 IST [32747-4] LOG:  redo is not required

2018-10-15 12:34:50 IST [32751-1] postgres@postgres FATAL:  the database system is starting up

2018-10-15 12:34:50 IST [32747-5] FATAL:  could not access status of transaction 385464

2018-10-15 12:34:50 IST [32747-6] DETAIL:  Could not read from file "pg_clog/0000" at offset 90112: Success.

2018-10-15 12:34:50 IST [32746-1] LOG:  startup process (PID 32747) exited with exit code 1

2018-10-15 12:34:50 IST [32746-2] LOG:  aborting startup due to startup process failure

 

 

--

Thanks & Regards
Arvind rao chikne

9818979986

Think Green!!! Please consider your environmental responsibility before printing this e-mail

 

Disclaimer

The information in this e-mail is confidential and may contain content that is subject to copyright and/or is commercial-in-confidence and is intended only for the use of the above named addressee. If you are not the intended recipient, you are hereby notified that dissemination, copying or use of the information is strictly prohibited. If you have received this e-mail in error, please telephone Fujitsu Australia Software Technology Pty Ltd on + 61 2 9452 9000 or by reply e-mail to the sender and delete the document and all copies thereof.

Whereas Fujitsu Australia Software Technology Pty Ltd would not knowingly transmit a virus within an email communication, it is the receiver’s responsibility to scan all communication and any files attached for computer viruses and other defects. Fujitsu Australia Software Technology Pty Ltd does not accept liability for any loss or damage (whether direct, indirect, consequential or economic) however caused, and whether by negligence or otherwise, which may result directly or indirectly from this communication or any files attached.

If you do not wish to receive commercial and/or marketing email messages from Fujitsu Australia Software Technology Pty Ltd, please email unsubscribe@fast.au.fujitsu.com

Attachment

pgsql-admin by date:

Previous
From: arvind chikne
Date:
Subject: WAL Master error
Next
From: Pierre Ochsenbein
Date:
Subject: pgpool versus which tool?