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

Reply via email to