Issue with starter kit and MySQL
Closed this issue · 3 comments
lukecurtis93 commented
Hi there
Attempting to get it all up and running and everything starts ok except MySQL
I see the following from the logs:
2023-09-28T14:15:27.236869031Z [Entrypoint] MySQL Docker Image 8.0.32-1.2.11-server
2023-09-28T14:15:27.529890965Z [Entrypoint] Starting MySQL 8.0.32-1.2.11-server
2023-09-28T14:15:27.792070701Z 2023-09-28T14:15:27.783767Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2023-09-28T14:15:27.792100641Z 2023-09-28T14:15:27.785489Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.32) starting as process 1
2023-09-28T14:15:27.798469850Z 2023-09-28T14:15:27.797910Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-09-28T14:15:29.229621571Z 2023-09-28T14:15:29.229420Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-09-28T14:15:29.382900253Z 2023-09-28T14:15:29.382757Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2023-09-28T14:15:29.394009842Z 2023-09-28T14:15:29.393826Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2023-09-28T14:15:29.470523077Z 2023-09-28T14:15:29.470188Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-09-28T14:15:29.470554428Z 2023-09-28T14:15:29.470280Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-09-28T14:15:29.471655328Z 2023-09-28T14:15:29.471491Z 0 [ERROR] [MY-010259] [Server] Another process with pid 171 is using unix socket file.
2023-09-28T14:15:29.471679537Z 2023-09-28T14:15:29.471516Z 0 [ERROR] [MY-010268] [Server] Unable to setup unix socket lock file.
2023-09-28T14:15:29.471683988Z 2023-09-28T14:15:29.471534Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-09-28T14:15:30.959993585Z 2023-09-28T14:15:30.959863Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
2023-09-28T14:18:47.179256855Z [Entrypoint] MySQL Docker Image 8.0.32-1.2.11-server
2023-09-28T14:18:47.258821681Z [Entrypoint] Starting MySQL 8.0.32-1.2.11-server
2023-09-28T14:18:47.482590539Z 2023-09-28T14:18:47.477037Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2023-09-28T14:18:47.482642619Z 2023-09-28T14:18:47.478629Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.32) starting as process 1
2023-09-28T14:18:47.487327868Z 2023-09-28T14:18:47.487132Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-09-28T14:18:47.584452343Z 2023-09-28T14:18:47.584273Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-09-28T14:18:47.813914910Z 2023-09-28T14:18:47.813738Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-09-28T14:18:47.813939510Z 2023-09-28T14:18:47.813776Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-09-28T14:18:47.814363781Z 2023-09-28T14:18:47.814190Z 0 [ERROR] [MY-010259] [Server] Another process with pid 171 is using unix socket file.
2023-09-28T14:18:47.814394401Z 2023-09-28T14:18:47.814256Z 0 [ERROR] [MY-010268] [Server] Unable to setup unix socket lock file.
2023-09-28T14:18:47.814413340Z 2023-09-28T14:18:47.814266Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-09-28T14:18:49.354458125Z 2023-09-28T14:18:49.354291Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
When attempting to manually run the container.
Any ideas?
Thanks!
lukecurtis93 commented
If I manually run docker compose up -d i get the following
$ docker compose up -d
[+] Running 1/0
[+] Running 1/1mplate-php-laravel-mysql-mysql-1 Created 0.0s
[+] Running 1/1mplate-php-laravel-mysql-mysql-1 Created 0.0s
[+] Running 1/1mplate-php-laravel-mysql-mysql-1 Created 0.0s
[+] Running 1/1mplate-php-laravel-mysql-mysql-1 Created 0.0s
[+] Running 1/1mplate-php-laravel-mysql-mysql-1 Created 0.0s
[+] Running 1/1mplate-php-laravel-mysql-mysql-1 Created 0.0s
✔ Container template-php-laravel-mysql-mysql-1 Started 0.0s
gitpod /workspace/template-php-laravel-mysql (main) $ php artisan tinker
Psy Shell v0.11.21 (PHP 8.2.10 — cli) by Justin Hileman
> User::factory()->create()
[!] Aliasing 'User' to 'App\Models\User' for this Tinker session.
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, SQL: insert into `users` (`name`, `email`, `email_verified_at`, `password`, `remember_token`, `updated_at`, `created_at`) values (Lukas Corkery, jackeline.corkery@example.org, 2023-09-28 14:22:50, $2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi, eiIb0VpWp3, 2023-09-28 14:22:50, 2023-09-28 14:22:50)).
> exit
INFO Goodbye.
ijpatricio commented
Hey @lukecurtis93
Can you tell me how are you starting the environment?
Just double checked, and here is after starting a new environment, on mainbranch, just 1 minute ago. Everything OK.
lukecurtis93 commented
Hi Joao, thanks so much for the quick reply super appreciate it
I installed it through the web GUI starter kit which prompted me to open my PHPStorm gateway
Interesting, after deleting the workspace and starting again it worked... super weird can't replicate it now
Thanks for your response in any case! Loving the product so far.