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: user@domain.com)

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 sr-users-leave@lists.kamailio.org
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