| 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
| 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 |
| 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? |