Closed panjunyong closed 1 year ago
You'll want to stop all processes using RelStorage, and then remove any persistent cache files you have. If you're still using memcache, you'll also want to clear that out too. Then you can start the processes back up and things should be fine. If they're not, then there's a fundamental problem in your database (for example, failed replication) that will need to be fixed.
Thanks for your reply.
I am not using the cache-local-dir option, so no persistent cache. And I am not using memcache either.
I tried restart all processes, but it doesn't work. I also checked database tables, and no problem found.
So any other hint?
I just used zodbconvert, and converted to a FileStorage data.fs without any error.
And restart the process and all works fine now.
Now I want to convert it back to relstorage/mysql and have a try.
After convert the data.fs back to relstorage/mysql, all works fine now.
Maybe RelStorage should have a simple recovering script to fix the problem.
I'm afraid it's not that simple; there's a real chance you've lost data by ignoring the problem.
But I fixed the problem using zodbconvert without any error or warning.
Does that mean zodbconvert may lost data?
I have used Relstorage for a long time, and it is quite stable.
But today our server raises CacheConsistencyError when any transaction commited.
I am using RelStorage 3.2 with mysql.
How to fix this problem?