galera node rejoining is started with --disable-log-error
it's tried to rejoin galera node , operation failed but any logs are not received
that does not allow to get the log_error
# service mysql start --wsrep_cluster_address=gcomm://192.168.104.195
|
Starting mysql (via systemctl): Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.
|
[FAILED]
|
|
root 4969 0.0 0.0 113260 1724 pts/1 S+ 18:50 0:00 /bin/sh /usr/sbin/service mysql start --wsrep_cluster_address=gcomm://192.1 68.104.195
|
root 4978 0.0 0.0 115520 1832 pts/1 S+ 18:50 0:00 /bin/sh /etc/init.d/mysql start --wsrep_cluster_address=gcomm://192.168.104 .195
|
root 4984 0.0 0.0 128428 1456 pts/1 S+ 18:50 0:00 /bin/systemctl start mysql.service
|
mysql 5069 0.0 2.5 722992 51896 ? Dl 18:50 0:00 /usr/sbin/mysqld --user=mysql --wsrep_recover --disable-log-error
|
root 5107 0.0 0.0 112660 968 pts/3 S+ 18:50 0:00 grep --color=auto mysql
|
[root@t4w6 ~]#
|
|
]# systemctl status mariadb.service
|
● mariadb.service - MariaDB 10.3.6 database server
|
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
|
Drop-In: /etc/systemd/system/mariadb.service.d
|
└─migrated-from-my.cnf-settings.conf
|
Active: failed (Result: exit-code) since Wed 2018-04-25 18:50:39 EEST; 4min 51s ago
|
Docs: man:mysqld(8)
|
https://mariadb.com/kb/en/library/systemd/
|
Process: 1418 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
|
Process: 3211 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=killed, signal=ABRT)
|
Process: 4993 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=1/FAILURE)
|
Process: 4990 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
|
Main PID: 3211 (code=killed, signal=ABRT)
|
|
Apr 25 18:50:39 t4w6.xentio.lan sh[4993]: 2018-04-25 18:50:38 0 [ERROR]
|
Apr 25 18:50:39 t4w6.xentio.lan sh[4993]: 2018-04-25 18:50:38 0 [ERROR] @@@@@@@@@@@
|
Apr 25 18:50:39 t4w6.xentio.lan sh[4993]: 2018-04-25 18:50:38 0 [ERROR] @@' '@@
|
Apr 25 18:50:39 t4w6.xentio.lan sh[4993]: 2018-04-25 18:50:38 0 [ERROR] @@ _ _ @@
|
Apr 25 18:50:39 t4w6.xentio.lan sh[4993]: 2018-04-25 18:50:38 0 [ERROR] | (.) (.) |
|
Apr 25 18:50:39 t4w6.xentio.lan sh[4993]: 2018-04-25 18:50:38 0 [ERROR] | ` |
|
Apr 25 18:50:39 t4w6.xentio.lan systemd[1]: mariadb.service: control process exited, code=exited status=1
|
Apr 25 18:50:39 t4w6.xentio.lan systemd[1]: Failed to start MariaDB 10.3.6 database server.
|
Apr 25 18:50:39 t4w6.xentio.lan systemd[1]: Unit mariadb.service entered failed state.
|
Apr 25 18:50:39 t4w6.xentio.lan systemd[1]: mariadb.service failed.
|
|
{"report":{"fcp":915.8999998569489,"ttfb":426.2000000476837,"pageVisibility":"visible","entityId":67082,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"086a9d2b-5147-4753-836e-3707117b0067","navigationType":0,"readyForUser":991.8999998569489,"redirectCount":0,"resourceLoadedEnd":690.2999999523163,"resourceLoadedStart":432.09999990463257,"resourceTiming":[{"duration":9.600000143051147,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":432.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":432.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":441.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":9.5,"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":432.39999985694885,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":432.39999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":441.89999985694885,"responseStart":0,"secureConnectionStart":0},{"duration":39,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":432.5,"connectEnd":432.5,"connectStart":432.5,"domainLookupEnd":432.5,"domainLookupStart":432.5,"fetchStart":432.5,"redirectEnd":0,"redirectStart":0,"requestStart":432.5,"responseEnd":471.5,"responseStart":471.5,"secureConnectionStart":432.5},{"duration":216.40000009536743,"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":432.59999990463257,"connectEnd":432.59999990463257,"connectStart":432.59999990463257,"domainLookupEnd":432.59999990463257,"domainLookupStart":432.59999990463257,"fetchStart":432.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":475,"responseEnd":649,"responseStart":487.09999990463257,"secureConnectionStart":432.59999990463257},{"duration":40.799999952316284,"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":432.7000000476837,"connectEnd":432.7000000476837,"connectStart":432.7000000476837,"domainLookupEnd":432.7000000476837,"domainLookupStart":432.7000000476837,"fetchStart":432.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":432.7000000476837,"responseEnd":473.5,"responseStart":473.5,"secureConnectionStart":432.7000000476837},{"duration":41.200000047683716,"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":432.7999999523163,"connectEnd":432.7999999523163,"connectStart":432.7999999523163,"domainLookupEnd":432.7999999523163,"domainLookupStart":432.7999999523163,"fetchStart":432.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":432.7999999523163,"responseEnd":474,"responseStart":474,"secureConnectionStart":432.7999999523163},{"duration":41.700000047683716,"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":432.89999985694885,"connectEnd":432.89999985694885,"connectStart":432.89999985694885,"domainLookupEnd":432.89999985694885,"domainLookupStart":432.89999985694885,"fetchStart":432.89999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":432.89999985694885,"responseEnd":474.59999990463257,"responseStart":474.59999990463257,"secureConnectionStart":432.89999985694885},{"duration":42.5,"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":433,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":433,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":475.5,"responseStart":0,"secureConnectionStart":0},{"duration":42.10000014305115,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":433.09999990463257,"connectEnd":433.09999990463257,"connectStart":433.09999990463257,"domainLookupEnd":433.09999990463257,"domainLookupStart":433.09999990463257,"fetchStart":433.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":433.09999990463257,"responseEnd":475.2000000476837,"responseStart":475.2000000476837,"secureConnectionStart":433.09999990463257},{"duration":42.59999990463257,"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":433.2000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":433.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":475.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":42.59999990463257,"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":433.2999999523163,"connectEnd":433.2999999523163,"connectStart":433.2999999523163,"domainLookupEnd":433.2999999523163,"domainLookupStart":433.2999999523163,"fetchStart":433.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":433.2999999523163,"responseEnd":475.89999985694885,"responseStart":475.89999985694885,"secureConnectionStart":433.2999999523163},{"duration":119.10000014305115,"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":433.89999985694885,"connectEnd":433.89999985694885,"connectStart":433.89999985694885,"domainLookupEnd":433.89999985694885,"domainLookupStart":433.89999985694885,"fetchStart":433.89999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":433.89999985694885,"responseEnd":553,"responseStart":553,"secureConnectionStart":433.89999985694885},{"duration":251.90000009536743,"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":438.39999985694885,"connectEnd":438.39999985694885,"connectStart":438.39999985694885,"domainLookupEnd":438.39999985694885,"domainLookupStart":438.39999985694885,"fetchStart":438.39999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":438.39999985694885,"responseEnd":690.2999999523163,"responseStart":690.2999999523163,"secureConnectionStart":438.39999985694885},{"duration":102.79999995231628,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":641.0999999046326,"connectEnd":641.0999999046326,"connectStart":641.0999999046326,"domainLookupEnd":641.0999999046326,"domainLookupStart":641.0999999046326,"fetchStart":641.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":714,"responseEnd":743.8999998569489,"responseStart":743,"secureConnectionStart":641.0999999046326},{"duration":183.70000004768372,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":871.3999998569489,"connectEnd":871.3999998569489,"connectStart":871.3999998569489,"domainLookupEnd":871.3999998569489,"domainLookupStart":871.3999998569489,"fetchStart":871.3999998569489,"redirectEnd":0,"redirectStart":0,"requestStart":1025.7000000476837,"responseEnd":1055.0999999046326,"responseStart":1054.2000000476837,"secureConnectionStart":871.3999998569489},{"duration":122.79999995231628,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":908.7000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":908.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1031.5,"responseStart":0,"secureConnectionStart":0}],"fetchStart":1,"domainLookupStart":1,"domainLookupEnd":1,"connectStart":1,"connectEnd":1,"requestStart":20,"responseStart":427,"responseEnd":433,"domLoading":430,"domInteractive":1086,"domContentLoadedEventStart":1086,"domContentLoadedEventEnd":1133,"domComplete":1255,"loadEventStart":1255,"loadEventEnd":1255,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1062.2000000476837},{"name":"bigPipe.sidebar-id.end","time":1063.0999999046326},{"name":"bigPipe.activity-panel-pipe-id.start","time":1063.2999999523163},{"name":"bigPipe.activity-panel-pipe-id.end","time":1064.3999998569489},{"name":"activityTabFullyLoaded","time":1150.2999999523163}],"measures":[],"correlationId":"fa79d8da0f8024","effectiveType":"4g","downlink":9.2,"rtt":0,"serverDuration":73,"dbReadsTimeInMs":14,"dbConnsTimeInMs":23,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Is this repeatable ?