| From: | Brian Hirt <bhirt(at)mobygames(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: autovacuum process (PID ...) was terminated by signal 11 |
| Date: | 2006-01-04 17:11:22 |
| Message-ID: | 2511A9AC-8894-4786-966A-92858BCCF252@mobygames.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
that's strange, because I'm running 8.1.1.
[root(at)pgdb01 root]# /usr/pg-8.1/bin/postmaster --version
postmaster (PostgreSQL) 8.1.1
Is there more information i can provide to help find the problem?
On Jan 4, 2006, at 10:04 AM, Tom Lane wrote:
> Brian Hirt <bhirt(at)mobygames(dot)com> writes:
>> When I'm doing a database load of a 5gb database, autovacuum always
>> segfaults shortly after the load finishes.
>
> This sure looks like the same bug already fixed in 8.1.1:
>
> 2005-11-28 08:35 alvherre
>
> * src/backend/postmaster/autovacuum.c: Set a snapshot before
> running analyze on a single table, to avoid a crash when analyzing
> tables with expressional indexes.
>
> Per report from Frank van Vugt.
>
> regards, tom lane
--------------------------------------------
MobyGames
http://www.mobygames.com
The world's largest and most comprehensive
gaming database project
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jaime Casanova | 2006-01-04 17:20:28 | Re: autovacuum process (PID ...) was terminated by signal 11 |
| Previous Message | Tom Lane | 2006-01-04 17:04:20 | Re: autovacuum process (PID ...) was terminated by signal 11 |