beyondcode / herd-community

76 stars 1 forks source link

[Bug]: MySQL Database services deleted after create a Postgre service #852

Closed wagnerfnds closed 1 month ago

wagnerfnds commented 1 month ago

Platform

macOS

Operating system version

Sonoma 14.5

System architecture

ARM64 (M1, M2, etc)

Herd Version

1.7.1 (Build 28)

PHP Version

No response

Bug description

Hi guys, when we have a MySQL service and we want to run another database service like Postgre 16, it deletes the MySQL service with all databases. If this should be the normal behavior, so at least could have a confirmation alert.

Steps to reproduce

No response

Relevant log output

No response

mpociot commented 1 month ago

This is definitely not a normal behavior. So you still see the MySQL service in your list of services but it's deleted? How can I reproduce this, as I have pretty much every available service running

wagnerfnds commented 1 month ago

Yes, I continued to see my MySQL service and also the newly created Postgres, but Postrgres did not start automatically or manually and all MySQL databases were deleted as if a new MySQL service had been created.

I deleted the Postgres service (which didn't start) and tried creating it again to reproduce the error, this time the port was already in use. When checking what was running on the port I found a strange MySQL service running on the Postgres port.

I don't have any local installation of MySQL or Postgres, only the Herd services.

I'll attach some images that might help.

Screenshot 2024-06-29 at 10 52 24 Screenshot 2024-06-29 at 10 52 36
sschlein commented 1 month ago

Could you please check your config directory for Herd? I have attached a screenshot about the things that I am interested in. There should be a services JSON with the services and a directory that holds the data of these services, so your MySQL databases should still be there. If you create a new MySQL service and move the old data over while both processes are stopped, that should bring them back.

Please share your services-plist file or it's content so that we can have a look. I can't come up with a reason why Herd would start mysql on the postgres port but I can obviously see that from your terminal output 🤔

CleanShot 2024-07-01 at 08 12 42