dimanche 1 octobre 2017

Laravel: MariaDB - artisan migrate:refresh hangs

I'm using Debian 9 with MariaDB 10.1.27, Composer 1.4.2 and Laravel 5.5.13.

I've created an empty database using CREATE DATABASE 'laravel', configured it in Laravel's .env config file and now I've sometimes the problem, that database actions hangs (nothing happens) or in the browser I get an timeout exceeded message. Connecting to the database using mysql -u laravel -p laravel is still possible - like SELECT's.

php artisan migrate

...is sometimes working like migrate:refresh and sometimes not. If it's not working, I always have to restart the MariaDB service and usually, it works then the first time again.

migrate:refresh for example clears the database and imports / loads most of the time 10 migrations and then, it's just doing nothing. I've already waited about 1 hour for this task, but it only keeps saying, that the migration table was missing and added and nothing more. Artisan doesn't even say, that it has imported / loaded 9 other tables...

For sending emails, I'm using supervisor, but it shouldn't be in use, while running migrate:refreshh;

Increasing the execution timeout doesn't help anything. So, what's the problem? In Homestead it's just working perfect. Are there any specific settings in MariaDB required? Or do I need to create the database with specific parameters like default charset?

Btw: If the application is running, I'm also sometimes getting the execution timeout error message, while browsing the web site.



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire