Hi
I think you create a db connection to server on each DB component and the number of connections exceeds the max connections, there are two solutions to fix it.
-. On database server side, modify the parameter max_connections. see
http://dev.mysql.com/doc/refman/5.5/en/too-many-connections.html -. On job side, try to use a tMysqlConnection to create a db connection in the job, all other db component using the same connnection by checking the option 'using an existing connnection'
Best regards
Shong
Hi shong,
It's pretty much that the 2nd solution you provide is what I'm looking for though I'm using tRunjob.
If I will open a database connection in the parent job can the child job catch it's connection?
How can I apply this? Please help
Thanks!
Hi
Yes, you can share the db connection to the child job by checking the option 'use or register a shared db connection' on tMysqlConnection. For example
parent job:
tMysqlConnection
|
onsubjobok
|
other subjobs
|
onsubjobs
|
tRunJob
child job:
tMysqlConnection
|
onsubjobok
|
other subjob
on tMysqlConnection_1 and tMysqlConnection_2, check the option 'use or register a shared db connection' and type in a connenction name, for example, "connection"
Thanks Shong!
Provided that tMySqlConnection_1 and tMySqlConnection_2 has the same connection name for use or register a shared db connection.
Do I have still to fill up it's hostname and etc ?? For me it still the same when you try to declare the connection without checking the register a shared db connection or the theory here is when I check the option of sharing the db connection it treats the connection as 1 and not as separated which causes too many connections?
Am I right?
Hi
If you check the option of sharing the db connection on both of the two component, you don't need to fill up the parameters like hostname etc on tMysqlConnection_2 in child job, it use the same connection which have been registered on tMysqlConnection_1 in parent job.
Best regards
Shong
