Function call crashes server

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Function call crashes server
Date: 2002-03-21 02:46:11
Message-ID: 200203210246.g2L2kBs23735@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

If I do this as any user:

SELECT update_pg_pwd();

it crashes all backends and causes a server-wide restart. Is this
acceptable behavior? I am sure there are other cases too. Isn't it a
problem that we let ordinary users crash the server and cause a restart?

---------------------------------------------------------------------------

LOG: server process (pid 23337) was terminated by signal 11
LOG: terminating any other active server processes
LOG: all server processes terminated; reinitializing shared memory and semaphores
FATAL: The database system is starting up
LOG: database system was interrupted at 2002-03-21 03:42:08 CET
LOG: checkpoint record is at 0/43C048
LOG: redo record is at 0/43C048; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 99; next oid: 24747
LOG: database system was not properly shut down; automatic recovery in progress
LOG: redo starts at 0/43C088
LOG: ReadRecord: record with zero length at 0/4421B4
LOG: redo done at 0/442190
LOG: database system is ready

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Copeland 2002-03-21 04:37:33 Re: Function call crashes server
Previous Message Jan Wieck 2002-03-20 23:23:01 Re: Notify argument?