Automatic database backup failed - simple editing tasks very slow

Audacity has suddenly started slowing down and hanging when performing simple editing tasks, giving the above message. I’m using v.3.7.7 on Windows 11. The project is not a big one - currently 5 tracks, 4 minutes in length. The problem details are as follows:

“timestamp”: 1775473681,
“event_id”: “39d233f1be35784db24cf5b6307275cf”,
“platform”: “native”,
“release”: “audacity@3.7.7”,
“contexts”: {
“os”: {
“type”: “os”,
“name”: “Windows”,
“version”: “10.0.26200”
}
},
“exception”: {
“values”: [
{
“type”: “Warning”,
“value”: “Automatic database backup failed.”,
“mechanism”: {
“type”: “runtime_error”,
“handled”: false,
“data”: {
“sqlite3.query”: “INSERT INTO (id, dict, doc) VALUES(1, ?1, ?2) ON CONFLICT(id) DO UPDATE SET dict = ?1, doc = ?2;”,
“sqlite3.rc”: “18”,
“sqlite3.context”: “ProjectGileIO::WriteDoc::step”
}
}
}
]
}
}

It looks like the sqlight database has something that needs to be re-indexed or repaired. If this continues to happen after you restart the computer, do a Google search for “sqlight repair”.

Thanks. I think the issue has now been fixed, or fixed itself. I won’t bore you with details because I think it was very specific to how my PC folder hierarchy was (wrongly) set up after I fiddled around with it, and the place I was attempting to save the file in ran out of space (or something…). Stuff has now been moved back to where it should be, and Audacity is now working fine. Touch wood …
But thanks for the tip, and if it happens again I’ll remember sqlight. :slightly_smiling_face: