Postgres Pro
Downloads
Home   >   mailing lists

Re: Insert 1 million data - Mailing list pgsql-admin

From Rohit Rajput
Subject Re: Insert 1 million data
Date
Msg-id 744185788.4252348.1609227376678@mail.yahoo.com
Whole thread Raw
In response to Insert 1 million data  (Sreejith P <sreejith@lifetrenz.com>)
Responses Re: Insert 1 million data  (Sreejith P <sreejith@lifetrenz.com>)
List pgsql-admin
Tree view
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 where you have placed your WAL files.

On Tuesday, 29 December, 2020, 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 '/BackupVolume/hisDbBackup/WALs/0000000200000AE6000000B9': No space left on device

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

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

 

2020-12-17 21:53:56 +04 [84225]: user=AstDBA,db=AST-PROD,app=[unknown],client=172.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=AstDBA,db=AST-PROD,app=[unknown],client=172.18.200.100 WARNING:  terminating connection because of crash of another server process

2020-12-17 21:53:56 +04 [51102]: user=AstDBA,db=AST-PROD,app=[unknown],client=172.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 memory.

 

 

2020-12-17 21:55:20 +04 [55808]: user=replicator,db=[unknown],app=[unknown],client=172.18.200.144 FATAL:  the database system is in recovery mode

 

 

2020-12-17 21:55:25 +04 [55828]: user=replicator,db=[unknown],app=walreceiver,client=172.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=replicator,db=[unknown],app=walreceiver,client=172.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=replicator,db=[unknown],app=walreceiver,client=172.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=replicator,db=[unknown],app=walreceiver,client=172.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=replicator,db=[unknown],app=walreceiver,client=172.18.200.144 ERROR:  requested starting point AEA/A2000000 is ahead of the WAL flush position of this server AEA/A1FFFA50

 

Thanks

Sreejith

 

 


 

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 confidential or privileged information. If you are not the intended recipient, please notify the sender immediately and destroy all copies of this message and any attachments. The views expressed in this email are, unless otherwise stated, those of the author and not those of dWise HealthCare IT Solutions or its management.

pgsql-admin by date:

Previous
From: Sreejith P
Date:
Subject: Insert 1 million data
Next
From: Sreejith P
Date:
Subject: Re: Insert 1 million data