From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
---|---|
To: | Robert Nix <robert(at)urban4m(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Segmentation fault: pg_upgrade 9.1 to 9.3: pg_dump: row number 0 is out of range 0..-1 |
Date: | 2013-09-15 23:10:07 |
Message-ID: | CAMkU=1zLZmBtR=2OP4Qyqb_azL-kg0wc+vtb51A4cqJdaT1zfg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sat, Sep 14, 2013 at 6:40 PM, Robert Nix <robert(at)urban4m(dot)com> wrote:
> Running a pg_upgrade task is causing Segmentation fault:
>
> command: "/usr/lib/postgresql/9.3/bin/pg_dump" --host
> "/var/lib/postgresql" --port 50432 --username "postgres" --schema-only
> --quote-all-identifiers --binary-upgrade --format=custom
> --file="pg_upgrade_dump_6064585.custom" "u" >>
> "pg_upgrade_dump_6064585.log" 2>&1
> pg_dump: row number 0 is out of range 0..-1
> Segmentation fault (core dumped)
>
...
>
> Any tips on how to diagnose and/or what might be the problem?
>
What happens if you manually run the pg_dump command quoted above against a
running 9.1 server, outside of the context of pg_upgrade? (Your port will
be probably be different from 50432)
If that still crashes, What if you drop the --binary-upgrade option? The
--format=custom option?
>
> gdb doesn't seem helpful:
>
> $ gdb /usr/lib/postgresql/9.3/bin/pg_dump core
> GNU gdb (GDB) 7.5-ubuntu
> Reading symbols from /usr/lib/postgresql/9.3/bin/pg_dump...(no debugging
> symbols found)...done.
>
You need to install the debugging symbols, which I have no experience doing
under Ubuntu, but it should be easy to find instructions for. Or you could
compile pg_dump from source, after configuring with --enable-debug.
Cheers,
Jeff
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Janes | 2013-09-15 23:49:55 | Re: help getting a backtrace from 9.2 on Ubuntu 13.04? |
Previous Message | Joe Conway | 2013-09-15 22:51:07 | Re: Using PL/R with 9.3beta2 |