Re: server process was terminated by signal 11 postgres

Lists: pgsql-novice
From: fabrizio picca <fabrizio(dot)picca(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: server process was terminated by signal 11 postgres
Date: 2005-09-13 08:42:47
Message-ID: 1532344d0509130142449d0c32@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-novice

When i try inserting a quite large amount from data (imported from a
text file via Java) i get this error wich cames non always at the same
time.

What is this caused by ?

--
L'Estetica del lavoro è lo spettacolo della merce umana (Area)
--
http://www.fabpicca.net


From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: fabrizio(dot)picca(at)gmail(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: server process was terminated by signal 11 postgres
Date: 2005-09-13 11:11:11
Message-ID: 1126609871.2559.64.camel@linda
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-novice

On Tue, 2005-09-13 at 10:42 +0200, fabrizio picca wrote:
> When i try inserting a quite large amount from data (imported from a
> text file via Java) i get this error wich cames non always at the same
> time.
>
> What is this caused by ?

Signal 11 is a segmentation fault on Unix systems; this means that the
server process has tried to write to an invalid memory address. It
could be caused by an error in the postgres program itself, or in Java,
or possibly by a hardware fault in your machine's memory.

You need to give many more details: which operating system, which
version of PostgreSQL; more details of the command being run - is this
under JBDC? If possible, get a backtrace of the error from the server.

--
Oliver Elphick olly(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
Do you want to know God? http://www.lfix.co.uk/knowing_god.html


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: fabrizio(dot)picca(at)gmail(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: server process was terminated by signal 11 postgres
Date: 2005-09-13 15:14:24
Message-ID: 23326.1126624464@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-novice

fabrizio picca <fabrizio(dot)picca(at)gmail(dot)com> writes:
> When i try inserting a quite large amount from data (imported from a
> text file via Java) i get this error wich cames non always at the same
> time.

> What is this caused by ?

Either a bug or a hardware problem. You haven't given nearly enough
details to let anyone figure out which, however. If you think it might
be a Postgres bug, please see the bug reporting guidelines here:
http://www.postgresql.org/docs/8.0/static/bug-reporting.html

regards, tom lane


From: fabrizio picca <fabrizio(dot)picca(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: server process was terminated by signal 11 postgres
Date: 2005-09-14 19:29:22
Message-ID: 1532344d050914122963b407e3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-novice

thanks everybody, fortunately i've resolved everything.
The problem was a mistake in pointer allocation in one of the
C-Triggers i've developed.
I've detected the fault and everything is ok now.
Thanks again for the attention.

On 9/13/05, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> fabrizio picca <fabrizio(dot)picca(at)gmail(dot)com> writes:
> > When i try inserting a quite large amount from data (imported from a
> > text file via Java) i get this error wich cames non always at the same
> > time.
>
> > What is this caused by ?
>
> Either a bug or a hardware problem. You haven't given nearly enough
> details to let anyone figure out which, however. If you think it might
> be a Postgres bug, please see the bug reporting guidelines here:
> http://www.postgresql.org/docs/8.0/static/bug-reporting.html
>
> regards, tom lane
>

--
L'Estetica del lavoro è lo spettacolo della merce umana (Area)
--
http://www.fabpicca.net