22 Aug
2006
22 Aug
'06
3:12 p.m.
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:
--
___________________________________________________
__
|- giannici(a)neomedia.it
|ederico Giannici http://www.neomedia.it
___________________________________________________
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.