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.