MySQL Error: Can’t perform query: Can’t open file: ‘xxxx.MYI’ (errno: 145)

May 31, 2008

I have timesheet.php and bugzilla 2.20 running on a linux box sharing same mysql db server.

When I tried logging-in to both the applications, I got following error.

Can't perform query: Can't open file: 'xxxxxx.MYI' (errno: 145)

You will face this error when your MySQL table is corrupted, and there are a few reasons for that:
1 – Server crash;
2 – Hardware failure;
3 – A MySQL write process was interrupted;

However you can fix this very easy with a simple query…

$ mysql
mysql> use database_name;
mysql> REPAIR TABLE table_name;

This will repair the specified table. The name of the table which is corrupted can be seen in the error as ‘xxxxx.MYI’.

Good luck.


Why GlassFish?

March 12, 2008

Few points to be considered while taking decision to adopt GlassFish Application Server.

  • GlassFish is an Open Source Application Server which implements the latest Java EE 5.0 specifications.
  • SUN is heavily supporting GlassFish Open Source Project.
  • GlassFish has very rich Administration Console like Weblogic and unlike JBoss.
  • After acquiring by Redhat, JBoss is not showing any momentum, whereas SUN is heavily supporting GlassFish Open Source Project, that is why GlassFish’s adoption is increasing as a best Open Source Application Server choice today.
  • GlassFish is very easy for developers to use, and increases the developer productivity when used in integration with Netbeans IDE.

Read GlassFish Adoption Stories and see how GlassFish is being used for enterprise applications.

I have been using GlassFish from last few months for my company’s client projects. Not yet deployed on Production.


JUnit Presentation on SlideShare

January 3, 2008

TDD Using PHP


Agileworld.net updated

December 25, 2007

I have updated my website this weekend. Check out: http://www.agileworld.net


Successful Person

November 5, 2007