After 3 days of normal function again, it would appear I have a variation of the same problem, but with some subtle differences.
The Pi was not responsive on my network this morning and the Kodi client on my Android tablet could not connect, so I had no choice but to power off the Pi and turn it back on again. When I did, it appeared that all was well and when I checked the TVH web interface, the only oddity was that while TVH was still recognising the TVHat device and the USB DBV-T device I have since connected, both were reported as disabled. I also noticed that the priority setting I had changed on the USB adapter to ensure the TVHat had top priority (being a better quality tuner) had reverted back to default.
So I enabled both adapters in the Parameters screen (at which point both showed a green dot next to them instead of a red one) and set the priority for the USB adapter back to 1.
However, when I try to access any TV channels Kodi is still reporting "No free adapter available".
I have restarted the service using "sudo systemctl restart tvheadend" which has made no difference and neither has a full reboot.
ls -l /dev/dvb/adapter0
and
ls -l /dev/dvb/adapter1
both show results (this was something I discussed with another person when I had the original issue where the TVHat adapter was not being recognised by TVH at all and it turned out the ls -l /dev/dvb/adapter0 command did not work.
pi@pi-tv:~ $ ls -l /dev/dvb/adapter0
total 0
crw-rw---- 1 root video 212, 0 May 31 08:28 demux0
crw-rw---- 1 root video 212, 1 May 31 08:28 dvr0
crw-rw---- 1 root video 212, 3 May 31 08:28 frontend0
crw-rw---- 1 root video 212, 2 May 31 08:28 net0
pi@pi-tv:~ $ ls -l /dev/dvb/adapter1
total 0
crw-rw---- 1 root video 212, 5 May 31 08:28 demux0
crw-rw---- 1 root video 212, 6 May 31 08:28 dvr0
crw-rw---- 1 root video 212, 4 May 31 08:28 frontend0
sudo systemctl status tvheadend reports:-
pi@pi-tv:~ $ sudo systemctl status tvheadend
● tvheadend.service
Loaded: loaded (/etc/init.d/tvheadend; generated)
Active: active (running) since Wed 2023-05-31 08:28:32 BST; 7min ago
Docs: man:systemd-sysv-generator(8)
Process: 362 ExecStart=/etc/init.d/tvheadend start (code=exited, status=0/SUCCESS)
Tasks: 28 (limit: 2088)
CGroup: /system.slice/tvheadend.service
└─478 /usr/bin/tvheadend -f -u hts -g video
May 31 08:28:42 pi-tv.home.internal tvheadend[478]: epgdb: gzip format detected, inflating (ratio 21.6% deflated size 1873659)
May 31 08:28:42 pi-tv.home.internal tvheadend[478]: epgdb: parsing 8672311 bytes
May 31 08:28:42 pi-tv.home.internal tvheadend[478]: epgdb: loaded v2
May 31 08:28:42 pi-tv.home.internal tvheadend[478]: epgdb: config 1
May 31 08:28:42 pi-tv.home.internal tvheadend[478]: epgdb: brands 0
May 31 08:28:42 pi-tv.home.internal tvheadend[478]: epgdb: seasons 3726
May 31 08:28:42 pi-tv.home.internal tvheadend[478]: epgdb: episodes 8491
May 31 08:28:42 pi-tv.home.internal tvheadend[478]: epgdb: broadcasts 13414
May 31 08:28:43 pi-tv.home.internal tvheadend[478]: START: HTS Tvheadend version 4.2.8-34~g24a2f59e9 started, running as PID:478 UID:109 GID:44, CWD:/ CNF:/home/hts/.hts/tvheadend
May 31 08:28:44 pi-tv.home.internal tvheadend[478]: avahi: Service 'Tvheadend' successfully established.
The TVH web interface appears to show both tuners alive and well-
https://www.screencast.com/t/rAHpR7kztkz
https://www.screencast.com/t/rAHpR7kztkz
EDIT
Fixed again. Though unsure why this happened.
Where earlier I reported that the reboot appeared to result in the adapters still being present in TVH, but not enabled, and the amended priority for the USB tuner had gone back to 0, I've since discovered even after re-enabling each adapters neither had a Network assigned and I had to re-assign "DVB-T Network" to each and now have a functioning system again.