You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by manueltg89 <ma...@hotmail.com> on 2020/06/27 15:59:51 UTC

WriteBehind enabled problem FK constraint

Hello.

In my app I have writeBehind to true, when I start to write in my Apache
Ignite instance sometimes throw an error with FK, is there anyway to
maintain order with writes to external database?

Thanks.



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: WriteBehind enabled problem FK constraint

Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!

I recommend disabling FKs for tables which are written by Cache Store.

Regards,
-- 
Ilya Kasnacheev


пн, 29 июн. 2020 г. в 16:01, manueltg89 <manuel.trinidad.garcia@hotmail.com
>:

> Hello!
>
> With writeBehind enabled I get many more errors that with writeBehind
> disabled. What write state do you recommended with writes to external
> database?
>
> Thanks in advance.
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>

Re: WriteBehind enabled problem FK constraint

Posted by manueltg89 <ma...@hotmail.com>.
Hello!

With writeBehind enabled I get many more errors that with writeBehind
disabled. What write state do you recommended with writes to external
database?

Thanks in advance.



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: WriteBehind enabled problem FK constraint

Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!

I don't think so, writeBehind is managed in batches and sometimes a batch
has to be re-tried, which will make it out-of-order. Other reasons may also
cause writeBehind writes to be out of order. You may not get the "correct"
order even for non-write-behind Cache Store since it may maintain its own
ordering between different caches.

Regards,
-- 
Ilya Kasnacheev


сб, 27 июн. 2020 г. в 18:59, manueltg89 <manuel.trinidad.garcia@hotmail.com
>:

> Hello.
>
> In my app I have writeBehind to true, when I start to write in my Apache
> Ignite instance sometimes throw an error with FK, is there anyway to
> maintain order with writes to external database?
>
> Thanks.
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>