corrupt database

[Paolo Benvenuto]

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?

[Thomas Keffer]

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

--
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/90ea9a7b-01aa-48e8-96c1-f660d0e5d951%40googlegroups.com.

[Paolo Benvenuto]

resolved! thank you very much!!!

To unsubscribe from this group and stop receiving emails from it, send an email to weewx...@googlegroups.com.