XFileSharing Pro - MySql Bug !

Message
Author
ALMGHARI
Posts: 50
Joined: Jun 07, 2008 5:37 pm

MySql Bug !

#1 Postby ALMGHARI » Jul 12, 2009 12:28 am

Hello,

Please, If I click on (Files) admin settings , I see this bug
?op=admin_files

Code: Select all

Software error:

Can't execute select:
Incorrect key file for table '/tmp/#sql_60db_0.MYI'; try to repair it at Modules/DataBase.pm line 76.

For help, please send mail to the webmaster (*********), giving this error message and the time and date of the error. 
How I can fix this problem ?

ankurs
Posts: 1054
Joined: Mar 10, 2009 2:34 am

#2 Postby ankurs » Jul 12, 2009 5:35 am

not sure but try repair your database

Eskick
Posts: 86
Joined: Mar 10, 2009 11:47 am

#3 Postby Eskick » Jul 12, 2009 3:39 pm

go to phpmyadmin if you have it, select all tables and repair it.

cuty
Posts: 103
Joined: Apr 14, 2009 11:20 pm

#4 Postby cuty » Jul 12, 2009 6:15 pm

ssh and do cd /var/lib/mysql/your database to repair

myISAchk.* -f

ALMGHARI
Posts: 50
Joined: Jun 07, 2008 5:37 pm

#5 Postby ALMGHARI » Jul 12, 2009 9:28 pm

Eskick wrote:go to phpmyadmin if you have it, select all tables and repair it.
I repaired all the tables by phpmyadmin
same the problem
cuty wrote:ssh and do cd /var/lib/mysql/your database to repair

myISAchk.* -f
root@server [/var/lib/mysql/arabsh_arabsh]# myISAchk.* -f
-bash: myISAchk.*: command not found

!

cuty
Posts: 103
Joined: Apr 14, 2009 11:20 pm

#6 Postby cuty » Jul 13, 2009 5:31 am

my bad its :

myisachk -f *.MYI

admin
Site Admin
Posts: 1839
Joined: Mar 22, 2006 12:32 pm

Re: MySql Bug !

#7 Postby admin » Jul 13, 2009 5:48 am

in mysql console:

Code: Select all

repair table <table name>;

ALMGHARI
Posts: 50
Joined: Jun 07, 2008 5:37 pm

#8 Postby ALMGHARI » Jul 14, 2009 12:56 am

cuty wrote:my bad its :

myisachk -f *.MYI
root@server [/var/lib/mysql/arabsh_arabsh]# myisachk -f *.MYI
-bash: myisachk: command not found

and after this
myisamchk -f *.MYI
same the problem

admin wrote:in mysql console:

Code: Select all

repair table <table name>;
I do not know
What's this ?

ALMGHARI
Posts: 50
Joined: Jun 07, 2008 5:37 pm

#9 Postby ALMGHARI » Jul 22, 2009 2:28 pm

UP !

ankurs
Posts: 1054
Joined: Mar 10, 2009 2:34 am

#10 Postby ankurs » Jul 22, 2009 2:35 pm

ALMGHARI wrote:UP !
wow it took u 1 week to fix ? was all this time, site down ?

ALMGHARI
Posts: 50
Joined: Jun 07, 2008 5:37 pm

#11 Postby ALMGHARI » Jul 24, 2009 12:49 am

The site is up
But the problem not fix
!!

User avatar
PilgrimX182
Posts: 2186
Joined: Mar 22, 2006 1:39 pm

#12 Postby PilgrimX182 » Jul 24, 2009 6:28 am

Contact your server support or hire server administrator.
This is your MySQL Problem, not XFS one.

cuty
Posts: 103
Joined: Apr 14, 2009 11:20 pm

#13 Postby cuty » Jul 24, 2009 1:08 pm

didnt know this was still not fixed, sorry.

1. Log on to the server command shell.

2. Stop the mysql service.

/etc/init.d/mysql stop

3. Change the path to the mysql db.

cd /var/lib/mysql/"your database name"

4. Issue any of the following commands.

myisamchk --recover *.MYI

myisamchk -f *.MYI

5. Start the mysql service.

/etc/init.d/mysql start


should be good then, if any questions PM or write back here.

ALMGHARI
Posts: 50
Joined: Jun 07, 2008 5:37 pm

#14 Postby ALMGHARI » Jul 24, 2009 10:09 pm

Thank you cuty, but not fixed

Code: Select all

root@server [/var/lib/mysql/arabsh_arabsh]# /etc/init.d/mysql stop 
Shutting down MySQL..                                      [  OK  ]
root@server [/var/lib/mysql/arabsh_arabsh]# myisamchk --recover *.MYI 
- recovering (with sort) MyISAM-table 'Comments.MYI'
Data records: 7661
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
          
---------

- recovering (with sort) MyISAM-table 'Files.MYI'
Data records: 1412832
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
          
---------

- recovering (with sort) MyISAM-table 'Folders.MYI'
Data records: 206
- Fixing index 1
- Fixing index 2
          
---------

- recovering (with sort) MyISAM-table 'IP2Files.MYI'
Data records: 109043
- Fixing index 1
- Fixing index 2
- Fixing index 3
          
---------

- recovering (with sort) MyISAM-table 'IP2Time.MYI'
Data records: 0
- Fixing index 1
          
---------

- recovering (with sort) MyISAM-table 'News.MYI'
Data records: 0
- Fixing index 1
          
---------

- recovering (with sort) MyISAM-table 'Payments.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
          
---------

- recovering (with sort) MyISAM-table 'Reports.MYI'
Data records: 249
- Fixing index 1
- Fixing index 2
- Fixing index 3
          
---------

- recovering (with sort) MyISAM-table 'Secure.MYI'
Data records: 909
- Fixing index 1
- Fixing index 2
          
---------

- recovering (with sort) MyISAM-table 'Servers.MYI'
Data records: 5
- Fixing index 1
          
---------

- recovering (with sort) MyISAM-table 'Sessions.MYI'
Data records: 817
- Fixing index 1
          
---------

- recovering (with sort) MyISAM-table 'Stats.MYI'
Data records: 130
- Fixing index 1
          
---------

- recovering (with sort) MyISAM-table 'Transactions.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
          
---------

- recovering (with sort) MyISAM-table 'Users.MYI'
Data records: 6797
- Fixing index 1
- Fixing index 2
root@server [/var/lib/mysql/arabsh_arabsh]# myisamchk -f *.MYI 
Checking MyISAM file: Comments.MYI
Data records:    7661   Deleted blocks:       0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check data record references index: 3
- check data record references index: 4
- check record links
          
---------

Checking MyISAM file: Files.MYI
Data records: 1412832   Deleted blocks:       0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check data record references index: 3
- check data record references index: 4
- check data record references index: 5
- check data record references index: 6
- check record links
          
---------

Checking MyISAM file: Folders.MYI
Data records:     206   Deleted blocks:       0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check record links
          
---------

Checking MyISAM file: IP2Files.MYI
Data records:  109043   Deleted blocks:       0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check data record references index: 3
- check record links
          
---------

Checking MyISAM file: IP2Time.MYI
Data records:       0   Deleted blocks:       0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1

---------

Checking MyISAM file: News.MYI
Data records:       0   Deleted blocks:       0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check record links
          
---------

Checking MyISAM file: Payments.MYI
Data records:       0   Deleted blocks:       0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check data record references index: 3

---------

Checking MyISAM file: Reports.MYI
Data records:     249   Deleted blocks:       0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check data record references index: 3
- check record links
          
---------

Checking MyISAM file: Secure.MYI
Data records:     909   Deleted blocks:       0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check record links
          
---------

Checking MyISAM file: Servers.MYI
Data records:       5   Deleted blocks:       0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check record links
          
---------

Checking MyISAM file: Sessions.MYI
Data records:     817   Deleted blocks:       0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1

---------

Checking MyISAM file: Stats.MYI
Data records:     130   Deleted blocks:       0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1

---------

Checking MyISAM file: Transactions.MYI
Data records:       0   Deleted blocks:       0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check record links
          
---------

Checking MyISAM file: Users.MYI
Data records:    6797   Deleted blocks:       0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check record links
root@server [/var/lib/mysql/arabsh_arabsh]# /etc/init.d/mysql start 
Starting MySQL...                                          [  OK  ]

Code: Select all

Software error:

Can't execute select:
Incorrect key file for table '/tmp/#sql_191b_0.MYI'; try to repair it at Modules/DataBase.pm line 76.

cuty
Posts: 103
Joined: Apr 14, 2009 11:20 pm

#15 Postby cuty » Jul 25, 2009 11:03 pm

yea somtimes that happens, myisamchk -f*.MYI right after , that'll will most likely solve it, somtimes running the --recover doesnt work.You have to use both or -f* command only.