https://bugs.kde.org/show_bug.cgi?id=479900
--- Comment #6 from j...@acm.org <j...@acm.org> --- (In reply to Maik Qualmann from comment #2) > Corrupt files are not caused by the database used. As Gilles already writes, > what do you mean by "corrupt", files no longer readable or just missing > metadata. > We have had users using SQLite with over 200,000 images. > Definitely check your drives for errors. I also work a little in this area > and SSD hard drives can also have very ugly data area errors. > > Maik But the Symptoms I was seeing seem to be caused by the database. 0 bad sectors on either drive. I've checked. Maria DB seems to have fixed the problem, but only going forward, the data loss seems to be permanent (not in the files, not in the database). First symptom? Select a tag in the left frame. Select images in the Thumbnails or Preview. Notice that some show no tags in the right frame, but when adding a tag, all the others miraculously appear. Later symptoms involve actual data loss. I;ve switched to MariaDB. I've now made a couple hundred thousand changes to the files (the easy ones). No data loss so far. Question. Are those with 200K images in SQL Lite on Windows? If not, the data may not apply. I'm using windows. -- You are receiving this mail because: You are watching all bug changes.
