Re: [weewx-user] Re: Belchertown Error - Any idea what is wrong?

2021-11-08 Thread bchap...@gmail.com
Ok...I changed the archive interval to 120...looks good so far.  Might be 
time for a hardware upgrade.

Thanks for the help!

On Monday, November 8, 2021 at 9:07:57 PM UTC-5 vince wrote:

> There is a LOT enabled on that box if you look at the logs.Long sftp 
> session, Windy, PWS, Wunderground, CWOP,  Seasons, Rain Machine extension, 
> owmap, and the like.   You just can't run all that stuff and a too-quick 
> archive interval on something as weak as a model-B.
>
> On Monday, November 8, 2021 at 6:03:20 PM UTC-8 gjr80 wrote:
>
>> And there is the crux of the issue:
>>
>> Nov  8 20:03:39 raspberrypi weewx[6055] INFO weewx.engine: Using archive 
>> interval of 60 seconds (software record generation)
>>
>> Lesser RPis are just fine when used with a reasonable archive interval. 
>> Cutting it to the minimum 60 seconds is asking for trouble.
>>
>> Gary
>>
>> On Tuesday, 9 November 2021 at 11:56:10 UTC+10 tke...@gmail.com wrote:
>>
>>> There are lots of ways this can happen. Things to try (or, at least, 
>>> think about):
>>>
>>> 1. I would think that an RPi2 would be enough to run WeeWX + 
>>> Belchertown. Check by running a tool such as htop or top. How busy is the 
>>> processor?
>>>
>>> Along the same line, what is your archive interval? If it is short (1 
>>> minute), and your reports are complex, it is possible you are asking too 
>>> much of an RPi2.
>>>
>>> 2. Database locked errors can be as simple as having an open instance of 
>>> sqlite3 or SQLite DB Browser, which are contending for the locks. Running 
>>> weewxd and another weewx utility simultaneously can cause this. You can 
>>> check to see if more than one process is using the database by using the 
>>> "fuser" command:
>>>
>>> fuser -v /var/lib/weewx/weewx.sdb
>>>
>>> 3. Older versions of the underlying "C" library would wait for a full 
>>> second if the database was locked. It wouldn't take too many attempts to 
>>> exceed the typical 5 second timeout limit. However, I think this has been 
>>> fixed in newer versions. Still, it's worth an "apt update", followed by 
>>> "apt upgrade" to be sure you're up to date.
>>>
>>> 4. I am not very familiar with the Belchertown skin, so it's possible 
>>> that it's creating this problem internally by holding open two connections 
>>> simultaneously, without an intervening commit. Don't know.
>>>
>>> 5. It's also possible that your SD card is failing, and SQLite is 
>>> struggling to finalize the commits, leading to lock contention. The tool 
>>> fsck can help to determine the health of your card. Use the utility "top", 
>>> and look at the "wa" field (2nd line) while WeeWX is generating reports.
>>>
>>>
>>>
>>>
>>>
>>> On Mon, Nov 8, 2021 at 5:21 PM Doug Jenkins  
>>> wrote:
>>>
 Rpi2 with the latest O/S version is probably not enough to run both 
 belchertown and weewx together. Especially if you have a lot of archive 
 records to generate the NOAA reports on the first go.

 The RPI 4 is readily available and will be a good investment for a 
 nominal fee. It has at least 2GB (vs 512mb) of RAM and a 4 core processor 
 instead of the single core Broadcom chip that came on that pi.

 The bus is a lot better for I/O and you will have a lot less of an 
 issue with SD card corruption with RPi4 than with RPi2. 

 Trust me, I started my weewx 3.x site 3 years ago in on a RPi 2 and 
 struggled with stability with the pi itself. Now I run on a RPi4 with a 
 portable SSD drive to store my data with no issues.

 Just my $0.02



 On Mon, Nov 8, 2021, 8:02 PM vince  wrote:

> I bet if you turn Belchertown off (temporarily) and enable just the 
> Standard or Seasons skin that it'll work just fine.
>
> Sometimes you need to throw more compute at the problem.
>
> On Monday, November 8, 2021 at 4:40:00 PM UTC-8 bchap...@gmail.com 
> wrote:
>
>> Raspberry Pi 2 with raspbian buster
>>
>> This runs in a cycle of approximately every 6 minutes.  Nothing else 
>> running on this machine.
>>
>> On Monday, November 8, 2021 at 7:35:14 PM UTC-5 tke...@gmail.com 
>> wrote:
>>
>>> Yes, tell us what computer you are using. Also, the operating system 
>>> and version.
>>>
>>> On Mon, Nov 8, 2021 at 4:32 PM vince  wrote:
>>>
 Your database is locked :-)

 Typically this is when you're trying to do too much too fast on a 
 very slow box like a pi-zero or the like.

 On Monday, November 8, 2021 at 4:06:48 PM UTC-8 bchap...@gmail.com 
 wrote:

> Nov  8 18:53:35 raspberrypi weewx[5618] INFO weewx.engine: Main 
> loop exiting. Shutting engine down.
> Nov  8 18:53:35 raspberrypi weewx[5618] INFO weewx.engine: 
> Shutting down StdReport thread
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine: 
> Caught unrecoverable exception in 

Re: [weewx-user] Re: Belchertown Error - Any idea what is wrong?

2021-11-08 Thread vince
There is a LOT enabled on that box if you look at the logs.Long sftp 
session, Windy, PWS, Wunderground, CWOP,  Seasons, Rain Machine extension, 
owmap, and the like.   You just can't run all that stuff and a too-quick 
archive interval on something as weak as a model-B.

On Monday, November 8, 2021 at 6:03:20 PM UTC-8 gjr80 wrote:

> And there is the crux of the issue:
>
> Nov  8 20:03:39 raspberrypi weewx[6055] INFO weewx.engine: Using archive 
> interval of 60 seconds (software record generation)
>
> Lesser RPis are just fine when used with a reasonable archive interval. 
> Cutting it to the minimum 60 seconds is asking for trouble.
>
> Gary
>
> On Tuesday, 9 November 2021 at 11:56:10 UTC+10 tke...@gmail.com wrote:
>
>> There are lots of ways this can happen. Things to try (or, at least, 
>> think about):
>>
>> 1. I would think that an RPi2 would be enough to run WeeWX + Belchertown. 
>> Check by running a tool such as htop or top. How busy is the processor?
>>
>> Along the same line, what is your archive interval? If it is short (1 
>> minute), and your reports are complex, it is possible you are asking too 
>> much of an RPi2.
>>
>> 2. Database locked errors can be as simple as having an open instance of 
>> sqlite3 or SQLite DB Browser, which are contending for the locks. Running 
>> weewxd and another weewx utility simultaneously can cause this. You can 
>> check to see if more than one process is using the database by using the 
>> "fuser" command:
>>
>> fuser -v /var/lib/weewx/weewx.sdb
>>
>> 3. Older versions of the underlying "C" library would wait for a full 
>> second if the database was locked. It wouldn't take too many attempts to 
>> exceed the typical 5 second timeout limit. However, I think this has been 
>> fixed in newer versions. Still, it's worth an "apt update", followed by 
>> "apt upgrade" to be sure you're up to date.
>>
>> 4. I am not very familiar with the Belchertown skin, so it's possible 
>> that it's creating this problem internally by holding open two connections 
>> simultaneously, without an intervening commit. Don't know.
>>
>> 5. It's also possible that your SD card is failing, and SQLite is 
>> struggling to finalize the commits, leading to lock contention. The tool 
>> fsck can help to determine the health of your card. Use the utility "top", 
>> and look at the "wa" field (2nd line) while WeeWX is generating reports.
>>
>>
>>
>>
>>
>> On Mon, Nov 8, 2021 at 5:21 PM Doug Jenkins  
>> wrote:
>>
>>> Rpi2 with the latest O/S version is probably not enough to run both 
>>> belchertown and weewx together. Especially if you have a lot of archive 
>>> records to generate the NOAA reports on the first go.
>>>
>>> The RPI 4 is readily available and will be a good investment for a 
>>> nominal fee. It has at least 2GB (vs 512mb) of RAM and a 4 core processor 
>>> instead of the single core Broadcom chip that came on that pi.
>>>
>>> The bus is a lot better for I/O and you will have a lot less of an issue 
>>> with SD card corruption with RPi4 than with RPi2. 
>>>
>>> Trust me, I started my weewx 3.x site 3 years ago in on a RPi 2 and 
>>> struggled with stability with the pi itself. Now I run on a RPi4 with a 
>>> portable SSD drive to store my data with no issues.
>>>
>>> Just my $0.02
>>>
>>>
>>>
>>> On Mon, Nov 8, 2021, 8:02 PM vince  wrote:
>>>
 I bet if you turn Belchertown off (temporarily) and enable just the 
 Standard or Seasons skin that it'll work just fine.

 Sometimes you need to throw more compute at the problem.

 On Monday, November 8, 2021 at 4:40:00 PM UTC-8 bchap...@gmail.com 
 wrote:

> Raspberry Pi 2 with raspbian buster
>
> This runs in a cycle of approximately every 6 minutes.  Nothing else 
> running on this machine.
>
> On Monday, November 8, 2021 at 7:35:14 PM UTC-5 tke...@gmail.com 
> wrote:
>
>> Yes, tell us what computer you are using. Also, the operating system 
>> and version.
>>
>> On Mon, Nov 8, 2021 at 4:32 PM vince  wrote:
>>
>>> Your database is locked :-)
>>>
>>> Typically this is when you're trying to do too much too fast on a 
>>> very slow box like a pi-zero or the like.
>>>
>>> On Monday, November 8, 2021 at 4:06:48 PM UTC-8 bchap...@gmail.com 
>>> wrote:
>>>
 Nov  8 18:53:35 raspberrypi weewx[5618] INFO weewx.engine: Main 
 loop exiting. Shutting engine down.
 Nov  8 18:53:35 raspberrypi weewx[5618] INFO weewx.engine: Shutting 
 down StdReport thread
 Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine: 
 Caught unrecoverable exception in generator 
 'user.belchertown.HighchartsJsonGenerator'
 Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
 weewx.reportengine:   database is locked
 Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
 weewx.reportengine:   Traceback (most recent call last):

Re: [weewx-user] Re: Belchertown Error - Any idea what is wrong?

2021-11-08 Thread gjr80
And there is the crux of the issue:

Nov  8 20:03:39 raspberrypi weewx[6055] INFO weewx.engine: Using archive 
interval of 60 seconds (software record generation)

Lesser RPis are just fine when used with a reasonable archive interval. 
Cutting it to the minimum 60 seconds is asking for trouble.

Gary

On Tuesday, 9 November 2021 at 11:56:10 UTC+10 tke...@gmail.com wrote:

> There are lots of ways this can happen. Things to try (or, at least, think 
> about):
>
> 1. I would think that an RPi2 would be enough to run WeeWX + Belchertown. 
> Check by running a tool such as htop or top. How busy is the processor?
>
> Along the same line, what is your archive interval? If it is short (1 
> minute), and your reports are complex, it is possible you are asking too 
> much of an RPi2.
>
> 2. Database locked errors can be as simple as having an open instance of 
> sqlite3 or SQLite DB Browser, which are contending for the locks. Running 
> weewxd and another weewx utility simultaneously can cause this. You can 
> check to see if more than one process is using the database by using the 
> "fuser" command:
>
> fuser -v /var/lib/weewx/weewx.sdb
>
> 3. Older versions of the underlying "C" library would wait for a full 
> second if the database was locked. It wouldn't take too many attempts to 
> exceed the typical 5 second timeout limit. However, I think this has been 
> fixed in newer versions. Still, it's worth an "apt update", followed by 
> "apt upgrade" to be sure you're up to date.
>
> 4. I am not very familiar with the Belchertown skin, so it's possible that 
> it's creating this problem internally by holding open two connections 
> simultaneously, without an intervening commit. Don't know.
>
> 5. It's also possible that your SD card is failing, and SQLite is 
> struggling to finalize the commits, leading to lock contention. The tool 
> fsck can help to determine the health of your card. Use the utility "top", 
> and look at the "wa" field (2nd line) while WeeWX is generating reports.
>
>
>
>
>
> On Mon, Nov 8, 2021 at 5:21 PM Doug Jenkins  wrote:
>
>> Rpi2 with the latest O/S version is probably not enough to run both 
>> belchertown and weewx together. Especially if you have a lot of archive 
>> records to generate the NOAA reports on the first go.
>>
>> The RPI 4 is readily available and will be a good investment for a 
>> nominal fee. It has at least 2GB (vs 512mb) of RAM and a 4 core processor 
>> instead of the single core Broadcom chip that came on that pi.
>>
>> The bus is a lot better for I/O and you will have a lot less of an issue 
>> with SD card corruption with RPi4 than with RPi2. 
>>
>> Trust me, I started my weewx 3.x site 3 years ago in on a RPi 2 and 
>> struggled with stability with the pi itself. Now I run on a RPi4 with a 
>> portable SSD drive to store my data with no issues.
>>
>> Just my $0.02
>>
>>
>>
>> On Mon, Nov 8, 2021, 8:02 PM vince  wrote:
>>
>>> I bet if you turn Belchertown off (temporarily) and enable just the 
>>> Standard or Seasons skin that it'll work just fine.
>>>
>>> Sometimes you need to throw more compute at the problem.
>>>
>>> On Monday, November 8, 2021 at 4:40:00 PM UTC-8 bchap...@gmail.com 
>>> wrote:
>>>
 Raspberry Pi 2 with raspbian buster

 This runs in a cycle of approximately every 6 minutes.  Nothing else 
 running on this machine.

 On Monday, November 8, 2021 at 7:35:14 PM UTC-5 tke...@gmail.com wrote:

> Yes, tell us what computer you are using. Also, the operating system 
> and version.
>
> On Mon, Nov 8, 2021 at 4:32 PM vince  wrote:
>
>> Your database is locked :-)
>>
>> Typically this is when you're trying to do too much too fast on a 
>> very slow box like a pi-zero or the like.
>>
>> On Monday, November 8, 2021 at 4:06:48 PM UTC-8 bchap...@gmail.com 
>> wrote:
>>
>>> Nov  8 18:53:35 raspberrypi weewx[5618] INFO weewx.engine: Main loop 
>>> exiting. Shutting engine down.
>>> Nov  8 18:53:35 raspberrypi weewx[5618] INFO weewx.engine: Shutting 
>>> down StdReport thread
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine: 
>>> Caught unrecoverable exception in generator 
>>> 'user.belchertown.HighchartsJsonGenerator'
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
>>> weewx.reportengine:   database is locked
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
>>> weewx.reportengine:   Traceback (most recent call last):
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
>>> weewx.reportengine: File 
>>> "/usr/share/weewx/weedb/sqlite.py", line 30, in guarded_fn
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
>>> weewx.reportengine:   return fn(*args, **kwargs)
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
>>> weewx.reportengine: File 
>>> "/usr/share/weewx/weedb/sqlite.py", line 219, in execute

Re: [weewx-user] Re: Belchertown Error - Any idea what is wrong?

2021-11-08 Thread Tom Keffer
There are lots of ways this can happen. Things to try (or, at least, think
about):

1. I would think that an RPi2 would be enough to run WeeWX + Belchertown.
Check by running a tool such as htop or top. How busy is the processor?

Along the same line, what is your archive interval? If it is short (1
minute), and your reports are complex, it is possible you are asking too
much of an RPi2.

2. Database locked errors can be as simple as having an open instance of
sqlite3 or SQLite DB Browser, which are contending for the locks. Running
weewxd and another weewx utility simultaneously can cause this. You can
check to see if more than one process is using the database by using the
"fuser" command:

fuser -v /var/lib/weewx/weewx.sdb

3. Older versions of the underlying "C" library would wait for a full
second if the database was locked. It wouldn't take too many attempts to
exceed the typical 5 second timeout limit. However, I think this has been
fixed in newer versions. Still, it's worth an "apt update", followed by
"apt upgrade" to be sure you're up to date.

4. I am not very familiar with the Belchertown skin, so it's possible that
it's creating this problem internally by holding open two connections
simultaneously, without an intervening commit. Don't know.

5. It's also possible that your SD card is failing, and SQLite is
struggling to finalize the commits, leading to lock contention. The tool
fsck can help to determine the health of your card. Use the utility "top",
and look at the "wa" field (2nd line) while WeeWX is generating reports.





On Mon, Nov 8, 2021 at 5:21 PM Doug Jenkins  wrote:

> Rpi2 with the latest O/S version is probably not enough to run both
> belchertown and weewx together. Especially if you have a lot of archive
> records to generate the NOAA reports on the first go.
>
> The RPI 4 is readily available and will be a good investment for a nominal
> fee. It has at least 2GB (vs 512mb) of RAM and a 4 core processor instead
> of the single core Broadcom chip that came on that pi.
>
> The bus is a lot better for I/O and you will have a lot less of an issue
> with SD card corruption with RPi4 than with RPi2.
>
> Trust me, I started my weewx 3.x site 3 years ago in on a RPi 2 and
> struggled with stability with the pi itself. Now I run on a RPi4 with a
> portable SSD drive to store my data with no issues.
>
> Just my $0.02
>
>
>
> On Mon, Nov 8, 2021, 8:02 PM vince  wrote:
>
>> I bet if you turn Belchertown off (temporarily) and enable just the
>> Standard or Seasons skin that it'll work just fine.
>>
>> Sometimes you need to throw more compute at the problem.
>>
>> On Monday, November 8, 2021 at 4:40:00 PM UTC-8 bchap...@gmail.com wrote:
>>
>>> Raspberry Pi 2 with raspbian buster
>>>
>>> This runs in a cycle of approximately every 6 minutes.  Nothing else
>>> running on this machine.
>>>
>>> On Monday, November 8, 2021 at 7:35:14 PM UTC-5 tke...@gmail.com wrote:
>>>
 Yes, tell us what computer you are using. Also, the operating system
 and version.

 On Mon, Nov 8, 2021 at 4:32 PM vince  wrote:

> Your database is locked :-)
>
> Typically this is when you're trying to do too much too fast on a very
> slow box like a pi-zero or the like.
>
> On Monday, November 8, 2021 at 4:06:48 PM UTC-8 bchap...@gmail.com
> wrote:
>
>> Nov  8 18:53:35 raspberrypi weewx[5618] INFO weewx.engine: Main loop
>> exiting. Shutting engine down.
>> Nov  8 18:53:35 raspberrypi weewx[5618] INFO weewx.engine: Shutting
>> down StdReport thread
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine:
>> Caught unrecoverable exception in generator
>> 'user.belchertown.HighchartsJsonGenerator'
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR
>> weewx.reportengine:   database is locked
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR
>> weewx.reportengine:   Traceback (most recent call last):
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR
>> weewx.reportengine: File
>> "/usr/share/weewx/weedb/sqlite.py", line 30, in guarded_fn
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR
>> weewx.reportengine:   return fn(*args, **kwargs)
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR
>> weewx.reportengine: File
>> "/usr/share/weewx/weedb/sqlite.py", line 219, in execute
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR
>> weewx.reportengine:   return sqlite3.Cursor.execute(self,
>> *args, **kwargs)
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR
>> weewx.reportengine:   sqlite3.OperationalError: database is
>> locked
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR
>> weewx.reportengine: 
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR
>> weewx.reportengine:   During handling of the above exception,
>> another exception 

Re: [weewx-user] Re: Belchertown Error - Any idea what is wrong?

2021-11-08 Thread bchap...@gmail.com
Nov  8 20:03:39 raspberrypi weewx[6055] INFO user.gw1000: driver version is 
0.4.1
Nov  8 20:03:39 raspberrypi weewx[6055] INFO user.gw1000: GW1000 address is 
192.168.20.222:45000
Nov  8 20:03:39 raspberrypi weewx[6055] INFO user.gw1000: poll interval is 
15 seconds
Nov  8 20:03:39 raspberrypi weewx[6055] INFO weewx.engine: StdConvert 
target unit is 0x1
Nov  8 20:03:39 raspberrypi weewx[6055] INFO weewx.engine: Archive will use 
data binding wx_binding
Nov  8 20:03:39 raspberrypi weewx[6055] INFO weewx.engine: Record 
generation will be attempted in 'software'
Nov  8 20:03:39 raspberrypi weewx[6055] INFO weewx.engine: Using archive 
interval of 60 seconds (software record generation)
Nov  8 20:03:39 raspberrypi weewx[6055] INFO weewx.restx: StationRegistry: 
Registration not requested.
Nov  8 20:03:39 raspberrypi weewx[6055] INFO weewx.restx: Wunderground-PWS: 
Data for station KNYGRANV5 will be posted
Nov  8 20:03:39 raspberrypi weewx[6055] INFO weewx.restx: PWSWeather: Data 
for station KNYGRANV5 will be posted
Nov  8 20:03:39 raspberrypi weewx[6055] INFO weewx.restx: CWOP: Data for 
station EW5855 will be posted
Nov  8 20:03:39 raspberrypi weewx[6055] INFO user.wcloud: service version 
is 0.13
Nov  8 20:03:39 raspberrypi weewx[6055] INFO user.wcloud: Data will be 
uploaded for id=efad7e92b2c1e3bd
Nov  8 20:03:39 raspberrypi weewx[6055] INFO user.windy: version is 0.7
Nov  8 20:03:39 raspberrypi weewx[6055] INFO user.windy: Data will be 
uploaded to https://stations.windy.com/pws/update
Nov  8 20:03:39 raspberrypi weewx[6055] INFO user.owm: service version is 
0.9
Nov  8 20:03:39 raspberrypi weewx[6055] ERROR user.owm: Data will not be 
posted: Missing option 'OpenWeatherMap'
Nov  8 20:03:39 raspberrypi weewx[6055] INFO user.rainmachine: service 
version is 0.5
Nov  8 20:03:39 raspberrypi weewx[6055] INFO user.rainmachine: Data will be 
uploaded for RainMachine located at 192.168.20.155 ssl: False
Nov  8 20:03:39 raspberrypi weewx[6055] INFO __main__: Starting up weewx 
version 4.5.1
Nov  8 20:03:39 raspberrypi weewx[6055] INFO weewx.engine: Using binding 
'wx_binding' to database 'weewx.sdb'
Nov  8 20:03:39 raspberrypi weewx[6055] INFO weewx.manager: Starting 
backfill of daily summaries
Nov  8 20:03:39 raspberrypi weewx[6055] INFO weewx.manager: Daily summaries 
up to date
Nov  8 20:03:39 raspberrypi weewx[6055] INFO weewx.engine: Starting main 
packet loop.
Nov  8 20:03:39 raspberrypi weewx[6055] INFO user.gw1000: Using 'rainyear' 
for rain total
Nov  8 20:03:39 raspberrypi weewx[6055] INFO user.gw1000: skipping rain 
measurement of 292.9: no last rain
Nov  8 20:03:39 raspberrypi weewx[6055] INFO user.gw1000: Skipping 
lightning count of 0: no last count
Nov  8 20:04:25 raspberrypi weewx[6055] INFO weewx.manager: Added record 
2021-11-08 20:04:00 EST (1636419840) to database 'weewx.sdb'
Nov  8 20:04:25 raspberrypi weewx[6055] INFO weewx.manager: Added record 
2021-11-08 20:04:00 EST (1636419840) to daily summary in 'weewx.sdb'
Nov  8 20:04:25 raspberrypi weewx[6055] INFO weewx.restx: RainMachine: 
Published record 2021-11-08 20:04:00 EST (1636419840)
Nov  8 20:04:25 raspberrypi weewx[6055] INFO weewx.restx: Windy: Published 
record 2021-11-08 20:04:00 EST (1636419840)
Nov  8 20:04:25 raspberrypi weewx[6055] INFO weewx.restx: PWSWeather: 
Published record 2021-11-08 20:04:00 EST (1636419840)
Nov  8 20:04:25 raspberrypi weewx[6055] INFO weewx.restx: Wunderground-PWS: 
Published record 2021-11-08 20:04:00 EST (1636419840)
Nov  8 20:04:25 raspberrypi weewx[6055] INFO weewx.restx: CWOP: Published 
record 2021-11-08 20:04:00 EST (1636419840)
Nov  8 20:04:26 raspberrypi weewx[6055] INFO weewx.restx: WeatherCloud: 
Published record 2021-11-08 20:04:00 EST (1636419840)
Nov  8 20:04:30 raspberrypi weewx[6055] INFO weewx.cheetahgenerator: 
Generated 8 files for report SeasonsReport in 5.18 seconds
Nov  8 20:04:36 raspberrypi weewx[6055] INFO weewx.imagegenerator: 
Generated 15 images for report SeasonsReport in 5.53 seconds
Nov  8 20:04:36 raspberrypi weewx[6055] INFO weewx.reportengine: Copied 5 
files to /var/www/html/weewx
Nov  8 20:04:37 raspberrypi weewx[6055] INFO paramiko.transport: Connected 
(version 2.0, client OpenSSH_7.9p1)
Nov  8 20:04:37 raspberrypi weewx[6055] INFO paramiko.transport: 
Authentication (password) successful!
Nov  8 20:04:37 raspberrypi weewx[6055] INFO paramiko.transport.sftp: [chan 
0] Opened sftp connection (server version 3)
Nov  8 20:04:47 raspberrypi weewx[6055] INFO paramiko.transport.sftp: [chan 
0] sftp session closed.
Nov  8 20:04:47 raspberrypi weewx[6055] INFO user.sftp: sftpgenerator: 
transferred 41 files in 10.57 seconds
Nov  8 20:04:53 raspberrypi weewx[6055] INFO weewx.cheetahgenerator: 
Generated 11 files for report Belchertown in 6.58 seconds
Nov  8 20:04:54 raspberrypi weewx[6055] INFO weewx.reportengine: Copied 37 
files to /var/www/html
Nov  8 20:05:23 raspberrypi crontab[6326]: (pi) REPLACE (pi)
Nov  8 20:05:23 raspberrypi crontab[6326]: (pi) END EDIT (pi)

Re: [weewx-user] Re: Belchertown Error - Any idea what is wrong?

2021-11-08 Thread Doug Jenkins
Rpi2 with the latest O/S version is probably not enough to run both
belchertown and weewx together. Especially if you have a lot of archive
records to generate the NOAA reports on the first go.

The RPI 4 is readily available and will be a good investment for a nominal
fee. It has at least 2GB (vs 512mb) of RAM and a 4 core processor instead
of the single core Broadcom chip that came on that pi.

The bus is a lot better for I/O and you will have a lot less of an issue
with SD card corruption with RPi4 than with RPi2.

Trust me, I started my weewx 3.x site 3 years ago in on a RPi 2 and
struggled with stability with the pi itself. Now I run on a RPi4 with a
portable SSD drive to store my data with no issues.

Just my $0.02



On Mon, Nov 8, 2021, 8:02 PM vince  wrote:

> I bet if you turn Belchertown off (temporarily) and enable just the
> Standard or Seasons skin that it'll work just fine.
>
> Sometimes you need to throw more compute at the problem.
>
> On Monday, November 8, 2021 at 4:40:00 PM UTC-8 bchap...@gmail.com wrote:
>
>> Raspberry Pi 2 with raspbian buster
>>
>> This runs in a cycle of approximately every 6 minutes.  Nothing else
>> running on this machine.
>>
>> On Monday, November 8, 2021 at 7:35:14 PM UTC-5 tke...@gmail.com wrote:
>>
>>> Yes, tell us what computer you are using. Also, the operating system and
>>> version.
>>>
>>> On Mon, Nov 8, 2021 at 4:32 PM vince  wrote:
>>>
 Your database is locked :-)

 Typically this is when you're trying to do too much too fast on a very
 slow box like a pi-zero or the like.

 On Monday, November 8, 2021 at 4:06:48 PM UTC-8 bchap...@gmail.com
 wrote:

> Nov  8 18:53:35 raspberrypi weewx[5618] INFO weewx.engine: Main loop
> exiting. Shutting engine down.
> Nov  8 18:53:35 raspberrypi weewx[5618] INFO weewx.engine: Shutting
> down StdReport thread
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine:
> Caught unrecoverable exception in generator
> 'user.belchertown.HighchartsJsonGenerator'
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR
> weewx.reportengine:   database is locked
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR
> weewx.reportengine:   Traceback (most recent call last):
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR
> weewx.reportengine: File
> "/usr/share/weewx/weedb/sqlite.py", line 30, in guarded_fn
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR
> weewx.reportengine:   return fn(*args, **kwargs)
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR
> weewx.reportengine: File
> "/usr/share/weewx/weedb/sqlite.py", line 219, in execute
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR
> weewx.reportengine:   return sqlite3.Cursor.execute(self,
> *args, **kwargs)
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR
> weewx.reportengine:   sqlite3.OperationalError: database is
> locked
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR
> weewx.reportengine: 
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR
> weewx.reportengine:   During handling of the above exception,
> another exception occurred:
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR
> weewx.reportengine: 
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR
> weewx.reportengine:   Traceback (most recent call last):
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR
> weewx.reportengine: File
> "/usr/share/weewx/weewx/reportengine.py", line 196, in run
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR
> weewx.reportengine:   obj.start()
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR
> weewx.reportengine: File
> "/usr/share/weewx/weewx/reportengine.py", line 281, in start
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR
> weewx.reportengine:   self.run()
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR
> weewx.reportengine: File
> "/usr/share/weewx/user/belchertown.py", line 1550, in run
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR
> weewx.reportengine:   start_ts = archive.firstGoodStamp()
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR
> weewx.reportengine: File
> "/usr/share/weewx/weewx/manager.py", line 247, in firstGoodStamp
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR
> weewx.reportengine:   _row = self.getSql("SELECT
> MIN(dateTime) FROM %s" % self.table_name)
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR
> weewx.reportengine: File
> "/usr/share/weewx/weewx/manager.py", line 449, in getSql
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR
> weewx.reportengine:   _cursor.execute(sql, sqlargs)
> Nov  8 

Re: [weewx-user] Re: Belchertown Error - Any idea what is wrong?

2021-11-08 Thread gjr80
Would like to see a more extensive log extract, I wouldn’t have though a 
RPi2 would have that much of a problem with just WeeWX and Belchertown 
using a GW1000.

Gary

On Tuesday, 9 November 2021 at 11:02:35 UTC+10 vince wrote:

> I bet if you turn Belchertown off (temporarily) and enable just the 
> Standard or Seasons skin that it'll work just fine.
>
> Sometimes you need to throw more compute at the problem.
>
> On Monday, November 8, 2021 at 4:40:00 PM UTC-8 bchap...@gmail.com wrote:
>
>> Raspberry Pi 2 with raspbian buster
>>
>> This runs in a cycle of approximately every 6 minutes.  Nothing else 
>> running on this machine.
>>
>> On Monday, November 8, 2021 at 7:35:14 PM UTC-5 tke...@gmail.com wrote:
>>
>>> Yes, tell us what computer you are using. Also, the operating system and 
>>> version.
>>>
>>> On Mon, Nov 8, 2021 at 4:32 PM vince  wrote:
>>>
 Your database is locked :-)

 Typically this is when you're trying to do too much too fast on a very 
 slow box like a pi-zero or the like.

 On Monday, November 8, 2021 at 4:06:48 PM UTC-8 bchap...@gmail.com 
 wrote:

> Nov  8 18:53:35 raspberrypi weewx[5618] INFO weewx.engine: Main loop 
> exiting. Shutting engine down.
> Nov  8 18:53:35 raspberrypi weewx[5618] INFO weewx.engine: Shutting 
> down StdReport thread
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine: 
> Caught unrecoverable exception in generator 
> 'user.belchertown.HighchartsJsonGenerator'
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
> weewx.reportengine:   database is locked
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
> weewx.reportengine:   Traceback (most recent call last):
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
> weewx.reportengine: File 
> "/usr/share/weewx/weedb/sqlite.py", line 30, in guarded_fn
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
> weewx.reportengine:   return fn(*args, **kwargs)
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
> weewx.reportengine: File 
> "/usr/share/weewx/weedb/sqlite.py", line 219, in execute
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
> weewx.reportengine:   return sqlite3.Cursor.execute(self, 
> *args, **kwargs)
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
> weewx.reportengine:   sqlite3.OperationalError: database is 
> locked
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
> weewx.reportengine:   
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
> weewx.reportengine:   During handling of the above exception, 
> another exception occurred:
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
> weewx.reportengine:   
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
> weewx.reportengine:   Traceback (most recent call last):
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
> weewx.reportengine: File 
> "/usr/share/weewx/weewx/reportengine.py", line 196, in run
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
> weewx.reportengine:   obj.start()
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
> weewx.reportengine: File 
> "/usr/share/weewx/weewx/reportengine.py", line 281, in start
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
> weewx.reportengine:   self.run()
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
> weewx.reportengine: File 
> "/usr/share/weewx/user/belchertown.py", line 1550, in run
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
> weewx.reportengine:   start_ts = archive.firstGoodStamp()
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
> weewx.reportengine: File 
> "/usr/share/weewx/weewx/manager.py", line 247, in firstGoodStamp
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
> weewx.reportengine:   _row = self.getSql("SELECT 
> MIN(dateTime) FROM %s" % self.table_name)
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
> weewx.reportengine: File 
> "/usr/share/weewx/weewx/manager.py", line 449, in getSql
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
> weewx.reportengine:   _cursor.execute(sql, sqlargs)
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
> weewx.reportengine: File 
> "/usr/share/weewx/weedb/sqlite.py", line 44, in guarded_fn
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
> weewx.reportengine:   raise weedb.OperationalError(e)
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
> weewx.reportengine:   weedb.OperationalError: database is 
> locked
> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
> weewx.reportengine: 

Re: [weewx-user] Re: Belchertown Error - Any idea what is wrong?

2021-11-08 Thread vince
I bet if you turn Belchertown off (temporarily) and enable just the 
Standard or Seasons skin that it'll work just fine.

Sometimes you need to throw more compute at the problem.

On Monday, November 8, 2021 at 4:40:00 PM UTC-8 bchap...@gmail.com wrote:

> Raspberry Pi 2 with raspbian buster
>
> This runs in a cycle of approximately every 6 minutes.  Nothing else 
> running on this machine.
>
> On Monday, November 8, 2021 at 7:35:14 PM UTC-5 tke...@gmail.com wrote:
>
>> Yes, tell us what computer you are using. Also, the operating system and 
>> version.
>>
>> On Mon, Nov 8, 2021 at 4:32 PM vince  wrote:
>>
>>> Your database is locked :-)
>>>
>>> Typically this is when you're trying to do too much too fast on a very 
>>> slow box like a pi-zero or the like.
>>>
>>> On Monday, November 8, 2021 at 4:06:48 PM UTC-8 bchap...@gmail.com 
>>> wrote:
>>>
 Nov  8 18:53:35 raspberrypi weewx[5618] INFO weewx.engine: Main loop 
 exiting. Shutting engine down.
 Nov  8 18:53:35 raspberrypi weewx[5618] INFO weewx.engine: Shutting 
 down StdReport thread
 Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine: 
 Caught unrecoverable exception in generator 
 'user.belchertown.HighchartsJsonGenerator'
 Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
 weewx.reportengine:   database is locked
 Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
 weewx.reportengine:   Traceback (most recent call last):
 Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
 weewx.reportengine: File 
 "/usr/share/weewx/weedb/sqlite.py", line 30, in guarded_fn
 Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
 weewx.reportengine:   return fn(*args, **kwargs)
 Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
 weewx.reportengine: File 
 "/usr/share/weewx/weedb/sqlite.py", line 219, in execute
 Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
 weewx.reportengine:   return sqlite3.Cursor.execute(self, 
 *args, **kwargs)
 Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
 weewx.reportengine:   sqlite3.OperationalError: database is 
 locked
 Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
 weewx.reportengine:   
 Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
 weewx.reportengine:   During handling of the above exception, 
 another exception occurred:
 Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
 weewx.reportengine:   
 Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
 weewx.reportengine:   Traceback (most recent call last):
 Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
 weewx.reportengine: File 
 "/usr/share/weewx/weewx/reportengine.py", line 196, in run
 Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
 weewx.reportengine:   obj.start()
 Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
 weewx.reportengine: File 
 "/usr/share/weewx/weewx/reportengine.py", line 281, in start
 Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
 weewx.reportengine:   self.run()
 Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
 weewx.reportengine: File 
 "/usr/share/weewx/user/belchertown.py", line 1550, in run
 Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
 weewx.reportengine:   start_ts = archive.firstGoodStamp()
 Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
 weewx.reportengine: File 
 "/usr/share/weewx/weewx/manager.py", line 247, in firstGoodStamp
 Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
 weewx.reportengine:   _row = self.getSql("SELECT 
 MIN(dateTime) FROM %s" % self.table_name)
 Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
 weewx.reportengine: File 
 "/usr/share/weewx/weewx/manager.py", line 449, in getSql
 Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
 weewx.reportengine:   _cursor.execute(sql, sqlargs)
 Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
 weewx.reportengine: File 
 "/usr/share/weewx/weedb/sqlite.py", line 44, in guarded_fn
 Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
 weewx.reportengine:   raise weedb.OperationalError(e)
 Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
 weewx.reportengine:   weedb.OperationalError: database is 
 locked
 Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
 weewx.reportengine:   Generator terminated
 Nov  8 18:53:45 raspberrypi weewx[5618] INFO user.gw1000: 
 Gw1000Collector thread has been terminated
 Nov  8 18:53:45 raspberrypi weewx[5618] CRITICAL __main__: Database 
 OperationalError exception: database is locked
 Nov  8 18:53:45 raspberrypi weewx[5618] CRITICAL __main__:   

Re: [weewx-user] Re: Belchertown Error - Any idea what is wrong?

2021-11-08 Thread bchap...@gmail.com
Raspberry Pi 2 with raspbian buster

This runs in a cycle of approximately every 6 minutes.  Nothing else 
running on this machine.

On Monday, November 8, 2021 at 7:35:14 PM UTC-5 tke...@gmail.com wrote:

> Yes, tell us what computer you are using. Also, the operating system and 
> version.
>
> On Mon, Nov 8, 2021 at 4:32 PM vince  wrote:
>
>> Your database is locked :-)
>>
>> Typically this is when you're trying to do too much too fast on a very 
>> slow box like a pi-zero or the like.
>>
>> On Monday, November 8, 2021 at 4:06:48 PM UTC-8 bchap...@gmail.com wrote:
>>
>>> Nov  8 18:53:35 raspberrypi weewx[5618] INFO weewx.engine: Main loop 
>>> exiting. Shutting engine down.
>>> Nov  8 18:53:35 raspberrypi weewx[5618] INFO weewx.engine: Shutting down 
>>> StdReport thread
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine: Caught 
>>> unrecoverable exception in generator 
>>> 'user.belchertown.HighchartsJsonGenerator'
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
>>> weewx.reportengine:   database is locked
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
>>> weewx.reportengine:   Traceback (most recent call last):
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
>>> weewx.reportengine: File 
>>> "/usr/share/weewx/weedb/sqlite.py", line 30, in guarded_fn
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
>>> weewx.reportengine:   return fn(*args, **kwargs)
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
>>> weewx.reportengine: File 
>>> "/usr/share/weewx/weedb/sqlite.py", line 219, in execute
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
>>> weewx.reportengine:   return sqlite3.Cursor.execute(self, 
>>> *args, **kwargs)
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
>>> weewx.reportengine:   sqlite3.OperationalError: database is 
>>> locked
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
>>> weewx.reportengine:   
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
>>> weewx.reportengine:   During handling of the above exception, 
>>> another exception occurred:
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
>>> weewx.reportengine:   
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
>>> weewx.reportengine:   Traceback (most recent call last):
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
>>> weewx.reportengine: File 
>>> "/usr/share/weewx/weewx/reportengine.py", line 196, in run
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
>>> weewx.reportengine:   obj.start()
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
>>> weewx.reportengine: File 
>>> "/usr/share/weewx/weewx/reportengine.py", line 281, in start
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
>>> weewx.reportengine:   self.run()
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
>>> weewx.reportengine: File 
>>> "/usr/share/weewx/user/belchertown.py", line 1550, in run
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
>>> weewx.reportengine:   start_ts = archive.firstGoodStamp()
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
>>> weewx.reportengine: File 
>>> "/usr/share/weewx/weewx/manager.py", line 247, in firstGoodStamp
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
>>> weewx.reportengine:   _row = self.getSql("SELECT 
>>> MIN(dateTime) FROM %s" % self.table_name)
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
>>> weewx.reportengine: File 
>>> "/usr/share/weewx/weewx/manager.py", line 449, in getSql
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
>>> weewx.reportengine:   _cursor.execute(sql, sqlargs)
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
>>> weewx.reportengine: File 
>>> "/usr/share/weewx/weedb/sqlite.py", line 44, in guarded_fn
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
>>> weewx.reportengine:   raise weedb.OperationalError(e)
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
>>> weewx.reportengine:   weedb.OperationalError: database is locked
>>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR 
>>> weewx.reportengine:   Generator terminated
>>> Nov  8 18:53:45 raspberrypi weewx[5618] INFO user.gw1000: 
>>> Gw1000Collector thread has been terminated
>>> Nov  8 18:53:45 raspberrypi weewx[5618] CRITICAL __main__: Database 
>>> OperationalError exception: database is locked
>>> Nov  8 18:53:45 raspberrypi weewx[5618] CRITICAL __main__:   
>>> Waiting 2 minutes then retrying...
>>> Nov  8 18:55:45 raspberrypi weewx[5618] INFO __main__: retrying...
>>>
>>> -- 
>> 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 

Re: [weewx-user] Re: Belchertown Error - Any idea what is wrong?

2021-11-08 Thread Tom Keffer
Yes, tell us what computer you are using. Also, the operating system and
version.

On Mon, Nov 8, 2021 at 4:32 PM vince  wrote:

> Your database is locked :-)
>
> Typically this is when you're trying to do too much too fast on a very
> slow box like a pi-zero or the like.
>
> On Monday, November 8, 2021 at 4:06:48 PM UTC-8 bchap...@gmail.com wrote:
>
>> Nov  8 18:53:35 raspberrypi weewx[5618] INFO weewx.engine: Main loop
>> exiting. Shutting engine down.
>> Nov  8 18:53:35 raspberrypi weewx[5618] INFO weewx.engine: Shutting down
>> StdReport thread
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine: Caught
>> unrecoverable exception in generator
>> 'user.belchertown.HighchartsJsonGenerator'
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine:
>>   database is locked
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine:
>>   Traceback (most recent call last):
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine:
>> File "/usr/share/weewx/weedb/sqlite.py", line 30, in guarded_fn
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine:
>>   return fn(*args, **kwargs)
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine:
>> File "/usr/share/weewx/weedb/sqlite.py", line 219, in execute
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine:
>>   return sqlite3.Cursor.execute(self, *args, **kwargs)
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine:
>>   sqlite3.OperationalError: database is locked
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine:
>> 
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine:
>>   During handling of the above exception, another exception occurred:
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine:
>> 
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine:
>>   Traceback (most recent call last):
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine:
>> File "/usr/share/weewx/weewx/reportengine.py", line 196, in run
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine:
>>   obj.start()
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine:
>> File "/usr/share/weewx/weewx/reportengine.py", line 281, in start
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine:
>>   self.run()
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine:
>> File "/usr/share/weewx/user/belchertown.py", line 1550, in run
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine:
>>   start_ts = archive.firstGoodStamp()
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine:
>> File "/usr/share/weewx/weewx/manager.py", line 247, in
>> firstGoodStamp
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine:
>>   _row = self.getSql("SELECT MIN(dateTime) FROM %s" %
>> self.table_name)
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine:
>> File "/usr/share/weewx/weewx/manager.py", line 449, in getSql
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine:
>>   _cursor.execute(sql, sqlargs)
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine:
>> File "/usr/share/weewx/weedb/sqlite.py", line 44, in guarded_fn
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine:
>>   raise weedb.OperationalError(e)
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine:
>>   weedb.OperationalError: database is locked
>> Nov  8 18:53:44 raspberrypi weewx[5618] ERROR weewx.reportengine:
>>   Generator terminated
>> Nov  8 18:53:45 raspberrypi weewx[5618] INFO user.gw1000: Gw1000Collector
>> thread has been terminated
>> Nov  8 18:53:45 raspberrypi weewx[5618] CRITICAL __main__: Database
>> OperationalError exception: database is locked
>> Nov  8 18:53:45 raspberrypi weewx[5618] CRITICAL __main__: 
>> Waiting 2 minutes then retrying...
>> Nov  8 18:55:45 raspberrypi weewx[5618] INFO __main__: retrying...
>>
>> --
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/weewx-user/005fa296-d595-4f83-9626-1d6f45ccf251n%40googlegroups.com
> 
> .
>

-- 
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.
To view this discussion on the web visit