Cool. Nice one. On Wed, Apr 14, 2010 at 9:41 AM, Richard U <richard....@gmail.com> wrote: > Thanks Tom > > I found a way of doing this... by killing the dead connection and > creating a new one... > > Propel::close(); // kill existing > $connection_cdb = Propel::getConnection(); // create new > > > On Wed, Apr 14, 2010 at 10:16 PM, Tom Haskins-Vaughan > <t...@templestreetmedia.com> wrote: >> I think I came across this after trying to download a very large file >> ~100MB between db calls. I don't remember how I fixed it, but I think >> I just tried to reconnect manuallly to the db. I'll have a dig around >> and see what I can come up with. >> >> Tom >> >> On Tue, Apr 13, 2010 at 12:55 AM, Slavka <richard....@gmail.com> wrote: >>> Hey guys... im getting the "SQLSTATE[HY000]: General error: 2006 MySQL >>> server has gone away" >>> In my action i create the required db connections as such.... >>> >>> $connection_cdb = Propel::getConnection('propel'); >>> $connection_stats = Propel::getConnection('cdb_stats'); >>> >>> I then read a big csv file from the server and this takes a marginal >>> amount of time (50-60seconds)... , then when i try and do something >>> with the db i get the error above... >>> >>> Is there anyway that i can force for the connections not to time out >>> >>> -- >>> If you want to report a vulnerability issue on symfony, please send it to >>> security at symfony-project.com >>> >>> 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 >>> >>> To unsubscribe, reply using "remove me" as the subject. >>> >> >> -- >> If you want to report a vulnerability issue on symfony, please send it to >> security at symfony-project.com >> >> 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 >> > > -- > If you want to report a vulnerability issue on symfony, please send it to > security at symfony-project.com > > 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 >
-- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com 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