Unknown error when attempting to read from GSheet between token refresh interval

[FarmBuis]

Hi mobizt. In my code I first get parameters from GSheet sheet1(lets call this read1), then I get IDs from GSheet sheet2(lets call this read2), then I do some comparing and then update to GSheet sheet2(lets call this update) and repeat this process once after every 10mins. There is a delay of 50ms between read1 and read2 as well as between read2 and update.

When I first execute this code all three (read1, read2 and update) work just fine. After the first 10min when the program calls read1 it returns an "unknown error", read2 and update work fine. Only read1 returns an error and continues to do so until the token refreshes after 50min. After the token refresh it works only once again and never again for the remainder of that token.

I found a way around this by calling read1 a second time if the first time returned an error, then it seems to work. Can you perhaps shed some light on this issue as to why it might be happening?

[mobizt]

I cannot tell anything as it is unknown fault that causes unexpected error.

Which means the SSL client fails to operate i.e. out of memory.

Any network/server issues can be detectable, but the memory issue depends on your application.

[FarmBuis]

Thank you. I simplified the complex if statements that called these read/update functions and now it seems to work. I was checking my freeheap before and after the gsheet.get.values and it seemed like all was in order, there was no difference in the available freeheap when it worked and when it didnt work. Either way it works now than you.

[FarmBuis]

Correction the issue is not resolved. It turns out it is time based. If I call the GSheet.values.get(); within 240 second (4mins) from the last time it was called then it works perfectly fine. if I increase that interval to anything more than 240 second, say 300 seconds (5min), then it does not work until the token is refreshed or if I call GSheet.values.get(); a second time right after it failed the first time. I am regularly calling GSheet.ready(); . I still dont know why this is happening but at least there are solutions around this.

1. Call GSheet.values.get(); within 240s intervals.
2. If you want to use an interval larger than 240s then you need to Call GSheet.values.get(); a second time if it fails.

[mobizt]

Thanks for posting this again.

From the information you provided, this issue is related to the known issue of ESP32 WiFiClient and ESP_SSLClient that use inside this library. The issue was detected in my other libraries too in ESP32 when working with google service API.

I updated the repo already to fix the issue (not yet release a new version).

Please update by downloading the source files from Code > Download ZIP.

[FarmBuis]

Problem solved. Thank you so much for this fix