my application connects to Google cloud SQL, but in Postgres database and it is intermittent. sometimes when open application receive message " “Data table xxxx” is not accesible due to : Exception while reading from Stream. sometimes work, sometimes work slow, and in other, this error appear.
any information you might have, it will be welcomed.
I started having this issue this morning, all my apps are using Mysql db since long time ago, and i today i got that message, the apps are having problems syncing
Yep, sync is still on and off randomly. Support recommended refreshing credentials to the database, and reconnecting tables, but neither of those have led to a fix.
Tonight I did what support ask.. basically recreate credentials..
But…while I was doing, I also realized that appsheet, somewhere in April.. update the list of IP addresses that I need to add in Google cloud Database firewall.
From the current 62 AppSheet addresses, my firewall had only 49 IP addresses defined .
I add the missing IP addresses, and now..seems to be working.
That said, I’m curious if I missed an email or notification from appsheet regarding new server ip addresses being added to their whitelist, or if there was no anouncement? I would love to prevent this from happening in the future if possible. Thanks