I am having problems with the sdr driver as a result of having a page with many queries that causes after a few hours when weewx writes in the database it gives the database is locked error. I also don't understand why weewx doesn't wait for the query to finish before writing. When this happens, weewx restart but the sdr driver is unable to boot because there is another process rtl_433 running and it gives the error usb_claim_interface error -6. The driver enters in a loop that does not come out until I stop weewx, kill the rtl_433 process and start weewx again I think the problem is that the previous rtl_433 process was not killed.
Sep 16 00:06:03 raspberrypi weewx[21121]: manager: Added record 2019-09-16 00:05:00 CEST (1568585100) to database 'weewx.sdb' Sep 16 00:06:03 raspberrypi weewx[21121]: manager: Added record 2019-09-16 00:05:00 CEST (1568585100) to daily summary in 'weewx.sdb' Sep 16 00:06:08 raspberrypi weewx[21121]: engine: Main loop exiting. Shutting engine down. Sep 16 00:06:08 raspberrypi weewx[21121]: engine: Shutting down StdReport thread Sep 16 00:06:09 raspberrypi weewx[21121]: Belchertown Extension: Query:SELECT strftime("%m", datetime(dateTime, "unixepoch")) as month, IFNULL(sum(rain),0) as obs FROM archive WHERE dateTime >= 1420066800 AND dateTime <= 1451602800 GROUP BY month; Sep 16 00:06:14 raspberrypi weewx[21121]: reportengine: Caught unrecoverable exception in generator 'user.belchertown.HighchartsJsonGenerator' Sep 16 00:06:14 raspberrypi weewx[21121]: **** database is locked Sep 16 00:06:14 raspberrypi weewx[21121]: **** Traceback (most recent call last): Sep 16 00:06:14 raspberrypi weewx[21121]: **** File "/usr/share/weewx/weewx/reportengine.py", line 204, in run Sep 16 00:06:14 raspberrypi weewx[21121]: **** obj.start() Sep 16 00:06:14 raspberrypi weewx[21121]: **** File "/usr/share/weewx/weewx/reportengine.py", line 300, in start Sep 16 00:06:14 raspberrypi weewx[21121]: **** self.run() Sep 16 00:06:14 raspberrypi weewx[21121]: **** File "/usr/share/weewx/user/belchertown.py", line 1205, in run Sep 16 00:06:14 raspberrypi weewx[21121]: **** series_data = self._getObservationData(binding, archive, observation_type, minstamp, maxstamp, aggregate_type, aggregate_interval, time_length, xaxis_groupby, xaxis_categories, mirrored_value) Sep 16 00:06:14 raspberrypi weewx[21121]: **** File "/usr/share/weewx/user/belchertown.py", line 1592, in _getObservationData Sep 16 00:06:14 raspberrypi weewx[21121]: **** for row in query: Sep 16 00:06:14 raspberrypi weewx[21121]: **** File "/usr/share/weewx/weewx/manager.py", line 407, in genSql Sep 16 00:06:14 raspberrypi weewx[21121]: **** for _row in _cursor.execute(sql, sqlargs): Sep 16 00:06:14 raspberrypi weewx[21121]: **** File "/usr/share/weewx/weedb/sqlite.py", line 43, in guarded_fn Sep 16 00:06:14 raspberrypi weewx[21121]: **** raise weedb.OperationalError(e) Sep 16 00:06:14 raspberrypi weewx[21121]: **** OperationalError: database is locked Sep 16 00:06:14 raspberrypi weewx[21121]: **** Generator terminated Sep 16 00:06:14 raspberrypi weewx[21121]: sdr: MainThread: shutdown process rtl_433 -q -F json -R 32 -M utc -f 868.3M Sep 16 00:06:24 raspberrypi weewx[21121]: sdr: MainThread: timed out waiting for stdout-thread Sep 16 00:06:34 raspberrypi weewx[21121]: sdr: MainThread: timed out waiting for stderr-thread Sep 16 00:06:34 raspberrypi weewx[21121]: engine: Database OperationalError exception: database is locked Sep 16 00:06:34 raspberrypi weewx[21121]: **** Waiting 2 minutes then retrying... Sep 16 00:08:34 raspberrypi weewx[21121]: engine: retrying... Sep 16 00:08:34 raspberrypi weewx[21121]: engine: Using configuration file /etc/weewx/weewx.conf Sep 16 00:08:34 raspberrypi weewx[21121]: engine: Loading station type SDR (user.sdr) Sep 16 00:08:34 raspberrypi weewx[21121]: sdr: MainThread: driver version is 0.64 Sep 16 00:08:34 raspberrypi weewx[21121]: sdr: MainThread: sensor map is {'windGust': 'wind_gust.*.FOWHx080Packet', 'windDir': 'wind_dir.*.FOWHx080Packet', 'windSpeed': 'wind_speed.*.FOWHx080Packet', 'outTemp': 'temperature.*.FOWHx080Packet', 'outHumidity': 'humidity.*.FOWHx080Packet', 'rain_total': 'rain_total.*.FOWHx080Packet', 'battery': 'battery.*.FOWHx080Packet'} Sep 16 00:08:34 raspberrypi weewx[21121]: sdr: MainThread: deltas is {'rain': 'rain_total'} Sep 16 00:08:34 raspberrypi weewx[21121]: sdr: MainThread: startup process 'rtl_433 -q -F json -R 32 -M utc -f 868.3M' ... ... Sep 16 00:08:35 raspberrypi weewx[21121]: engine: Starting main packet loop. Sep 16 00:08:35 raspberrypi weewx[21121]: sdr: MainThread: err: ['rtl_433 version unknown inputs file rtl_tcp RTL-SDR\n', 'Trying conf file at "rtl_433.conf"...\n', 'Trying conf file at "/root/.config/rtl_433/rtl_433.conf"...\n', 'Trying conf file at "/usr/local/etc/rtl_433/rtl_433.conf"...\n', 'Trying conf file at "/etc/rtl_433/rtl_433.conf"...\n', 'quiet option (-q) is default and deprecated. See -v to increase verbosity\n', '\n', '\tConsider using "-M newmodel" to transition to new model keys. This will become the default someday.\n', '\tA table of changes and discussion is at https://github.com/merbanan/rtl_433/pull/986.\n', '\n', 'Registered 1 out of 133 device decoding protocols [ 32 ]\n', *'usb_claim_interface error -6* \n'] Sep 16 00:08:35 raspberrypi weewx[21121]: engine: Main loop exiting. Shutting engine down. Sep 16 00:08:35 raspberrypi weewx[21121]: sdr: MainThread: shutdown process rtl_433 -q -F json -R 32 -M utc -f 868.3M Sep 16 00:08:35 raspberrypi weewx[21121]: engine: Caught WeeWxIOError: rtl_433 process is not running Sep 16 00:08:35 raspberrypi weewx[21121]: **** Waiting 60 seconds then retrying... Sep 16 00:09:35 raspberrypi weewx[21121]: engine: retrying... Sep 16 00:09:35 raspberrypi weewx[21121]: engine: Using configuration file /etc/weewx/weewx.conf Sep 16 00:09:35 raspberrypi weewx[21121]: engine: Loading station type SDR (user.sdr) Sep 16 00:09:35 raspberrypi weewx[21121]: sdr: MainThread: driver version is 0.64 Sep 16 00:09:35 raspberrypi weewx[21121]: sdr: MainThread: sensor map is {'windGust': 'wind_gust.*.FOWHx080Packet', 'windDir': 'wind_dir.*.FOWHx080Packet', 'windSpeed': 'wind_speed.*.FOWHx080Packet', 'outTemp': 'temperature.*.FOWHx080Packet', 'outHumidity': 'humidity.*.FOWHx080Packet', 'rain_total': 'rain_total.*.FOWHx080Packet', 'battery': 'battery.*.FOWHx080Packet'} Sep 16 00:09:35 raspberrypi weewx[21121]: sdr: MainThread: deltas is {'rain': 'rain_total'} Sep 16 00:09:35 raspberrypi weewx[21121]: sdr: MainThread: startup process 'rtl_433 -q -F json -R 32 -M utc -f 868.3M' ... -- 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/5795ad1c-25df-416c-8094-00aae73378b7%40googlegroups.com.