I am using advisory locks with GET_LOCK(). However, the client is hanging on
the execute statement below. The client never responds after the execute;
nor do I get an error message. What can I try to do to debug? I'm lost....
## call to get_lock was performed higher up in the code
print "\n$sql\n" if $DEBUG;
my $sth = $dbh->prepare($sql) or die "Cannot Prepare $@";
print "\n\nafter prepare\n\n";
my $rv = $sth->execute() or die "Cannot Execute $@"; <---------- HANGING
HERE
print "\n\nafter execute\n\n"; <-------------------------- NEVER
PRINTS
$dbh->{PrintError} = 0; ## warn messages off
$dbh->{RaiseError} = 1; ## die with message on
[EMAIL PROTECTED]
Position Research, Inc.
Search engine results by research
tel: (760) 480-8291 fax: (760) 480-8271
www.PositionResearch.com
