Re: PostgreSQL server terminated by signal 11

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Daniel Caune" <daniel(dot)caune(at)ubisoft(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: PostgreSQL server terminated by signal 11
Date: 2006-07-27 20:05:51
Message-ID: 27282.1154030751@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

"Daniel Caune" <daniel(dot)caune(at)ubisoft(dot)com> writes:
> My PostgreSQL server running on a Linux machine is terminated by signal
> 11 whenever I try to create some indexes on a table, which contains
> quite a lot of data.

Judging from your examples it's got something to do with the partial
index WHERE clause. What PG version is this exactly? If you leave out
different parts of the WHERE, does it still crash? Does the crash
happen immediately after you give the command, or does it run for
awhile? It might be worth getting a stack trace from the failure
(best way is to attach to the running backend with gdb, provoke the
crash, and do "bt" --- search for "gdb" in the archives if you need
details).

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-07-27 21:08:36 Re: Index row maximum size and crash
Previous Message Daniel Caune 2006-07-27 20:02:22 Re: [SQL] PostgreSQL server terminated by signal 11

Browse pgsql-sql by date

  From Date Subject
Next Message Wilkinson Charlie E 2006-07-27 20:17:24 Re: Disk is full, what's cool to get rid of?
Previous Message Erik Jones 2006-07-27 20:00:03 Re: Disk is full, what's cool to get rid of?