From: | aaaaaa <abcxiaod(at)126(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | problem in regard to hot standby |
Date: | 2019-01-16 14:36:50 |
Message-ID: | 2d78399f.9472.1685717e4ba.Coremail.abcxiaod@126.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all,
I have encounted the problem with the hot standby, The master node was suddenly powered off,meanwhile,both two standby node had shut down end printed logs as followed:
PG version:9.6.8
2019-01-13 09:35:42.831 CST,,,28904,,5c332ceb.70e8,5,,2019-01-07 18:41:47 CST,,0,LOG,00000,"replication terminated by primary server","End of WAL reached on timeline 3 at 1/D49ADFF0.",,,,,,,"WalReceiverMain,walreceiver.c:456",""
2019-01-13 09:35:42.831 CST,,,28904,,5c332ceb.70e8,6,,2019-01-07 18:41:47 CST,,0,FATAL,XX000,"could not send end-of-streaming message to primary:no COPY in progress",,,,,,,,"libpqrcv_endstreaming,libpqwalreceiver.c:282",""
2019-01-13 09:35:42.876 CST,,,28904,,5c332ceb.70e8,7,,2019-01-07 18:41:47 CST,1/0,0,FATAL,XX000,"invalid memory alloc request size 1701675008",,,,,,,,"palloc_extended,mcxt.c:961",""
2019-01-13 09:35:42.945 CST,,,28771,,5c332ceb.7063,3,,2019-01-07 18:41:47 CST,,0,LOG,00000,"startup process(PID 28883) exited with exit code 1",,,,,,,,"LogChildExit,postmaster.c:3552",""
2019-01-13 09:35:42.945 CST,,,28771,,5c332ceb.7063,4,,2019-01-07 18:41:47 CST,,0,LOG,00000,"terminating any other active server processes",,,,,,,,"HandleChildCrash,postmaster.c:3294",""
2019-01-13 09:35:43.119 CST,,,28771,,5c332ceb.7063,5,,2019-01-07 18:41:47 CST,,0,LOG,00000,"database system is shut down",,,,,,,,"UnlinkLockFiles,miscinit.c:755",""
Can anyone please tell me why standby nodes shut down and what i suppose to do make the cluster back to normal again?
Regards
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Gierth | 2019-01-16 15:55:21 | Re: Weird behaviour of ROLLUP/GROUPING |
Previous Message | Pavel Stehule | 2019-01-16 13:15:01 | Re: Weird behaviour of ROLLUP/GROUPING |