Any progress on this? I recently had to rebuild my rPi weewx image due to
corruption and thought I'd messed up the config file somehow but I'm seeing
the same issue:
Oct 21 12:43:16 raspberrypi weewx[24540]: restx: StationRegistry: Failed to
publish record 2017-10-21 12:43:00 PDT (1508614980): FAIL: execute failed:
database disk image is malformed
Thx,
Andy
On Thursday, October 19, 2017 at 3:10:14 AM UTC-7, Bostjan Potocnik wrote:
>
> The same here:
> Oct 19 09:25:17 bica weewx[22534]: restx: StationRegistry: Failed to
> publish record 2017-10-19 09:25:00 CEST (1508397900): FAIL: execute failed:
> database disk image is malformed
>
>
>
>
> On Monday, October 2, 2017 at 1:05:45 AM UTC+2, Paul Anderson wrote:
>>
>> I noticed this in my stations weewx.log
>>
>>
>> Oct 1 17:50:15 webserver weewx[10004]: restx: StationRegistry: Failed to
>> publish record 2017-10-01 17:50:00 EDT (1506894600): FAIL: execute failed:
>> database disk image is malformed
>>
>>
>> Because the error referred to a database disk image being malformed , I
>> thought it was referring to my local Sqlite weewx.sdb. After researching on
>> SqLite database corruption issues, I learned how this sometimes happens
>> especial on SD cards such as used with the PI and on SSD drives. Because I
>> am running on a SSD drive I went though the steps of doing a .dump to a
>> file, then recreated the database from the backup file. When I opened the
>> “new” database with sqlite3 tool I checked it’s integrity with PRAGMA
>> integrity_check. The integrity_check pragma looks for out-of-order records,
>> missing pages, malformed records, missing index entries, and UNIQUE, CHECK,
>> and NOT NULL constraint errors.
>>
>> It returned OK, so it thinks the database is fine.
>>
>>
>> Moved the “new database” back into place , ran the checks that wee-data
>> base provides , did a rebuild-daily and restated weewx, and got the same
>> StationRegistry: Failed to publish error.
>>
>>
>> The more I look at this issue I am starting to believe that it’s not a
>> issue with my local weewx.sdb at all, but rather an issue with the Station
>> Registry database on THE WEEWX SERVER.
>>
>>
>> I believe the error is actually a server reply from register.cgi on the
>> weewx.com server.
>>
>> Most likely from here:
>>
>> $rc =
>> $sth->execute($rec{station_url},$rec{description},$rec{latitude},$rec{longitude},$rec{station_type},$rec{station_model},$rec{weewx_info},$rec{python_info},$rec{platform_info},$rec{last_addr},$rec{last_seen});
>>
>> if(!$rc) {
>>
>> my $msg = 'execute failed: ' . $DBI::errstr;
>>
>> $dbh->disconnect();
>>
>> return ('FAIL', $msg, \%rec);
>>
>> }
>>
>>
>> Also it’s very interesting to note that no North America station have
>> been updated after Fri, 29 Sep 2017 10:56:51 GMT.
>>
>> So my WILD SPECULATION is that the weewx.com site maybe run on at least
>> a couple of servers, and EUROPE may be OK, but North America has a bad
>> Station Registry database?
>>
>>
>> Thanks,
>>
>> Paul
>>
>
--
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
