[MDEV-12410] Unable to Start Galera Node Created: 2017-03-30  Updated: 2020-08-25  Resolved: 2018-02-06

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.1.19, 10.1.22
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Oren Bissick (Inactive) Assignee: Sachin Setiya (Inactive)
Resolution: Incomplete Votes: 1
Labels: galera, need_feedback
Environment:

Centos 7



 Description   

This node ran out of storage so i deleted the contents of /var/lib/mysql/ in order to do full SST from one of the other nodes. but i keep getting the error below, i even upgraded to latest version 10.1.22 from 10.1.19 and still getting this error.

Mar 30 12:14:24 MariaDBClusterQA4 sh[9255]: Executing: /bin/sh -c 'systemctl unset-environment _WSREP_START_POSITION'
Mar 30 12:14:24 MariaDBClusterQA4 sh[9255]: Failed to determine peer security context: Protocol not available
Mar 30 12:14:24 MariaDBClusterQA4 sh[9255]: Got unexpected auxiliary data with level=1 and type=2
Mar 30 12:14:24 MariaDBClusterQA4 sh[9259]: Executing: /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'
Mar 30 12:14:25 MariaDBClusterQA4 sh[9259]: 2017-03-30 12:14:25 140595771279616 [Note] /usr/sbin/mysqld (mysqld 10.1.22-MariaDB) starting as process 9356 ...
Mar 30 12:14:29 MariaDBClusterQA4 sh[9259]: WSREP: Failed to start mysqld for wsrep recovery: '2017-03-30 12:14:25 140595771279616 [Note] InnoDB: Using mutexes to ref count buffer pool pages
Mar 30 12:14:29 MariaDBClusterQA4 sh[9259]: 2017-03-30 12:14:25 140595771279616 [Note] InnoDB: The InnoDB memory heap is disabled
Mar 30 12:14:29 MariaDBClusterQA4 sh[9259]: 2017-03-30 12:14:25 140595771279616 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Mar 30 12:14:29 MariaDBClusterQA4 sh[9259]: 2017-03-30 12:14:25 140595771279616 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
Mar 30 12:14:29 MariaDBClusterQA4 sh[9259]: 2017-03-30 12:14:25 140595771279616 [Note] InnoDB: Compressed tables use zlib 1.2.7
Mar 30 12:14:29 MariaDBClusterQA4 sh[9259]: 2017-03-30 12:14:25 140595771279616 [Note] InnoDB: Using Linux native AIO
Mar 30 12:14:29 MariaDBClusterQA4 sh[9259]: 2017-03-30 12:14:25 140595771279616 [Note] InnoDB: Using SSE crc32 instructions
Mar 30 12:14:29 MariaDBClusterQA4 sh[9259]: 2017-03-30 12:14:25 140595771279616 [Note] InnoDB: Initializing buffer pool, size = 5.3G



 Comments   
Comment by Claudio Nanni [ 2018-01-08 ]

This has been seen again on CentOS 7:

Failed to determine peer security context: Protocol not available
Got unexpected auxiliary data with level=1 and type=2

Comment by Sergei Golubchik [ 2018-01-08 ]

Could you provide more context please? E.g. what systemctl status mariadb.service say?

Generated at Thu Feb 08 07:57:30 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.