Online backup cause boot failure, anyone know why?
in [PgSql]
|
Prev: Earn more for a more satisfactory life. agonizing adelocodonic affrighted
Next: Online backup cause boot failure,anyone know why?
From: Andrew Dunstan on 5 Aug 2010 09:40 On 08/05/2010 09:19 AM, Richard wrote: > I want to create a database backup when PG is running, so I call pg_start_backup(''), scp the data to a backup directory, pg_stop_backup. > Then I reboot PG , PG boot failed with log like "unexpected pageaddr X/X in log file X, segment X, offset X" "WAL ends before end time of backup dump". > Then I check the failure XLOG file, found the error page contains a pageaddr 8K before it should be, and the failure XLOG record a ONLINE CHECKPONT with 60 bytes in former page, the other 4 bytes missing. > > Any one met this before? Please help me! > > This question really belongs on the pgsql-general list, not the -hackers list. If all you copied was the data directory then you haven't done this right anyway. See <http://www.postgresql.org/docs/8.3/static/continuous-archiving.html#BACKUP-TIPS> Why did you reboot postgres after taking your backup? cheers andrew -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: "Richard" on 5 Aug 2010 10:13 Thanks for replying. But I could not find any relation between the RequestXLogSwitch function and the error I met. For perfromance purpose , I change the pg_start_backup checkpoint type from CHECKPOINT_WAIT to CHECKPOINT_IMMEDIATE, does it matter? ------------------ Richard 2010-08-05 ------------------------------------------------------------- �����ˣ�Tom Lane �������ڣ�2010-08-05 22:04:30 �ռ��ˣ�Richard ���ͣ�pgsql-hackers ���⣺Re: [HACKERS] Online backup cause boot failure, anyone know why? "Richard" <husttripper(a)vip.sina.com> writes: > PS : I am using PG 8.3.7 I believe there's a related bug fix in 8.3.8. BTW, -hackers is not the place for this type of question. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: "Richard" on 5 Aug 2010 10:54 I am sorry, my English is poor. I was confused by what you said. What do you mean by saying "that'd break it"! ------------------ Richard 2010-08-05 ------------------------------------------------------------- �����ˣ�Tom Lane �������ڣ�2010-08-05 22:44:50 �ռ��ˣ�Richard ���ͣ�pgsql-hackers ���⣺Re: [HACKERS] Online backup cause boot failure, anyone know why? "Richard" <husttripper(a)vip.sina.com> writes: > For perfromance purpose , I change the pg_start_backup checkpoint type from CHECKPOINT_WAIT to CHECKPOINT_IMMEDIATE, does it matter? Oh, so this isn't so much "8.3.7" as "randomly-hacked-up 8.3.7". Yes, that'd break it, I believe. CHECKPOINT_IMMEDIATE doesn't imply waiting. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: "=?utf-8?B?UmljaGFyZA==?=" on 5 Aug 2010 11:50 Sorry, wrong word, it should be job. You mean the wrong type of checkpoint causes XLOG file recovery fail? I was confused, the XLOG files seem corrupted, is it also caused by the checkpoint type? If so , why it can do this? ------------------ Richard 2010-08-05 ------------------------------------------------------------- 发件人：Nicolas Barbier 发送日期：2010-08-05 23:43:22 收件人：Richard 抄送：Heikki Linnakangas; Tom Lane; pgsql-hackers 主题：Re: [HACKERS] Online backup cause boot failure, anyone know why? 2010/8/5 Richard <husttripper(a)vip.sina.com>: > All jods are done by client code, not manually. What is a jod? > I still did't not understand what you said. > What break what? The fact that you replaced CHECKPOINT_WAIT with CHECKPOINT_IMMEDIATE is the cause of your problem. You "broke" the correctness of the system by doing so. Nicolas -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: "=?utf-8?B?UmljaGFyZA==?=" on 5 Aug 2010 09:50
I reboot PG because I found PG recovery end point if far away from the actual end point of the XLOG on the backup directory, so I want to test if the original DB is OK. Unfortunately, I got the same PG log on the original DB. I don't unstand what you said, I missing what? ------------------ Richard 2010-08-05 ------------------------------------------------------------- 发件人：Andrew Dunstan 发送日期：2010-08-05 21:40:13 收件人：Richard 抄送：pgsql-hackers 主题：Re: [HACKERS] Online backup cause boot failure, anyone know why? On 08/05/2010 09:19 AM, Richard wrote: > I want to create a database backup when PG is running, so I call pg_start_backup(''), scp the data to a backup directory, pg_stop_backup. > Then I reboot PG , PG boot failed with log like "unexpected pageaddr X/X in log file X, segment X, offset X" "WAL ends before end time of backup dump". > Then I check the failure XLOG file, found the error page contains a pageaddr 8K before it should be, and the failure XLOG record a ONLINE CHECKPONT with 60 bytes in former page, the other 4 bytes missing. > > Any one met this before? Please help me! > > This question really belongs on the pgsql-general list, not the -hackers list. If all you copied was the data directory then you haven't done this right anyway. See <http://www.postgresql.org/docs/8.3/static/continuous-archiving.html#BACKUP-TIPS> Why did you reboot postgres after taking your backup? cheers andrew -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers |