LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Closed Thread
  Search this Thread
Old 08-27-2018, 08:06 AM   #1
manishdixitajm
LQ Newbie
 
Registered: Aug 2013
Posts: 4

Rep: Reputation: Disabled
Maria DB not starting woth Galera first time execution


Hi,

I m using Linux 3.10.0-862.9.1.el7.x86_64. When I am configuring Galera and starting it for the first time. I am getting below error
Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.

I am using https://github.com/eoldavix/Sangoma-FreePBX-HA .

After checking journalctl -xe , I am getting below logs
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: Foun
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: Pass
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: Assi
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: wsre
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: Star
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: 'wsr
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: Sett
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [ERROR] WSREP: It
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [ERROR] WSREP: wsr
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [ERROR] Aborting
Aug 27 16:32:21 PRPBX01 systemd[1]: mariadb.service: main process exited, code=exited, status
Aug 27 16:32:21 PRPBX01 systemd[1]: Failed to start MariaDB 10.1.35 database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman.../systemd-devel
--
-- Unit mariadb.service has failed.
--
-- The result is failed.
Aug 27 16:32:21 PRPBX01 systemd[1]: Unit mariadb.service entered failed state.
Aug 27 16:32:21 PRPBX01 systemd[1]: mariadb.service failed.
Aug 27 16:32:21 PRPBX01 polkitd[581]: Unregistered Authentication Agent for unix-process:1568
Aug 27 16:32:27 PRPBX01 postfix/smtp[15629]: connect to yourpbx.com[54.174.45.28]:25: Connect
lines 2895-2917/2917 (END)
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: Found saved state: 79be128b-a9e6-11e8-9763-02d4c371bfe
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; bas
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: Assign initial position for certification: 0, protocol
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: wsrep_sst_grab()
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: Start replication
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: 'wsrep-new-cluster' option used, bootstrapping the clu
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: Setting initial position to 79be128b-a9e6-11e8-9763-02
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [ERROR] WSREP: It may not be safe to bootstrap the cluster from this
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [ERROR] WSREP: wsrep::connect(gcomm://172.16.15.10,172.16.15.14) fai
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [ERROR] Aborting
Aug 27 16:32:21 PRPBX01 systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Aug 27 16:32:21 PRPBX01 systemd[1]: Failed to start MariaDB 10.1.35 database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman.../systemd-devel
--
-- Unit mariadb.service has failed.
--
-- The result is failed.
Aug 27 16:32:21 PRPBX01 systemd[1]: Unit mariadb.service entered failed state.
Aug 27 16:32:21 PRPBX01 systemd[1]: mariadb.service failed.
Aug 27 16:32:21 PRPBX01 polkitd[581]: Unregistered Authentication Agent for unix-process:15683:1113890 (system bus name :1.1201, object path /o
Aug 27 16:32:27 PRPBX01 postfix/smtp[15629]: connect to yourpbx.com[54.174.45.28]:25: Connection timed out
lines 2895-2917/2917 (END)
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: Found saved state: 79be128b-a9e6-11e8-9763-02d4c371bfea:-1, safe_to_bootstrap: 0
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 172.16.15.10; base_port = 4567; cert.log_conflicts
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: Assign initial position for certification: 0, protocol version: -1
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: wsrep_sst_grab()
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: Start replication
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: 'wsrep-new-cluster' option used, bootstrapping the cluster
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: Setting initial position to 79be128b-a9e6-11e8-9763-02d4c371bfea:0
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [ERROR] WSREP: It may not be safe to bootstrap the cluster from this node. It was not the last one to leave the cluster and may
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [ERROR] WSREP: wsrep::connect(gcomm://172.16.15.10,172.16.15.14) failed: 7
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [ERROR] Aborting
Aug 27 16:32:21 PRPBX01 systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Aug 27 16:32:21 PRPBX01 systemd[1]: Failed to start MariaDB 10.1.35 database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman.../systemd-devel
--
-- Unit mariadb.service has failed.
--
-- The result is failed.
Aug 27 16:32:21 PRPBX01 systemd[1]: Unit mariadb.service entered failed state.
Aug 27 16:32:21 PRPBX01 systemd[1]: mariadb.service failed.
Aug 27 16:32:21 PRPBX01 polkitd[581]: Unregistered Authentication Agent for unix-process:15683:1113890 (system bus name :1.1201, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale en_US.
Aug 27 16:32:27 PRPBX01 postfix/smtp[15629]: connect to yourpbx.com[54.174.45.28]:25: Connection timed out
lines 2895-2917/2917 (END)
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: Found saved state: 79be128b-a9e6-11e8-9763-02d4c371bfea:-1, safe_to_bootstrap: 0
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 172.16.15.10; base_port = 4567; cert.log_conflicts = no; debug = no; evs.
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: Assign initial position for certification: 0, protocol version: -1
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: wsrep_sst_grab()
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: Start replication
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: 'wsrep-new-cluster' option used, bootstrapping the cluster
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: Setting initial position to 79be128b-a9e6-11e8-9763-02d4c371bfea:0
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [ERROR] WSREP: It may not be safe to bootstrap the cluster from this node. It was not the last one to leave the cluster and may not contain all the up
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [ERROR] WSREP: wsrep::connect(gcomm://172.16.15.10,172.16.15.14) failed: 7
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [ERROR] Aborting
Aug 27 16:32:21 PRPBX01 systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Aug 27 16:32:21 PRPBX01 systemd[1]: Failed to start MariaDB 10.1.35 database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman.../systemd-devel
--
-- Unit mariadb.service has failed.
--
-- The result is failed.
Aug 27 16:32:21 PRPBX01 systemd[1]: Unit mariadb.service entered failed state.
Aug 27 16:32:21 PRPBX01 systemd[1]: mariadb.service failed.
Aug 27 16:32:21 PRPBX01 polkitd[581]: Unregistered Authentication Agent for unix-process:15683:1113890 (system bus name :1.1201, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale en_US.UTF-8) (disconnected f
Aug 27 16:32:27 PRPBX01 postfix/smtp[15629]: connect to yourpbx.com[54.174.45.28]:25: Connection timed out
lines 2895-2917/2917 (END)
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: Found saved state: 79be128b-a9e6-11e8-9763-02d4c371bfea:-1, safe_to_bootstrap: 0
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 172.16.15.10; base_port = 4567; cert.log_conflicts = no; debug = no; evs.
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: Assign initial position for certification: 0, protocol version: -1
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: wsrep_sst_grab()
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: Start replication
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: 'wsrep-new-cluster' option used, bootstrapping the cluster
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [Note] WSREP: Setting initial position to 79be128b-a9e6-11e8-9763-02d4c371bfea:0
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [ERROR] WSREP: It may not be safe to bootstrap the cluster from this node. It was not the last one to leave the cluster and may not contain all the up
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [ERROR] WSREP: wsrep::connect(gcomm://172.16.15.10,172.16.15.14) failed: 7
Aug 27 16:32:20 PRPBX01 mysqld[15776]: 2018-08-27 16:32:20 140274436954368 [ERROR] Aborting
Aug 27 16:32:21 PRPBX01 systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Aug 27 16:32:21 PRPBX01 systemd[1]: Failed to start MariaDB 10.1.35 database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman.../systemd-devel
--
-- Unit mariadb.service has failed.
--
-- The result is failed.
Aug 27 16:32:21 PRPBX01 systemd[1]: Unit mariadb.service entered failed state.
Aug 27 16:32:21 PRPBX01 systemd[1]: mariadb.service failed.
Aug 27 16:32:21 PRPBX01 polkitd[581]: Unregistered Authentication Agent for unix-process:15683:1113890 (system bus name :1.1201, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale en_US.UTF-8) (disconnected f
Aug 27 16:32:27 PRPBX01 postfix/smtp[15629]: connect to yourpbx.com[54.174.45.28]:25: Connection timed out

Could you please help me to troubleshoot this.

Thanks
 
Old 08-27-2018, 09:04 AM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 22,133

Rep: Reputation: 5929Reputation: 5929Reputation: 5929Reputation: 5929Reputation: 5929Reputation: 5929Reputation: 5929Reputation: 5929Reputation: 5929Reputation: 5929Reputation: 5929
Read the LQ Rules: do not post the same question in multiple forums. Duplicate reported.
 
Old 08-27-2018, 09:05 AM   #3
rtmistler
Moderator
 
Registered: Mar 2011
Location: MA, USA
Distribution: MINT Debian, Angstrom, SUSE, Ubuntu, Debian
Posts: 8,219
Blog Entries: 13

Rep: Reputation: 3608Reputation: 3608Reputation: 3608Reputation: 3608Reputation: 3608Reputation: 3608Reputation: 3608Reputation: 3608Reputation: 3608Reputation: 3608Reputation: 3608
Please post your thread in only one forum. Posting a single thread in the most relevant forum will make it easier for members to help you and will keep the discussion in one place. This thread is being closed because it is a duplicate.

https://www.linuxquestions.org/quest...on-4175637217/
 
  


Closed Thread


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Maria DB not starting for Galera first time execution manishdixitajm Linux - Software 5 08-27-2018 10:17 AM
Maria DB galera cluster backup maas187 Linux - Software 5 04-17-2018 04:55 PM
MariaDB Galera Cluster Starting Issue blakk Red Hat 2 03-05-2015 03:17 PM
Execution Time Sanjib_Sur Linux - Newbie 3 12-02-2008 02:20 PM
how to [time] the execution hq4ever Linux - General 8 07-03-2004 05:57 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 02:47 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration