Closed

mysql database

This project was awarded to AndrewUIB for $45 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
$30 - $50 USD
Total Bids
16
Project Description

it may require a db admin to fine tune your mysql database to prevent corrupt tables to determine what is the issue this problem is happening to often we need a solution Reparing the table worked correctly, although I am also seeing this in the logs.

root@server2 [/var/lib/mysql]# tail -f [url removed, login to view]
130614 9:07:59 [ERROR] /usr/sbin/mysqld: Incorrect key file for table './hoodbox_demandtest/[url removed, login to view]'; try to repair it
130614 9:07:59 [ERROR] Got an error from thread_id=30829, /home/rpmbuild/rpm-build/BUILD/[url removed, login to view]:121
130614 9:07:59 [ERROR] MySQL thread id 30829, OS thread handle 0x2abc7b855940, query id 533203 localhost hoodbox_dtest updating
DELETE
FROM `qsuxbs_session`
WHERE `time` < '1371217979'

I then got the following error when repairing the next table.

Table './hoodbox_demandtest/qsuxbs_session' is marked as crashed and should be repaired SQL=INSERT INTO `qsuxbs_session` (`session_id`, `client_id`, `time`) VALUES ('96435680e46dcecbad3a46eb79b752a7', 0, '1371220782')

+----------------------------------+--------+----------+--------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+----------------------------------+--------+----------+--------------------------------------------------------+
| hoodbox_demandtest.suxbs_session | repair | Error | Table 'hoodbox_demandtest.suxbs_session' doesn't exist |
| hoodbox_demandtest.suxbs_session | repair | status | Operation failed |
+----------------------------------+--------+----------+--------------------------------------------------------+

It appears that a table was deleted per the mysql error log above.

--
Andrew Zahn
Systems Administrator

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online