Hello, a bit strange as I haven't seen a similar report and 5.6.x series is out for quite some time.
It seems to be from the timer routine, what is the db_mode parameter for usrloc module? Have you set also time_procs param? Cheers, Daniel On 03.01.24 21:28, Sergiu Pojoga via sr-users wrote: > Hi, > > Facing the following error after bumping Kam from 5.3 => 5.4 => 5.5 => > 5.6, following instructions on each step about DB structure and module > changes. > > These errors show up since. Any clue what they mean? A couple other > modules are using the same DB MySQL connector. The data in the DB also > seems to get updated properly. > > Jan 03 15:08:30 sip kamailio[20881]: ERROR: <core> [db.c:489]: > db_use_table(): invalid connection parameter > /Jan 03 15:08:30 sip kamailio[20881]: ERROR: usrloc [ucontact.c:1170]: > db_update_ucontact_ruid(): sql use_table failed > Jan 03 15:08:30 sip kamailio[20881]: ERROR: usrloc [urecord.c:438]: > wb_timer(): updating contact in db failed (aor: [email protected]) > / > > version: kamailio 5.6.5 (x86_64/linux) 48d48f > compiled on 02:32:48 Jan 2 2024 with gcc 4.9.2 > > DB structure: > > location | CREATE TABLE `location` ( > `id` int(10) 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(11) NOT NULL DEFAULT 1, > `last_modified` datetime NOT NULL DEFAULT '2000-01-01 00:00:01', > `flags` int(11) NOT NULL DEFAULT 0, > `cflags` int(11) NOT NULL DEFAULT 0, > `user_agent` varchar(255) NOT NULL DEFAULT '', > `socket` varchar(64) DEFAULT NULL, > `methods` int(11) DEFAULT NULL, > `instance` varchar(255) DEFAULT NULL, > `reg_id` int(11) NOT NULL DEFAULT 0, > `server_id` int(11) NOT NULL DEFAULT 0, > `connection_id` int(11) NOT NULL DEFAULT 0, > `keepalive` int(11) NOT NULL DEFAULT 0, > `partition` int(11) 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 AUTO_INCREMENT=287989 DEFAULT CHARSET=latin1 > > > select * from version where table_name='location'; > table_name: location > table_version: 9 > > Thanks. > > __________________________________________________________ > Kamailio - Users Mailing List - Non Commercial Discussions > To unsubscribe send an email to [email protected] > Important: keep the mailing list in the recipients, do not reply only to the > sender! > Edit mailing list options or unsubscribe: -- Daniel-Constantin Mierla (@ asipto.com) twitter.com/miconda -- linkedin.com/in/miconda Kamailio Consultancy and Development Services Kamailio Advanced Training -- asipto.com
__________________________________________________________ Kamailio - Users Mailing List - Non Commercial Discussions To unsubscribe send an email to [email protected] Important: keep the mailing list in the recipients, do not reply only to the sender! Edit mailing list options or unsubscribe:
