[OpenSIPS-Users] Need some help on mysql error on opensips .

[Sasmita Panda]

Hi All ,

I am using opensips 3.4 running on EKS node and the database is AWS RDS (
8.0.mysql_aurora.3.08.2) .

In the config  I am using sql_only mode to save/extract data from the
database .

loadmodule "usrloc.so"
modparam("usrloc", "nat_bflag", "NAT")
modparam("usrloc", "working_mode_preset", "sql-only")
modparam("usrloc", "db_url", "mysql://mysql-user:mysql-pass@mysql-domain
/dbname")
modparam("usrloc", "use_domain", 1)
modparam("usrloc", "max_contact_delete", 1)

        if ($rm=="REGISTER") {
 xlog( "L_NOTICE", "Register Contact & $ct \n" );
                fix_nated_register();

 if(!save("location","force-registration,max-contacts=10,path-lazy"))
                          sl_reply_error();
                exit;
        }


Below is the error I am getting in the opensips logs :

2025-10-20 00:30:03.120
{"body":"Oct 19 19:00:03 [36] NOTICE:Register Contact \u0026
\u003csip:hbh3a766 at 192.168.33.49:57670
;transport=wss\u003e;expires=90","attributes":{"log.file.path":"/var/log/pods/eks-opensips_west-registrar-f5c5896d4-rgn8d_44da0dac-0521-4e1b-b4e7-89c7f0f87c11/west-registrar/0.log","log.iostream":"stderr","logtag":"F"},"resources":{"k8s.container.restart_count":"0","k8s.pod.uid":"44da0dac-0521-4e1b-b4e7-89c7f0f87c11"}}
2025-10-20 00:30:03.121
{"body":"Oct 19 19:00:03 [36]*
CRITICAL:db_mysql:wrapper_single_mysql_stmt_execute: driver error (1243):
Unknown prepared statement handler (5) given to
mysql_stmt_precheck","attributes*
":{"log.file.path":"/var/log/pods/eks-opensips_west-registrar-f5c5896d4-rgn8d_44da0dac-0521-4e1b-b4e7-89c7f0f87c11/west-registrar/0.log","log.iostream":"stderr","logtag":"F"},"resources":{"k8s.container.restart_count":"0","k8s.pod.uid":"44da0dac-0521-4e1b-b4e7-89c7f0f87c11"}}
2025-10-20 00:30:03.121
{"body":"Oct 19 19:00:03 [36]* ERROR:usrloc:db_insert_ucontact: inserting
contact in db failed","attributes":*
{"log.file.path":"/var/log/pods/eks-opensips_west-registrar-f5c5896d4-rgn8d_44da0dac-0521-4e1b-b4e7-89c7f0f87c11/west-registrar/0.log","log.iostream":"stderr","logtag":"F"},"resources":{"k8s.container.restart_count":"0","k8s.pod.uid":"44da0dac-0521-4e1b-b4e7-89c7f0f87c11"}}
2025-10-20 00:30:03.121
{"body":"Oct 19 19:00:03 [36]* ERROR:usrloc:wb_timer: inserting contact
into database failed*
","attributes":{"log.file.path":"/var/log/pods/eks-opensips_west-registrar-f5c5896d4-rgn8d_44da0dac-0521-4e1b-b4e7-89c7f0f87c11/west-registrar/0.log","log.iostream":"stderr","logtag":"F"},"resources":{"k8s.container.restart_count":"0","k8s.pod.uid":"44da0dac-0521-4e1b-b4e7-89c7f0f87c11"}}

*** I have 2 instance on which opensips running and the Database is common
for both .

*Thanks & Regards*
*Sasmita Panda*
*Senior Network Testing and Software Engineer*
*3CLogic , ph:07827611765*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20251021/ca4d3c9e/attachment.html>