Got another one (no env since the last changes). I'll try and run the "kept" install from when I killed 22853 (had to use -9) to see if it reproduces the problem with the same binaries. Is there interest in me removing the perl in /opt/local/bin/perl? I can install ccache elsewhere and rename that directory.
502 310 1 0 0:00.09 ?? 0:00.14
/Library/PostgreSQL/8.3/bin/postgres -D /Library/PostgreSQL/8.3/data
502 313 310 0 0:00.36 ?? 0:00.51 postgres: logger process
502 315 310 0 0:01.10 ?? 0:02.43 postgres: writer process
502 316 310 0 0:01.03 ?? 0:01.62 postgres: wal writer process
502 317 310 0 0:00.28 ?? 0:00.40 postgres: autovacuum
launcher process
502 318 310 0 0:00.29 ?? 0:00.33 postgres: stats collector
process
501 22813 1 0 0:00.29 ?? 0:00.38 /Volumes/High
Usage/usr/local/src/build-farm-4.4/builds/HEAD/inst/bin/postgres -D data-C
501 22815 22813 0 0:00.57 ?? 0:01.31 postgres: writer process
501 22816 22813 0 0:00.53 ?? 0:00.85 postgres: wal writer process
501 22817 22813 0 0:00.28 ?? 0:00.65 postgres: autovacuum
launcher process
501 22818 22813 0 0:01.19 ?? 0:01.47 postgres: stats collector
process
501 22853 22813 0 78:13.79 ?? 89:26.32 postgres: Robert
pl_regression [local] CREATE FUNCTION
Robert:/usr/local/src/build-farm-4.4/builds/HEAD
% gdb inst/bin/postgres 22853
GNU gdb 6.3.50-20050815 (Apple version gdb-1518) (Sat Feb 12 02:52:12 UTC 2011)
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 "x86_64-apple-darwin"...Reading symbols for shared
libraries ...... done
/Volumes/High Usage/usr/local/src/build-farm-4.4/builds/HEAD/22853: No such
file or directory
Attaching to program: `/Volumes/High
Usage/usr/local/src/build-farm-4.4/builds/HEAD/inst/bin/postgres', process
22853.
Reading symbols for shared libraries .+++++......... done
0x0000000100a505e4 in Perl_get_hash_seed ()
(gdb) bt
#0 0x0000000100a505e4 in Perl_get_hash_seed ()
#1 0x0000000100a69b94 in perl_parse ()
#2 0x00000001007c0680 in plperl_init_interp () at plperl.c:781
#3 0x00000001007c117a in _PG_init () at plperl.c:443
#4 0x0000000100304396 in internal_load_library (libname=0x10100d540
"/Volumes/High
Usage/usr/local/src/build-farm-4.4/builds/HEAD/inst/lib/postgresql/plperl.so")
at dfmgr.c:284
#5 0x0000000100304ce5 in load_external_function (filename=<value temporarily
unavailable, due to optimizations>, funcname=0x10100d508 "plperl_validator",
signalNotFound=1 '\001', filehandle=0x7fff5fbfd3b8) at dfmgr.c:113
#6 0x0000000100307200 in fmgr_info_C_lang [inlined] () at /Volumes/High
Usage/usr/local/src/build-farm-4.4/builds/HEAD/pgsql.4091/src/backend/utils/fmgr/fmgr.c:349
#7 0x0000000100307200 in fmgr_info_cxt_security (functionId=41362,
finfo=0x7fff5fbfd410, mcxt=<value temporarily unavailable, due to
optimizations>, ignore_security=<value temporarily unavailable, due to
optimizations>) at fmgr.c:280
#8 0x00000001003083f0 in OidFunctionCall1Coll (functionId=<value temporarily
unavailable, due to optimizations>, collation=0, arg1=41430) at fmgr.c:1585
#9 0x000000010009f58d in ProcedureCreate (procedureName=0x1010064d0
"perl_elog", procNamespace=2200, replace=1 '\001', returnsSet=0 '\0',
returnType=2278, languageObjectId=41363, languageValidator=41362,
prosrc=0x101006958 "\n\n my $msg = shift;\n elog(NOTICE,$msg);\n\n",
probin=0x0, isAgg=0 '\0', isWindowFunc=0 '\0', security_definer=0 '\0',
isStrict=0 '\0', volatility=118 'v', parameterTypes=0x10100d7d8,
allParameterTypes=0, parameterModes=0, parameterNames=0, parameterDefaults=0x0,
proconfig=0, procost=100, prorows=0) at pg_proc.c:653
#10 0x0000000100105aae in CreateFunction (stmt=0x101006ab8,
queryString=0x101005a38 "create or replace function perl_elog(text) returns
void language plperl as $$\n\n my $msg = shift;\n elog(NOTICE,$msg);\n\n$$;")
at functioncmds.c:942
#11 0x000000010023839b in MemoryContextSwitchTo [inlined] () at /Volumes/High
Usage/usr/local/src/build-farm-4.4/builds/HEAD/pgsql.4091/src/include/utils/palloc.h:1184
#12 0x000000010023839b in PortalRunUtility (portal=0x101027238,
utilityStmt=0x101006ab8, isTopLevel=<value temporarily unavailable, due to
optimizations>, dest=0x101006e60, completionTag=0x7fff5fbfdea0 "") at
pquery.c:1192
#13 0x0000000100239b55 in PortalRunMulti (portal=0x101027238, isTopLevel=<value
temporarily unavailable, due to optimizations>, dest=0x101006e60,
altdest=0x101006e60, completionTag=0x7fff5fbfdea0 "") at pquery.c:1315
#14 0x000000010023a508 in PortalRun (portal=0x101027238,
count=9223372036854775807, isTopLevel=<value temporarily unavailable, due to
optimizations>, dest=0x101006e60, altdest=0x101006e60,
completionTag=0x7fff5fbfdea0 "") at pquery.c:813
#15 0x00000001002364bd in exec_simple_query (query_string=0x101005a38 "create
or replace function perl_elog(text) returns void language plperl as $$\n\n my
$msg = shift;\n elog(NOTICE,$msg);\n\n$$;") at postgres.c:1018
#16 0x0000000100237081 in PostgresMain (argc=2, argv=<value temporarily
unavailable, due to optimizations>, username=<value temporarily unavailable,
due to optimizations>) at postgres.c:3924
#17 0x00000001001e9bbc in ServerLoop () at postmaster.c:3605
#18 0x00000001001eab37 in PostmasterMain (argc=3, argv=0x100800680) at
postmaster.c:1120
#19 0x000000010017db45 in main (argc=3, argv=0x100800680) at main.c:199
--
<<inline: oracle_sig_logo.gif>>
Robert Creager, Principal Software Engineer Oracle Server Technologies 500 Eldorado Blvd, Bldg 5 Broomfield, CO, 80021 Phone: 303-272-6830 Email: robert.crea...@oracle.com
<<inline: green-for-email-sig_0.gif>>
Oracle is committed to developing practices and products that help protect the environment
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
