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

Re^2: DBIx::Connector timeout?

by leuchuk (Novice)
on Aug 02, 2013 at 13:20 UTC ( #1047595=note: print w/ replies, xml ) Need Help??


in reply to DBIx::Connector timeout?

The timeout comes most probable from the database.

Every database has a predefined timeout. Usually on the clients side there is a parameter for the time wainting for an answer from the server.

There are some solutions for your problem:

First try whether your database is the one giving you this problem. It could be a timeout for example from IP or a wrong routing when e.g. the firewall interrups the traffic.

Then check whether your connection parameters are right. A wrong port number could give you the head ache.

If you identify the database as the one making the timeout: Rise the connection timeout in your database. There is usually an entry in a configuration file or depending on database and OS an environment variable. Rise the limit of open connections if it is a problem of too many open (and probably in parts idle) connections. If you have lots of users try pooling.

Leuchuk


Comment on Re^2: DBIx::Connector timeout?

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (16)
As of 2015-07-06 13:39 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (74 votes), past polls