List:General Discussion« Previous MessageNext Message »
From:Adarsh Sharma Date:January 2 2012 10:17am
Subject:ERROR 1307 (HY000) at line 31: Failed to CREATE PROCEDURE
View as plain text  
Dear all,

I am running Mysql on a Linux System ( Caos ).
Today when I am trying to create a procedure in it, I m facing the below 
issue :

ERROR 1307 (HY000) at line 31: Failed to CREATE PROCEDURE

My OS version is :
Systemr-5:~ # cat /etc/issue
Welcome to SUSE Linux Enterprise Server 10 SP1 (x86_64) - Kernel \r (\l).

Kernel Version is :  Server-5:~ # uname -a
Linux 5 2.6.16.46-0.12-smp #1 SMP Thu May 17 14:00:09 UTC 2007 x86_64 
x86_64 x86_64 GNU/Linux

Mysql Version is very old :
System-5:~ # mysql --version
mysql  Ver 14.12 Distrib 5.0.45, for unknown-linux-gnu (x86_64) using 
readline 5.0

After some research ,I know this error occurs due to loading mysql data 
in previous version of mysql from new one.
I had this issue in the past & I solved the issue by mysql_upgrade 
command but this time the issue still persists.

Any suggestions for solving the issue.


Thanks in Advance.


Thread
ERROR 1307 (HY000) at line 31: Failed to CREATE PROCEDUREAdarsh Sharma2 Jan
  • Re: ERROR 1307 (HY000) at line 31: Failed to CREATE PROCEDUREhsv3 Jan