Bug #62379 Error Code : 1548 Cannot load from mysql.proc. The table is probably corrupted
Submitted: 8 Sep 2011 5:04 Modified: 8 Sep 2011 9:47
Reporter: Zahid Quadri Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.1.46 OS:Microsoft Windows (xp)
Assigned to: CPU Architecture:Any
Tags: cannot create trigger, error 1548, mysql bug, open source, table corrupted, trirgger issue

[8 Sep 2011 5:04] Zahid Quadri
Description:
Error Code : 1548
Cannot load from mysql.proc. The table is probably corrupted

i am trying to create a trigger but its giving above error on microsoft windows machine can any one please provide me the solution. i need it urgently. im trying to run mysql_upgrade but its not working. 

can any one tell me how to run mysql_upgrade on windows machine.

How to repeat:
there was no privilege for root user to create trigger i hav provided privilege to root user to create trigger and after that restarted mysql server. then tried to create trigger since then it is giving the same problem.
[8 Sep 2011 6:26] Valeriy Kravchuk
What exact version, 5.1.x, do you use? Had you upgraded from some older version and skipped running mysql_upgrade?

Please, send the output of:

show create table mysql.proc\G
[8 Sep 2011 6:36] Zahid Quadri
i m using mysql 5.1.46

i havent upgraded mysql it was a fresh installation.

here is the output 

mysql> show create table mysql.proc\G;
*************************** 1. row ***************************
       Table: proc
Create Table: CREATE TABLE `proc` (
  `db` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `name` char(64) NOT NULL DEFAULT '',
  `type` enum('FUNCTION','PROCEDURE') NOT NULL,
  `specific_name` char(64) NOT NULL DEFAULT '',
  `language` enum('SQL') NOT NULL DEFAULT 'SQL',
  `sql_data_access` enum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_
DATA') NOT NULL DEFAULT 'CONTAINS_SQL',
  `is_deterministic` enum('YES','NO') NOT NULL DEFAULT 'NO',
  `security_type` enum('INVOKER','DEFINER') NOT NULL DEFAULT 'DEFINER',
  `param_list` blob NOT NULL,
  `returns` longblob NOT NULL,
  `body` longblob NOT NULL,
  `definer` char(77) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMES
TAMP,
  `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `sql_mode` set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE',
'NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','PO
STGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO
_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLAS
H_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_
DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE
_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH')
 NOT NULL DEFAULT '',
  `comment` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `character_set_client` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NU
LL,
  `collation_connection` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NU
LL,
  `db_collation` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `body_utf8` longblob,
  PRIMARY KEY (`db`,`name`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stored Procedures'
1 row in set (0.00 sec)

ERROR:
No query specified
[8 Sep 2011 6:48] Zahid Quadri
.
[8 Sep 2011 6:56] Valeriy Kravchuk
Please, send the output of

check table mysql.proc extended;
[8 Sep 2011 7:09] Zahid Quadri
its working now i fixed it...thanks for your valuable support.

i run mysql_upgrade -u root -p

it ran successfully. and my problem also got solved
[30 Dec 2011 8:36] Paul Duffield
My joomla 1.7 databases would not backup or install components and there was an error message saying that mysql.proc was probably corrupted when trying to back up sites in virtualmin. I ran the fix suggested here and two days of stress and heart ache were solved!

I am not an expert on this by any means but it demonstrated yet again to me the value of people like you in these forums. Thanks again I will now be able to sleep at night again with 50 websites functional again :-)
[23 Aug 2012 6:07] damodaram r
I am getting error at "CURRENT_TIMES" in proc creation
please suggest me how can i do that