| Tuesday, November 19th, 2019, 00:07 UTC | ||
| [00:07:31] | amessina (amessina!~amessina@unaffiliated/amessina) has joined #mythtv | |
| [00:19:15] | peper03 (peper03!~peper03@mythtv/developer/peper03) has quit (Ping timeout: 246 seconds) | |
| [00:24:51] | peper03 (peper03!~peper03@mythtv/developer/peper03) has joined #mythtv | |
| [00:24:51] | Mode for #mythtv by ChanServ!ChanServ@services. : +v peper03 | |
| [00:40:32] | amessina (amessina!~amessina@unaffiliated/amessina) has quit (Remote host closed the connection) | |
| [00:41:00] | amessina (amessina!~amessina@unaffiliated/amessina) has joined #mythtv | |
| [01:47:01] | amessina (amessina!~amessina@unaffiliated/amessina) has quit (Remote host closed the connection) | |
| [01:47:29] | amessina (amessina!~amessina@unaffiliated/amessina) has joined #mythtv | |
| [02:02:40] | gregl (gregl!~greg@cpe-24-194-253-7.nycap.res.rr.com) has quit (Read error: Connection reset by peer) | |
| [02:04:10] | gregl (gregl!~greg@cpe-24-194-253-7.nycap.res.rr.com) has joined #mythtv | |
| [02:54:30] | amessina (amessina!~amessina@unaffiliated/amessina) has quit (Remote host closed the connection) | |
| [02:54:56] | amessina (amessina!~amessina@unaffiliated/amessina) has joined #mythtv | |
| [03:13:57] | amessina (amessina!~amessina@unaffiliated/amessina) has quit (Remote host closed the connection) | |
| [03:14:26] | amessina (amessina!~amessina@unaffiliated/amessina) has joined #mythtv | |
| [05:04:13] | Warped (Warped!~Warped@unaffiliated/warped) has quit (Ping timeout: 250 seconds) | |
| [05:29:09] | amessina (amessina!~amessina@unaffiliated/amessina) has quit (Quit: Konversation terminated!) | |
| [06:50:00] | peterbennett (peterbennett!~pi@mythtv/developer/peterbennett) has quit (Quit: WeeChat 2.3) | |
| [07:01:41] | peterbennett (peterbennett!~pi@mythtv/developer/peterbennett) has joined #mythtv | |
| [07:01:41] | Mode for #mythtv by ChanServ!ChanServ@services. : +v peterbennett | |
| [07:08:29] | markspieth22 (markspieth22!~yaaic@mythtv/developer/markspieth) has joined #mythtv | |
| [07:08:29] | Mode for #mythtv by ChanServ!ChanServ@services. : +v markspieth22 | |
| [07:12:17] | markspieth (markspieth!~yaaic@mythtv/developer/markspieth) has quit (Ping timeout: 264 seconds) | |
| [07:30:41] | markk_ (markk_!~mark@host109-149-186-43.range109-149.btcentralplus.com) has joined #mythtv | |
| [09:05:02] | Merlin83b (Merlin83b!~Daniel@office.34sp.com) has joined #mythtv | |
| [09:41:26] | SteveGoodey (SteveGoodey!~steve@host86-141-37-95.range86-141.btcentralplus.com) has joined #mythtv | |
| [09:41:27] | Mode for #mythtv by ChanServ!ChanServ@services. : +v SteveGoodey | |
| [10:11:37] | Merlin83b (Merlin83b!~Daniel@office.34sp.com) has quit (Ping timeout: 240 seconds) | |
| [10:16:39] | SteveGoodey (SteveGoodey!~steve@host86-141-37-95.range86-141.btcentralplus.com) has quit (Quit: Konversation terminated!) | |
| [10:16:55] | Merlin83b (Merlin83b!~Daniel@2a00:1ee0:3:1337:fdcb:6638:3d09:ca0a) has joined #mythtv | |
| [12:30:27] | markk_ (markk_!~mark@host109-149-186-43.range109-149.btcentralplus.com) has quit (Ping timeout: 240 seconds) | |
| [12:44:18] | markk_ (markk_!~mark@host109-149-186-43.range109-149.btcentralplus.com) has joined #mythtv | |
| [12:53:58] | Warped (Warped!~Warped@unaffiliated/warped) has joined #mythtv | |
| [13:14:00] | warpme_ (warpme_!uid391875@gateway/web/irccloud.com/x-qhfkicbzgdxqqfws) has joined #mythtv | |
| [13:33:37] | markk_ (markk_!~mark@host109-149-186-43.range109-149.btcentralplus.com) has quit (Ping timeout: 240 seconds) | |
| [13:46:14] | markk_ (markk_!~mark@host109-149-186-43.range109-149.btcentralplus.com) has joined #mythtv | |
| [14:52:01] | jheizer (jheizer!~jon@c-73-51-91-251.hsd1.il.comcast.net) has quit (Quit: WeeChat 1.9.1) | |
| [15:01:05] | jheizer (jheizer!~jon@c-73-51-91-251.hsd1.il.comcast.net) has joined #mythtv | |
| [15:01:05] | Mode for #mythtv by ChanServ!ChanServ@services. : +v jheizer | |
| [15:34:53] | jheizer: | Always check your backups... mysqldump on mythconverg has been creating 830byte files for ages. |
| [15:35:31] | jheizer: | Guess I broke it on an update. Yet another issue for this stupid server move. Should have just left things along. I'll get my builders back online one of these years. |
| [15:37:50] | jheizer: | Sadly the myth auto generated ones and my own cron ones were both trash |
| [15:41:57] | stuarta: | doh! |
| [15:42:27] | jheizer: | Man, even worth restoring a 2 year old backup? |
| [15:42:56] | stuarta: | still got the old drives? bring it up and do a fresh backup? |
| [15:43:16] | jheizer: | yeah, was trying to do that via chroot last night |
| [15:43:27] | jheizer: | as to not bring down the machine it had been moved too as my wife was working |
| [15:44:06] | jheizer: | guide said to kill some file in the data dir after moving to the new machine. Did that and no luck. Drive back in old machine and no luck. |
| [15:44:16] | jheizer: | So maybe a way to recover it still, but not sure. |
| [15:44:47] | stuarta: | is mysqldump erroring? |
| [15:44:51] | jheizer: | This is what all my backups have https://pastebin.com/wGZWLEjB |
| [15:46:04] | jheizer: | dump is mad server is not running. Still trying to figure out exactly why the server start is failing. |
| [15:47:48] | jheizer: | Oh oh oh, got it. |
| [15:47:58] | jheizer: | Had to kill aria_log_control |
| [15:48:46] | jheizer: | mysqldump: Got error: 1932: "Table 'mythconverg.music_radios' doesn't exist in engine" when using LOCK TABLES |
| [15:48:55] | jheizer: | why mysqldump has been failing |
| [15:51:04] | stuarta: | have you done an engine conversion to aria? |
| [15:51:25] | ** jheizer shrugs ** | |
| [15:51:37] | jheizer: | Not on purpose. |
| [15:51:48] | stuarta: | tbh it looks like it's running !MYISAM or !InnoDB |
| [15:52:10] | stuarta: | or missing that particular table |
| [15:52:25] | jheizer: | a 16 or 17 year old upgraded for ever DB |
| [15:52:40] | jheizer: | few tables its mad about |
| [15:52:42] | markk_ (markk_!~mark@host109-149-186-43.range109-149.btcentralplus.com) has quit (Ping timeout: 246 seconds) | |
| [15:52:52] | jheizer: | some weather ones |
| [15:53:00] | jheizer: | just dropping them all for now |
| [15:53:04] | stuarta: | looks like a few tables have ended up with a non standard engine |
| [15:53:09] | stuarta: | nah you can fix it |
| [15:53:25] | stuarta: | first `show create table <blah>` to find out what it is |
| [15:53:49] | jheizer: | Ah already did. I can dump a current fresh DB and put them back together. |
| [15:53:52] | stuarta: | then iirc, it's `alter table blah engine=MYISAM` i think we did |
| [15:54:03] | stuarta: | s/did/use |
| [15:55:09] | jheizer: | YES! 436M Nov 19 09:54 latest.sql |
| [15:55:58] | jheizer: | My guess would be something failing on a my->maria conversion |
| [15:56:08] | jheizer: | that sounds about like the time distros were making the move. |
| [15:57:01] | jheizer: | Annoying, auto backups, manual backups, backblaze offiste, and it all fails me cause I hadn't checked them in ages. |
| [15:57:46] | stuarta: | doh |
| [16:00:05] | jheizer: | Thanks listening/the help |
| [16:00:14] | jheizer: | too bad I didn't get all drop table happy |
| [16:00:19] | jheizer: | Could have saved me a few steps tonight. |
| [16:01:22] | stuarta: | np |
| [16:08:35] | amessina (amessina!~amessina@unaffiliated/amessina) has joined #mythtv | |
| [16:18:37] | amessina (amessina!~amessina@unaffiliated/amessina) has quit (Remote host closed the connection) | |
| [16:19:06] | amessina (amessina!~amessina@unaffiliated/amessina) has joined #mythtv | |
| [16:36:21] | markk_ (markk_!~mark@host109-149-186-43.range109-149.btcentralplus.com) has joined #mythtv | |
| [17:45:28] | Merlin83b (Merlin83b!~Daniel@2a00:1ee0:3:1337:fdcb:6638:3d09:ca0a) has quit (Quit: Leaving) | |
| [18:13:08] | amessina (amessina!~amessina@unaffiliated/amessina) has quit (Remote host closed the connection) | |
| [18:13:33] | amessina (amessina!~amessina@unaffiliated/amessina) has joined #mythtv | |
| [18:37:38] | markk_ (markk_!~mark@host109-149-186-43.range109-149.btcentralplus.com) has quit (Ping timeout: 240 seconds) | |
| [18:41:46] | markk_ (markk_!~mark@host109-149-186-43.range109-149.btcentralplus.com) has joined #mythtv | |
| [19:42:03] | markk_ (markk_!~mark@host109-149-186-43.range109-149.btcentralplus.com) has quit (Ping timeout: 240 seconds) | |
| [20:02:35] | amessina (amessina!~amessina@unaffiliated/amessina) has quit (Remote host closed the connection) | |
| [20:03:00] | amessina (amessina!~amessina@unaffiliated/amessina) has joined #mythtv | |
| [20:07:29] | amessina_ (amessina_!~amessina@unaffiliated/amessina) has joined #mythtv | |
| [20:07:48] | amessina (amessina!~amessina@unaffiliated/amessina) has quit (Ping timeout: 245 seconds) | |
| [20:16:29] | amessina_ (amessina_!~amessina@unaffiliated/amessina) has quit (Remote host closed the connection) | |
| [20:16:54] | amessina_ (amessina_!~amessina@unaffiliated/amessina) has joined #mythtv | |
| [20:36:25] | markk_ (markk_!~mark@host109-149-186-43.range109-149.btcentralplus.com) has joined #mythtv | |
| [21:01:23] | stuarta: | yay, finally stuff is doing what i want it todo |
| [21:02:26] | Tobbe5178 (Tobbe5178!~asdf@81-235-210-78-no62.tbcn.telia.com) has quit (Read error: Connection reset by peer) | |
| [21:12:33] | markspieth2: | is it ok to add another python dependency for ttvdb? fuzzywuzzy is what I have used to fix #135154 and it works well. |
| [21:12:33] | ** MythLogBot https://code.mythtv.org/trac/ticket/135154 ** | |
| [21:12:46] | markspieth2: | #13514 |
| [21:12:46] | ** MythLogBot https://code.mythtv.org/trac/ticket/13514 ** | |
| [21:13:26] | stuarta: | markspieth2: provides it's on the common platforms, yes |
| [21:13:37] | stuarta: | ubuntu lts is the most important |
| [21:14:38] | markspieth2: | I just installed it on debian fine, py2 and 3 both work |
| [21:14:51] | markspieth2: | so ubuntu is np |
| [21:14:57] | stuarta: | \o/ |
| [21:15:19] | stuarta: | wonder if it's on centos7, for the 2 users that use it |
| [21:15:55] | markspieth2: | rpm should have it too. |
| [21:16:07] | markspieth2: | tbc |
| [21:17:25] | markspieth2: | I wont push this just yet until there is more feedback |
| [21:21:32] | ** stuarta insults centos7 ** | |
| [21:22:46] | stuarta: | tbh, if you are happy it's available on debian / ubuntu we can leave the centos one to require it via pip |
| [21:32:05] | markspieth22 (markspieth22!~yaaic@mythtv/developer/markspieth) has quit (Ping timeout: 264 seconds) | |
| [21:39:29] | markspieth (markspieth!~yaaic@mythtv/developer/markspieth) has joined #mythtv | |
| [21:39:29] | Mode for #mythtv by ChanServ!ChanServ@services. : +v markspieth | |
| [21:51:58] | stuarta: | markspieth2: dunno if you saw my previous comment |
| [21:52:05] | stuarta: | tbh, if you are happy it's available on debian / ubuntu we can leave the centos one to require it via pip <- this one |
| [22:16:52] | markspieth: | xenial is supported. fedora 29 is supported too. will push today with updates to the 2 packgers to follow |
| [22:22:48] | stuarta: | awesome |
| [22:23:08] | stuarta: | if you feel up to it, please add the relevant package names to the ansible playbooks |
| [22:30:00] | amessina_ (amessina_!~amessina@unaffiliated/amessina) has quit (Remote host closed the connection) | |
| [22:30:28] | amessina_ (amessina_!~amessina@unaffiliated/amessina) has joined #mythtv | |
| [22:48:26] | markk_ (markk_!~mark@host109-149-186-43.range109-149.btcentralplus.com) has quit (Ping timeout: 240 seconds) | |
| [22:57:46] | markspieth: | which repo is ansible in? never touched this before. |
| [23:50:58] | markspieth: | found it but will probably break dnf. I can push deb though and suse looks old/incomplete |
IRC Logs collected by
BeirdoBot.
Please use the above link to report any bugs.