ports/121745: PostgreSQL contrib ossp-uuid crashes backend

[Samuel J. Greear]

>Number:         121745
>Category:       ports
>Synopsis:       PostgreSQL contrib ossp-uuid crashes backend
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Sun Mar 16 00:30:02 UTC 2008
>Closed-Date:
>Last-Modified:
>Originator:     Samuel J. Greear
>Release:        7.0-RELEASE
>Organization:
Evilcode Corporation
>Environment:
FreeBSD dev1.in.flixn.com 7.0-RELEASE FreeBSD 7.0-RELEASE #0: Sun Feb 24 19:59:52 UTC 2008     root at logan.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC  i386

>Description:
#0  0x28960bf0 in uuid_make_v1 (uuid=0xf58f3e57, mode=1, ap=0xbfbfe308 "") at uuid.c:897
897             if (!(   time_now.tv_sec  == uuid->time_last.tv_sec
[New Thread 0x28a01100 (LWP 100116)]
(gdb) bt
#0  0x28960bf0 in uuid_make_v1 (uuid=0xf58f3e57, mode=1, ap=0xbfbfe308 "") at uuid.c:897
#1  0x28961441 in uuid_make (uuid=0xf58f3e57, mode=1) at uuid.c:1195
#2  0x2895ee71 in uuid_generate_internal (mode=1, ns=0x0, name=0x0) at uuid-ossp.c:176
#3  0x2895eef2 in uuid_generate_v1 (fcinfo=0xbfbfe388) at uuid-ossp.c:191
#4  0x08193306 in ExecMakeFunctionResult (fcache=0x28ae62b8, econtext=0x28ae6230, isNull=0x28ae6918 "", isDone=0x28ae6928) at execQual.c:1351
#5  0x08193b49 in ExecEvalFunc (fcache=0x28ae62b8, econtext=0x28ae6230, isNull=0x28ae6918 "", isDone=0x28ae6928) at execQual.c:1753
#6  0x08199253 in ExecTargetList (targetlist=0x28ae66d0, econtext=0x28ae6230, values=0x28ae6908, isnull=0x28ae6918 "", itemIsDone=0x28ae6928,
    isDone=0xbfbfe6a0) at execQual.c:4601
#7  0x08199670 in ExecProject (projInfo=0x28ae6808, isDone=0xbfbfe6a0) at execQual.c:4802
#8  0x081a6dea in ExecResult (node=0x28ae61a8) at nodeResult.c:155
#9  0x08190e59 in ExecProcNode (node=0x28ae61a8) at execProcnode.c:319
#10 0x0818eb05 in ExecutePlan (estate=0x28ae6018, planstate=0x28ae61a8, operation=CMD_SELECT, numberTuples=0, direction=ForwardScanDirection,
    dest=0x28a96dd8) at execMain.c:1233
#11 0x0818d6a4 in ExecutorRun (queryDesc=0x28adb868, direction=ForwardScanDirection, count=0) at execMain.c:267
#12 0x08255264 in PortalRunSelect (portal=0x28ae1018, forward=1 '\001', count=0, dest=0x28a96dd8) at pquery.c:943
#13 0x08254f6a in PortalRun (portal=0x28ae1018, count=2147483647, isTopLevel=1 '\001', dest=0x28a96dd8, altdest=0x28a96dd8, completionTag=0xbfbfe8fa "")
    at pquery.c:769
#14 0x0824f84e in exec_simple_query (query_string=0x28a96018 "SELECT uuid_generate_v1();") at postgres.c:963
#15 0x082536dc in PostgresMain (argc=4, argv=0x28a32448, username=0x28a32428 "flixn") at postgres.c:3530
#16 0x0821cf0c in BackendRun (port=0x28a07400) at postmaster.c:3207
#17 0x0821c420 in BackendStartup (port=0x28a07400) at postmaster.c:2830
#18 0x08219e62 in ServerLoop () at postmaster.c:1274
#19 0x08219835 in PostmasterMain (argc=3, argv=0xbfbfed74) at postmaster.c:1029
#20 0x081bab25 in main (argc=3, argv=0xbfbfed74) at main.c:188


Pg uuid-ossp module is perhaps using the wrong uuid_t definition?
>How-To-Repeat:
Install misc/ossp-uuid. Install databases/postgresql83-server, install databases/postgresql-contrib (may need extra configure line --with-ossp-uuid). 

Add uuid functions to a database as per: http://www.postgresql.org/docs/current/static/contrib.html

Call any of the uuid functions as per: http://www.postgresql.org/docs/current/static/uuid-ossp.html
>Fix:


>Release-Note:
>Audit-Trail:
>Unformatted: