-
Bug
-
-
Resolution:
Fixed
-
None
-
None
-
None
-
After installing MariaDB from .deb files (assuming all fixes to preceding bugs are applied and install succeeds), I get this:
root@ubuntu-x86-vm:~# ls -la /var/lib/mysql/
total 20564
drwxr-xr-x 4 mysql mysql 4096 2009-10-19 19:20 .
drwxr-xr-x 34 root root 4096 2009-10-19 19:19 ..
rw-rr- 1 root root 0 2009-10-19 19:19 debian-5.1.flag
rw-rw--- 1 mysql mysql 10485760 2009-10-19 19:20 ibdata1
rw-rw--- 1 mysql mysql 5242880 2009-10-19 19:20 ib_logfile0
rw-rw--- 1 mysql mysql 5242880 2009-10-19 19:19 ib_logfile1
rw-rw--- 1 mysql mysql 16384 2009-10-19 19:19 maria_log.00000001
rw-rw--- 1 mysql mysql 52 2009-10-19 19:19 maria_log_control
drwxr-xr-x 2 mysql root 4096 2009-10-19 19:20 mysql
rw------ 1 root root 17 2009-10-19 19:20 mysql_upgrade_info
rw-rw--- 1 mysql mysql 4 2009-10-19 19:19 pbxt-lock
drwx------ 2 root root 4096 2009-10-19 19:19 test
note that 'test' is owned by root. This makes it impossible to create any tables in 'test' database:
MySQL [test]> create table t1(a int);
ERROR 1005 (HY000): Can't create table 't1' (errno: 13)
MySQL [test]> create database db1;
Query OK, 1 row affected (0.00 sec)
MySQL [test]> create table db1.t1(a int);
Query OK, 0 rows affected (0.05 sec)
Fix suggestion: make the installation procedure set correct permissions.
{"report":{"fcp":884,"ttfb":162.7000000178814,"pageVisibility":"visible","entityId":20231,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"491e3b07-c3a4-42d9-9eb3-9e81b3d786c0","navigationType":0,"readyForUser":943.4000000059605,"redirectCount":0,"resourceLoadedEnd":1153.5,"resourceLoadedStart":167.80000001192093,"resourceTiming":[{"duration":231.40000000596046,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":167.80000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":167.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":399.2000000178814,"responseStart":0,"secureConnectionStart":0},{"duration":231.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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":168.10000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":168.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":399.60000002384186,"responseStart":0,"secureConnectionStart":0},{"duration":277.2999999821186,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":168.2000000178814,"connectEnd":168.2000000178814,"connectStart":168.2000000178814,"domainLookupEnd":168.2000000178814,"domainLookupStart":168.2000000178814,"fetchStart":168.2000000178814,"redirectEnd":0,"redirectStart":0,"requestStart":168.2000000178814,"responseEnd":445.5,"responseStart":445.5,"secureConnectionStart":168.2000000178814},{"duration":356.2000000178814,"initiatorType":"script","name":"https://jira.mariadb.org/s/c32eb0da7ad9831253f8397e6cc26afd-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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":168.40000000596046,"connectEnd":168.40000000596046,"connectStart":168.40000000596046,"domainLookupEnd":168.40000000596046,"domainLookupStart":168.40000000596046,"fetchStart":168.40000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":168.40000000596046,"responseEnd":524.6000000238419,"responseStart":524.6000000238419,"secureConnectionStart":168.40000000596046},{"duration":359.39999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/bc0bcb146314416123c992714ee00ff7-CDN/lu2bv2/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":168.60000002384186,"connectEnd":168.60000002384186,"connectStart":168.60000002384186,"domainLookupEnd":168.60000002384186,"domainLookupStart":168.60000002384186,"fetchStart":168.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":168.60000002384186,"responseEnd":528,"responseStart":528,"secureConnectionStart":168.60000002384186},{"duration":359.69999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":168.80000001192093,"connectEnd":168.80000001192093,"connectStart":168.80000001192093,"domainLookupEnd":168.80000001192093,"domainLookupStart":168.80000001192093,"fetchStart":168.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":168.80000001192093,"responseEnd":528.5,"responseStart":528.5,"secureConnectionStart":168.80000001192093},{"duration":359.90000000596046,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":169,"connectEnd":169,"connectStart":169,"domainLookupEnd":169,"domainLookupStart":169,"fetchStart":169,"redirectEnd":0,"redirectStart":0,"requestStart":169,"responseEnd":528.9000000059605,"responseStart":528.9000000059605,"secureConnectionStart":169},{"duration":415.7999999821186,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bv2/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":169.10000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":169.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":584.9000000059605,"responseStart":0,"secureConnectionStart":0},{"duration":360.09999999403954,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":169.30000001192093,"connectEnd":169.30000001192093,"connectStart":169.30000001192093,"domainLookupEnd":169.30000001192093,"domainLookupStart":169.30000001192093,"fetchStart":169.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":169.30000001192093,"responseEnd":529.4000000059605,"responseStart":529.4000000059605,"secureConnectionStart":169.30000001192093},{"duration":415.7000000178814,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bv2/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":169.40000000596046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":169.40000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":585.1000000238419,"responseStart":0,"secureConnectionStart":0},{"duration":360.2999999821186,"initiatorType":"script","name":"https://jira.mariadb.org/s/719848dd97ebe0663199f49a3936487a-CDN/lu2bv2/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":169.60000002384186,"connectEnd":169.60000002384186,"connectStart":169.60000002384186,"domainLookupEnd":169.60000002384186,"domainLookupStart":169.60000002384186,"fetchStart":169.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":169.60000002384186,"responseEnd":529.9000000059605,"responseStart":529.9000000059605,"secureConnectionStart":169.60000002384186},{"duration":982.7000000178814,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":170.40000000596046,"connectEnd":170.40000000596046,"connectStart":170.40000000596046,"domainLookupEnd":170.40000000596046,"domainLookupStart":170.40000000596046,"fetchStart":170.40000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":170.40000000596046,"responseEnd":1153.1000000238419,"responseStart":1153.1000000238419,"secureConnectionStart":170.40000000596046},{"duration":983.0999999940395,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":170.40000000596046,"connectEnd":170.40000000596046,"connectStart":170.40000000596046,"domainLookupEnd":170.40000000596046,"domainLookupStart":170.40000000596046,"fetchStart":170.40000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":170.40000000596046,"responseEnd":1153.5,"responseStart":1153.5,"secureConnectionStart":170.40000000596046},{"duration":370.80000001192093,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":595.5,"connectEnd":595.5,"connectStart":595.5,"domainLookupEnd":595.5,"domainLookupStart":595.5,"fetchStart":595.5,"redirectEnd":0,"redirectStart":0,"requestStart":595.5,"responseEnd":966.3000000119209,"responseStart":966.3000000119209,"secureConnectionStart":595.5},{"duration":290,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":878.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":878.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1168.5,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":13,"responseStart":163,"responseEnd":164,"domLoading":166,"domInteractive":1173,"domContentLoadedEventStart":1173,"domContentLoadedEventEnd":1209,"domComplete":1924,"loadEventStart":1924,"loadEventEnd":1926,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1157.5},{"name":"bigPipe.sidebar-id.end","time":1158.300000011921},{"name":"bigPipe.activity-panel-pipe-id.start","time":1158.4000000059605},{"name":"bigPipe.activity-panel-pipe-id.end","time":1160.800000011921},{"name":"activityTabFullyLoaded","time":1214.1000000238419}],"measures":[],"correlationId":"9aa00666a21395","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":92,"dbReadsTimeInMs":8,"dbConnsTimeInMs":16,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}