You can do an integrity check on the database. You may have to install the command line utility sqlite3 first:
*sudo apt-get install sqlite3* then *echo "PRAGMA integrity_check;" | sqlite3 /var/lib/weewx/weedb.sdb* -tk On Thu, Nov 14, 2019 at 11:51 AM Paolo Benvenuto <[email protected]> wrote: > Hi! following a power failure I cannot start weewx any more: > > $ sudo service weewx status > ● weewx.service - LSB: weewx weather system > Loaded: loaded (/etc/init.d/weewx; generated; vendor preset: enabled) > Active: active (exited) since Thu 2019-11-14 20:17:02 CET; 13min ago > Docs: man:systemd-sysv-generator(8) > Process: 1530 ExecStop=/etc/init.d/weewx stop (code=exited, > status=0/SUCCESS) > Process: 1542 ExecStart=/etc/init.d/weewx start (code=exited, > status=0/SUCCESS) > > nov 14 20:17:02 raspberrypi weewx[1558]: **** File > "/usr/share/weewx/weewx/manager.py", line 1157, in __init__ > nov 14 20:17:02 raspberrypi weewx[1558]: **** > super(DaySummaryManager, self).__init__(connection, table_name, schema) > nov 14 20:17:02 raspberrypi weewx[1558]: **** File > "/usr/share/weewx/weewx/manager.py", line 73, in __init__ > nov 14 20:17:02 raspberrypi weewx[1558]: **** self.sqlkeys = > self.connection.columnsOf(self.table_name) > nov 14 20:17:02 raspberrypi weewx[1558]: **** File > "/usr/share/weewx/weedb/sqlite.py", line 167, in columnsOf > nov 14 20:17:02 raspberrypi weewx[1558]: **** column_list = [row[1] > for row in self.genSchemaOf(table)] > nov 14 20:17:02 raspberrypi weewx[1558]: **** File > "/usr/share/weewx/weedb/sqlite.py", line 156, in genSchemaOf > nov 14 20:17:02 raspberrypi weewx[1558]: **** for row in > self.connection.execute("""PRAGMA table_info(%s);""" % table): > nov 14 20:17:02 raspberrypi weewx[1558]: **** DatabaseError: malformed > database schema (?) > nov 14 20:17:02 raspberrypi weewx[1558]: **** Exiting. > > The sqlite db seems corrupted. Any hint? > > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/90ea9a7b-01aa-48e8-96c1-f660d0e5d951%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/90ea9a7b-01aa-48e8-96c1-f660d0e5d951%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAPq0zEBTX15hCEu8g8-OGUS2-qsoJGwpD3-%2BnOg73cvtNi1NWQ%40mail.gmail.com.
