Bug #49160 ndb_error_reporter seems to be broken in 7.0

• Submitted: 27 Nov 2009 10:46
• Modified: 7 Dec 2009 12:43
• Reporter: Oli Sennhauser
• Status: Duplicate
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S2 (Serious)
• Version: mysql-5.1-telco-7.0
• OS: Any
• Assigned to: Assigned Account
• CPU Architecture: Any
• Tags: ndb_error_reporter

[27 Nov 2009 10:46] Oli Sennhauser

Description:
ndb_error_reporter seems to not work anymore with 7.0.7/.9:

How to repeat:
ndb_error_reporter /home/mysql/cluster/7.0.9/config.ini
 Copying data from node 2009-11-27
Unknown suffix '-' used for variable 'id' (value '2009-11-27')
ndb_config: Error while setting value '2009-11-27' to 'id'
Unknown suffix '-' used for variable 'id' (value '2009-11-27')
ndb_config: Error while setting value '2009-11-27' to 'id'
cp: cannot stat `:/ndb_2009-11-27*': No such file or directory
 Copying data from node 11:45:21
Unknown suffix ':' used for variable 'id' (value '11:45:21')
ndb_config: Error while setting value '11:45:21' to 'id'
Unknown suffix ':' used for variable 'id' (value '11:45:21')
ndb_config: Error while setting value '11:45:21' to 'id'
cp: cannot stat `:/ndb_11:45:21*': No such file or directory
 Copying data from node [ndb_config]
Unknown suffix '[' used for variable 'id' (value '[ndb_config]')
ndb_config: Error while setting value '[ndb_config]' to 'id'

It seems like it starts with the time stamp of the configuration file.

Suggested fix:
just make it work again.

[27 Nov 2009 10:46] Oli Sennhauser

config.ini causing troubles

Attachment: config.ini (application/octet-stream, text), 798 bytes.

[30 Nov 2009 7:14] Bernd Ocklin

ndb_config creates warnings about arbitrator sitting on ndbd machine. Warnings are not handled by ndb_error_reporter. yes, ndb_error_reporter should still work even with broken config.ini

[30 Nov 2009 7:30] Bernd Ocklin

Quick fix to error reporter:

=== modified file 'storage/ndb/tools/ndb_error_reporter'
--- storage/ndb/tools/ndb_error_reporter	2009-02-12 08:29:00 +0000
+++ storage/ndb/tools/ndb_error_reporter	2009-11-30 07:29:57 +0000
@@ -30,13 +30,14 @@
     exit(1);
 }
 
-my @nodes= split ' ',`ndb_config --config-file=$ARGV[0] --nodes --query=id --type=ndbd`;
+my @nodes= split ' ',`ndb_config --config-file=$ARGV[0] --nodes --query=id --type=ndbd | tail -1`;
 
-push @nodes, split ' ',`ndb_config --config-file=$ARGV[0] --nodes --query=id --type=ndb_mgmd`;
+push @nodes, split ' ',`ndb_config --config-file=$ARGV[0] --nodes --query=id --type=ndb_mgmd | tail -1`;

[30 Nov 2009 13:39] Hartmut Holzgraefe

The real problem is that up to 6.3.x the warnings are written to stderr (as expected) but starting with 7.0.x are written to stdout instead, see:

  http://bugs.mysql.com/44689

Fix 44689 and you get this one fixed for free ...

[7 Dec 2009 12:43] Jonas Oreland

closed as duplicate of bug#44689
(as fix for that also fixes this)