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 1kuCBM-0003IT-ML for pgsql-admin@arkaria.postgresql.org; Tue, 29 Dec 2020 10:24:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kuCBL-0004Rb-K7 for pgsql-admin@arkaria.postgresql.org; Tue, 29 Dec 2020 10:24:47 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kuCBK-0004RD-Tb for pgsql-admin@lists.postgresql.org; Tue, 29 Dec 2020 10:24:47 +0000 Received: from mailout1.med.uni-muenchen.de ([138.245.1.11]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kuCBG-00041I-Jd for pgsql-admin@lists.postgresql.org; Tue, 29 Dec 2020 10:24:45 +0000 From: "Dischner, Anton" DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=med.uni-muenchen.de; s=gw1201801; t=1609237479; bh=yO7l7kn3+6/tuVqDk/evXTrxDRm8EQjo6nD1YQAO6A8=; h=From:To:Subject:Date:References:In-Reply-To:From; b=UBQwtW5aqjxSPxBxySdK1Xlt3Jdqlp0NrNBUrRNOz0Veh7U/PByn1+qb+PhxP+NTb SEKMXPcDWZ3YXixC1MRy2wOkIs1r0bhNSyLPp5mzDnz1IBeRt5QO6aOGLi+/j2eNcR Lkf3hpU0nykYWK+dleuxvuU2ZUTeZ8sIFFgWczkM= To: 'Sreejith P' , Rohit Rajput , "pgsql-admin@lists.postgresql.org" Subject: AW: Insert 1 million data Thread-Topic: Insert 1 million data Thread-Index: AQHW3bOo8PV3wAGf1EibbGMV4NQqk6oNnmkAgAAnJwCAABhEYA== Date: Tue, 29 Dec 2020 10:24:38 +0000 Message-ID: References: <744185788.4252348.1609227376678@mail.yahoo.com> In-Reply-To: Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [172.17.13.18] Content-Type: multipart/alternative; boundary="_000_d8f44b82a02a4fccab75377c05d490dbMITMB5heliosmedunimuenc_" MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_000_d8f44b82a02a4fccab75377c05d490dbMITMB5heliosmedunimuenc_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, try a watch df -h while you are running your job to see how filesystem space decreases over t= ime regards, Anton Von: Sreejith P Gesendet: Dienstag, 29. Dezember 2020 10:56 An: Rohit Rajput ; pgsql-admin@lists.postgresql.org Betreff: Re: Insert 1 million data Thanks Rohit. After upgrading volume getting following error. Almost same as previous one= . We have increased backup volume and run the Job Again . When I reach 900 th= ousand records, getting almost similar error again. - Do I need to turn off auto vaccum ? - Shall increase maintance work mem ? 2020-12-23 01:16:14.335 +04 [18450] DETAIL: Failed process was running: aut= ovacuum: ANALYZE public.lt_encounter 2020-12-23 01:16:14.343 +04 [18450] LO= G: terminating any other active server processes 2020-12-23 01:16:14.344 +0= 4 [18455] WARNING: terminating connection because of crash of another serve= r process 2020-12-23 01:16:14.344 +04 [18455] DETAIL: The postmaster has co= mmanded this server process to roll back the current transaction and exit, = because another server process exited abnormally and possibly corrupted sha= red memory. 2020-12-23 01:16:14.344 +04 [18455] HINT: In a moment you should be able to= reconnect to the database and repeat your command. 2020-12-23 01:16:14.356 +04 [31155] rptDBA@Ast-ReportDB WARNING: terminatin= g connection because of crash of another server process 2020-12-23 01:16:14.356 +04 [31155] rptDBA@Ast-ReportDB DETAIL: The postmas= ter has commanded this server process to roll back the current transaction = and exit, because another server process exited abnormally and possibly cor= rupted shared memory. 2020-12-23 01:16:14.356 +04 [31155] rptDBA@Ast-ReportDB HINT: In a moment y= ou should be able to reconnect to the database and repeat your command. 2020-12-23 01:16:14.356 +04 [31155] rptDBA@Ast-ReportDB CONTEXT: SQL statem= ent "INSERT INTO lt_encounter( encounter_id, customer_id, customer_name, si= te_id, site_territory, site_cluster, site_emirates, site_long_name, site_sh= ort_name, encounter_date, encounter_created_on, enounter_no, patient_mpi, p= atient_name, pateint_nationality, patient_nationality_id, patient_gender, p= ateint_age, encounter_visit_purpose, encounter_payer_type, encounter_end_da= te, is_parent_encounter, parent_encounter_no, encounter_type_id, encounter_= status_id, parent_encounter_id, primary_encounter_id,patient_email, patient= _passport,patient_address,mobile_number ) SELECT e.encounter_id, e.customer= _id, e.customer_name, e.site_id, e.site_territory, e.site_cluster, e.site_e= mirates, e.site_name, e.site_alias, e.encounter_date, e.encounter_created_o= n, e.encounter_no, e.mpi, TRIM(REGEXP_REPLACE(e.patient_name, '\s+', ' ', '= g')), e.nationality, e.nationality_id, e.patient_gender, e.patient_age, e.v= isit_purpose, e.payer_type, e.encounter_end_date, e.is_parent_encounter, e.= parent_encounter_no, e.encounter_type_id, e.encounter_status_id, e.parent_e= ncounter_id, e.primary_encounter_id,e.email, e.passport,e.address,e.mobile_= no FROM JSON_TO_RECORDSET(_encounters) AS e ( "encounter_id" BIGINT, "custo= mer_id" INT, "customer_name" VARCHAR, "site_id" INT, "site_territory" VARCH= AR, "site_cluster" VARCHAR, "site_emirates" VARCHAR, "site_name" VARCHAR, "= site_alias" VARCHAR, "encounter_date" TIMESTAMP(0), "encounter_created_on" = TIMESTAMP(0), "encounter_no" VARCHAR, "mpi" VARCHAR, "patient_name" VARCHAR= , "nationality" VARCHAR, "nationality_id" VARCHAR, "patient_gender" VARCHAR= , "patient_age" VARCHAR, "visit_purpose" VARCHAR, "payer_type" VARCHAR, "en= counter_end_date" TIMESTAMP(0), "is_parent_encounter" BOOLEAN, "parent_enco= unter_no" VARCHAR, "encounter_type_id" INT, "encounter_status_id" INT, "par= ent_encounter_id" BIGINT, "primary_encounter_id" BIGINT,"email" varchar, "p= assport" varchar,"address" varchar,"mobile_no" varchar ) ON CONFLICT ON CON= STRAINT lt_encounter_pkey DO UPDATE SET ( last_updated_on, customer_id, cus= tomer_name, site_id, site_territory, site_cluster, site_emirates, site_long= _name, site_short_name, encounter_date, encounter_created_on, enounter_no, = patient_mpi, patient_name, pateint_nationality, patient_nationality_id, pat= ient_gender, pateint_age, encounter_visit_purpose, encounter_payer_type, en= counter_end_date, is_parent_encounter, parent_encounter_no, encounter_type_= id, encounter_status_id, parent_encounter_id, primary_encounter_id,patient_= email, patient_passport,patient_address,mobile_number ) =3D ( clock_timesta= mp()::TIMESTAMP(0), EXCLUDED.customer_id, EXCLUDED.customer_name, EXCLUDED.= site_id, EXCLUDED.site_territory, EXCLUDED.site_cluster, EXCLUDED.site_emir= ates, EXCLUDED.site_long_name, EXCLUDED.site_short_name, EXCLUDED.encounter= _date, EXCLUDED.encounter_created_on, EXCLUDED.enounter_no, EXCLUDED.patien= t_mpi, EXCLUDED.patient_name, EXCLUDED.pateint_nationality, EXCLUDED.patien= t_nationality_id, EXCLUDED.patient_gender, EXCLUDED.pateint_age, EXCLUDED.e= ncounter_visit_purpose, EXCLUDED.encounter_payer_type, EXCLUDED.encounter_e= nd_date, EXCLUDED.is_parent_encounter, EXCLUDED.parent_encounter_no, EXCLUD= ED.encounter_type_id, EXCLUDED.encounter_status_id, EXCLUDED.parent_encount= er_id, EXCLUDED.primary_encounter_id,EXCLUDED.patient_email, EXCLUDED.patie= nt_passport,EXCLUDED.patient_address,EXCLUDED.mobile_number )" PL/pgSQL fun= ction lt_insert_update_encounters(json) line 21 at SQL statement 2020-12-23 01:16:14.570 +04 [18450] LOG: all server processes terminated; r= einitializing 2020-12-23 01:16:14.826 +04 [31201] LOG: database system was = interrupted; last known up at 2020-12-23 01:12:30 +04 2020-12-23 01:16:14.9= 32 +04 [31201] LOG: database system was not properly shut down; automatic r= ecovery in progress 2020-12-23 01:16:14.937 +04 [31201] LOG: redo starts at= 5C/2DC41798 2020-12-23 01:16:22.302 +04 [31201] LOG: invalid record length= at 5C/6FD96D10: wanted 24, got 0 2020-12-23 01:16:22.302 +04 [31201] LOG: = redo done at 5C/6FD96CD8 2020-12-23 01:16:22.302 +04 [31201] LOG: last comp= leted transaction was at log time 2020-12-23 01:15:14.852692+04 2020-12-23 = 01:16:32.813 +04 [18450] LOG: database system is ready to accept connection= s 2020-12-23 01:26:00.119 +04 [31209] rptDBA@Ast-ReportDB LOG: could not re= ceive data from client: Connection reset by peer 2020-12-24 01:14:27.047 +0= 4 [18450] LOG: server process (PID 8936) was terminated by signal 9: Killed= 2020-12-24 01:14:27.047 +04 [18450] DETAIL: Failed process was running: au= tovacuum: ANALYZE public.lt_encounter 2020-12-24 01:14:27.148 +04 [18450] L= OG: terminating any other active server processes 2020-12-24 01:14:27.149 += 04 [31206] WARNING: terminating connection because of crash of another serv= er process 2020-12-24 01:14:27.149 +04 [31206] DETAIL: The postmaster has c= ommanded this server process to roll back the current transaction and exit,= because another server process exited abnormally and possibly corrupted sh= ared memory. 2020-12-24 01:14:27.149 +04 [31206] HINT: In a moment you shou= ld be able to reconnect to the database and repeat your command. 2020-12-24= 01:14:27.162 +04 [8929] rptDBA@Ast-ReportDB WARNING: terminating connectio= n because of crash of another server process 2020-12-24 01:14:27.162 +04 [8= 929] rptDBA@Ast-ReportDB DETAIL: The postmaster has commanded this server p= rocess to roll back the current transaction and exit, because another serve= r process exited abnormally and possibly corrupted shared memory. 2020-12-2= 4 01:14:27.162 +04 [8929] rptDBA@Ast-ReportDB HINT: In a moment you should = be able to reconnect to the database and repeat your command. From: Rohit Rajput Date: Tuesday, 29 December 2020 at 1:06 PM To: "pgsql-admin@lists.postgresql.org" , = Sreejith P Subject: Re: Insert 1 million data 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 whe= re you have placed your WAL files. On Tuesday, 29 December, 2020, 12:55:01 pm IST, Sreejith P wrote: Getting below error while running a background job for inserting 1 Million = records. Can I get some help ? cp: error writing '/BackupVolume/hisDbBackup/WALs/0000000200000AE6000000B9'= : No space left on device 2020-12-17 21:55:26 +04 [55822]: user=3D,db=3D,app=3D,client=3D LOG: archi= ve command failed with exit code 1 2020-12-17 21:55:26 +04 [55822]: user=3D,db=3D,app=3D,client=3D DETAIL: Th= e failed archive command was: test ! -f /BackupVolume/dbWALBack/WALs/000000= 0200000AE6000000B9 && cp pg_wal/0000000200000AE6000000B9 /BackupVolume/hisD= bBackup/WALs/0000000200000AE6000000B9 2020-12-17 21:53:56 +04 [84225]: user=3DAstDBA,db=3DAST-PROD,app=3D[unknown= ],client=3D172.18.200.100 HINT: In a moment you should be able to reconnec= t to the database and repeat your command. 2020-12-17 21:53:56 +04 [51102]: user=3DAstDBA,db=3DAST-PROD,app=3D[unknown= ],client=3D172.18.200.100 WARNING: terminating connection because of crash= of another server process 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 ser= ver process exited abnormally and possibly corrupted shared memory. 2020-12-17 21:55:20 +04 [55808]: user=3Dreplicator,db=3D[unknown],app=3D[un= known],client=3D172.18.200.144 FATAL: the database system is in recovery m= ode 2020-12-17 21:55:25 +04 [55828]: user=3Dreplicator,db=3D[unknown],app=3Dwal= receiver,client=3D172.18.200.148 ERROR: requested starting point AEA/A2000= 000 is ahead of the WAL flush position of this server AEA/A1FFFA50 2020-12-17 21:55:25 +04 [55827]: user=3Dreplicator,db=3D[unknown],app=3Dwal= receiver,client=3D172.18.200.147 ERROR: requested starting point AEA/A2000= 000 is ahead of the WAL flush position of this server AEA/A1FFFA50 2020-12-17 21:55:25 +04 [55829]: user=3Dreplicator,db=3D[unknown],app=3Dwal= receiver,client=3D172.18.200.145 ERROR: requested starting point AEA/A2000= 000 is ahead of the WAL flush position of this server AEA/A1FFFA50 2020-12-17 21:55:25 +04 [55830]: user=3Dreplicator,db=3D[unknown],app=3Dwal= receiver,client=3D172.18.200.146 ERROR: requested starting point AEA/A2000= 000 is ahead of the WAL flush position of this server AEA/A1FFFA50 2020-12-17 21:55:25 +04 [55831]: user=3Dreplicator,db=3D[unknown],app=3Dwal= receiver,client=3D172.18.200.144 ERROR: requested starting point AEA/A2000= 000 is ahead of the WAL flush position of this server AEA/A1FFFA50 Thanks Sreejith Error! Filename not specified. [Image removed by sender.] 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. [https://www.lifetrenz.com/lt-logo.png] 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. --_000_d8f44b82a02a4fccab75377c05d490dbMITMB5heliosmedunimuenc_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

 

try a

 

watch df -h

 

while you are running your job to see how filesystem space decreases o= ver time

 

regards,

 

Anton

&nbs= p;

Von: Sreejith P <sreejith@lifetrenz.com>= ;
Gesendet: Dienstag, 29. Dezember 2020 10:56
An: Rohit Rajput <rht.rajput@yahoo.com>; pgsql-admin@lists.pos= tgresql.org
Betreff: Re: Insert 1 million data

 

Thanks Rohit.

 

After upgrading volume getting following error. Almost same as previo= us one.

 

We have i= ncreased backup volume and run the Job Again . When I reach 900 thousand re= cords,  getting almost similar error again. 

 

-D= o I need to turn off auto vaccum ?

-S= hall increase maintance work mem ?

 

 

2020-12-23 01:16:14.335 += ;04 [18450] DETAIL: Failed process was running: autovacuum: ANALYZE public.lt_encounter 2020-12-23 01:16:14.343 = +04 [18450] LOG: terminating any other active server processes 2020-12-= 23 01:16:14.344 +04 [18455] WARNING: terminating connection because of crash of another server process 2020-12-23 01:16:14.= 344 +04 [18455] DETAIL: The postmaster has commanded this server proces= s to roll back the current transaction and exit, because another server pro= cess exited abnormally and possibly corrupted shared memory. 

2020-12-23 01:16:14.344 += ;04 [18455] HINT: In a moment you should be able to reconnect to the databa= se and repeat your command. 

2020-12-23 01:16:14.356 += ;04 [31155] rptDBA@Ast-ReportDB WARNING: terminating connection because of = crash of another server process 

2020-12-23 01:16:14.356 += ;04 [31155] rptDBA@Ast-ReportDB DETAIL: The postmaster has commanded this s= erver process to roll back the current transaction and exit, because another server process exited abnormally and possibly co= rrupted shared memory. 

2020-12-23 01:16:14.356 += ;04 [31155] rptDBA@Ast-ReportDB HINT: In a moment you should be able to rec= onnect to the database and repeat your command.

 

 

2020-12-23 01:16:14.356 += ;04 [31155] rptDBA@Ast-ReportDB CONTEXT: SQL statement "INSERT INTO lt= _encounter( encounter_id, customer_id, customer_name, site_id, site_territory, site_cluster, site_emirates, site_long_name, site= _short_name, encounter_date, encounter_created_on, enounter_no, patient_mpi= , patient_name, pateint_nationality, patient_nationality_id, patient_gender= , pateint_age, encounter_visit_purpose, encounter_payer_type, encounter_end_date, is_parent_encounter, parent_enco= unter_no, encounter_type_id, encounter_status_id, parent_encounter_id, prim= ary_encounter_id,patient_email, patient_passport,patient_address,mobile_num= ber ) SELECT e.encounter_id, e.customer_id, e.customer_name, e.site_id, e.site_territory, e.site_cluster, e.site_emira= tes, e.site_name, e.site_alias, e.encounter_date, e.encounter_created_on, e= .encounter_no, e.mpi, TRIM(REGEXP_REPLACE(e.patient_name, '\s+', ' ', '= g')), e.nationality, e.nationality_id, e.patient_gender, e.patient_age, e.visit_purpose, e.payer_type, e.encounte= r_end_date, e.is_parent_encounter, e.parent_encounter_no, e.encounter_type_= id, e.encounter_status_id, e.parent_encounter_id, e.primary_encounter_id,e.= email, e.passport,e.address,e.mobile_no FROM JSON_TO_RECORDSET(_encounters) AS e ( "encounter_id" BIGINT= , "customer_id" INT, "customer_name" VARCHAR, "sit= e_id" INT, "site_territory" VARCHAR, "site_cluster"= ; VARCHAR, "site_emirates" VARCHAR, "site_name" VARCHAR= , "site_alias" VARCHAR, "encounter_date" TIMESTAMP(0), "encounter_created_on" TIMESTAMP(0), "encount= er_no" VARCHAR, "mpi" VARCHAR, "patient_name" VARC= HAR, "nationality" VARCHAR, "nationality_id" VARCHAR, &= quot;patient_gender" VARCHAR, "patient_age" VARCHAR, "v= isit_purpose" VARCHAR, "payer_type" VARCHAR, "encounter_end_date" TIMESTAMP(0), "is_parent_encounter&quo= t; BOOLEAN, "parent_encounter_no" VARCHAR, "encounter_type_i= d" INT, "encounter_status_id" INT, "parent_encounter_id= " BIGINT, "primary_encounter_id" BIGINT,"email" va= rchar, "passport" varchar,"address" varchar,"mobil= e_no" varchar ) ON CONFLICT ON CONSTRAINT lt_encounter_pkey DO UPDATE SET ( last= _updated_on, customer_id, customer_name, site_id, site_territory, site_clus= ter, site_emirates, site_long_name, site_short_name, encounter_date, encoun= ter_created_on, enounter_no, patient_mpi, patient_name, pateint_nationality, patient_nationality_id, patient_gender,= pateint_age, encounter_visit_purpose, encounter_payer_type, encounter_end_= date, is_parent_encounter, parent_encounter_no, encounter_type_id, encounte= r_status_id, parent_encounter_id, primary_encounter_id,patient_email, patient_passport,patient_address,mobil= e_number ) =3D ( clock_timestamp()::TIMESTAMP(0), EXCLUDED.customer_id, EXC= LUDED.customer_name, EXCLUDED.site_id, EXCLUDED.site_territory, EXCLUDED.si= te_cluster, EXCLUDED.site_emirates, EXCLUDED.site_long_name, EXCLUDED.site_short_name, EXCLUDED.encounter_date= , EXCLUDED.encounter_created_on, EXCLUDED.enounter_no, EXCLUDED.patient_mpi= , EXCLUDED.patient_name, EXCLUDED.pateint_nationality, EXCLUDED.patient_nat= ionality_id, EXCLUDED.patient_gender, EXCLUDED.pateint_age, EXCLUDED.encounter_visit_purpose, EXCLUDED.encounter= _payer_type, EXCLUDED.encounter_end_date, EXCLUDED.is_parent_encounter, EXC= LUDED.parent_encounter_no, EXCLUDED.encounter_type_id, EXCLUDED.encounter_s= tatus_id, EXCLUDED.parent_encounter_id, EXCLUDED.primary_encounter_id,EXCLUDED.patient_email, EXCLUDED.patient_pas= sport,EXCLUDED.patient_address,EXCLUDED.mobile_number )" PL/pgSQL func= tion lt_insert_update_encounters(json) line 21 at SQL statement 

 

2020-12-23 01:16:14.570 += ;04 [18450] LOG: all server processes terminated; reinitializing 2020-12-23= 01:16:14.826 +04 [31201] LOG: database system was interrupted; last known up at 2020-12-23 01:12:30 +04 2020-12-23 0= 1:16:14.932 +04 [31201] LOG: database system was not properly shut down= ; automatic recovery in progress 2020-12-23 01:16:14.937 +04 [31201] LO= G: redo starts at 5C/2DC41798 2020-12-23 01:16:22.302 +04 [31201] LOG: invalid record length at 5C/6FD96D10: wanted 24, got = 0 2020-12-23 01:16:22.302 +04 [31201] LOG: redo done at 5C/6FD96CD8 202= 0-12-23 01:16:22.302 +04 [31201] LOG: last completed transaction was at= log time 2020-12-23 01:15:14.852692+04 2020-12-23 01:16:32.813 +04 [18450] LOG: database system is ready to accept conne= ctions 2020-12-23 01:26:00.119 +04 [31209] rptDBA@Ast-ReportDB LOG: cou= ld not receive data from client: Connection reset by peer 2020-12-24 01:14:= 27.047 +04 [18450] LOG: server process (PID 8936) was terminated by signal 9: Killed 2020-12-24 01:14:27.047 +04 [= 18450] DETAIL: Failed process was running: autovacuum: ANALYZE public.lt_en= counter 2020-12-24 01:14:27.148 +04 [18450] LOG: terminating any other = active server processes 2020-12-24 01:14:27.149 +04 [31206] WARNING: terminating connection because of crash of anothe= r server process 2020-12-24 01:14:27.149 +04 [31206] DETAIL: The postma= ster has commanded this server process to roll back the current transaction= and exit, because another server process exited abnormally and possibly corrupted shared memory. 2020-12-24 01:14:2= 7.149 +04 [31206] HINT: In a moment you should be able to reconnect to = the database and repeat your command. 2020-12-24 01:14:27.162 +04 [8929= ] rptDBA@Ast-ReportDB WARNING: terminating connection because of crash of another server process 2020-12-24 01:14:27.= 162 +04 [8929] rptDBA@Ast-ReportDB 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 memory. 2020-12-24 01:14:27.162 +04 [892= 9] rptDBA@Ast-ReportDB HINT: In a moment you should be able to reconnect to= the database and repeat your command.

 

From: Rohi= t Rajput <rht.rajput@yahoo.com>
Date: Tuesday, 29 December 2020 at 1:06 PM
To: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lis= ts.postgresql.org>, Sreejith P <sreejith@lifetrenz.com>
Subject: Re: Insert 1 million data

 

If you look at error, it clearly says th= at your WAL directory is full when you are loading your data. You should ge= t more space added to your disk where you have placed your WAL files.

 

On Tuesday, 29 December, 2= 020, 12:55:01 pm IST, Sreejith P <sreejith@lifetrenz.com> wrote:

 

 

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

 

Can I get some help ?

 

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

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

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

 

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

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

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 proc= ess exited abnormally and possibly corrupted shared memory.

 

 

2020-12-17 21:55:20 += 04 [55808]: user=3Dreplicator,db=3D[unknown],app=3D[unknown],client=3D172.1= 8.200.144 FATAL:  the database system is in recovery mode<= span lang=3D"EN-IN" style=3D"font-size:10.0pt;font-family:"Helvetica N= eue";color:#26282A">

 

 

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/A1FFFA50

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/A1FFFA50

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/A1FFFA50

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/A1FFFA50

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/A1FFFA50

 

Thanks

Sreejith

 

 

 

Error! Filename not specified.

3D"Image 

Solutions for Care Anywhere

dWise HealthCare IT Solutions Pvt. Ltd= . | www.lifetrenz.com Disclaimer: The information and attachments contained in this email are intended for exclusive use of the addressee(s) and may contain confide= ntial or privileged information. If you are not the intended recipient, ple= ase notify the sender immediately and destroy all copies of this message an= d any attachments. The views expressed in this email are, unless otherwise stated, those of the author and not th= ose of dWise HealthCare IT Solutions or its management.

 

 

Solutions f= or Care Anywhere

dWise HealthCare IT= Solutions Pvt. Ltd. | www.lifetrenz.com Disclaimer: The information and attachments contained in this email are intended for exclusive use of the addressee(s) and may contain confide= ntial or privileged information. If you are not the intended recipient, ple= ase notify the sender immediately and destroy all copies of this message an= d any attachments. The views expressed in this email are, unless otherwise stated, those of the author and not th= ose of dWise HealthCare IT Solutions or its management.

--_000_d8f44b82a02a4fccab75377c05d490dbMITMB5heliosmedunimuenc_--