You are viewing a plain text version of this content. The canonical link for it is here.
Posted to modperl@perl.apache.org by Jie Gao <J....@isu.usyd.edu.au> on 2000/06/09 10:26:46 UTC
DBD::Sybase problem
Hi All,
DBD::Sybase v 1.22
DBI 1.13
Apache::DBI v 1.44
mod_perl/1.23
Apache/1.3.12
Solaris/Sparc 7
Using cached connnection with:
Apache::DBI->connect_on_init("DBI:Sybase:$db_name", $db_user_name, $db_user_pwd);
in start_up.pl.
Server starts ok and all goes well; but after a few hours I get server
errors, with the following in the error_log:
[Fri Jun 9 08:36:44 2000] PerlHandler subroutine `Apache::Registry::handler': DBD::Sybase::db ping failed:
OpenClient message: LAYER = (1) ORIGIN = (1) SEVERITY = (1) NUMBER = (60)
[Fri Jun 9 08:36:44 2000] PerlHandler subroutine `Apache::Registry::handler': Message String:
ct_cancel(CONN,ALL): user api layer: external error: There is a usage error. This routine has been called
at an illegal time.
[Fri Jun 9 08:36:44 2000] PerlHandler subroutine `Apache::Registry::handler': OpenClient message: LAYER =
(1) ORIGIN = (1) SEVERITY = (1) NUMBER = (60)
[Fri Jun 9 08:36:44 2000] PerlHandler subroutine `Apache::Registry::handler': Message String:
ct_close(FORCE): user api layer: external error: There is a usage error. This routine has been called at an
illegal time.
[Fri Jun 9 08:36:44 2000] PerlHandler subroutine `Apache::Registry::handler': DBD::Sybase::st execute
failed: OpenClient message: LAYER = (1) ORIGIN = (1) SEVERITY = (1) NUMBER = (60)
[Fri Jun 9 08:36:44 2000] PerlHandler subroutine `Apache::Registry::handler': Message String: ct_command():
user api layer: external error: There is a usage error. This routine has been called at an illegal time.
[Fri Jun 9 08:36:44 2000] [error] Database select error: OpenClient message: LAYER = (1) ORIGIN = (1)
SEVERITY = (1) NUMBER = (60)
Message String: ct_command(): user api layer: external error: There is a usage error. This routine has been
called at an illegal time.
Any idea why this is happening?
Thanks very much,
Jie
Re: DBD::Sybase problem
Posted by Alex Farber <fa...@cpan.org>.
Hi,
Jie Gao wrote:
> > Server starts ok and all goes well; but after a few hours I get server
> > errors, with the following in the error_log:
> > ct_cancel(CONN,ALL): user api layer: external error: There is a usage error. This routine has been called
> > at an illegal time.
isn't it http://perl.apache.org/guide/databases.html#The_Morning_Bug ?
Regards
Alex
Re: DBD::Sybase problem
Posted by Jie Gao <J....@isu.usyd.edu.au>.
Hi All,
Following up the attached message I posted a couple of weeks ago, I
found if the database was taken down during the lifetime of the Web
server, this problem would pop up, even if the db was taken up again.
Cheers,
Jie
On Fri, 9 Jun 2000, Jie Gao wrote:
> Date: Fri, 9 Jun 2000 18:26:46 +1000 (EST)
> From: Jie Gao <J....@isu.usyd.edu.au>
> To: dbi-users@isc.org
> Cc: modperl@apache.org
> Subject: DBD::Sybase problem
>
> Hi All,
>
> DBD::Sybase v 1.22
> DBI 1.13
> Apache::DBI v 1.44
> mod_perl/1.23
> Apache/1.3.12
> Solaris/Sparc 7
>
> Using cached connnection with:
>
> Apache::DBI->connect_on_init("DBI:Sybase:$db_name", $db_user_name, $db_user_pwd);
>
> in start_up.pl.
>
> Server starts ok and all goes well; but after a few hours I get server
> errors, with the following in the error_log:
>
> [Fri Jun 9 08:36:44 2000] PerlHandler subroutine `Apache::Registry::handler': DBD::Sybase::db ping failed:
> OpenClient message: LAYER = (1) ORIGIN = (1) SEVERITY = (1) NUMBER = (60)
> [Fri Jun 9 08:36:44 2000] PerlHandler subroutine `Apache::Registry::handler': Message String:
> ct_cancel(CONN,ALL): user api layer: external error: There is a usage error. This routine has been called
> at an illegal time.
> [Fri Jun 9 08:36:44 2000] PerlHandler subroutine `Apache::Registry::handler': OpenClient message: LAYER =
> (1) ORIGIN = (1) SEVERITY = (1) NUMBER = (60)
> [Fri Jun 9 08:36:44 2000] PerlHandler subroutine `Apache::Registry::handler': Message String:
> ct_close(FORCE): user api layer: external error: There is a usage error. This routine has been called at an
> illegal time.
> [Fri Jun 9 08:36:44 2000] PerlHandler subroutine `Apache::Registry::handler': DBD::Sybase::st execute
> failed: OpenClient message: LAYER = (1) ORIGIN = (1) SEVERITY = (1) NUMBER = (60)
> [Fri Jun 9 08:36:44 2000] PerlHandler subroutine `Apache::Registry::handler': Message String: ct_command():
> user api layer: external error: There is a usage error. This routine has been called at an illegal time.
> [Fri Jun 9 08:36:44 2000] [error] Database select error: OpenClient message: LAYER = (1) ORIGIN = (1)
> SEVERITY = (1) NUMBER = (60)
> Message String: ct_command(): user api layer: external error: There is a usage error. This routine has been
> called at an illegal time.
>
>
> Any idea why this is happening?
>
> Thanks very much,
>
>
> Jie
>
>