Hi all,
yesterday I upgrade skrooge to 1.12 stable, opened my working file (that has been converted with success), inserted a few operations in it and closed everything.
Today, just after launching the program I got an error: "Oups your file seems corrupted", and I tried the recovery. The final result was the archive was empty (no operations), only accounts and categories where in place.
Closing and re-opening the program I got the same "Oups.." and in console the following:

Code: Select all

%skrooge
##WARNING: PRAGMA journal_mode=MEMORY                             
##         returns :database disk image is malformed Unable to execute statement
##WARNING: SELECT * FROM parameters WHERE t_name='SKG_SQLITE_LAST_VERSION' AND t_uuid_parent='document'
##         returns :database disk image is malformed Unable to execute statement
##DEBUG: skrooge(8835)/kio (KDirModel) KDirModelPrivate::_k_slotDeleteItems: No node found for item that was just removed: KUrl("file:///home/luca/tmp/luca.skg")


Luckily, having done the upgrade yesterday, I had a backup copy, so I reopened it, it was converted again, I inserted again the operations and closed.
Now, each time I open the archive, while it works, the warning about the archive being restored from the backup copy is shown.
Please note I've tried both having the archive on usb stick or hard disk.
Any suggestion?

It happened again.
This is what is going on, before opening the situation is:

Code: Select all

$ ls -l *skg*
-rwx------ 1 luca luca 4640786 gen 21 14:56 luca.skg
-rwx------ 1 luca luca 4639762 gen 21 14:56 luca.skg.old


Now I try to open skrooge (I enabled debug output with kdebugdialog):

Code: Select all

$ skrooge
##WARNING: QDBusConnection: session D-Bus connection created before QCoreApplication. Application may misbehave.
##WARNING: QDBusConnection: session D-Bus connection created before QCoreApplication. Application may misbehave.
##DEBUG: skrooge(9450)/kdecore (KSycoca) KSycocaPrivate::openDatabase: Trying to open ksycoca from "/var/tmp/kdecache-luca/ksycoca4"
$ ##DEBUG: skrooge(9450)/kio (bookmarks) KBookmarkManager::KBookmarkManager: starting KDirWatch for  "/home/luca/.local/share/user-places.xbel"
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x1429d20)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::protoQ: creating ProtoQueue instance for "file"
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::ProtoQueue::ProtoQueue: m_maxConnectionsTotal: 5 m_maxConnectionsPerHost: 5
##DEBUG: skrooge(9450)/kio (Slave) KIO::Slave::createSlave: createSlave "file" for KUrl("file:///media/veracrypt1/CONTABILITA/")
##DEBUG: skrooge(9450)/kio (KIOConnection) KIO::ConnectionServer::listenForRemote: Listening on  "local:/run/user/1000/ksocket-luca/skroogeDs9450.slave-socket"
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::StatJob(0x1429d20) KIO::Slave(0x14de150)
##DEBUG: skrooge(9450)/kio (KDirListerCache) KDirListerCache::listDir: Listing directory: KUrl("file:///media/veracrypt1/CONTABILITA")
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x1574ce0)
##DEBUG: skrooge(9450)/kio KNFSShare::KNFSSharePrivate::findExportsFile: Could not find exports file! /etc/exports doesn't exist. Configure it in share/config/knfsshare, [General], exportsFile=....
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::ListJob(0x1574ce0) KIO::Slave(0x14de150)
##DEBUG: skrooge(9450)/kio (KDirListerCache) KDirListerCache::slotResult: finished listing KUrl("file:///media/veracrypt1/CONTABILITA")
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x16510e0)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::StatJob(0x16510e0) KIO::Slave(0x14de150)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x18a9df0)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::protoQ: creating ProtoQueue instance for "thumbnail"
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::ProtoQueue::ProtoQueue: m_maxConnectionsTotal: 1 m_maxConnectionsPerHost: 1
##DEBUG: skrooge(9450)/kio (KIOConnection) KIO::ConnectionServer::listenForRemote: Listening on  "local:/run/user/1000/ksocket-luca/skroogeoN9450.slave-socket"
##DEBUG: skrooge(9450)/kio (Slave) KIO::Slave::createSlave: createSlave "thumbnail" for KUrl("thumbnail:/media/veracrypt1/CONTABILITA/STORICI")
##DEBUG: skrooge(9450)/kio (KIOConnection) KIO::ConnectionServer::listenForRemote: Listening on  "local:/run/user/1000/ksocket-luca/skroogedu9450.slave-socket"
##DEBUG: skrooge(9450)/kio (KIOJob) KIO::SlaveInterface::dispatch: error  104   "Cannot create thumbnail for directory"
##DEBUG: skrooge(9450)/kio (KIOJob) KIO::TransferJob::slotFinished: KUrl("thumbnail:/media/veracrypt1/CONTABILITA/STORICI")
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::TransferJob(0x18a9df0) KIO::Slave(0x134de70)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x166e060)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::StatJob(0x166e060) KIO::Slave(0x14de150)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x1463350)
##DEBUG: skrooge(9450)/kio (KIOJob) KIO::SlaveInterface::dispatch: error  104   "Cannot create thumbnail for directory"
##DEBUG: skrooge(9450)/kio (KIOJob) KIO::TransferJob::slotFinished: KUrl("thumbnail:/media/veracrypt1/CONTABILITA/COMUNE_DI_MODENA")
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::TransferJob(0x1463350) KIO::Slave(0x134de70)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x1331c50)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::StatJob(0x1331c50) KIO::Slave(0x14de150)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x146fce0)
##DEBUG: skrooge(9450)/kio (KIOJob) KIO::SlaveInterface::dispatch: error  104   "Cannot create thumbnail for directory"
##DEBUG: skrooge(9450)/kio (KIOJob) KIO::TransferJob::slotFinished: KUrl("thumbnail:/media/veracrypt1/CONTABILITA/DICHIARAZIONE_REDDITI_IN_CORSO")
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::TransferJob(0x146fce0) KIO::Slave(0x134de70)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x153ccb0)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::StatJob(0x153ccb0) KIO::Slave(0x14de150)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x147db30)
##DEBUG: skrooge(9450)/kio (KIOJob) KIO::SlaveInterface::dispatch: error  104   "Cannot create thumbnail for directory"
##DEBUG: skrooge(9450)/kio (KIOJob) KIO::TransferJob::slotFinished: KUrl("thumbnail:/media/veracrypt1/CONTABILITA/skrooge-backup")
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::TransferJob(0x147db30) KIO::Slave(0x134de70)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x11c26d0)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::StatJob(0x11c26d0) KIO::Slave(0x14de150)
##DEBUG: skrooge(9450)/kio (KDirListerCache) KDirListerCache::stopListingUrl: KDirLister(0x1087850)  url= KUrl("file:///media/veracrypt1/CONTABILITA")
##DEBUG: skrooge(9450)/kio (KDirListerCache) KDirListerCache::stopListingUrl: KDirLister(0x1087850)  url= KUrl("file:///media/veracrypt1/CONTABILITA")
##DEBUG: skrooge(9450)/kio (KDirListerCache) KDirListerCache::forgetDirs: KDirLister(0x1087850) item moved into cache: KUrl("file:///media/veracrypt1/CONTABILITA")
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x140bfc0)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::DirectCopyJob(0x140bfc0) KIO::Slave(0x14de150)
##WARNING: PRAGMA journal_mode=MEMORY
##         returns :database disk image is malformed Unable to execute statement
##WARNING: SELECT * FROM parameters WHERE t_name='SKG_SQLITE_LAST_VERSION' AND t_uuid_parent='document'
##         returns :database disk image is malformed Unable to execute statement
##DEBUG: skrooge(9450)/kio (KDirListerCache) KDirListerCache::updateDirectory: KUrl("file:///media/veracrypt1/CONTABILITA")
##DEBUG: skrooge(9450)/kio (KDirListerCache) KDirListerCache::slotFileDirty: Doing stat on: "/media/veracrypt1/CONTABILITA/.luca.skg.wrkBz9450.new"
##DEBUG: skrooge(9450)/kio (KDirListerCache) KDirListerCache::updateDirectory: KUrl("file:///media/veracrypt1/CONTABILITA")
##DEBUG: skrooge(9450)/kio (KDirListerCache) KDirListerCache::processPendingUpdates: "/media/veracrypt1/CONTABILITA"
##DEBUG: skrooge(9450)/kdecore (K*TimeZone*) KSystemTimeZonesPrivate::instance: instance(): ... initialised
##DEBUG: skrooge(9450)/kdecore (K*TimeZone*) KSystemTimeZonesPrivate::readConfig: readConfig(): local zone= "Europe/Rome"
##DEBUG: skrooge(9450)/kdecore (K*TimeZone*) KSystemTimeZonesPrivate::readZoneTab: readZoneTab( "/usr/share/zoneinfo/zone.tab" )
##DEBUG: skrooge(9450)/kdeui (KNotification) KNotificationManager::notificationClosed: 32



and I got [ERR-14]: Oups, this file seems to be corrupted.
If I try to recover the file I got [ERR-5]: Impossible to recover this file and in the console:

Code: Select all

##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x126d2f0)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::StatJob(0x126d2f0) KIO::Slave(0x14de150)
##DEBUG: skrooge(9450)/kio (KDirListerCache) KDirListerCache::listDir: Entry in cache: KUrl("file:///media/veracrypt1/CONTABILITA")
##DEBUG: skrooge(9450)/kio (KDirListerCache) KDirListerCache::updateDirectory: KUrl("file:///media/veracrypt1/CONTABILITA")
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x1499190)
##DEBUG: skrooge(9450)/kio (KDirListerCache) KDirListerCache::updateDirectory: update started in KUrl("file:///media/veracrypt1/CONTABILITA")
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x13f62d0)
##DEBUG: skrooge(9450)/kio (Slave) KIO::Slave::createSlave: createSlave "file" for KUrl("file:///media/veracrypt1/CONTABILITA/STORICI")
##DEBUG: skrooge(9450)/kio (KIOConnection) KIO::ConnectionServer::listenForRemote: Listening on  "local:/run/user/1000/ksocket-luca/skroogeVY9450.slave-socket"
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::ListJob(0x1499190) KIO::Slave(0x14de150)
##DEBUG: skrooge(9450)/kio (KDirListerCache) KDirListerCache::slotUpdateResult: finished update KUrl("file:///media/veracrypt1/CONTABILITA")
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::StatJob(0x13f62d0) KIO::Slave(0x9d9650)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x13f4290)
##DEBUG: skrooge(9450)/kio (KIOJob) KIO::SlaveInterface::dispatch: error  104   "Cannot create thumbnail for directory"
##DEBUG: skrooge(9450)/kio (KIOJob) KIO::TransferJob::slotFinished: KUrl("thumbnail:/media/veracrypt1/CONTABILITA/STORICI")
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::TransferJob(0x13f4290) KIO::Slave(0x134de70)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x16e3da0)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::StatJob(0x16e3da0) KIO::Slave(0x9d9650)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x1603380)
##DEBUG: skrooge(9450)/kio (KIOJob) KIO::SlaveInterface::dispatch: error  104   "Cannot create thumbnail for directory"
##DEBUG: skrooge(9450)/kio (KIOJob) KIO::TransferJob::slotFinished: KUrl("thumbnail:/media/veracrypt1/CONTABILITA/COMUNE_DI_MODENA")
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::TransferJob(0x1603380) KIO::Slave(0x134de70)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x188b9a0)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::StatJob(0x188b9a0) KIO::Slave(0x9d9650)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0xbede00)
##DEBUG: skrooge(9450)/kio (KIOJob) KIO::SlaveInterface::dispatch: error  104   "Cannot create thumbnail for directory"
##DEBUG: skrooge(9450)/kio (KIOJob) KIO::TransferJob::slotFinished: KUrl("thumbnail:/media/veracrypt1/CONTABILITA/DICHIARAZIONE_REDDITI_IN_CORSO")
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::TransferJob(0xbede00) KIO::Slave(0x134de70)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x13f53c0)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::StatJob(0x13f53c0) KIO::Slave(0x9d9650)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x1703e80)
##DEBUG: skrooge(9450)/kio (KIOJob) KIO::SlaveInterface::dispatch: error  104   "Cannot create thumbnail for directory"
##DEBUG: skrooge(9450)/kio (KIOJob) KIO::TransferJob::slotFinished: KUrl("thumbnail:/media/veracrypt1/CONTABILITA/skrooge-backup")
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::TransferJob(0x1703e80) KIO::Slave(0x134de70)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x15b0a40)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::StatJob(0x15b0a40) KIO::Slave(0x9d9650)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x1105cb0)
##DEBUG: skrooge(9450)/kio (KIOJob) KIO::SlaveInterface::dispatch: error  104   "Cannot create thumbnail for directory"
##DEBUG: skrooge(9450)/kio (KIOJob) KIO::TransferJob::slotFinished: KUrl("thumbnail:/media/veracrypt1/CONTABILITA/DICHIARAZIONE_REDDITI_IN_CORSO")
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::TransferJob(0x1105cb0) KIO::Slave(0x134de70)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x12e4d40)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::StatJob(0x12e4d40) KIO::Slave(0x9d9650)
##DEBUG: skrooge(9450)/kio (KDirListerCache) KDirListerCache::stopListingUrl: KDirLister(0x1132c00)  url= KUrl("file:///media/veracrypt1/CONTABILITA")
##DEBUG: skrooge(9450)/kio (KDirListerCache) KDirListerCache::stopListingUrl: KDirLister(0x1132c00)  url= KUrl("file:///media/veracrypt1/CONTABILITA")
##DEBUG: skrooge(9450)/kio (KDirListerCache) KDirListerCache::forgetDirs: KDirLister(0x1132c00) item moved into cache: KUrl("file:///media/veracrypt1/CONTABILITA")
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x11ca3c0)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::DirectCopyJob(0x11ca3c0) KIO::Slave(0x9d9650)
##WARNING: PRAGMA journal_mode=MEMORY
##         returns :database disk image is malformed Unable to execute statement
##WARNING: SELECT * FROM parameters WHERE t_name='SKG_SQLITE_LAST_VERSION' AND t_uuid_parent='document'
##         returns :database disk image is malformed Unable to execute statement
##DEBUG: skrooge(9450)/kio (KDirListerCache) KDirListerCache::updateDirectory: KUrl("file:///media/veracrypt1/CONTABILITA")
##DEBUG: skrooge(9450)/kio (KDirListerCache) KDirListerCache::slotFileDirty: Doing stat on: "/media/veracrypt1/CONTABILITA/.luca.skg.wrkKS9450.new"
##DEBUG: skrooge(9450)/kio (KDirListerCache) KDirListerCache::updateDirectory: KUrl("file:///media/veracrypt1/CONTABILITA")
##DEBUG: skrooge(9450)/kio (KDirListerCache) KDirListerCache::processPendingUpdates: "/media/veracrypt1/CONTABILITA"
##DEBUG: skrooge(9450)/kdeui (KNotification) KNotificationManager::notificationClosed: 33
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x159ec20)
##DEBUG: skrooge(9450)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::DirectCopyJob(0x159ec20) KIO::Slave(0x9d9650)
##DEBUG: skrooge(9450)/kdeui (KNotification) KNotificationManager::notificationClosed: 34


SQLite3 is at version 3.8.11.1.
Now I'm scared that every time I work on the file I will got it damaged.

If I try to reopen the file again I got [ERR-5]: Failed to open '/media/veracrypt1/CONTABILITA/luca.skg'. and in the console:

Code: Select all

$ skrooge
##WARNING: QDBusConnection: session D-Bus connection created before QCoreApplication. Application may misbehave.
##WARNING: QDBusConnection: session D-Bus connection created before QCoreApplication. Application may misbehave.
##DEBUG: skrooge(9604)/kdecore (KSycoca) KSycocaPrivate::openDatabase: Trying to open ksycoca from "/var/tmp/kdecache-luca/ksycoca4"
$ ##DEBUG: skrooge(9604)/kio (bookmarks) KBookmarkManager::KBookmarkManager: starting KDirWatch for  "/home/luca/.local/share/user-places.xbel"
##DEBUG: skrooge(9604)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x27059d0)
##DEBUG: skrooge(9604)/kio (Scheduler) KIO::SchedulerPrivate::protoQ: creating ProtoQueue instance for "file"
##DEBUG: skrooge(9604)/kio (Scheduler) KIO::ProtoQueue::ProtoQueue: m_maxConnectionsTotal: 5 m_maxConnectionsPerHost: 5
##DEBUG: skrooge(9604)/kio (Slave) KIO::Slave::createSlave: createSlave "file" for KUrl("file:///media/veracrypt1/CONTABILITA/")
##DEBUG: skrooge(9604)/kio (KIOConnection) KIO::ConnectionServer::listenForRemote: Listening on  "local:/run/user/1000/ksocket-luca/skroogeDs9604.slave-socket"
##DEBUG: skrooge(9604)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::StatJob(0x27059d0) KIO::Slave(0x2732250)
##DEBUG: skrooge(9604)/kio (KDirListerCache) KDirListerCache::listDir: Listing directory: KUrl("file:///media/veracrypt1/CONTABILITA")
##DEBUG: skrooge(9604)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x244b6d0)
##DEBUG: skrooge(9604)/kio KNFSShare::KNFSSharePrivate::findExportsFile: Could not find exports file! /etc/exports doesn't exist. Configure it in share/config/knfsshare, [General], exportsFile=....
##DEBUG: skrooge(9604)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::ListJob(0x244b6d0) KIO::Slave(0x2732250)
##DEBUG: skrooge(9604)/kio (KDirListerCache) KDirListerCache::slotResult: finished listing KUrl("file:///media/veracrypt1/CONTABILITA")
##DEBUG: skrooge(9604)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x2652380)
##DEBUG: skrooge(9604)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::StatJob(0x2652380) KIO::Slave(0x2732250)
##DEBUG: skrooge(9604)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x277a5a0)
##DEBUG: skrooge(9604)/kio (Scheduler) KIO::SchedulerPrivate::protoQ: creating ProtoQueue instance for "thumbnail"
##DEBUG: skrooge(9604)/kio (Scheduler) KIO::ProtoQueue::ProtoQueue: m_maxConnectionsTotal: 1 m_maxConnectionsPerHost: 1
##DEBUG: skrooge(9604)/kio (KIOConnection) KIO::ConnectionServer::listenForRemote: Listening on  "local:/run/user/1000/ksocket-luca/skroogeVr9604.slave-socket"
##DEBUG: skrooge(9604)/kio (Slave) KIO::Slave::createSlave: createSlave "thumbnail" for KUrl("thumbnail:/media/veracrypt1/CONTABILITA/STORICI")
##DEBUG: skrooge(9604)/kio (KIOConnection) KIO::ConnectionServer::listenForRemote: Listening on  "local:/run/user/1000/ksocket-luca/skroogebc9604.slave-socket"
##DEBUG: skrooge(9604)/kio (KIOJob) KIO::SlaveInterface::dispatch: error  104   "Cannot create thumbnail for directory"
##DEBUG: skrooge(9604)/kio (KIOJob) KIO::TransferJob::slotFinished: KUrl("thumbnail:/media/veracrypt1/CONTABILITA/STORICI")
##DEBUG: skrooge(9604)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::TransferJob(0x277a5a0) KIO::Slave(0x26b4240)
##DEBUG: skrooge(9604)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x2358d30)
##DEBUG: skrooge(9604)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::StatJob(0x2358d30) KIO::Slave(0x2732250)
##DEBUG: skrooge(9604)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x26529d0)
##DEBUG: skrooge(9604)/kio (KIOJob) KIO::SlaveInterface::dispatch: error  104   "Cannot create thumbnail for directory"
##DEBUG: skrooge(9604)/kio (KIOJob) KIO::TransferJob::slotFinished: KUrl("thumbnail:/media/veracrypt1/CONTABILITA/COMUNE_DI_MODENA")
##DEBUG: skrooge(9604)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::TransferJob(0x26529d0) KIO::Slave(0x26b4240)
##DEBUG: skrooge(9604)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x27f62b0)
##DEBUG: skrooge(9604)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::StatJob(0x27f62b0) KIO::Slave(0x2732250)
##DEBUG: skrooge(9604)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x2176af0)
##DEBUG: skrooge(9604)/kio (KIOJob) KIO::SlaveInterface::dispatch: error  104   "Cannot create thumbnail for directory"
##DEBUG: skrooge(9604)/kio (KIOJob) KIO::TransferJob::slotFinished: KUrl("thumbnail:/media/veracrypt1/CONTABILITA/DICHIARAZIONE_REDDITI_IN_CORSO")
##DEBUG: skrooge(9604)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::TransferJob(0x2176af0) KIO::Slave(0x26b4240)
##DEBUG: skrooge(9604)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x26a38a0)
##DEBUG: skrooge(9604)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::StatJob(0x26a38a0) KIO::Slave(0x2732250)
##DEBUG: skrooge(9604)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x25cee30)
##DEBUG: skrooge(9604)/kio (KIOJob) KIO::SlaveInterface::dispatch: error  104   "Cannot create thumbnail for directory"
##DEBUG: skrooge(9604)/kio (KIOJob) KIO::TransferJob::slotFinished: KUrl("thumbnail:/media/veracrypt1/CONTABILITA/skrooge-backup")
##DEBUG: skrooge(9604)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::TransferJob(0x25cee30) KIO::Slave(0x26b4240)
##DEBUG: skrooge(9604)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x2a725e0)
##DEBUG: skrooge(9604)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::StatJob(0x2a725e0) KIO::Slave(0x2732250)
##DEBUG: skrooge(9604)/kio (KDirListerCache) KDirListerCache::stopListingUrl: KDirLister(0x1ecc840)  url= KUrl("file:///media/veracrypt1/CONTABILITA")
##DEBUG: skrooge(9604)/kio (KDirListerCache) KDirListerCache::stopListingUrl: KDirLister(0x1ecc840)  url= KUrl("file:///media/veracrypt1/CONTABILITA")
##DEBUG: skrooge(9604)/kio (KDirListerCache) KDirListerCache::forgetDirs: KDirLister(0x1ecc840) item moved into cache: KUrl("file:///media/veracrypt1/CONTABILITA")
##DEBUG: skrooge(9604)/kio (Scheduler) KIO::SchedulerPrivate::doJob: KIO::SimpleJob(0x2707c80)
##DEBUG: skrooge(9604)/kio (Scheduler) KIO::SchedulerPrivate::jobFinished: KIO::DirectCopyJob(0x2707c80) KIO::Slave(0x2732250)
##WARNING: insert into doctransaction (d_date, t_name, i_parent) values ('2016-01-21 15:17:01','#INTERNAL#Migrate document', 0);
##         returns :no such table: doctransaction Unable to execute statement
##WARNING: SELECT * FROM parameters WHERE t_name='SKG_SQLITE_LAST_VERSION' AND t_uuid_parent='document'
##         returns :no such table: parameters Unable to execute statement
##DEBUG: skrooge(9604)/kio (KDirListerCache) KDirListerCache::updateDirectory: KUrl("file:///media/veracrypt1/CONTABILITA")
##DEBUG: skrooge(9604)/kio (KDirListerCache) KDirListerCache::slotFileDirty: Doing stat on: "/media/veracrypt1/CONTABILITA/.luca.skg.wrkAK9604.new"
##DEBUG: skrooge(9604)/kio (KDirListerCache) KDirListerCache::updateDirectory: KUrl("file:///media/veracrypt1/CONTABILITA")
##DEBUG: skrooge(9604)/kio (KDirListerCache) KDirListerCache::processPendingUpdates: "/media/veracrypt1/CONTABILITA"
##DEBUG: skrooge(9604)/kdecore (K*TimeZone*) KSystemTimeZonesPrivate::instance: instance(): ... initialised
##DEBUG: skrooge(9604)/kdecore (K*TimeZone*) KSystemTimeZonesPrivate::readConfig: readConfig(): local zone= "Europe/Rome"
##DEBUG: skrooge(9604)/kdecore (K*TimeZone*) KSystemTimeZonesPrivate::readZoneTab: readZoneTab( "/usr/share/zoneinfo/zone.tab" )
##DEBUG: skrooge(9604)/kdeui (KNotification) KNotificationManager::notificationClosed: 36


If I sqlite into the skrooge file I got:

Code: Select all

$ sqlite3 luca.skg
SQLite version 3.8.11.1 2015-07-29 20:00:57
sqlite> .schema
Error: file is encrypted or is not a database


Hi,

When Skrooge tries to open /media/veracrypt1/CONTABILITA/luca.skg, first, Skrooge tries to create the sqlite file in /media/veracrypt1/CONTABILITA/.luca.skg.wrk and tries to open it.

I don't know why you have this error.
Is it due to veracrypt? I don't know.
To be sure, could you copy your file in your $HOME and try to open it?

smankowski wrote:Hi,

When Skrooge tries to open /media/veracrypt1/CONTABILITA/luca.skg, first, Skrooge tries to create the sqlite file in /media/veracrypt1/CONTABILITA/.luca.skg.wrk and tries to open it.

I don't know why you have this error.
Is it due to veracrypt? I don't know.
To be sure, could you copy your file in your $HOME and try to open it?

I did it and the same happened.
Now I'm using it since days without having the issue again, and I'm making regular bcakups.
I thought a disk space shortage, but I had enough space to duplicate my .skg file at all (i.e., is the .rk file a lot bigger?)

As a side note, is there a way to configure skroog to place the working file in another filesystem (e.g., a memory file system)?

fluca1978 wrote:As a side note, is there a way to configure skroog to place the working file in another filesystem (e.g., a memory file system)?

There is no option.
Skrooge creates the working copy in the same directory except if the is not write access in this directory.
In this case, /tmp is used.

It just happeneed again:

Code: Select all

[ERR-5]: Impossible to recover this file
[ERR-14]: Oups, this file seems to be corrupted
[ERR-10011]: database disk image is malformed Unable to execute statement
[ERR-10011]: PRAGMA journal_mode=MEMORY

This time I was on an unencrypted device but with 18 MB of free space left, my .skg file is 7 MB. Making more free space and taking it back from a backup copy did work. How much free space do I need to be "safe"?

Hi,

In fact, when you want to do a recovery, you have in the folder:
1- The main file: yourfile.skg
2- The working copy: .yourfile.skg.wrk
3- A temporary sqlite file to try the recovery: yourfile_recovered.sqlite
4- The target recovery file: yourfile_recovered.skg

So, we can say that you need 4x the size of your file.
In your case: 7x4=28 MB