Upgrading Plesk 9.5.4 MySQL

[KrazyBob]

OK. I used the atomic installer and

Code: Select all

yum upgrade -y

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

Code: Select all

mysql_upgrade -uadmin -p

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?

[BruceLee]

follow these steps:
http://www.atomicorp.com/wiki/index.php/Mysql

[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.

[KrazyBob]

I first ran the atomic installer and then

Code: Select all

yum upgrade -y

Didn't that also upgrade mysql?

But then I ran

Code: Select all

mysql_upgrade -u admin -p

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

[breun]

I'd execute SQL REPAIR statements that were suggested to you by mysql_upgrade and see if that helps.

[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:

Code: Select all

yum upgrade -y

It upgraded the system and removed obsolete packages. PHP and MySQL appeared to run fine. But we followed your separate MySQL upgrade instructions, too.

Code: Select all

mysql_upgrade -u admin -p

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

[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

[breun]

"You can't use locks with log table" is a harmless message. See http://bugs.mysql.com/bug.php?id=30487

[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?

[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.

[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.

[ryanz]

Any updates on fixing these errors:

Table upgrade required. Please do "REPAIR TABLE `domains`" or dump/reload to fix it!

[biggles]

1. Try to repair tables
and if it fails...
2. Dump and restore database

[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.

[breun]

Use mysqlcheck:

Code: Select all

mysqlcheck --user=admin --password=`cat /etc/psa/.psa.shadow` --all-databases --auto-repair