postgresql 8.2 rc1 - crash

From: "hubert depesz lubaczewski" <depesz(at)gmail(dot)com>
To: "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: postgresql 8.2 rc1 - crash
Date: 2006-11-30 10:38:28
Message-ID: 9e4684ce0611300238q3430a26dnc57a5cc6a0945ee8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi,
i have been testing 8.2 rc1, while i got this problem.

base data:
linux, 32bit, kernel: 2.6.18.3; debian
postgresql version:
PostgreSQL 8.2rc1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
3.3.5(Debian 1:
3.3.5-13)
problematic table is over 2gigabytes in size, and has several indices - one
of them is gin-index.

problem:
when i issue vacuum full verbose analyze it works, but then crashes with
signal 11.
always in the same situation.

i was not able to check what is the reason.
i did:
recompile with debug, set ulimit -c unlimited, and rerun the query.
it crashed.
i bundled:
1. logs
2. core file
3. config of postgresql
4. saved output of vacuum
all of this can be fetched from:
http://depesz.com/various/crash.data.tar.bz2
unfortunatelly i'm not c programmer, so i dont know gdb, but i hope you will
be ab le to make any sense out of it.

the bz2 file is > 20mb in size.

any help? is it hardware problem? or a missed bug in code?

if i can provide you with more information - please tell me what i should
tell you.

depesz

--
http://www.depesz.com/ - nowy, lepszy depesz

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hengki Suhartoyo 2006-11-30 10:56:08 Float8 precision problem
Previous Message Ashish Karalkar 2006-11-30 09:33:32 Re: [Slony1-general] Please help... syntax Error in create set ..