Failed to execute canary query (probably due to zombie transaction)

Hi All,


I was getting below error log often. I have no clue whats going wrong.




Can anyone help me out?

Hi Ajithkumar,


Are you noticing any actual problems in the apps?

It's normal to have some "canary query" errors from time to time. They are a couple queries that the app automatically does to ensure that the local storage database is behaving properly and places cleans "zombie" transactions that may be pending after a app reload. 

Those error messages are important only for throubleshooting problems where apps are not opening or upgrading correctly, but can be ignored otherwise.


Regards,

João Rosado

João Rosado wrote:

Hi Ajithkumar,


Are you noticing any actual problems in the apps?

It's normal to have some "canary query" errors from time to time. They are a couple queries that the app automatically does to ensure that the local storage database is behaving properly and places cleans "zombie" transactions that may be pending after a app reload. 

Those error messages are important only for throubleshooting problems where apps are not opening or upgrading correctly, but can be ignored otherwise.


Regards,

João Rosado

Hi Joao,

I was not getting it often.

But the data that I have to list from local storage is not been shown often.

Could this be the cause?






It's hard to say without more details, but like I said it if it didn't recover after a that error it would probably not open the app at all or say upgrade failed.


Can you replicate your list problems consistently?