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 <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> 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
>
>
