Re: PostgreSQL XID exceeded crash.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mario Lopez <mario(at)lar3d(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL XID exceeded crash.
Date: 2006-09-04 16:08:25
Message-ID: 25170.1157386105@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Mario Lopez <mario(at)lar3d(dot)com> writes:
> PID:8069 CMD_TAG:idle XID:274157581 LOG: 00000: sentencia: INSERT INTO
> scannmap4 VALUES (1719914, 2, 117, 28, 1155, 17073, 1, 1, '', '', '',
> '', NULL);
> PID:8069 CMD_TAG:idle XID:274157581 UBICACIN: log_after_parse,
> postgres.c:605
> PID:8025 CMD_TAG: XID: DEBUG: 00000: proceso de servidor (PID 8069)
> termin con cdigo de salida 255

Hm, well that gives us a little bit to go on. Tell us about the
schema of table scannmap4 ... what are its column datatypes, indexes,
rules, foreign keys, triggers? Can you reproduce the crash just by
feeding this one statement into it?

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Philippe Lang 2006-09-04 16:16:49 Re: Plperl functions with OUT parameters crashing each other when used in the same connection
Previous Message Mario Lopez 2006-09-04 16:02:54 Re: PostgreSQL XID exceeded crash.