List of sieve scripts got out of sync with the #sieve folder

[alecpl]

Cyrus 3.6.3 with Murder.

For some reason the list of scripts stored in the sqlite index got out-of-sync with the content of the #sieve folder. It might have been our fault when we did some data migration. Right now we can't say it got broken during normal operation.

To find out what's going on encountered some issues:

1. reconstructing the #sieve folder didn't fix the issue (it did not de-activate nor remove records from sieve_scripts table).
2. dav.db file is not mentioned at https://www.cyrusimap.org/3.8/imap/concepts/deployment/databases.html, sieve is mentioned in DAV Index (<userid>.dav) section, but the file is dav.db not <userid>.dav. If it was properly documented or the file was sieve.db we would find the issue faster.
3. maybe accessing a sieve script that exists in the sieve_scripts table, but not in the #sieve folder should trigger re-sync?

It would be much easier if 1. or 3. just worked for this case, but documentation could be clearer too.

[ksmurchison]

Did you try a dav_reconstruct on the user in question? dav_reconstruct is what updates the DAV DB.

[alecpl]

It wasn't me dealing with the server, but I believe my colleague used just the normal reconstruct on the folder, not dav_reconstruct on a user.