Mailing-List:	contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Subscribe:	<mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive:	<http://sourceware.org/ml/cygwin/>
List-Post:	<mailto:cygwin AT cygwin DOT com>
List-Help:	<mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender:	cygwin-owner AT cygwin DOT com
Mail-Followup-To:	cygwin AT cygwin DOT com
Delivered-To:	mailing list cygwin AT cygwin DOT com
Message-ID:	<20040827040129.70625.qmail@web41412.mail.yahoo.com>
Date:	Thu, 26 Aug 2004 21:01:29 -0700 (PDT)
From:	Kumar Pandey <kpandeyktm AT yahoo DOT com>
Subject:	Re: Postgres 7.4.5-1 and perl-5.8.5 -cygwin install - server crash -XP home
To:	cygwin AT cygwin DOT com
In-Reply-To:	<412E5BD2.7090807@x-ray.at>
MIME-Version:	1.0

I did a clean install from cygwin setup.exe of
Postgres 7.4.5-1 ,perl-5.8.5-3, cygrunsrv 1.0-1.
As before everything worked except for trying to
execute the perl function.
Select empcomp(employee) from employee; crashes the
database and it re-initializes.
I have cygserver running and ipc-deamon isn't running
at all.
Here's the relevent debug log from server side ----

Is there a way to get more debug/error messages?  

DEBUG:  plan:
DETAIL:  {SEQSCAN :startup_cost 0.00 :total_cost 22.50
:plan_rows 1000 :plan_width 4
        :targetlist ({TARGETENTRY :resdom {RESDOM
:resno 1 :restype 23 :restypmod -1
        :resname empcomp :ressortgroupref 0
:resorigtbl 0 :resorigcol 0 :resjunk false} :expr
{FUNCEXPR :funcid 17149 :funcresulttype 23 :funcretset
false
        :funcformat 0 :args ({VAR :varno 1 :varattno 0
:vartype 17143 :vartypmod4
        :varlevelsup 0 :varnoold 1 :varoattno 0})}})
:qual <> :lefttree <> :righ ttree
        <> :initPlan <> :extParam () :allParam ()
:nParamExec 0 :scanrelid 1}
DEBUG:  PortalRun
DEBUG:  reaping dead processes
DEBUG:  child process (PID 8168) exited with exit code
128
LOG:  server process (PID 8168) exited with exit code
128
LOG:  terminating any other active server processes
LOG:  all server processes terminated; reinitializing
DEBUG:  shmem_exit(0)
DEBUG:  invoking IpcMemoryCreate(size=9469952)
LOG:  database system was interrupted at 2004-08-26
20:41:40 PDT
LOG:  checkpoint record is at 0/A1B8E8
LOG:  redo record is at 0/A1B8E8; undo record is at
0/0; shutdown TRUE
LOG:  next transaction ID: 547; next OID: 25334
LOG:  database system was not properly shut down;
automatic recovery in progress

DEBUG:  forked new backend, pid=1944 socket=7
FATAL:  the database system is starting up
DEBUG:  proc_exit(0)
DEBUG:  shmem_exit(0)
DEBUG:  exit(0)
DEBUG:  reaping dead processes
DEBUG:  child process (PID 1944) exited with exit code
0
LOG:  record with zero length at 0/A1B928
LOG:  redo is not required
LOG:  database system is ready
DEBUG:  proc_exit(0)
DEBUG:  shmem_exit(0)
DEBUG:  exit(0)
DEBUG:  reaping dead processes

Thanks
Kumar

--- Reini Urban <rurban AT x-ray DOT at> wrote:

> Kumar Pandey schrieb:
>   > DEBUG:  PortalRun
> > DEBUG:  reaping dead processes
> > DEBUG:  child process (PID 2168) exited with exit
> code
> > 128
> > LOG:  server process (PID 2168) exited with exit
> code
> > 128
> > LOG:  terminating any other active server
> processes
> > LOG:  all server processes terminated;
> reinitializing
> > DEBUG:  shmem_exit(0)
> > DEBUG:  invoking IpcMemoryCreate(size=9469952)
> > LOG:  database system was interrupted at
> 2004-08-26
> > 11:27:23 PDT
> 
> Do you have ipc-daemon2 running? This particular
> error looks like so.
> Turn it off then.
> The new postgres builds may only use cygserver!
> -- 
> Reini Urban
> http://xarch.tu-graz.ac.at/home/rurban/
> 



		
__________________________________
Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.
http://mobile.yahoo.com/maildemo 

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

- Raw text -