Re: Quite strange crash

On Monday 08 January 2001 00:08, Tom Lane wrote:
> Denis Perchine <dyp(at)perchine(dot)com> writes:
> > Does anyone seen this on PostgreSQL 7.0.3?????
> > FATAL: s_lock(401f7435) at bufmgr.c:2350, stuck spinlock. Aborting.
>
> Were there any errors before that?

No... Just clean log (I redirect log from stderr/out t file, and all other to
syslog).

Here it is just from the begin:

----
DEBUG: Data Base System is starting up at Sun Jan 7 04:22:00 2001
DEBUG: Data Base System was interrupted being in production at Thu Jan 4
23:30:22 2001
DEBUG: Data Base System is in production state at Sun Jan 7 04:22:00 2001

FATAL: s_lock(401f7435) at bufmgr.c:2350, stuck spinlock. Aborting.

FATAL: s_lock(401f7435) at bufmgr.c:2350, stuck spinlock. Aborting.
Server process (pid 1008) exited with status 6 at Sun Jan 7 04:29:07 2001
Terminating any active server processes...
Server processes were terminated at Sun Jan 7 04:29:07 2001
Reinitializing shared memory and semaphores
-----

As far as you can see it happends almost just after start.

I can give you full list of queries which was made by process 1008. But
basically there was only queries like this:
select message_id from pop3 where server_id = 6214

insert into pop3 (server_id, mailfrom, mailto, subject, message_id,
sent_date, sent_date_text, recieved_date, state) values (25641,
'virtualo.com', 'jrdias(at)mail(dot)telepac(dot)pt', 'Joao roque Dias I have
tried them all....this one is for real........!',
'20010107041334(dot)CVEA17335(dot)fep02-svc(dot)mail(dot)telepac(dot)pt(at)anydomain(dot)com',
'2001-01-07 04:06:23 -00', 'Sat, 06 Jan 2001 23:06:23 -0500', 'now', 1)

And the last query was:
Jan 7 04:27:53 mx postgres[1008]: query: select message_id from pop3 where
server_id = 22615

> I've been suspicious for awhile that the system might neglect to release
> buffer cntx_lock spinlocks if an elog() occurs while one is held. This
> looks like it might be such a case, but you're only showing us the end
> symptom not what led up to it ...

Just say me what can I do. Unfortunatly I can not reproduce the situation...

--
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp(at)perchine(dot)com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------