<div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Oct 11, 2023 at 11:05 AM Paul Harrison <<a href="mailto:mythtv@mythqml.net">mythtv@mythqml.net</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><u></u>
<div>
<p>On 11/10/2023 14:52, James Abernathy wrote:</p>
<blockquote type="cite">
<div dir="ltr">
<div dir="ltr"><br>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Wed, Oct 11, 2023 at
8:58 AM James Abernathy <<a href="mailto:jfabernathy@gmail.com" target="_blank">jfabernathy@gmail.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div dir="ltr"><br>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Wed, Oct 11, 2023
at 8:55 AM James Abernathy <<a href="mailto:jfabernathy@gmail.com" target="_blank">jfabernathy@gmail.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div dir="ltr"><br>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Wed, Oct 11,
2023 at 8:42 AM David Hampton via mythtv-users
<<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On
Wed, 2023-10-11 at 07:58 -0400, James Abernathy
wrote:<br>
> <br>
> <br>
> On Wed, Oct 11, 2023 at 7:51 AM John
Pilkington<br>
> <<a href="mailto:johnpilk222@gmail.com" target="_blank">johnpilk222@gmail.com</a>>
wrote:<br>
> > On 11/10/2023 12:42, James Abernathy
wrote:<br>
> > > <br>
> > > <br>
> > > On Wed, Oct 11, 2023 at 7:22 AM
James Abernathy<br>
> > > <<a href="mailto:jfabernathy@gmail.com" target="_blank">jfabernathy@gmail.com</a>
<br>
> > > <mailto:<a href="mailto:jfabernathy@gmail.com" target="_blank">jfabernathy@gmail.com</a>>>
wrote:<br>
> > > <br>
> > > I have my mythconverg backup
script running daily and after<br>
> > > yesterday's update to master
it didn't run this morning at<br>
> > > 5:40 as<br>
> > > it should. I know because I
didn't get the email it usually<br>
> > > sends<br>
> > > to one of my gmail accounts.<br>
> > > <br>
> > > I checked the systemctl
status and this is what I saw:<br>
> > > <br>
> > > Oct 11 05:40:02
kubuntu-closet systemd[1]: Starting Backup<br>
> > > MythTV<br>
> > > Database 'mythconverg'...<br>
> > > Oct 11 05:40:02
kubuntu-closet mythtv-database-<br>
> > > backup.sh[319303]:<br>
> > > Database schema 1379 not
supported.<br>
> > > Oct 11 05:40:02
kubuntu-closet mythtv-database-<br>
> > > backup.sh[319303]:<br>
> > > Bindings support schema
version 1378<br>
> > > Oct 11 05:40:02
kubuntu-closet systemd[1]:<br>
> > >
mythtv-database-backup.service: Main process
exited,<br>
> > > code=exited,<br>
> > > status=1/FAILURE<br>
> > > Oct 11 05:40:02
kubuntu-closet systemd[1]:<br>
> > >
mythtv-database-backup.service: Failed with
result 'exit-<br>
> > > code'.<br>
> > > Oct 11 05:40:02
kubuntu-closet systemd[1]: Failed to start<br>
> > > Backup<br>
> > > MythTV Database
'mythconverg'.<br>
> > > <br>
> > > <br>
> > > Not sure why it's talking
about schema 1379??<br>
> > > <br>
> > > Jim A<br>
> > > <br>
> > > <br>
> > > BTW, the complete script that
systemd runs to backup is below:<br>
> > > #!/bin/sh<br>
> > > #
/etc/cron.weekly/mythtv-database script - check
and backup<br>
> > > mythconverg <br>
> > > tables<br>
> > > # Copyright 2005/12/02 2006/10/08
Paul Andreassen<br>
> > > # 2010 Mario
Limonciello<br>
> > > <br>
> > > set -e -u<br>
> > > <br>
> > > DBNAME="mythconverg"<br>
> > > USER="mythtv"<br>
> > >
OPT_MYTHDB='/usr/share/doc/mythtv-<br>
> > > backend/contrib/maintenance/<a href="http://optimize_mythdb.pl" rel="noreferrer" target="_blank">optimize_mythdb.pl</a><br>
> > > <<a href="http://optimize_mythdb.pl" rel="noreferrer" target="_blank">http://optimize_mythdb.pl</a>>'<br>
> > > <br>
> > > /usr/bin/mysqlcheck -s $DBNAME<br>
> > > <br>
> > >
BKUP_LOG=/tmp/backup-mythconverg.log<br>
> > > <br>
> > > export
MYTHCONFDIR=/home/mythtv/.mythtv/<br>
> > > <br>
> > > ${OPT_MYTHDB} | grep -v
"^Analyzed:" 2>&1 > $BKUP_LOG<br>
> > > <br>
> > > sudo --preserve-env --user=$USER<br>
> > > /usr/share/mythtv/<a href="http://mythconverg_backup.pl" rel="noreferrer" target="_blank">mythconverg_backup.pl</a>
<br>
> > > <<a href="http://mythconverg_backup.pl" rel="noreferrer" target="_blank">http://mythconverg_backup.pl</a>>
\<br>
> > > --rotate=5 --verbose
2>&1 >> $BKUP_LOG<br>
> > > <br>
> > > if [ $? -eq 0 ]; then<br>
> > > MSG="kubuntu-closet $DBNAME
Checked and Backed Up, RC=$?"<br>
> > > else<br>
> > > MSG="kubuntu-closet $DBNAME
Back Up Failed, RC=$?"<br>
> > > fi<br>
> > > <br>
> > > cd /data/mythtv/db_backups/<br>
> > > ls -l --directory --block-size=K
* | tail -10 >> $BKUP_LOG<br>
> > > <br>
> > > mail -s "$MSG" <a href="mailto:my.email@gmail.com" target="_blank">my.email@gmail.com</a>
<mailto:<a href="mailto:my.email@gmail.com" target="_blank">my.email@gmail.com</a>>
<<br>
> > > $BKUP_LOG<br>
> > > <br>
> > > --------------------------<br>
> > > <br>
> > > The actual error I get when it's
run from the console is:<br>
> > > <br>
> > > Database schema 1379 not
supported.<br>
> > > Bindings support schema version
1378<br>
> > > <br>
> > > Jim A<br>
> > > <br>
> > chema 1379 came with yesterday's
commit for gallery images.<br>
> > <br>
> > <br>
> > <a href="https://github.com/MythTV/mythtv/commit/5825b36c97ec742f908845ccd11eee40040c0529" rel="noreferrer" target="_blank">https://github.com/MythTV/mythtv/commit/5825b36c97ec742f908845ccd11eee40040c0529</a><br>
> > <br>
> > ISTR that these updates used to get a
bigger flag. Nowadays they<br>
> > just <br>
> > happen...<br>
> > <br>
> > <br>
> <br>
> <br>
> It seems that normal TV program recording
and playback still works<br>
> fine, so I'll wait for things to just
clear up. <br>
<br>
Did your MythTV perl bindings get updated at the
same time your backend<br>
was updated? They should both use schema 1379.
What's the output of:<br>
<br>
grep SCHEMA $(find /usr -name MythTV.pm
2>/dev/null) | head -1<br>
<br>
I was able to run a database backup on my
production system (schema<br>
1379) without a problem.<br>
<br>
David<br>
<br>
</blockquote>
<div><br>
</div>
<span style="font-family:monospace"><span style="font-weight:bold;color:rgb(84,255,84)">jim@kubuntu-closet</span><span style="color:rgb(0,0,0)">:</span><span style="font-weight:bold;color:rgb(84,84,255)">~</span><span style="color:rgb(0,0,0)">$ grep SCHEMA $(find
/usr -name MythTV.pm 2>/dev/null) | head -1
</span><br>
/usr/local/share/perl/5.34.0/MythTV.pm: our
$SCHEMA_VERSION = "1378";
<br>
<span style="font-weight:bold;color:rgb(84,255,84)">jim@kubuntu-closet</span><span style="color:rgb(0,0,0)">:</span><span style="font-weight:bold;color:rgb(84,84,255)">~</span><span style="color:rgb(0,0,0)">$</span><br>
</span>
<div><br>
</div>
<div><br>
</div>
<div>Jim A</div>
<div><br>
</div>
</div>
</div>
</blockquote>
<div><br>
</div>
<div>FYI, I tried this on a Debian 12 build and it
showed </div>
<div><span style="font-family:monospace"><span style="font-weight:bold;color:rgb(84,255,84)">jim@debian-mythtv</span><span style="color:rgb(0,0,0)">:</span><span style="font-weight:bold;color:rgb(84,84,255)">~</span><span style="color:rgb(0,0,0)">$ grep SCHEMA $(find
/usr -name MythTV.pm 2>/dev/null) | head -1
</span><br>
/usr/share/perl5/MythTV.pm: our $SCHEMA_VERSION =
"1379";<br>
<br>
</span></div>
<div><span style="font-family:monospace">The previous
run was on a Ubuntu 22.04 system using the ppa</span></div>
<div><span style="font-family:monospace"><br>
</span></div>
<div><span style="font-family:monospace">Jim A</span></div>
</div>
</div>
</blockquote>
<div><br>
</div>
<div>I did some more digging and it is definitely a Ubuntu PPA
v34 related issue. The Debian 12 backend where I build my
own packages did run the mythconverg optimize and backup
just fine this morning and it's stamped as a 1379 schema.</div>
<div><br>
</div>
<div>Jim A</div>
<div><br>
</div>
</div>
</div>
<br>
</blockquote>
<p><br>
</p>
<p>There can be up to 24 hours delay in the building of the PPA
packages. Are you sure you have the latest build installed?</p>
<p>You can use <span style="font-family:monospace"><span style="color:rgb(0,0,0);background-color:rgb(255,255,255)">apt-cache
policy libmythtv-perl </span></span>to see what version of
the perl binding you have installed.</p>
<p><br>
</p>
<p>Paul H.<br>
<span style="font-family:monospace"><span style="color:rgb(0,0,0);background-color:rgb(255,255,255)"> </span></span>
</p>
</div></blockquote><div><br></div><div>apt-cache policy libmythtv-perl<br>libmythtv-perl:<br> Installed: 2:34.0~master.202310100432.20594a9a1e~ubuntu22.04.1<br> Candidate: 2:34.0~master.202310100432.20594a9a1e~ubuntu22.04.1<br> Version table:<br> *** 2:34.0~master.202310100432.20594a9a1e~ubuntu22.04.1 500<br> 500 <a href="https://ppa.launchpadcontent.net/mythbuntu/34/ubuntu">https://ppa.launchpadcontent.net/mythbuntu/34/ubuntu</a> jammy/main amd64 Packages<br> 500 <a href="https://ppa.launchpadcontent.net/mythbuntu/34/ubuntu">https://ppa.launchpadcontent.net/mythbuntu/34/ubuntu</a> jammy/main i386 Packages<br> 100 /var/lib/dpkg/status<br> 2:32.0+fixes.20220325.f69ce764b7-0ubuntu1 500<br> 500 <a href="http://us.archive.ubuntu.com/ubuntu">http://us.archive.ubuntu.com/ubuntu</a> jammy/multiverse amd64 Packages<br> 500 <a href="http://us.archive.ubuntu.com/ubuntu">http://us.archive.ubuntu.com/ubuntu</a> jammy/multiverse i386 Packages<br> </div></div></div>