We have a following table xyz( id int , fname varchar(50), img image)<br />where image is a data type we have created
similarto lo.<br /><br />so when we executed an insert query on the following table :-<br /><br />insert into xyz
VALUES(2541, '/home/ravi/jdbc/2_down/76.jpg', '76.jpg');<br /><br />It works well for nearly 2500 images but from there
onwardswe obtained the following error and the database crashes.<br /><br />this is the bt we obtained on using gdb
withthe postgres process<br /><br />#0 0x00313bbc in memcpy () from /lib/libc.so.6<br />#1 0x0819496d in datumCopy
()<br/>#2 0x0812d202 in copyObject ()<br />#3 0x08151c49 in eval_const_expressions_mutator ()<br />#4 0x08150c2f in
expression_tree_mutator()<br />#5 0x08151c49 in eval_const_expressions_mutator ()<br />#6 0x08150ece in
expression_tree_mutator()<br />#7 0x08151c49 in eval_const_expressions_mutator ()<br />#8 0x08152818 in
eval_const_expressions()<br />#9 0x081487d8 in preprocess_expression ()<br />#10 0x08149a04 in subquery_planner ()<br
/>#110x08149e56 in planner ()<br />#12 0x0817c25c in pg_plan_query ()<br />#13 0x0817c8d2 in pg_plan_queries ()<br
/>#140x0817e135 in PostgresMain ()<br />#15 0x0815b6e5 in ServerLoop ()<br />#16 0x0815c459 in PostmasterMain ()<br
/>#170x08128f48 in main ()<br /><br /><br />this is the LOG obtained<br /><br />LOG: server process (PID 2499) was
terminatedby signal 11<br />(gdb) LOG: terminating any other active server processes<br />LOG: all server processes
terminated;reinitializing<br />LOG: database system was interrupted at 2006-10-10 23:40:05 IST<br />LOG: checkpoint
recordis at 0/14B37B98<br />LOG: redo record is at 0/14B37B98; undo record is at 0/0; shutdown FALSE<br />LOG: next
transactionID: 210546; next OID: 851968; next MultiXactId: 1<br />LOG: database system was not properly shut down;
automaticrecovery in progress<br />FATAL: the database system is starting up<br />LOG: record with zero length at
0/14B37BD8<br/>LOG: redo is not required<br />LOG: database system is ready<br />LOG: transaction ID wrap limit is
1073952152,limited by database "benchmark"<br /><br /><br />Can somebody suggest us what might be the cause of error
andwhat can we do to resolve it ?<br /><p> __________________________________________________<br />Do You Yahoo!?<br
/>Tiredof spam? Yahoo! Mail has the best spam protection around <br />http://mail.yahoo.com