[mythtv-users] Database damage?
Craig Treleaven
ctreleaven at cogeco.ca
Sat Feb 13 12:47:07 UTC 2021
> On Feb 12, 2021, at 9:49 PM, Stephen Worthington <stephen_agent at jsw.gen.nz> wrote:
>
> When you say find_orphans.py crashes, do you mean it gives you a
> Python error message with a traceback? If so, then please post that
> and I can look at trying to fix it.
Thanks for the offer. Note that I’m still running 0.28-fixes and the backend and database are on Mac OS X.
I did a lot of manual pruning yesterday and have the number of zero byte recordings down to 561:
[much elided…]
MediumMini.local: Wisdom of the Crowd - Root Directory 1411_20180108005900.ts
MediumMini.local: Wisdom of the Crowd - The Tipping Point 1411_20180115005900.ts
MediumMini.local: Young Sheldon - A Math Emergency and Perky Palms 1041_20190208013000.ts
MediumMini.local: Young Sheldon - A Loaf of Bread and a Grand Old Flag 1041_20190222013000.ts
Count: 561
Are you sure you want to continue?
> yes
Traceback (most recent call last):
File "/opt/local/share/mythtv/contrib/find_orphans.py", line 230, in <module>
main()
File "/opt/local/share/mythtv/contrib/find_orphans.py", line 214, in main
opt[1](opt[2])
File "/opt/local/share/mythtv/contrib/find_orphans.py", line 129, in delete_recs
rec.delete(True, True)
File "/opt/local/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/MythTV/dataheap.py", line 365, in delete
return self.getProgram().delete(force, rerecord)
File "/opt/local/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/MythTV/mythproto.py", line 964, in delete
be.forgetRecording(self)
File "/opt/local/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/MythTV/mythproto.py", line 661, in forgetRecording
program.toString()]))
File "/opt/local/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/MythTV/mythproto.py", line 155, in backendCommand
return self._conn.command.backendCommand(data)
File "/opt/local/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/MythTV/connections.py", line 314, in backendCommand
self.reconnect(True)
File "/opt/local/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/MythTV/connections.py", line 243, in reconnect
self.connect()
File "/opt/local/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/MythTV/connections.py", line 224, in connect
self.socket.connect((self.host, self.port))
File "/opt/local/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/MythTV/utility/other.py", line 306, in connect
socket.socket.connect(self, *args, **kwargs)
File "/opt/local/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/socket.py", line 228, in meth
return getattr(self._sock,name)(*args)
socket.error: [Errno 61] Connection refused
Note that the backend crashed. The be log didn’t capture anything. A subsequent run of find_orphans.py indicated there are now 560 zero-byte recordings. I did not try to determine which one was removed! ;)
Following is some version info in case it helps:
MediumMini:~ mytthtv$ python --version
Python 2.7.10
MediumMini:~ mytthtv$ port provides /opt/local/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/socket.py
/opt/local/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/socket.py is provided by: python27
MediumMini:~ mytthtv$ mythfrontend --version
Please attach all output as a file in bug reports.
MythTV Version : v0.28.1-e26a33c6-MacPorts
MythTV Branch : fixes/0.28
Network Protocol : 88
Library API : 0.28.20161120-1
QT Version : 5.8.0
Options compiled in:
release darwin_da using_corevideo using_backend using_bindings_perl using_bindings_python using_bindings_php using_darwin using_frontend using_hdhomerun using_vbox using_libcrypto using_libdns_sd using_libfftw3 using_libxml2 using_lirc using_mheg using_opengl using_opengl_video using_opengl_themepainter using_qtwebkit using_qtscript using_taglib using_appleremote using_bindings_perl using_bindings_python using_bindings_php using_darwin_da using_freetype2 using_mythtranscode using_opengl using_ffmpeg_threads using_mheg using_libass using_libxml2
Craig
More information about the mythtv-users
mailing list