Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

Re^2: DBD::Sybase::db prepare failed after nth iteration

by perlsen (Chaplain)
on Nov 16, 2007 at 15:16 UTC ( [id://651235]=note: print w/replies, xml ) Need Help??


in reply to Re: DBD::Sybase::db prepare failed after nth iteration
in thread DBD::Sybase::db prepare failed after nth iteration

Hi Michael,

Thanks For your above information. Below is the error, what i am getting, while executing the perl script.
"DBD::Sybase::db prepare failed: OpenClient message: LAYER = (6) ORIGI +N = (8) SEVERITY = (5) NUMBER = (1) Message String: ct_connect(): directory service layer: internal direct +ory control layer error: There was an error encountered while binding + to the directory service. Couldn't prepare the query for procedure execution : OpenClient messag +e: LAYER = (6) ORIGIN = (8) SEVERITY = (5) NUMBER = (1) Message String: ct_connect(): directory service layer: internal direct +ory control layer error: There was an error encountered while binding + to the directory service."

And also, this is happened nearly after 150 th excution on one day. the same script when i ran it for next day. it was throwing the same type of error after running thru some 200 th execution.

then, I have introduced 2 more dbh connection with the existing dbh connection. Now it is not throwing any error and the script works faster compared to the Above one.

I am not Sure whether these Approach is fine for that problem.

Please suggest me, if this is the right approach to fix the issue? or Is Anything i need to modify my Script.

Thanks and Regards
perlsen
Server Error (Error ID 4244896c2135420)

An error has occurred. The site administrators have been notified of the problem and will likely soon fix it. We thank you, for you're patients.

Replies are listed 'Best First'.
Re^3: DBD::Sybase::db prepare failed after nth iteration
by mpeppler (Vicar) on Nov 16, 2007 at 15:55 UTC
    OK - so that means that DBD::Sybase is trying to open a new connection. Is that done on purpose?

    If that's NOT the case then you should make sure that any $sth really go out of scope or are cleaned up before executing the next call. Maybe consider using the syb_no_child_con option to make sure that DBD::Sybase doesn't attempt to open a second connection if there is already an "active" statement handle on the current $dbh.

    Michael

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (6)
As of 2024-03-29 15:14 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found