Hello hydrus,
I have migrated machines and ever since I am getting a DB malformed error.
I have been analyzing and testing with the database and am confident that it is not malformed. I only encounter this issue when trying to update the PTR, so far I have not encountered it otherwise.
Even after resetting the process cache, backing up then restoring the db, and more, the problem persists, and the service enters a paused state.
Is any of this useful for you to hear?
Attached is a customary bonus picture, and here is my traceback.
DBException DatabaseError: database disk image is malformed Traceback (most recent call last): File "include\ClientServices.py", line 1436, in SyncProcessUpdates ( did_some_work, did_everything ) = HG.client_controller.WriteSynchronous( 'process_repository', self._service_key, only_when_idle, stop_time ) File "include\HydrusController.py", line 705, in WriteSynchronous return self._Write( action, HC.LOW_PRIORITY, True, *args, **kwargs ) File "include\HydrusController.py", line 209, in _Write result = self.db.Write( action, priority, synchronous, *args, **kwargs ) File "include\HydrusDB.py", line 914, in Write if synchronous: return job.GetResult() File "include\HydrusData.py", line 1503, in GetResult raise e DBException: DatabaseError: database disk image is malformed Database Traceback (most recent call last): File "include\HydrusDB.py", line 536, in _ProcessJob result = self._Write( action, *args, **kwargs ) File "include\ClientDB.py", line 11823, in _Write elif action == 'process_repository': result = self._ProcessRepositoryUpdates( *args, **kwargs ) File "include\ClientDB.py", line 8597, in _ProcessRepositoryUpdates self._ProcessRepositoryDefinitionUpdate( service_id, definition_update ) File "include\ClientDB.py", line 8456, in _ProcessRepositoryDefinitionUpdate self._CacheRepositoryAddHashes( service_id, service_hash_ids_to_hashes ) File "include\ClientDB.py", line 645, in _CacheRepositoryAddHashes hash_id = self._GetHashId( hash ) File "include\ClientDB.py", line 4120, in _GetHashId self._c.execute( 'INSERT INTO hashes ( hash ) VALUES ( ? );', ( sqlite3.Binary( hash ), ) ) DatabaseError: database disk image is malformed Database Traceback (most recent call last): File "include\HydrusDB.py", line 536, in _ProcessJob result = self._Write( action, *args, **kwargs ) File "include\ClientDB.py", line 11823, in _Write elif action == 'process_repository': result = self._ProcessRepositoryUpdates( *args, **kwargs ) File "include\ClientDB.py", line 8597, in _ProcessRepositoryUpdates self._ProcessRepositoryDefinitionUpdate( service_id, definition_update ) File "include\ClientDB.py", line 8456, in _ProcessRepositoryDefinitionUpdate self._CacheRepositoryAddHashes( service_id, service_hash_ids_to_hashes ) File "include\ClientDB.py", line 645, in _CacheRepositoryAddHashes hash_id = self._GetHashId( hash ) File "include\ClientDB.py", line 4120, in _GetHashId self._c.execute( 'INSERT INTO hashes ( hash ) VALUES ( ? );', ( sqlite3.Binary( hash ), ) ) DatabaseError: database disk image is malformed
If I can help gather information, please let me know. Thanks.