Page 1 of 2
Upgrading Plesk 9.5.4 MySQL
Posted: Sun May 01, 2011 6:46 am
by KrazyBob
OK. I used the atomic installer and
Upgrade was deliberate since Update caused the same problem I'm about to identify.
I ended up with PHP 5.3.6 and MySQL 5.1.x. Since I am on Plesk I issued
and ended up with
Code: Select all
psa.siteapppackages_apscategories OK
psa.slave_params OK
psa.slaves OK
psa.smtp_poplocks OK
psa.spamfilter OK
psa.spamfilter_preferences
error : Table upgrade required. Please do "REPAIR TABLE `spamfilter_preferences`" or dump/reload to fix it!
psa.subdomains
error : Table upgrade required. Please do "REPAIR TABLE `subdomains`" or dump/reload to fix it!
psa.suspend_handler_history OK
psa.sys_users OK
psa.tts_cats OK
psa.tts_conf OK
psa.tts_priorities OK
psa.tts_queues OK
psa.tts_reporters OK
psa.tts_slave_info OK
psa.tts_ticket_events OK
psa.tts_tickets OK
psa.upgrade_history OK
psa.web_users OK
psa.webalizer_group_referrer OK
psa.webalizer_hidden_referrer OK
There were more than just these, but you get the idea.
Do I even need to run mysql_upgrade if doing yum upgrade? If so, what about these errors?
Re: Upgrading Plesk 9.5.4 MySQL
Posted: Sun May 01, 2011 11:46 am
by BruceLee
Re: Upgrading Plesk 9.5.4 MySQL
Posted: Sun May 01, 2011 3:08 pm
by faris
mysql_upgrade will tell you if it doesn't need to be run and will allow you to run it anyway. It does no harm even if you run it multiple times.
The only issue you may encounter would be the situation where you get an error saying that the table can't be repaired during the table repair process. In that case you have to dump and restore, which is not something I'm happy about doing personally as I'm not sure exactly sure about the best way to do it.
Anyway, with any luck you won't encounter the issue.
Re: Upgrading Plesk 9.5.4 MySQL
Posted: Sun May 01, 2011 5:07 pm
by KrazyBob
I first ran the atomic installer and then
Didn't that also upgrade mysql?
But then I ran
and it did exactly as you indicated.
Code: Select all
psa.spamfilter_preferences
error : Table upgrade required. Please do "REPAIR TABLE `spamfilter_preferences`" or dump/reload to fix it!
psa.subdomains
error : Table upgrade required. Please do "REPAIR TABLE `subdomains`" or dump/reload to fix it!
Do you recommend that I do a yum upgrade -y and then do a mysql_upgrade -u admin -p?
One would think that yum upgrade alone included mysql.
This has really been a hassle that was not present when PHP 5.2.17 was installed. A lot of workarounds makes me worry that once loaded with paying domains its going to bork and I will be helically wound on a vertical axis. (screwed!)
But it seems to me that I should get the most current version of PHP and MySQL on while I am pulling my hair out and ready to kick the dog
Re: Upgrading Plesk 9.5.4 MySQL
Posted: Sun May 01, 2011 5:42 pm
by breun
I'd execute SQL REPAIR statements that were suggested to you by mysql_upgrade and see if that helps.
Re: Upgrading Plesk 9.5.4 MySQL
Posted: Sun May 01, 2011 7:54 pm
by KrazyBob
Respectfully, we did that. That's why we're here asking for help. This is where the pro's hang out!
We first ran:
It upgraded the system and removed obsolete packages. PHP and MySQL appeared to run fine. But we followed your separate MySQL upgrade instructions, too.
That borked it so we ran the repair and it had no effect. The question asked was if running yum upgrade -y is there a need to run mysql_upgrade still?
Code: Select all
[root@xyz-secure ~]# mysqlcheck --check-upgrade --all-databases --auto-repair -u admin -p
Enter password:
atmail.AbookGroup_a OK
atmail.AbookGroup_b OK
atmail.AbookGroup_c OK
atmail.AbookGroup_d OK
atmail.AbookGroup_e OK
atmail.AbookGroup_f OK
atmail.AbookGroup_g OK
atmail.AbookGroup_h OK
atmail.AbookGroup_i OK
atmail.AbookGroup_j OK
atmail.AbookGroup_k OK
atmail.AbookGroup_l OK
atmail.AbookGroup_m OK
atmail.AbookGroup_n OK
atmail.AbookGroup_o OK
atmail.AbookGroup_other OK
atmail.AbookGroup_p OK
atmail.AbookGroup_q OK
atmail.AbookGroup_r OK
atmail.AbookGroup_s OK
atmail.AbookGroup_shared OK
atmail.AbookGroup_t OK
atmail.AbookGroup_u OK
atmail.AbookGroup_v OK
atmail.AbookGroup_w OK
atmail.AbookGroup_x OK
atmail.AbookGroup_y OK
atmail.AbookGroup_z OK
atmail.AbookPermissions OK
atmail.Abook_a OK
atmail.Abook_b OK
atmail.Abook_c OK
atmail.Abook_d OK
atmail.Abook_e OK
atmail.Abook_f OK
atmail.Abook_g OK
atmail.Abook_h OK
atmail.Abook_i OK
atmail.Abook_j OK
atmail.Abook_k OK
atmail.Abook_l OK
atmail.Abook_m OK
atmail.Abook_n OK
atmail.Abook_o OK
atmail.Abook_other OK
atmail.Abook_p OK
atmail.Abook_q OK
atmail.Abook_r OK
atmail.Abook_s OK
atmail.Abook_shared OK
atmail.Abook_t OK
atmail.Abook_u OK
atmail.Abook_v OK
atmail.Abook_w OK
atmail.Abook_x OK
atmail.Abook_y OK
atmail.Abook_z OK
atmail.Accounts OK
atmail.Domains OK
atmail.EmailDatabase_a OK
atmail.EmailDatabase_b OK
atmail.EmailDatabase_c OK
atmail.EmailDatabase_d OK
atmail.EmailDatabase_e OK
atmail.EmailDatabase_f OK
atmail.EmailDatabase_g OK
atmail.EmailDatabase_h OK
atmail.EmailDatabase_i OK
atmail.EmailDatabase_j OK
atmail.EmailDatabase_k OK
atmail.EmailDatabase_l OK
atmail.EmailDatabase_m OK
atmail.EmailDatabase_n OK
atmail.EmailDatabase_o OK
atmail.EmailDatabase_other OK
atmail.EmailDatabase_p OK
atmail.EmailDatabase_q OK
atmail.EmailDatabase_r OK
atmail.EmailDatabase_s OK
atmail.EmailDatabase_t OK
atmail.EmailDatabase_u OK
atmail.EmailDatabase_v OK
atmail.EmailDatabase_w OK
atmail.EmailDatabase_x OK
atmail.EmailDatabase_y OK
atmail.EmailDatabase_z OK
atmail.EmailMessage_Reply OK
atmail.EmailMessage_a OK
atmail.EmailMessage_b OK
atmail.EmailMessage_c OK
atmail.EmailMessage_d OK
atmail.EmailMessage_e OK
atmail.EmailMessage_f OK
atmail.EmailMessage_g OK
atmail.EmailMessage_h OK
atmail.EmailMessage_i OK
atmail.EmailMessage_j OK
atmail.EmailMessage_k OK
atmail.EmailMessage_l OK
atmail.EmailMessage_m OK
atmail.EmailMessage_n OK
atmail.EmailMessage_o OK
atmail.EmailMessage_other OK
atmail.EmailMessage_p OK
atmail.EmailMessage_q OK
atmail.EmailMessage_r OK
atmail.EmailMessage_s OK
atmail.EmailMessage_t OK
atmail.EmailMessage_u OK
atmail.EmailMessage_v OK
atmail.EmailMessage_w OK
atmail.EmailMessage_x OK
atmail.EmailMessage_y OK
atmail.EmailMessage_z OK
atmail.EmailUIDL_a OK
atmail.EmailUIDL_b OK
atmail.EmailUIDL_c OK
atmail.EmailUIDL_d OK
atmail.EmailUIDL_e OK
atmail.EmailUIDL_f OK
atmail.EmailUIDL_g OK
atmail.EmailUIDL_h OK
atmail.EmailUIDL_i OK
atmail.EmailUIDL_j OK
atmail.EmailUIDL_k OK
atmail.EmailUIDL_l OK
atmail.EmailUIDL_m OK
atmail.EmailUIDL_n OK
atmail.EmailUIDL_o OK
atmail.EmailUIDL_other OK
atmail.EmailUIDL_p OK
atmail.EmailUIDL_q OK
atmail.EmailUIDL_r OK
atmail.EmailUIDL_s OK
atmail.EmailUIDL_t OK
atmail.EmailUIDL_u OK
atmail.EmailUIDL_v OK
atmail.EmailUIDL_w OK
atmail.EmailUIDL_x OK
atmail.EmailUIDL_y OK
atmail.EmailUIDL_z OK
atmail.Filter OK
atmail.Folders OK
atmail.Groups OK
atmail.Log_Error OK
atmail.Log_Login OK
atmail.Log_RecvMail OK
atmail.Log_SMS OK
atmail.Log_SendMail OK
atmail.Log_Spam OK
atmail.Log_Virus OK
atmail.MailSort_a OK
atmail.MailSort_b OK
atmail.MailSort_c OK
atmail.MailSort_d OK
atmail.MailSort_e OK
atmail.MailSort_f OK
atmail.MailSort_g OK
atmail.MailSort_h OK
atmail.MailSort_i OK
atmail.MailSort_j OK
atmail.MailSort_k OK
atmail.MailSort_l OK
atmail.MailSort_m OK
atmail.MailSort_n OK
atmail.MailSort_o OK
atmail.MailSort_other OK
atmail.MailSort_p OK
atmail.MailSort_q OK
atmail.MailSort_r OK
atmail.MailSort_s OK
atmail.MailSort_t OK
atmail.MailSort_u OK
atmail.MailSort_v OK
atmail.MailSort_w OK
atmail.MailSort_x OK
atmail.MailSort_y OK
atmail.MailSort_z OK
atmail.MailThreads OK
atmail.SpellCheck OK
atmail.UserPermissions OK
atmail.UserSession OK
atmail.UserSettings_a OK
atmail.UserSettings_b OK
atmail.UserSettings_c OK
atmail.UserSettings_d OK
atmail.UserSettings_e OK
atmail.UserSettings_f OK
atmail.UserSettings_g OK
atmail.UserSettings_h OK
atmail.UserSettings_i OK
atmail.UserSettings_j OK
atmail.UserSettings_k OK
atmail.UserSettings_l OK
atmail.UserSettings_m OK
atmail.UserSettings_n OK
atmail.UserSettings_o OK
atmail.UserSettings_other OK
atmail.UserSettings_p OK
atmail.UserSettings_q OK
atmail.UserSettings_r OK
atmail.UserSettings_s OK
atmail.UserSettings_t OK
atmail.UserSettings_u OK
atmail.UserSettings_v OK
atmail.UserSettings_w OK
atmail.UserSettings_x OK
atmail.UserSettings_y OK
atmail.UserSettings_z OK
atmail.Users OK
horde.horde_alarms OK
horde.horde_cache OK
horde.horde_datatree OK
horde.horde_datatree_attributes OK
horde.horde_groups OK
horde.horde_groups_members OK
horde.horde_histories OK
horde.horde_locks OK
horde.horde_perms OK
horde.horde_prefs OK
horde.horde_sessionhandler OK
horde.horde_signups OK
horde.horde_syncml_anchors OK
horde.horde_syncml_map OK
horde.horde_tokens OK
horde.horde_users OK
horde.horde_vfs OK
horde.kronolith_events OK
horde.kronolith_shares OK
horde.kronolith_shares_groups OK
horde.kronolith_shares_users OK
horde.kronolith_storage OK
horde.mnemo_memos OK
horde.mnemo_shares OK
horde.mnemo_shares_groups OK
horde.mnemo_shares_users OK
horde.turba_objects OK
horde.turba_shares OK
horde.turba_shares_groups OK
horde.turba_shares_users OK
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.general_log
Error : You can't use locks with log tables.
status : OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.servers OK
mysql.slow_log
Error : You can't use locks with log tables.
status : OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
phpmyadmin_Za7Ed4JH1aAR.pma_bookmark OK
phpmyadmin_Za7Ed4JH1aAR.pma_column_info OK
phpmyadmin_Za7Ed4JH1aAR.pma_designer_coords OK
phpmyadmin_Za7Ed4JH1aAR.pma_history OK
phpmyadmin_Za7Ed4JH1aAR.pma_pdf_pages OK
phpmyadmin_Za7Ed4JH1aAR.pma_relation OK
phpmyadmin_Za7Ed4JH1aAR.pma_table_coords OK
phpmyadmin_Za7Ed4JH1aAR.pma_table_info OK
psa.APSApplicationItems OK
psa.APSCatalogUpdates OK
psa.APSClientApplicationItems OK
psa.APSLicenseTypes OK
psa.APSLicenses OK
psa.BackendCache OK
psa.BackupsRunning OK
psa.BackupsScheduled OK
psa.BackupsSettings OK
psa.BillingCache OK
psa.Cards OK
psa.ClientsTraffic OK
psa.Components OK
psa.DashboardPreset
error : Table upgrade required. Please do "REPAIR TABLE `DashboardPreset`" or dump/reload to fix it!
psa.DashboardPresetConfig OK
psa.DatabaseServers
error : Table upgrade required. Please do "REPAIR TABLE `DatabaseServers`" or dump/reload to fix it!
psa.DomainServices OK
psa.DomainsTraffic OK
psa.GL_remote_domains OK
psa.GL_settings OK
psa.IP_Addresses OK
psa.Limits OK
psa.ListsParams OK
psa.Logos OK
psa.MailLists OK
psa.MailMessagesStat OK
psa.Modules OK
psa.NewsArticles OK
psa.Notes OK
psa.Notifications OK
psa.PMM OK
psa.PMMDefault OK
psa.Parameters OK
psa.Permissions OK
psa.PersistentCache OK
psa.PleskPagesStat
error : Table upgrade required. Please do "REPAIR TABLE `PleskPagesStat`" or dump/reload to fix it!
psa.Repository OK
psa.SBConfig OK
psa.SBResellers
error : Table upgrade required. Please do "REPAIR TABLE `SBResellers`" or dump/reload to fix it!
psa.SBSites OK
psa.SSOBranding
error : Table upgrade required. Please do "REPAIR TABLE `SSOBranding`" or dump/reload to fix it!
psa.SiteAppFiles OK
psa.SiteAppPackages OK
psa.SiteAppResources OK
psa.SiteApps OK
psa.SiteAppsHitsStat
error : Table upgrade required. Please do "REPAIR TABLE `SiteAppsHitsStat`" or dump/reload to fix it!
psa.SitePagesStat OK
psa.Skins
error : Table upgrade required. Please do "REPAIR TABLE `Skins`" or dump/reload to fix it!
psa.Templates OK
psa.TmplData OK
psa.WebApps OK
psa.Webmails
error : Table upgrade required. Please do "REPAIR TABLE `Webmails`" or dump/reload to fix it!
psa.accounts OK
psa.actions OK
psa.ai_vendor_sources OK
psa.anon_ftp OK
psa.apscategories OK
psa.badmailfrom
error : Table upgrade required. Please do "REPAIR TABLE `badmailfrom`" or dump/reload to fix it!
psa.certificates OK
psa.cl_param OK
psa.clients
error : Table upgrade required. Please do "REPAIR TABLE `clients`" or dump/reload to fix it!
psa.cp_access OK
psa.custom_buttons OK
psa.data_bases OK
psa.db_users OK
psa.disk_usage OK
psa.dns_recs OK
psa.dns_recs_t OK
psa.dns_zone OK
psa.dom_level_usrs OK
psa.dom_param OK
psa.domainaliases OK
psa.domains
error : Table upgrade required. Please do "REPAIR TABLE `domains`" or dump/reload to fix it!
psa.event_handlers OK
psa.exp_event OK
psa.forwarding OK
psa.hosting OK
psa.ip_pool OK
psa.itmpl OK
psa.itmpl_data OK
psa.key_history OK
psa.key_history_params OK
psa.locales OK
psa.lockout
error : Table upgrade required. Please do "REPAIR TABLE `lockout`" or dump/reload to fix it!
psa.log_actions OK
psa.log_components OK
psa.log_rotation OK
psa.longtaskparams OK
psa.longtasks OK
psa.mail OK
psa.mail_aliases OK
psa.mail_redir OK
psa.mail_resp
error : Table upgrade required. Please do "REPAIR TABLE `mail_resp`" or dump/reload to fix it!
psa.mass_mail
error : Table upgrade required. Please do "REPAIR TABLE `mass_mail`" or dump/reload to fix it!
psa.mass_mail_clients OK
psa.mass_mail_domains OK
psa.misc OK
psa.mn_param OK
psa.module_fileserver_hosts OK
psa.module_fileserver_params OK
psa.module_fileserver_shares OK
psa.module_fileserver_users OK
psa.module_fileserver_valid_users OK
psa.module_firewall_objects OK
psa.module_firewall_rules OK
psa.module_kav_groups OK
psa.module_kav_mailnames OK
psa.module_kav_parameters OK
psa.module_vpn_objects OK
psa.module_watchdog_disk OK
psa.module_watchdog_disk_event OK
psa.module_watchdog_param OK
psa.module_watchdog_report OK
psa.module_watchdog_service
error : Table upgrade required. Please do "REPAIR TABLE `module_watchdog_service`" or dump/reload to fix it!
psa.module_watchdog_service_event OK
psa.module_watchdog_sys_stat OK
psa.password_secrets OK
psa.pd_users OK
psa.protected_dirs OK
psa.report OK
psa.report_auto OK
psa.report_section OK
psa.resp_attach OK
psa.resp_forward OK
psa.resp_freq OK
psa.secret_keys OK
psa.sessions OK
psa.siteapppackages_apscategories OK
psa.slave_params OK
psa.slaves OK
psa.smtp_poplocks OK
psa.spamfilter OK
psa.spamfilter_preferences
error : Table upgrade required. Please do "REPAIR TABLE `spamfilter_preferences`" or dump/reload to fix it!
psa.subdomains
error : Table upgrade required. Please do "REPAIR TABLE `subdomains`" or dump/reload to fix it!
psa.suspend_handler_history OK
psa.sys_users OK
psa.tts_cats OK
psa.tts_conf OK
psa.tts_priorities OK
psa.tts_queues OK
psa.tts_reporters OK
psa.tts_slave_info OK
psa.tts_ticket_events OK
psa.tts_tickets OK
psa.upgrade_history OK
psa.web_users OK
psa.webalizer_group_referrer OK
psa.webalizer_hidden_referrer OK
Repairing tables
psa.DashboardPreset
note : The storage engine for the table doesn't support repair
psa.DatabaseServers
note : The storage engine for the table doesn't support repair
psa.PleskPagesStat
note : The storage engine for the table doesn't support repair
psa.SBResellers
note : The storage engine for the table doesn't support repair
psa.SSOBranding
note : The storage engine for the table doesn't support repair
psa.SiteAppsHitsStat
note : The storage engine for the table doesn't support repair
psa.Skins
note : The storage engine for the table doesn't support repair
psa.Webmails
note : The storage engine for the table doesn't support repair
psa.badmailfrom
note : The storage engine for the table doesn't support repair
psa.clients
note : The storage engine for the table doesn't support repair
psa.domains
note : The storage engine for the table doesn't support repair
psa.lockout
note : The storage engine for the table doesn't support repair
psa.mail_resp
note : The storage engine for the table doesn't support repair
psa.mass_mail
note : The storage engine for the table doesn't support repair
psa.module_watchdog_service
note : The storage engine for the table doesn't support repair
psa.spamfilter_preferences
note : The storage engine for the table doesn't support repair
psa.subdomains
note : The storage engine for the table doesn't support repair
re: Dump & Restore WAS: Upgrading Plesk 9.5.4 MySQL
Posted: Mon May 02, 2011 2:51 am
by KrazyBob
OK. I dumped and restored the databases. Easy enough. But the process now reports that I cannot lock log tables. I don't know what that means? Is that a critical error? Is it even safe to load this server with clients? I mean, all of this kludging around just to get PHP and mySQL upgraded is really pretty ridiculous.
Code: Select all
[root@xyz-secure ~]# mysqldump -uadmin -p --all-databases > pleskbackup.sql
[root@xyz-secure ~]# mysql -uadmin -p < pleskbackup.sql
[root@xya-secure ~]# mysqlcheck --check-upgrade --all-databases -uadmin -p
atmail.AbookGroup_a OK
atmail.AbookGroup_b OK
atmail.AbookGroup_c OK
atmail.AbookGroup_d OK
atmail.AbookGroup_e OK
atmail.AbookGroup_f OK
atmail.AbookGroup_g OK
atmail.AbookGroup_h OK
atmail.AbookGroup_i OK
atmail.AbookGroup_j OK
atmail.AbookGroup_k OK
atmail.AbookGroup_l OK
atmail.AbookGroup_m OK
atmail.AbookGroup_n OK
atmail.AbookGroup_o OK
atmail.AbookGroup_other OK
atmail.AbookGroup_p OK
atmail.AbookGroup_q OK
atmail.AbookGroup_r OK
atmail.AbookGroup_s OK
atmail.AbookGroup_shared OK
atmail.AbookGroup_t OK
atmail.AbookGroup_u OK
atmail.AbookGroup_v OK
atmail.AbookGroup_w OK
atmail.AbookGroup_x OK
atmail.AbookGroup_y OK
atmail.AbookGroup_z OK
atmail.AbookPermissions OK
atmail.Abook_a OK
atmail.Abook_b OK
atmail.Abook_c OK
atmail.Abook_d OK
atmail.Abook_e OK
atmail.Abook_f OK
atmail.Abook_g OK
atmail.Abook_h OK
atmail.Abook_i OK
atmail.Abook_j OK
atmail.Abook_k OK
atmail.Abook_l OK
atmail.Abook_m OK
atmail.Abook_n OK
atmail.Abook_o OK
atmail.Abook_other OK
atmail.Abook_p OK
atmail.Abook_q OK
atmail.Abook_r OK
atmail.Abook_s OK
atmail.Abook_shared OK
atmail.Abook_t OK
atmail.Abook_u OK
atmail.Abook_v OK
atmail.Abook_w OK
atmail.Abook_x OK
atmail.Abook_y OK
atmail.Abook_z OK
atmail.Accounts OK
atmail.Domains OK
atmail.EmailDatabase_a OK
atmail.EmailDatabase_b OK
atmail.EmailDatabase_c OK
atmail.EmailDatabase_d OK
atmail.EmailDatabase_e OK
atmail.EmailDatabase_f OK
atmail.EmailDatabase_g OK
atmail.EmailDatabase_h OK
atmail.EmailDatabase_i OK
atmail.EmailDatabase_j OK
atmail.EmailDatabase_k OK
atmail.EmailDatabase_l OK
atmail.EmailDatabase_m OK
atmail.EmailDatabase_n OK
atmail.EmailDatabase_o OK
atmail.EmailDatabase_other OK
atmail.EmailDatabase_p OK
atmail.EmailDatabase_q OK
atmail.EmailDatabase_r OK
atmail.EmailDatabase_s OK
atmail.EmailDatabase_t OK
atmail.EmailDatabase_u OK
atmail.EmailDatabase_v OK
atmail.EmailDatabase_w OK
atmail.EmailDatabase_x OK
atmail.EmailDatabase_y OK
atmail.EmailDatabase_z OK
atmail.EmailMessage_Reply OK
atmail.EmailMessage_a OK
atmail.EmailMessage_b OK
atmail.EmailMessage_c OK
atmail.EmailMessage_d OK
atmail.EmailMessage_e OK
atmail.EmailMessage_f OK
atmail.EmailMessage_g OK
atmail.EmailMessage_h OK
atmail.EmailMessage_i OK
atmail.EmailMessage_j OK
atmail.EmailMessage_k OK
atmail.EmailMessage_l OK
atmail.EmailMessage_m OK
atmail.EmailMessage_n OK
atmail.EmailMessage_o OK
atmail.EmailMessage_other OK
atmail.EmailMessage_p OK
atmail.EmailMessage_q OK
atmail.EmailMessage_r OK
atmail.EmailMessage_s OK
atmail.EmailMessage_t OK
atmail.EmailMessage_u OK
atmail.EmailMessage_v OK
atmail.EmailMessage_w OK
atmail.EmailMessage_x OK
atmail.EmailMessage_y OK
atmail.EmailMessage_z OK
atmail.EmailUIDL_a OK
atmail.EmailUIDL_b OK
atmail.EmailUIDL_c OK
atmail.EmailUIDL_d OK
atmail.EmailUIDL_e OK
atmail.EmailUIDL_f OK
atmail.EmailUIDL_g OK
atmail.EmailUIDL_h OK
atmail.EmailUIDL_i OK
atmail.EmailUIDL_j OK
atmail.EmailUIDL_k OK
atmail.EmailUIDL_l OK
atmail.EmailUIDL_m OK
atmail.EmailUIDL_n OK
atmail.EmailUIDL_o OK
atmail.EmailUIDL_other OK
atmail.EmailUIDL_p OK
atmail.EmailUIDL_q OK
atmail.EmailUIDL_r OK
atmail.EmailUIDL_s OK
atmail.EmailUIDL_t OK
atmail.EmailUIDL_u OK
atmail.EmailUIDL_v OK
atmail.EmailUIDL_w OK
atmail.EmailUIDL_x OK
atmail.EmailUIDL_y OK
atmail.EmailUIDL_z OK
atmail.Filter OK
atmail.Folders OK
atmail.Groups OK
atmail.Log_Error OK
atmail.Log_Login OK
atmail.Log_RecvMail OK
atmail.Log_SMS OK
atmail.Log_SendMail OK
atmail.Log_Spam OK
atmail.Log_Virus OK
atmail.MailSort_a OK
atmail.MailSort_b OK
atmail.MailSort_c OK
atmail.MailSort_d OK
atmail.MailSort_e OK
atmail.MailSort_f OK
atmail.MailSort_g OK
atmail.MailSort_h OK
atmail.MailSort_i OK
atmail.MailSort_j OK
atmail.MailSort_k OK
atmail.MailSort_l OK
atmail.MailSort_m OK
atmail.MailSort_n OK
atmail.MailSort_o OK
atmail.MailSort_other OK
atmail.MailSort_p OK
atmail.MailSort_q OK
atmail.MailSort_r OK
atmail.MailSort_s OK
atmail.MailSort_t OK
atmail.MailSort_u OK
atmail.MailSort_v OK
atmail.MailSort_w OK
atmail.MailSort_x OK
atmail.MailSort_y OK
atmail.MailSort_z OK
atmail.MailThreads OK
atmail.SpellCheck OK
atmail.UserPermissions OK
atmail.UserSession OK
atmail.UserSettings_a OK
atmail.UserSettings_b OK
atmail.UserSettings_c OK
atmail.UserSettings_d OK
atmail.UserSettings_e OK
atmail.UserSettings_f OK
atmail.UserSettings_g OK
atmail.UserSettings_h OK
atmail.UserSettings_i OK
atmail.UserSettings_j OK
atmail.UserSettings_k OK
atmail.UserSettings_l OK
atmail.UserSettings_m OK
atmail.UserSettings_n OK
atmail.UserSettings_o OK
atmail.UserSettings_other OK
atmail.UserSettings_p OK
atmail.UserSettings_q OK
atmail.UserSettings_r OK
atmail.UserSettings_s OK
atmail.UserSettings_t OK
atmail.UserSettings_u OK
atmail.UserSettings_v OK
atmail.UserSettings_w OK
atmail.UserSettings_x OK
atmail.UserSettings_y OK
atmail.UserSettings_z OK
atmail.Users OK
horde.horde_alarms OK
horde.horde_cache OK
horde.horde_datatree OK
horde.horde_datatree_attributes OK
horde.horde_groups OK
horde.horde_groups_members OK
horde.horde_histories OK
horde.horde_locks OK
horde.horde_perms OK
horde.horde_prefs OK
horde.horde_sessionhandler OK
horde.horde_signups OK
horde.horde_syncml_anchors OK
horde.horde_syncml_map OK
horde.horde_tokens OK
horde.horde_users OK
horde.horde_vfs OK
horde.kronolith_events OK
horde.kronolith_shares OK
horde.kronolith_shares_groups OK
horde.kronolith_shares_users OK
horde.kronolith_storage OK
horde.mnemo_memos OK
horde.mnemo_shares OK
horde.mnemo_shares_groups OK
horde.mnemo_shares_users OK
horde.turba_objects OK
horde.turba_shares OK
horde.turba_shares_groups OK
horde.turba_shares_users OK
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.general_log
Error : You can't use locks with log tables.
status : OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.servers OK
mysql.slow_log
Error : You can't use locks with log tables.
status : OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
phpmyadmin_Za7Ed4JH1aAR.pma_bookmark OK
phpmyadmin_Za7Ed4JH1aAR.pma_column_info OK
phpmyadmin_Za7Ed4JH1aAR.pma_designer_coords OK
phpmyadmin_Za7Ed4JH1aAR.pma_history OK
phpmyadmin_Za7Ed4JH1aAR.pma_pdf_pages OK
phpmyadmin_Za7Ed4JH1aAR.pma_relation OK
phpmyadmin_Za7Ed4JH1aAR.pma_table_coords OK
phpmyadmin_Za7Ed4JH1aAR.pma_table_info OK
psa.APSApplicationItems OK
psa.APSCatalogUpdates OK
psa.APSClientApplicationItems OK
psa.APSLicenseTypes OK
psa.APSLicenses OK
psa.BackendCache OK
psa.BackupsRunning OK
psa.BackupsScheduled OK
psa.BackupsSettings OK
psa.BillingCache OK
psa.Cards OK
psa.ClientsTraffic OK
psa.Components OK
psa.DashboardPreset OK
psa.DashboardPresetConfig OK
psa.DatabaseServers OK
psa.DomainServices OK
psa.DomainsTraffic OK
psa.GL_remote_domains OK
psa.GL_settings OK
psa.IP_Addresses OK
psa.Limits OK
psa.ListsParams OK
psa.Logos OK
psa.MailLists OK
psa.MailMessagesStat OK
psa.Modules OK
psa.NewsArticles OK
psa.Notes OK
psa.Notifications OK
psa.PMM OK
psa.PMMDefault OK
psa.Parameters OK
psa.Permissions OK
psa.PersistentCache OK
psa.PleskPagesStat OK
psa.Repository OK
psa.SBConfig OK
psa.SBResellers OK
psa.SBSites OK
psa.SSOBranding OK
psa.SiteAppFiles OK
psa.SiteAppPackages OK
psa.SiteAppResources OK
psa.SiteApps OK
psa.SiteAppsHitsStat OK
psa.SitePagesStat OK
psa.Skins OK
psa.Templates OK
psa.TmplData OK
psa.WebApps OK
psa.Webmails OK
psa.accounts OK
psa.actions OK
psa.ai_vendor_sources OK
psa.anon_ftp OK
psa.apscategories OK
psa.badmailfrom OK
psa.certificates OK
psa.cl_param OK
psa.clients OK
psa.cp_access OK
psa.custom_buttons OK
psa.data_bases OK
psa.db_users OK
psa.disk_usage OK
psa.dns_recs OK
psa.dns_recs_t OK
psa.dns_zone OK
psa.dom_level_usrs OK
psa.dom_param OK
psa.domainaliases OK
psa.domains OK
psa.event_handlers OK
psa.exp_event OK
psa.forwarding OK
psa.hosting OK
psa.ip_pool OK
psa.itmpl OK
psa.itmpl_data OK
psa.key_history OK
psa.key_history_params OK
psa.locales OK
psa.lockout OK
psa.log_actions OK
psa.log_components OK
psa.log_rotation OK
psa.longtaskparams OK
psa.longtasks OK
psa.mail OK
psa.mail_aliases OK
psa.mail_redir OK
psa.mail_resp OK
psa.mass_mail OK
psa.mass_mail_clients OK
psa.mass_mail_domains OK
psa.misc OK
psa.mn_param OK
psa.module_fileserver_hosts OK
psa.module_fileserver_params OK
psa.module_fileserver_shares OK
psa.module_fileserver_users OK
psa.module_fileserver_valid_users OK
psa.module_firewall_objects OK
psa.module_firewall_rules OK
psa.module_kav_groups OK
psa.module_kav_mailnames OK
psa.module_kav_parameters OK
psa.module_vpn_objects OK
psa.module_watchdog_disk OK
psa.module_watchdog_disk_event OK
psa.module_watchdog_param OK
psa.module_watchdog_report OK
psa.module_watchdog_service OK
psa.module_watchdog_service_event OK
psa.module_watchdog_sys_stat OK
psa.password_secrets OK
psa.pd_users OK
psa.protected_dirs OK
psa.report OK
psa.report_auto OK
psa.report_section OK
psa.resp_attach OK
psa.resp_forward OK
psa.resp_freq OK
psa.secret_keys OK
psa.sessions OK
psa.siteapppackages_apscategories OK
psa.slave_params OK
psa.slaves OK
psa.smtp_poplocks OK
psa.spamfilter OK
psa.spamfilter_preferences OK
psa.subdomains OK
psa.suspend_handler_history OK
psa.sys_users OK
psa.tts_cats OK
psa.tts_conf OK
psa.tts_priorities OK
psa.tts_queues OK
psa.tts_reporters OK
psa.tts_slave_info OK
psa.tts_ticket_events OK
psa.tts_tickets OK
psa.upgrade_history OK
psa.web_users OK
psa.webalizer_group_referrer OK
psa.webalizer_hidden_referrer OK
Re: Upgrading Plesk 9.5.4 MySQL
Posted: Mon May 02, 2011 3:32 am
by breun
"You can't use locks with log table" is a harmless message. See
http://bugs.mysql.com/bug.php?id=30487
Re: Upgrading Plesk 9.5.4 MySQL
Posted: Mon May 02, 2011 3:34 am
by KrazyBob
Thanks. I am still not comfortable with this as a production server with all of the manual hassles. I think that I am going to restore the OS from backup and install PHP 5.2.17
Code: Select all
yum update php* --exclude=php*5.3*
and then manually update mysql using the Atomic Wiki.
I don't know. What do you think?
Re: Upgrading Plesk 9.5.4 MySQL
Posted: Mon May 02, 2011 3:39 am
by breun
I think it's fine, but I only know what I've seen here. PHP 5.2.x is no longer maintained, so it's not something I'd use if I were setting up a new server now.
Re: Upgrading Plesk 9.5.4 MySQL
Posted: Mon May 02, 2011 3:55 am
by KrazyBob
I wonder then if someone more experienced with updating Plesk 9.5.x with PHP 5.3.x and MySQL 5.1.x could write a new Wiki. ION Loader; mysql, Zend... phew.
Re: Upgrading Plesk 9.5.4 MySQL
Posted: Thu Aug 18, 2011 4:12 pm
by ryanz
Any updates on fixing these errors:
Table upgrade required. Please do "REPAIR TABLE `domains`" or dump/reload to fix it!
Re: Upgrading Plesk 9.5.4 MySQL
Posted: Fri Aug 19, 2011 12:52 am
by biggles
1. Try to repair tables
and if it fails...
2. Dump and restore database
Re: Upgrading Plesk 9.5.4 MySQL
Posted: Fri Aug 19, 2011 12:01 pm
by faris
Any tips on how exactly to do this safely?
Ideally you'd not want to be dumping and restoring when a database may be being updated.
Stopping apache is one option if the tables are related to website scripts, but if the table in question is a plesk one you'd need to stop plesk too.
Unfortunately ASL will restart apache (and other things) if it finds it down, so you'd also need to kill the process watcher and any third party process watchers you may have too.
So there has to be an easier way. Like putting a lock on the table or something?
Faris.
Re: Upgrading Plesk 9.5.4 MySQL
Posted: Fri Aug 19, 2011 3:43 pm
by breun
Use mysqlcheck:
Code: Select all
mysqlcheck --user=admin --password=`cat /etc/psa/.psa.shadow` --all-databases --auto-repair