1016 - Can't open file: 'session.MYI' (errno: 145)

[Guest]

Hello:

 

As of last night, we've been running into some serious problems with our mysql database reporting errors quite frequently. I've searched around here and it seems that what I've been doing is what everyone else has had luck with. However, our situation is a bit different.

 

1016 - Can't open file: 'session.MYI' (errno: 145)

 

As a result of that error, I go into phpmyadmin and repair the sessions database file, and often times the who_online file is also corrupt, so I repair that file as well. Everything works shortly after that perfectly, however after about 30 minutes to an hour, the sessions.MYI file is corrupt again forcing me to have to repair it again.

 

Everyone once and a while, we will get this error:

 

1030 - Got error 127 from storage engine

 

As a result of that, I also repair the sessions and who_online file and all is well again. I am not aware of any changes with our host as of recently but am not sure where this repetitive problems lies within.

 

Any help would be GREATLY appreciated.

 

Thank you!

[oschellas]

This sort of crash is apparently often a result of insufficient disk space. So maybe you should check to see whether your account has maxed out on its allowed disk usage. Maybe talk to your hosting company to report the issue and get some assistance.

[jillbalkus]

Hello:

 

As of last night, we've been running into some serious problems with our mysql database reporting errors quite frequently. I've searched around here and it seems that what I've been doing is what everyone else has had luck with. However, our situation is a bit different.

 

1016 - Can't open file: 'session.MYI' (errno: 145)

 

As a result of that error, I go into phpmyadmin and repair the sessions database file, and often times the who_online file is also corrupt, so I repair that file as well. Everything works shortly after that perfectly, however after about 30 minutes to an hour, the sessions.MYI file is corrupt again forcing me to have to repair it again.

 

Everyone once and a while, we will get this error:

 

1030 - Got error 127 from storage engine

 

As a result of that, I also repair the sessions and who_online file and all is well again. I am not aware of any changes with our host as of recently but am not sure where this repetitive problems lies within.

 

Any help would be GREATLY appreciated.

 

Thank you!

 

I've started having the exact same problem today (never before) on a store that's been up and running for 2 years. I'm on Yahoo hosting (I know, I know, it's horrible). You?

[Guest]

I've started having the exact same problem today (never before) on a store that's been up and running for 2 years. I'm on Yahoo hosting (I know, I know, it's horrible). You?

WOW, Yahoo hosting? We are on yahoo hosting as well. I have opened an engineering ticket with yahoo, but haven't heard back from them yet. I will be sure to tell them that there are other customers that are having the same exact issues.

 

Our store has been running flawlessly for about 2 years as well.

 

It sounds to me as if it is definately a host issue now that you confirmed the same symptoms, but the problem is going to be getting yahoo to recognize that it is a host issue.

 

Perhaps we can get in contact and try and team up to get yahoo to realize the issue is on their end.

[jillbalkus]

Hey John,

 

Glad to know I'm not alone on this. Feel free to tell them that fabulalife.com is having the same issue.

 

After repairing the sessions and whos_online databases via phpmyadmin every 30 minutes to an hour (as you also described), I did go into the Yahoo Web Hosting Control Panel > Create & Update > MySQL database and repaired the database (after backing it up, of course). No problems since doing that two days ago (fingers crossed!).

 

Which site are you having troubles with, so I can let the Yahoo folks know if we still have issues?

 

Thanks!

[Guest]

So when the database was working properly, you went into the yahoo control panel and did a "Repair Database" that way and it has been problem free since then? I will try that right now. Thanks for the advice.

[jillbalkus]

Yes, when it was working properly, after fixing via phpmyadmin. Let me know how it goes!

[Guest]

No luck. Same error about an hour after doing a repair through the Yahoo control panel.

 

Did you call yahoo support at all? If so, what did they tell you?

[jillbalkus]

Maybe try doing the repair without fixing first? I tried to call Yahoo the other day but was on hold for 30 minutes and gave up.

[Guest]

Nothing is working. and no response from yahoo yet.

[[email protected]]

Having the same issues with my Yahoo site....talked with them 2 different times....no satisfactory response yet...this just started happening with me last week.

[jillbalkus]

Having the same issues with my Yahoo site....talked with them 2 different times....no satisfactory response yet...this just started happening with me last week.

 

My site is down again . . . I'll let ya'll know what Yahoo says.

[satish]

set session to go to mysql.This can be done thru configure.php

Also repair the session table if needed.

 

 

Satish

[jillbalkus]

set session to go to mysql.This can be done thru configure.php

Also repair the session table if needed.

 

Thanks for the reply, Satish.

 

I've done repair table sessions; multiple times and it only seems to fix the problem for 30 minutes just like John says is also happening with him.

 

My configure.php file is set to mysql (I think):

 

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

 

Any other thoughts?

[jillbalkus]

Still haven't had a chance to sit on hold with Yahoo yet, but I decided to dump my sessions and whos_online tables and restore their default values from the osCommerce installation. Here's what I did in phpmyadmin:

 

drop table if exists sessions;
create table sessions (
 sesskey varchar(32) not null ,
 expiry int(11) unsigned not null ,
 value text not null ,
 PRIMARY KEY (sesskey)
);

insert into sessions (sesskey, expiry, value) values ('ec9fa3c2c4a1da4d85735440e2646b7f', '1215577335', 'cart|O:12:\"shoppingCart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:5:\"cPath\";s:4:\"3_10\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}');
insert into sessions (sesskey, expiry, value) values ('323525dbf8f30f4fa7f4d31040f346d8', '1215577541', 'language|s:7:\"english\";languages_id|s:1:\"1\";selected_box|s:5:\"tools\";');
drop table if exists specials;
create table specials (
 specials_id int(11) not null auto_increment,
 products_id int(11) not null ,
 specials_new_products_price decimal(15,4) not null ,
 specials_date_added datetime ,
 specials_last_modified datetime ,
 expires_date datetime ,
 date_status_change datetime ,
 status int(1) default '1' not null ,
 PRIMARY KEY (specials_id)
);

drop table if exists whos_online;
create table whos_online (
 customer_id int(11) ,
 full_name varchar(64) not null ,
 session_id varchar(128) not null ,
 ip_address varchar(15) not null ,
 time_entry varchar(14) not null ,
 time_last_click varchar(14) not null ,
 last_page_url varchar(255) not null 
);

insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', 'ec9fa3c2c4a1da4d85735440e2646b7f', '24.98.65.172', '1215575895', '1215575895', '/catalog/movies-action-c-3_10.html');
drop table if exists zones;
create table zones (
 zone_id int(11) not null auto_increment,
 zone_country_id int(11) not null ,
 zone_code varchar(32) not null ,
 zone_name varchar(32) not null ,
 PRIMARY KEY (zone_id)
);

 

 

I did it this morning (About 6 hours ago) and no more errors today.

[satish]

The table was getting corrupted and the repairs were not working the way they should have.

 

You dropped the table and then recreated that sorted the problem.

 

Thanks for placing the details of what You did.

 

Satish

[EQP Solutions]

Hi all,

Just to let you know that I am having the same problem (1016 - Can't open file: 'sessions.myi') and I am also using Yahoo Hosting. Many thanks for your instructions. My problem is fixed for now by repairing the sessions table. I will wait and see how long this lasts! Please post any comments you get from Yahoo.

Thanks again.

Helen.

[llz925]

I'm getting a somewhat similar error and I've got Yahoo hosting too:

 

1030 - Got error 134 from storage engine

 

select value from sessions where sesskey = '866a52ea90d685cd23ad88009a7d3d3c' and expiry > '1220063657'

 

[TEP STOP]

 

 

Any idea on what I can do to fix this?? Any kind of help is most appreciated.

[satish]

Repair Your session table or delete and recreate session table.

make sure Your session is stored in mysql.

 

Satish

[~Kira]

I've started having the exact same problem today (never before) on a store that's been up and running for 2 years. I'm on Yahoo hosting (I know, I know, it's horrible). You?

 

Yes yahoo is horrible. Get a real hosting account with Cpanel and you'll be much better off.

[Guest]

Still haven't had a chance to sit on hold with Yahoo yet, but I decided to dump my sessions and whos_online tables and restore their default values from the osCommerce installation. Here's what I did in phpmyadmin:

 

drop table if exists sessions;
create table sessions (
 sesskey varchar(32) not null ,
 expiry int(11) unsigned not null ,
 value text not null ,
 PRIMARY KEY (sesskey)
);

insert into sessions (sesskey, expiry, value) values ('ec9fa3c2c4a1da4d85735440e2646b7f', '1215577335', 'cart|O:12:\"shoppingCart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:5:\"cPath\";s:4:\"3_10\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}');
insert into sessions (sesskey, expiry, value) values ('323525dbf8f30f4fa7f4d31040f346d8', '1215577541', 'language|s:7:\"english\";languages_id|s:1:\"1\";selected_box|s:5:\"tools\";');
drop table if exists specials;
create table specials (
 specials_id int(11) not null auto_increment,
 products_id int(11) not null ,
 specials_new_products_price decimal(15,4) not null ,
 specials_date_added datetime ,
 specials_last_modified datetime ,
 expires_date datetime ,
 date_status_change datetime ,
 status int(1) default '1' not null ,
 PRIMARY KEY (specials_id)
);

drop table if exists whos_online;
create table whos_online (
 customer_id int(11) ,
 full_name varchar(64) not null ,
 session_id varchar(128) not null ,
 ip_address varchar(15) not null ,
 time_entry varchar(14) not null ,
 time_last_click varchar(14) not null ,
 last_page_url varchar(255) not null 
);

insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', 'ec9fa3c2c4a1da4d85735440e2646b7f', '24.98.65.172', '1215575895', '1215575895', '/catalog/movies-action-c-3_10.html');
drop table if exists zones;
create table zones (
 zone_id int(11) not null auto_increment,
 zone_country_id int(11) not null ,
 zone_code varchar(32) not null ,
 zone_name varchar(32) not null ,
 PRIMARY KEY (zone_id)
);

 

 

I did it this morning (About 6 hours ago) and no more errors today.

 

 

I tried to create the table but I guess I just don't understand it fully . Can someone help walk me through this process.

Thanks

[Guest]

This code works great!. Thanks Jill. if you have problems just copy and paste the code into the SQL tab in phpmyadmin and your back up and running.

Sincerely,

Anna