postgres database crashed
От | Ashish Goel |
---|---|
Тема | postgres database crashed |
Дата | |
Msg-id | 20061010183233.81495.qmail@web58108.mail.re3.yahoo.com обсуждение исходный текст |
Ответы |
Re: postgres database crashed
|
Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: