| Wednesday, September 7th, 2016, 00:28 UTC | ||
| [00:28:04] | amessina (amessina!~amessina@unaffiliated/amessina) has joined #mythtv | |
| [01:32:03] | dmfrey: | dekarl: yes, that sounds exactly like what I am looking for |
| [01:57:31] | dblain_ (dblain_!~dblain@mythtv/developer/dblain) has joined #mythtv | |
| [01:57:31] | dblain (dblain!~dblain@mythtv/developer/dblain) has quit (Read error: Connection reset by peer) | |
| [02:16:20] | Roklobster (Roklobster!~Dirkka@ppp118-209-38-96.lns20.mel4.internode.on.net) has quit (Ping timeout: 250 seconds) | |
| [02:24:47] | arescorpio (arescorpio!~arescorpi@154-58-245-190.fibertel.com.ar) has joined #mythtv | |
| [03:25:51] | knightr (knightr!~knightr@mythtv/developer/knightr) has quit (Read error: Connection reset by peer) | |
| [03:26:13] | knightr (knightr!~knightr@69-165-170-178.dsl.teksavvy.com) has joined #mythtv | |
| [03:26:13] | knightr (knightr!~knightr@69-165-170-178.dsl.teksavvy.com) has quit (Changing host) | |
| [03:26:13] | knightr (knightr!~knightr@mythtv/developer/knightr) has joined #mythtv | |
| [04:15:05] | arescorpio (arescorpio!~arescorpi@154-58-245-190.fibertel.com.ar) has quit (Ping timeout: 244 seconds) | |
| [05:13:11] | amessina (amessina!~amessina@unaffiliated/amessina) has quit (Quit: Konversation terminated!) | |
| [05:13:34] | Roklobster (Roklobster!~Dirkka@ppp118-209-38-96.lns20.mel4.internode.on.net) has joined #mythtv | |
| [05:46:07] | GreyFoxx (GreyFoxx!~greg@out.of.phaze.org) has quit (Ping timeout: 252 seconds) | |
| [05:46:15] | GreyFoxx (GreyFoxx!~greg@out.of.phaze.org) has joined #mythtv | |
| [06:09:12] | Tobbe5178 (Tobbe5178!~asdf@h184n1-sv-a13.ias.bredband.telia.com) has joined #mythtv | |
| [07:08:10] | clever (clever!~clever@nwcsnbsc03w-099192061143.dhcp-dynamic.FibreOp.nb.bellaliant.net) has quit (Ping timeout: 244 seconds) | |
| [07:33:21] | dekarl: | #12871 – mysql's new defaults break optimize_mythdb :( |
| [07:33:21] | ** MythLogBot http://code.mythtv.org/trac/ticket/12871 ** | |
| [07:35:15] | Roklobster: | don't shoot the messenger |
| [07:35:33] | clever (clever!~clever@nwcsnbsc03w-108175080220.dhcp-dynamic.FibreOp.nb.bellaliant.net) has joined #mythtv | |
| [07:50:35] | willcooke (willcooke!~willcooke@ubuntu/member/willcooke) has joined #mythtv | |
| [08:28:57] | stuarta: | dekarl: they've been breaking mythweb for a while, keep getting tickets about it |
| [08:29:41] | stuarta: | i'm very tempted to put in something i saw in one of the tickets that was like "set session <stuff>" which allows you to reset the defaults for that session |
| [08:29:52] | stuarta: | sadly i've forgotten what <stuff> is already |
| [08:35:06] | zz_CyberJacob is now known as CyberJacob | |
| [08:49:34] | dekarl: | stuarta, I was going to fix all that in master by using NULL again, but wanted to make sure why we are avoiding NULL in the first place :/ |
| [08:50:00] | stuarta: | there are some discrepancies in the db schema as well |
| [08:53:38] | Merlin83b (Merlin83b!~Daniel@2a00:1ee0:3:1337:99a:5e22:ea51:c3a) has joined #mythtv | |
| [09:03:03] | stuarta: | iirc, it's between recorded and oldrecorded |
| [09:41:42] | stuarta: | pfft, both seem to have the same issue in master |
| [09:41:52] | stuarta: | inetref is defined as NOT NULL, default NULL |
| [09:42:28] | stuarta: | yet, when you do show create table on them, there are different results |
| [09:43:28] | ** stuarta retracts that last one ** | |
| [09:43:42] | stuarta: | both show create table outputs are the same for inetref |
| [09:45:56] | stuarta: | #12868 for example |
| [09:45:56] | ** MythLogBot http://code.mythtv.org/trac/ticket/12868 ** | |
| [09:55:47] | stuarta: | dblain_: are you able to help me understand why the windows build barfed on the latest commits? |
| [10:01:08] | stuarta: | open.tickets-- |
| [10:14:49] | dekarl1 (dekarl1!~dekarl@mythtv/developer/dekarl) has joined #mythtv | |
| [10:15:33] | dekarl (dekarl!~dekarl@mythtv/developer/dekarl) has quit (Ping timeout: 240 seconds) | |
| [10:38:22] | dekarl1 is now known as dekarl | |
| [10:50:59] | markus_ (markus_!~markus@x55b39521.dyn.telefonica.de) has joined #mythtv | |
| [10:51:28] | markus_: | development channel oh good. Did you guys ever think about improving the setup handling? |
| [10:51:56] | markus_: | the mysql connectivity is a desaster, the dvb setup is another one |
| [10:52:08] | stuarta: | we've thought lots about it ;-) |
| [10:52:25] | stuarta: | that's one of the goals of the webfrontend |
| [10:52:27] | markus_: | if I run plain "mysql" on the console the mysql server won't complain about it :-) |
| [10:52:43] | markus_: | mythtv says it cannot log in (no problem I'll figure out why however it's user unfriendly) |
| [10:52:44] | stuarta: | what's up with mysql connectivity? |
| [10:53:16] | markus_: | better use sqlite instead of mysql if mysql can cause that many issues |
| [10:53:20] | markus_: | mythfrontend segfaults |
| [10:53:29] | markus_: | probably because of no mysql connectivity? |
| [10:54:11] | stuarta: | we fixed the segfault with it not being setup recently |
| [10:54:21] | stuarta: | nothing at all todo with mysql |
| [10:54:41] | markus_: | why isn't it using the local connection of mysql and insisting on using the network connection? |
| [10:54:46] | stuarta: | it was a classname collision in the frontend that was throwing off Qt's signal handling |
| [10:55:14] | markus_: | ERROR 1698 (28000): Access denied for user 'root'@'localhost' |
| [10:55:29] | stuarta: | that's all covered in the setup instructions |
| [10:55:46] | markus_: | I don't see that in mythfilldatabase (no idea why I have to run that command anyway) |
| [10:55:51] | markus_: | get rid of that command... |
| [10:56:28] | markus_: | I did the setup before and set it to english, mythfrontend is again asking for the language setup (probably due the missing db connection?) |
| [10:56:28] | stuarta: | you want to get rid of MFDB? how do you propose to get your guide data then? |
| [10:56:47] | stuarta: | did you install the relevant qt mysql db connector? |
| [10:57:05] | markus_: | just set up the DVB device and done, if it's set to EIT it should just run in the background and done |
| [10:57:30] | stuarta: | if you use EIT you don't need MFDB, other countries do |
| [10:57:58] | stuarta: | they have no useful broadcast program data, and therefore must use an external guide source, which is what MFDB is for |
| [10:59:37] | markus_: | well then don't even ask about running mfdb after the setup |
| [10:59:45] | markus_: | it seems like it's still asking after the setup |
| [11:00:27] | stuarta: | tbh, in the grand scheme of things, mentioning MFDB at the end of setup isn't a big issue |
| [11:00:39] | markus_: | Loading en_us translation for module mythfrontend |
| [11:00:39] | markus_: | Handling Segmentation fault |
| [11:00:40] | markus_: | Segmentation fault (core dumped) |
| [11:00:52] | stuarta: | have you pulled the latest updates? |
| [11:00:58] | markus_: | going to remove it and pulling the latest updates... |
| [11:01:11] | markus_: | but that is what is distributed with the latest ubuntu version it seems |
| [11:01:33] | stuarta: | tgm4883: has the ubuntu build picked up the frontend segfault fix yet? |
| [11:01:43] | ** stuarta goes to lunch ** | |
| [11:05:21] | markus_: | it would be nice if there would be a self contained package available with all libraries and all dependencies included |
| [11:06:00] | markus_: | that would make updates much easier from your side instead of relying on system libraries which are different on every system (which also avoid updating mythtv for several users) |
| [11:16:39] | sphery: | dekarl: as I mentioned on #12871, we can explicitly set the SQL mode we want in our connection code (as was done for a while with code in [dd2d7a14d] ). This could be used to overcome the issues with NO_ZERO_DATE/NO_ZERO_IN_DATE as well as ONLY_FULL_GROUP_BY. In MySQL 5.5, the default SQL mode is empty, in 5.7, it's ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, and ... |
| [11:16:39] | ** MythLogBot http://code.mythtv.org/trac/ticket/12871 ** | |
| [11:16:45] | sphery: | ... NO_ENGINE_SUBSTITUTION |
| [11:17:04] | sphery: | (per https://dev.mysql.com/doc/refman/5.5/en/sql-m . . . mode-changes and https://dev.mysql.com/doc/refman/5.7/en/sql-m . . . mode-changes ) |
| [11:17:22] | Merlin83b (Merlin83b!~Daniel@2a00:1ee0:3:1337:99a:5e22:ea51:c3a) has quit (Quit: Leaving) | |
| [11:21:11] | sphery: | dekarl: As far as "plan for migration" for the recordedfile schema, I don't really have anything comprehensive--it's going to require most changes all at once--but just assumed I would work through the changes in a separate branch until others were OK with switching. Note, though, that I didn't plan to do the InnoDB migration as part of that (I planned for InnoDB migration as part of embedded DB change). |
| [11:27:45] | sphery: | oops, those links were supposed to be without the #sql-mode-changes named anchor... |
| [11:30:32] | dekarl: | hmm, that would help more users then just a custom mythtv-mysql.cnf file for Ubuntu... and can be done to fixes without schema change... |
| [11:31:09] | sphery: | yeah |
| [11:32:59] | sphery: | I don't know if connect_options would work, but if not, it shouldn't be too difficult to put in a SET SESSION sql_mode = ''; somewhere around there |
| [11:37:24] | sphery: | hmmm... |
| [11:38:10] | sphery: | Just noticed: https://github.com/MythTV/mythtv/blob/master/ . . . con.cpp#L261 |
| [11:38:19] | sphery: | seems we're already trying to set the sql_mode... |
| [11:40:08] | sphery: | so that means we just need to do the same for mythweb and perl/python bindings |
| [11:48:27] | sphery: | I guess for perl bindings it would likely be adding the set session sql_mode right about https://github.com/MythTV/mythtv/blob/master/ . . . thTV.pm#L375 |
| [11:54:28] | knightr (knightr!~knightr@mythtv/developer/knightr) has quit (Ping timeout: 255 seconds) | |
| [11:54:57] | knightr (knightr!~knightr@69-165-170-178.dsl.teksavvy.com) has joined #mythtv | |
| [11:54:57] | knightr (knightr!~knightr@69-165-170-178.dsl.teksavvy.com) has quit (Changing host) | |
| [11:54:57] | knightr (knightr!~knightr@mythtv/developer/knightr) has joined #mythtv | |
| [12:11:27] | stuarta: | sphery: that's the magic glue i was looking for |
| [12:23:16] | Roklobster (Roklobster!~Dirkka@ppp118-209-38-96.lns20.mel4.internode.on.net) has quit (Ping timeout: 255 seconds) | |
| [12:32:12] | dblain (dblain!~dblain@mythtv/developer/dblain) has joined #mythtv | |
| [12:34:17] | sphery: | stuarta: Yeah, seems like that would be the best approach since we're using it in the mythtv code. Just need to use it in perl/python bindings and in mythweb. |
| [12:34:41] | stuarta: | would be the quickest way of achieving what we need |
| [12:35:06] | stuarta: | i might have to setup a VM just to be able to reproduce the issue, so I can prove that that fixes the issue |
| [12:35:21] | stuarta: | i spend my life building reproducers |
| [12:35:43] | sphery: | right, and we can always work on making our sql more strict later in all the extra development time we all have |
| [12:36:28] | sphery: | hehe, yeah. between debugging and build slaves and ... you spend a ton of time setting up systems for mythtv :) |
| [12:37:16] | stuarta: | and the day job ;-) |
| [12:40:44] | dblain: | stuarta: just pushed a fix for the msvc build |
| [12:41:15] | stuarta: | dblain: much appreciated |
| [12:46:40] | pppingme (pppingme!~pppingme@unaffiliated/pppingme) has quit (Ping timeout: 264 seconds) | |
| [12:56:38] | dmfrey: | dekarl: sphery: I am very interested in recorded schema change. Specifically, the api around that change should be considered up front as well |
| [13:01:30] | pppingme (pppingme!~pppingme@unaffiliated/pppingme) has joined #mythtv | |
| [13:08:30] | MythBuild: | build #56 of master-windows-msvc-64bit is complete: Success [3build successful] Build details are at http://code.mythtv.org/buildbot/builders/mast . . . it/builds/56 |
| [13:10:48] | dekarl: | I see there already have been some schema changes in master, so time to look at putting recordedid to use and reduce the size of our biggest tables a lot :) (should recordedseek refer to recordedfile or recorded?) |
| [13:12:08] | dekarl: | right now, with 1:1 mapping between recorded and recordedfile, its easy. but imho the seektable is a feature of the actual file with byte offsets... |
| [13:12:52] | ** stuarta hands dekarl the broom of DB schema cleaning ** | |
| [13:13:13] | stuarta: | not to mention switching to innodb tables by default |
| [13:13:30] | dekarl: | every time I look at small incremental steps it turns into a can of worms :( |
| [13:13:31] | dekarl: | aye |
| [13:13:47] | stuarta: | that happens to me no matter what i look at |
| [13:14:01] | dekarl: | switching to innodb once we have good keys in place is on TheList |
| [13:14:07] | tgm4883: | stuarta: what default fix? |
| [13:14:07] | stuarta: | i'm dreading even starting on converting dvb to use the dvbv5 api |
| [13:14:15] | tgm4883: | Segfault |
| [13:15:04] | stuarta: | d9182ff1b3efdcad978eee6cc42e28e09ab3e0cd <- that commit |
| [13:15:22] | pppingme (pppingme!~pppingme@unaffiliated/pppingme) has quit (Ping timeout: 244 seconds) | |
| [13:15:30] | stuarta: | Date: Mon Aug 22 23:26:00 2016 +0100 |
| [13:15:42] | stuarta: | i would have assumed you had a newer build than that for 0.28? |
| [13:16:25] | tgm4883: | stuarta: the build we have is on September 5th |
| [13:16:33] | tgm4883: | So yes |
| [13:20:14] | stuarta: | excellent thanks |
| [13:21:50] | willcooke (willcooke!~willcooke@ubuntu/member/willcooke) has quit (Quit: Do your hobbies) | |
| [13:22:05] | willcooke (willcooke!~willcooke@ubuntu/member/willcooke) has joined #mythtv | |
| [13:23:02] | dmfrey: | sphery: in that new schema for videos, i didn't see anything for marking a video as VIDEO, TV, HOMEMOVIE, MUSIC_VIDEO, or ADULT. is that something else now in the schema, or no present anymore? |
| [14:01:25] | pppingme (pppingme!~pppingme@unaffiliated/pppingme) has joined #mythtv | |
| [14:19:24] | scilib (scilib!~libsci@unaffiliated/libsci) has joined #mythtv | |
| [14:20:34] | libsci (libsci!~libsci@unaffiliated/libsci) has quit (*.net *.split) | |
| [14:20:35] | poptix (poptix!poptix@poptix.net) has quit (*.net *.split) | |
| [14:20:35] | coling (coling!~colin@cpc105064-sgyl40-2-0-cust843.18-2.cable.virginm.net) has quit (*.net *.split) | |
| [14:36:38] | knightr_ (knightr_!~knightr@69-165-170-178.dsl.teksavvy.com) has joined #mythtv | |
| [14:36:38] | knightr (knightr!~knightr@mythtv/developer/knightr) has quit (Read error: Connection reset by peer) | |
| [14:36:38] | knightr_ (knightr_!~knightr@69-165-170-178.dsl.teksavvy.com) has quit (Changing host) | |
| [14:36:38] | knightr_ (knightr_!~knightr@mythtv/developer/knightr) has joined #mythtv | |
| [14:41:07] | wagner__ (wagner__!~wagnerrp_@72.49.22.224) has quit (Ping timeout: 250 seconds) | |
| [14:42:12] | poptix (poptix!poptix@poptix.net) has joined #mythtv | |
| [14:42:12] | coling (coling!~colin@cpc105064-sgyl40-2-0-cust843.18-2.cable.virginm.net) has joined #mythtv | |
| [14:55:28] | amessina (amessina!~amessina@unaffiliated/amessina) has joined #mythtv | |
| [15:18:59] | rich0_ (rich0_!~quassel@gentoo/developer/rich0) has joined #mythtv | |
| [15:22:44] | superm1 (superm1!uid4318@ubuntu/member/superm1) has joined #mythtv | |
| [15:23:22] | rich0 (rich0!~quassel@gentoo/developer/rich0) has quit (Ping timeout: 265 seconds) | |
| [15:28:33] | rich0 (rich0!~quassel@gentoo/developer/rich0) has joined #mythtv | |
| [15:32:32] | rich0_ (rich0_!~quassel@gentoo/developer/rich0) has quit (Ping timeout: 240 seconds) | |
| [16:00:14] | markus__ (markus__!55b39521@gateway/web/freenode/ip.85.179.149.33) has joined #mythtv | |
| [16:01:57] | markus__ (markus__!55b39521@gateway/web/freenode/ip.85.179.149.33) has quit (Client Quit) | |
| [16:22:24] | pppingme (pppingme!~pppingme@unaffiliated/pppingme) has quit (Ping timeout: 276 seconds) | |
| [16:30:59] | pppingme (pppingme!~pppingme@unaffiliated/pppingme) has joined #mythtv | |
| [17:08:14] | willcooke (willcooke!~willcooke@ubuntu/member/willcooke) has quit (Quit: Do your hobbies) | |
| [17:21:50] | SteveGoodey (SteveGoodey!~steve@81.141.240.53) has joined #mythtv | |
| [17:47:12] | SteveGoodey (SteveGoodey!~steve@81.141.240.53) has quit (Ping timeout: 240 seconds) | |
| [17:47:20] | SteveGoodey (SteveGoodey!~steve@81.141.240.53) has joined #mythtv | |
| [18:40:33] | jams (jams!~jams@cpe-173-89-45-47.wi.res.rr.com) has joined #mythtv | |
| [18:58:14] | amessina (amessina!~amessina@unaffiliated/amessina) has quit (Remote host closed the connection) | |
| [19:00:53] | amessina (amessina!~amessina@unaffiliated/amessina) has joined #mythtv | |
| [19:24:37] | gregl (gregl!~greg@cpe-66-67-122-101.nycap.res.rr.com) has quit (Quit: Leaving) | |
| [19:24:58] | gregl (gregl!~greg@cpe-66-67-122-101.nycap.res.rr.com) has joined #mythtv | |
| [20:26:41] | Roklobster (Roklobster!~Dirkka@ppp118-209-38-96.lns20.mel4.internode.on.net) has joined #mythtv | |
| [20:49:58] | lautriv_ (lautriv_!~lautriv@funtoo/user/lautriv) has quit (Ping timeout: 250 seconds) | |
| [20:54:29] | SteveGoodey (SteveGoodey!~steve@81.141.240.53) has quit (Quit: Konversation terminated!) | |
| [21:02:53] | lautriv_ (lautriv_!~lautriv@x4e32557a.dyn.telefonica.de) has joined #mythtv | |
| [21:02:53] | lautriv_ (lautriv_!~lautriv@funtoo/user/lautriv) has joined #mythtv | |
| [21:02:53] | lautriv_ (lautriv_!~lautriv@x4e32557a.dyn.telefonica.de) has quit (Changing host) | |
| [21:47:35] | jst (jst!~quassel@198.199.94.175) has quit (Quit: No Ping reply in 180 seconds.) | |
| [21:49:13] | jst (jst!~quassel@email.jstenback.com) has joined #mythtv | |
| [22:04:00] | Tobbe5178 (Tobbe5178!~asdf@h184n1-sv-a13.ias.bredband.telia.com) has quit (Read error: Connection reset by peer) | |
| [22:27:46] | lapion (lapion!~axion@axion.xs4all.nl) has joined #mythtv | |
| [22:37:09] | rich0_ (rich0_!~quassel@gentoo/developer/rich0) has joined #mythtv | |
| [22:41:18] | rich0 (rich0!~quassel@gentoo/developer/rich0) has quit (Ping timeout: 244 seconds) | |
| [22:43:15] | rich0 (rich0!~quassel@gentoo/developer/rich0) has joined #mythtv | |
| [22:47:30] | rich0_ (rich0_!~quassel@gentoo/developer/rich0) has quit (Ping timeout: 244 seconds) | |
| [22:53:08] | wagnerrp (wagnerrp!~wagnerrp_@mythtv/developer/wagnerrp) has joined #mythtv | |
| [23:57:59] | markus__ (markus__!~markus@x55b390a2.dyn.telefonica.de) has joined #mythtv | |
IRC Logs collected by
BeirdoBot.
Please use the above link to report any bugs.