Bit more progress but slight confusion.
The database did indeed have two rows in every table relating to the exceptional date above. The last_updated stamp in the archive meta file was also exceptional. I wrote a little python script (attached) to correct all these and starting weewx over with the cleaned DB was successful however then it picked up on the following record from the logger (?) .
Jun 17 09:54:33 pecan-ubuntu weewx[3255] INFO __main__: Starting up weewx version 4.1.1
Jun 17 09:54:33 pecan-ubuntu weewx[3255] DEBUG weewx.drivers.vantage: Gentle wake up of console successful
Jun 17 09:54:33 pecan-ubuntu weewx[3255] INFO weewx.engine: Clock error is 1.92 seconds (positive is fast)
Jun 17 09:54:33 pecan-ubuntu weewx[3255] INFO weewx.engine: Using binding 'wx_binding' to database 'weewx.sdb'
Jun 17 09:54:33 pecan-ubuntu weewx[3255] INFO weewx.manager: Starting backfill of daily summaries
Jun 17 09:54:33 pecan-ubuntu weewx[3255] DEBUG weewx.drivers.vantage: Getting archive packets since 2021-06-16 20:16:00 BST (1623870960)
Jun 17 09:54:33 pecan-ubuntu weewx[3255] DEBUG weewx.drivers.vantage: Gentle wake up of console successful
Jun 17 09:54:33 pecan-ubuntu weewx[3255] DEBUG weewx.drivers.vantage: Retrieving 28 page(s); starting index= 0
Jun 17 09:54:33 pecan-ubuntu weewx[3255] ERROR weewx.engine: Internal error detected. Catchup abandoned
Jun 17 09:54:33 pecan-ubuntu weewx[3255] ERROR weewx.engine: **** Unknown archive type = 0xbf
Jun 17 09:54:33 pecan-ubuntu weewx[3255] INFO weewx.engine: Starting main packet loop.
Jun 17 09:54:33 pecan-ubuntu weewx[3255] DEBUG weewx.drivers.vantage: Gentle wake up of console successful
Jun 17 09:54:33 pecan-ubuntu weewx[3255] DEBUG weewx.drivers.vantage: Requesting 200 LOOP packets.
Jun 17 09:54:33 pecan-ubuntu weewx[3255] DEBUG weewx.drivers.vantage: Gentle wake up of console successful
Jun 17 09:55:14 pecan-ubuntu weewx[3255] DEBUG weewx.drivers.vantage: Getting archive packets since 2021-06-16 20:16:00 BST (1623870960)
Jun 17 09:55:15 pecan-ubuntu weewx[3255] DEBUG weewx.drivers.vantage: Gentle wake up of console successful
Jun 17 09:55:15 pecan-ubuntu weewx[3255] DEBUG weewx.drivers.vantage: Retrieving 28 page(s); starting index= 0
Jun 17 09:55:15 pecan-ubuntu weewx[3255] WARNING weewx.engine: ignore historical record: {'dateTime': 4996107120, 'usUnits': 1, 'interval': 1, 'rxCheckPercent': 100.0, 'outTemp': 1612.4, 'highOutTemp': 3257.5, 'lowOutTemp': 3263.9, 'rain': 223.9921246179, 'rainRate': 507.9606268227, 'barometer': 65.535, 'radiation': 65519.0, 'wind_samples': 65535.0, 'inTemp': -156.9, 'inHumidity': 155.0, 'outHumidity': 187.0, 'windSpeed': 127.0, 'windGust': 231.0, 'windGustDir': 2497.5, 'windDir': 2857.5, 'UV': 24.9, 'ET': 0.248, 'soilMoist1': 111.0, 'soilMoist3': 223.0, 'soilTemp3': 133.0, 'leafWet2': 251.0, 'leafWet3': 239.0, 'extraTemp2': 164.0, 'extraHumid1': 158.0, 'extraHumid2': 127.0, 'readClosed': 61951, 'readOpened': 32694}
Jun 17 09:55:15 pecan-ubuntu weewx[3255] DEBUG weewx.drivers.vantage: DMPAFT complete: page timestamp 2127-12-28 07:35:00 GMT (4985652900) less than final timestamp 2128-04-27 07:32:00 GMT (4996107120)
Jun 17 09:55:15 pecan-ubuntu weewx[3255] DEBUG weewx.drivers.vantage: Catch up complete.
Jun 17 09:55:15 pecan-ubuntu weewx[3255] DEBUG weewx.reportengine: Running reports for latest time in the database.
Jun 17 09:55:15 pecan-ubuntu weewx[3255] DEBUG weewx.drivers.vantage: Requesting 200 LOOP packets.
Jun 17 09:55:15 pecan-ubuntu weewx[3255] DEBUG weewx.reportengine: Running report 'StandardReport'
Jun 17 09:55:15 pecan-ubuntu weewx[3255] DEBUG weewx.drivers.vantage: Gentle wake up of console successful
So, I thought I would try one more clear-memory before factory resetting the VUE as clearing data previously has not worked and hopefully clean the data it has stored on board and this is the error message now!
File "./bin/wee_device", line 78, in <module>
main()
File "./bin/wee_device", line 74, in main
device.configure(config_dict)
File "/home/weewx/bin/weewx/drivers/__init__.py", line 67, in configure
self.do_options(options, parser, config_dict, not options.noprompt)
File "/home/weewx/bin/weewx/drivers/vantage.py", line 2055, in do_options
station = Vantage(**config_dict[DRIVER_NAME])
File "/home/weewx/bin/weewx/drivers/vantage.py", line 515, in __init__
log.debug("Hardware name: %s", self.hardware_name)
File "/home/weewx/bin/weewx/drivers/vantage.py", line 1292, in hardware_name
raise weewx.UnsupportedFeature("Unknown hardware type %d" % self.hardware_type)
weewx.UnsupportedFeature: Unknown hardware type 10