I've been updating one of my applications from OQGraphv2 to v3 and while initial tests showed everything working, I'm now getting troublesome crashes when I put some load on the OQGraph table.
The application is basically a webservice (in PHP) that queries the OQGraph table (schema attached) and returns the result. The query in itself should be fairly simple:
SELECT db.* FROM db_history AS db INNER JOIN version_history AS v ON db.nodeID = v.linkid WHERE origid = 1 AND destid = 3 AND latch = 'dijkstras';
When doing single sequential requests in the browser, everything works fine. But once I started to put some load on the webservice (using siege as load testing tool), MariaDB crashes quickly after 1-2 requests (crash dump attached), always with the same crash dump.
I should note that the database setup is a master-slave replication setup. I'm not sure that has anything to do with the crashes I'm seeing though.
I can reproduce this fairly easily and reliably in my test environment, on both the slave and the master node, but have not been successful so far in producing a test case that does not involve running siege.
{"report":{"fcp":1097.5,"ttfb":266,"pageVisibility":"visible","entityId":37819,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":16,"apdex":0.5,"journeyId":"4f55bf79-b7a1-4181-a815-b6eaddd1b6aa","navigationType":0,"readyForUser":1208.7000000001863,"redirectCount":0,"resourceLoadedEnd":810.7000000001863,"resourceLoadedStart":273.5,"resourceTiming":[{"duration":30.300000000046566,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":273.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":273.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":303.80000000004657,"responseStart":0,"secureConnectionStart":0},{"duration":30.799999999813735,"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":273.70000000018626,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":273.70000000018626,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":304.5,"responseStart":0,"secureConnectionStart":0},{"duration":329.39999999990687,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":273.70000000018626,"connectEnd":273.70000000018626,"connectStart":273.70000000018626,"domainLookupEnd":273.70000000018626,"domainLookupStart":273.70000000018626,"fetchStart":273.70000000018626,"redirectEnd":0,"redirectStart":0,"requestStart":307.80000000004657,"responseEnd":603.1000000000931,"responseStart":339.20000000018626,"secureConnectionStart":273.70000000018626},{"duration":77.80000000004657,"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":273.9000000001397,"connectEnd":273.9000000001397,"connectStart":273.9000000001397,"domainLookupEnd":273.9000000001397,"domainLookupStart":273.9000000001397,"fetchStart":273.9000000001397,"redirectEnd":0,"redirectStart":0,"requestStart":308.10000000009313,"responseEnd":351.70000000018626,"responseStart":346.10000000009313,"secureConnectionStart":273.9000000001397},{"duration":536.8000000000466,"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":273.9000000001397,"connectEnd":273.9000000001397,"connectStart":273.9000000001397,"domainLookupEnd":273.9000000001397,"domainLookupStart":273.9000000001397,"fetchStart":273.9000000001397,"redirectEnd":0,"redirectStart":0,"requestStart":308,"responseEnd":810.7000000001863,"responseStart":344,"secureConnectionStart":273.9000000001397},{"duration":87.39999999990687,"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":274.10000000009313,"connectEnd":274.10000000009313,"connectStart":274.10000000009313,"domainLookupEnd":274.10000000009313,"domainLookupStart":274.10000000009313,"fetchStart":274.10000000009313,"redirectEnd":0,"redirectStart":0,"requestStart":331.60000000009313,"responseEnd":361.5,"responseStart":355.9000000001397,"secureConnectionStart":274.10000000009313},{"duration":87.60000000009313,"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":274.30000000004657,"connectEnd":274.30000000004657,"connectStart":274.30000000004657,"domainLookupEnd":274.30000000004657,"domainLookupStart":274.30000000004657,"fetchStart":274.30000000004657,"redirectEnd":0,"redirectStart":0,"requestStart":332.20000000018626,"responseEnd":361.9000000001397,"responseStart":356.60000000009313,"secureConnectionStart":274.30000000004657},{"duration":48.89999999990687,"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":274.4000000001397,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":274.4000000001397,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":323.30000000004657,"responseStart":0,"secureConnectionStart":0},{"duration":87.60000000009313,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":274.5,"connectEnd":274.5,"connectStart":274.5,"domainLookupEnd":274.5,"domainLookupStart":274.5,"fetchStart":274.5,"redirectEnd":0,"redirectStart":0,"requestStart":332.5,"responseEnd":362.10000000009313,"responseStart":357.20000000018626,"secureConnectionStart":274.5},{"duration":50.5,"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":274.60000000009313,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":274.60000000009313,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":325.10000000009313,"responseStart":0,"secureConnectionStart":0},{"duration":94,"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":274.9000000001397,"connectEnd":274.9000000001397,"connectStart":274.9000000001397,"domainLookupEnd":274.9000000001397,"domainLookupStart":274.9000000001397,"fetchStart":274.9000000001397,"redirectEnd":0,"redirectStart":0,"requestStart":350.20000000018626,"responseEnd":368.9000000001397,"responseStart":368,"secureConnectionStart":274.9000000001397},{"duration":496.20000000018626,"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":278,"connectEnd":278,"connectStart":278,"domainLookupEnd":278,"domainLookupStart":278,"fetchStart":278,"redirectEnd":0,"redirectStart":0,"requestStart":373.60000000009313,"responseEnd":774.2000000001863,"responseStart":766,"secureConnectionStart":278},{"duration":497.30000000004657,"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":278.10000000009313,"connectEnd":278.10000000009313,"connectStart":278.10000000009313,"domainLookupEnd":278.10000000009313,"domainLookupStart":278.10000000009313,"fetchStart":278.10000000009313,"redirectEnd":0,"redirectStart":0,"requestStart":414.80000000004657,"responseEnd":775.4000000001397,"responseStart":767.4000000001397,"secureConnectionStart":278.10000000009313},{"duration":84.10000000009313,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":772.3000000000466,"connectEnd":772.3000000000466,"connectStart":772.3000000000466,"domainLookupEnd":772.3000000000466,"domainLookupStart":772.3000000000466,"fetchStart":772.3000000000466,"redirectEnd":0,"redirectStart":0,"requestStart":817.4000000001397,"responseEnd":856.4000000001397,"responseStart":855.7000000001863,"secureConnectionStart":772.3000000000466},{"duration":205.79999999981374,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1043.2000000001863,"connectEnd":1043.2000000001863,"connectStart":1043.2000000001863,"domainLookupEnd":1043.2000000001863,"domainLookupStart":1043.2000000001863,"fetchStart":1043.2000000001863,"redirectEnd":0,"redirectStart":0,"requestStart":1215.2000000001863,"responseEnd":1249,"responseStart":1247.7000000001863,"secureConnectionStart":1043.2000000001863},{"duration":174.89999999990687,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1084.7000000001863,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1084.7000000001863,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1259.6000000000931,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":97,"responseStart":266,"responseEnd":274,"domLoading":269,"domInteractive":1279,"domContentLoadedEventStart":1279,"domContentLoadedEventEnd":1345,"domComplete":1678,"loadEventStart":1678,"loadEventEnd":1678,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1250.4000000001397},{"name":"bigPipe.sidebar-id.end","time":1251.1000000000931},{"name":"bigPipe.activity-panel-pipe-id.start","time":1251.3000000000466},{"name":"bigPipe.activity-panel-pipe-id.end","time":1253.1000000000931},{"name":"activityTabFullyLoaded","time":1362.2000000001863}],"measures":[],"correlationId":"f7df1b11ee4084","effectiveType":"4g","downlink":9.7,"rtt":0,"serverDuration":90,"dbReadsTimeInMs":14,"dbConnsTimeInMs":25,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Yes. If you plan to fix the bug (or do some change, whatever) in both 10.0 anf 10.1, then you only need to do it and provide a pull request for 10.0 — I'll take care of propagating it to 10.1. Of course, if you want something to be done in 10.1 only, then you just create a pull request for 10.1.