Обсуждение: error while loading data into table
Hello,
I am loading data in "demo" database table "emp". I use folloing command :-
enterprisedb@linux-pgbulk:~/bin> ./edbldr -d demo userid=enterprisedb/psql control=/opt/PostgresPlus/user_tablespace/control_file.ctl
EDB*Loader: Copyright (c) 2007-2011, EnterpriseDB Corporation.
edbldr error: PANIC: could not write to file "pg_xlog/xlogtemp.8672": No space left on device
no connection to the server
load data
infile '/opt/PostgresPlus/user_tablespace/emp.csv'
APPEND into table emp
FIELDS TERMINATED BY ','
(id,name)
2011-11-10 18:45:49 ISTLOG: database system was not properly shut down; automatic recovery in progress
2011-11-10 18:45:49 ISTLOG: consistent recovery state reached at 0/50E709D4
2011-11-10 18:45:49 ISTLOG: redo starts at 0/44EFBB28
2011-11-10 18:45:56 ISTFATAL: the database system is starting up
2011-11-10 18:46:10 ISTFATAL: the database system is starting up
2011-11-10 18:46:14 ISTFATAL: the database system is starting up
2011-11-10 18:46:19 ISTFATAL: the database system is starting up
2011-11-10 18:46:22 ISTFATAL: the database system is starting up
2011-11-10 18:46:31 ISTFATAL: the database system is starting up
2011-11-10 18:46:36 ISTFATAL: the database system is starting up
2011-11-10 18:46:37 ISTLOG: could not open file "pg_xlog/000000010000000000000080" (log file 0, segment 128): No such file or directory
2011-11-10 18:46:37 ISTLOG: redo done at 0/7FFFFF88
2011-11-10 18:46:37 ISTLOG: last completed transaction was at log time 2011-11-10 18:33:33.838873+05:30
2011-11-10 18:46:40 ISTPANIC: could not write to file "pg_xlog/xlogtemp.8737": No space left on device
2011-11-10 18:46:40 ISTLOG: startup process (PID 8737) was terminated by signal 6: Aborted
1.2G ../data/pg_xlog/
total 1231656
-rw------- 1 enterprisedb enterprisedb 1073741824 2011-11-10 18:46 16863
-rw------- 1 enterprisedb enterprisedb 185901056 2011-11-10 18:46 16863.1
-rw------- 1 enterprisedb enterprisedb 327680 2011-11-10 18:46 16863_fsm
what's wrong in above. why not able to connect to database?? Can any please give me solution for that problem????
Regards,
Karuna karpe.
I am loading data in "demo" database table "emp". I use folloing command :-
enterprisedb@linux-pgbulk:~/bin> ./edbldr -d demo userid=enterprisedb/psql control=/opt/PostgresPlus/user_tablespace/control_file.ctl
EDB*Loader: Copyright (c) 2007-2011, EnterpriseDB Corporation.
edbldr error: PANIC: could not write to file "pg_xlog/xlogtemp.8672": No space left on device
no connection to the server
- Control_file.ctl file have following data :-
load data
infile '/opt/PostgresPlus/user_tablespace/emp.csv'
APPEND into table emp
FIELDS TERMINATED BY ','
(id,name)
- when I restart my postgres server, that time I found following logs in pg_log :-
2011-11-10 18:45:49 ISTLOG: database system was not properly shut down; automatic recovery in progress
2011-11-10 18:45:49 ISTLOG: consistent recovery state reached at 0/50E709D4
2011-11-10 18:45:49 ISTLOG: redo starts at 0/44EFBB28
2011-11-10 18:45:56 ISTFATAL: the database system is starting up
2011-11-10 18:46:10 ISTFATAL: the database system is starting up
2011-11-10 18:46:14 ISTFATAL: the database system is starting up
2011-11-10 18:46:19 ISTFATAL: the database system is starting up
2011-11-10 18:46:22 ISTFATAL: the database system is starting up
2011-11-10 18:46:31 ISTFATAL: the database system is starting up
2011-11-10 18:46:36 ISTFATAL: the database system is starting up
2011-11-10 18:46:37 ISTLOG: could not open file "pg_xlog/000000010000000000000080" (log file 0, segment 128): No such file or directory
2011-11-10 18:46:37 ISTLOG: redo done at 0/7FFFFF88
2011-11-10 18:46:37 ISTLOG: last completed transaction was at log time 2011-11-10 18:33:33.838873+05:30
2011-11-10 18:46:40 ISTPANIC: could not write to file "pg_xlog/xlogtemp.8737": No space left on device
2011-11-10 18:46:40 ISTLOG: startup process (PID 8737) was terminated by signal 6: Aborted
- I check my pg_xlog directory size
1.2G ../data/pg_xlog/
- my emp table size is more then 1GB;
- I create tablespace from emp table at location /opt/PostgresPlus/user_tablespace/. It having following files :-
total 1231656
-rw------- 1 enterprisedb enterprisedb 1073741824 2011-11-10 18:46 16863
-rw------- 1 enterprisedb enterprisedb 185901056 2011-11-10 18:46 16863.1
-rw------- 1 enterprisedb enterprisedb 327680 2011-11-10 18:46 16863_fsm
what's wrong in above. why not able to connect to database?? Can any please give me solution for that problem????
Regards,
Karuna karpe.
Karuna Karpe <karuna.karpe@os3infotech.com> wrote: > 2011-11-10 18:46:40 ISTPANIC: could not write to file > "pg_xlog/xlogtemp.8737": No space left on device > 2011-11-10 18:46:40 ISTLOG: startup process (PID 8737) was > terminated by signal 6: Aborted What does df show if you run it at that point? -Kevin
On Nov 10, 2011, at 7:01 AM, Karuna Karpe wrote: > what's wrong in above. why not able to connect to database?? Your disk is full? -- Scott Ribe scott_ribe@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice