Everytime I try to push my local dev site to a staging environment, I get the following error with absolutely no details. I have no idea how to proceed!
Hi @Chris_Sims ! Welcome to the Kinsta Community.
Can you please provide us your main.log file from your DevKinsta installation? Troubleshooting - Error Codes - Kinsta® Docs
main.log (106.4 KB)
I’ve attached the main.log.
Hi @Chris_Sims! Thank you for your reply and sharing the main.log file.
Upon reviewing the log it looks like the error occurring is, “The user specified as a definer (‘USERNAME’@‘localhost’) does not exist when using LOCK TABLES”.
We are investigating further into why this issue is occurring and will update you as soon as possible once we have details to share. We may need to escalate this internally with our development team to help determine the root cause of this problem. We appreciate your patience while we investigate into this matter further.
In the meantime, if you do have any questions or would like to share additional information please don’t hesitate to reply.
Best regards
Is there a workaround or anything I can do now other than the very slow and painful process of manually making these changes?
Hi @Chris_Sims! Thank you for your reply!
There is something we can try to see if it helps workaround this issue. This would be to create a user in MariaDB that matches the username of the expected definer and grant it all permissions on the database.
Please follow the instructions below to create this user and grant all privileges on the database:
-
Start a command prompt in Windows
-
Run: docker exec -u root -it devkinsta_db bash
-
Once you have entered into the container run: mysql -p You will be prompted for a password. You may copy/paste the database password from the wp-config.php file of your DevKinsta site.
-
In the MySQL command prompt run: GRANT ALL ON DB_NAME.* TO ‘learnn’@‘%’ IDENTIFIED BY ‘complex-password’;
In the above step please replace DB_NAME with the database name listed in the wp-config.php file of the site.
- Run FLUSH PRIVILEGES;
This should create the definer user MariaDB is looking for and hopefully allow you to push your local site to the staging environment.
Please let us know if this helps resolve the issue, or if you do continue to experience any difficulty. We are standing by and happy to help!
We look forward to hearing from you!
I apologize for the late response. This did seem to resolve the issue. Thank you.
@Chris_Sims Thank you for the update. We are glad that the workaround helped in fixing the issue.
If ever you need help or have questions in the future, please feel free to reach out here in the Community Forum. Have a great day!
This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.