Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re: fetchall_arrayref({}) call freezing

by mje (Deacon)
on Mar 12, 2014 at 13:17 UTC ( #1078016=note: print w/ replies, xml ) Need Help??


in reply to fetchall_arrayref({}) call freezing

DBI 1.607 is from July 2008 and DBD::ODBC 1.16 is from May 2008 almost 6 years old now. I was going to suggest you supplied a DBD::ODBC trace but as your version is so old it is almost before I took over its maintenance and the tracing is rather poor.

I know people always say this but can't you upgrade to a newer DBI and DBD::ODBC?

As a last resort, you can try enabling tracing in the ODBC Administrator and then when your code hangs, examine it to show me what were the last calls.


Comment on Re: fetchall_arrayref({}) call freezing
Re^2: fetchall_arrayref({}) call freezing
by banesong (Acolyte) on Mar 12, 2014 at 14:07 UTC
    I am currently locked in to the module due to versioning restrictions, but hope to be able to update things soon.

    I will turn on tracing and see what I can return to you.
      Okay.... No matter what I do, I get nothing in the ODBC trace file, even though I know for a fact that I am shoving data across the pipe. Even a DBA that I know is confused about that fact.

        The most common reason for this is a permission problem with the file specified as the trace file. However, I've sometimes also seen this if something else has an ODBC connection open when you enable tracing.

        Depending on how recent your windows is there is also now an enable system wide tracing option in the odbc administrator.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (13)
As of 2014-09-19 15:56 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (142 votes), past polls