[OpenSIPS-Devel] potential timer shifting

[Edwin]

Hi Bogdan,

OK, very clear anwer. Still I could not solve the problem. I made a snapshot
of the live-server and installed it as a testserver with another ip address
(so almost no load on my test environment)

Mysql 5.5.28 is installed on the server (unix socket)

In my opensips.cfg
db_default_url="mysql://opensips:opensipsrw@localhost/opensips"

# dep: usrloc signaling
loadmodule "registrar.so"
modparam("registrar", "received_avp", "$avp(801)")
modparam("registrar", "max_contacts", 2)

loadmodule "db_mysql.so"
modparam("db_mysql", "exec_query_threshold", 40000)



In de logs of my testserver I see:

Mar 26 15:18:04 opensips /usr/sbin/opensips[6725]:
ERROR:db_mysql:mysql_raise_event: event not registered -1

Mar 26 15:14:07 opensips /usr/sbin/opensips[4835]:
WARNING:db_mysql:log_expiry: threshold exceeded : mysql prep stmt took too
long - 69321 us.Source : update location set
expires=?,q=?,cseq=?,flags=?,cflags=?,user_agent=?,received=?,path=?,socket=?,methods=?,last_modified=?
where username=? AND contact=? AND callid=?

Is the 69321 value almost 7 seconds?






--
View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/potential-timer-shifting-tp7585511p7585520.html
Sent from the OpenSIPS - Devel mailing list archive at Nabble.com.