The following bug has been logged online: Bug reference: 3422 Logged by: Holger Schurig Email address: [EMAIL PROTECTED] PostgreSQL version: PostgreSQL 8.3d Operating system: Linux Description: Segmentation violation in PL/pgSQL Details:
PostgreSQL CVS from today Skytools (http://pgfoundry.org/scm/?group_id=1000206) from today After "make" && "make install" of PostgreSQL, I set PGDATA, run "initdb" without any parameters. Then, in skytools, I do "configure". Because I'm just interested in PyQ, I change the SUBDIRS variable in skytools/sql/Makefile to only contain "pgq pgq_ext txid". After this, I run "make" && "make install". Now I run "postgres -d5" (standard postgresql.conf file from initdb). In skytools/sql/pgdb I run "make test". Now I can observe a segmentation violation. The last lines of the "-d5" output are: DEBUG: plan: DETAIL: {PLANNEDSTMT :commandType 1 :canSetTag true :planTree {MERGEJOIN :startup_cost 124.66 :total_cost 204.66 :plan_rows 25 :plan_width 8 :targetlist ({TARGETENTRY :expr {VAR :varno 65001 :varattno 1 :vartype 20 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} :resno 1 :resname id1 :ressortgroupref 1 :resorigtbl 0 :resorigcol 0 :resjunk false}) :qual ({NULLTEST :arg {VAR :varno 65000 :varattno 1 :vartype 20 :vartypmod -1 :varlevelsup 0 :varnoold 2 :varoattno 1} :nulltesttype 0}) :lefttree {SORT :startup_cost 62.33 :total_cost 64.83 :plan_rows 1000 :plan_width 8 :targetlist ({TARGETENTRY :expr {VAR :varno 65001 :varattno 1 :vartype 20 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} :resno 1 :resname <> :ressortgroupref 0 :resorigtbl 0 :resorigcol 0 :resjunk false}) :qual <> :lefttree {FUNCTIONSCAN :startup_cost 0.00 :total_cost 12.50 :plan_rows 1000 :plan_width 8 :targetlist ({TARGETENTRY :expr {VAR :varno 1 :varattno 1 :vartype 20 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} :resno 1 :resname <> :ressortgroupref 0 :resorigtbl 0 :resorigcol 0 :resjunk false}) :qual <> :lefttree <> :righttree <> :initPlan <> :extParam (b) :allParam (b) :scanrelid 1 :funcexpr {FUNCEXPR :funcid 41492 :funcresulttype 20 :funcretset true :funcformat 0 :args ({PARAM :paramkind 0 :paramid 1 :paramtype 41484 :paramtypmod -1})} :funccolnames ("id1") :funccoltypes <> :funccoltypmods <>} :righttree <> :initPlan <> :extParam (b) :allParam (b) :numCols 1 :sortColIdx 1 :sortOperators 413 :nullsFirst true} :righttree {SORT :startup_cost 62.33 :total_cost 64.83 :plan_rows 1000 :plan_width 8 :targetlist ({TARGETENTRY :expr {VAR :varno 65001 :varattno 1 :vartype 20 :vartypmod -1 :varlevelsup 0 :varnoold 2 :varoattno 1} :resno 1 :resname <> :ressortgroupref 0 :resorigtbl 0 :resorigcol 0 :resjunk false}) :qual <> :lefttree {FUNCTIONSCAN :startup_cost 0.00 :total_cost 12.50 :plan_rows 1000 :plan_width 8 :targetlist ({TARGETENTRY :expr {VAR :varno 2 :varattno 1 :vartype 20 :vartypmod -1 :varlevelsup 0 :varnoold 2 :varoattno 1} :resno 1 :resname <> :ressortgroupref 0 :resorigtbl 0 :resorigcol 0 :resjunk false}) :qual <> :lefttree <> :righttree <> :initPlan <> :extParam (b) :allParam (b) :scanrelid 2 :funcexpr {FUNCEXPR :funcid 41492 :funcresulttype 20 :funcretset true :funcformat 0 :args ({PARAM :paramkind 0 :paramid 2 :paramtype 41484 :paramtypmod -1})} :funccolnames ("id2") :funccoltypes <> :funccoltypmods <>} :righttree <> :initPlan <> :extParam (b) :allParam (b) :numCols 1 :sortColIdx 1 :sortOperators 413 :nullsFirst true} :initPlan <> :extParam (b) :allParam (b) :jointype 1 :joinqual <> :mergeclauses ({OPEXPR :opno 410 :opfuncid 467 :opresulttype 16 :opretset false :args ({VAR :varno 65001 :varattno 1 :vartype 20 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} {VAR :varno 65000 :varattno 1 :vartype 20 :vartypmod -1 :varlevelsup 0 :varnoold 2 :varoattno 1})}) :mergeFamilies 1976 :mergeStrategies 5 :mergeNullsFirst 1} :rtable ({RTE :alias {ALIAS :aliasname id1 :colnames <>} :eref {ALIAS :aliasname id1 :colnames ("id1")} :rtekind 4 :funcexpr <> :funccoltypes <> :funccoltypmods <> :inh false :inFromCl true :requiredPerms 2 :checkAsUser 0} {RTE :alias {ALIAS :aliasname id2 :colnames <>} :eref {ALIAS :aliasname id2 :colnames ("id2")} :rtekind 4 :funcexpr <> :funccoltypes <> :funccoltypmods <> :inh false :inFromCl true :requiredPerms 2 :checkAsUser 0} {RTE :alias <> :eref {ALIAS :aliasname unnamed_join :colnames ("id1" "id2")} :rtekind 2 :jointype 1 :joinaliasvars <> :inh false :inFromCl true :requiredPerms 2 :checkAsUser 0}) :resultRelations <> :utilityStmt <> :intoClause <> :subplans <> :rewindPlanIDs (b) :returningLists <> :rowMarks <> :nParamExec 0} CONTEXT: SQL statement " select id1 from get_snapshot_active( $1 ) id1 left join get_snapshot_active( $2 ) id2 on (id1 = id2) where id2 is null order by 1 desc" PL/pgSQL function "batch_event_sql" line 66 at for over select rows PL/pgSQL function "get_batch_events" line 17 at assignment DEBUG: reaping dead processes DEBUG: server process (PID 19148) was terminated by signal 11: Segmentation fault LOG: server process (PID 19148) was terminated by signal 11: Segmentation fault LOG: terminating any other active server processes DEBUG: sending SIGQUIT to process 19095 DEBUG: sending SIGQUIT to process 19097 DEBUG: sending SIGQUIT to process 19096 DEBUG: reaping dead processes DEBUG: reaping dead processes LOG: all server processes terminated; reinitializing ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
