pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
error while loading data into table
3+ messages / 3 participants
[nested] [flat]

* error while loading data into table
@ 2011-11-10 14:01  Karuna Karpe <karuna.karpe@os3infotech.com>
  0 siblings, 2 replies; 3+ messages in thread

From: Karuna Karpe @ 2011-11-10 14:01 UTC (permalink / raw)
  To: pgsql-admin

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


   - 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

enterprisedb@linux-pgbulk:~/bin> du -sh ../data/pg_xlog/
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 :-

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.

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: error while loading data into table
@ 2011-11-10 14:47  Kevin Grittner <Kevin.Grittner@wicourts.gov>
  parent: Karuna Karpe <karuna.karpe@os3infotech.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Kevin Grittner @ 2011-11-10 14:47 UTC (permalink / raw)
  To: Karuna Karpe <karuna.karpe@os3infotech.com>; pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: error while loading data into table
@ 2011-11-10 14:50  Scott Ribe <scott_ribe@elevated-dev.com>
  parent: Karuna Karpe <karuna.karpe@os3infotech.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Scott Ribe @ 2011-11-10 14:50 UTC (permalink / raw)
  To: Karuna Karpe <karuna.karpe@os3infotech.com>; +Cc: pgsql-admin

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







^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2011-11-10 14:50 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-11-10 14:01 error while loading data into table Karuna Karpe <karuna.karpe@os3infotech.com>
2011-11-10 14:47 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2011-11-10 14:50 ` Scott Ribe <scott_ribe@elevated-dev.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox