Re: [Pgbuildfarm-members] CREATE FUNCTION hang on test machine polecat on HEAD - Mailing list pgsql-hackers

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)
returnsvoid 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=<valuetemporarily 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

--


Robert Creager, Principal Software Engineer
Oracle Server Technologies
500 Eldorado Blvd, Bldg 5
Broomfield, CO, 80021
Phone: 303-272-6830
Email: Robert.Creager@Oracle.com

Oracle is committed to developing practices and products that help protect the environment