Hi All,
This question pertains to MySQL used with Symfony 1.0 and Propel.
I have a LONG running batch script that intermittently needs access to
MySQL. I begin the script with the lines:
///code
$databaseManager = new sfDatabaseManager();
$databaseManager->initialize();
code////
And the program goes into an event loop, using FAM as the notifier.
But, if lots of time elapses between the time I initialize and the
time I need the connection, I get an error about MySQL has gone away.
This means that the idle timeout was exceeded for MySQL. I know I
could just set the timeouts to forever, but that is not a tenable
solution.
The question is: how to I tell Symfony to reconnect to MySQL? Is the
solution to use something like Propel::getConnection() every time I
need it? Some other solution? As I mentioned, this script basically
runs 24/7, only waking up when it needs to do something. As such,
doing something like upping the MySQL timeout isn't really an option
for me.
I've tried doing stuff like:
///code
$databaseManager = new sfDatabaseManager();
$databaseManager->initialize();
{do some stuff}
$databaseManager->shutdown();
{wait}
$databaseManager = new sfDatabaseManager();
$databaseManager->initialize();
///code
But that doesn't really work. Any tips anyone?
All Best,
JLS
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
