We are experiencing a strange error upgrading our Xilbo. Installation is docker (kubernetes) and has been working great on 2.3.16. During the migration to 3.3.7, we are getting access denied errors during table alters
down 20221024082400 AdCampaignMigration
down 20221101090337 CreateDisplayTypeTableMigration
down 20221101130018 AddDisplayMetaDataMigration
down 20221104095722 CreateDisplayLocationTypeTableMigration
We will upgrade it, take a backup
mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
Running database migrations
Phinx by CakePHP - https://phinx.org. 0.9.2
using config file .varwwwcmsphinx.php
using config parser php
using migration paths
- /var/www/cms/db/migrations
warning no environment specified, defaulting to: production
using adapter mysql
using database cms
== 20221024082400 AdCampaignMigration: migrating
In PdoAdapter.php line 134:
SQLSTATE[HY000]: General error: 7 Error on rename of './cms/#sql-1_88.frm'
to './cms/campaign.frm' (Errcode: 13 - Permission denied)
migrate [-c|--configuration CONFIGURATION] [-p|--parser PARSER] [-e|--environment ENVIRONMENT] [-t|--target TARGET] [-d|--date DATE] [-x|--dry-run]
The mysql container shows that the table is corrupted with a differing schema than the data shows. Typically I’m finding that it is missing one column in the schema (which makes sense if the FRM didn’t copy). I’m unclear why we would be experiencing this. All files have the correct permissions in the mysql container (mysql:mysql). Files are mounted from NFS storage.