Do you have a null value for dateTime in your database?

Here is how to check.First, make sure you have the tool sqlite3

*sudo apt-get install sqlite3*


Then use it to find null values

*sqlite3 /var/lib/weewx/weewx.sdb*
*sqlite> select dateTime from archive where dateTime isnull;*
*sqlite> .quit*


There should not be any null values.



On Fri, Mar 10, 2023 at 4:47 AM PC <blaise.cacr...@gmail.com> wrote:

> J'ai un autre problème :
> Mar 10 13:43:52 PiMeteo weewx[3486]: Stopping weewx weather system: weewx
> not running....
> Mar 10 13:43:52 PiMeteo systemd[1]: weewx.service: Succeeded.
> Mar 10 13:43:52 PiMeteo systemd[1]: Stopped LSB: weewx weather system.
> Mar 10 13:43:52 PiMeteo systemd[1]: Starting LSB: weewx weather system...
> Mar 10 13:43:52 PiMeteo weewx[3508] INFO __main__: Initializing weewx
> version 4.10.2
> Mar 10 13:43:52 PiMeteo weewx[3508] INFO __main__: Using Python 3.7.3
> (default, Oct 31 2022, 14:04:00) #012[GCC 8.3.0]
> Mar 10 13:43:52 PiMeteo weewx[3508] INFO __main__: Located at /bin/python3
> Mar 10 13:43:52 PiMeteo weewx[3508] INFO __main__: Platform
> Linux-5.10.103-v7l+-armv7l-with-debian-10.13
> Mar 10 13:43:52 PiMeteo weewx[3508] INFO __main__: Locale is 'fr_BE.UTF-8'
> Mar 10 13:43:52 PiMeteo weewx[3508] INFO __main__: Using configuration
> file /etc/weewx/weewx.conf
> Mar 10 13:43:52 PiMeteo weewx[3508] INFO __main__: Debug is 1
> Mar 10 13:43:52 PiMeteo weewx[3508] INFO __main__: PID file is
> /var/run/weewx.pid
> Mar 10 13:43:52 PiMeteo weewx[3512] DEBUG __main__: Initializing engine
> Mar 10 13:43:52 PiMeteo weewx[3512] INFO weewx.engine: Loading station
> type Vantage (weewx.drivers.vantage)
> Mar 10 13:43:52 PiMeteo weewx[3512] DEBUG weewx.drivers.vantage: Driver
> version is 3.5.2
> Mar 10 13:43:52 PiMeteo weewx[3512] DEBUG weewx.drivers.vantage: Option
> loop_request=1
> Mar 10 13:43:52 PiMeteo weewx[3512] DEBUG weewx.drivers.vantage: Opened up
> serial port /dev/ttyUSB0; baud 19200; timeout 4.00
> Mar 10 13:43:52 PiMeteo weewx[3497]: Starting weewx weather system: weewx.
> Mar 10 13:43:52 PiMeteo systemd[1]: Started LSB: weewx weather system.
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.drivers.vantage:
> Successfully woke up Vantage console
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.drivers.vantage: Hardware
> type is 16
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.drivers.vantage: ISS ID is
> 1
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.drivers.vantage: Hardware
> name: Vantage Pro2
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Loading service
> weewx.engine.StdTimeSynch
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Finished loading
> service weewx.engine.StdTimeSynch
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Loading service
> weewx.engine.StdConvert
> Mar 10 13:43:53 PiMeteo weewx[3512] INFO weewx.engine: StdConvert target
> unit is 0x10
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Finished loading
> service weewx.engine.StdConvert
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Loading service
> weewx.engine.StdCalibrate
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Finished loading
> service weewx.engine.StdCalibrate
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Loading service
> weewx.engine.StdQC
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Finished loading
> service weewx.engine.StdQC
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Loading service
> weewx.wxservices.StdWXCalculate
> Mar 10 13:43:53 PiMeteo weewx[3512] INFO weewx.wxservices: StdWXCalculate
> will use data binding wx_binding
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.manager: Daily summary
> version is 4.0
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Finished loading
> service weewx.wxservices.StdWXCalculate
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Loading service
> weewx.wxxtypes.StdWXXTypes
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Finished loading
> service weewx.wxxtypes.StdWXXTypes
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Loading service
> weewx.wxxtypes.StdPressureCooker
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Finished loading
> service weewx.wxxtypes.StdPressureCooker
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Loading service
> weewx.wxxtypes.StdRainRater
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Finished loading
> service weewx.wxxtypes.StdRainRater
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Loading service
> weewx.wxxtypes.StdDelta
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Finished loading
> service weewx.wxxtypes.StdDelta
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Loading service
> weewx.engine.StdArchive
> Mar 10 13:43:53 PiMeteo weewx[3512] INFO weewx.engine: Archive will use
> data binding wx_binding
> Mar 10 13:43:53 PiMeteo weewx[3512] INFO weewx.engine: Record generation
> will be attempted in 'hardware'
> Mar 10 13:43:53 PiMeteo weewx[3512] INFO weewx.engine: Using archive
> interval of 300 seconds (specified by hardware)
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Use LOOP data in
> hi/low calculations: 1
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Finished loading
> service weewx.engine.StdArchive
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Loading service
> weewx.restx.StdStationRegistry
> Mar 10 13:43:53 PiMeteo weewx[3512] INFO weewx.restx: StationRegistry:
> Registration not requested.
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Finished loading
> service weewx.restx.StdStationRegistry
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Loading service
> weewx.restx.StdWunderground
> Mar 10 13:43:53 PiMeteo weewx[3512] INFO weewx.restx: Wunderground:
> Posting not enabled.
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Finished loading
> service weewx.restx.StdWunderground
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Loading service
> weewx.restx.StdPWSweather
> Mar 10 13:43:53 PiMeteo weewx[3512] INFO weewx.restx: PWSweather: Posting
> not enabled.
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Finished loading
> service weewx.restx.StdPWSweather
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Loading service
> weewx.restx.StdCWOP
> Mar 10 13:43:53 PiMeteo weewx[3512] INFO weewx.restx: CWOP: Posting not
> enabled.
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Finished loading
> service weewx.restx.StdCWOP
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Loading service
> weewx.restx.StdWOW
> Mar 10 13:43:53 PiMeteo weewx[3512] INFO weewx.restx: WOW: Posting not
> enabled.
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Finished loading
> service weewx.restx.StdWOW
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Loading service
> weewx.restx.StdAWEKAS
> Mar 10 13:43:53 PiMeteo weewx[3512] INFO weewx.restx: AWEKAS: Posting not
> enabled.
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Finished loading
> service weewx.restx.StdAWEKAS
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Loading service
> user.mqtt.MQTT
> Mar 10 13:43:53 PiMeteo weewx[3512] INFO user.mqtt: service version is 0.24
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.restx: MQTT: Data will not
> be posted: Missing option 'server_url'
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Finished loading
> service user.mqtt.MQTT
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Loading service
> weewx.engine.StdPrint
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Finished loading
> service weewx.engine.StdPrint
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Loading service
> weewx.engine.StdReport
> Mar 10 13:43:53 PiMeteo weewx[3512] INFO weewx.engine: 'pyephem' detected,
> extended almanac data is available
> Mar 10 13:43:53 PiMeteo weewx[3512] DEBUG weewx.engine: Finished loading
> service weewx.engine.StdReport
> Mar 10 13:43:53 PiMeteo weewx[3512] INFO __main__: Starting up weewx
> version 4.10.2
> Mar 10 13:43:54 PiMeteo weewx[3512] DEBUG weewx.drivers.vantage:
> Successfully woke up Vantage console
> Mar 10 13:43:54 PiMeteo weewx[3512] INFO weewx.engine: Clock error is 0.73
> seconds (positive is fast)
> Mar 10 13:43:54 PiMeteo weewx[3512] INFO weewx.engine: Using binding
> 'wx_binding' to database 'weewx'
> Mar 10 13:43:54 PiMeteo weewx[3512] INFO weewx.manager: Starting backfill
> of daily summaries
> Mar 10 13:43:54 PiMeteo weewx[3512] INFO weewx.engine: Main loop exiting.
> Shutting engine down.
> Mar 10 13:43:54 PiMeteo weewx[3512] CRITICAL __main__: Caught
> unrecoverable exception:
> Mar 10 13:43:54 PiMeteo weewx[3512] CRITICAL __main__:     ****  '<=' not
> supported between instances of 'NoneType' and 'int'
> Mar 10 13:43:54 PiMeteo weewx[3512] CRITICAL __main__:     ****  Traceback
> (most recent call last):
> Mar 10 13:43:54 PiMeteo weewx[3512] CRITICAL __main__:     ****    File
> "/usr/share/weewx/weewxd", line 154, in main
> Mar 10 13:43:54 PiMeteo weewx[3512] CRITICAL __main__:     ****
>  engine.run()
> Mar 10 13:43:54 PiMeteo weewx[3512] CRITICAL __main__:     ****    File
> "/usr/share/weewx/weewx/engine.py", line 178, in run
> Mar 10 13:43:54 PiMeteo weewx[3512] CRITICAL __main__:     ****
>  self.dispatchEvent(weewx.Event(weewx.STARTUP))
> Mar 10 13:43:54 PiMeteo weewx[3512] CRITICAL __main__:     ****    File
> "/usr/share/weewx/weewx/engine.py", line 245, in dispatchEvent
> Mar 10 13:43:54 PiMeteo weewx[3512] CRITICAL __main__:     ****
>  callback(event)
> Mar 10 13:43:54 PiMeteo weewx[3512] CRITICAL __main__:     ****    File
> "/usr/share/weewx/weewx/engine.py", line 576, in startup
> Mar 10 13:43:54 PiMeteo weewx[3512] CRITICAL __main__:     ****
>  _nrecs, _ndays = dbmanager.backfill_day_summary()
> Mar 10 13:43:54 PiMeteo weewx[3512] CRITICAL __main__:     ****    File
> "/usr/share/weewx/weewx/manager.py", line 1299, in backfill_day_summary
> Mar 10 13:43:54 PiMeteo weewx[3512] CRITICAL __main__:     ****      for
> rec in self.genBatchRecords(start_batch_ts, stop_batch_ts):
> Mar 10 13:43:54 PiMeteo weewx[3512] CRITICAL __main__:     ****    File
> "/usr/share/weewx/weewx/manager.py", line 524, in genBatchRecords
> Mar 10 13:43:54 PiMeteo weewx[3512] CRITICAL __main__:     ****      for
> _row in self.genBatchRows(startstamp, stopstamp):
> Mar 10 13:43:54 PiMeteo weewx[3512] CRITICAL __main__:     ****    File
> "/usr/share/weewx/weewx/manager.py", line 505, in genBatchRows
> Mar 10 13:43:54 PiMeteo weewx[3512] CRITICAL __main__:     ****      if
> _row[0] <= _last_time:
> Mar 10 13:43:54 PiMeteo weewx[3512] CRITICAL __main__:     ****
>  TypeError: '<=' not supported between instances of 'NoneType' and 'int'
> Mar 10 13:43:54 PiMeteo weewx[3512] CRITICAL __main__:     ****  Exiting.
>
> Le vendredi 10 mars 2023 à 12:31:21 UTC+1, Tom Keffer a écrit :
>
>> Classic case of logger corruption. See the wiki:
>> https://github.com/weewx/weewx/wiki/Troubleshooting-the-Davis-Vantage-station#corrupt-station-memory
>>
>> On Fri, Mar 10, 2023 at 12:14 AM PC <blaise....@gmail.com> wrote:
>>
>>> Hello
>>> To follow up on the discussion
>>> https://groups.google.com/u/2/g/weewx-user/c/sl1zgrU0cd0 below, I
>>> applied the procedure
>>> https://forums.raspberrypi.com/viewtopic.php?t=262963#p1608493
>>> Weewx resumed life but with a constant delay not arranging and with a
>>> "hole" of a week from February 28. I tried "Wee_database-Rebuild-Daily"
>>> and there, it is no longer data. I found this in the log
>>>
>>> Mar 10 09:00:24 PiMeteo weewx[14479] DEBUG weewx.drivers.vantage:
>>> Retrieving 513 page(s); starting index= 0
>>> Mar 10 09:00:24 PiMeteo weewx[14479] DEBUG weewx.drivers.vantage: DMPAFT
>>> complete: page timestamp 2003-12-03 13:45:00 CET (1070455500) less than
>>> final timestamp 2023-03-08 15:20:00 CET (1678285200)
>>>
>>> How can you fix this?
>>> Where to modify the final timestamp?
>>>
>>> Merci
>>>
>>> --
>>> 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/4a67f8f9-c3e0-4e15-aaf4-63f7a5001230n%40googlegroups.com
>>> <https://groups.google.com/d/msgid/weewx-user/4a67f8f9-c3e0-4e15-aaf4-63f7a5001230n%40googlegroups.com?utm_medium=email&utm_source=footer>
>>> .
>>>
>> --
> 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/3a30f04c-a564-4f89-9594-8e417bfb8ed6n%40googlegroups.com
> <https://groups.google.com/d/msgid/weewx-user/3a30f04c-a564-4f89-9594-8e417bfb8ed6n%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>

-- 
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/CAPq0zECiP%3DwQPXEujAq3cz402MwRrG2ax6xsHp3o0enAoDzeOw%40mail.gmail.com.

Reply via email to