[Users] Problem with SQL queries in 1.1.0?

[Federico Giannici]

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).

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.
>>
> 


-- 
___________________________________________________
     __
    |-                      giannici at neomedia.it
    |ederico Giannici      http://www.neomedia.it
___________________________________________________