
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/

Wed, 06 Dec 2000 15:06:07 -0500
Mark Stosberg <mark@summersault.com>
select cash_out('2');  crashes backend on 7.0.2
I can confirm this is crashes in 7.1 too.

> 
> 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, Pennsylvania 19026

Tue, 12 Dec 2000 11:22:29 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: select cash_out('2');  crashes backend on 7.0.2
Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> cascade=> select cash_out(2);
>> pqReadData() -- backend closed the channel unexpectedly.

> I can confirm this is crashes in 7.1 too.

You can get this sort of result with almost any input or output function
:-(.  The problem is that they're mostly misdeclared to take type
"opaque", which for no good reason is also considered to mean "accepts
any input type whatever", which means you can pass a value of any type
at all to an input or output function.

There have been some past discussions about introducing a little more
rigor into the type system's handling of I/O functions, but it ain't
gonna happen for 7.1 ...

			regards, tom lane

Tue, 12 Dec 2000 15:25:47 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: select cash_out('2'); crashes backend on 7.0.2 
Added to TODO:

	* SELECT cash_out(2) crashes because of opaque 

> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> >> cascade=> select cash_out(2);
> >> pqReadData() -- backend closed the channel unexpectedly.
> 
> > I can confirm this is crashes in 7.1 too.
> 
> You can get this sort of result with almost any input or output function
> :-(.  The problem is that they're mostly misdeclared to take type
> "opaque", which for no good reason is also considered to mean "accepts
> any input type whatever", which means you can pass a value of any type
> at all to an input or output function.
> 
> There have been some past discussions about introducing a little more
> rigor into the type system's handling of I/O functions, but it ain't
> gonna happen for 7.1 ...
> 
> 			regards, tom lane
> 


-- 
  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, Pennsylvania 19026

Tue, 12 Dec 2000 15:28:05 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: select cash_out('2'); crashes backend on 7.0.2

Seems this still fails.  Hackers, does the crash cause other backends to
abort?

> 
> 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, Pennsylvania 19026

Mon, 22 Jan 2001 22:49:16 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: select cash_out('2');  crashes backend on 7.0.2
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.
	The connection to the server was lost. Attempting reset: NOTICE: 
	Message from PostgreSQL backend:
	        The Postmaster has informed me that some other backend died
	        abnormally and possibly corrupted shared memory.
	        I have rolled 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, Pennsylvania 19026

Wed, 24 Jan 2001 09:34:37 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: [BUGS] select cash_out('2');  crashes backend on 7.0.2