ERROR 126 (HY000): Incorrect key file for table '/tmp/#sql_66b0_0.MYI'; try to repair it
Hi All,
I am getting following error when I am trying to run one stored procedure on
table which has 30 rows in it. Table Type id MyIsAM.
ERROR 126 (HY000): Incorrect key file for table '/tmp/#sql_66b0_0.MYI'; try to
repair it
How to debug this error? I mean I tried to increase tmp_table_Size parameter
but, it does not affect.
Proc is as follows :-
CREATE definer=`myus...@`localhost` PROCEDURE `SP_GetLogs`(InputToDate Date,
InputFromDate Date, InputFrom int, InputTo int)
DETERMINISTIC
BEGIN
Declare Count int;
Declare AvgVal float(10,2);
Drop Temporary Table
If Exists norep_Temp;
Create Temporary
Table norep_Temp
(
-- CountOfXML
int,
TaskName
Varchar(100),
MinFinalXML Varchar(1),
MaxFinalXML Varchar(1) -- ,
-- AvgOfXML
float(10,2)
);
If (InputToDate IS
NULL and InputFromDate IS NULL)
Then
SET @stmt =
Concat('Insert into norep_Temp(MinFinalXML)
Select distinct
FinalXML
From ClientLog
Where TaskName =
','"','Time required to complete task','"','
and FinalXML Between
1 and 10
Order By FinalXML ASC
LIMIT ',InputFrom,',',InputTo,';');
Select @stmt;
Prepare stmt1 From
@stmt;
Execute stmt1;
Deallocate Prepare
stmt1;
SET @stmt =
Concat('Insert into norep_Temp(MaxFinalXML)
Select Distinct
FinalXML
From ClientLog
Where TaskName =
','"','Time required to complete task','"','
Order By FinalXML
DESC LIMIT ',InputFrom,',',InputTo,';');
Prepare stmt1 From
@stmt;
Execute stmt1;
Deallocate prepare
stmt1;
Select AVG(FinalXML)
into AvgOfXML From ClientLog Where TaskName = 'Time required to complete
task';
Select Count(*) into
CountOfXML From ClientLog Where TaskName = 'Time required to complete
task';
-- Select Count(*) as
CountOfXML, MIN(MinFinalXML), MAX(MaxFinalXML), AvgOfXML From norep_Temp Order
By MinFinalXML, MaxFinalXML Limit 0,10;
Select
CountOfXML, MinFinalXML, MaxFinalXML, AvgOfXML From norep_Temp;
Drop Temporary Table If Exists Temp;
Create Temporary Table Temp
(
TaskName Varchar(100),
MinVal Varchar(100),
MaxVal Varchar(100) -- ,
);
If (InputToDate IS NULL and InputFromDate IS NULL)
Then
SET @stmt = Concat('Insert into Temp(MinVal)
Select distinct Val
>From MyLogs
Where TaskName = ','"','Time required to complete task','"','
and Val Between 1 and 10
Order By Val ASC LIMIT ',InputFrom,',',InputTo,';');
Prepare stmt1 From @stmt;
Execute stmt1;
Deallocate Prepare stmt1;
SET @stmt = Concat('Insert into Temp(MaxVal)
Select Distinct Val
>From MyLogs
Where TaskName = ','"','Time required to complete task','"','
Order By Val DESC LIMIT ',InputFrom,',',InputTo,';');
Prepare stmt1 From @stmt;
Execute stmt1;
Deallocate prepare stmt1;
Select AVG(Val) into AvgVal From MyLogs Where TaskName = 'Time required to
complete task';
Select Count(*) into Count From MyLogs Where TaskName = 'Time required to
complete task';
Select Count, MinVal, MaxVal, AvgVal From Temp;
END;
--Regards, Manasi Save
Re: ERROR 126 (HY000): Incorrect key file for table '/tmp/#sql_66b0_0.MYI'; try to repair it
This kind of error usually means you ran out of disk space on your
tmp_dir drive.
Walter
On Mon, May 31, 2010 at 13:30, Manasi Save
manasi.s...@artificialmachines.com wrote:
Hi All,
I am getting following error when I am trying to run one stored procedure on
table which has 30 rows in it. Table Type id MyIsAM.
ERROR 126 (HY000): Incorrect key file for table '/tmp/#sql_66b0_0.MYI'; try
to repair it
How to debug this error? I mean I tried to increase tmp_table_Size parameter
but, it does not affect.
Proc is as follows :-
CREATE definer=`myus...@`localhost` PROCEDURE `SP_GetLogs`(InputToDate Date,
InputFromDate Date, InputFrom int, InputTo int)
DETERMINISTIC
BEGIN
Declare Count int;
Declare AvgVal float(10,2);
Drop Temporary Table If Exists norep_Temp;
Create Temporary Table norep_Temp
(
-- CountOfXML int,
TaskName Varchar(100),
MinFinalXML Varchar(1),
MaxFinalXML Varchar(1) -- ,
-- AvgOfXML float(10,2)
);
If (InputToDate IS NULL and InputFromDate IS NULL)
Then
SET @stmt = Concat('Insert into norep_Temp(MinFinalXML)
Select distinct FinalXML
From ClientLog
Where TaskName = ','','Time required to complete task','','
and FinalXML Between 1 and 10
Order By FinalXML ASC LIMIT ',InputFrom,',',InputTo,';');
Select @stmt;
Prepare stmt1 From @stmt;
Execute stmt1;
Deallocate Prepare stmt1;
SET @stmt = Concat('Insert into norep_Temp(MaxFinalXML)
Select Distinct FinalXML
From ClientLog
Where TaskName = ','','Time required to complete task','','
Order By FinalXML DESC LIMIT ',InputFrom,',',InputTo,';');
Prepare stmt1 From @stmt;
Execute stmt1;
Deallocate prepare stmt1;
Select AVG(FinalXML) into AvgOfXML From ClientLog Where TaskName = 'Time
required to complete task';
Select Count(*) into CountOfXML From ClientLog Where TaskName = 'Time
required to complete task';
-- Select Count(*) as CountOfXML, MIN(MinFinalXML), MAX(MaxFinalXML),
AvgOfXML From norep_Temp Order By MinFinalXML, MaxFinalXML Limit 0,10;
Select CountOfXML, MinFinalXML, MaxFinalXML, AvgOfXML From norep_Temp;
Drop Temporary Table If Exists Temp;
Create Temporary Table Temp
(
TaskName Varchar(100),
MinVal Varchar(100),
MaxVal Varchar(100) -- ,
);
If (InputToDate IS NULL and InputFromDate IS NULL)
Then
SET @stmt = Concat('Insert into Temp(MinVal)
Select distinct Val
From MyLogs
Where TaskName = ','','Time required to complete task','','
and Val Between 1 and 10
Order By Val ASC LIMIT ',InputFrom,',',InputTo,';');
Prepare stmt1 From @stmt;
Execute stmt1;
Deallocate Prepare stmt1;
SET @stmt = Concat('Insert into Temp(MaxVal)
Select Distinct Val
From MyLogs
Where TaskName = ','','Time required to complete task','','
Order By Val DESC LIMIT ',InputFrom,',',InputTo,';');
Prepare stmt1 From @stmt;
Execute stmt1;
Deallocate prepare stmt1;
Select AVG(Val) into AvgVal From MyLogs Where TaskName = 'Time required to
complete task';
Select Count(*) into Count From MyLogs Where TaskName = 'Time required to
complete task';
Select Count, MinVal, MaxVal, AvgVal From Temp;
END;
--
Regards,
Manasi Save
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: ERROR 126 (HY000): Incorrect key file for table '/tmp/#sql_66b0_0.MYI'; try to repair it
Dear Walter,
Thanks for quick response.
But When I try to remove my tmp files related to mysql. I am not
allowed to remove them. How should I make more space in that case.
and We have allocated 2GB space for /tmp dir. and current size of
folder is showing as 60M. Still I am getting this error.
Any specific reason this could happen. Any other possible scenario.
Any input will be a great help.
Thanks in advance.
--
Regards,
Manasi Save
On Mon, 31 May 2010 14:29:16 0200, Walter Heck - OlinData.com wrote:
This kind of error usually means you ran out of disk space on your
tmp_dir drive.
Walter
On Mon, May 31, 2010 at 13:30, Manasi Save
manasi.s...@artificialmachines.com wrote:
Hi All,
I am getting following error when I am trying to run one stored
procedure on
table which has 30 rows in it. Table Type id MyIsAM.
ERROR 126 (HY000): Incorrect key file for table
'/tmp/#sql_66b0_0.MYI'; try
to repair it
How to debug this error? I mean I tried to increase
tmp_table_Size parameter
but, it does not affect.
Proc is as follows :-
CREATE definer=`myus...@`localhost` PROCEDURE
`SP_GetLogs`(InputToDate Date,
InputFromDate Date, InputFrom int, InputTo int)
DETERMINISTIC
BEGIN
Declare Count int;
Declare AvgVal float(10,2);
Drop Temporary Table If Exists norep_Temp;
Create Temporary Table norep_Temp
(
-- CountOfXML int,
TaskName Varchar(100),
MinFinalXML Varchar(1),
MaxFinalXML Varchar(1) -- ,
-- AvgOfXML float(10,2)
);
If (InputToDate IS NULL and InputFromDate IS NULL)
Then
SET @stmt = Concat('Insert into norep_Temp(MinFinalXML)
Select distinct FinalXML
From ClientLog
Where TaskName = ','','Time required to complete task','','
and FinalXML Between 1 and 10
Order By FinalXML ASC LIMIT ',InputFrom,',',InputTo,';');
Select @stmt;
Prepare stmt1 From @stmt;
Execute stmt1;
Deallocate Prepare stmt1;
SET @stmt = Concat('Insert into norep_Temp(MaxFinalXML)
Select Distinct FinalXML
From ClientLog
Where TaskName = ','','Time required to complete task','','
Order By FinalXML DESC LIMIT ',InputFrom,',',InputTo,';');
Prepare stmt1 From @stmt;
Execute stmt1;
Deallocate prepare stmt1;
Select AVG(FinalXML) into AvgOfXML From ClientLog Where TaskName = 'Time
required to complete task';
Select Count(*) into CountOfXML From ClientLog Where TaskName = 'Time
required to complete task';
-- Select Count(*) as CountOfXML, MIN(MinFinalXML), MAX(MaxFinalXML),
AvgOfXML From norep_Temp Order By MinFinalXML, MaxFinalXML Limit 0,10;
Select CountOfXML, MinFinalXML, MaxFinalXML, AvgOfXML From
norep_Temp;
Drop Temporary Table If Exists Temp;
Create Temporary Table Temp
(
TaskName Varchar(100),
MinVal Varchar(100),
MaxVal Varchar(100) -- ,
);
If (InputToDate IS NULL and InputFromDate IS NULL)
Then
SET @stmt = Concat('Insert into Temp(MinVal)
Select distinct Val
From MyLogs
Where TaskName = ','','Time required to complete task','','
and Val Between 1 and 10
Order By Val ASC LIMIT ',InputFrom,',',InputTo,';');
Prepare stmt1 From @stmt;
Execute stmt1;
Deallocate Prepare stmt1;
SET @stmt = Concat('Insert into Temp(MaxVal)
Select Distinct Val
From MyLogs
Where TaskName = ','','Time required to complete task','','
Order By Val DESC LIMIT ',InputFrom,',',InputTo,';');
Prepare stmt1 From @stmt;
Execute stmt1;
Deallocate prepare stmt1;
Select AVG(Val) into AvgVal From MyLogs Where TaskName = 'Time
required to
complete task';
Select Count(*) into Count From MyLogs Where TaskName = 'Time required to
complete task';
Select Count, MinVal, MaxVal, AvgVal From Temp;
END;
--
Regards,
Manasi Save
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=manasi.s...@artificialmachines.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
