Обсуждение: pgbench data loading failure- tablepscace space or pg_wal mount space issue

Поиск
Список
Период
Сортировка

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

От
Raj kumar
Дата:
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 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

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