Beirdobot, irc.freenode.net

Wednesday, June 17th, 2020, 00:16 UTC

[00:16:43]

ooshlablu (ooshlablu!~ooshlablu@2601:18d:4600:43f0:58fe:c734:81fe:c957) has quit (Ping timeout: 260 seconds)

[00:17:11]

ooshlablu (ooshlablu!~ooshlablu@98.217.124.239) has joined #mythtv

[01:39:48]

gigem_:

jpabq_: How do you propose to handle the priority channel filter? My system used to depend on it working for record once rules. That's no longer the case but might be for others. Work up a patch for me to look at and try for a while and we'll see.

[03:03:58]

MythBuild:

Build [#30](https://code.mythtv.org/buildbot/#builders/188/builds/30) of `tidy-master` completed successfully.

[04:07:40]

markspieth (markspieth!~yaaic@mythtv/developer/markspieth) has quit (Ping timeout: 245 seconds)

[04:12:03]

markspieth (markspieth!~yaaic@mythtv/developer/markspieth) has joined #mythtv

[04:12:04]

Mode for #mythtv by ChanServ!ChanServ@services. : +v markspieth

[04:30:12]

tonsofpcs (tonsofpcs!~mythbuntu@rivendell/member/tonsofpcs) has quit (Ping timeout: 260 seconds)

[05:33:46]

markspieth2 (markspieth2!~yaaic@mythtv/developer/markspieth) has joined #mythtv

[05:33:46]

Mode for #mythtv by ChanServ!ChanServ@services. : +v markspieth2

[05:37:40]

markspieth (markspieth!~yaaic@mythtv/developer/markspieth) has quit (Ping timeout: 245 seconds)

[05:55:14]

kalamaja (kalamaja!~kalamaja@95.153.20.2) has left #mythtv ("Back to the real world.")

[06:56:33]

Steve-Goodey (Steve-Goodey!~steve@2a00:23c5:7d83:6501:6032:9caa:16d4:6ffa) has joined #mythtv

[06:56:33]

Mode for #mythtv by ChanServ!ChanServ@services. : +v Steve-Goodey

[07:39:20]

blahdodo (blahdodo!~blahdodo@69.172.190.84) has quit (Quit: Bye bye)

[07:43:33]

blahdodo (blahdodo!~blahdodo@69.172.190.84) has joined #mythtv

[07:53:41]

Warped (Warped!~Warped@unaffiliated/warped) has quit (Ping timeout: 272 seconds)

[07:54:19]

Warped_ (Warped_!~Warped@108.85.160.119) has joined #mythtv

[07:57:05]

MythBuild:

Build [#661](https://code.mythtv.org/buildbot/#builders/41/builds/661) of `master-freebsd11–64bit` completed successfully.

[08:05:25]

MythBuild:

Build [#796](https://code.mythtv.org/buildbot/#builders/45/builds/796) of `master-freebsd12–64bit` completed successfully.

[08:09:49]

Steve-Goodey:

morning all

[08:22:40]

stuarta:

Steve-Goodey: morning

[08:40:55]

stuarta:

ooo an akismet antispam extension for the forum

[09:02:11]

Steve-Goodey:

Wordpress though?

[09:02:30]

stuarta:

the API is generic

[09:07:40]

stuarta:

https://akismet.com/development/api/#comment-check <- probably the most useful bit

[09:08:18]

Steve-Goodey:

Ah. So junk stopforumspam or run as well?

[09:08:31]

stuarta:

both

[09:08:42]

stuarta:

SFS does more on the ip/username side

[09:09:48]

stuarta:

there's also fspamlist

[09:09:53]

stuarta:

trac uses all three

[09:10:18]

stuarta:

as well as DNS blacklists

[09:11:37]

warpme_ (warpme_!uid391875@gateway/web/irccloud.com/x-bqtcwlgevvwmwmsj) has joined #mythtv

[09:16:12]

stuarta:

#13635

[09:16:12]

** MythLogBot https://code.mythtv.org/trac/ticket/13635 **

[09:17:25]

stuarta:

it must work, as it's been a long time since we had any spam on trac

[09:18:11]

stuarta:

that and the fact we require people to be authenticated against github

[09:22:05]

Steve-Goodey:

Could you use Github as an authenticator for other MythTV services? Forum/Wiki etc.

[09:22:58]

stuarta:

i have a wiki upgrade todo, and we should be then able to use SSO for that

[09:23:11]

stuarta:

forum i need to investigate some more

[09:35:56]

RokLobsta (RokLobsta!~Dirkka@121-200-12-5.79c80c.mel.nbn.aussiebb.net) has joined #mythtv

[09:45:15]

Steve-Goodey (Steve-Goodey!~steve@2a00:23c5:7d83:6501:6032:9caa:16d4:6ffa) has quit (Quit: Konversation terminated!)

[10:33:35]

Warped_ (Warped_!~Warped@108.85.160.119) has quit (Quit: ChatZilla 0.9.92-rdmsoft [XULRunner 35.0.1/20150122214805])

[10:36:55]

Warped (Warped!~Warped@unaffiliated/warped) has joined #mythtv

[11:19:36]

hampton:

stuarta: Thanks for the bashiness fix.

[11:20:31]

stuarta:

hampton: np, i just committed the patch i shared yesterday

[12:28:33]

Steve-Goodey (Steve-Goodey!~steve@2a00:23c5:7d83:6501:6032:9caa:16d4:6ffa) has joined #mythtv

[12:28:33]

Mode for #mythtv by ChanServ!ChanServ@services. : +v Steve-Goodey

[12:36:58]

markspieth2 (markspieth2!~yaaic@mythtv/developer/markspieth) has quit (Remote host closed the connection)

[12:49:02]

Steve-Goodey:

stuarta: Haven't seen wagnerrp around for ages. ref: 11437

[12:56:32]

RokLobsta (RokLobsta!~Dirkka@121-200-12-5.79c80c.mel.nbn.aussiebb.net) has quit (Ping timeout: 258 seconds)

[13:24:02]

stuarta:

Steve-Goodey: feel free to suggest a new victim

[13:26:31]

stuarta:

i lose track of who is still active

[13:26:42]

stuarta:

!seen wagnerrp

[13:26:42]

MythLogBot:

wagnerrp was last seen 898 days 12 hours 24 minutes 30 seconds ago

[13:27:21]

RokLobsta (RokLobsta!~Dirkka@121-200-12-5.79c80c.mel.nbn.aussiebb.net) has joined #mythtv

[13:30:27]

stuarta:

#11437

[13:30:27]

** MythLogBot https://code.mythtv.org/trac/ticket/11437 **

[13:30:53]

hampton:

I wonder how well this mini-projector would do as a MythTV frontend. https://www.amazon.com/dp/B07TF834PT

[13:31:39]

stuarta:

dunno, but given it's out of stock, it'll be a while before we can find out!

[13:33:52]

hampton:

Interesing. It shows in stock for me here in the US.

[13:34:05]

stuarta:

clearly they don't want to ship it to the UK

[13:50:49]

SteveGoodey (SteveGoodey!~steve@host86-145-34-0.range86-145.btcentralplus.com) has joined #mythtv

[13:50:49]

Mode for #mythtv by ChanServ!ChanServ@services. : +v SteveGoodey

[13:58:56]

RokLobsta (RokLobsta!~Dirkka@121-200-12-5.79c80c.mel.nbn.aussiebb.net) has quit (Quit: Leaving)

[14:12:27]

jpabq_:

200 ANSI Lumen is low, but what do you expect from a battery powered projector?

[14:36:43]

peterben1 is now known as peterbennett

[14:36:52]

peterbennett (peterbennett!~pi@2601:183:100:2951:75f1:9c8e:c180:9f08) has quit (Changing host)

[14:36:52]

peterbennett (peterbennett!~pi@mythtv/developer/peterbennett) has joined #mythtv

[14:36:53]

Mode for #mythtv by ChanServ!ChanServ@services. : +v peterbennett

[14:38:13]

peterbennett:

Since I moved from mariadb to mysql, the service Dvr/GetRecordedList started taking 38 seconds.

[14:38:38]

stuarta:

that is odd

[14:38:47]

stuarta:

sounds more like a missing index

[14:38:50]

peterbennett:

Service Dvr/GetRecordedList runs hundreds of queries against recordedartwork

[14:39:10]

peterbennett:

I did this: CREATE INDEX recordedartwork_ix1 ON recordedartwork (inetref);

[14:39:20]

peterbennett:

Now it runs in 4 seconds

[14:39:48]

peterbennett:

Do we have any strategy for indexes on the tables?

[14:39:59]

stuarta:

nope

[14:40:07]

stuarta:

hell we haven't even moved to innodb

[14:40:34]

stuarta:

which would make the whole thing crash proof at a bare minimum

[14:41:30]

peterbennett:

I see it is using MyISAM

[14:41:52]

stuarta:

we have *always* used myisam

[14:42:17]

stuarta:

personally i'd like to see us use innodb

[14:42:38]

peterbennett:

I guess MyISAM is the default when you create a table

[14:42:49]

peterbennett:

I am not an expert in MySQL

[14:43:00]

** stuarta has done lots of mysql in the past **

[14:43:11]

stuarta:

peterbennett: yes myisam was always the default out of the box

[14:43:41]

stuarta:

you can change it, but 99.9% of users never will

[14:43:53]

peterbennett:

So I should just tell people if they want reasonable performance with Leanfront they should create that index....

[14:44:36]

stuarta:

and do a schema update in master to add it

[14:44:41]

ooshlablu (ooshlablu!~ooshlablu@98.217.124.239) has quit (Remote host closed the connection)

[14:45:22]

peterbennett:

Do we have any indexes at all?

[14:45:25]

stuarta:

peterbennett: and/or work on optimizing the queries thatt

[14:45:29]

stuarta:

the call uses

[14:45:42]

ooshlablu (ooshlablu!~ooshlablu@98.217.124.239) has joined #mythtv

[14:45:58]

stuarta:

like is it using a single query per recording, or 1 query to pull the whole dataset

[14:46:12]

stuarta:

the former would suck for performance

[14:46:27]

peterbennett:

It runs a separate query for each program (after it has got the program list). --> SELECT host, coverart, fanart, banner FROM recordedartwork WHERE inetref = 'ttvdb.py_76846' ORDER BY season = 11 DESC, season DESC

[14:46:34]

stuarta:

ugh

[14:46:37]

stuarta:

that's shit

[14:46:42]

peterbennett:

Probably some type of joind would be better

[14:46:47]

peterbennett:

join

[14:47:26]

stuarta:

also i would do an EXPLAIN on the query (without the index) and see what (if any) indexes it uses

[14:48:29]

peterbennett:

I assume it uses no index if there is none ?

[14:49:19]

stuarta:

oh ffs, it doesn't even have a primary key

[14:49:30]

stuarta:

so it's doing a full table search for each query

[14:50:25]

peterbennett:

I only have 925 rows.

[14:50:28]

stuarta:

https://paste.centos.org/view/91b2d6f2

[14:51:03]

stuarta:

peterbennett: if you run the query above with the word EXPLAIN before it

[14:51:11]

stuarta:

mysql will tell you how it goes about finding the data

[14:51:18]

stuarta:

suggest changing ; to \G

[14:51:22]

stuarta:

when you do

[14:51:22]

peterbennett:

I takes 38 seconds when it is doing a separate select for each recording, During that time the serve using 100% of one CPU

[14:51:47]

stuarta:

almost certainly io bound while the DB is doing the table scan

[14:52:38]

peterbennett:

Now it is using the index I created.

[14:53:00]

peterbennett:

I can drop the index and see what it says

[14:54:05]

peterbennett:

without the index it says 1, SIMPLE, recordedartwork, , ALL, , , , , 925, 10.00, Using where; Using filesort

[14:54:43]

peterbennett:

With the index: '1', 'SIMPLE', 'recordedartwork', NULL, 'ref', 'recordedartwork_ix1', 'recordedartwork_ix1', '767', 'const', '12', '100.00', 'Using filesort'

[14:55:33]

stuarta:

so the difference is, for the first part of the query (mysql internally breaks it down into subqueries) it now uses the index, whilst before it was doing a table scan

[14:56:13]

peterbennett:

yes. However with only 925 rows in the table I would have though that an index is not critical.

[14:56:41]

stuarta:

that would be true if there was even a primary key

[14:57:17]

peterbennett:

I believe inetref should be set as primary key

[14:57:21]

stuarta:

in the absense of a PK, there is absolutely nothing the DB has to go on, to find the records

[14:57:34]

stuarta:

until you created the index

[14:59:45]

peterbennett:

actually inetref is duplicated so it cannot be a primary key

[15:01:21]

stuarta:

i suspected that might be the case

[15:01:34]

stuarta:

so it definitely needs the index

[15:01:46]

peterbennett:

It also looks like recordedartwork never gets cleaned up – there is a lot of very old stuff in there.

[15:01:57]

** stuarta is not surprised **

[15:04:22]

peterbennett:

(inetref, season, host) may be a unique key

[15:16:45]

stuarta:

why is host even relevant to an artwork? surely it relates to a recording?

[15:20:01]

** stuarta finds #12167 **

[15:20:01]

** MythLogBot https://code.mythtv.org/trac/ticket/12167 **

[15:20:02]

SteveJGoodey (SteveJGoodey!~quassel@2a00:23c5:7d83:6501:3ca9:98a0:dcb4:f58e) has joined #mythtv

[15:20:02]

Mode for #mythtv by ChanServ!ChanServ@services. : +v SteveJGoodey

[15:26:50]

Steve-Goodey (Steve-Goodey!~steve@2a00:23c5:7d83:6501:6032:9caa:16d4:6ffa) has quit (Quit: Konversation terminated!)

[15:28:28]

ooshlablu (ooshlablu!~ooshlablu@98.217.124.239) has quit (Remote host closed the connection)

[15:29:39]

ooshlablu (ooshlablu!~ooshlablu@98.217.124.239) has joined #mythtv

[15:34:16]

Guest28700 (Guest28700!maliutamat@gateway/shell/matrix.org/x-biuexaonfrrseetq) has quit (Changing host)

[15:34:16]

Guest28700 (Guest28700!maliutamat@unaffiliated/maliuta) has joined #mythtv

[15:34:17]

Guest28700 (Guest28700!maliutamat@gateway/shell/matrix.org/x-biuexaonfrrseetq) has joined #mythtv

[15:34:17]

Guest28700 (Guest28700!maliutamat@unaffiliated/maliuta) has quit (Changing host)

[15:35:20]

peterbennett:

stuarta: host represents the backend where the artwork is stored, which could be the master backend or a slave backend.

[15:36:46]

peterbennett:

Oops – I used those terrible words master and slave. There was an article recently that criticized the computer industry for the use of those words.

[15:42:47]

stuarta:

tbh. i'm of the opinion that artwork/channelicons etc should be stored on the master backend

[15:44:56]

stuarta:

that way a client, whether it be a frontend, and app etc, can just pull the required data from the backend

[17:07:22]

Steve-Goodey (Steve-Goodey!~steve@2a00:23c5:7d83:6501:6032:9caa:16d4:6ffa) has joined #mythtv

[17:07:22]

Mode for #mythtv by ChanServ!ChanServ@services. : +v Steve-Goodey

[17:34:41]

jpabq_ (jpabq_!~quassel@mythtv/developer/jpabq) has quit (Ping timeout: 244 seconds)

[17:56:12]

markk_ (markk_!~mark@host86-172-134-200.range86-172.btcentralplus.com) has joined #mythtv

[18:17:52]

markk_ (markk_!~mark@host86-172-134-200.range86-172.btcentralplus.com) has quit (Quit: Konversation terminated!)

[18:32:58]

jpabq (jpabq!~quassel@mythtv/developer/jpabq) has joined #mythtv

[18:32:59]

Mode for #mythtv by ChanServ!ChanServ@services. : +v jpabq

[19:09:07]

jpabq:

Decisions, Decisions. I have been a "RedHat" user for 25 years. CentOS and Debian are too restrictive. Fedora's life cycle it too short. I guess that means Ubuntu LTS?

[19:40:45]

jheizer2:

ubuntu LTS for me is the nice middle ground of moving forward but not too fast. And if you need something newer someone always has a PPA for it.

[19:51:51]

jpabq:

My main production machine is currently on Fedora 30, so the OS is at the end of its support. Always a little scary to upgrade the main mythbackend machine.

[19:52:52]

kwizart:

jpabq, fedora for multimedia "production" server isn't that difficult to maintain

[19:54:18]

kwizart:

jpabq, there is some eiffor to have a mythtv package for CentOS8, but isn't available still

[19:58:57]

jpabq:

kwizart: It seems that every time I do a Fedora OS upgrade, something breaks. The last time, mythfrontend refused to start in Mate and I had to switch to LX. For YEARS I have battled with networking issues under Fedora. My motherboard has two NICs and it is rare for both to be available after a reboot. Sometimes neither is available. That got old a LONG time ago. I don't know if Ubuntu will be any better, but I think it is time to try it.

[20:00:34]

kwizart:

jpabq, weird, no issue from my side (even using two NIC, but then I'm using gdm/gnome for desktop)

[20:03:53]

Steve-Goodey (Steve-Goodey!~steve@2a00:23c5:7d83:6501:6032:9caa:16d4:6ffa) has quit (Quit: Konversation terminated!)

[20:07:46]

markk_ (markk_!~mark@host86-172-134-200.range86-172.btcentralplus.com) has joined #mythtv

[20:12:15]

peper03_ (peper03_!~peper03@mythtv/developer/peper03) has joined #mythtv

[20:12:15]

Mode for #mythtv by ChanServ!ChanServ@services. : +v peper03_

[20:12:55]

blahdodo_ (blahdodo_!~blahdodo@69.172.190.84) has joined #mythtv

[20:18:54]

blahdodo (blahdodo!~blahdodo@69.172.190.84) has quit (*.net *.split)

[20:18:54]

peper03 (peper03!~peper03@mythtv/developer/peper03) has quit (*.net *.split)

[20:18:54]

pppingme (pppingme!~pppingme@unaffiliated/pppingme) has quit (*.net *.split)

[20:18:55]

poptix (poptix!poptix@poptix.net) has quit (*.net *.split)

[20:23:51]

pppingme (pppingme!~pppingme@unaffiliated/pppingme) has joined #mythtv

[20:24:13]

poptix (poptix!poptix@poptix.net) has joined #mythtv

[20:34:11]

jpabq:

kwizart: I was able to alleviate that issue (to a point) by switching from NetworkManager to systemd-network. However, I am now getting message that systemd-netword is depricated and that I need to switch back to NetworkManager. I sure hope it has been improved since then. Even under systemd-network it would happen occationally, but with NetworkManger it failed to bring up at least one NIC every time.

[20:48:07]

hampton:

markk_: I just tried compiling the vulkan code and I get lots of 'VkDevice has not been declared' errors, etc. I do have the vulkan-headers rpm installed, but I don't see where vulcan_core.h is included (except in configure).

[20:53:34]

markk_:

hampton: on my install at least – vulcan_core.h seems to arrive (indirectly) via #include <QVulkanDeviceFunctions> in mythrendervulkan. does it work if you add that directly to mythrendervulkan.h?

[20:58:10]

hampton:

Did you add vulkan to the qt config?

[21:04:31]

hampton:

I see "#if QT_CONFIG(vulkan)" at the top of qvulcanfunctions.h just before it includes vulkan/vulknan.h, but when I try adding "vulkan" to the QT config in libmythui.pro I get "Unknown module(s) in QT: vulkan".

[21:07:44]

hampton:

There's an open bug against Fedora about qt not having been compiled with vulkan support. I'll have to see if I enabled it when I build qt5.15 locally.

[21:11:13]

SteveGoodey (SteveGoodey!~steve@host86-145-34-0.range86-145.btcentralplus.com) has quit (Quit: Konversation terminated!)

[21:12:27]

Warped_ (Warped_!~Warped@108.85.160.119) has joined #mythtv

[21:12:28]

Warped (Warped!~Warped@unaffiliated/warped) has quit (Ping timeout: 272 seconds)

[21:14:28]

Warped_ (Warped_!~Warped@108.85.160.119) has quit (Client Quit)

[21:19:07]

jpabq:

markk_: I have implemented enough of https://www.itu.int/rec/T-REC-H.265-201911-I/en to extract the video resolution, video scan type, aspect ratio and (of course) frame and keyframe byte offsets.

[21:23:10]

markk_ (markk_!~mark@host86-172-134-200.range86-172.btcentralplus.com) has quit (Ping timeout: 246 seconds)

[21:44:42]

markk_ (markk_!~mark@host86-172-134-200.range86-172.btcentralplus.com) has joined #mythtv

[21:49:34]

markk_:

hampton: adding QT += vulkan doesn't work here either. Looking at the qt docs again – it looks like I'll have to add an additional check to ensure Qt actually has vulkan configured (https://doc.qt.io/qt-5/qvulkaninstance.html#details). presumably that is failing for you.

[21:50:17]

markk_:

jpabq: cool – did you base it off the h264 parser?

[21:50:23]

markk_:

bedtime:)

[21:50:55]

jpabq:

markk_: Paritially. I ended up crafting a base class that h264 and h265 inherit from.

[22:08:15]

RokLobsta (RokLobsta!~Dirkka@121-200-12-5.79c80c.mel.nbn.aussiebb.net) has joined #mythtv

[22:14:54]

markk_ (markk_!~mark@host86-172-134-200.range86-172.btcentralplus.com) has quit (Ping timeout: 240 seconds)

[23:21:48]

Warped (Warped!~Warped@unaffiliated/warped) has joined #mythtv

[23:28:24]

RokLobsta (RokLobsta!~Dirkka@121-200-12-5.79c80c.mel.nbn.aussiebb.net) has quit (Quit: Leaving)

[23:59:28]

markspieth (markspieth!~yaaic@mythtv/developer/markspieth) has joined #mythtv

[23:59:28]

Mode for #mythtv by ChanServ!ChanServ@services. : +v markspieth

MythLogBot@irc.freenode.net :: #mythtv

Current users (52):