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

Tue Nov 11 12:44:48 UTC 2025

Hi Bogdan-Andrei,

It's aws mysql Aurora . AWS says the minor version of mysql server is zero
downtime upgrade . So we didn't get any such message on the server side if
all the connections got closed or what .
There is no error or notification on the server side .  Other applications
using the mysql SDK also run smoothly with this type of upgrade  .

*Thanks & Regards*
*Sasmita Panda*
*Senior Network Testing and Software Engineer*
*3CLogic , ph:07827611765*

On Tue, Nov 11, 2025 at 4:18 PM Bogdan-Andrei Iancu <bogdan at opensips.org>
wrote:

> 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 listUsers at lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20251111/1bb1602f/attachment.html>