I have a strange error.
when I do a ps aux I get:
postgres 15018 0.0 0.6 9192 7396 ? S 09:20 0:00 /usr/bin/perl
/www/nexum/cgi-bin/accounting/posting/automatic_posting
postgres 15019 0.0 0.3 25696 4176 ? S 09:20 0:00 postgres:
postgres nexum [local]: idle
a little bit about the system.
It's a Dell Power Edge 500 sc with 1G Mem and a PIII 1Ghz processor 40G HDD
running RHEL 3.0 with apache 2.0.46
This perl script is designed to handle payment posting for an application we
developed. It runs fine on our development server which is running apache
1.3.27 on ES 2.1
on the production server the script hangs and we see the above msg in "ps
aux"
we wrote a wrapper for the program that will exec it from the command line
and everything runs a-o-k
has anyone else encounted something like this? should I downgrade the
installation of apache?
the script is using Pg.pm and makes many database calls in side of a
transaction session. turning on max debug from postgresql has not yeilded
an errors and putting in our own debug statements to print to STDERR to goto
the apache log also yeilds nothing since we can't see anything until we kill
the process. then what it remembers gets dumped to the error log.
Jon Pastore RHCE, President
IDE Tech, Inc.
(954) 360-0393 Office
(954) 428-0442 Fax
Public Key: <http://www.idetech.net/keys/jpastore.asc>
http://www.idetech.net/keys/jpastore.asc