pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (7+ messages)  latest in thread

Message-ID: <6679.1202153472@sss.pgh.pa.us>
Permalink:  ../6679.1202153472@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/6679.1202153472@sss.pgh.pa.us

 · 

reply

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