agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedRe: pg_dump Error
12+ messages / 8 participants
[nested] [flat]
* Re: pg_dump Error
@ 2000-12-22 16:31 Tom Lane <tgl@sss.pgh.pa.us>
parent: Najm Hashmi <najm@mondo-live.com>
0 siblings, 0 replies; 12+ messages in thread
From: Tom Lane @ 2000-12-22 16:31 UTC (permalink / raw)
To: Najm Hashmi <najm@mondo-live.com>; +Cc: pgsql-sql
Najm Hashmi <najm@mondo-live.com> writes:
> while trying to dump db shcema and content, I am getting the
> following error:
> [najm@localhost najm]$ pg_dump -D fliprdb > flipr.sql
> PQgetvalue: ERROR! tuple number 0 is out of range 0..-1
> Segmentation fault (core dumped)
Hmm, looks like you've managed to expose a bug in pg_dump. It looks
like pg_dump is getting an empty result to some query that it's not
prepared to handle an empty result for, but there's not enough info
here to tell what that query is.
I'd suggest restarting the postmaster with -d2 and making sure its
output is going into a logfile (don't use -S switch), then rerun
pg_dump. The last query shown in the postmaster log will be the one
that's causing a problem. That'll give us more info to go on.
I'm thinking that the problem is something along the lines of a table
with no owner (ie, no corresponding entry in pg_shadow), but can't
tell for sure yet.
regards, tom lane
^ permalink raw reply [nested|flat] 12+ messages in thread
* pg_dump Error
@ 2000-12-22 18:53 Najm Hashmi <najm@mondo-live.com>
0 siblings, 1 reply; 12+ messages in thread
From: Najm Hashmi @ 2000-12-22 18:53 UTC (permalink / raw)
To: pgsql-sql
Hi all,
while trying to dump db shcema and content, I am getting the
following error:
[najm@localhost najm]$ pg_dump -D fliprdb > flipr.sql
PQgetvalue: ERROR! tuple number 0 is out of range 0..-1
Segmentation fault (core dumped)
Any suggestion what I am doing wrong and why i am getting this error.
Thank you all in advance for your help
Regards.
Najm
^ permalink raw reply [nested|flat] 12+ messages in thread
* pg_dump error
@ 2001-01-15 20:13 Johann Spies <jhspies@adept.co.za>
0 siblings, 1 reply; 12+ messages in thread
From: Johann Spies @ 2001-01-15 20:13 UTC (permalink / raw)
To: pgsql-sql
Version 6.5.3 on Debian Potato
My daily cron job reported :
Can not create pgdump_oid table. Explanation from backend: 'ERROR:
cannot create pgdump_oid
Is there a way to repair this?
Johann
--
J.H. Spies - Tel. 082 782 0336
"For I know that my redeemer liveth, and that he shall
stand at the latter day upon the earth"
Job 19:25
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: pg_dump error
@ 2001-01-16 01:03 Philip Warner <pjw@rhyme.com.au>
parent: Johann Spies <jhspies@adept.co.za>
0 siblings, 1 reply; 12+ messages in thread
From: Philip Warner @ 2001-01-16 01:03 UTC (permalink / raw)
To: Johann Spies <jhspies@adept.co.za>; pgsql-sql
At 22:13 15/01/01 +0200, Johann Spies wrote:
>
>Can not create pgdump_oid table. Explanation from backend: 'ERROR:
>cannot create pgdump_oid
>
>Is there a way to repair this?
>
If there was an earlier crash while running pg_dump, the table may already
exist. If so, try deleting it. Also, can you confirm that the username
under which you run pg_dump has the rights to create tables?
----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 0500 83 82 82 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: pg_dump error
@ 2001-01-16 01:19 Tatsuo Ishii <t-ishii@sra.co.jp>
parent: Philip Warner <pjw@rhyme.com.au>
0 siblings, 1 reply; 12+ messages in thread
From: Tatsuo Ishii @ 2001-01-16 01:19 UTC (permalink / raw)
To: pjw@rhyme.com.au; +Cc: jhspies@adept.co.za; pgsql-sql
> >Can not create pgdump_oid table. Explanation from backend: 'ERROR:
> >cannot create pgdump_oid
> >
> >Is there a way to repair this?
> >
>
> If there was an earlier crash while running pg_dump, the table may already
> exist. If so, try deleting it. Also, can you confirm that the username
> under which you run pg_dump has the rights to create tables?
I have observed it several times on 7.0.x while using
pg_dumpall. Since pg_dumpall would create pgdump_oid as many times as
the number of databases, I suspect there might be an internal cache
problem in the backend. However this problem was hard to reproduce, I
have not tackled it yet. If someone has a reproducible data, please
let us know...
--
Tatsuo Ishii
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: pg_dump error
@ 2001-01-16 01:36 Tom Lane <tgl@sss.pgh.pa.us>
parent: Tatsuo Ishii <t-ishii@sra.co.jp>
0 siblings, 1 reply; 12+ messages in thread
From: Tom Lane @ 2001-01-16 01:36 UTC (permalink / raw)
To: Tatsuo Ishii <t-ishii@sra.co.jp>; +Cc: pjw@rhyme.com.au; jhspies@adept.co.za; pgsql-sql
Tatsuo Ishii <t-ishii@sra.co.jp> writes:
>>>> Can not create pgdump_oid table. Explanation from backend: 'ERROR:
>>>> cannot create pgdump_oid
>>>>
>>>> Is there a way to repair this?
I would guess that this means there is a file named "pgdump_oid" hanging
around in the database directory, no doubt leftover from some previous
pg_dump cycle. Manually removing the file should get you up and running
again. However, that just begs the question of why the file is there...
regards, tom lane
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: pg_dump error
@ 2001-01-16 08:21 Johann Spies <jhspies@adept.co.za>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 12+ messages in thread
From: Johann Spies @ 2001-01-16 08:21 UTC (permalink / raw)
To: pgsql-sql
On Mon, Jan 15, 2001 at 08:36:46PM -0500, Tom Lane wrote:
> Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> >>>> Can not create pgdump_oid table. Explanation from backend: 'ERROR:
> >>>> cannot create pgdump_oid
> >>>>
> >>>> Is there a way to repair this?
>
> I would guess that this means there is a file named "pgdump_oid" hanging
> around in the database directory, no doubt leftover from some previous
> pg_dump cycle. Manually removing the file should get you up and running
> again. However, that just begs the question of why the file is there...
>
I found the file "pgdump_oid" and removed it. Running the dump script
after that resulted in:
------------------------
"$Can not drop pgdump_oid table. Explanation from backend:
'pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
'."
------------------------
Running the same script
(pg_dump js -o -c -f /home/js/psql/jhspiesdb.out)
a second time:
-------------------------
'Can not create pgdump_oid table. Explanation from backend: 'ERROR:
cannot create pgdump_oid
'.
----------------------------------
Trying after that to "drop table pgdump_oid" resulted in:
------------------------
js=> drop table pgdump_oid;
QUERY: drop table pgdump_oid;
ERROR: Relation 'pgdump_oid' does not exist
ERROR: Relation 'pgdump_oid' does not exist
------------------------
Also doing \dt in psql resulted in an seemingly endless loop with no
output produced. I had to kill psql.
However, my other applications using postgresql is still working.
I also tried reinstalling postgresql. The process also resulted in
errors (one was a message about not being able to find a file with the
name "can_i_run") and when the installation script (Debian) tried to
dump the data it also failed. In the end I had postgresql running
again but the same pg_dump problem remains.
Regards.
Johann
--
J.H. Spies - Tel. 082 782 0336
"Jesus said unto her, I am the resurrection, and the
life; he that believeth in me, though he were dead,
yet shall he live" John 11:25
^ permalink raw reply [nested|flat] 12+ messages in thread
* pg_dump error
@ 2007-02-28 19:17 Karthikeyan Sundaram <skarthi98@hotmail.com>
0 siblings, 1 reply; 12+ messages in thread
From: Karthikeyan Sundaram @ 2007-02-28 19:17 UTC (permalink / raw)
To: pgsql-admin@postgresql.org; pgsql-sql
Hi,
I am using 8.2.1 on my dev server.
When I do a pg_dump, I am getting an error message.
pg_dump -U postgres podcast -t channel
pg_dump: symbol lookup error: pg_dump: undefined symbol: PQescapeStringConn
How can I resolved this? What may be the problem?
Because of this, I am not able to dump anything.
Regards
skarthi
_________________________________________________________________
Play Flexicon: the crossword game that feeds your brain. PLAY now for FREE.
http://zone.msn.com/en/flexicon/default.htm?icid=flexicon_hmtagline
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: pg_dump error
@ 2007-02-28 19:31 Joshua D. Drake <jd@commandprompt.com>
parent: Karthikeyan Sundaram <skarthi98@hotmail.com>
0 siblings, 1 reply; 12+ messages in thread
From: Joshua D. Drake @ 2007-02-28 19:31 UTC (permalink / raw)
To: Karthikeyan Sundaram <skarthi98@hotmail.com>; +Cc: pgsql-admin@postgresql.org; pgsql-sql
Karthikeyan Sundaram wrote:
> Hi,
>
> I am using 8.2.1 on my dev server.
>
> When I do a pg_dump, I am getting an error message.
>
> pg_dump -U postgres podcast -t channel
>
> pg_dump: symbol lookup error: pg_dump: undefined symbol: PQescapeStringConn
>
> How can I resolved this? What may be the problem?
>
> Because of this, I am not able to dump anything.
Sounds like you have two different versions of pg_dump on your box. Did
you recently try to upgrade?
Sincerely,
Joshua D. Drake
>
>
> Regards
> skarthi
>
> _________________________________________________________________
> Play Flexicon: the crossword game that feeds your brain. PLAY now for
> FREE. http://zone.msn.com/en/flexicon/default.htm?icid=flexicon_hmtagline
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: pg_dump error
@ 2007-02-28 19:35 Karthikeyan Sundaram <skarthi98@hotmail.com>
parent: Joshua D. Drake <jd@commandprompt.com>
0 siblings, 1 reply; 12+ messages in thread
From: Karthikeyan Sundaram @ 2007-02-28 19:35 UTC (permalink / raw)
To: jd@commandprompt.com; +Cc: pgsql-admin@postgresql.org; pgsql-sql
Hi Joshua,
Thanks for your reply. No, I recently installed (fresh installation)
from scratch.
Regards
skarthi
>From: "Joshua D. Drake" <jd@commandprompt.com>
>To: Karthikeyan Sundaram <skarthi98@hotmail.com>
>CC: pgsql-admin@postgresql.org, pgsql-sql@postgresql.org
>Subject: Re: [ADMIN] pg_dump error
>Date: Wed, 28 Feb 2007 11:31:01 -0800
>
>Karthikeyan Sundaram wrote:
> > Hi,
> >
> > I am using 8.2.1 on my dev server.
> >
> > When I do a pg_dump, I am getting an error message.
> >
> > pg_dump -U postgres podcast -t channel
> >
> > pg_dump: symbol lookup error: pg_dump: undefined symbol:
>PQescapeStringConn
> >
> > How can I resolved this? What may be the problem?
> >
> > Because of this, I am not able to dump anything.
>
>Sounds like you have two different versions of pg_dump on your box. Did
>you recently try to upgrade?
>
>Sincerely,
>
>Joshua D. Drake
>
>
> >
> >
> > Regards
> > skarthi
> >
> > _________________________________________________________________
> > Play Flexicon: the crossword game that feeds your brain. PLAY now for
> > FREE.
>http://zone.msn.com/en/flexicon/default.htm?icid=flexicon_hmtagline
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> >
>
>
>--
>
> === The PostgreSQL Company: Command Prompt, Inc. ===
>Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
>Providing the most comprehensive PostgreSQL solutions since 1997
> http://www.commandprompt.com/
>
>Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
>PostgreSQL Replication: http://www.commandprompt.com/products/
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate
_________________________________________________________________
Mortgage rates as low as 4.625% - Refinance $150,000 loan for $579 a month.
Intro*Terms
https://www2.nextag.com/goto.jsp?product=100000035&url=%2fst.jsp&tm=y&search=mortgage_te...
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: [SQL] pg_dump error
@ 2007-03-02 06:12 Tom Lane <tgl@sss.pgh.pa.us>
parent: Karthikeyan Sundaram <skarthi98@hotmail.com>
0 siblings, 0 replies; 12+ messages in thread
From: Tom Lane @ 2007-03-02 06:12 UTC (permalink / raw)
To: Karthikeyan Sundaram <skarthi98@hotmail.com>; +Cc: jd@commandprompt.com; pgsql-admin@postgresql.org; pgsql-sql
"Karthikeyan Sundaram" <skarthi98@hotmail.com> writes:
> Thanks for your reply. No, I recently installed (fresh installation)
> from scratch.
Well, your pg_dump seems to be finding an older version of libpq.so from
somewhere. Check for a pre-existing postgresql package.
regards, tom lane
^ permalink raw reply [nested|flat] 12+ messages in thread
* PG_DUMP ERROR
@ 2024-02-22 10:42 Cars Jeeva <carsjeeva@gmail.com>
0 siblings, 0 replies; 12+ messages in thread
From: Cars Jeeva @ 2024-02-22 10:42 UTC (permalink / raw)
To: pgsql-sql@lists.postgresql.org
Hi Team,I have upgraded the postgress v11 to v15.4 in my application. After
upgrading i am trying the backup (pg_dump) but it got failed.pg_dump:
error: query failed: ERROR: could not load library
"/var/opt/project/pgsql-15/lib/llvmjit.so":
/var/opt/project/pgsql-15/lib/llvmjit.so: undefined symbol: LLVMBuildGEPSome
one can help me to resolve the issue.
Thank you.
^ permalink raw reply [nested|flat] 12+ messages in thread
end of thread, other threads:[~2024-02-22 10:42 UTC | newest]
Thread overview: 12+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-12-22 18:53 pg_dump Error Najm Hashmi <najm@mondo-live.com>
2000-12-22 16:31 ` Tom Lane <tgl@sss.pgh.pa.us>
2001-01-15 20:13 pg_dump error Johann Spies <jhspies@adept.co.za>
2001-01-16 01:03 ` Re: pg_dump error Philip Warner <pjw@rhyme.com.au>
2001-01-16 01:19 ` Re: pg_dump error Tatsuo Ishii <t-ishii@sra.co.jp>
2001-01-16 01:36 ` Re: pg_dump error Tom Lane <tgl@sss.pgh.pa.us>
2001-01-16 08:21 ` Re: pg_dump error Johann Spies <jhspies@adept.co.za>
2007-02-28 19:17 pg_dump error Karthikeyan Sundaram <skarthi98@hotmail.com>
2007-02-28 19:31 ` Re: pg_dump error Joshua D. Drake <jd@commandprompt.com>
2007-02-28 19:35 ` Re: pg_dump error Karthikeyan Sundaram <skarthi98@hotmail.com>
2007-03-02 06:12 ` Re: [SQL] pg_dump error Tom Lane <tgl@sss.pgh.pa.us>
2024-02-22 10:42 PG_DUMP ERROR Cars Jeeva <carsjeeva@gmail.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox