General Error, need help urgently

[gargantua]

[SOLVED] General Error, need help urgently

Plesk 8.2.1 and centos5
with final upgrades for plesk

when im clicking on the name of the client in the "Client menu" i get this error:

MySQL query failed: Incorrect information in file: './psa/BackupsRunning.frm'
0: /usr/local/psa/admin/plib/common_func.php3:216
db_query(string 'SELECT sessionId FROM BackupsRunning WHERE param = 'BackupManagerFactory_client' AND val='3' limit 1')
1: /usr/local/psa/admin/plib/backup/BackupManagerFactory.php:231
BackupManagerFactoryTable::findByClient(integer '3')
2: /usr/local/psa/admin/plib/backup/BackupManagerFactory.php:174
BackupManagerFactory::getClientSessionId()
3: /usr/local/psa/admin/plib/backup/BackupCore.php:361
BackupClient->getBackupIdImpl()
4: /usr/local/psa/admin/plib/backup/BackupCore.php:54
BackupCore->__construct()
5: /usr/local/psa/admin/plib/backup/BackupCore.php:343
BackupClient->__construct(object of type Client)
6: /usr/local/psa/admin/plib/report/class.ClientReport.php:254
ClientReport::getBackupsRepositorySize(object of type Client)
7: /usr/local/psa/admin/plib/class.DomainsForm.php:228
DomainsForm->assign(object of type DomainsList, object of type Client, object of type Permissions)
8: /usr/local/psa/admin/htdocs/domains/domains.php3:231



If i create new client and clicking on it, i get exacly the same thing. Also i cant delete client:

MySQL query failed: Incorrect information in file: './psa/BackupsScheduled.frm'

what should i do?

 

[breun]

You might want to use mysqlcheck to check your databases for corruption. To check all databases on your system you can run the following command:

mysqlcheck --all-databases -uadmin -p`cat /etc/psa/.psa.shadow`

You can use the --repair option to repair databases.

 

[gargantua]

first of all - thank you for the answer

i checked through SSH --all-databases and there some errors:

---------------------
error : Incorrect information in file: './psa/BackupsObjects.frm'
psa.BackupsRunning
error : Incorrect information in file: './psa/BackupsRunning.frm'
psa.BackupsScheduled
error : Incorrect information in file: './psa/BackupsScheduled.frm'
psa.BackupsSettings
error : Incorrect information in file: './psa/BackupsSettings.frm'


error : Incorrect information in file: './psa/PMM.frm'
error : Incorrect information in file: './psa/PMMDefault.frm'

--------------------


--repair
did't work out for this errors


in the /etc/psa
i did't find such files

what should i do next?

 

[breun]

What do you expect to find in /etc/psa? The MySQL databases are not located there, but under /var/lib/mysql (at least on CentOS).

 

[gargantua]

i thought './psa/BackupsObjects.frm' is a file...

ok, anyway, what else can i do?

 

[breun]

It is a file. Databases are stored in files. But they're not stored under /etc/psa. The tables of the psa databases are stored in /var/lib/mysql/psa. But this is all not that relevant as you'll want to use the database tools to check and repair things.

You said repairing fixed the errors. What problems do you still have?

 

[gargantua]

i still have the same problem, and i sad that it DID'T help out

--repair log this:


---------------------
error : Incorrect information in file: './psa/BackupsObjects.frm'
psa.BackupsRunning
error : Incorrect information in file: './psa/BackupsRunning.frm'
psa.BackupsScheduled
error : Incorrect information in file: './psa/BackupsScheduled.frm'
psa.BackupsSettings
error : Incorrect information in file: './psa/BackupsSettings.frm'


error : Incorrect information in file: './psa/PMM.frm'
error : Incorrect information in file: './psa/PMMDefault.frm'

--------------------

 

[breun]

I'm sorry, I read did't as did instead of didn't.

I'd try restoring a backup (Plesk makes daily dumps of the psa database in /var/lib/psa/dumps).

 

[gargantua]

it worked out! thank YOU VERY MUCH!

uncompressed dump for the prev. day and evr. is ok

SOLVED