I'm using MythTV... it consistently fails with this query;
2020-02-01 11:56:26.486022 W LoadFromProgram(): SQL contains LIMIT clause, caller should be updated to use limit parameter instead
|
QMYSQLResult::cleanup: unable to free statement handle
|
2020-02-01 11:56:28.990474 E DB Error (LoadByTemplate):
|
Query was:
|
SELECT recordid, category, (category = ?) AS catmatch, (category = ?) AS typematch FROM record WHERE type = ? AND (category = ? OR category = ? OR category = 'Default') ORDER BY catmatch DESC, typematch DESC
|
Bindings were:
|
:CAT1="", :CAT2="", :CATTYPE1="", :CATTYPE2="", :TEMPLATE=11
|
Driver error was [2/2006]:
|
QMYSQL3: Unable to execute statement
|
Database error was:
|
MySQL server has gone away
|
mariadb.service: Main process exited, code=killed, status=11/SEGV
I look at the sudo journalctl -xe
I see this consistently in one of the threads every time this problem occurs:
Stack trace of thread 1009:
|
#0 0x00005623efa724ee _Z7sortcmpPK6StringS1_PK15charset_info_st (mysqld + 0x7004ee)
|
#1 0x00005623efb2fa37 _ZNK26Type_handler_string_result13Item_const_eqEPK10Item_constS2_b (mysqld + 0x7bd>
|
#2 0x00005623efc136a2 _ZN4Item15eq_by_collationEPS_bPK15charset_info_st (mysqld + 0x8a16a2)
|
#3 0x00005623efa199a9 _ZN9Item_cond14add_key_fieldsEP4JOINPP9KEY_FIELDPjyPP14SARGABLE_PARAM (mysqld + 0x>
|
#4 0x00005623efa196ea _ZN13Item_cond_and14add_key_fieldsEP4JOINPP9KEY_FIELDPjyPP14SARGABLE_PARAM (mysqld>
|
#5 0x00005623efa1a8cb n/a (mysqld + 0x6a88cb)
|
#6 0x00005623efa4aeb4 _ZN4JOIN14optimize_innerEv (mysqld + 0x6d8eb4)
|
#7 0x00005623efa4cef4 _ZN4JOIN8optimizeEv (mysqld + 0x6daef4)
|
#8 0x00005623efa4d094 _Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select>
|
#9 0x00005623efa4dbb4 _Z13handle_selectP3THDP3LEXP13select_resultm (mysqld + 0x6dbbb4)
|
#10 0x00005623ef9de93c n/a (mysqld + 0x66c93c)
|
#11 0x00005623ef9edf96 _Z21mysql_execute_commandP3THD (mysqld + 0x67bf96)
|
#12 0x00005623efa03ce0 _ZN18Prepared_statement7executeEP6Stringb (mysqld + 0x691ce0)
|
#13 0x00005623efa03e94 _ZN18Prepared_statement12execute_loopEP6StringbPhS2_ (mysqld + 0x691e94)
|
#14 0x00005623efa04a7e n/a (mysqld + 0x692a7e)
|
#15 0x00005623efa04b22 _Z19mysqld_stmt_executeP3THDPcj (mysqld + 0x692b22)
|
#16 0x00005623ef9f221b _Z16dispatch_command19enum_server_commandP3THDPcjbb (mysqld + 0x68021b)
|
#17 0x00005623ef9f5021 _Z10do_commandP3THD (mysqld + 0x683021)
|
#18 0x00005623efad9296 _Z24do_handle_one_connectionP7CONNECT (mysqld + 0x767296)
|
#19 0x00005623efad93d3 handle_one_connection (mysqld + 0x7673d3)
|
#20 0x00007fa0850d64cf start_thread (libpthread.so.0 + 0x94cf)
|
#21 0x00007fa0848ac2d3 __clone (libc.so.6 + 0xff2d3)
|
Any idea what is going on in this stack?
I've tried re-installing maria db... I've tried wiping the database and recreating it.
{"report":{"fcp":744.7999992370605,"ttfb":139.5999994277954,"pageVisibility":"visible","entityId":82874,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"da7e0f92-a37e-4229-b923-d9ac61818cf7","navigationType":0,"readyForUser":842.2999992370605,"redirectCount":0,"resourceLoadedEnd":845,"resourceLoadedStart":145.19999980926514,"resourceTiming":[{"duration":125.09999942779541,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":145.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":145.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":270.29999923706055,"responseStart":0,"secureConnectionStart":0},{"duration":124.79999923706055,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":145.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":145.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":270.29999923706055,"responseStart":0,"secureConnectionStart":0},{"duration":134.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":145.5,"connectEnd":145.5,"connectStart":145.5,"domainLookupEnd":145.5,"domainLookupStart":145.5,"fetchStart":145.5,"redirectEnd":0,"redirectStart":0,"requestStart":145.5,"responseEnd":280,"responseStart":279.8999996185303,"secureConnectionStart":145.5},{"duration":220.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/099b33461394b8015fc36c0a4b96e19f-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":145.5999994277954,"connectEnd":145.5999994277954,"connectStart":145.5999994277954,"domainLookupEnd":145.5999994277954,"domainLookupStart":145.5999994277954,"fetchStart":145.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":145.5999994277954,"responseEnd":366.29999923706055,"responseStart":366.29999923706055,"secureConnectionStart":145.5999994277954},{"duration":224.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":145.79999923706055,"connectEnd":145.79999923706055,"connectStart":145.79999923706055,"domainLookupEnd":145.79999923706055,"domainLookupStart":145.79999923706055,"fetchStart":145.79999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":145.79999923706055,"responseEnd":370.29999923706055,"responseStart":370.29999923706055,"secureConnectionStart":145.79999923706055},{"duration":224,"initiatorType":"script","name":"https://jira.mariadb.org/s/94c15bff32baef80f4096a08aceae8bc-CDN/lu2bu7/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":145.79999923706055,"connectEnd":145.79999923706055,"connectStart":145.79999923706055,"domainLookupEnd":145.79999923706055,"domainLookupStart":145.79999923706055,"fetchStart":145.79999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":145.79999923706055,"responseEnd":369.79999923706055,"responseStart":369.79999923706055,"secureConnectionStart":145.79999923706055},{"duration":224.79999923706055,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":146,"connectEnd":146,"connectStart":146,"domainLookupEnd":146,"domainLookupStart":146,"fetchStart":146,"redirectEnd":0,"redirectStart":0,"requestStart":146,"responseEnd":370.79999923706055,"responseStart":370.79999923706055,"secureConnectionStart":146},{"duration":225.30000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bu7/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":146.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":146.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":371.5,"responseStart":0,"secureConnectionStart":0},{"duration":225.20000076293945,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":146.29999923706055,"connectEnd":146.29999923706055,"connectStart":146.29999923706055,"domainLookupEnd":146.29999923706055,"domainLookupStart":146.29999923706055,"fetchStart":146.29999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":146.29999923706055,"responseEnd":371.5,"responseStart":371.5,"secureConnectionStart":146.29999923706055},{"duration":229,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bu7/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":146.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":146.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":375.5,"responseStart":0,"secureConnectionStart":0},{"duration":225.39999961853027,"initiatorType":"script","name":"https://jira.mariadb.org/s/3339d87fa2538a859872f2df449bf8d0-CDN/lu2bu7/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":146.69999980926514,"connectEnd":146.69999980926514,"connectStart":146.69999980926514,"domainLookupEnd":146.69999980926514,"domainLookupStart":146.69999980926514,"fetchStart":146.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":146.69999980926514,"responseEnd":372.0999994277954,"responseStart":372.0999994277954,"secureConnectionStart":146.69999980926514},{"duration":341.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":152.39999961853027,"connectEnd":152.39999961853027,"connectStart":152.39999961853027,"domainLookupEnd":152.39999961853027,"domainLookupStart":152.39999961853027,"fetchStart":152.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":152.39999961853027,"responseEnd":494.19999980926514,"responseStart":494.19999980926514,"secureConnectionStart":152.39999961853027},{"duration":692.4000005722046,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":152.5999994277954,"connectEnd":152.5999994277954,"connectStart":152.5999994277954,"domainLookupEnd":152.5999994277954,"domainLookupStart":152.5999994277954,"fetchStart":152.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":152.5999994277954,"responseEnd":845,"responseStart":845,"secureConnectionStart":152.5999994277954},{"duration":56.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":438.19999980926514,"connectEnd":438.19999980926514,"connectStart":438.19999980926514,"domainLookupEnd":438.19999980926514,"domainLookupStart":438.19999980926514,"fetchStart":438.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":438.19999980926514,"responseEnd":494.69999980926514,"responseStart":494.69999980926514,"secureConnectionStart":438.19999980926514},{"duration":259.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":663.2999992370605,"connectEnd":663.2999992370605,"connectStart":663.2999992370605,"domainLookupEnd":663.2999992370605,"domainLookupStart":663.2999992370605,"fetchStart":663.2999992370605,"redirectEnd":0,"redirectStart":0,"requestStart":663.2999992370605,"responseEnd":923.0999994277954,"responseStart":923.0999994277954,"secureConnectionStart":663.2999992370605}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":3,"responseStart":140,"responseEnd":152,"domLoading":143,"domInteractive":907,"domContentLoadedEventStart":907,"domContentLoadedEventEnd":949,"domComplete":1758,"loadEventStart":1758,"loadEventEnd":1759,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":887.5999994277954},{"name":"bigPipe.sidebar-id.end","time":888.3999996185303},{"name":"bigPipe.activity-panel-pipe-id.start","time":888.5999994277954},{"name":"bigPipe.activity-panel-pipe-id.end","time":891.1999998092651},{"name":"activityTabFullyLoaded","time":960.3999996185303}],"measures":[],"correlationId":"7b31e89905f44b","effectiveType":"4g","downlink":9.3,"rtt":0,"serverDuration":79,"dbReadsTimeInMs":13,"dbConnsTimeInMs":20,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}