<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">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> </div></div></div>