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.