• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Error Number: 126 "Incorrect key file for table '/mysql-temp/#sql_2e14_0.MYI'; try to repair it

#7
[eluser]ray023[/eluser]
Update:
setting pconnect to FALSE did not help; still got the error.

I turned on profiler and grab the 15 queries that were run and put them in a php file outside CI:


Code:
echo time().'<br>';
$link = mysql_connect('ray023.myhostingprovider.com', 'myLogin', 'myPassword');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
$db_selected = mysql_select_db('myDatabase', $link);
if (!$db_selected) {
    die ('Can\'t use myDatabase : ' . mysql_error());
}
echo 'connected<br>';

$sql_array = get_sql_array();

$counter = 0;
foreach ($sql_array as $query)
{
$result = mysql_query($query);
if (!$result)
  echo 'false<br>';
else
  echo 'query no:  '.++$counter.'  result count:'.mysql_num_rows($result).'<br>';
}

echo $counter.' queries run';


function get_sql_array()
{
$sql_01 = "SELECT *
    FROM (`ci_sessions`)
    WHERE `session_id` =  '6c0833dbd929ccf4e0b5816af2d48649'
    AND `user_agent` =  'Mozilla/5.0 (Windows NT 6.2; WOW64; rv:17.0) Gecko/20100101 Firefox/17.0'
    ";
$sql_02 = "SELECT
                        #MY_FIELDS
                    FROM
                        #MyTables
   ";
///...populate variables with my sql tables obtained from profiler
$sql_15 = "SELECT
                        #MY_FIELDS
                    FROM
                        #MyTables
   ";
  
        return array($sql_01,$sql_02,$sql_03,$sql_04,$sql_05,$sql_06,$sql_07,$sql_08,$sql_09,$sql_10,$sql_11,$sql_12,$sql_13,$sql_14,$sql_15);
}

I refreshed the screen 200 times and did not get the error...I went back to my "problem" controller, refreshed it 68 times and did NOT get the error Tongue

I currently have no idea what's going on. I'll just to have watch how often this happens and the conditions in which happens. I'll update if I get anywhere.


Messages In This Thread
Error Number: 126 "Incorrect key file for table '/mysql-temp/#sql_2e14_0.MYI'; try to repair it - by El Forum - 01-04-2013, 08:07 AM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.