[OpenSIPS-Devel] potential timer shifting

[Bogdan-Andrei Iancu]

Hi Edwin,

69321 us  means 0.07 seconds - which for a query is still ok. The 
problem is on your production system, the logs were indicating a delay 
in execution of 7490000 us -> which means 7secs .

So, it might be something particular to that system (load in combination 
with the DB performance, etc).

Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com


On 03/26/2013 04:34 PM, Edwin wrote:
> 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.
>
> _______________________________________________
> Devel mailing list
> Devel at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
>