Обсуждение: pgbench data loading failure- tablepscace space or pg_wal mount space issue
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 [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 device
2020-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
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