Skip to content

Instantly share code, notes, and snippets.

@daharon
Created February 21, 2012 22:38
Show Gist options
  • Select an option

  • Save daharon/1879525 to your computer and use it in GitHub Desktop.

Select an option

Save daharon/1879525 to your computer and use it in GitHub Desktop.
MySQL-Cluster SQL node will not come back up in upgrade from 7.1.18 to 7.2.4
root 7735 5419 0 15:58 pts/0 00:00:00 sudo service mysql start
root 7736 7735 0 15:58 pts/0 00:00:00 /bin/sh /sbin/service mysql start
root 7741 7736 0 15:58 pts/0 00:00:00 /bin/sh /etc/init.d/mysql start
root 7747 7741 0 15:58 pts/0 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/sql2.office.sazze.com.pid
mysql 8031 7747 12 15:58 pts/0 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/sql2.office.sazze.com.err --pid-file=/var/lib/mysql/sql2.office.sazze.com.pid --port=3306
2012-02-21 15:51:52 [MgmtSrvr] INFO -- Nodeid 4 allocated for API at 10.1.1.27
2012-02-21 15:51:52 [MgmtSrvr] INFO -- Node 4: mysqld --server-id=0
2012-02-21 15:51:53 [MgmtSrvr] INFO -- Node 2: Node 4 Connected
2012-02-21 15:51:53 [MgmtSrvr] INFO -- Node 3: Node 4 Connected
2012-02-21 15:51:53 [MgmtSrvr] INFO -- Node 2: Node 4: API mysql-5.5.19 ndb-7.2.4
2012-02-21 15:51:53 [MgmtSrvr] INFO -- Node 3: Node 4: API mysql-5.5.19 ndb-7.2.4
2012-02-21 15:51:54 [MgmtSrvr] ALERT -- Node 2: Node 4 Disconnected
2012-02-21 15:51:54 [MgmtSrvr] INFO -- Node 3: Communication to Node 4 closed
2012-02-21 15:51:54 [MgmtSrvr] INFO -- Node 2: Communication to Node 4 closed
2012-02-21 15:51:54 [MgmtSrvr] ALERT -- Node 3: Node 4 Disconnected
2012-02-21 15:51:57 [MgmtSrvr] INFO -- Node 3: Communication to Node 4 opened
2012-02-21 15:51:57 [MgmtSrvr] INFO -- Node 2: Communication to Node 4 opened
#
# Shutting down 7.1.18
#
120221 14:25:36 [Note] /usr/sbin/mysqld: Normal shutdown
120221 14:25:36 [Note] Event Scheduler: Purging the queue. 0 events
120221 14:25:36 [Note] Stopping Cluster Utility thread
120221 14:25:36 [Note] Stopping Cluster Index Stats thread
120221 14:25:36 [Note] Stopping Cluster Binlog
120221 14:25:36 [Note] Stopping Cluster Index Statistics thread
120221 14:25:37 InnoDB: Starting shutdown...
120221 14:25:38 InnoDB: Shutdown completed; log sequence number 0 44243
120221 14:25:38 [Note] /usr/sbin/mysqld: Shutdown complete
120221 14:25:38 mysqld_safe mysqld from pid file /var/lib/mysql/sql2.office.example.com.pid ended
#
# Starting up 7.2.4
#
120221 14:28:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120221 14:28:40 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead.
120221 14:28:40 [Note] Plugin 'FEDERATED' is disabled.
120221 14:28:40 InnoDB: The InnoDB memory heap is disabled
120221 14:28:40 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120221 14:28:40 InnoDB: Compressed tables use zlib 1.2.3
120221 14:28:40 InnoDB: Using Linux native AIO
120221 14:28:40 InnoDB: Initializing buffer pool, size = 128.0M
120221 14:28:40 InnoDB: Completed initialization of buffer pool
120221 14:28:40 InnoDB: highest supported file format is Barracuda.
InnoDB: 127 rollback segment(s) active.
120221 14:28:41 InnoDB: Waiting for the background threads to start
120221 14:28:42 InnoDB: 1.1.8 started; log sequence number 44243
120221 14:28:42 [Note] NDB: NodeID is 4, management server '10.1.1.26:1186'
120221 14:28:43 [Note] NDB[0]: NodeID: 4, all storage nodes connected
120221 14:28:43 [Warning] NDB: server id set to zero - changes logged to bin log with server id zero will be logged with another server id by slave mysqlds
120221 14:28:43 [Note] Starting Cluster Binlog Thread
120221 14:28:46 mysqld_safe mysqld from pid file /var/lib/mysql/sql2.office.example.com.pid ended
#
# Startup failed.
#
#
# Trying again.
#
120221 14:30:54 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120221 14:30:54 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead.
120221 14:30:54 [Note] Plugin 'FEDERATED' is disabled.
120221 14:30:54 InnoDB: The InnoDB memory heap is disabled
120221 14:30:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120221 14:30:54 InnoDB: Compressed tables use zlib 1.2.3
120221 14:30:54 InnoDB: Using Linux native AIO
120221 14:30:54 InnoDB: Initializing buffer pool, size = 128.0M
120221 14:30:54 InnoDB: Completed initialization of buffer pool
120221 14:30:54 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
120221 14:30:54 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
120221 14:30:55 InnoDB: Waiting for the background threads to start
120221 14:30:56 InnoDB: 1.1.8 started; log sequence number 1589349
120221 14:30:56 [Note] NDB: NodeID is 4, management server '10.1.1.26:1186'
120221 14:30:56 [Note] NDB[0]: NodeID: 4, all storage nodes connected
120221 14:30:56 [Warning] NDB: server id set to zero - changes logged to bin log with server id zero will be logged with another server id by slave mysqlds
120221 14:30:56 [Note] Starting Cluster Binlog Thread
120221 14:30:58 mysqld_safe mysqld from pid file /var/lib/mysql/sql2.office.example.com.pid ended
@daharon
Copy link
Author

daharon commented Feb 21, 2012

The management and data nodes have already been successfully upgraded.
The SQL node is giving me trouble, though...

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment