4 ms·
During some low-impact exploratory work on my local machine recently, I launched a Jupyter Lab notebook that connected to a SQLite db that was in a directory MS
by nrjames 4y ago
During some low-impact exploratory work on my local machine recently, I launched a Jupyter Lab notebook that connected to a SQLite db that was in a directory MS One Drive had claimed. The sync processes had nuked the db within five minutes. I was able to recreate the db easily, from csv files. Important lesson learned!
- psnehanshu 4y agoWhat do you mean by "nuked", did OneDrive delete it? It shouldn't delete unless it was deleted in the cloud by someone (or you).
- nrjames 4y agoNo, I think what happened is that OneDrive overwrote the local db with a version from the cloud that was several seconds older, corrupting everything. Or maybe it just overwrote the lock file? I'm not completely sure. Whatever it was, it appears that OneDrive replace a newer version of the db with an older or partial/corrupted one from a prior sync. I should mention that I was able to repeat the corrupting problem reliably. The problem disappeared when I moved to a working directory that was not monitored by OneDrive. I was setting up a very simple db from a few CSV files, for use in a data science exercise for a course. There was nothing interesting happening in my code at all-- maybe a simple table join sql query, at most.