I have been running CRDB for 1 year, and I am testing backups (for good measure). The database is ~1GB and has 2115 ranges, running v21.1.7.
restore from 'gs://backups/2021-08-20_1'; command does not seem to end. It gets stuck at 99% (on the jobs page). It has been running for 3+ hours now.
The CPU usage and Disk Write IOPS is high, and Live Bytes is going up very very slowly.
The only other relevant thing I can see that in the “Statments” tab on the UI, it shows that the Execution Count for “INSERT INTO system.table_statistics” is 1M+.
What can I do to get RESTORE to work? I am currently very worried that I do not have a way to recover the database.
Let me know if any other information is needed.
Thank you in advance.