[Users] Problem with SQL queries in 1.1.0?

Klaus Darilion klaus.mailinglists at pernau.at
Tue Aug 22 15:39:04 CEST 2006


Federico Giannici wrote:
> Your suspect was correct: I was able to reproduce exactly the same 
> errors simply by stopping a restarting the MySQL server (thus breaking 
> old connections).

Shouldn't the mysql module reconnect?

regards
klaus

> 
> OpenSER is using MySQL library version 5.0.18.
> The MySQL server is version 4.0.27.
> 
> 
> Bye.
> 
> 
> 
> Bogdan-Andrei Iancu wrote:
>> Hi Federico,
>>
>> please check if when you get this errors your openser process is still 
>> connected to the mysql server.
>> the interesting part is that no error string is present into the log:
>>    OpenSER[19895]: submit_query:
>>
>> regards,
>> bogdan
>>
>> Federico Giannici wrote:
>>
>>> We recently upgraded from version 1.0.0 to 1.1.0 from CVS of a few 
>>> days ago.
>>>
>>> After a couple of days of uptime, some SQL errors began to appear. 
>>> First there was this one:
>>>
>>> Aug 21 10:07:07 eowyn OpenSER[19895]: ERROR: warning_builder: buffer 
>>> size exceeded
>>> Aug 21 10:07:07 eowyn OpenSER[19895]: WARNING: warning skipped -- too 
>>> big
>>> Aug 21 10:07:07 eowyn OpenSER[19895]: submit_query:
>>> Aug 21 10:07:07 eowyn OpenSER[19895]: db_insert: Error while 
>>> submitting query
>>> Aug 21 10:07:07 eowyn OpenSER[19895]: ERROR:acc:acc_db_request: Error 
>>> while inserting to database
>>>
>>> Then, some errors like this:
>>>
>>> Aug 21 15:41:28 eowyn OpenSER[19895]: submit_query:
>>> Aug 21 15:41:28 eowyn OpenSER[19895]: db_insert: Error while 
>>> submitting query
>>> Aug 21 15:41:28 eowyn OpenSER[19895]: ERROR:acc:acc_db_request: Error 
>>> while inserting to database
>>>
>>> Or the following:
>>>
>>> Aug 21 19:02:10 eowyn OpenSER[20604]: submit_query:
>>> Aug 21 19:02:10 eowyn OpenSER[20604]: db_query: Error while 
>>> submitting query
>>> Aug 21 19:02:10 eowyn OpenSER[20604]: NM ERROR: 
>>> nm_hash_load_domains(): error with dbf.query()
>>>
>>> The nm_hash_load_domains() function is a module of mine, that make an 
>>> SQL query. No problem with version 1.0.0.
>>>
>>>
>>> Is there any SQL known problem in the 1.1.0 CVS version?
>>> Maybe the first error caused some memory garbage?
>>>
>>>
>>> Thanks.
>>>
>>
> 
> 





More information about the Users mailing list