110100 2005-10-21 22:37 0000 mythtv / mythfilldatabase fails with mysql-5 2006-03-09 22:28:26 0000 1 1 1 Unclassified Gentoo Linux Applications unspecified All Linux RESOLVED FIXED P2 normal --- 1 hwertz@avalon.net media-tv@gentoo.org dan.dickey@savvis.net gentoo@kormoc.com stevenrwalter@gmail.com hwertz@avalon.net 2005-10-21 22:37:35 0000 I recently updated from mysql-4.1.14 to mysql-5.0.13_rc. I ran revdep-rebuild, and rebuild qt. The rest of mythtv seems to work ok, but mythfilldatabase gives lots of various errors like: DB Error (Inserting into dd_schedule): Query was: INSERT INTO dd_schedule (programid,stationid,scheduletime,duration,repeat,stereo,subtitled,hdtv,closecaptioned,tvrating,partnumber,parttotal,endtime) VALUES('SH0000010000','15673','2005-10-23T06:00:00','00:30:00',0,0,0,0,0,NULL,0,0,'2005-10-23T06:30:00'); Driver error was [2/1064]: QMYSQL3: Unable to execute query Database error was: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'repeat,stereo,subtitled,hdtv,closecaptioned,tvrating,partnumber,parttotal,endtim' at line 1 Reproducible: Always Steps to Reproduce: 1. Upgrade to mysql-5.x 2. run mythfilldatabase Actual Results: SQL errors. The TV guide in mythtv gradually gets more and more "Unknown" entries as the data already in the database becomes out of date, and after a while mythtv no longer records shows, since there's no more guide info. Expected Results: mythfilldatabase fills the database, and mythtv is all shiny and happy. A solution is below.. but first, some emerge info.. Builds fly on this setup.. distcc is running between this XP 2200+, a Sempron 2500+, and an XP 2100+.: Portage 2.0.53_rc6 (default-linux/x86/2005.0, gcc-3.4.4, glibc-2.3.5-r2, 2.6.13-gentoo-r1 i686) ================================================================= System uname: 2.6.13-gentoo-r1 i686 AMD Athlon(tm) XP 2200+ Gentoo Base System version 1.12.0_pre9 distcc 2.18.3 i686-pc-linux-gnu (protocols 1 and 2) (default port 3632) [enabled] dev-lang/python: 2.4.2 sys-apps/sandbox: 1.2.13 sys-devel/autoconf: 2.13, 2.59-r7 sys-devel/automake: 1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r1 sys-devel/binutils: 2.16.1 sys-devel/libtool: 1.5.20 virtual/os-headers: 2.6.11-r2 ACCEPT_KEYWORDS="x86 ~x86" AUTOCLEAN="yes" CBUILD="i686-pc-linux-gnu" CFLAGS="-O2 -march=athlon-xp -fomit-frame-pointer" CHOST="i686-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/kde/2/share/config /usr/kde/3.4/env /usr/kde/3.4/share/config /usr/kde/3.4/shutdown /usr/kde/3/share/config /usr/lib/X11/xkb /usr/lib/mozilla/defaults/pref /usr/share/config /var/qmail/control" CONFIG_PROTECT_MASK="/etc/gconf /etc/terminfo /etc/env.d" CXXFLAGS="-O2 -march=athlon-xp -fomit-frame-pointer" DISTDIR="/usr/portage/distfiles" FEATURES="autoconfig distcc distlocks fixpackages sandbox sfperms strict" GENTOO_MIRRORS="http://gentoo.mirrors.tds.net/gentoo" MAKEOPTS="-j5" PKGDIR="/usr/portage/packages" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" PORTDIR_OVERLAY="/usr/local/portage" SYNC="rsync://rsync.us.gentoo.org/gentoo-portage" USE="x86 3dnow 3dnowext X a52 aac alsa apm arts avi berkdb bitmap-fonts browserplugin cdr cjk crypt cups curl dv dvd dvdr dvdread eds emboss encode esd fam fame ffmpeg flac foomaticdb fortran gdbm gif gimpprint gnome gpm gstreamer gtk gtk2 guile imagemagick imlib insecure-savers ipv6 java jpeg junit kde libg++ libwww mad matroska mikmod mjpeg mmx motif mozilla mp3 mpeg mppe-mppc mysql mythtv nas ncurses nls nptl nsplugin nvidia offensive ogg oggvorbis opengl oss pam pdflib perl pic plugin png ppds python qt quicktime readline samba scanner sdl slang spell sse ssl subtitles tcltk tcpd threads tiff truetype truetype-fonts type1-fonts udev usb v4l v4l2 vorbis win32codecs xanim xine xml2 xmms xv xvid zlib userland_GNU kernel_linux elibc_glibc" Unset: ASFLAGS, CTARGET, LANG, LC_ALL, LDFLAGS, LINGUAS Please see this URL: http://www.gossamer-threads.com/lists/mythtv/users/131121?do=post_view_flat#131121 In short, "repeat" is a reserved word in mysql-5, but the mythtv Datadirect source uses repeat as a table entry. This post, courtesy of mickc at whizardries , suggests quoting instances of repeat in SQL queries with `` characters. I suspect although mysql-4 doesn't need this change, that it will be compatible with mysql-4 as well. I just built a copy of mythtv with this change, and unlike mickc I'm getting no warnings/errors at all.. it works smoothly. I haven't checked out mythtv-cvs to see if this change is already in there. hwertz@avalon.net 2005-10-21 22:42:53 0000 Created an attachment (id=71157) This implements the patch I described, quoting repeat in queries. vivo@gentoo.org 2005-10-22 15:48:10 0000 no knowledge of this package but: "repeat" is a reserved word, the query should be written as INSERT INTO dd_schedule (`programid`,`stationid`,`scheduletime`,`duration`,`repeat` ... or the field `repeat` renamed cheers carlo@gentoo.org 2005-10-27 05:34:09 0000 *** Bug 110584 has been marked as a duplicate of this bug. *** gentoo@kormoc.com 2005-10-27 08:05:32 0000 myth svn has renamed the field to isrepeat last night. Should likly modify the patch to be the same. cardoe@gentoo.org 2005-10-27 11:35:48 0000 So here's the issue. If we fix this and use the patch, then when the next version is released the updating of the database schema will fail and everyone will have to rebuild their database from scratch. And it's not like I can just comment out that update because then it'll break new installs and people who didn't emerge the fix. So there's a big catch 22 here. cardoe@gentoo.org 2005-10-27 13:40:54 0000 I guess I could just do the fix Francesco mentioned for 0.18.1 jakub@gentoo.org 2005-11-07 04:46:29 0000 *** Bug 111772 has been marked as a duplicate of this bug. *** dan.dickey@savvis.net 2005-12-07 12:19:28 0000 Created an attachment (id=74246) The patch as implemented by the upstream mythtv. Here is the patch as implemented by the upstream group. I've tested it, and mythfilldatabase works for me. mducksub@atari-source.com 2005-12-18 11:56:45 0000 This should have 'mythtv' added to the summary to ease searches. Thanks :) cardoe@gentoo.org 2005-12-21 14:50:44 0000 changing summary so I can find this darn thing cardoe@gentoo.org 2005-12-25 23:51:45 0000 This will be fixed by the up coming mythtv-0.18.2_pre7882 version. This will include the 0-18-fixes branch which 0.18.1 came from and has since included further fixes. While this fix wasn't backported into that branch, I have applied the patch. 7882 is the rev number of the last commit to that branch. cardoe@gentoo.org 2006-03-09 22:28:26 0000 Use MythTV 0.19 71157 2005-10-21 22:42 0000 This implements the patch I described, quoting repeat in queries. datadirect.patch text/plain KioqIG15dGh0di0wLjE4LjEvbGlicy9saWJteXRodHYvZGF0YWRpcmVjdC5jcHAJU2F0IE9jdCAy MiAwMDozMTo1MSAyMDA1Ci0tLSBteXRodHYtMC4xOC4xL2xpYnMvbGlibXl0aHR2L2RhdGFkaXJl Y3QuY3BwfglTYXQgT2N0IDIyIDAwOjQwOjI1IDIwMDUKKioqKioqKioqKioqKioqCioqKiAxNzMs MTgxICoqKioKICAgICAgICAgIFFEYXRlVGltZSBlbmR0aW1lID0gY3Vycl9zY2hlZHVsZS50aW1l LmFkZFNlY3MoCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFFUaW1l KCkuc2Vjc1RvKGN1cnJfc2NoZWR1bGUuZHVyYXRpb24pKTsKICAKICAgICAgICAgIHF1ZXJ5LnBy ZXBhcmUoIklOU0VSVCBJTlRPIGRkX3NjaGVkdWxlIChwcm9ncmFtaWQsc3RhdGlvbmlkLCIKISAg ICAgICAgICAgICAgICAgICAgICAgInNjaGVkdWxldGltZSxkdXJhdGlvbixgcmVwZWF0YCxzdGVy ZW8sc3VidGl0bGVkLGhkdHYsIgogICAgICAgICAgICAgICAgICAgICAgICAiY2xvc2VjYXB0aW9u ZWQsdHZyYXRpbmcscGFydG51bWJlcixwYXJ0dG90YWwsZW5kdGltZSkgIgogICAgICAgICAgICAg ICAgICAgICAgICAiVkFMVUVTKDpQUk9HUkFNSUQsOlNUQVRJT05JRCw6VElNRSw6RFVSQVRJT04s IgogICAgICAgICAgICAgICAgICAgICAgICAiOlJFUEVBVCw6U1RFUkVPLDpTVUJUSVRMRUQsOkhE VFYsOkNMT1NFQ0FQVElPTkVELCIKICAgICAgICAgICAgICAgICAgICAgICAgIjpUVlJBVElORyw6 UEFSVE5VTUJFUiw6UEFSVFRPVEFMLDpFTkRUSU1FKTsiKTsKLS0tIDE3MywxODEgLS0tLQogICAg ICAgICAgUURhdGVUaW1lIGVuZHRpbWUgPSBjdXJyX3NjaGVkdWxlLnRpbWUuYWRkU2VjcygKICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgUVRpbWUoKS5zZWNzVG8oY3Vy cl9zY2hlZHVsZS5kdXJhdGlvbikpOwogIAogICAgICAgICAgcXVlcnkucHJlcGFyZSgiSU5TRVJU IElOVE8gZGRfc2NoZWR1bGUgKHByb2dyYW1pZCxzdGF0aW9uaWQsIgohICAgICAgICAgICAgICAg ICAgICAgICAic2NoZWR1bGV0aW1lLGR1cmF0aW9uLHJlcGVhdCxzdGVyZW8sc3VidGl0bGVkLGhk dHYsIgogICAgICAgICAgICAgICAgICAgICAgICAiY2xvc2VjYXB0aW9uZWQsdHZyYXRpbmcscGFy dG51bWJlcixwYXJ0dG90YWwsZW5kdGltZSkgIgogICAgICAgICAgICAgICAgICAgICAgICAiVkFM VUVTKDpQUk9HUkFNSUQsOlNUQVRJT05JRCw6VElNRSw6RFVSQVRJT04sIgogICAgICAgICAgICAg ICAgICAgICAgICAiOlJFUEVBVCw6U1RFUkVPLDpTVUJUSVRMRUQsOkhEVFYsOkNMT1NFQ0FQVElP TkVELCIKICAgICAgICAgICAgICAgICAgICAgICAgIjpUVlJBVElORyw6UEFSVE5VTUJFUiw6UEFS VFRPVEFMLDpFTkRUSU1FKTsiKTsKKioqKioqKioqKioqKioqCioqKiA0MTMsNDIxICoqKioKICAg ICAgICAgICAgICAgICAgICAgICAgICJvcmlnaW5hbGFpcmRhdGUsIHNob3d0eXBlLCBjYXRlZ29y eV90eXBlLCBjb2xvcmNvZGUsICIKICAgICAgICAgICAgICAgICAgICAgICAgICJzeW5kaWNhdGVk ZXBpc29kZW51bWJlciwgdHZyYXRpbmcsIG1wYWFyYXRpbmcsICIKICAgICAgICAgICAgICAgICAg ICAgICAgICJwcm9ncmFtaWQpICIKICAgICAgICAgICAgICAgICAgICAgICAgICJTRUxFQ1QgY2hh bmlkLCBzY2hlZHVsZXRpbWUsIGVuZHRpbWUsIHRpdGxlLCAiCiEgICAgICAgICAgICAgICAgICAg ICAgICAic3VidGl0bGUsIGRlc2NyaXB0aW9uLCB5ZWFyLCBzdGFycywgYHJlcGVhdGAsIHN0ZXJl bywgIgogICAgICAgICAgICAgICAgICAgICAgICAgInN1YnRpdGxlZCwgaGR0diwgY2xvc2VjYXB0 aW9uZWQsIHBhcnRudW1iZXIsICIKICAgICAgICAgICAgICAgICAgICAgICAgICJwYXJ0dG90YWws IHNlcmllc2lkLCBvcmlnaW5hbGFpcmRhdGUsIHNob3d0eXBlLCAiCiAgICAgICAgICAgICAgICAg ICAgICAgICAiY2F0ZWdvcnlfdHlwZSwgY29sb3Jjb2RlLCBzeW5kaWNhdGVkZXBpc29kZW51bWJl ciwgIgogICAgICAgICAgICAgICAgICAgICAgICAgInR2cmF0aW5nLCBtcGFhcmF0aW5nLCBkZF9w cm9ncmFtLnByb2dyYW1pZCAiCi0tLSA0MTMsNDIxIC0tLS0KICAgICAgICAgICAgICAgICAgICAg ICAgICJvcmlnaW5hbGFpcmRhdGUsIHNob3d0eXBlLCBjYXRlZ29yeV90eXBlLCBjb2xvcmNvZGUs ICIKICAgICAgICAgICAgICAgICAgICAgICAgICJzeW5kaWNhdGVkZXBpc29kZW51bWJlciwgdHZy YXRpbmcsIG1wYWFyYXRpbmcsICIKICAgICAgICAgICAgICAgICAgICAgICAgICJwcm9ncmFtaWQp ICIKICAgICAgICAgICAgICAgICAgICAgICAgICJTRUxFQ1QgY2hhbmlkLCBzY2hlZHVsZXRpbWUs IGVuZHRpbWUsIHRpdGxlLCAiCiEgICAgICAgICAgICAgICAgICAgICAgICAic3VidGl0bGUsIGRl c2NyaXB0aW9uLCB5ZWFyLCBzdGFycywgcmVwZWF0LCBzdGVyZW8sICIKICAgICAgICAgICAgICAg ICAgICAgICAgICJzdWJ0aXRsZWQsIGhkdHYsIGNsb3NlY2FwdGlvbmVkLCBwYXJ0bnVtYmVyLCAi CiAgICAgICAgICAgICAgICAgICAgICAgICAicGFydHRvdGFsLCBzZXJpZXNpZCwgb3JpZ2luYWxh aXJkYXRlLCBzaG93dHlwZSwgIgogICAgICAgICAgICAgICAgICAgICAgICAgImNhdGVnb3J5X3R5 cGUsIGNvbG9yY29kZSwgc3luZGljYXRlZGVwaXNvZGVudW1iZXIsICIKICAgICAgICAgICAgICAg ICAgICAgICAgICJ0dnJhdGluZywgbXBhYXJhdGluZywgZGRfcHJvZ3JhbS5wcm9ncmFtaWQgIgoq KioqKioqKioqKioqKioKKioqIDYxNiw2MjQgKioqKgogICAgICAgICAgICAgICJjaGFubmVsIGNo YXIoNSksIGNoYW5uZWxNaW5vciBjaGFyKDMpICkiOyAKICAgICAgY3JlYXRlQVRlbXBUYWJsZSAo ImRkX3Zfc3RhdGlvbiIsIHRhYmxlKTsKICAKICAgICAgdGFibGUgPSAiKCBwcm9ncmFtaWQgY2hh cigxMiksIHN0YXRpb25pZCBjaGFyKDEyKSwgc2NoZWR1bGV0aW1lIGRhdGV0aW1lLCAiCiEgICAg ICAgICAgICAgImR1cmF0aW9uIHRpbWUsIGByZXBlYXRgIGJvb2wsIHN0ZXJlbyBib29sLCBzdWJ0 aXRsZWQgYm9vbCwgIgogICAgICAgICAgICAgICJoZHR2IGJvb2wsIGNsb3NlY2FwdGlvbmVkIGJv b2wsIHR2cmF0aW5nIGNoYXIoNSksIHBhcnRudW1iZXIgaW50LCAiCiAgICAgICAgICAgICAgInBh cnR0b3RhbCBpbnQsIGVuZHRpbWUgZGF0ZXRpbWUsIElOREVYIHByb2dpZHggKHByb2dyYW1pZCkg KSI7CiAgICAgIGNyZWF0ZUFUZW1wVGFibGUoImRkX3NjaGVkdWxlIiwgdGFibGUpOyAKICAKLS0t IDYxNiw2MjQgLS0tLQogICAgICAgICAgICAgICJjaGFubmVsIGNoYXIoNSksIGNoYW5uZWxNaW5v ciBjaGFyKDMpICkiOyAKICAgICAgY3JlYXRlQVRlbXBUYWJsZSAoImRkX3Zfc3RhdGlvbiIsIHRh YmxlKTsKICAKICAgICAgdGFibGUgPSAiKCBwcm9ncmFtaWQgY2hhcigxMiksIHN0YXRpb25pZCBj aGFyKDEyKSwgc2NoZWR1bGV0aW1lIGRhdGV0aW1lLCAiCiEgICAgICAgICAgICAgImR1cmF0aW9u IHRpbWUsIHJlcGVhdCBib29sLCBzdGVyZW8gYm9vbCwgc3VidGl0bGVkIGJvb2wsICIKICAgICAg ICAgICAgICAiaGR0diBib29sLCBjbG9zZWNhcHRpb25lZCBib29sLCB0dnJhdGluZyBjaGFyKDUp LCBwYXJ0bnVtYmVyIGludCwgIgogICAgICAgICAgICAgICJwYXJ0dG90YWwgaW50LCBlbmR0aW1l IGRhdGV0aW1lLCBJTkRFWCBwcm9naWR4IChwcm9ncmFtaWQpICkiOwogICAgICBjcmVhdGVBVGVt cFRhYmxlKCJkZF9zY2hlZHVsZSIsIHRhYmxlKTsgCiAgCioqKioqKioqKioqKioqKgoqKiogNjM0 LDY0MiAqKioqCiAgICAgIHRhYmxlID0gIiggY2hhbmlkIGludCB1bnNpZ25lZCBOT1QgTlVMTCwg c3RhcnR0aW1lIGRhdGV0aW1lIE5PVCBOVUxMLCAiCiAgICAgICAgICAgICAgImVuZHRpbWUgZGF0 ZXRpbWUsIHRpdGxlIHZhcmNoYXIoMTI4KSwgc3VidGl0bGUgdmFyY2hhcigxMjgpLCAiCiAgICAg ICAgICAgICAgImRlc2NyaXB0aW9uIHRleHQsIGNhdGVnb3J5IHZhcmNoYXIoNjQpLCAiCiAgICAg ICAgICAgICAgImNhdGVnb3J5X3R5cGUgdmFyY2hhcig2NCksIGFpcmRhdGUgeWVhciwgc3RhcnMg ZmxvYXQgdW5zaWduZWQsICIKISAgICAgICAgICAgICAicHJldmlvdXNseXNob3duIHRpbnlpbnQs IGByZXBlYXRgIGJvb2wsIHN0ZXJlbyBib29sLCAiCiAgICAgICAgICAgICAgInN1YnRpdGxlZCBi b29sLCBoZHR2IGJvb2wsICBjbG9zZWNhcHRpb25lZCBib29sLCBwYXJ0bnVtYmVyIGludCwgIgog ICAgICAgICAgICAgICJwYXJ0dG90YWwgaW50LCBzZXJpZXNpZCBjaGFyKDEyKSwgb3JpZ2luYWxh aXJkYXRlIGRhdGUsICIKICAgICAgICAgICAgICAic2hvd3R5cGUgdmFyY2hhcigzMCksIGNvbG9y Y29kZSB2YXJjaGFyKDIwKSwgIgogICAgICAgICAgICAgICJzeW5kaWNhdGVkZXBpc29kZW51bWJl ciB2YXJjaGFyKDIwKSwgcHJvZ3JhbWlkIGNoYXIoMTIpLCAiCi0tLSA2MzQsNjQyIC0tLS0KICAg ICAgdGFibGUgPSAiKCBjaGFuaWQgaW50IHVuc2lnbmVkIE5PVCBOVUxMLCBzdGFydHRpbWUgZGF0 ZXRpbWUgTk9UIE5VTEwsICIKICAgICAgICAgICAgICAiZW5kdGltZSBkYXRldGltZSwgdGl0bGUg dmFyY2hhcigxMjgpLCBzdWJ0aXRsZSB2YXJjaGFyKDEyOCksICIKICAgICAgICAgICAgICAiZGVz Y3JpcHRpb24gdGV4dCwgY2F0ZWdvcnkgdmFyY2hhcig2NCksICIKICAgICAgICAgICAgICAiY2F0 ZWdvcnlfdHlwZSB2YXJjaGFyKDY0KSwgYWlyZGF0ZSB5ZWFyLCBzdGFycyBmbG9hdCB1bnNpZ25l ZCwgIgohICAgICAgICAgICAgICJwcmV2aW91c2x5c2hvd24gdGlueWludCwgcmVwZWF0IGJvb2ws IHN0ZXJlbyBib29sLCAiCiAgICAgICAgICAgICAgInN1YnRpdGxlZCBib29sLCBoZHR2IGJvb2ws ICBjbG9zZWNhcHRpb25lZCBib29sLCBwYXJ0bnVtYmVyIGludCwgIgogICAgICAgICAgICAgICJw YXJ0dG90YWwgaW50LCBzZXJpZXNpZCBjaGFyKDEyKSwgb3JpZ2luYWxhaXJkYXRlIGRhdGUsICIK ICAgICAgICAgICAgICAic2hvd3R5cGUgdmFyY2hhcigzMCksIGNvbG9yY29kZSB2YXJjaGFyKDIw KSwgIgogICAgICAgICAgICAgICJzeW5kaWNhdGVkZXBpc29kZW51bWJlciB2YXJjaGFyKDIwKSwg cHJvZ3JhbWlkIGNoYXIoMTIpLCAiCg== 74246 2005-12-07 12:19 0000 The patch as implemented by the upstream mythtv. mythtv-0.18.1-mysql5-repeat.patch text/plain LS0tIGxpYnMub2xkL2xpYm15dGh0di9kYXRhZGlyZWN0LmNwcAkyMDA1LTA1LTA0IDE0OjQwOjA3 LjAwMDAwMDAwMCAtMDUwMAorKysgbGlicy9saWJteXRodHYvZGF0YWRpcmVjdC5jcHAJMjAwNS0x Mi0wNyAwOTo0MDo0Mi4wMDAwMDAwMDAgLTA2MDAKQEAgLTE3NCwxNiArMTc0LDE2IEBACiAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgUVRpbWUoKS5zZWNzVG8oY3Vycl9z Y2hlZHVsZS5kdXJhdGlvbikpOwogCiAgICAgICAgIHF1ZXJ5LnByZXBhcmUoIklOU0VSVCBJTlRP IGRkX3NjaGVkdWxlIChwcm9ncmFtaWQsc3RhdGlvbmlkLCIKLSAgICAgICAgICAgICAgICAgICAg ICAic2NoZWR1bGV0aW1lLGR1cmF0aW9uLHJlcGVhdCxzdGVyZW8sc3VidGl0bGVkLGhkdHYsIgor ICAgICAgICAgICAgICAgICAgICAgICJzY2hlZHVsZXRpbWUsZHVyYXRpb24saXNyZXBlYXQsc3Rl cmVvLHN1YnRpdGxlZCxoZHR2LCIKICAgICAgICAgICAgICAgICAgICAgICAiY2xvc2VjYXB0aW9u ZWQsdHZyYXRpbmcscGFydG51bWJlcixwYXJ0dG90YWwsZW5kdGltZSkgIgogICAgICAgICAgICAg ICAgICAgICAgICJWQUxVRVMoOlBST0dSQU1JRCw6U1RBVElPTklELDpUSU1FLDpEVVJBVElPTiwi Ci0gICAgICAgICAgICAgICAgICAgICAgIjpSRVBFQVQsOlNURVJFTyw6U1VCVElUTEVELDpIRFRW LDpDTE9TRUNBUFRJT05FRCwiCisgICAgICAgICAgICAgICAgICAgICAgIjpJU1JFUEVBVCw6U1RF UkVPLDpTVUJUSVRMRUQsOkhEVFYsOkNMT1NFQ0FQVElPTkVELCIKICAgICAgICAgICAgICAgICAg ICAgICAiOlRWUkFUSU5HLDpQQVJUTlVNQkVSLDpQQVJUVE9UQUwsOkVORFRJTUUpOyIpOwogICAg ICAgICBxdWVyeS5iaW5kVmFsdWUoIjpQUk9HUkFNSUQiLCBjdXJyX3NjaGVkdWxlLnByb2dyYW1p ZCk7CiAgICAgICAgIHF1ZXJ5LmJpbmRWYWx1ZSgiOlNUQVRJT05JRCIsIGN1cnJfc2NoZWR1bGUu c3RhdGlvbmlkKTsKICAgICAgICAgcXVlcnkuYmluZFZhbHVlKCI6VElNRSIsIGN1cnJfc2NoZWR1 bGUudGltZSk7CiAgICAgICAgIHF1ZXJ5LmJpbmRWYWx1ZSgiOkRVUkFUSU9OIiwgY3Vycl9zY2hl ZHVsZS5kdXJhdGlvbik7Ci0gICAgICAgIHF1ZXJ5LmJpbmRWYWx1ZSgiOlJFUEVBVCIsIGN1cnJf c2NoZWR1bGUucmVwZWF0KTsKKyAgICAgICAgcXVlcnkuYmluZFZhbHVlKCI6SVNSRVBFQVQiLCBj dXJyX3NjaGVkdWxlLnJlcGVhdCk7CiAgICAgICAgIHF1ZXJ5LmJpbmRWYWx1ZSgiOlNURVJFTyIs IGN1cnJfc2NoZWR1bGUuc3RlcmVvKTsKICAgICAgICAgcXVlcnkuYmluZFZhbHVlKCI6U1VCVElU TEVEIiwgY3Vycl9zY2hlZHVsZS5zdWJ0aXRsZWQpOwogICAgICAgICBxdWVyeS5iaW5kVmFsdWUo IjpIRFRWIiwgY3Vycl9zY2hlZHVsZS5oZHR2KTsKQEAgLTQxNCw3ICs0MTQsNyBAQAogICAgICAg ICAgICAgICAgICAgICAgICAic3luZGljYXRlZGVwaXNvZGVudW1iZXIsIHR2cmF0aW5nLCBtcGFh cmF0aW5nLCAiCiAgICAgICAgICAgICAgICAgICAgICAgICJwcm9ncmFtaWQpICIKICAgICAgICAg ICAgICAgICAgICAgICAgIlNFTEVDVCBjaGFuaWQsIHNjaGVkdWxldGltZSwgZW5kdGltZSwgdGl0 bGUsICIKLSAgICAgICAgICAgICAgICAgICAgICAgInN1YnRpdGxlLCBkZXNjcmlwdGlvbiwgeWVh ciwgc3RhcnMsIHJlcGVhdCwgc3RlcmVvLCAiCisgICAgICAgICAgICAgICAgICAgICAgICJzdWJ0 aXRsZSwgZGVzY3JpcHRpb24sIHllYXIsIHN0YXJzLCBpc3JlcGVhdCwgc3RlcmVvLCAiCiAgICAg ICAgICAgICAgICAgICAgICAgICJzdWJ0aXRsZWQsIGhkdHYsIGNsb3NlY2FwdGlvbmVkLCBwYXJ0 bnVtYmVyLCAiCiAgICAgICAgICAgICAgICAgICAgICAgICJwYXJ0dG90YWwsIHNlcmllc2lkLCBv cmlnaW5hbGFpcmRhdGUsIHNob3d0eXBlLCAiCiAgICAgICAgICAgICAgICAgICAgICAgICJjYXRl Z29yeV90eXBlLCBjb2xvcmNvZGUsIHN5bmRpY2F0ZWRlcGlzb2RlbnVtYmVyLCAiCkBAIC02MTcs NyArNjE3LDcgQEAKICAgICBjcmVhdGVBVGVtcFRhYmxlICgiZGRfdl9zdGF0aW9uIiwgdGFibGUp OwogCiAgICAgdGFibGUgPSAiKCBwcm9ncmFtaWQgY2hhcigxMiksIHN0YXRpb25pZCBjaGFyKDEy KSwgc2NoZWR1bGV0aW1lIGRhdGV0aW1lLCAiCi0gICAgICAgICAgICAiZHVyYXRpb24gdGltZSwg cmVwZWF0IGJvb2wsIHN0ZXJlbyBib29sLCBzdWJ0aXRsZWQgYm9vbCwgIgorICAgICAgICAgICAg ImR1cmF0aW9uIHRpbWUsIGlzcmVwZWF0IGJvb2wsIHN0ZXJlbyBib29sLCBzdWJ0aXRsZWQgYm9v bCwgIgogICAgICAgICAgICAgImhkdHYgYm9vbCwgY2xvc2VjYXB0aW9uZWQgYm9vbCwgdHZyYXRp bmcgY2hhcig1KSwgcGFydG51bWJlciBpbnQsICIKICAgICAgICAgICAgICJwYXJ0dG90YWwgaW50 LCBlbmR0aW1lIGRhdGV0aW1lLCBJTkRFWCBwcm9naWR4IChwcm9ncmFtaWQpICkiOwogICAgIGNy ZWF0ZUFUZW1wVGFibGUoImRkX3NjaGVkdWxlIiwgdGFibGUpOyAKQEAgLTYzNSw3ICs2MzUsNyBA QAogICAgICAgICAgICAgImVuZHRpbWUgZGF0ZXRpbWUsIHRpdGxlIHZhcmNoYXIoMTI4KSwgc3Vi dGl0bGUgdmFyY2hhcigxMjgpLCAiCiAgICAgICAgICAgICAiZGVzY3JpcHRpb24gdGV4dCwgY2F0 ZWdvcnkgdmFyY2hhcig2NCksICIKICAgICAgICAgICAgICJjYXRlZ29yeV90eXBlIHZhcmNoYXIo NjQpLCBhaXJkYXRlIHllYXIsIHN0YXJzIGZsb2F0IHVuc2lnbmVkLCAiCi0gICAgICAgICAgICAi cHJldmlvdXNseXNob3duIHRpbnlpbnQsIHJlcGVhdCBib29sLCBzdGVyZW8gYm9vbCwgIgorICAg ICAgICAgICAgInByZXZpb3VzbHlzaG93biB0aW55aW50LCBpc3JlcGVhdCBib29sLCBzdGVyZW8g Ym9vbCwgIgogICAgICAgICAgICAgInN1YnRpdGxlZCBib29sLCBoZHR2IGJvb2wsICBjbG9zZWNh cHRpb25lZCBib29sLCBwYXJ0bnVtYmVyIGludCwgIgogICAgICAgICAgICAgInBhcnR0b3RhbCBp bnQsIHNlcmllc2lkIGNoYXIoMTIpLCBvcmlnaW5hbGFpcmRhdGUgZGF0ZSwgIgogICAgICAgICAg ICAgInNob3d0eXBlIHZhcmNoYXIoMzApLCBjb2xvcmNvZGUgdmFyY2hhcigyMCksICIK