Re: [weewx-user] Re: Database Error Message

Here is a sanitized copy of my Weewx.conf. I do have all of my Belchertown settings in the weewx conf , so it adds a bunch of lines. I'm really not sure about the synthetic measurements. # WEEWX CONFIGURATION FILE # # Copyright (c) 2009-2019 Tom Keffer # See the file LICENSE.txt for your rights.

Re: [weewx-user] Re: Database Error Message

I'm also using my Pi3 as a MQTT server feeding Belchertown I'm not sure if that makes a difference or not. With all of that being said everything runs smoothly on WeeWxVersion 4. I know Tom said that version 5 does a lot more. I also use my PI3 for ADSB sending data to a few ADSB sites. On Wed, Ja

Re: [weewx-user] Re: Database Error Message

It's not Belchertown. It's not db size. I ran many tests. v5 and Belchertown can easily coexist on a pi3 or so system. If every time through you're exceeding the default archive period you're doing something custom to make that happen. I keep coming back to the known issue/slowness with syn

Re: [weewx-user] Re: Database Error Message

gt; >>>>>>> Yes I'm on a PI3 with ADSB tracking running as well. I changed the >>>>>>> archive to 300 so we'll see how it goes. Never had the issue before >>>>>>> upgrading to 5.0 so it must be somewhat related to that. I'v

Re: [weewx-user] Re: Database Error Message

n Tue, Jan 16, 2024 at 2:36 PM sanphillipo >>>>> wrote: >>>>> >>>>>> Yes I'm on a PI3 with ADSB tracking running as well. I changed the >>>>>> archive to 300 so we'll see how it goes. Never had the issue before >>&

Re: [weewx-user] Re: Database Error Message

ng as well. I changed the >>>>> archive to 300 so we'll see how it goes. Never had the issue before >>>>> upgrading to 5.0 so it must be somewhat related to that. I've noticed >>>>> that >>>>> CPU usage and temps are slightly higher than

Re: [weewx-user] Re: Database Error Message

it goes. Never had the issue before >>>> upgrading to 5.0 so it must be somewhat related to that. I've noticed >>>> that >>>> CPU usage and temps are slightly higher than average since I upgraded last >>>> night. Thanks for the suggestions.

Re: [weewx-user] Re: Database Error Message

to 5.0 so it must be somewhat related to that. I've noticed that >>> CPU usage and temps are slightly higher than average since I upgraded last >>> night. Thanks for the suggestions. >>> >>> >>> >>> Sent from my Verizon, Samsung Galaxy sma

Re: [weewx-user] Re: Database Error Message

martphone >> >> >> Original message -------- >> From: vince >> Date: 1/16/24 4:12 PM (GMT-05:00) >> To: weewx-user >> Subject: Re: [weewx-user] Re: Database Error Message >> >> The log excerpt is a little short but perhaps. I

Re: [weewx-user] Re: Database Error Message

Sent from my Verizon, Samsung Galaxy smartphone > > > Original message > From: vince > Date: 1/16/24 4:12 PM (GMT-05:00) > To: weewx-user > Subject: Re: [weewx-user] Re: Database Error Message > > The log excerpt is a little short but perhaps. I see i

Re: [weewx-user] Re: Database Error Message

On a MacBook Air M1 I'm getting "Generated 32 files for report Belchertown in 1.21 seconds" We know from our benchmarks that it's about 20x faster than an RPi3, so I would expect times in the 24-30 second range. On Tue,

Re: [weewx-user] Re: Database Error Message

aded last night. Thanks for the suggestions. Sent from my Verizon, Samsung Galaxy smartphone Original message From: vince Date: 1/16/24 4:12 PM (GMT-05:00) To: weewx-user Subject: Re: [weewx-user] Re: Database Error Message The log excerpt is a little short but perhaps.   I see

Re: [weewx-user] Re: Database Error Message

Tom - FWIW on a pi4 with multiple skins+extensions enabled I'm seeing Belchertown generate in 4 to 11 seconds depending on time of day so over 120 definitely seems like a hardware problem or that synthetic reading thing if they've customized at all. Typical is under 5 secs with hourly perhaps

Re: [weewx-user] Re: Database Error Message

Agree with Vince. However, it seems that the Belchertown skin is very slow under V5. I'll try and do some investigation later. In the meantime, switching to a 5 minute archive interval will probably solve your problem. -tk On Tue, Jan 16, 2024 at 1:12 PM vince wrote: > The log excerpt is a lit

Re: [weewx-user] Re: Database Error Message

The log excerpt is a little short but perhaps. I see in your log you have a 120 second archive period yet Belchertown took 125 seconds to run (which is 'very' slow), so it's possible your archive period is too fast for your hardware. What kind of pi are you on ? Something slower than a pi4

Re: [weewx-user] Re: Database Error Message

Hope this is the information you were looking for. Jan 16 14:10:52 raspberrypi weewxd[23682]: INFO __main__: Initializing weewxd version 5.0.0 Jan 16 14:10:52 raspberrypi weewxd[23682]: INFO __main__: Command line: /usr/share/weewx/weewxd.py /etc/weewx/weewx.conf Jan 16 14:10:52 raspberrypi weewxd

[weewx-user] Re: Database Error Message

>From the FAQ - https://github.com/weewx/weewx/wiki/WeeWX-Frequently-Asked-Questions#where-do-i-find-the-log >From the wiki - https://github.com/weewx/weewx/wiki/view-logs On Tuesday, January 16, 2024 at 10:59:42 AM UTC-8 Michael Sanphillipo wrote: > I set the debug to 1 and restarted Weewx. Wh

[weewx-user] Re: Database Error Message

I set the debug to 1 and restarted Weewx. Where will the log be on a Raspberry Pi3 running Buster? On Tuesday, January 16, 2024 at 12:58:53 PM UTC-5 vince wrote: > Usual ‘how to report a problem’ answer applies… > > Set debug=1, restart weewx, post the log from beginning of restart through > ‘t

[weewx-user] Re: Database Error Message

Usual ‘how to report a problem’ answer applies… Set debug=1, restart weewx, post the log from beginning of restart through ‘two’ reporting intervals. Some more info on what kind of pi might help too. On Tuesday, January 16, 2024 at 8:13:48 AM UTC-8 Michael Sanphillipo wrote: > I upgraded from v

Re: [weewx-user] Re: Database error

Thomas Using SQLITE on my raspberry with the 7" screen attached to it SQLITE was twice the size and I couldn't get it smaller so was very difficult to use, therefore decided to try it on the laptop with the bigger screen plus the fact as I had a lot to change I could take it work and do the adjustm

[weewx-user] Re: Database error

It worked! installed Sqlite3 on my Pi, dumped, rebuilt, no more errors! Thanks again. On Wednesday, 31 October 2018 12:41:57 UTC, Jules wrote: > > Hi, > > I'm seeing database is malformed errors. I've searched and found post on > how to fix this by running sqlite3 and dumping to ascii and re

[weewx-user] Re: Database error

Hi, I'll give that a go, thanks. Jules On Wednesday, 31 October 2018 12:41:57 UTC, Jules wrote: > > Hi, > > I'm seeing database is malformed errors. I've searched and found post on > how to fix this by running sqlite3 and dumping to ascii and re-importing. > > My problem is running sqlite3 !

[weewx-user] Re: database error

works again. i restore my backup. now i change the system to orange pi +2 and install complete to emmc. Am Samstag, 2. September 2017 12:12:56 UTC+2 schrieb Ralf Buck: > > hello > > it seems that my database had a error > > Sep 02 12:11:56 raspberrypi weewx[1385]: File > "/usr/share/we

Re: [weewx-user] Re: database error

Most likely the USB stick is corrupted. They are not designed to be primary storage, so it has probably worn out and failed. One thing to try. The error occurred while dumping the daily summaries, which need not be saved --- they can recreated from the archive. So, you can try just dumping the arc

[weewx-user] Re: database error

echo '.dump' | sqlite3 ./weewx.sdb INSERT INTO "archive_day_wind" VALUES(1494972000,0.0,1494973048,13.7,1495019248,3.62385185185185498824e+02,288,3.62385185185185498824e+02,288,NULL,2.34090915588452297413e+02,-8.79672687838567135543e+01,259,9.18866833690265671918e+02,9.18866833690265671918e+

[weewx-user] Re: database error

i will read this. my sdb file is on a usb stick Am Samstag, 2. September 2017 12:12:56 UTC+2 schrieb Ralf Buck: > > hello > > it seems that my database had a error > > Sep 02 12:11:56 raspberrypi weewx[1385]: File > "/usr/share/weewx/weewx/manager.py", line 214, in firstGoodStamp > Sep