Page 1 of 1

DatabaseError

Posted: March 28th, 2014, 8:16 pm
by ugokanain
I been getting a few errors:

Code: Select all

Traceback (most recent call last):
  File "sabnzbd/database.pyc", line 104, in execute
DatabaseError: database disk image is malformed
2014-03-28 19:00:22,936::ERROR::[database:111] SQL Command Failed, see log
2014-03-28 19:00:22,936::DEBUG::[database:112] SQL: select count(*) from History WHERE name LIKE ?
2014-03-28 19:00:22,936::INFO::[database:113] Traceback: 
Traceback (most recent call last):
  File "sabnzbd/database.pyc", line 104, in execute
DatabaseError: database disk image is malformed
2014-03-28 19:00:22,936::ERROR::[database:111] SQL Command Failed, see log
2014-03-28 19:00:22,936::DEBUG::[database:112] SQL: SELECT * FROM history WHERE name LIKE ? ORDER BY completed desc LIMIT ?, ?
2014-03-28 19:00:22,937::INFO::[database:113] Traceback: 
Restarted Sab, even stopped all dls, but still get this error

Just got a new error
2014-03-28 19:21:44,333::DEBUG::[database:112] SQL: INSERT INTO history (completed, name, nzb_name, category, pp, script, report,
url, status, nzo_id, storage, path, script_log, script_line, download_time, postproc_time, stage_log,
downloaded, completeness, fail_message, url_info, bytes)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2014-03-28 19:21:44,334::INFO::[database:113] Traceback:
Traceback (most recent call last):
File "sabnzbd/database.pyc", line 104, in execute
DatabaseError: database disk image is malformed

Re: DatabaseError

Posted: March 28th, 2014, 9:29 pm
by ugokanain
Deleted history1.db and it seems to work fine now

Re: DatabaseError

Posted: March 29th, 2014, 3:59 am
by shypike
Any file on a disk system can get corrupted.
SABnzbd could handle this a bit more gracefully.

Re: DatabaseError

Posted: March 29th, 2014, 5:03 am
by ugokanain
bite your tongue ;)

hope you are doing well