postgres database crashed

From: Ashish Goel <postgres_help(at)yahoo(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: postgres database crashed
Date: 2006-10-10 18:32:33
Message-ID: 20061010183233.81495.qmail@web58108.mail.re3.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

We have a following table xyz( id int , fname varchar(50), img image)
where image is a data type we have created similar to lo.

so when we executed an insert query on the following table :-

insert into xyz VALUES (2541, '/home/ravi/jdbc/2_down/76.jpg', '76.jpg');

It works well for nearly 2500 images but from there onwards we obtained the following error and the database crashes.

this is the bt we obtained on using gdb with the postgres process

#0 0x00313bbc in memcpy () from /lib/libc.so.6
#1 0x0819496d in datumCopy ()
#2 0x0812d202 in copyObject ()
#3 0x08151c49 in eval_const_expressions_mutator ()
#4 0x08150c2f in expression_tree_mutator ()
#5 0x08151c49 in eval_const_expressions_mutator ()
#6 0x08150ece in expression_tree_mutator ()
#7 0x08151c49 in eval_const_expressions_mutator ()
#8 0x08152818 in eval_const_expressions ()
#9 0x081487d8 in preprocess_expression ()
#10 0x08149a04 in subquery_planner ()
#11 0x08149e56 in planner ()
#12 0x0817c25c in pg_plan_query ()
#13 0x0817c8d2 in pg_plan_queries ()
#14 0x0817e135 in PostgresMain ()
#15 0x0815b6e5 in ServerLoop ()
#16 0x0815c459 in PostmasterMain ()
#17 0x08128f48 in main ()

this is the LOG obtained

LOG: server process (PID 2499) was terminated by signal 11
(gdb) LOG: terminating any other active server processes
LOG: all server processes terminated; reinitializing
LOG: database system was interrupted at 2006-10-10 23:40:05 IST
LOG: checkpoint record is at 0/14B37B98
LOG: redo record is at 0/14B37B98; undo record is at 0/0; shutdown FALSE
LOG: next transaction ID: 210546; next OID: 851968; next MultiXactId: 1
LOG: database system was not properly shut down; automatic recovery in progress
FATAL: the database system is starting up
LOG: record with zero length at 0/14B37BD8
LOG: redo is not required
LOG: database system is ready
LOG: transaction ID wrap limit is 1073952152, limited by database "benchmark"

Can somebody suggest us what might be the cause of error and what can we do to resolve it ?

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2006-10-10 18:35:30 Re: more anti-postgresql FUD
Previous Message Tom Lane 2006-10-10 18:17:57 Re: archive_timeout?