Hi,Oleg! On Aug 01, Oleg wrote:
Hello all,
I have troubles with backport some errors from 5.5 to 5.1 http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_q... http://dev.mysql.com/doc/refman/5.5/en/error-messages-server.html#error_er_q...
Last error in mysql 5.1.49 - 1640. If i just add ER_QUERY_CACHE_DISABLED --- a/sql/share/errmsg.txt 2010-07-09 16:35:08.000000000 +0400 +++ b/sql/share/errmsg.txt 2010-07-31 20:41:47.244015659 +0400 @@ -6213,3 +6213,7 @@ ER_DEBUG_SYNC_HIT_LIMIT eng "debug sync point hit limit reached" ger "Debug Sync Point Hit Limit erreicht" + +ER_QUERY_CACHE_DISABLED + eng "Query cache is disabled; restart the server with query_cache_type=1 to enable it" + then error code of ER_DEBUG_SYNC_HIT_LIMIT is 1641 (instead of 1651 what i need).
If i try: --- a/sql/share/errmsg.txt 2010-07-09 16:35:08.000000000 +0400 +++ b/sql/share/errmsg.txt 2010-07-31 20:41:47.244015659 +0400 @@ -6213,3 +6213,8 @@ ER_DEBUG_SYNC_HIT_LIMIT eng "debug sync point hit limit reached" ger "Debug Sync Point Hit Limit erreicht" + +start-error-number 1010 +ER_QUERY_CACHE_DISABLED + eng "Query cache is disabled; restart the server with query_cache_type=1 to enable it" +
then mysql doesn't start with error in bootstrap.log like: "mysqld can't srart because errmsg.sys has only 642 errors, when last error number is ...."
you need to run comp_err to recreate errmsg.sys files and also rebuild MySQL with the new mysqld_error.h file Regards, Sergei