The following bug has been logged online:
Bug reference: 3841
Logged by: Dmitriy
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.beta4
Operating system: FreeBSD 6.2-RELEASE
Description: core dump in uuid-ossp
Details:
in sql console:
postgres=# select uuid_nil();
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
on server console:
LOG: server process (PID 41258) was terminated by signal 11: Segmentation
fault
LOG: terminating any other active server processes
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server pro.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
LOG: all server processes terminated; reinitializing
LOG: database system was interrupted; last known up at 2007-12-27 11:53:03
IRKT
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: redo starts at 0/43FEA4
LOG: record with zero length at 0/447C94
LOG: redo done at 0/447C68
LOG: last completed transaction was at log time 2007-12-27
11:53:37.354834+08
gdb:
[EMAIL PROTECTED] ~/data]$ gdb ../bin/postgres postgres.core
GNU gdb 6.1.1 [FreeBSD]
Copyright 2004 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you
are
welcome to change it and/or distribute copies of it under certain
conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB. Type "show warranty" for details.
This GDB was configured as "i386-marcel-freebsd"...
Core was generated by `postgres'.
Program terminated with signal 11, Segmentation fault.
Reading symbols from /usr/local/lib/libxslt.so.2...done.
Loaded symbols for /usr/local/lib/libxslt.so.2
Reading symbols from /usr/local/lib/libxml2.so.5...done.
Loaded symbols for /usr/local/lib/libxml2.so.5
Reading symbols from /usr/lib/libpam.so.3...done.
Loaded symbols for /usr/lib/libpam.so.3
Reading symbols from /lib/libcrypt.so.3...done.
Loaded symbols for /lib/libcrypt.so.3
Reading symbols from /lib/libm.so.4...done.
Loaded symbols for /lib/libm.so.4
Reading symbols from /lib/libc.so.6...done.
Loaded symbols for /lib/libc.so.6
Reading symbols from /lib/libz.so.3...done.
Loaded symbols for /lib/libz.so.3
Reading symbols from /usr/local/lib/libiconv.so.3...done.
Loaded symbols for /usr/local/lib/libiconv.so.3
Reading symbols from /usr/local/pgsql/lib/uuid-ossp.so...done.
Loaded symbols for /usr/local/pgsql/lib/uuid-ossp.so
Reading symbols from /libexec/ld-elf.so.1...done.
Loaded symbols for /libexec/ld-elf.so.1
#0 0x2a5d5cd8 in uuid_import () from /usr/local/pgsql/lib/uuid-ossp.so
(gdb) bt
#0 0x2a5d5cd8 in uuid_import () from /usr/local/pgsql/lib/uuid-ossp.so
#1 0x2a5d67d2 in uuid_load () from /usr/local/pgsql/lib/uuid-ossp.so
#2 0x2a5d57aa in special_uuid_value (name=0x2a5dafa4 "nil") at
uuid-ossp.c:95
#3 0x08141c34 in ExecMakeFunctionResult (fcache=0x1100bc8c, econtext=Cannot
access memory at address 0xe89d9715
) at execQual.c:1351
Cannot access memory at address 0xe89d970d
(gdb) Quit
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
