Re: [sr-dev] [SR-Users] db_mysql "Commands out of sync; you can't run this command now "

2011-08-31 12:18 keltezéssel, Daniel-Constantin Mierla írta:

Hello,

On 8/31/11 10:49 AM, MÉSZÁROS Mihály wrote:

...

Hi Daniel,

Thank You for your reply!

•   if (!ul_dbh)
  

•           ul_dbh = ul_dbf.init(&db_url); /* Get a new database 
  

connection */

•   ul_dbh = ul_dbf.init(&db_url); /* Get a database connection 
  

per child */

Are you sure that it will not cause any problem that rank -1 process in usrloc database will be initialized twice, and ul_dbh will be overloaded with new connection? I guess this will cause problem.

it is safe, we have connection pool system inside, allowing many modules to use the same db connection when the db url value is matched. So, if a connection with same db url exists, it will be reused.

Thank You for clarification! I will compile it and get back to you with results.

Cheers, Misi