Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re^3: DBD::Sybase query execute hangs randomly for Sybase IQ 15.4

by jfroebe (Vicar)
on Jun 19, 2013 at 17:13 UTC ( #1039804=note: print w/ replies, xml ) Need Help??


in reply to Re^2: DBD::Sybase query execute hangs randomly for Sybase IQ 15.4
in thread DBD::Sybase query execute hangs randomly for Sybase IQ 15.4

In case your dbas need information on the Config file. In particular, look at:

  1. -iqgovern Number of concurrent queries (default is 2*num_cpu+10)
  2. -gm Number of connections that can be active at one time

You might be running into blocking locks if the parallel runs of your Perl code are hitting the same pages.

As far as Perl goes, you may want to enable DBI Tracing to determine if there is something funky going on.

Jason L. Froebe

Blog, Tech Blog


Comment on Re^3: DBD::Sybase query execute hangs randomly for Sybase IQ 15.4
Re^4: DBD::Sybase query execute hangs randomly for Sybase IQ 15.4
by cmahajan (Initiate) on Jun 20, 2013 at 01:34 UTC
    I'm going to enable DBI tracing and will check the trace file for any hints. Will update the results here.
Re^4: DBD::Sybase query execute hangs randomly for Sybase IQ 15.4
by cmahajan (Initiate) on Jun 25, 2013 at 02:47 UTC
    I enabled DBI Tracing in my script and here's the error message I got in the trace file. I was lucky enough that the issue occurred shortly after I added the tracing code in my code. From the error message I believe that this is related to the network configuration on my Unix machine (IBM AIX). Any ideas on how to go about fixing this? =================================== -> FETCH for DBD::Sybase::db (DBI::db=HASH(0x30844064)~INNER 'Driver') ERROR: 50 'OpenClient message: LAYER = (4) ORIGIN = (1) SEVERITY = (5) NUMBER = (28) Server bhedw_dev, database Message String: ct_results(): protocol specific layer: external error: There is a tds protocol error. An illegal token was received. OpenClient message: LAYER = (1) ORIGIN = (1) SEVERITY = (1) NUMBER = (50) Server bhedw_dev, database Message String: ct_cmd_drop(): user api layer: external error: The connection has been marked dead. ===================================

      Try running the query from isql or dbisql. isql will handle t-sql and dbisql will handle Watcom-SQL.

      Jason L. Froebe

      Blog, Tech Blog

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1039804]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (6)
As of 2014-07-31 00:17 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (241 votes), past polls