MySQL Forums
Forum List  »  Replication

MySQL 5.6 startup issues with replication and server-id
Posted by: Sami Rantamäki
Date: May 07, 2014 11:52PM

Hi! I'm new here so please do forgive if this first post has some flaws. But, the situation shortly: I have a remote database with tons of measurement data, and I need to replicate that data for easier access. For historical reasons remote database is run on Ubuntu. Previous installation of Ubuntu (10.4, it had gone unnoticed) broke while updating and was in a hurry so installed 14.4 instead, with MySQL 5.6. Measurement environment is up and running, but for some reason I can't proceed with the replication process. And this might very well be an OS related issue as well, but suspected that I'd ask here first.

MySQL server (remote, Ubuntu 14.4, MySQL 5.6) starts without a glitch if nothing is touched, it starts without a glitch if I comment the line "bind-address 127.0.0.1". But, as soon as I uncomment the line "server-id=1" (local database, the destination of replication has server-id=2, it hasn't been touched), the server won't start.

There appears to be many warnings within error.log (/var/log/mysql/error.log) and some errors, but I'm guessing that the actual reason to prevent server from starting is that the TCP/IP-address is already in use? I've also tried to add "bind-address=ubuntu.server.ip.here" with the same results. It also seems like mysql is still being run (not stopping properly on sudo /etc/init.d/mysql stop/restart or sudo service mysql stop/restart), atleast sometimes.

Here is some output from the error.log from one of the times I tried the restart. That same list goes on and on, but as far as I can tell, it's always those same warnings and errors:

140507 14:56:04 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140507 14:56:49 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2014-05-07 14:56:49 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2014-05-07 14:56:49 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-05-07 14:56:49 31378 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)

2014-05-07 14:56:49 31378 [Warning] Buffered warning: Changed limits: table_cache: 431 (requested 2000)

2014-05-07 14:56:49 31378 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
2014-05-07 14:56:49 31378 [Note] Plugin 'FEDERATED' is disabled.
2014-05-07 14:56:49 31378 [ERROR] Function 'innodb' already exists
2014-05-07 14:56:49 31378 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2014-05-07 14:56:49 31378 [ERROR] Function 'federated' already exists
2014-05-07 14:56:49 31378 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2014-05-07 14:56:49 31378 [ERROR] Function 'blackhole' already exists
2014-05-07 14:56:49 31378 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2014-05-07 14:56:49 31378 [ERROR] Function 'archive' already exists
2014-05-07 14:56:49 31378 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2014-05-07 14:56:49 31378 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-05-07 14:56:49 31378 [Note] InnoDB: The InnoDB memory heap is disabled
2014-05-07 14:56:49 31378 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-05-07 14:56:49 31378 [Note] InnoDB: Compressed tables use zlib 1.2.8
2014-05-07 14:56:49 31378 [Note] InnoDB: Using Linux native AIO
2014-05-07 14:56:49 31378 [Note] InnoDB: Using CPU crc32 instructions
2014-05-07 14:56:49 31378 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-05-07 14:56:49 31378 [Note] InnoDB: Completed initialization of buffer pool
2014-05-07 14:56:49 31378 [Note] InnoDB: Highest supported file format is Barracuda.
2014-05-07 14:56:49 31378 [Note] InnoDB: 128 rollback segment(s) are active.
2014-05-07 14:56:49 31378 [Note] InnoDB: Waiting for purge to start
2014-05-07 14:56:49 31378 [Note] InnoDB: 5.6.17 started; log sequence number 1635381
^G/usr/sbin/mysqld: File '/var/log/mysql/mysql-bin.000027' not found (Errcode: 2 - No such file or directory)
2014-05-07 14:56:49 31378 [ERROR] Failed to open log (file '/var/log/mysql/mysql-bin.000027', errno 2)
2014-05-07 14:56:49 31378 [ERROR] Could not open log file
2014-05-07 14:56:49 31378 [ERROR] Can't init tc log
2014-05-07 14:56:49 31378 [ERROR] Aborting

2014-05-07 14:56:49 31378 [Note] Binlog end
2014-05-07 14:56:49 31378 [Note] Shutting down plugin 'partition'
2014-05-07 14:56:49 31378 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-05-07 14:56:49 31378 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-05-07 14:56:49 31378 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-05-07 14:56:49 31378 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-05-07 14:56:49 31378 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-05-07 14:56:49 31378 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-05-07 14:56:49 31378 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-05-07 14:56:49 31378 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-05-07 14:56:49 31378 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-05-07 14:56:49 31378 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-05-07 14:56:49 31378 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-05-07 14:56:49 31378 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-05-07 14:56:49 31378 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-05-07 14:56:49 31378 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-05-07 14:56:49 31378 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-05-07 14:56:49 31378 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-05-07 14:56:49 31378 [Note] Shutting down plugin 'INNODB_METRICS'
2014-05-07 14:56:49 31378 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-05-07 14:56:49 31378 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-05-07 14:56:49 31378 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-05-07 14:56:49 31378 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-05-07 14:56:49 31378 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-05-07 14:56:49 31378 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-05-07 14:56:49 31378 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-05-07 14:56:49 31378 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-05-07 14:56:49 31378 [Note] Shutting down plugin 'INNODB_CMP'
2014-05-07 14:56:49 31378 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-05-07 14:56:49 31378 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-05-07 14:56:49 31378 [Note] Shutting down plugin 'INNODB_TRX'
2014-05-07 14:56:49 31378 [Note] Shutting down plugin 'InnoDB'
2014-05-07 14:56:49 31378 [Note] InnoDB: FTS optimize thread exiting.
2014-05-07 14:56:49 31378 [Note] InnoDB: Starting shutdown...
2014-05-07 14:56:51 31378 [Note] InnoDB: Shutdown completed; log sequence number 1635391
2014-05-07 14:56:51 31378 [Note] Shutting down plugin 'BLACKHOLE'
2014-05-07 14:56:51 31378 [Note] Shutting down plugin 'ARCHIVE'
2014-05-07 14:56:51 31378 [Note] Shutting down plugin 'MyISAM'
2014-05-07 14:56:51 31378 [Note] Shutting down plugin 'CSV'
2014-05-07 14:56:51 31378 [Note] Shutting down plugin 'MRG_MYISAM'
2014-05-07 14:56:51 31378 [Note] Shutting down plugin 'MEMORY'
2014-05-07 14:56:51 31378 [Note] Shutting down plugin 'sha256_password'
2014-05-07 14:56:51 31378 [Note] Shutting down plugin 'mysql_old_password'
2014-05-07 14:56:51 31378 [Note] Shutting down plugin 'mysql_native_password'
2014-05-07 14:56:51 31378 [Note] Shutting down plugin 'binlog'
2014-05-07 14:56:51 31378 [Note] /usr/sbin/mysqld: Shutdown complete

140507 14:56:51 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140507 14:57:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2014-05-07 14:57:36 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2014-05-07 14:57:36 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-05-07 14:57:36 32138 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)

2014-05-07 14:57:36 32138 [Warning] Buffered warning: Changed limits: table_cache: 431 (requested 2000)

2014-05-07 14:57:36 32138 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
2014-05-07 14:57:36 32138 [Note] Plugin 'FEDERATED' is disabled.
2014-05-07 14:57:36 32138 [ERROR] Function 'innodb' already exists
2014-05-07 14:57:36 32138 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2014-05-07 14:57:36 32138 [ERROR] Function 'federated' already exists
2014-05-07 14:57:36 32138 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2014-05-07 14:57:36 32138 [ERROR] Function 'blackhole' already exists
2014-05-07 14:57:36 32138 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2014-05-07 14:57:36 32138 [ERROR] Function 'archive' already exists
2014-05-07 14:57:36 32138 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-05-07 14:57:36 32138 [Note] InnoDB: The InnoDB memory heap is disabled
2014-05-07 14:57:36 32138 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-05-07 14:57:36 32138 [Note] InnoDB: Compressed tables use zlib 1.2.8
2014-05-07 14:57:36 32138 [Note] InnoDB: Using Linux native AIO
2014-05-07 14:57:36 32138 [Note] InnoDB: Using CPU crc32 instructions
2014-05-07 14:57:36 32138 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-05-07 14:57:36 32138 [Note] InnoDB: Completed initialization of buffer pool
2014-05-07 14:57:36 32138 [Note] InnoDB: Highest supported file format is Barracuda.
2014-05-07 14:57:37 32138 [Note] InnoDB: 128 rollback segment(s) are active.
2014-05-07 14:57:37 32138 [Note] InnoDB: Waiting for purge to start
2014-05-07 14:57:37 32138 [Note] InnoDB: 5.6.17 started; log sequence number 1635391
2014-05-07 14:57:37 32138 [Note] Server hostname (bind-address): '*'; port: 3306
2014-05-07 14:57:37 32138 [Note] IPv6 is available.
2014-05-07 14:57:37 32138 [Note] - '::' resolves to '::';
2014-05-07 14:57:37 32138 [Note] Server socket created on IP: '::'.
2014-05-07 14:57:37 32138 [Note] Event Scheduler: Loaded 0 events
2014-05-07 14:57:37 32138 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.17-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)

I'm not that familiar with MySQL that could get a whole lot out of that. And this might very well be some newbie mistake, but this is the third day I'm fighting over this, and not even Google has been able to give any solution. So, please, help.

-Sami

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL 5.6 startup issues with replication and server-id
3627
May 07, 2014 11:52PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.