BUG #8353: Core dump with uuid-ossp on FreeBSD 9,2 - Mailing list pgsql-bugs

The following bug has been logged on the website:

Bug reference:      8353
Logged by:          Mark Badolato
Email address:      mbadolato@gmail.com
PostgreSQL version: 9.2.4
Operating system:   FreeBSD 9.2
Description:

I saw a similar issue to this in the mailing list from back in 2007 (BUG
#3841).  It seems that there are still issues with uuid on FreeBSD.


I tried executing both select uuid_nil(); and select uuid_generate_v4();
Both cause a long delay then lose connection, and result in a core file.


This is happening on all of our FreeBSD machines (all v9.2). I tried on both
AMD and Intel procs, and in a virtual (on the AMD) and bare metal (xeon).


This is working with no problems on my Postgres install on my Mac (10.8),
installed from the binary distribution.


psql (9.2.4)
Type "help" for help.


cms=# select uuid_generate_v4();
The connection to the server was lost. Attempting reset: Failed.
!> quit


Looking at gdb doesn't really look like it's producing anything useful,
though I admit I'm not adept at doing anything with gdb.


# gdb /usr/local/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 "amd64-marcel-freebsd"...(no debugging symbols
found)...
Core was generated by `postgres'.
Program terminated with signal 10, Bus error.
Reading symbols from /usr/local/lib/libintl.so.9...(no debugging symbols
found)...done.
Loaded symbols for /usr/local/lib/libintl.so.9
Reading symbols from /usr/local/lib/libxml2.so.5...(no debugging symbols
found)...done.
Loaded symbols for /usr/local/lib/libxml2.so.5
Reading symbols from /usr/lib/libssl.so.6...(no debugging symbols
found)...done.
Loaded symbols for /usr/lib/libssl.so.6
Reading symbols from /lib/libcrypto.so.6...(no debugging symbols
found)...done.
Loaded symbols for /lib/libcrypto.so.6
Reading symbols from /lib/libm.so.5...(no debugging symbols found)...done.
Loaded symbols for /lib/libm.so.5
Reading symbols from /lib/libc.so.7...(no debugging symbols found)...done.
Loaded symbols for /lib/libc.so.7
Reading symbols from /usr/local/lib/libiconv.so.3...(no debugging symbols
found)...done.
Loaded symbols for /usr/local/lib/libiconv.so.3
Reading symbols from /lib/libz.so.6...(no debugging symbols found)...done.
Loaded symbols for /lib/libz.so.6
Reading symbols from /usr/lib/liblzma.so.5...(no debugging symbols
found)...done.
Loaded symbols for /usr/lib/liblzma.so.5
Reading symbols from /usr/local/lib/postgresql/uuid-ossp.so...(no debugging
symbols found)...done.
Loaded symbols for /usr/local/lib/postgresql/uuid-ossp.so
Reading symbols from /lib/libthr.so.3...(no debugging symbols
found)...done.
Loaded symbols for /lib/libthr.so.3
Reading symbols from /libexec/ld-elf.so.1...(no debugging symbols
found)...done.
Loaded symbols for /libexec/ld-elf.so.1
#0  0x000000080251d546 in uuid_make () from
/usr/local/lib/postgresql/uuid-ossp.so
[New Thread 802922800 (LWP 100161/postgres)]
(gdb)