Date: Sun, 16 Mar 2008 00:26:29 GMT From: "Samuel J. Greear" <freebsd-pr@evilcode.net> To: freebsd-gnats-submit@FreeBSD.org Subject: ports/121745: PostgreSQL contrib ossp-uuid crashes backend Message-ID: <200803160026.m2G0QT2A080981@www.freebsd.org> Resent-Message-ID: <200803160030.m2G0U2F9087837@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>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@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:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200803160026.m2G0QT2A080981>