22 Aug
2006
22 Aug
'06
3:39 p.m.
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.