Failed again tonight.
Same error, on the same row:
anvil.tables.TableError: Internal database error: ERROR: canceling statement due to user request
<running on the server>
called from /downlink/anvil/_server.py, line 42
called from server_module, line 670
called from server_module, line 219
Session ID:3SO2AOSD4MRS24ZQGM6EQCQDPFDTUT5U
The code line is the same as yesterday. This time a loop over 24 PDFs I’m trying to archive in the document buffer table.
I don’t think I’m hitting DB too quickly, here are the log of the loop
2022-05-05 03:02:17.166627+00:00 - info - saving document in Anvil buffer database
2022-05-05 03:02:17.787746+00:00 - info - saving audit trail in Anvil buffer database
2022-05-05 03:02:25.031218+00:00 - info - saving document in Anvil buffer database
2022-05-05 03:02:26.014853+00:00 - info - saving audit trail in Anvil buffer database
2022-05-05 03:02:32.976062+00:00 - info - saving document in Anvil buffer database
2022-05-05 03:02:33.464905+00:00 - info - saving audit trail in Anvil buffer database
2022-05-05 03:02:39.497643+00:00 - info - saving document in Anvil buffer database
2022-05-05 03:02:40.150628+00:00 - info - saving audit trail in Anvil buffer database
2022-05-05 03:02:46.008466+00:00 - info - saving document in Anvil buffer database
2022-05-05 03:02:46.855679+00:00 - info - saving audit trail in Anvil buffer database
2022-05-05 03:02:53.286981+00:00 - info - saving document in Anvil buffer database
2022-05-05 03:02:53.853669+00:00 - info - saving audit trail in Anvil buffer database
2022-05-05 03:02:59.365530+00:00 - info - saving document in Anvil buffer database
2022-05-05 03:03:00.069294+00:00 - info - saving audit trail in Anvil buffer database
2022-05-05 03:03:05.745416+00:00 - info - saving document in Anvil buffer database
2022-05-05 03:03:06.742689+00:00 - info - saving audit trail in Anvil buffer database
2022-05-05 03:03:13.098978+00:00 - info - saving document in Anvil buffer database
2022-05-05 03:03:13.747621+00:00 - info - saving audit trail in Anvil buffer database
2022-05-05 03:03:20.175714+00:00 - info - saving document in Anvil buffer database
2022-05-05 03:03:20.906129+00:00 - info - saving audit trail in Anvil buffer database
2022-05-05 03:03:28.356071+00:00 - info - saving document in Anvil buffer database
2022-05-05 03:03:29.592448+00:00 - info - saving audit trail in Anvil buffer database
The document buffer is limited to 1000 rows not to exceed DB usage limits.
I feel hopeless and tired of keep trying again until it completes.