Gil Vidals [EMAIL PROTECTED] wrote:
> 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....
I'd try 'trace' - read about 'trace' in the DBI perldocs:
perldoc DBI
at a command prompt.
HTH.
--
Hardy Merrill
Red Hat, Inc.
>
>
> ## 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
