Client Hanging on Execute. How to debug?

From: Gil Vidals (gil.vidals_at_positionresearch.com)
Date: 12/11/03 

To: <dbi-users@perl.org>
Date: Thu, 11 Dec 2003 11:48:01 -0800

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

Gil.Vidals@PositionResearch.com
Position Research, Inc.
Search engine results by research
tel: (760) 480-8291 fax: (760) 480-8271
www.PositionResearch.com

Relevant Pages

  • Re: Client Hanging on Execute. How to debug?
    ... > the execute statement below. ... The client never responds after the execute; ... What can I try to do to debug? ... > Position Research, Inc. ...
    (perl.dbi.users)
  • Password authentication fails: SSH secure shell to openssh server
    ... Can connect to OpenSSH server from openSSH client but not from ... SSH Secure Shell Client ... debug: Ssh2/ssh2.c:2121/main: Entering event loop. ...
    (SSH)
  • Re: hostbased auth between commercial and OpenSSH
    ... The server just rejects hostbased from OpenSSH client saying method is ... Client side debug snippet (I've got hostbased as only ... client user 'myusername', server user 'myusername', ...
    (comp.security.ssh)
  • Re: Rsync problem - still unsolved
    ... My client shows my message from the 22.2.06 ... In our Institut i was able to use rsync with ssh for backup my data from PC to linux server. ... I'm still able to get an ssh2 connection (only with keyboard-interactive authentication which is ok for me). ... debug: SshAuthMethodClient/sshauthmethodc.c:85: Added "keyboard-interactive" to ...
    (comp.security.ssh)
  • Re: Problem connecting to SSH, OpenVMS7.3-2, HP TCP/IP v5.4 patched
    ... debug: ... connection lost. ... client on the same node as the server. ... [No surprise, as I allow, but don't use, host-based authentication.] ...
    (comp.os.vms)