pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Problem in taking the database dump 2+ messages / 2 participants [nested] [flat]
* Problem in taking the database dump @ 2012-09-18 08:57 himanshu.joshi <himanshu.joshi@orkash.com> 2012-09-18 14:03 ` Re: Problem in taking the database dump Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 2+ messages in thread From: himanshu.joshi @ 2012-09-18 08:57 UTC (permalink / raw) To: pgsql-admin Hi, I am facing a strange problem while taking dump of a postgres database using pg_dump. whenever I start the pg_dump command to take the backup of that particular database, it stops within few minutes with the below mentioned error: *[root@s8-msd-2 bin]# ./pg_dump -Upostgres pdc_uima_dummy > /hdd2-1/pdc_uima_dummy_108_18092012.sql pg_dump: SQL command failed pg_dump: Error message from server: ERROR: invalid memory alloc request size 18446744073709551613 pg_dump: The command was: COPY public.object_data (id, wkb_geometry, obj_type_id, obj_beginoffset, obj_endoffset, source_id, sentence_id, last_mod_date, obj_norm_value, obj_text, entity_name, frequency) TO stdout;* After repeating the process many times I am getting the same error every time. Due to space problem in the database server, the tablespace of that particular database is mounted on another storage server. Is this mounting is the cause of the error or anything else? Plz suggest. Thanks & Regards, Himanshu Joshi ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Problem in taking the database dump 2012-09-18 08:57 Problem in taking the database dump himanshu.joshi <himanshu.joshi@orkash.com> @ 2012-09-18 14:03 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2012-09-18 14:03 UTC (permalink / raw) To: himanshu.joshi <himanshu.joshi@orkash.com>; +Cc: pgsql-admin "himanshu.joshi" <himanshu.joshi@orkash.com> writes: > I am facing a strange problem while taking dump of a postgres > database using pg_dump. > whenever I start the pg_dump command to take the backup of that > particular database, it stops within few minutes with the below > mentioned error: > *[root@s8-msd-2 bin]# ./pg_dump -Upostgres pdc_uima_dummy > > /hdd2-1/pdc_uima_dummy_108_18092012.sql > pg_dump: SQL command failed > pg_dump: Error message from server: ERROR: invalid memory alloc request > size 18446744073709551613 > pg_dump: The command was: COPY public.object_data (id, wkb_geometry, > obj_type_id, obj_beginoffset, obj_endoffset, source_id, sentence_id, > last_mod_date, obj_norm_value, obj_text, entity_name, frequency) TO > stdout;* This looks like a data corruption issue -- that is, there's some row in that table that contains a damaged variable-width field, such that the system is computing a silly value for the width of the field. You need to find and remove the damaged row(s). regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2012-09-18 14:03 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2012-09-18 08:57 Problem in taking the database dump himanshu.joshi <himanshu.joshi@orkash.com> 2012-09-18 14:03 ` Tom Lane <tgl@sss.pgh.pa.us>
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