Bind mounts cause a migration error #152
Description
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'
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