Re: [OpenSIPS-Users] issues with prepared statements in mysql
It fails completely. As a matter o fact... anything that doesn't return query OK fails: :( On Mar 3, 2010 12:17 PM, Bogdan-Andrei Iancu bog...@voice-system.ro wrote: Hi Alex, and the acc record is actually added (even with the trigger error) ? or the acc insert fails completely ? Regards, Bogdan Alex G wrote: I have a scenario where I execute a trigger in mysql when info is added to the a... ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- Bogdan-Andrei Iancu www.voice-system.ro ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] issues with prepared statements in mysql
That's because it is a single transaction and is being rolled back, most likely. On 03/03/2010 01:23 PM, Alex G wrote: It fails completely. As a matter o fact... anything that doesn't return query OK fails: :( On Mar 3, 2010 12:17 PM, Bogdan-Andrei Iancu bog...@voice-system.ro mailto:bog...@voice-system.ro wrote: Hi Alex, and the acc record is actually added (even with the trigger error) ? or the acc insert fails completely ? Regards, Bogdan Alex G wrote: I have a scenario where I execute a trigger in mysql when info is added to the a... ___ Users mailing list Users@lists.opensips.org mailto:Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- Bogdan-Andrei Iancu www.voice-system.ro http://www.voice-system.ro ___ Users mailing list Users@lists.opensips.org mailto:Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- Alex Balashov - Principal Evariste Systems LLC Tel: +1 678-954-0670 Direct : +1 678-954-0671 Web: http://www.evaristesys.com/ ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] issues with prepared statements in mysql
well, in this case, the mysql driver in opensips reports the truth :)... the only option here is to make your trigger more fault-resistant ;) Regards, Bogdan Alex G wrote: It fails completely. As a matter o fact... anything that doesn't return query OK fails: :( On Mar 3, 2010 12:17 PM, Bogdan-Andrei Iancu bog...@voice-system.ro mailto:bog...@voice-system.ro wrote: Hi Alex, and the acc record is actually added (even with the trigger error) ? or the acc insert fails completely ? Regards, Bogdan Alex G wrote: I have a scenario where I execute a trigger in mysql when info is added to the a... ___ Users mailing list Users@lists.opensips.org mailto:Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- Bogdan-Andrei Iancu www.voice-system.ro http://www.voice-system.ro ___ Users mailing list Users@lists.opensips.org mailto:Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- Bogdan-Andrei Iancu www.voice-system.ro ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
[OpenSIPS-Users] issues with prepared statements in mysql
I have a scenario where I execute a trigger in mysql when info is added to the acc table. In some circumstances, my trigger results in a duplicate key when it tries to add info to another table. The prepared statement functionality reads this as an error, and fails to do the insert into the acc table as a result of this. Is there any way to get around this? ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users