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 <[EMAIL PROTECTED]> 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/
