corrupt DB or something else?

23 views
Skip to first unread message

Die Fledermaus

unread,
Jan 1, 2020, 9:28:19 AM1/1/20
to weewx-user
I am consistently getting the following error

cheetahgenerator: Generated 8 files for report SeasonsReport in 1.22 seconds

Jan  1 09:20:21 rasp-weewx weewx[515]: reportengine: Caught unrecoverable exception in generator 'weewx.imagegenerator.ImageGenerator'

Jan  1 09:20:21 rasp-weewx weewx[515]:         ****  database disk image is malformed

Jan  1 09:20:21 rasp-weewx weewx[515]:         ****  Traceback (most recent call last):

Jan  1 09:20:21 rasp-weewx weewx[515]:         ****    File "/usr/share/weewx/weewx/reportengine.py", line 204, in run

Jan  1 09:20:21 rasp-weewx weewx[515]:         ****      obj.start()

Jan  1 09:20:21 rasp-weewx weewx[515]:         ****    File "/usr/share/weewx/weewx/reportengine.py", line 300, in start

Jan  1 09:20:21 rasp-weewx weewx[515]:         ****      self.run()

Jan  1 09:20:21 rasp-weewx weewx[515]:         ****    File "/usr/share/weewx/weewx/imagegenerator.py", line 33, in run

Jan  1 09:20:21 rasp-weewx weewx[515]:         ****      self.genImages(self.gen_ts)

Jan  1 09:20:21 rasp-weewx weewx[515]:         ****    File "/usr/share/weewx/weewx/imagegenerator.py", line 170, in genImages

Jan  1 09:20:21 rasp-weewx weewx[515]:         ****      aggregate_interval=aggregate_interval)

Jan  1 09:20:21 rasp-weewx weewx[515]:         ****    File "/usr/share/weewx/weewx/manager.py", line 513, in getSqlVectors

Jan  1 09:20:21 rasp-weewx weewx[515]:         ****      aggregate_type, aggregate_interval)

Jan  1 09:20:21 rasp-weewx weewx[515]:         ****    File "/usr/share/weewx/weewx/manager.py", line 761, in _getSqlVectors

Jan  1 09:20:21 rasp-weewx weewx[515]:         ****      _cursor.execute(sql_str, stamp)

Jan  1 09:20:21 rasp-weewx weewx[515]:         ****    File "/usr/share/weewx/weedb/sqlite.py", line 29, in guarded_fn

Jan  1 09:20:21 rasp-weewx weewx[515]:         ****      return fn(*args, **kwargs)

Jan  1 09:20:21 rasp-weewx weewx[515]:         ****    File "/usr/share/weewx/weedb/sqlite.py", line 211, in execute

Jan  1 09:20:21 rasp-weewx weewx[515]:         ****      return sqlite3.Cursor.execute(self, *args, **kwargs)

Jan  1 09:20:21 rasp-weewx weewx[515]:         ****  DatabaseError: database disk image is malformed

Jan  1 09:20:21 rasp-weewx weewx[515]:         ****  Generator terminated

Jan  1 09:20:21 rasp-weewx weewx[515]: copygenerator: copied 0 files to /var/www/html/weewx

Jan  1 09:20:21 rasp-weewx weewx[515]: cheetahgenerator: Generated 1 files for report cmon in 0.03 seconds

Jan  1 09:20:22 rasp-weewx weewx[515]: reportengine: Caught unrecoverable exception in generator 'weewx.imagegenerator.ImageGenerator'

Jan  1 09:20:22 rasp-weewx weewx[515]:         ****  database disk image is malformed

Jan  1 09:20:22 rasp-weewx weewx[515]:         ****  Traceback (most recent call last):

Jan  1 09:20:22 rasp-weewx weewx[515]:         ****    File "/usr/share/weewx/weewx/reportengine.py", line 204, in run

Jan  1 09:20:22 rasp-weewx weewx[515]:         ****      obj.start()

Jan  1 09:20:22 rasp-weewx weewx[515]:         ****    File "/usr/share/weewx/weewx/reportengine.py", line 300, in start

Jan  1 09:20:22 rasp-weewx weewx[515]:         ****      self.run()

Jan  1 09:20:22 rasp-weewx weewx[515]:         ****    File "/usr/share/weewx/weewx/imagegenerator.py", line 33, in run

Jan  1 09:20:22 rasp-weewx weewx[515]:         ****      self.genImages(self.gen_ts)

Jan  1 09:20:22 rasp-weewx weewx[515]:         ****    File "/usr/share/weewx/weewx/imagegenerator.py", line 170, in genImages

Jan  1 09:20:22 rasp-weewx weewx[515]:         ****      aggregate_interval=aggregate_interval)

Jan  1 09:20:22 rasp-weewx weewx[515]:         ****    File "/usr/share/weewx/weewx/manager.py", line 513, in getSqlVectors

Jan  1 09:20:22 rasp-weewx weewx[515]:         ****      aggregate_type, aggregate_interval)

Jan  1 09:20:22 rasp-weewx weewx[515]:         ****    File "/usr/share/weewx/weewx/manager.py", line 790, in _getSqlVectors

Jan  1 09:20:22 rasp-weewx weewx[515]:         ****      for _rec in _cursor.execute(sql_str, (startstamp, stopstamp)):

Jan  1 09:20:22 rasp-weewx weewx[515]:         ****  DatabaseError: database disk image is malformed

Jan  1 09:20:22 rasp-weewx weewx[515]:         ****  Generator terminated

 I had my usb stick on my raspberry Pi fail during an update so I had to restore my weewx from my backed up files. I am concerned the DB copy I have is corrupt. and I will loose all my previous data. If I have to start with a new DB what is the best way to do this short of reinstalling weewx, and putting back the backed up files minus the DB.
Reply all
Reply to author
Forward
0 new messages