MySQL Bugs: #17868: Incorrect error message when doing illegal configuration change 4->3 nodegroups

Bug #17868	Incorrect error message when doing illegal configuration change 4->3 nodegroups
Submitted:	2 Mar 2006 17:23	Modified:	9 Nov 2006 7:56
Reporter:	Nikolay Grishakin	Email Updates:
Status:	No Feedback
Category:	Server: Cluster	Severity:	S3 (Non-critical)
Version:	4.1->	OS:	Linux (Linux)
Assigned to:	li zhou	Target Version:

Description:
ndbd fails to start on the node after backup procedure. ndb error log has the following
information:

Message: Internal program error (failed ndbrequire) (Internal error, programming
ror message, please report a bug)
Error: 2341
Error data: ndbcntr/NdbcntrMain.cpp
Error object: NDBCNTR (Line: 882) 0x0000000a
Program: /home/ndbdev/ngrishakin/builds/libexec/ndbd
Pid: 17594
Trace: /space/run/ndb_5_trace.log.3
Version: Version 5.1.8 (beta)
***EOM***

The work around it is to delete all files in /space/run directory and then ndbd will
start successfully.

How to repeat:
1. I used 4 node groups cluster configuration (see 4nd.ini file) and populated TPCB
database using load_tpcb.pl script.
2. Start ndb_mgmd -f 4nd.ini on ndb15.
3. Start mysql server on ndb15: mysql_server start
4. Start ndbd on each machine ndb14, 13, 12, 11, 10, 09, 07, 15: ndbd -c ndb15:14000
5. Run load_tpcb.pl script on ndb15:
[ndbdev@ndb15 ngrishakin]$ perl load_tpcb.pl NDB15 3306 root BLANK ndb_mix

6. After it finishes run BACKUP on ndb15: ndb_mgm ndb15:14000 -e "start backup"

7. Shut down ndb_mgmd and mySQL server on ndb15 and ndbd on all nodes.

8. Start 3 node groups cluster on ndb15: ndb_mgmd -f 3nd.ini

9. Try to start ndbd on each node and it will fail with the error above.

All error log files and cluster configuration files are copied to ndb15:/data2/bug17868/.
Please let me know if more info. needed?

Hi Nikolay,

Your configuration change was not according to procedure.
And will fail with/without DD and with/without BACKUP.
It is supposed to fail.

When doing any change in config wrt nodes, you _must_ start with clean filesystem.

However the error message should be better,
  I guess that we never tried to decrease a cluster before...

Due to reasons mentioned above, I'm changing title and decreasing prio.

settting to P2 as it is an incorrect error message

sorry p3

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/12182

ChangeSet@1.2535, 2006-09-19 14:11:59+00:00, lzhou@dev3-138.dev.cn.tlan +1 -0
  BUG#17868 modify errorr message when doing illegal configuration change

Can't not reproduced in 5.1.12.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/12584

ChangeSet@1.2535, 2006-09-27 14:03:13+00:00, lzhou@dev3-138.dev.cn.tlan +1 -0
  BUG#17868 modify errorr message when doing illegal configuration change

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/12592

ChangeSet@1.2535, 2006-09-27 17:49:16+00:00, lzhou@dev3-138.dev.cn.tlan +1 -0
  BUG#17868 modify errorr message when doing illegal configuration change

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".