Re: [weewx-user] DB error(s) or something else?

35 views

Skip to first unread message

Thomas Keffer

unread,

Jan 1, 2020, 9:54:27 AM1/1/20

to weewx-user

Most likely, your disk is failing, leading to database corruption. You can check by using the tool sqlite3, although it is not 100% able to find all errors.

You may have to install it first

sudo apt install sqlite3

Then run it on the database

sqlite3 /var/lib/weewx/weewx.sdb

sqlite> PRAGMA integrity_check;

If you find some errors, the tool DB Browser for SQLite purports to be able to fix some errors, although I have never tried it. It may be worth giving it a try.

If you can fix the database, copy it over to a safe place.

Personally, unless you've got good reason to think it's OK, I would throw the disk away and start all over with a fresh disk. Install the OS; reinstall weewx. If you were able to recover the database, copy it over. Otherwise, start afresh.

-tk

On Wed, Jan 1, 2020 at 7:26 AM Ian Bell <diefldr...@gmail.com> wrote:

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.

--
You received this message because you are subscribed to the Google Groups "weewx-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/5f507c85-2e6d-4072-9659-bc4fef6ca52b%40googlegroups.com.

Reply all

Reply to author

Forward

0 new messages