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

Tue Nov 11 10:48:10 UTC 2025

Hi Sasmita,

At steps (3) + (4), if the db conn is not reset (from the OpenSIPS 
perspective), the statements are kept (of course). The question is - did 
the mysql upgrade triggered the closing of all DB conns in the mysql server?

Regards,

Bogdan-Andrei Iancu

OpenSIPS Founder and Developer
   https://www.opensips-solutions.com
   https://www.siphub.com

On 22.10.2025 16:15, Sasmita Panda via Users wrote:
> Hi All ,
>
> Is there any update on this ?
>
> Just to elaborate the error a bit , I have opensips running on eks 
> cluster nodes and multiple opensips nodes used to connect to the same 
> RDS (Aurora mysql).
> On the RDS side there was a minor version upgrade from 
> 8.0.mysql_aurora.3.07 to 8.0.mysql_aurora.3.08.2 . After upgrade when 
> register request comes to opensips
> and it goes to insert the data in the DB. It gives the above error 
> which I shared earlier .
>
> *CRITICAL:db_mysql:wrapper_single_mysql_stmt_execute: driver error 
> (1243): Unknown prepared statement handler (5) given to 
> mysql_stmt_precheck*
> *ERROR:usrloc:db_insert_ucontact: inserting contact in db 
> failed","attributes*
> *ERROR:usrloc:wb_timer: inserting contact into database failed*
> *
> *
> *As for my understanding : *
> During the Aurora mysql upgrade from 3.07 to 3.08.2
>
> 1.
>
>     All old DB sessions are terminated and reset .
>
> 2.
>
>     The Auro engine restarts and resets all session level state .
>
> 3.
>
>     However opensips SB driver (db_mysql) still holds references to
>     old prepared statement in an old connection pool .
>
> 4.
>
>     When the connection is reused by opensips after upgrade , those
>     handels does not exists anymore and hence → driver Error 1243
>     appears in opensips logs (invalid prepared statement and failed to
>     insert data in the database ) .
>
> 5.
>
>     Once we restarted the pods the connection pool from opensips side
>     also got reset and hence the issue got resolved .
>
> *
> *
> *But restart is not suitable for live environment . So is there any 
> other option to recover this automatically . On opensips module 
> documentation for db_mysql *
> *I am not getting any such parameter to set . Do I need to update the 
> mysql client version to ? Please suggest . *
> *
> *
> */Thanks & Regards/*
> /Sasmita Panda/
> /Senior Network Testing and Software Engineer/
> /3CLogic , ph:07827611765/
>
>
> On Tue, Oct 21, 2025 at 11:14 AM Sasmita Panda <spanda at 3clogic.com> wrote:
>
>     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/
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20251111/aab0c2c8/attachment-0001.html>