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 failedJan 03 15:08:30 sip kamailio[20881]: ERROR: usrloc [urecord.c:438]: wb_timer(): updating contact in db failed (aor: user@domain.com 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.
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:
*Answers to your questions:*
*> what is the db_mode parameter for usrloc module?* modparam("usrloc", "db_mode", 2) # other modules like dialog have same mode 2
*> Have you set also time_procs param?* modparam("usrloc", "timer_procs", 2)
Other usrloc params: modparam("usrloc", "db_load", 1) modparam("usrloc", "matching_mode", 0) modparam("usrloc", "handle_lost_tcp", 0) modparam("usrloc", "use_domain", MULTIDOMAIN) modparam("usrloc", "nat_bflag", FLB_NATB) modparam("usrloc", "timer_interval", 60) modparam("usrloc", "skip_remote_socket", 0)
Thanks.
On Thu, Jan 4, 2024 at 3:38 AM Daniel-Constantin Mierla miconda@gmail.com wrote:
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 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
-
Daniel-Constantin Mierla -
Sergiu Pojoga