Re: [Pgbuildfarm-members] CREATE FUNCTION hang on test machine polecat on HEAD
От | Robert Creager |
---|---|
Тема | Re: [Pgbuildfarm-members] CREATE FUNCTION hang on test machine polecat on HEAD |
Дата | |
Msg-id | 9A0F9A76-DF19-49E6-9506-2876614A7734@Oracle.com обсуждение исходный текст |
Ответ на | Re: [Pgbuildfarm-members] CREATE FUNCTION hang on test machine polecat on HEAD (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | 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
Вложения
В списке pgsql-hackers по дате отправления:
Следующее
От: Alvaro HerreraДата:
Сообщение: Re: Re: starting to review the Extend NOT NULL representation to pg_constraint patch