From: | Greg Copeland <greg(at)CopelandConsulting(dot)Net> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Function call crashes server |
Date: | 2002-03-21 04:37:33 |
Message-ID: | 1016685453.24414.13.camel@mouse.copelandconsulting.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Does the same thing here.
Sounds like a serious problem to me too.
Greg
On Wed, 2002-03-20 at 20:46, Bruce Momjian wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
From | Date | Subject | |
---|---|---|---|
Next Message | Neil Conway | 2002-03-21 04:55:42 | Re: [GENERAL] Notify argument? |
Previous Message | Bruce Momjian | 2002-03-21 02:46:11 | Function call crashes server |