Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Wrong version of mariadb (causing sql-import errors) #73

Open
purdy opened this issue Nov 6, 2024 · 4 comments
Open

Wrong version of mariadb (causing sql-import errors) #73

purdy opened this issue Nov 6, 2024 · 4 comments
Labels
bug Something isn't working

Comments

@purdy
Copy link

purdy commented Nov 6, 2024

I have a .lando.yml file that specifies a version of MariaDB that matches what I run on production (10.11). MariaDB recently added a sandbox protection line in snapshots generated by mysqldump. However, when I try to import a snap from production, I get this error:

ERROR at line 1: Unknown command '\-'.

When I log onto the database service to inspect further, the sql-import refers to mysql, which is symlinked to mariadb and its version does not match what I specified in the yml file:

$ mariadb --version
mariadb  Ver 15.1 Distrib 10.5.26-MariaDB, for debian-linux-gnu (x86_64) using  EditLine wrapper
name: mysite
recipe: lamp
config:
  webroot: web
  php: 8.1
  database: mariadb:10.11
@purdy purdy added the bug Something isn't working label Nov 6, 2024
@AaronFeledy
Copy link
Member

You may need to run lando update and ensure you have the latest version of the lamp and mariadb plugins, then run lando rebuild to apply any service updates to your app.

@purdy
Copy link
Author

purdy commented Nov 8, 2024

I have done that and still get 10.5.26. I tried it on another computer, too:

$ mariadb --version
mariadb  Ver 15.1 Distrib 10.5.26-MariaDB, for debian-linux-gnu (aarch64) using  EditLine wrapper

@AaronFeledy
Copy link
Member

Using the same landofile, I get the correct version:

❯ cat .lando.yml
name: mysite
recipe: lamp
config:
  webroot: web
  php: 8.1
  database: mariadb:10.11

❯ lando ssh -s database -c "mariadb --version"
mariadb  Ver 15.1 Distrib 10.11.9-MariaDB, for Linux (x86_64) using readline 5.1

What do you get for lando version --all?

@purdy
Copy link
Author

purdy commented Nov 8, 2024

 Name                 Version
 ──────────────────── ───────
 @lando/acquia        v1.5.1
 @lando/apache        v1.1.1
 @lando/backdrop      v1.6.1
 @lando/cli           v3.23.3
 @lando/compose       v1.2.1
 @lando/core          v3.23.3
 @lando/dotnet        v1.2.1
 @lando/drupal        v1.9.2
 @lando/elasticsearch v1.3.1
 @lando/go            v1.2.1
 @lando/healthcheck   v3.23.3
 @lando/joomla        v1.7.1
 @lando/lagoon        v1.3.1
 @lando/lamp          v1.7.1
 @lando/laravel       v1.8.1
 @lando/lemp          v1.7.1
 @lando/mailhog       v1.2.1
 @lando/mariadb       v1.6.1
 @lando/mean          v1.4.1
 @lando/memcached     v1.3.1
 @lando/mongo         v1.2.1
 @lando/mssql         v1.4.1
 @lando/mysql         v1.4.1
 @lando/networking    v3.23.3
 @lando/nginx         v1.4.1
 @lando/node          v1.3.1
 @lando/pantheon      v1.8.1
 @lando/php           v1.6.1
 @lando/phpmyadmin    v1.3.1
 @lando/platformsh    v0.9.0
 @lando/postgres      v1.4.1
 @lando/proxy         v3.23.3
 @lando/python        v1.4.1
 @lando/redis         v1.2.1
 @lando/ruby          v1.4.1
 @lando/scanner       v3.23.3
 @lando/sharing       v3.23.3
 @lando/solr          v1.3.1
 @lando/symfony       v1.8.1
 @lando/tomcat        v1.2.1
 @lando/varnish       v1.2.1
 @lando/wordpress     v1.7.1

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants