[MDEV-4514] After increasing user name length mysql.db is reported broken and event scheduler does not start Created: 2013-05-12  Updated: 2013-05-13  Resolved: 2013-05-13

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: 5.5.31

Type: Bug Priority: Critical
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-4332 Increase username length from 16 char... Closed

 Description   

Test case:

--source include/not_embedded.inc
 
alter table mysql.user modify User char(80) binary not null default '';
alter table mysql.db modify User char(80) binary not null default '';
alter table mysql.tables_priv modify User char(80) binary not null default '';
alter table mysql.columns_priv modify User char(80) binary not null default '';
alter table mysql.procs_priv modify User char(80) binary not null default '';
alter table mysql.proc modify definer char(141) collate utf8_bin not null default '';
alter table mysql.event modify definer char(141) collate utf8_bin not null default '';
flush privileges;
 
--enable_reconnect
--append_file $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
restart
EOF
--shutdown_server 60
--source include/wait_until_connected_again.inc
 
set global event_scheduler = on;
select @@event_scheduler;
 
alter table mysql.user modify User char(16) binary not null default '';
alter table mysql.db modify User char(16) binary not null default '';
alter table mysql.tables_priv modify User char(16) binary not null default '';
alter table mysql.columns_priv modify User char(16) binary not null default '';
alter table mysql.procs_priv modify User char(16) binary not null default '';
alter table mysql.proc modify definer char(77) collate utf8_bin not null default '';
alter table mysql.event modify definer char(77) collate utf8_bin not null default '';
 
set global event_scheduler = off;

Output:

CURRENT_TEST: bug.t1
mysqltest: At line 19: query 'set global event_scheduler = on' failed: 1577: Cannot proceed because system tables used by Event Scheduler were found damaged at server start

Error log:

130512 17:22:23 [ERROR] Incorrect definition of table mysql.db: expected column 'User' at position 2 to have type char(16), found type char(80).
130512 17:22:23 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.

bzr version-info

revision-id: wlad@montyprogram.com-20130509212557-5cdelkdvf7t61062
revno: 3756
branch-nick: 5.5



 Comments   
Comment by Sergei Golubchik [ 2013-05-13 ]

pushed in 5.5

Generated at Thu Feb 08 06:57:01 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.