Re: [BUGS] select cash_out('2'); crashes backend on 7.0.2 - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [BUGS] select cash_out('2'); crashes backend on 7.0.2
Date
Msg-id 200101241434.JAA16483@candle.pha.pa.us
Whole thread Raw
List pgsql-hackers
Folks, I see we have many problems here:test=> select textout(2);pqReadData() -- backend closed the channel
unexpectedly.       This probably means the backend terminated abnormally        before or while processing the
request.Theconnection to the server was lost. Attempting reset: NOTICE: Message from PostgreSQL backend:        The
Postmasterhas informed me that some other backend died        abnormally and possibly corrupted shared memory.        I
haverolled back the current transaction and am going to        terminate your database system connection and exit.
 Please reconnect to the database system and repeat your query.Failed.
 

and the server log shows:
Reinitializing shared memory and semaphores

Seems like a pretty serious denial of service attack to me.  It restarts
all running backends.

I have aligned the error messages, at least.


> 
> Hello,
> 
>  I was just experimenting, trying to see if I could find a function that
> would format a numeric value like 'money' with Postgres 7.0.2. Here's
> what happened:
> 
> ######
> cascade=> select cash_out(2);
> pqReadData() -- backend closed the channel unexpectedly.
>         This probably means the backend terminated abnormally
>         before or while processing the request.
> We have lost the connection to the backend, so further processing is
> impossible.  Terminating.
> ######
> 
> The same thing happened with Postgres 6.5.3. Here's my full version:
> PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc 2.96 
> 
> I'm sure if what I tried is even valid input, but I'm guessing this is
> not a desired result in any case. :) 
> 
> Thanks for the great software and good luck with this!
> 
> A frequent Postgres user,
> 
>   -mark
> 
> personal website             }      Summersault Website Development
> http://mark.stosberg.com/    {      http://www.summersault.com/
> 


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


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: unixODBC again :-(
Next
From: Bruce Momjian
Date:
Subject: Re: Open 7.1 items