Еггог Uh-oh! Unable to start site

Support
,
1

What issue or error are you experiencing?

Еггог
Uh-oh! Unable to start site.
Error: Command failed: /home/user/.config/Local/lightning-services/ mysql-8.0.16+6/bin/linux/bin/mysqladmin
ping
mysqladmin: connect to server at ‘localhost’ failed
error: 'Can’t connect to local MySQL server through socket ‘/home/ user/.config/Local/run/ZJunPR7wC/mysql/mysqld.sock’
(2)"
Check that mysqld is running and that the socket: ‘/home/user/.config/ Local/run/ZJunPR7wC/mysql/mysqld.sock’ exists!
at ChildProcess.exithandler (node:child_process:422:12)
at ChildProcess.emit (node:events:517:28) at ChildProcess.emit (node:domain:489:12)
at maybeClose (node:internal/child_process:1098:16)
at Socket. (node:internal/child_process:450:11) at Socket.emit (node:events:517:28)
at Socket.emit (node:domain:489:12)
at Pipe. (node:net:350:12)

What steps can be taken to replicate the issue? Feel free to include screenshots, videos, etc

I reinstalled local many times.
Screenshot from 2024-04-23 15-31-51
But still getting this error. As well i reinstalled mysql, apache2 and nginx on my computer, because i thought that it’s the reason.

System Details

  • Local Version:
    9.0
  • Operating System (OS) and OS version:
    Linux (Ubuntu)

Local Logs

Attach your Local Logs here (Help Doc - Retrieving Local’s Log)

{"class":"Process","level":"warn","message":"nginx: [emerg] socket() [::1]:10003 failed (97: Address family not supported by protocol)","process":"nginx","thread":"main","timestamp":"2024-04-23T12:31:15.030Z"}
{"class":"Process","level":"warn","message":"nginx: [emerg] socket() [::1]:10003 failed (97: Address family not supported by protocol)","process":"nginx","thread":"main","timestamp":"2024-04-23T12:31:15.554Z"}
{"class":"Process","level":"warn","message":"2024-04-23T12:31:15.134730Z 0 [System] [MY-010116] [Server] %%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/linux/bin/mysqld (mysqld 8.0.16) starting as process 145272","process":"mysql","thread":"main","timestamp":"2024-04-23T12:31:15.719Z"}
{"class":"Process","level":"warn","message":"2024-04-23T12:31:15.136619Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.","process":"mysql","thread":"main","timestamp":"2024-04-23T12:31:15.719Z"}
{"class":"Process","level":"warn","message":"2024-04-23T12:31:15.716741Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","process":"mysql","thread":"main","timestamp":"2024-04-23T12:31:15.719Z"}
{"class":"Process","level":"warn","message":"2024-04-23T12:31:15.718842Z 0 [ERROR] [MY-010250] [Server] Failed to create a socket for IPv6 '::1': errno: 97.","process":"mysql","thread":"main","timestamp":"2024-04-23T12:31:15.720Z"}
{"class":"Process","level":"warn","message":"2024-04-23T12:31:15.718853Z 0 [ERROR] [MY-010255] [Server] Can't create IP socket: Address family not supported by protocol","process":"mysql","thread":"main","timestamp":"2024-04-23T12:31:15.720Z"}
{"class":"Process","level":"warn","message":"nginx: [emerg] socket() [::1]:10003 failed (97: Address family not supported by protocol)","process":"nginx","thread":"main","timestamp":"2024-04-23T12:31:16.073Z"}
{"class":"Process","level":"warn","message":"nginx: [emerg] socket() [::1]:10003 failed (97: Address family not supported by protocol)","process":"nginx","thread":"main","timestamp":"2024-04-23T12:31:16.603Z"}
{"class":"Process","level":"warn","message":"2024-04-23T12:31:15.719016Z 0 [ERROR] [MY-010119] [Server] Aborting","process":"mysql","thread":"main","timestamp":"2024-04-23T12:31:17.348Z"}
{"class":"Process","level":"warn","message":"2024-04-23T12:31:17.347558Z 0 [System] [MY-010910] [Server] %%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/linux/bin/mysqld: Shutdown complete (mysqld 8.0.16)  MySQL Community Server - GPL.","process":"mysql","thread":"main","timestamp":"2024-04-23T12:31:17.349Z"}
{"class":"Process","level":"warn","message":"2024-04-23T12:31:18.042530Z 0 [System] [MY-010116] [Server] %%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/linux/bin/mysqld (mysqld 8.0.16) starting as process 145460","process":"mysql","thread":"main","timestamp":"2024-04-23T12:31:18.546Z"}
{"class":"Process","level":"warn","message":"2024-04-23T12:31:18.044059Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.","process":"mysql","thread":"main","timestamp":"2024-04-23T12:31:18.546Z"}
{"class":"Process","level":"warn","message":"2024-04-23T12:31:18.543430Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","process":"mysql","thread":"main","timestamp":"2024-04-23T12:31:18.546Z"}
{"class":"Process","level":"warn","message":"2024-04-23T12:31:18.545498Z 0 [ERROR] [MY-010250] [Server] Failed to create a socket for IPv6 '::1': errno: 97.","process":"mysql","thread":"main","timestamp":"2024-04-23T12:31:18.546Z"}
{"class":"Process","level":"warn","message":"2024-04-23T12:31:18.545509Z 0 [ERROR] [MY-010255] [Server] Can't create IP socket: Address family not supported by protocol","process":"mysql","thread":"main","timestamp":"2024-04-23T12:31:18.547Z"}
{"class":"Process","level":"warn","message":"2024-04-23T12:31:18.545702Z 0 [ERROR] [MY-010119] [Server] Aborting","process":"mysql","thread":"main","timestamp":"2024-04-23T12:31:20.269Z"}
{"class":"Process","level":"warn","message":"2024-04-23T12:31:20.268552Z 0 [System] [MY-010910] [Server] %%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/linux/bin/mysqld: Shutdown complete (mysqld 8.0.16)  MySQL Community Server - GPL.","process":"mysql","thread":"main","timestamp":"2024-04-23T12:31:20.270Z"}
{"class":"Process","level":"warn","message":"2024-04-23T12:31:20.942452Z 0 [System] [MY-010116] [Server] %%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/linux/bin/mysqld (mysqld 8.0.16) starting as process 145591","process":"mysql","thread":"main","timestamp":"2024-04-23T12:31:21.518Z"}
{"class":"Process","level":"warn","message":"2024-04-23T12:31:20.943994Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.","process":"mysql","thread":"main","timestamp":"2024-04-23T12:31:21.519Z"}
{"class":"Process","level":"warn","message":"2024-04-23T12:31:21.515649Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","process":"mysql","thread":"main","timestamp":"2024-04-23T12:31:21.519Z"}
{"class":"Process","level":"warn","message":"2024-04-23T12:31:21.517796Z 0 [ERROR] [MY-010250] [Server] Failed to create a socket for IPv6 '::1': errno: 97.","process":"mysql","thread":"main","timestamp":"2024-04-23T12:31:21.519Z"}
{"class":"Process","level":"warn","message":"2024-04-23T12:31:21.517806Z 0 [ERROR] [MY-010255] [Server] Can't create IP socket: Address family not supported by protocol","process":"mysql","thread":"main","timestamp":"2024-04-23T12:31:21.520Z"}
{"level":"error","message":"Database did NOT respond to ping after 15 tries.","service":{},"serviceBinVersion":{},"stack":"Error: Command failed: %%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/linux/bin/mysqladmin ping\n\u0007mysqladmin: connect to server at 'localhost' failed\nerror: 'Can't connect to local MySQL server through socket '%%site.runData%%/mysql/mysqld.sock' (2)'\nCheck that mysqld is running and that the socket: '%%site.runData%%/mysql/mysqld.sock' exists!\n\n    at ChildProcess.exithandler (node:child_process:422:12)\n    at ChildProcess.emit (node:events:517:28)\n    at ChildProcess.emit (node:domain:489:12)\n    at maybeClose (node:internal/child_process:1098:16)\n    at Socket.<anonymous> (node:internal/child_process:450:11)\n    at Socket.emit (node:events:517:28)\n    at Socket.emit (node:domain:489:12)\n    at Pipe.<anonymous> (node:net:350:12)","thread":"main","timestamp":"2024-04-23T12:31:23.131Z"}
{"class":"SiteProcessManagerService","level":"error","message":"Unable to start site.","stack":"Error: Command failed: %%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/linux/bin/mysqladmin ping\n\u0007mysqladmin: connect to server at 'localhost' failed\nerror: 'Can't connect to local MySQL server through socket '%%site.runData%%/mysql/mysqld.sock' (2)'\nCheck that mysqld is running and that the socket: '%%site.runData%%/mysql/mysqld.sock' exists!\n\n    at ChildProcess.exithandler (node:child_process:422:12)\n    at ChildProcess.emit (node:events:517:28)\n    at ChildProcess.emit (node:domain:489:12)\n    at maybeClose (node:internal/child_process:1098:16)\n    at Socket.<anonymous> (node:internal/child_process:450:11)\n    at Socket.emit (node:events:517:28)\n    at Socket.emit (node:domain:489:12)\n    at Pipe.<anonymous> (node:net:350:12)","thread":"main","timestamp":"2024-04-23T12:31:23.132Z"}
{"class":"SiteProvisionerService","level":"error","message":"Unable to provision site.","stack":"Error: Command failed: %%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/linux/bin/mysqladmin ping\n\u0007mysqladmin: connect to server at 'localhost' failed\nerror: 'Can't connect to local MySQL server through socket '%%site.runData%%/mysql/mysqld.sock' (2)'\nCheck that mysqld is running and that the socket: '%%site.runData%%/mysql/mysqld.sock' exists!\n\n    at ChildProcess.exithandler (node:child_process:422:12)\n    at ChildProcess.emit (node:events:517:28)\n    at ChildProcess.emit (node:domain:489:12)\n    at maybeClose (node:internal/child_process:1098:16)\n    at Socket.<anonymous> (node:internal/child_process:450:11)\n    at Socket.emit (node:events:517:28)\n    at Socket.emit (node:domain:489:12)\n    at Pipe.<anonymous> (node:net:350:12)","thread":"main","timestamp":"2024-04-23T12:35:08.555Z"}
{"eventId":"19adb793843d4075b3bd68f4e86abdc5","level":"warn","message":"Unhandled Rejection.","p":{},"reason":{"cmd":"%%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/linux/bin/mysqladmin ping","code":1,"killed":false,"signal":null},"thread":"main","timestamp":"2024-04-23T12:35:10.733Z"}

Security Reminder
Local does a pretty good job of scrubbing private info from the logs and the errors it produces, however there’s always the possibility that something private can come through. Because these are public forums, always review the screenshots you are sharing to make sure there isn’t private info like passwords being displayed.

2

Hi @KSKS

If you create a new, blank site in Local can you access that okay? If you can, then you may want to try reimporting the site getting the errors. The steps would look like this:

  • Locate the site files on your machine, and save a copy of them to your desktop. If you click Go to Site Folder under your site name it should take you right to where they are located.
  • Once you have those copied, completely delete the site from Local
  • Restart Local/your machine
  • Reimport the site back into Local. You can refer here on how to Restore from only Local site files
3

Hello! No, it’s happening with new, blank site. I can’t even create an empty site…

4

Have you tried quitting Local and doing a full reboot of your machine?

When you do reboot make sure you don’t have anything else running as well.

Are you running other developer applications simultaneously? Apps like MAMP, XAMPP, or Docker for example.

Do you have any antivirus, security, or firewall applications that could be blocking Local?