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