Hi Fred > Did you upgrade the database (assuming an upgrade from pre-5.6): > > https://www.kamailio.org/wikidocs/install/upgrade/5.5.x-to-5.6.0/
Yes I did. I even remember reading this article. That is the only change, right? -- add index on connection_id for usrloc module location table CREATE INDEX tcpcon_idx ON location (`connection_id`); show create table location: CREATE TABLE `location` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `ruid` varchar(64) NOT NULL DEFAULT '', `username` varchar(64) NOT NULL DEFAULT '', `domain` varchar(64) DEFAULT NULL, `contact` varchar(512) NOT NULL DEFAULT '', `received` varchar(128) DEFAULT NULL, `path` varchar(512) DEFAULT NULL, `expires` datetime NOT NULL DEFAULT '2030-05-28 21:32:15', `q` float(10,2) NOT NULL DEFAULT '1.00', `callid` varchar(255) NOT NULL DEFAULT 'Default-Call-ID', `cseq` int NOT NULL DEFAULT '1', `last_modified` datetime NOT NULL DEFAULT '2000-01-01 00:00:01', `flags` int NOT NULL DEFAULT '0', `cflags` int NOT NULL DEFAULT '0', `user_agent` varchar(255) NOT NULL DEFAULT '', `socket` varchar(64) DEFAULT NULL, `methods` int DEFAULT NULL, `instance` varchar(255) DEFAULT NULL, `reg_id` int NOT NULL DEFAULT '0', `server_id` int NOT NULL DEFAULT '0', `connection_id` int NOT NULL DEFAULT '0', `keepalive` int NOT NULL DEFAULT '0', `partition` int NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `ruid_idx` (`ruid`), KEY `account_contact_idx` (`username`,`domain`,`contact`), KEY `expires_idx` (`expires`), KEY `connection_idx` (`server_id`,`connection_id`), KEY `tcpcon_idx` (`connection_id`) ) ENGINE=InnoDB Yes, that key is present! -- Mit freundlichen Grüssen -Benoît Panizzon- @ HomeOffice und normal erreichbar -- I m p r o W a r e A G - Leiter Commerce Kunden ______________________________________________________ Zurlindenstrasse 29 Tel +41 61 826 93 00 CH-4133 Pratteln Fax +41 61 826 93 01 Schweiz Web http://www.imp.ch ______________________________________________________ __________________________________________________________ Kamailio - Users Mailing List - Non Commercial Discussions To unsubscribe send an email to sr-users-le...@lists.kamailio.org Important: keep the mailing list in the recipients, do not reply only to the sender! Edit mailing list options or unsubscribe:
