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
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! |