Skip site navigation (1) Skip section navigation (2)

executing SELECT xmlelement(name foo); causes "server closed the connection unexpectedly" Error

From: Sushil <sdive(at)vertex(dot)co(dot)in>
To: pgsql-bugs(at)postgresql(dot)org
Subject: executing SELECT xmlelement(name foo); causes "server closed the connection unexpectedly" Error
Date: 2008-04-20 12:33:11
Message-ID: 480B3807.7020605@vertex.co.in (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi,

I am trying to exploit XML features of PostgreSQL 8.3.0 DB.

I tried executing following query:

SELECT xmlelement(name foo);

from psql prompt.

I received Following error on screen:

server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!>

Environment details are:

OS: *CentOS release 5 (Final)*
DB: *PostgreSQL 8.3.0*

Following is DB server log when the query was submitted:

DEBUG:  forked new backend, pid=4411 socket=8
LOG:  connection received: host=[local]
LOG:  connection authorized: user=postgres database=testdb
DEBUG:  postmaster child[4411]: starting with (
DEBUG:          postgres
DEBUG:          -v196608
DEBUG:          -y
DEBUG:          testdb
DEBUG:  )
DEBUG:  InitPostgres
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, 
xid/subid/cid: 0/1/0, nestlvl: 1, children: <>
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, 
xid/subid/cid: 0/1/0, nestlvl: 1, children: <>
DEBUG:  StartTransactionCommand
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, 
xid/subid/cid: 0/1/0, nestlvl: 1, children: <>
LOG:  statement: SELECT xmlelement(name foo);
DEBUG:  parse tree:
DETAIL:  {QUERY :commandType 1 :querySource 0 :canSetTag true 
:utilityStmt <>
        :resultRelation 0 :intoClause <> :hasAggs false :hasSubLinks 
false :rtable <>
        :jointree {FROMEXPR :fromlist <> :quals <>} :targetList 
({TARGETENTRY :expr
        {XMLEXPR :op 1 :name foo :named_args <> :arg_names <> :args <> 
:xmloption 0
        :type 0 :typmod 0} :resno 1 :resname xmlelement :ressortgroupref 
0 :resorigtbl
        0 :resorigcol 0 :resjunk false}) :returningList <> :groupClause 
<> :havingQual
        <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount 
<> :rowMarks
        <> :setOperations <>}

DEBUG:  rewritten parse tree:
DETAIL:  ({QUERY :commandType 1 :querySource 0 :canSetTag true 
:utilityStmt <>
        :resultRelation 0 :intoClause <> :hasAggs false :hasSubLinks 
false :rtable <>
        :jointree {FROMEXPR :fromlist <> :quals <>} :targetList 
({TARGETENTRY :expr
        {XMLEXPR :op 1 :name foo :named_args <> :arg_names <> :args <> 
:xmloption 0
        :type 0 :typmod 0} :resno 1 :resname xmlelement :ressortgroupref 
0 :resorigtbl
        0 :resorigcol 0 :resjunk false}) :returningList <> :groupClause 
<> :havingQual
        <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount 
<> :rowMarks
        <> :setOperations <>})

DEBUG:  plan:
DETAIL:  {PLANNEDSTMT :commandType 1 :canSetTag true :planTree {RESULT 
:startup_cost
        0.00 :total_cost 0.01 :plan_rows 1 :plan_width 0 :targetlist 
({TARGETENTRY
        :expr {XMLEXPR :op 1 :name foo :named_args <> :arg_names <> :args <>
        :xmloption 0 :type 0 :typmod 0} :resno 1 :resname xmlelement 
:ressortgroupref
        0 :resorigtbl 0 :resorigcol 0 :resjunk false}) :qual <> :lefttree <>
        :righttree <> :initPlan <> :extParam (b) :allParam (b) 
:resconstantqual <>}
        :rtable <> :resultRelations <> :utilityStmt <> :intoClause <> 
:subplans <>
        :rewindPlanIDs (b) :returningLists <> :rowMarks <> :relationOids <>
        :nParamExec 0}

*postgres: postgres testdb [local] SELECT: symbol lookup error: 
postgres: postgres testdb [local] SELECT: undefined symbol: 
xmlNewTextWriterMemory*
DEBUG:  reaping dead processes
DEBUG:  server process (PID 4411) exited with exit code 127
LOG:  server process (PID 4411) exited with exit code 127
LOG:  terminating any other active server processes
DEBUG:  sending SIGQUIT to process 4401
DEBUG:  sending SIGQUIT to process 4402
DEBUG:  sending SIGQUIT to process 4403
DEBUG:  sending SIGQUIT to process 4404
LOG:  all server processes terminated; reinitializing
DEBUG:  shmem_exit(0)
DEBUG:  invoking IpcMemoryCreate(size=39288832)
DEBUG:  reaping dead processes
LOG:  database system was interrupted; last known up at 2008-11-20 
03:48:07 EST
LOG:  connection received: host=[local]
FATAL:  the database system is in recovery mode
DEBUG:  checkpoint record is at 0/367B0468
DEBUG:  redo record is at 0/367B0468; shutdown TRUE
DEBUG:  next transaction ID: 0/682118; next OID: 81920
DEBUG:  next MultiXactId: 1; next MultiXactOffset: 0
LOG:  database system was not properly shut down; automatic recovery in 
progress
DEBUG:  proc_exit(1)
DEBUG:  shmem_exit(1)
DEBUG:  forked new backend, pid=4413 socket=8
DEBUG:  exit(1)
DEBUG:  reaping dead processes
DEBUG:  server process (PID 4413) exited with exit code 1
LOG:  record with zero length at 0/367B04B0
LOG:  redo is not required
DEBUG:  transaction ID wrap limit is 2147484025, limited by database 
"template1"
DEBUG:  proc_exit(0)
DEBUG:  shmem_exit(0)
DEBUG:  exit(0)
DEBUG:  reaping dead processes
LOG:  autovacuum launcher started
LOG:  database system is ready to accept connections

The server appeared as crashed and got restarted.

Seek your help to have this issue fixed.

Thanks,
Sushil

The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy the original message all copies of this message and any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.

Please do not print this email unless it is absolutely necessary.

Attachment: sdive.vcf
Description: text/x-vcard (216 bytes)

Responses

pgsql-bugs by date

Next:From: Sam MasonDate: 2008-04-20 13:38:42
Subject: Re: Inconsistent shift operator
Previous:From: Daniel RuosoDate: 2008-04-19 21:52:00
Subject: Re: BUG #4115: PostgreSQL ISO format is not really ISO

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group