Cumulus MX build 3257 SQLite check on startup

[jpsc]

I have never used SQLite and the new build hangs at this step

Code: Select all

2023-10-30 09:44:36.023 Checking SQLite integrity...
2023-10-30 09:44:37.204 SQLite integrity check result: *** in database main ***
    On tree page 1252 cell 40: 2nd reference to page 77
    On tree page 1252 cell 38: 2nd reference to page 180
.
.
.
    Page 309: btreeInitPage() returns error code 11
2023-10-30 09:44:37.208 SQLite integrity check Failed, trying to compact database
2023-10-30 09:44:37.216 !!! Unhandled Exception !!!
SQLite.SQLiteException: database disk image is malformed
  at SQLite.SQLiteCommand.ExecuteNonQuery () [0x000cd] in <b9f88366af0e413e8a5d7e0ce3ae1233>:0 
  at SQLite.SQLiteConnection.Execute (System.String query, System.Object[] args) [0x00039] in <b9f88366af0e413e8a5d7e0ce3ae1233>:0 
  at CumulusMX.WeatherStation.CheckSqliteDatabase (System.Boolean giveup) [0x00162] in <b9f88366af0e413e8a5d7e0ce3ae1233>:0 
  at CumulusMX.WeatherStation..ctor (CumulusMX.Cumulus cumulus) [0x00576] in <b9f88366af0e413e8a5d7e0ce3ae1233>:0 
  at CumulusMX.DavisStation..ctor (CumulusMX.Cumulus cumulus) [0x00031] in <b9f88366af0e413e8a5d7e0ce3ae1233>:0 
  at CumulusMX.Cumulus..ctor (System.Int32 HTTPport, System.Boolean DebugEnabled, System.String startParms) [0x0268c] in <b9f88366af0e413e8a5d7e0ce3ae1233>:0 
  at CumulusMX.Program.RunAsAConsole (System.Int32 port, System.Boolean debug) [0x00048] in <b9f88366af0e413e8a5d7e0ce3ae1233>:0 
  at CumulusMX.Program.Main (System.String[] args) [0x00552] in <b9f88366af0e413e8a5d7e0ce3ae1233>:0 
2023-10-30 09:44:46.037 api/tags: Unexpected Error, Description: "Cannot access a disposed object."
2023-10-30 09:44:46.160 WS Client Connect: ::ffff:192.168.111.22, Total clients: 1
2023-10-30 09:46:31.379 api/tags: Unexpected Error, Description: "Cannot access a disposed object."
2023-10-30 09:46:31.448 WS Client Connect: ::ffff:192.168.111.22, Total clients: 1
2023-10-30 09:46:31.455 WS Client Disconnected: ::ffff:192.168.111.22, Total clients: 1
2023-10-30 09:48:31.293 Ctrl+C pressed

[HansR]

It is CMX which uses SQLite for some databases.
Just remove the file data/cumulusmx.db and try again.
NOTE: your RECENT charts will restart to build up so you will have little data after the file removal. Some patience required.

[mcrossley]

Thanks for the report, I'll put in a catch for that error...