From: Tom Lane <tgl@sss.pgh.pa.us>
To: Mike Williams <mike.williams@comodo.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: "create implicit sequence" crashes postgres
Date: Mon, 04 Feb 2008 14:31:12 -0500
Message-ID: <6679.1202153472@sss.pgh.pa.us> (raw)
In-Reply-To: <200802041726.01060.mike.williams@comodo.com>
References: <200802041726.01060.mike.williams@comodo.com>
Mike Williams <mike.williams@comodo.com> writes:
> We're trying to move off a single VM running postgres 8.1 to a newer more
> powerful pair of VMs with a DRBD mirror for storage and postgres 8.2.
> But, every attempt to dump the data from 8.1.x into 8.2.6 fails, and fails
> exactly the same way.
> And any SQL to create a table with more than 24, or 25 (can't remember off top
> of my head) characters long, with a serial column, causes this crash:
> Feb 4 17:00:03 mcsql1 postgres[6639]: [23-1] NOTICE: CREATE TABLE will
> create implicit sequence "billing_transaction_items_id_seq" for serial column
> Feb 4 17:00:03 mcsql1 postgres[6639]: [23-2] "billing_transaction_items.id"
> Feb 4 17:00:03 mcsql1 postgres[6377]: [4-1] LOG: server process (PID 6639)
> was terminated by signal 11
> The only comonality between those that crash is that they're all 64bit Xen
> VMs, so far non-VM servers don't crash. But nothing anywhere I can find even
> vaguely hints at problems running Postgres under Xen.
News to me too. Can you get a stack trace from the crash? Can you
extract a small test case from your dump script, so people can try it
elsewhere?
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, mike.williams@comodo.com
Subject: Re: "create implicit sequence" crashes postgres
In-Reply-To: <6679.1202153472@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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