[Discuss] mysql problem

[joe at polcari.com (Joe Polcari)]

DB probably locked during migration and the query to log returned nothing.

From:  Discuss on behalf of dan moylan
Date:  Monday, August 22, 2016 at 4:31 PM
To:  "discuss at blu.org"
Cc:  betty moylan
Subject:  [Discuss] mysql problem


i run a perl cgi script on www/moylan.us as well as on my
home computer.  on saturday while i was at the linux install
fest the script ran fine both places, but in the afternoon
it failed at moylan.us, though it continued fine on my local
host.  my web hosting service was migrating to a different
server over the lunch hour.

the error message i receive is:

 Can't call method "prepare" on an undefined value at
 /home/moylan/ulmmoy/prl/sub/USR/USR.pm line 777.

the code around there is:

 775      # get all current logins
 776        $stm = "select * from log";
 777        $sh0 = $dh0->prepare ($stm);
 778        $sh0->execute ();

i had the same problem two years ago, but on my home
machine, not moylan.us where the script ran fine.  as best i
can recall, the solution involved disabling selinux --
though i'm not certain.  however, i checked and the remote
server already has selinux disabled.

any thoughts as to what could be going on?

ole dan

j. daniel moylan
84 harvard ave
brookline, ma 02446-6202
617-777-0207 (cel)
jdm at moylan.us
www.moylan.us
[no html pls]
_______________________________________________
Discuss mailing list
Discuss at blu.org
http://lists.blu.org/mailman/listinfo/discuss