pgbench data loading failure- tablepscace space or pg_wal mount space issue

From: Raj kumar <rajkumar820999(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: pgbench data loading failure- tablepscace space or pg_wal mount space issue
Date: 2020-04-28 06:38:53
Message-ID: CACxU--WYZEvePCM73VqS+fxS4OrRfiT163iH+DyDw_RGa2yOEA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi ,

I am trying to load 2 TB of data into the database. It worked fine for 1TB
but failed for 2TB.
I have separate temporary tablespace. I have separate mount for pg_wal with
soft link from data directory.

From the below error, I want to understand* if the error is due to
Tablespace space issue or pg_wal mount point space issue. Please advise.*

2020-04-27 03:36:15 MST [3173]: [7-1] user=,db=,app=,client=LOG: database
system is ready to accept connections
2020-04-27 03:36:15 MST [3182]: [1-1] user=,db=,app=,client=LOG: dbms_aq
launcher started

*2020-04-27 09:36:01 MST [13034]: [1-1]
user=enterprisedb,db=perfbench,app=pgbench,client=[local]PANIC: could not
write to file "pg_wal/xlogtemp.13034": No space left on device2020-04-27
09:36:01 MST [13034]: [2-1] *

*user=enterprisedb,db=perfbench,app=pgbench,client=[local]CONTEXT: writing
block 191554326 of relation pg_tblspc/16388/PG_11_201809051/16387/16447
COPY pgbench_accounts, line 11684939175*

2020-04-27 09:36:01 MST [13034]: [3-1]
user=enterprisedb,db=perfbench,app=pgbench,client=[local]STATEMENT: copy
pgbench_accounts from stdin
2020-04-27 09:36:01 MST [3173]: [8-1] user=,db=,app=,client=LOG: server
process (PID 13034) was terminated by signal 6: Aborted
2020-04-27 09:36:01 MST [3173]: [9-1] user=,db=,app=,client=DETAIL: Failed
process was running: copy pgbench_accounts from stdin

Thanks,
Raj

Browse pgsql-admin by date

  From Date Subject
Next Message Rui DeSousa 2020-04-28 06:41:11 Re: PostgreSQL DB checkpoint error!
Previous Message Ashok kumar Mani 2020-04-28 06:31:52 RE: PostgreSQL DB checkpoint error!