[TYPO3-dev] Temporarily Closing Typo3 Database Connection

[Frank Weindel]

Mathias Schreiber [wmdb >] wrote:
> Frank Weindel schrieb:
>> Thanks for your reply. The problem is that the function that sends out 
>> the mass mailing to 20000+ people takes a very long time to finish and 
>> does not access the database. So sometime during the execution of that 
>> function we lose the connection to the database so after that function 
>> returns and we try to query the database it fails. I'm thinking the 
>> disconnection is due to a connection timeout. We do not want to 
>> increase the timeout.
> 
> Hola,
> 
> ah, now I see.
> Still, it sounds rather odd to me, since any new request should connect 
> to the DB just fine.
> 
> Another idea I have (rather dirty) run a counter and issue an select 
> every... 500 records or so?
> 
> Never heard of that problem (and we got jobs that run for longer than an 
> hour without talking to the DB), sounds much like the stup is involved.
> 
> cheers
> Mathias

It might not be a timeout issue after all.  The disconnection seems to 
coincide with heavy load times on our db server. Perhaps that brought on 
the problem.

Frank