Обсуждение: postgres crash - illegal instruction

Hi,

I'v run into the following today:

  2893LOG:  server process (PID 24519) was terminated by signal 4:
Illegal instruction

Is this an error in postgres?

I'm running 8.4.2 - yes, I should update.

Hello

Dne 24. května 2011 12:21 Jiří Pavlovský <jira@getnet.cz> napsal(a):
> Hi,
>
> I'v run into the following today:
>
>  2893LOG:  server process (PID 24519) was terminated by signal 4: Illegal
> instruction
>
> Is this an error in postgres?
>
> I'm running 8.4.2 - yes, I should update.
>

what is operation system?
what is output from SELECT version()?

Regards

Pavel Stehule

>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

On 24.5.2011 12:40, Pavel Stehule wrote:
> Hello
>
> Dne 24. května 2011 12:21 Jiří Pavlovský<jira@getnet.cz>  napsal(a):
>> Hi,
>>
>> I'v run into the following today:
>>
>>   2893LOG:  server process (PID 24519) was terminated by signal 4: Illegal
>> instruction
>>
>> Is this an error in postgres?
>>
>> I'm running 8.4.2 - yes, I should update.
>>
> what is operation system?
> what is output from SELECT version()?

CetOS5
Linux p69.project-syndicate.org 2.6.18-194.11.4.el5PAE #1 SMP Tue Sep 21
05:48:23 EDT 2010 i686 i686 i386 GNU/Linux

PostgreSQL 8.4.2 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC)
4.1.2 20080704 (Red Hat 4.1.2-44), 32-bit

I's from the rpms on postgres.org


Regards,
Jiri

2011/5/24 Jiří Pavlovský <jira@getnet.cz>:
> I'v run into the following today:
>
>  2893LOG:  server process (PID 24519) was terminated by signal 4: Illegal
> instruction
>
> Is this an error in postgres?
>

I'll tend to suspect hardware error, specifically memory corruption,
or on-disk corruption of the binary.  Do you use ECC and is it working
correctly?  It is extremely unlikely that gcc generated a binary with
illegal instructions in it, especially for x86 systems.