Random ssl key.pem cannot be used - invalid argument

Bug #1390603 reported by Joe J
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Galera
New
Undecided
Unassigned

Bug Description

+++++++++++++++++++++++++++Basic Info++++++++++++++++++++++++++++++++++++
This issue randomly occurs and is not reproducible. This is from a server that had been
up from several days and replicating without error. Normally when this happens a re-install
of both the MariaDB and Galera are required. I have not figured out how to p[prevent a re-install.

+++++++++++++++++++++++++++Mysql Config Info++++++++++++++++++++++++++++++
[mysqld]
query_cache_size=0
binlog_format=ROW
default_storage_engine=innodb
innodb_autoinc_lock_mode=2
innodb_locks_unsafe_for_binlog=1
innodb_doublewrite=1
innodb_log_file_size=5M
# wsrep provider configuration: basic wsrep options
wsrep_provider=/usr/lib/galera/libgalera_smm.so
wsrep_provider_options="gcache.size=256M; gcache.page_size=128M"
wsrep_cluster_address=gcomm://REDACTED
#wsrep_cluster_address=gcomm://
wsrep_cluster_name=MariaDB_Cluster
wsrep_node_address="fl-db01"
wsrep_node_name="fl-db01"
wsrep_sst_method=xtrabackup
wsrep_sst_auth="REDACTED:REDACTED"
wsrep_provider_options=socket.ssl_cert=/etc/mysql/ssl/cert.pem;socket.ssl_key=/etc/mysql/ssl/key.pem
# additional wsrep settings
wsrep_node_incoming_address=REDACTED
wsrep_sst_receive_address=REDACTED
wsrep_slave_threads=16

+++++++++++++++++++++++++++SSL Directory Permissions++++++++++++++++++++++++
XXXXXX@fl-db01:/etc/mysql/ssl$ ls -lah
total 16K
drw-r-xr-x 2 mysql mysql 4.0K Nov 1 05:08 .
drwxr-xr-x 4 root root 4.0K Nov 1 05:04 ..
-rw-r-xr-x 1 mysql mysql 908 Nov 1 05:08 cert.pem
-rw-r-xr-x 1 mysql mysql 916 Nov 1 05:08 key.pem

+++++++++++++++++++++++++++Galera/MariaDB Version Info++++++++++++++++++++++++++++++
Galera 25.3.5-wheezy(rXXXX) by Codership
MariaDB 5.5

+++++++++++++++++++++++++++Syslog Mysql Log output++++++++++++++++++++++++++

Nov 7 19:46:02 fl-db01 mysqld: eight = 1; protonet.bac
Nov 7 19:46:02 fl-db01 mysqld: 141107 19:46:02 [Note] WSREP: Service thread queue flushed.
Nov 7 19:46:02 fl-db01 mysqld: 141107 19:46:02 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
Nov 7 19:46:02 fl-db01 mysqld: 141107 19:46:02 [Note] WSREP: wsrep_sst_grab()
Nov 7 19:46:02 fl-db01 mysqld: 141107 19:46:02 [Note] WSREP: Start replication
Nov 7 19:46:02 fl-db01 mysqld: 141107 19:46:02 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
Nov 7 19:46:02 fl-db01 mysqld: 141107 19:46:02 [Note] WSREP: protonet asio version 0
Nov 7 19:46:02 fl-db01 mysqld: 141107 19:46:02 [Note] WSREP: Using CRC-32C (optimized) for message checksums.
Nov 7 19:46:02 fl-db01 mysqld: 141107 19:46:02 [Note] WSREP: initializing ssl context
Nov 7 19:46:02 fl-db01 mysqld: 141107 19:46:02 [ERROR] WSREP: could not use private key file '/etc/mysql/ssl/key.pem': Invalid argument
Nov 7 19:46:02 fl-db01 mysqld: 141107 19:46:02 [ERROR] WSREP: Invalid argument
Nov 7 19:46:02 fl-db01 mysqld: 141107 19:46:02 [ERROR] WSREP: wsrep::connect() failed: 7
Nov 7 19:46:02 fl-db01 mysqld: 141107 19:46:02 [ERROR] Aborting
Nov 7 19:46:02 fl-db01 mysqld:
Nov 7 19:46:02 fl-db01 mysqld: 141107 19:46:02 [Note] WSREP: Service disconnected.
Nov 7 19:46:03 fl-db01 mysqld: 141107 19:46:03 [Note] WSREP: Some threads may fail to exit.
Nov 7 19:46:03 fl-db01 mysqld: 141107 19:46:03 [Note] /usr/sbin/mysqld: Shutdown complete
Nov 7 19:46:03 fl-db01 mysqld:
Nov 7 19:46:03 fl-db01 mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Nov 7 19:46:30 fl-db01 /etc/init.d/mysql[9658]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Nov 7 19:46:30 fl-db01 /etc/init.d/mysql[9658]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Nov 7 19:46:30 fl-db01 /etc/init.d/mysql[9658]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)'
Nov 7 19:46:30 fl-db01 /etc/init.d/mysql[9658]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Nov 7 19:46:30 fl-db01 /etc/init.d/mysql[9658]:
ah_dev@fl-db01:/var/log$
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.