URGENT: MySQL Error : Table './db_name/searchcore_text' is marked as crashed and last (automatic?) repair failed

**K a M a L** · Tue 31 Jul '18, 5:09am

It is not a big problem if you couldn't recover this table .. you can recreate it with query

Code:

CREATE TABLE `searchcore_text` (
  `searchcoreid` int(10) UNSIGNED NOT NULL,
  `keywordtext` mediumtext ,
  `title` varchar(254) NOT NULL DEFAULT ''
)

And Then rebuild Search index in admincp

**djbaxter** · Tue 31 Jul '18, 5:58am

Originally posted by K a M a L

It is not a big problem if you couldn't recover this table .. you can recreate it with query

Code:

CREATE TABLE `searchcore_text` (
`searchcoreid` int(10) UNSIGNED NOT NULL,
`keywordtext` mediumtext ,
`title` varchar(254) NOT NULL DEFAULT ''
)

And Then rebuild Search index in admincp

That sounds like bad advice to me.

**djbaxter** · Tue 31 Jul '18, 6:01am

Originally posted by aagcrc

I just got this error:

----- MySQL Error : Table './db_name/searchcore_text' is marked as crashed and last (automatic?) repair failed

So I start the repair feature under AdminCP -> Maintenance -> Repair/Optimize Tables, and being stuck for hours

Log in to your cPanel and use phpMyAdmin to repair the table.

Originally posted by aagcrc

When someone tries to do something in the forum, I also get this error:

---- MySQL Error : Can't create/write to file '/tmp/MYgPUht5' (Errcode: 28)

Disk space:

root@svr2 [/]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/md3 442G 45G 376G 11% /
tmpfs 7.8G 0 7.8G 0% /dev/shm
/dev/md0 477M 51M 401M 12% /boot
/usr/tmpDSK 4.0G 3.8G 0 100% /tmp

Temp folder gets full

root@svr2 [/]# mysqld --verbose --help | grep tmp
180731 7:55:27 [Note] mysqld (mysqld 5.5.52-cll) starting as process 25435 ...
180731 7:55:27 [Note] Plugin 'FEDERATED' is disabled.
--max-tmp-tables=# Maximum number of temporary tables a client can keep open
--slave-load-tmpdir=name
--tmp-table-size=# If an internal in-memory temporary table exceeds this
-t, --tmpdir=name Path for temporary files. Several paths may be specified,
max-tmp-tables 32
slave-load-tmpdir /tmp
tmp-table-size 268435456
tmpdir /tmp

Submit a support ticket to your host and get them to look into your server and database configuration.

**K a M a L** · Tue 31 Jul '18, 6:07am

Originally posted by djbaxter

That sounds like bad advice to me.

Okay

**aagcrc** · Tue 31 Jul '18, 7:06am

I have full control of the server with Root access
The forums was working and it just stopped....
How safe is to restart the mysql service to cancel and start the repair, would be safter via SSH Console?
Thank you\

**Wayne Luke** · Tue 31 Jul '18, 8:54am

Stopping and starting the MySQL Service without proper shutdown is probably what caused the table to crash to begin with. You should never restart the server while queries are running on it.

MySQL Error : Can't create/write to file '/tmp/MYgPUht5' (Errcode: 28)

This is probably your main issue. You're out of disk space where your temporary partition is. MySQL will not be able to operate until you provide more disk space on this partition. This partition should be at least three times the size of your largest table. If you want to play it safe, you should allocate five times your largest table to this partition.

You should repair your tables from the command line. You can find instructions on how to do this in the MySQL Manual.

MySQL :: MySQL 5.7 Reference Manual :: 2.10.12 Rebuilding or Repairing Tables or Indexes

https://dev.mysql.com/doc/refman/5.7/en/rebuilding-tables.html

Since you're the "Server Administrator" you should familiarize yourself with all software running on your server so you can handle these minor issues.

**aagcrc** · Tue 31 Jul '18, 12:06pm

Thanks everyone, you gave me some light and I fixed the issue. Basically I moved the MySQL temp folder to the root for now, and re-run the repair and that fixed the table. I did repair it from PHPmyAdmin

root@svr2 [~]# mysqld --verbose --help | grep tmp
180731 16:52:36 [Note] mysqld (mysqld 5.5.52-cll) starting as process 15795 ...
180731 16:52:37 [Note] Plugin 'FEDERATED' is disabled.
--max-tmp-tables=# Maximum number of temporary tables a client can keep open
--slave-load-tmpdir=name
--tmp-table-size=# If an internal in-memory temporary table exceeds this
-t, --tmpdir=name Path for temporary files. Several paths may be specified,
max-tmp-tables 32
slave-load-tmpdir /mysqltemp
tmp-table-size 268435456
tmpdir /mysqltemp

root@svr2 [~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/md3 442G 52G 369G 13% /
tmpfs 7.8G 0 7.8G 0% /dev/shm
/dev/md0 477M 51M 401M 12% /boot
/usr/tmpDSK 4.0G 137M 3.7G 4% /tmp

ANALYZE TABLE `searchcore_text`


db_name.searchcore_text	analyze	status	OK

Thank you

vBulletin 4 End of Life

URGENT: MySQL Error : Table './db_name/searchcore_text' is marked as crashed and last (automatic?) repair failed

URGENT: MySQL Error : Table './db_name/searchcore_text' is marked as crashed and last (automatic?) repair failed

Comment

Comment

Comment

Comment

Comment

Comment

Comment