From owner-freebsd-ports-bugs@FreeBSD.ORG Sun Mar 16 00:30:03 2008 Return-Path: Delivered-To: freebsd-ports-bugs@hub.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 0D7971065671 for ; Sun, 16 Mar 2008 00:30:03 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [IPv6:2001:4f8:fff6::28]) by mx1.freebsd.org (Postfix) with ESMTP id EEDD08FC24 for ; Sun, 16 Mar 2008 00:30:02 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (gnats@localhost [127.0.0.1]) by freefall.freebsd.org (8.14.2/8.14.2) with ESMTP id m2G0U2JJ087844 for ; Sun, 16 Mar 2008 00:30:02 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.2/8.14.1/Submit) id m2G0U2F9087837; Sun, 16 Mar 2008 00:30:02 GMT (envelope-from gnats) Resent-Date: Sun, 16 Mar 2008 00:30:02 GMT Resent-Message-Id: <200803160030.m2G0U2F9087837@freefall.freebsd.org> Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer) Resent-To: freebsd-ports-bugs@FreeBSD.org Resent-Reply-To: FreeBSD-gnats-submit@FreeBSD.org, "Samuel J. Greear" Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 44FBB106566B for ; Sun, 16 Mar 2008 00:29:53 +0000 (UTC) (envelope-from nobody@FreeBSD.org) Received: from www.freebsd.org (www.freebsd.org [IPv6:2001:4f8:fff6::21]) by mx1.freebsd.org (Postfix) with ESMTP id 44B0C8FC15 for ; Sun, 16 Mar 2008 00:29:53 +0000 (UTC) (envelope-from nobody@FreeBSD.org) Received: from www.freebsd.org (localhost [127.0.0.1]) by www.freebsd.org (8.14.2/8.14.2) with ESMTP id m2G0QTS9080982 for ; Sun, 16 Mar 2008 00:26:29 GMT (envelope-from nobody@www.freebsd.org) Received: (from nobody@localhost) by www.freebsd.org (8.14.2/8.14.1/Submit) id m2G0QT2A080981; Sun, 16 Mar 2008 00:26:29 GMT (envelope-from nobody) Message-Id: <200803160026.m2G0QT2A080981@www.freebsd.org> Date: Sun, 16 Mar 2008 00:26:29 GMT From: "Samuel J. Greear" To: freebsd-gnats-submit@FreeBSD.org X-Send-Pr-Version: www-3.1 Cc: Subject: ports/121745: PostgreSQL contrib ossp-uuid crashes backend X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 16 Mar 2008 00:30:03 -0000 >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: