My favorites | Sign in
Project Home Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 3: PostgreSQL Crashes when select uuid()
1 person starred this issue and may be notified of changes. Back to list
Status:  New
Owner:  ----


 
Reported by afra...@gmail.com, Nov 14, 2007
When doing a "SELECT uuid()", PostgreSQL crashes as shown below:

1. psql -U postgres demo -f uuid.sql
psql:uuid.sql:4: ERROR:  type "uuid" does not exist
CREATE TYPE
psql:uuid.sql:11: NOTICE:  return type uuid is only a shell
CREATE FUNCTION
psql:uuid.sql:14: NOTICE:  argument type uuid is only a shell
CREATE FUNCTION
CREATE TYPE
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
...
CREATE CAST

2. psql -U postgres demo
demo=# select uuid();
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.

Postgres Serverlog:
LOG:  PGR_Create_Socket_Connect(): FAIL 5
LOG:  server process (PID 29292) was terminated by signal 11
LOG:  terminating any other active server processes
FATAL:  the database system is in recovery mode

Oddly enough, if I do this:
demo=# CREATE table test (id uuid, f int);
CREATE TABLE
demo=# INSERT INTO test (id, f) VALUES (uuid(), 2);
INSERT 0 1
demo=# INSERT INTO test (id, f) VALUES (uuid(), 6);
INSERT 0 1
demo=# select * from test;
                  id                  | f 
--------------------------------------+---
 0b648c8e-c508-48cf-844b-fab5e1cf203d | 2
 94759fd6-1663-418b-b04d-fdab7f4d8973 | 6
(2 rows)

demo=# select uuid();
                 uuid                 
--------------------------------------
 8dbb94ec-a82d-4e84-b7f2-8856985397ed
(1 row)

So it works but only for the current session (it will crash again). 

What version of the product are you using? On what operating system?

8.2.4 on Debian Etch

 
Nov 14, 2007
#1 afra...@gmail.com
I apologize for this issue - this is an issue which was due to replication. 

Powered by Google Project Hosting