Monday, November 10th, 2014, 00:17 UTC | ||
[00:17:09] | arescorpio (arescorpio!~arescorpi@227-206-17-190.fibertel.com.ar) has joined #mythtv | |
[01:35:34] | len_ (len_!~quassel@75-168-45-25.mpls.qwest.net) has joined #mythtv | |
[01:45:07] | jya: | stuartm: I dont recall changing anything on mythtranscode between 0.27.3 and 0.27.4 :( |
[03:07:44] | rich0_ is now known as rich0 | |
[04:01:05] | peper03 (peper03!~peper03@mythtv/developer/peper03) has quit (Ping timeout: 258 seconds) | |
[04:05:59] | peper03 (peper03!~peper03@mythtv/developer/peper03) has joined #mythtv | |
[04:22:41] | arescorpio (arescorpio!~arescorpi@227-206-17-190.fibertel.com.ar) has quit (Excess Flood) | |
[04:42:30] | fetzerch_ (fetzerch_!~quassel@unaffiliated/fetzerch) has joined #mythtv | |
[04:46:36] | fetzerch (fetzerch!~quassel@unaffiliated/fetzerch) has quit (Ping timeout: 264 seconds) | |
[05:34:37] | len_ (len_!~quassel@75-168-45-25.mpls.qwest.net) has quit (Read error: Connection reset by peer) | |
[05:37:55] | len_ (len_!~quassel@75-168-45-25.mpls.qwest.net) has joined #mythtv | |
[05:47:50] | Roklobsta (Roklobsta!~Roklobsta@ppp118-209-111-219.lns20.mel4.internode.on.net) has joined #mythtv | |
[06:46:23] | bill6502 (bill6502!~bill@205.178.26.43) has left #mythtv () | |
[07:07:49] | Tobbe5178 (Tobbe5178!~asdf@2001:2002:d9d4:ce1d:8055:b710:2df0:b293) has joined #mythtv | |
[07:59:53] | Tobbe5178 (Tobbe5178!~asdf@2001:2002:d9d4:ce1d:8055:b710:2df0:b293) has quit (Ping timeout: 244 seconds) | |
[08:31:37] | joki (joki!~joki@p5486239A.dip0.t-ipconnect.de) has quit (Ping timeout: 244 seconds) | |
[08:36:44] | joki (joki!~joki@p548621A5.dip0.t-ipconnect.de) has joined #mythtv | |
[09:13:10] | stuarta: | morning all |
[09:15:42] | stuarta: | stuartm: mysql issues resolved? |
[09:36:13] | stuartm: | jya: neither do I, I suspect what changed was in the broadcast and it's just coincidence that the user upgraded at the same time |
[09:38:09] | stuartm: | stuarta: still getting errors from the wiki |
[09:43:13] | stuarta: | that's weird |
[09:43:16] | stuartm: | https://www.mythtv.org/wiki/Schedules_Direct_URL_Change |
[09:43:42] | stuarta: | that loaded fine for me |
[09:43:57] | ** stuarta fires up a window to watch some logs ** | |
[09:44:17] | stuarta: | may as well do something while my internal case work tracker is down ;( |
[09:45:17] | stuartm: | https://www.mediawiki.org/wiki/Manual:How_to_debug#SQL_errors |
[09:45:46] | stuarta: | can you screenshot the error page you have and send it to me? |
[09:47:10] | stuartm: | 1665 Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED. (localhost) |
[09:47:24] | stuartm: | UPDATE `watchlist` SET wl_notificationtimestamp = NULL WHERE wl_user = '100' AND wl_namespace = '0' AND wl_title = 'Schedules_Direct_URL_Change' |
[09:47:26] | stuarta: | ah right, lemme change that |
[09:48:21] | stuarta: | changed, try now |
[09:48:52] | stuarta: | as part of getting replication to work i'd set BINLOG_FORMAT = STATEMENT, i've now let it use the defaults |
[09:49:23] | stuartm: | still not working, same error |
[09:49:31] | stuarta: | bah, default = statement |
[09:50:15] | stuarta: | try again |
[09:50:47] | stuartm: | working :) |
[09:50:56] | stuarta: | why do we have that transaction isolation setting.... hmm..... |
[09:53:04] | stuarta: | right. ffs, it's bloody atlassian crowd that wants read-committed |
[09:53:07] | ** stuarta fiddles ** | |
[09:53:22] | stuarta: | yep, that binlog setting breaks replication |
[09:53:36] | stuarta: | ffs. now i have to dump and restore the tables again |
[09:54:24] | stuarta: | grr |
[09:54:59] | stuarta: | right, so we are back to binlog_format = statement, but we no longer have read committed transaction isolation level |
[09:55:05] | dekarl1 (dekarl1!~dekarl@p4FCEF7A5.dip0.t-ipconnect.de) has joined #mythtv | |
[09:56:03] | stuartm: | no errors so far |
[09:56:36] | stuarta: | should work, it was actually the transaction isolation level that was the root of the problem |
[09:57:41] | dekarl (dekarl!~dekarl@p4FCEE8BB.dip0.t-ipconnect.de) has quit (Ping timeout: 244 seconds) | |
[09:57:57] | stuarta: | oh well, at least i've got the dump and restore down to a fine art nw |
[09:57:59] | stuarta: | *now |
[10:03:23] | stuartm: | did you stop httpd? |
[10:04:03] | stuarta: | no |
[10:04:44] | stuarta: | it may have done something itself "zend_mm_heap corrupted" |
[10:05:08] | stuarta: | several times, at which point you appear to have restarted it |
[10:06:14] | stuarta: | right, that's replication fixed on mizar again. so we have DB's in sync |
[10:07:38] | stuartm: | it's been a week now without spam, of course the wiki was broken for 4 of those days so it's probably a bit early to call it |
[10:08:08] | stuarta: | haha |
[10:08:23] | stuarta: | what did you change? adding those extra block lists? |
[10:11:56] | stuartm: | extra block lists, and actually enabling the StopForumSpam extension |
[10:12:39] | stuartm: | that relies on a local copy of the IP blacklist btw, the recommendation is that you setup a cron job to periodically download an updated copy so I've still got that to look forward to |
[10:15:45] | sraue (sraue!~stephan@xbmc/staff/sraue) has quit (Ping timeout: 260 seconds) | |
[10:20:56] | len_ (len_!~quassel@75-168-45-25.mpls.qwest.net) has quit (Remote host closed the connection) | |
[10:26:50] | stuarta: | stuartm: lets add that to the todo list for moving to mizar |
[10:27:26] | stuarta: | i was also thinking of putting zbblock in a shared location so we can use it across all the sites |
[10:33:53] | sraue (sraue!~stephan@xbmc/staff/sraue) has joined #mythtv | |
[10:37:16] | sraue (sraue!~stephan@xbmc/staff/sraue) has quit (Excess Flood) | |
[10:37:33] | sraue (sraue!~stephan@xbmc/staff/sraue) has joined #mythtv | |
[11:53:29] | Roklobsta (Roklobsta!~Roklobsta@ppp118-209-111-219.lns20.mel4.internode.on.net) has quit (Quit: KVIrc 4.2.0 Equilibrium http://www.kvirc.net/) | |
[13:11:46] | skd5aner (skd5aner!~skd5aner@231.sub-70-198-68.myvzw.com) has quit (Ping timeout: 265 seconds) | |
[13:12:12] | skd5aner (skd5aner!~skd5aner@231.sub-70-198-68.myvzw.com) has joined #mythtv | |
[13:25:39] | sheedy-away is now known as sheedy | |
[13:39:06] | Jordack (Jordack!~Jordack@75-151-31-172-Michigan.hfc.comcastbusiness.net) has joined #mythtv | |
[14:33:07] | paul-h (paul-h!~Paul@90.204.194.59) has joined #mythtv | |
[14:35:55] | paul-h: | tgm4883: re: #12003 – it looks like that should be 00x00 not ##x## |
[14:35:55] | ** MythLogBot http://code.mythtv.org/trac/ticket/12003 ** | |
[14:36:44] | paul-h: | That's the same on 0.27-fixes as well as master |
[14:38:33] | tgm4883: | I can test that, if that is the case someone should update the theme guide |
[14:39:54] | paul-h: | I looked for that in the theme guide but the only reference I found has 00x00 |
[14:40:36] | paul-h: | https://www.mythtv.org/wiki/Recordings-ui.xml . . . most_windows |
[14:41:48] | paul-h: | It could have been updated since that ticket was opened though – can't be arsed looking at the history :) |
[14:49:33] | paul-h: | tgm4883: Ah was you talking about the recordings screens or the MythVideo screens? |
[14:50:53] | tgm4883: | I believe myth video |
[14:52:25] | paul-h: | OK that does use a different format to confuse things |
[15:07:45] | paul-h (paul-h!~Paul@90.204.194.59) has quit (Quit: Konversation terminated!) | |
[15:56:05] | paul-h (paul-h!~Paul@90.204.194.59) has joined #mythtv | |
[15:57:29] | paul-h: | stuartm: do you want me to commit Rogers patches? |
[15:58:54] | paul-h: | They made a big difference in the limited testing I did |
[16:13:39] | moparisthebest (moparisthebest!~quassel@unaffiliated/moparisthebest) has quit (Ping timeout: 272 seconds) | |
[16:17:20] | moparisthebest (moparisthebest!~quassel@gateway/tor-sasl/moparisthebest) has joined #mythtv | |
[16:27:16] | sraue (sraue!~stephan@xbmc/staff/sraue) has quit (Quit: Ex-Chat) | |
[16:27:28] | jwhite_ is now known as jwhite | |
[16:38:46] | sraue (sraue!~stephan@xbmc/staff/sraue) has joined #mythtv | |
[16:39:33] | Tobbe5178 (Tobbe5178!~asdf@2001:2002:d9d4:ce1d:a0b4:d847:c133:ccd9) has joined #mythtv | |
[16:46:43] | skd5aner (skd5aner!~skd5aner@231.sub-70-198-68.myvzw.com) has quit (Ping timeout: 250 seconds) | |
[16:47:49] | skd5aner (skd5aner!~skd5aner@21.sub-70-198-68.myvzw.com) has joined #mythtv | |
[17:03:55] | SteveGoodey (SteveGoodey!~steve@host217-42-217-49.range217-42.btcentralplus.com) has joined #mythtv | |
[17:18:02] | stuarta: | hurrah, now i understand how the mailman archives hang together |
[17:27:56] | stuarta: | it's like the mailman authors decided they couldn't be arsed writing a web index for the archives, and just got the apache authors todo it |
[17:28:15] | stuarta: | it works by "apache magic" :) |
[17:29:02] | ** stuarta wanders off for a while ** | |
[17:34:00] | toeb (toeb!~toeb@HSI-KBW-109-192-061-138.hsi6.kabel-badenwuerttemberg.de) has joined #mythtv | |
[17:59:24] | stuartm: | paul-h: yeah, they looked good |
[18:00:35] | sheedy is now known as sheedy-away | |
[18:29:09] | gregL (gregL!~greg@cpe-74-76-121-109.nycap.res.rr.com) has joined #mythtv | |
[18:56:00] | gregL (gregL!~greg@cpe-74-76-121-109.nycap.res.rr.com) has quit (Remote host closed the connection) | |
[19:22:12] | wagnerrp (wagnerrp!~wagnerrp_@mythtv/developer/wagnerrp) has quit (Read error: Connection timed out) | |
[19:46:29] | rsiebert (rsiebert!~quassel@g226056167.adsl.alicedsl.de) has joined #mythtv | |
[19:49:47] | rsiebert_ (rsiebert_!~quassel@f052171105.adsl.alicedsl.de) has quit (Ping timeout: 244 seconds) | |
[20:18:52] | pvr4me (pvr4me!~pvrme@184.151.190.138) has joined #mythtv | |
[20:26:13] | pvr4me (pvr4me!~pvrme@184.151.190.138) has quit (Ping timeout: 264 seconds) | |
[20:27:07] | Roklobsta (Roklobsta!~Roklobsta@ppp118-209-111-219.lns20.mel4.internode.on.net) has joined #mythtv | |
[20:27:15] | andreaz (andreaz!~andre_000@p5DD1596C.dip0.t-ipconnect.de) has joined #mythtv | |
[21:23:05] | wagnerrp (wagnerrp!~wagnerrp_@mythtv/developer/wagnerrp) has joined #mythtv | |
[21:33:31] | len_ (len_!~quassel@75-168-45-25.mpls.qwest.net) has joined #mythtv | |
[21:36:40] | reipr (reipr!~reipr@unaffiliated/underdawg) has joined #mythtv | |
[21:36:40] | reipr (reipr!~reipr@unaffiliated/underdawg) has left #mythtv () | |
[21:39:05] | reipr (reipr!~reipr@unaffiliated/underdawg) has joined #mythtv | |
[21:39:10] | reipr: | hullo |
[21:39:51] | reipr: | worng channel. |
[21:39:52] | reipr (reipr!~reipr@unaffiliated/underdawg) has left #mythtv () | |
[21:50:56] | Jordack (Jordack!~Jordack@75-151-31-172-Michigan.hfc.comcastbusiness.net) has quit () | |
[21:51:32] | SteveGoodey (SteveGoodey!~steve@host217-42-217-49.range217-42.btcentralplus.com) has quit (Quit: Konversation terminated!) | |
[22:17:31] | paul-h: | wagnerrp: does the patch on #12260 look OK – If you give me the nod I will commit it if you are busy |
[22:17:31] | ** MythLogBot http://code.mythtv.org/trac/ticket/12260 ** | |
[22:28:18] | stuarta: | oops bounced a commit message :( |
[22:30:17] | stuarta: | well a message to mythtv-commits |
[22:32:58] | stuarta: | ah good, it worked that time |
[23:12:47] | paul-h: | gigem: is there a problem with #12267 – it seems a simple patch |
[23:12:47] | ** MythLogBot http://code.mythtv.org/trac/ticket/12267 ** | |
[23:16:09] | paul-h: | dekarl1: can #11978 be closed? – looks like you committed the patch already |
[23:16:09] | ** MythLogBot http://code.mythtv.org/trac/ticket/11978 ** | |
[23:20:54] | Tobbe5178 (Tobbe5178!~asdf@2001:2002:d9d4:ce1d:a0b4:d847:c133:ccd9) has quit (Read error: Connection reset by peer) | |
[23:43:21] | paul-h (paul-h!~Paul@90.204.194.59) has quit (Quit: Konversation terminated!) |
IRC Logs collected by
BeirdoBot.
Please use the above link to report any bugs.