[mythtv-users] I somehow broke it [solved]

Thu Jan 2 00:58:52 UTC 2020

Hi All

myisamchk -r /var/lib/mysql/mythconverg

fixed all the rules and guide data errors.
Now a more careful look at backup and restore
James

> The local station, trying to be clever, but being stupid, have a new year cant-find-a-polite-word
> 
> I record daily News at 5pm, that lasts 1 hour (much rubbish) and ends with weather.
> I record 15 min past end on all programs.
> 
> They now have two identically named News, one at 5pm, one at 6pm being a breakfast TV type entertainment discussion panel, with the weather drifting over 6pm.
> 
> OK methought, get rid of the recording rule, and manually record at 5pm for 70 minutes.
> 
> 1) myth schedules 1 news from 5 - 6 missing the last minute or so of weather and does not record the 15 min extra.
> I presume scheduler has some funny logic that says you recorded XXX, now it is showing again so do not extend.
> 
> 2) mythweb deleted all rules when I deleted that rule
> mythbackend version: fixes/29 [v29.1-60-gaf5d819671]
> 
> I do a daily DB backup, with logrotate of 4 so just restore the DB
> but
> 
> [sandypit] /store/jam [998]% df
> Filesystem      1K-blocks       Used  Available Use% Mounted on
> devtmpfs          8118380          0    8118380   0% /dev
> tmpfs             8128528          0    8128528   0% /dev/shm
> tmpfs             8128528     473860    7654668   6% /run
> tmpfs             8128528          0    8128528   0% /sys/fs/cgroup
> /dev/sda3        20511312   12850096    6596256  67% /
> /dev/sda1          255724       5048     250676   2% /boot/efi
> /dev/sda2        20511312    4836012   14610340  25% /other
> /dev/sda5      1872008924 1069247764  707598488  61% /store
> /dev/sdb1      4844216220 3502195708 1097815652  77% /backup
> /dev/sdc1      3845547004 1564635952 2085545476  43% /store/Movies
> tmpfs             1625704         16    1625688   1% /run/user/1000
> 
> [sandypit] /store/jam [999]% ls -ld mythconverg/
> drwxr-xr-x 2 jam users 4096 Nov  4 05:04 mythconverg/
> [sandypit] /store/jam [1000]% ll mythconverg/
> total 224608
> -rw-r--r-- 1 jam users 45860474 Oct 31 05:04 mythconverg-1348-20191031050401.sql.gz
> -rw-r--r-- 1 jam users 46034719 Nov  1 05:04 mythconverg-1348-20191101050401.sql.gz
> -rw-r--r-- 1 jam users 46094039 Nov  2 05:04 mythconverg-1348-20191102050401.sql.gz
> -rw-r--r-- 1 jam users 45981773 Nov  3 05:04 mythconverg-1348-20191103050401.sql.gz
> -rw-r--r-- 1 jam users 45914491 Nov  4 05:04 mythconverg-1348-20191104050401.sql.gz
> -rw-r--r-- 1 jam users     2265 Apr 29  2019 seticons
> -rw-r--r-- 1 jam users    76802 Apr 29  2019 tableDesc
> 
> [sandypit] /store/jam [1001]% cat .mythtv/backuprc
> DBBackupDirectory=/home/jam/mythconverg
> 
> [sandypit] /store/jam [1002]% /usr/local/bin/mythconverg_backup.pl
> 
> ERROR: DBBackupDirectory is not a directory or is not writable. Please specify
>       a directory in your database information file using DBBackupDirectory.
>       If not using a database information file, please specify the
>        --directory command-line option.
> 
> Invalid backup directory, stopped at /usr/local/bin/mythconverg_backup.pl line 878.
> 
> ——————————————————————————
> So my questins are, before I go spelunking and fiddling with sql
> 
> 1) can I restore the recording rules from the months old backup
> 2) the guide, which I get from epg, was erased and is suspiciously blank an hour later. What to do about that.
> The recordings and videos with meta data are intact
> 
> I run 29 as 1 of my backends is mac, and (sorry Dan) after a month of trying I could not build a 30 mac frontend
> James
> 
> PS the spate of failures on a system that has been fine for years appears HW. but no other symptoms occur as too the disk
> SMART Attributes Data Structure revision number: 1
> Vendor Specific SMART Attributes with Thresholds:
> ID# ATTRIBUTE_NAME          FLAG     VALUE WORST THRESH TYPE      UPDATED  WHEN_FAILED RAW_VALUE
>  5 Reallocated_Sector_Ct   0x0033   100   100   010    Pre-fail  Always       -       0
>  9 Power_On_Hours          0x0032   099   099   000    Old_age   Always       -       3420
> 12 Power_Cycle_Count       0x0032   099   099   000    Old_age   Always       -       28
> 177 Wear_Leveling_Count     0x0013   099   099   000    Pre-fail  Always       -       3
> 179 Used_Rsvd_Blk_Cnt_Tot   0x0013   100   100   010    Pre-fail  Always       -       0
> 181 Program_Fail_Cnt_Total  0x0032   100   100   010    Old_age   Always       -       0
> 182 Erase_Fail_Count_Total  0x0032   100   100   010    Old_age   Always       -       0
> 183 Runtime_Bad_Block       0x0013   100   100   010    Pre-fail  Always       -       0
> 187 Reported_Uncorrect      0x0032   100   100   000    Old_age   Always       -       0
> 190 Airflow_Temperature_Cel 0x0032   069   044   000    Old_age   Always       -       31
> 195 Hardware_ECC_Recovered  0x001a   200   200   000    Old_age   Always       -       0
> 199 UDMA_CRC_Error_Count    0x003e   100   100   000    Old_age   Always       -       0
> 235 Unknown_Attribute       0x0012   099   099   000    Old_age   Always       -       17
> 241 Total_LBAs_Written      0x0032   099   099   000    Old_age   Always       -       5991669827
> 
> SMART Error Log Version: 1
> No Errors Logged