queue_poison_pill table missing primary key #39239
Labels
Issue: ready for confirmation
Reported on 2.4.7-p2
Indicates original Magento version for the Issue report.
Preconditions and environment
This is the same issue as #33822 , that was originally raised by @sych74, commented by @siliconalchemy and looked into by @engcom-Echo and was closed without resolution.
Steps to reproduce
Prepare database:
Install Magento prequisites- database, PHP, Composer, RabbitMQ, Redis, Elasticsearch
Download Magento Community repository:
composer create-project --repository-url=https://repo.magento.com/ magento/project-community-edition=2.4.7-p2 /var/www/html/magento
Set permissions:
Install Magento
php bin/magento setup:install --base-url=<url> --db-host=ip:port --db-name=magentodb --db-user="magento" --db-password=<db password> --admin-firstname="xx" --admin-lastname="yy" --admin-email="[email protected]" --admin-user="[email protected]" --admin-password="Testing123%567" --use-rewrites=1 --backend-frontname="admin" --db-prefix=mage_ --timezone=America/Los_Angeles --currency=USD --language=en_US --session-save="redis" --search-engine=elasticsearch8 --elasticsearch-host=<ip> --elasticsearch-port=9200 --elasticsearch-index-prefix=magento2 --amqp-host=<ip> --amqp-port="5672" --amqp-user="magentorabbit" --amqp-password="<magentorabbit password>" --amqp-virtualhost="magento" --amqp-ssl=
Expected result
Magento installed successfully.
Actual result
Magento not installed successfully.
Additional information
pxc_strict_mode
of the Galera cluster is set toENFORCING
Per Percona's detailed explanation, the solution is to have primary keys on every table, including
queue_poison_pill
.Release note
No response
Triage and priority
The text was updated successfully, but these errors were encountered: