[MDEV-9300] If --wsrep-new-cluster is specified and max_allowed_packet is not valid, cluster won't start Created: 2015-12-17  Updated: 2016-01-24  Resolved: 2016-01-24

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.1.9
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Federico Razzoli Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: need_feedback


 Description   

This command failed:

mysqld_safe --wsrep-new-cluster &

From the errlog:

151217 12:58:46 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql/
2015-12-17 12:58:46 140061782251456 [Warning] option 'max_allowed_packet': unsigned value 2147483648 adjusted to 1073741824
2015-12-17 12:58:46 140061782251456 [Warning] options --log-slow-admin-statements, --log-queries-not-using-indexes and --log-slow-slave-statements have no effect if --log_slow_queries is not set
2015-12-17 12:58:46 140061782251456 [Note] /usr/sbin/mysqld (mysqld 10.1.9-MariaDB-1~trusty-log) starting as process 4042 ...
2015-12-17 12:58:46 140061782251456 [Note] Using unique option prefix 'myisam_recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead.
2015-12-17 12:58:46 140061782251456 [Note] Using unique option prefix 'myisam_recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead.
2015-12-17 12:58:46 7f62acc717c0 InnoDB: Warning: Using innodb_locks_unsafe_for_binlog is DEPRECATED. This option may be removed in future releases. Please use READ COMMITTED transaction isolation level instead, see http://dev.mysql.com/doc/refman/5.6/en/set-transaction.html.
2015-12-17 12:58:46 140061782251456 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2015-12-17 12:58:46 140061782251456 [Note] InnoDB: The InnoDB memory heap is disabled
2015-12-17 12:58:46 140061782251456 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-12-17 12:58:46 140061782251456 [Note] InnoDB: Memory barrier is not used
2015-12-17 12:58:46 140061782251456 [Note] InnoDB: Compressed tables use zlib 1.2.8
2015-12-17 12:58:46 140061782251456 [Note] InnoDB: Using Linux native AIO
2015-12-17 12:58:46 140061782251456 [Note] InnoDB: Using CPU crc32 instructions
2015-12-17 12:58:46 140061782251456 [Note] InnoDB: Initializing buffer pool, size = 3.0G
2015-12-17 12:58:46 140061782251456 [Note] InnoDB: Completed initialization of buffer pool
2015-12-17 12:58:46 140061782251456 [Note] InnoDB: Highest supported file format is Barracuda.
2015-12-17 12:58:46 140061782251456 [Note] InnoDB: 128 rollback segment(s) are active.
2015-12-17 12:58:46 140061782251456 [Note] InnoDB: Waiting for purge to start
2015-12-17 12:58:47 140061782251456 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1641782
2015-12-17 12:58:47 140057453233920 [Note] InnoDB: Dumping buffer pool(s) not yet started
2015-12-17 12:58:47 140061782251456 [Note] Plugin 'FEEDBACK' is disabled.
2015-12-17 12:58:47 140061782251456 [Note] Server socket created on IP: '0.0.0.0'.
2015-12-17 12:58:47 140061782251456 [Note] Reading of all Master_info entries succeded
2015-12-17 12:58:47 140061782251456 [Note] Added new Master_info '' to hash table
2015-12-17 12:58:47 140061782251456 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.9-MariaDB-1~trusty-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution

What changed between the 2 restarts? I fixed this line in the config file:

max_allowed_packet = 2147483648



 Comments   
Comment by Elena Stepanova [ 2015-12-26 ]

f_razzoli,

What do you mean by the command failing? I don't see a failure in the provided log, it seems the server has started.
Also, which two restarts are you referring to? There is only one server start in the log.

Comment by Elena Stepanova [ 2016-01-24 ]

Please comment to re-open if you have further information on this issue.

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