Bug #43215 6 error codes changed from 5.1 to 6.0
Submitted: 26 Feb 2009 8:48 Modified: 16 Mar 2009 17:04
Reporter: Magnus Blåudd Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:6.0 OS:Any
Assigned to: Magnus Blåudd CPU Architecture:Any

[26 Feb 2009 8:48] Magnus Blåudd
Description:
There are 6 error codes in 6.0 that has changed from 5.1 GA. The errmsg.txt file in 6.0 need to be changed so that the error codes being used in 5.1 stays the same in 6.0

Three of the error codes have only been released as part of MySQL Cluster 6.3 and 6.4 so they need to be added to MySQL Server 6.0 to ensure they stay the same in the future.

How to repeat:
$diff mysql-5.1-telco-6.3/include/mysqld_error.h mysql-6.0/include/mysqld_error.h
@@ -623,10 +623,147 @@
 #define WARN_PLUGIN_DELETE_BUILTIN 1619
 #define WARN_PLUGIN_BUSY 1620
 #define ER_VARIABLE_IS_READONLY 1621
-#define ER_WARN_ENGINE_TRANSACTION_ROLLBACK 1622
-#define ER_SLAVE_HEARTBEAT_FAILURE 1623
-#define ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE 1624
-#define ER_NDB_REPLICATION_SCHEMA_ERROR 1625
-#define ER_CONFLICT_FN_PARSE_ERROR 1626
-#define ER_EXCEPTIONS_WRITE_ERROR 1627
-#define ER_ERROR_LAST 1627
<snip>
here follows new errorcodes for 6.0

Suggested fix:
Reorder error codes in 6.0 so that they stay the same as in 5.1
[26 Feb 2009 9:05] Davi Arnaut
If they are added to 6.0, they won't stay the same if we add new errors to 5.1
[26 Feb 2009 9:17] Magnus Blåudd
I thought we wouldn't add new error codes after GA? But if that is the case, we better take the three "new" ones and put them in 5.1 as well.
[26 Feb 2009 12:10] Sergei Golubchik
After GA we don't add new codes to the *previous* version, as this would've caused changed error numbers in the GA version.
[26 Feb 2009 14:02] Bugs System
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/67687

2809 Magnus Svensson	2009-02-26
      Bug#43215 6 error codes changed from 5.1 to 6.0
      modified:
        sql/share/errmsg.txt
[27 Feb 2009 9:09] Bugs System
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/67806

3087 Magnus Svensson	2009-02-27
      Bug#43215 6 error codes changed from 5.1 to 6.0
      modified:
        mysql-test/r/debug_sync.result
        mysql-test/r/locktrans_innodb.result
        mysql-test/r/locktrans_myisam.result
        mysql-test/suite/backup/r/backup_backupdir.result
        mysql-test/suite/backup/r/backup_db_grants.result
        mysql-test/suite/rpl/r/rpl_heartbeat.result
        mysql-test/suite/rpl/r/rpl_locktrans_falcon.result
        mysql-test/suite/rpl/r/rpl_locktrans_innodb.result
        mysql-test/suite/rpl/r/rpl_locktrans_myisam.result
        sql/share/errmsg.txt
[13 Mar 2009 19:07] Bugs System
Pushed into 5.1.33 (revid:joro@sun.com-20090313111355-7bsi1hgkvrg8pdds) (version source revid:staale.smedseng@sun.com-20090227160332-3k1kc0rao6y07cbp) (merge vers: 5.1.33) (pib:6)
[16 Mar 2009 9:45] Magnus Blåudd
The error codes released in 5.1(a few of them in MySQL Cluster) has now been reserved in 5.1 so that if we add any new error code in 5.1 they will come after the already released error codes. Error codes in 6.0 are still allowed to change since it's not been released yet.
[16 Mar 2009 17:04] Paul Dubois
No changelog entry needed.
[18 Mar 2009 13:16] Bugs System
Pushed into 6.0.11-alpha (revid:joro@sun.com-20090318122208-1b5kvg6zeb4hxwp9) (version source revid:ingo.struewing@sun.com-20090227125658-k4cj7xgkg1qkvmyt) (merge vers: 6.0.10-alpha) (pib:6)
[9 May 2009 16:41] Bugs System
Pushed into 5.1.34-ndb-6.2.18 (revid:jonas@mysql.com-20090508185236-p9b3as7qyauybefl) (version source revid:jonas@mysql.com-20090508100057-30ote4xggi4nq14v) (merge vers: 5.1.33-ndb-6.2.18) (pib:6)
[9 May 2009 17:39] Bugs System
Pushed into 5.1.34-ndb-6.3.25 (revid:jonas@mysql.com-20090509063138-1u3q3v09wnn2txyt) (version source revid:jonas@mysql.com-20090508175813-s6yele2z3oh6o99z) (merge vers: 5.1.33-ndb-6.3.25) (pib:6)
[9 May 2009 18:36] Bugs System
Pushed into 5.1.34-ndb-7.0.6 (revid:jonas@mysql.com-20090509154927-im9a7g846c6u1hzc) (version source revid:jonas@mysql.com-20090509073226-09bljakh9eppogec) (merge vers: 5.1.33-ndb-7.0.6) (pib:6)