Hi guys.
I been trying Ghost in containers and it all seems to work but what worries me are errors in mySQL logs:
...
2023-07-02 14:19:05 2 [ERROR] Slave SQL: Error 'Multiple primary key defined' on query. Default database: 'ghost_o_xyz'. Query: 'alter table `migrations_lock` add primary key `migrations_lock_pkey`(`lock_key`)', Internal MariaDB error code: 1068
2023-07-02 14:19:05 2 [Warning] WSREP: Ignoring error 'Multiple primary key defined' on query. Default database: 'ghost_o_xyz'. Query: 'alter table `migrations_lock` add primary key `migrations_lock_pkey`(`lock_key`)', Error_code: 1068
2023-07-02 14:20:35 2 [ERROR] Slave SQL: Error 'Duplicate key name 'migrations_name_version_unique'' on query. Default database: 'ghost_o_xyz'. Query: 'alter table `migrations` add unique `migrations_name_version_unique`(`name`, `version`)', Internal MariaDB error code: 1061
...
I’d rather - obviously - keep the database and fiddle with with as oppose to start from scratch.
I’ve checked - DB Error after upgrading to v4 - #6 by jackma
but dropping both migrations & migrations_lock -while container is down - does not help. I get the errors upon very next container start.
p.s. I pull the image today.
Can you advise on a safe way to fix it?
many thanks, L.