Re: [OpenSIPS-Users] issues with prepared statements in mysql

[Bogdan-Andrei Iancu]

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" 
>> 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 
>> > 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
>   


-- 
Bogdan-Andrei Iancu
www.voice-system.ro


___
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

[Alex Balashov]

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" > > 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


-- 
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

[Alex G]

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" 
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

[Bogdan-Andrei Iancu]

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 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
>   


-- 
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

[Alex G]

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