Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ku9Ya-0006LY-IE for pgsql-admin@arkaria.postgresql.org; Tue, 29 Dec 2020 07:36:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ku9YZ-0004O7-4Z for pgsql-admin@arkaria.postgresql.org; Tue, 29 Dec 2020 07:36:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ku9YY-0004O0-B6 for pgsql-admin@lists.postgresql.org; Tue, 29 Dec 2020 07:36:34 +0000 Received: from sonic306-19.consmr.mail.sg3.yahoo.com ([106.10.241.139]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ku9YQ-00009q-I2 for pgsql-admin@lists.postgresql.org; Tue, 29 Dec 2020 07:36:33 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1609227380; bh=1Y+We8VJ/nTWRoF/Jp594QB1Xyiu9h9BjSfM7PUZWmk=; h=Date:From:To:In-Reply-To:References:Subject:From:Subject; b=bKwa8ZbCnTHuKehDo/R6iZirhoE0OAFAG/oPVqbB1CbzfBWJiAIG3TWU67evenN6yeaQunfXIMGcm9HVGTPuvtdzQPP0GYz14fgC3DQj+/QBZsMyuTEKtqJK1c+f1iYmu3H9TP5hl1CSXeRMcRWBCI3sgLRSvuMYeOxRSvpfoGZt+rZbYQ69mhpKjLdg8+umUj11FSnKS2YHjtdATIrjNKnKr5bBxc5+MsAUsuatawn0EirMR7wPqx6bUOCmga5zen6Gh0baQR4O9eI9QGwZfwP9d00UacDKcjGDNmxMaycJCEDZ82AUYy3z+3lazY9xFu1yhE/CvLshgtd/+AYFgQ== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1609227380; bh=mpCNjhJZwT4VC2HzFBIRKBtYlRyKm+hXUhaO35njLSn=; h=Date:From:To:Subject:From:Subject; b=VqMrEJLR7CtLG79GAlPF+rYd4ee0jxF69G7m12e66jpW9SE5Jog39SwBhjs7iUUcA9+U1XrtoL83QImJbwQ/eQQ7MQtMnmpRhgz9ioCd4E4YaY+oWsIiqfDVBOI6l5bd53Q4mDB7jhHV0zYZlkccNPem3AgXd0XrTUyZCEuLiU/LpV14XBmQsCTlnF0qlcInjBo54Jf8qEX6YDpgaN6WemOgTaOpNKaEaEc0rJlIU2XcFXA0Oot4L+BDtblcv0Z+NYztsWx52GgE9xd7RJtXOL/qn4lCZl0sAyHXKUqjoqtL8/TUOpvRkpULlwY/oHUneQRErm6Jnn3z8EdOjBwHVw== X-YMail-OSG: TlRbRpsVM1lFcrWSUuMXQu2.fdzDka2hDxvqfs_DVhNuWNT1hpIoAncT9_L4u38 SpDoRkZFw5GobUcB1DrSZmSFNhjJSZWRPAXA5PX0No1rlF9c0RMt.UpBF.k_q2wXygV1lRVuxFih KbmFonqv7asEwA_kKEr6HtEj.I8gyidPSu9GxSRia5xZSQc4OmCIt1aWX2U40aq2l2BnGD6qttBh TIfe1g4hjLzHhfzgoqYW.n8o624Z2z2MhDfZS6j.6mo.pz7BMgXIAVaY_vHIMLsPgv6C3KgG8evp fCcgSqi0fDRc03ZFbndOuDKIuvi3FSAorTvAVna4SzU7QF8tqoqIvUJZNoHfB1nzWwXZ8yXFtmT3 McHCq0M3lOjjn2hJwuBZmTjygFeO4T.Im0Eyws8Sifg_8hTDq_5ltmHwU02wPmg1FBAimp7IbHXw wgT8xIIAs76cwE5P.S6Xxk0IVWrcb5iV14U7b4omyjS1g7LkICkV7WCF5KXHf7bbwnQzb2XV9aOZ aKoCKHQ.FCJr4hotX0QgTE7poNkMrq1isCU2DAFw4xRYzh2iqRIKUNLvRkmE.cmtzqkTin_zX9Gu 0Ef8w9rTCpWBrmNhtnDRa5q8J.9hv0tK7rCUxB8N.rUNdD8NoCacQ3.7vrky5zJ9LSbdP4bYKsSb RHEWzdlUdCBYzcH85A24wPcYhUxplyi3X_.6m4TdU0nj1SgVEO8w0.izJzOVyiNvj88akWI6o51s Zt9XogVm7bFKMzfeZKSPwB7LnntUVJ.kAf_37xFzHzNomp0MrkqTR3z1yPU7xO2ZskW02uClkuLs 4QmMhkjZqbU5WOh8xD9kCaVC5AzyGC4WrjlPPiF87Re4xY.iqkuvM75EO5s15WHBtdmMHFYoIsgD .za._tNos42xNc1Pj4vm_Eu27ImftjCgtq9Izqzk6jzs2f78fhSn2s7vm0i5d0X5RUf92qR.PuxP ROYdt4jD6q2DyZyPfG4oC6mPCArBFsypM8E.nbe27sqcr1XOBpMdFktttX0uv5G5uk37Ev.Ju9zn mXjhT_Vwa8_9WKXmac5p3dWqSzum0NUkDPN9UAzxKVphyCMUJJtdnPNhCHCSW8sfrrtwjmAwC5Me iB6zWnNA9NGVK28VDIu4aH.uHYbtNKBeQGK67uiRpdPirGjrH6KQ.qCtcmZu5GW0CoA0.Gb8.GFG N7_mkA96wUJngyKeG3qNSRJ7VCADMB6dSkOj1ECaUjE_.nTDRW.qI5PW6HXvvYrf5Ijq1KghidOl Rl4JEBGmAmTmCr0BtcYvfbJxexR2F7r.HTH29gDQyzP5gB2_bGj3JXQ1A5SyGJLssLlpzUJ1PK75 5zUYtiBelmXGyTiBR7AIgKgdO43eAJ1V2axm4Yt3mPaZUstDwOKsBEG7O6vldhH776EG.8bDQ0t6 DwTBBpXyyTEkieGrba9M4H13DN_jOnQe6UGe1Fevat7Th5bZTPGO_oVahejR6BY.35j25pbTtylW hEPHFPhQIzGcfmNGOzfA7vsTowXQT5sQMSLCLL0R3g_pHxpXlquAr3fdsrX4uuVVpvB7_wUiGVcY YJgROWuaz4YiyvQv9McPt5cjrZoDWWoTriiwjUuxQr5MxmpKRTIZTC9IdhUSDQrbgUwjwzdaSGk. _r.vVG1GtkYgntC0GYi5Z6GCiHJIc.N8xOHDejr5aS4_4iUwP.XgyhSDeV2wS4L3GlgghkPFgN6x 8BeqfcnaEZNhlsntM2R3wuENQ.oMXzRohtabG4IuANcYxzD4TZPi6iTtODntfs_sGGX3wIUbQnyB Vb1AUklJW.HJtQGY4Dnk36naz9INclCUGcz1Z1V3rDtX9CAPypYQWbiSzYp8wZZY8Kcdvyo0KMu4 cIhKXyljXqENxcajAgER7qYTqbzd16BxoImm2q5A0CHQ.Rivwnih8B241wW8B7yLyzgdw0N4wE75 5TsOZZytrpU5GnMWf5WwvxrEooHErEkEmZC7.hN7hC8B_oiGsfbi7FKg2h1VAHh3h4rT514eVyZJ Ck_B0kTIugFpDl4eoII8IMzOR8yNTaWQ9bfmQYtZtgDuMXsEmjdCvlAuLb7xkOvYpPxpF5a6SF2B fZ4crV9joxp.k8C0O8zpvFi62s6V.R6oXWHWc14TXByeqJKwe3L..nsWDp9F93wyIGyZj7aO6bEr mJjnvo.oR5.SioKre2zjgwBXFeZcheyoSSdlmAAmaYXvtkmTTrbBxO95EyY.PRqh17ehH7Po4yK9 A2A_faCBHtplu5Sya03HVf6pI5rw08O7eIVHwdstn.z4ZPJ_NhYUoM1FlkcuV7jKPOdqwhLVg7lU sFNmz2UU.PyZRT9eD5DlWswWIml5f1w3CMTJxGZls8YXd.fCNntZQuAjOO7k1g4WQDCQBpCiG14A XUCQA0HeCM9YD1ky8Ov_onuoXc2EBhy4nlEQaxKGwe8RbOOBiPGe53jtHPWAwd2OExyp7iiXdpsA 2DLu.QvwjBUUCjMULh9kGpwz.MXVOjemagQjrZg1uG7CdTuTXj1jJMQ-- Received: from sonic.gate.mail.ne1.yahoo.com by sonic306.consmr.mail.sg3.yahoo.com with HTTP; Tue, 29 Dec 2020 07:36:20 +0000 Date: Tue, 29 Dec 2020 07:36:16 +0000 (UTC) From: Rohit Rajput To: "pgsql-admin@lists.postgresql.org" , Sreejith P Message-ID: <744185788.4252348.1609227376678@mail.yahoo.com> In-Reply-To: References: Subject: Re: Insert 1 million data MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_4252347_1164519282.1609227376676" X-Mailer: WebService/1.1.17278 YMailNorrin Mozilla/5.0 (Macintosh; Intel Mac OS X 11_1_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36 Content-Length: 13625 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_4252347_1164519282.1609227376676 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable If you look at error, it clearly says that your WAL directory is full when= you are loading your data. You should get more space added to your disk wh= ere you have placed your WAL files. On Tuesday, 29 December, 2020, 12:55:01 pm IST, Sreejith P wrote: =20 =20 Getting below error while running a background job for inserting 1 Million = records. =20 =C2=A0 =20 Can I get some help ? =20 =C2=A0 =20 cp: error writing '/BackupVolume/hisDbBackup/WALs/0000000200000AE6000000B9'= : No space left on device =20 2020-12-17 21:55:26 +04 [55822]: user=3D,db=3D,app=3D,client=3D LOG:=C2=A0= =C2=A0archive command=C2=A0failed=C2=A0with exit code 1 =20 2020-12-17 21:55:26 +04 [55822]: user=3D,db=3D,app=3D,client=3D DETAIL:=C2= =A0=C2=A0The=C2=A0failed=C2=A0archive command was: test ! -f /BackupVolume/= dbWALBack/WALs/0000000200000AE6000000B9 && cp pg_wal/0000000200000AE6000000= B9 /BackupVolume/hisDbBackup/WALs/0000000200000AE6000000B9 =20 =C2=A0 =20 2020-12-17 21:53:56 +04 [84225]: user=3DAstDBA,db=3DAST-PROD,app=3D[unknown= ],client=3D172.18.200.100 HINT:=C2=A0=C2=A0In a moment you should be able t= o reconnect to the database and repeat your command. =20 2020-12-17 21:53:56 +04 [51102]: user=3DAstDBA,db=3DAST-PROD,app=3D[unknown= ],client=3D172.18.200.100 WARNING:=C2=A0=C2=A0terminating connection becaus= e of crash of another server process =20 2020-12-17 21:53:56 +04 [51102]: user=3DAstDBA,db=3DAST-PROD,app=3D[unknown= ],client=3D172.18.200.100 DETAIL:=C2=A0=C2=A0The postmaster has commanded t= his server process to roll back the current transaction and exit, because a= nother server process exited abnormally and possibly corrupted shared memor= y. =20 =C2=A0 =20 =C2=A0 =20 2020-12-17 21:55:20 +04 [55808]: user=3Dreplicator,db=3D[unknown],app=3D[un= known],client=3D172.18.200.144 FATAL:=C2=A0=C2=A0the database system is in = recovery mode =20 =C2=A0 =20 =C2=A0 =20 2020-12-17 21:55:25 +04 [55828]: user=3Dreplicator,db=3D[unknown],app=3Dwal= receiver,client=3D172.18.200.148 ERROR:=C2=A0=C2=A0requested starting point= AEA/A2000000 is ahead of the WAL flush position of this server AEA/A1FFFA5= 0 =20 2020-12-17 21:55:25 +04 [55827]: user=3Dreplicator,db=3D[unknown],app=3Dwal= receiver,client=3D172.18.200.147 ERROR:=C2=A0=C2=A0requested starting point= AEA/A2000000 is ahead of the WAL flush position of this server AEA/A1FFFA5= 0 =20 2020-12-17 21:55:25 +04 [55829]: user=3Dreplicator,db=3D[unknown],app=3Dwal= receiver,client=3D172.18.200.145 ERROR:=C2=A0=C2=A0requested starting point= AEA/A2000000 is ahead of the WAL flush position of this server AEA/A1FFFA5= 0 =20 2020-12-17 21:55:25 +04 [55830]: user=3Dreplicator,db=3D[unknown],app=3Dwal= receiver,client=3D172.18.200.146 ERROR:=C2=A0=C2=A0requested starting point= AEA/A2000000 is ahead of the WAL flush position of this server AEA/A1FFFA5= 0 =20 2020-12-17 21:55:25 +04 [55831]: user=3Dreplicator,db=3D[unknown],app=3Dwal= receiver,client=3D172.18.200.144 ERROR:=C2=A0=C2=A0requested starting point= AEA/A2000000 is ahead of the WAL flush position of this server AEA/A1FFFA5= 0 =20 =C2=A0 =20 Thanks =20 Sreejith =20 =C2=A0 =20 =C2=A0 =20 =C2=A0 Solutions for Care Anywhere dWise HealthCare IT Solutions Pvt. Ltd. | www.lifetrenz.com Disclaimer: The information and attachments contained in this email are int= ended for exclusive use of the addressee(s) and may contain confidential or= privileged information. If you are not the intended recipient, please noti= fy the sender immediately and destroy all copies of this message and any at= tachments. The views expressed in this email are, unless otherwise stated, = those of the author and not those of dWise HealthCare IT Solutions or its m= anagement. =20 ------=_Part_4252347_1164519282.1609227376676 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
If you look at error, it cle= arly says that your WAL directory is full when you are loading your data. Y= ou should get more space added to your disk where you have placed your WAL = files.

=20
=20
On Tuesday, 29 December, 2020, 12:55:01 pm IST, Sreejit= h P <sreejith@lifetrenz.com> wrote:


=20 =20

Getting below error while running a background job= for inserting 1 Million records.

=20

 

=20

Can I get some help ?

=20

 

=20

cp: error writing '/BackupVolume/hisDbBackup/WALs/= 0000000200000AE6000000B9': No space left on device

=20

2020-12-17 21:55:26 +04 [55822]: user=3D,db=3D,app= =3D,client=3D LOG:  archive command failed with exit co= de 1

=20

2020-12-17 21:55:26 +04 [55822]: user=3D,db=3D,app= =3D,client=3D DETAIL:  The failed archive command was: = test ! -f /BackupVolume/dbWALBack/WALs/0000000200000AE6000000B9 && cp pg_wal/0000000200000AE6000000B9 /BackupVolume/hisDbBackup/WA= Ls/0000000200000AE6000000B9

=20

 

=20

2020-12-17 21:53:56 +04 [84225]: user=3DAstDBA,db= =3DAST-PROD,app=3D[unknown],client=3D172.18.200.100 HINT:  In a m= oment you should be able to reconnect to the database and repeat your command.

=20

2020-12-17 21:53:56 +04 [51102]: user=3DAstDBA,db= =3DAST-PROD,app=3D[unknown],client=3D172.18.200.100 WARNING:  ter= minating connection because of crash of another server process

=20

2020-12-17 21:53:56 +04 [51102]: user=3DAstDBA,db= =3DAST-PROD,app=3D[unknown],client=3D172.18.200.100 DETAIL:  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 mem= ory.

=20

 

=20

 

=20

2020-12-17 21:55:20 +04 [55808]: user=3Dreplicator= ,db=3D[unknown],app=3D[unknown],client=3D172.18.200.144 FATAL:  t= he database system is in recovery mode

=20

 

=20

 

=20

2020-12-17 21:55:25 +04 [55828]: user=3Dreplicator= ,db=3D[unknown],app=3Dwalreceiver,client=3D172.18.200.148 ERROR:  = ;requested starting point AEA/A2000000 is ahead of the WAL flush position of this server AEA/A1FFFA5= 0

=20

2020-12-17 21:55:25 +04 [55827]: user=3Dreplicator= ,db=3D[unknown],app=3Dwalreceiver,client=3D172.18.200.147 ERROR:  = ;requested starting point AEA/A2000000 is ahead of the WAL flush position of this server AEA/A1FFFA5= 0

=20

2020-12-17 21:55:25 +04 [55829]: user=3Dreplicator= ,db=3D[unknown],app=3Dwalreceiver,client=3D172.18.200.145 ERROR:  = ;requested starting point AEA/A2000000 is ahead of the WAL flush position of this server AEA/A1FFFA5= 0

=20

2020-12-17 21:55:25 +04 [55830]: user=3Dreplicator= ,db=3D[unknown],app=3Dwalreceiver,client=3D172.18.200.146 ERROR:  = ;requested starting point AEA/A2000000 is ahead of the WAL flush position of this server AEA/A1FFFA5= 0

=20

2020-12-17 21:55:25 +04 [55831]: user=3Dreplicator= ,db=3D[unknown],app=3Dwalreceiver,client=3D172.18.200.144 ERROR:  = ;requested starting point AEA/A2000000 is ahead of the WAL flush position of this server AEA/A1FFFA5= 0

=20

 

=20

Thanks

=20

Sreejith

=20

&nbs= p;

=20

&nbs= p;

=20

 

Soluti= ons for Care Anywhere

dWise HealthCare IT Solutions Pvt= . Ltd. | www.lifetrenz.com
Discl= aimer: The information and attachments contained in this email are intended=20 for exclusive use of the addressee(s) and may contain confidential or=20 privileged information. If you are not the intended recipient, please=20 notify the sender immediately and destroy all copies of this message and any attachments. The views expressed in this email are, unless=20 otherwise stated, those of the author and not those of dWise HealthCare IT = Solutions or its management.
------=_Part_4252347_1164519282.1609227376676--