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.

Sign up for GitHub

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

Jump to bottom

Bind mounts cause a migration error #152

Open
brandonvu99 opened this issue Jan 28, 2025 · 0 comments
Open

Bind mounts cause a migration error #152

brandonvu99 opened this issue Jan 28, 2025 · 0 comments

Comments

@brandonvu99
Copy link

On a fresh install using Docker on Windows 11 with WSL, I get this error from the monicahq container:

...

2025-01-27 19:34:11   2019_09_04_075311_fix_tattoo_or_piercing_translation .............. 2ms DONE
2025-01-27 19:34:11   2019_12_17_024553_add_foreign_keys ............................ 1,385ms FAIL
2025-01-27 19:34:11 
2025-01-27 19:34:11 In Connection.php line 760:
2025-01-27 19:34:11 
2025-01-27 19:34:11   [Illuminate\Database\QueryException (HY000)]
2025-01-27 19:34:11   SQLSTATE[HY000]: General error: 1025 Error on rename of './monica/relations
2025-01-27 19:34:11   hips' to './monica/#sql-backup-1-a' (errno: 194 "Tablespace is missing for
2025-01-27 19:34:11   a table") (SQL: ALTER TABLE relationships CHANGE account_id account_id INT
2025-01-27 19:34:11   UNSIGNED NOT NULL, CHANGE relationship_type_id relationship_type_id INT UNS
2025-01-27 19:34:11   IGNED NOT NULL, CHANGE contact_is contact_is INT UNSIGNED NOT NULL, CHANGE
2025-01-27 19:34:11   of_contact of_contact INT UNSIGNED NOT NULL)
2025-01-27 19:34:11 
2025-01-27 19:34:11 
2025-01-27 19:34:11 Exception trace:
2025-01-27 19:34:11   at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
2025-01-27 19:34:11  Illuminate\Database\Connection->runQueryCallback() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:720
2025-01-27 19:34:11  Illuminate\Database\Connection->run() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:534
2025-01-27 19:34:11  Illuminate\Database\Connection->statement() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php:109
2025-01-27 19:34:11  Illuminate\Database\Schema\Blueprint->build() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php:439
2025-01-27 19:34:11  Illuminate\Database\Schema\Builder->build() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php:269
2025-01-27 19:34:11  Illuminate\Database\Schema\Builder->table() at /var/www/html/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:338
2025-01-27 19:34:11  Illuminate\Support\Facades\Facade::__callStatic() at /var/www/html/database/migrations/2019_12_17_024553_add_foreign_keys.php:496
2025-01-27 19:34:11  AddForeignKeys->cleanRelationshipTable() at /var/www/html/database/migrations/2019_12_17_024553_add_foreign_keys.php:78
2025-01-27 19:34:11  AddForeignKeys->up() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:488
2025-01-27 19:34:11  Illuminate\Database\Migrations\Migrator->runMethod() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:406
2025-01-27 19:34:11  Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations\{closure}() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:415
2025-01-27 19:34:11  Illuminate\Database\Migrations\Migrator->runMigration() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:216
2025-01-27 19:34:11  Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations\{closure}() at /var/www/html/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php:37
2025-01-27 19:34:11  Illuminate\Console\View\Components\Task->render() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:751
2025-01-27 19:34:11  Illuminate\Database\Migrations\Migrator->write() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:216
2025-01-27 19:34:11  Illuminate\Database\Migrations\Migrator->runUp() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:181
2025-01-27 19:34:11  Illuminate\Database\Migrations\Migrator->runPending() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:124
2025-01-27 19:34:11  Illuminate\Database\Migrations\Migrator->run() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php:88
2025-01-27 19:34:11  Illuminate\Database\Console\Migrations\MigrateCommand->Illuminate\Database\Console\Migrations\{closure}() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:628
2025-01-27 19:34:11  Illuminate\Database\Migrations\Migrator->usingConnection() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php:81
2025-01-27 19:34:11  Illuminate\Database\Console\Migrations\MigrateCommand->handle() at /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
2025-01-27 19:34:11  Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() at /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php:41
2025-01-27 19:34:11  Illuminate\Container\Util::unwrapIfClosure() at /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
2025-01-27 19:34:11  Illuminate\Container\BoundMethod::callBoundMethod() at /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:35
2025-01-27 19:34:11  Illuminate\Container\BoundMethod::call() at /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php:661
2025-01-27 19:34:11  Illuminate\Container\Container->call() at /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php:183
2025-01-27 19:34:11  Illuminate\Console\Command->execute() at /var/www/html/vendor/symfony/console/Command/Command.php:326
2025-01-27 19:34:11  Symfony\Component\Console\Command\Command->run() at /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php:152
2025-01-27 19:34:11  Illuminate\Console\Command->run() at /var/www/html/vendor/symfony/console/Application.php:1078
2025-01-27 19:34:11  Symfony\Component\Console\Application->doRunCommand() at /var/www/html/vendor/symfony/console/Application.php:324
2025-01-27 19:34:11  Symfony\Component\Console\Application->doRun() at /var/www/html/vendor/symfony/console/Application.php:175
2025-01-27 19:34:11  Symfony\Component\Console\Application->run() at /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Application.php:102
2025-01-27 19:34:11  Illuminate\Console\Application->run() at /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php:155
2025-01-27 19:34:11  Illuminate\Foundation\Console\Kernel->handle() at /var/www/html/artisan:35
2025-01-27 19:34:11 
2025-01-27 19:34:11 In Connection.php line 545:
2025-01-27 19:34:11 
2025-01-27 19:34:11   [PDOException (HY000)]
2025-01-27 19:34:11   SQLSTATE[HY000]: General error: 1025 Error on rename of './monica/relations
2025-01-27 19:34:11   hips' to './monica/#sql-backup-1-a' (errno: 194 "Tablespace is missing for
2025-01-27 19:34:11   a table")
2025-01-27 19:34:11 
2025-01-27 19:34:11 
2025-01-27 19:34:11 Exception trace:
2025-01-27 19:34:11   at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:545
2025-01-27 19:34:11  PDOStatement->execute() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:545
2025-01-27 19:34:11  Illuminate\Database\Connection->Illuminate\Database\{closure}() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:753
2025-01-27 19:34:11  Illuminate\Database\Connection->runQueryCallback() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:720
2025-01-27 19:34:11  Illuminate\Database\Connection->run() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:534
2025-01-27 19:34:11  Illuminate\Database\Connection->statement() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php:109
2025-01-27 19:34:11  Illuminate\Database\Schema\Blueprint->build() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php:439
2025-01-27 19:34:11  Illuminate\Database\Schema\Builder->build() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php:269
2025-01-27 19:34:11  Illuminate\Database\Schema\Builder->table() at /var/www/html/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:338
2025-01-27 19:34:11  Illuminate\Support\Facades\Facade::__callStatic() at /var/www/html/database/migrations/2019_12_17_024553_add_foreign_keys.php:496
2025-01-27 19:34:11  AddForeignKeys->cleanRelationshipTable() at /var/www/html/database/migrations/2019_12_17_024553_add_foreign_keys.php:78
2025-01-27 19:34:11  AddForeignKeys->up() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:488
2025-01-27 19:34:11  Illuminate\Database\Migrations\Migrator->runMethod() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:406
2025-01-27 19:34:11  Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations\{closure}() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:415
2025-01-27 19:34:11  Illuminate\Database\Migrations\Migrator->runMigration() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:216
2025-01-27 19:34:11  Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations\{closure}() at /var/www/html/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php:37
2025-01-27 19:34:11  Illuminate\Console\View\Components\Task->render() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:751
2025-01-27 19:34:11  Illuminate\Database\Migrations\Migrator->write() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:216
2025-01-27 19:34:11  Illuminate\Database\Migrations\Migrator->runUp() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:181
2025-01-27 19:34:11  Illuminate\Database\Migrations\Migrator->runPending() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:124
2025-01-27 19:34:11  Illuminate\Database\Migrations\Migrator->run() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php:88
2025-01-27 19:34:11  Illuminate\Database\Console\Migrations\MigrateCommand->Illuminate\Database\Console\Migrations\{closure}() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:628
2025-01-27 19:34:11  Illuminate\Database\Migrations\Migrator->usingConnection() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php:81
2025-01-27 19:34:11  Illuminate\Database\Console\Migrations\MigrateCommand->handle() at /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
2025-01-27 19:34:11  Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() at /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php:41
2025-01-27 19:34:11  Illuminate\Container\Util::unwrapIfClosure() at /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
2025-01-27 19:34:11  Illuminate\Container\BoundMethod::callBoundMethod() at /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:35
2025-01-27 19:34:11  Illuminate\Container\BoundMethod::call() at /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php:661
2025-01-27 19:34:11  Illuminate\Container\Container->call() at /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php:183
2025-01-27 19:34:11  Illuminate\Console\Command->execute() at /var/www/html/vendor/symfony/console/Command/Command.php:326
2025-01-27 19:34:11  Symfony\Component\Console\Command\Command->run() at /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php:152
2025-01-27 19:34:11  Illuminate\Console\Command->run() at /var/www/html/vendor/symfony/console/Application.php:1078
2025-01-27 19:34:11  Symfony\Component\Console\Application->doRunCommand() at /var/www/html/vendor/symfony/console/Application.php:324
2025-01-27 19:34:11  Symfony\Component\Console\Application->doRun() at /var/www/html/vendor/symfony/console/Application.php:175
2025-01-27 19:34:11  Symfony\Component\Console\Application->run() at /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Application.php:102
2025-01-27 19:34:11  Illuminate\Console\Application->run() at /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php:155
2025-01-27 19:34:11  Illuminate\Foundation\Console\Kernel->handle() at /var/www/html/artisan:35
2025-01-27 19:34:11 
2025-01-27 19:34:11 
2025-01-27 19:34:11 ✓ Check for encryption keys
2025-01-27 19:34:11 '/usr/local/bin/php' 'artisan' monica:passport --force
2025-01-27 19:34:12 Checking encryption keys...
2025-01-27 19:34:12 ✓ Creating encryption keys
2025-01-27 19:34:12 '/usr/local/bin/php' 'artisan' passport:keys --no-interaction
2025-01-27 19:34:12 Encryption keys generated successfully.
...

2025-01-27 19:34:13 Monica v4.1.2 is set up, enjoy.
2025-01-27 19:34:13 Database ready.AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.21.0.3. Set the 'ServerName' directive globally to suppress this message
2025-01-27 19:34:13 AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.21.0.3. Set the 'ServerName' directive globally to suppress this message
2025-01-27 19:34:13 [Tue Jan 28 00:34:13.398898 2025] [mpm_prefork:notice] [pid 1:tid 1] AH00163: Apache/2.4.62 (Debian) PHP/8.2.27 configured -- resuming normal operations
2025-01-27 19:34:13 [Tue Jan 28 00:34:13.398931 2025] [core:notice] [pid 1:tid 1] AH00094: Command line: 'apache2 -D FOREGROUND'

Full log here.

This docker-compose file with bind mounts cause the error:

services:
  monica:
    image: monica
    depends_on:
      - db
    ports:
      - 7221:80
    environment:
      - APP_KEY=mysecretappkeycensoredforgithub
      - DB_HOST=db
      - DB_USERNAME=usermonica
      - DB_PASSWORD=secret
    volumes:
      - ./data:/var/www/html/storage
    restart: always

  db:
    image: mariadb:11
    environment:
      - MYSQL_RANDOM_ROOT_PASSWORD=true
      - MYSQL_DATABASE=monica
      - MYSQL_USER=usermonica
      - MYSQL_PASSWORD=secret
    volumes:
      - ./mysql:/var/lib/mysql
    restart: always

Using volumes instead of bind mounts (as suggested in the installation instructions) does not cause the migration error. I've never really ran into an issue with using bind mounts over volumes before, so I thought that this would not cause a problem
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@brandonvu99