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