[OpenSIPS-Devel] potential timer shifting

[Edwin]

Hi Vlad,

My location table is InnoDB, utf8_unicode_ci. It holds 431 rows /
registrations (1.9 MiB).

For opensips standards this is a very small system... Getting a 'CRITICAL'
error is questionable?

This is the export of my location table (should be the same as the one
generated with the latest 1.9.0 version).

CREATE TABLE IF NOT EXISTS location (
  id int(10) unsigned NOT NULL AUTO_INCREMENT,
  username char(64) COLLATE utf8_unicode_ci NOT NULL,
  domain char(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  contact char(255) COLLATE utf8_unicode_ci NOT NULL,
  received char(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  path char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  expires datetime NOT NULL DEFAULT '2020-05-28 21:32:15',
  q float(10,2) NOT NULL DEFAULT '1.00',
  callid char(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT
'Default-Call-ID',
  cseq int(11) NOT NULL DEFAULT '13',
  last_modified datetime NOT NULL DEFAULT '1900-01-01 00:00:01',
  flags int(11) NOT NULL DEFAULT '0',
  cflags int(11) NOT NULL DEFAULT '0',
  user_agent char(255) COLLATE utf8_unicode_ci NOT NULL,
  `socket` char(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  methods int(11) DEFAULT NULL,
  sip_instance char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (id),
  KEY account_contact_idx (username,domain,contact,callid)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
AUTO_INCREMENT=28107 ;

loadmodule "usrloc.so"
modparam("usrloc", "db_url", "mysql://***:***@localhost/opensips")
modparam("usrloc", "db_mode", 2)
modparam("usrloc", "matching_mode", 1)


I just upgraded (on my test platform) from (debian apt) 1.9.0-1-99301 to
1.9.0-1-99381. Is there a changelog for apt.opensips.org?



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