error while loading data into table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

enterprisedb@linux-pgbulk:~/bin> du -sh ../data/pg_xlog/
1.2G    ../data/pg_xlog/
enterprisedb@linux-pgbulk:~/bin> ls -l /opt/PostgresPlus/user_tablespace/PG_9.0_201008051/16862/
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.


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux