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: <412F5135.4070805@x-ray.at>
Date: Fri, 27 Aug 2004 17:20:21 +0200
From: Reini Urban <rurban AT x-ray DOT at>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; de-AT; rv:1.8a2) Gecko/20040714
MIME-Version: 1.0
To: Kumar Pandey <kpandeyktm AT yahoo DOT com>
CC: cygwin AT cygwin DOT com, pgsql-cygwin AT postgresql DOT org
Subject: Re: Any working PL./Perl instance of - Postgres 7.4.5-1,perl-5.8.5 - on -XP home or Win 2000?
References: <20040827141759 DOT 81680 DOT qmail AT web41411 DOT mail DOT yahoo DOT com>
In-Reply-To: <20040827141759.81680.qmail@web41411.mail.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-IsSubscribed: yes

Kumar Pandey schrieb:
> If anyone with cygwin install of above combination
> (available from yesterday) could run the tests
> outlined below - I would very much appreciate it.
> Please post your results.
> 
> Thanks
> Kumar
> 
> Steps to install and test -
> 1) install plperl 
> 
> createlang plperl template1
> 
> 2) create test table 
> 
> CREATE TABLE employee (
>      name text,
>      basesalary integer,
>      bonus integer
>  );
> 
> 3) create test function
> 
> CREATE FUNCTION empcomp(employee) RETURNS integer AS '
>      my ($emp) = @_;
>      return $emp->{''basesalary''} +
> $emp->{''bonus''};
>  ' LANGUAGE plperl;
> 
> 4) add a test data
> insert into employee values('Sir Postgre',40,5);
>  
> 5)use perl function - database crashes for me at this
> point.
> 
> SELECT name, empcomp(employee) FROM employee;

verified.

BTW: postmaster -d 5
will give you verbose output.

it's a cygserver problem. But I haven't checked yet if it's just
too much connections (postgresql checks at init some max_connections 
params from 500 down to 10), still too less memory or if it's the dup 
problem.
dup(0) => Bad file descriptor ???

sometimes the single select works. sometimes it crashes after you do 
some inserts.
unfortunately the regression testsuite doesn't handle this case.


DEBUG:  found "/bin/postgres" using argv[0]
DEBUG:  invoking IpcMemoryCreate(size=1114112)
WARNING:  dup(0) failed after 3196 successes: Bad file descriptor
DEBUG:  max_safe_fds = 986, usable_fds = 3196, already_open = 4
DEBUG:  found "/bin/postmaster" using argv[0]
LOG:  database system was shut down at 2004-08-27 12:59:04 GMT
LOG:  checkpoint record is at 0/9DDFA0
LOG:  redo record is at 0/9DDFA0; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 536; next OID: 17142
LOG:  database system is ready
DEBUG:  proc_exit(0)
DEBUG:  shmem_exit(0)
DEBUG:  exit(0)
DEBUG:  reaping dead processes

-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/

--
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/