When upgrading to 8.0 I get the following db upgrade errors:
2023-02-07T09:20:44Z:LOG_ERR:a707bda418:dba_driver.php:463:db_logger: dba_pdo: ERROR: CREATE INDEX idx_workerq_priority ON workerq (workerq_priority);
SQLSTATE[42P07]: Duplicate table: 7 ERROR: relation "idx_workerq_priority" already exists
2023-02-07T09:20:44Z:LOG_ERR:a707bda418:dba_driver.php:463:db_logger: dba_pdo: ERROR: CREATE INDEX idx_workerq_reservationid ON workerq (workerq_reservationid);
SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block
2023-02-07T09:20:44Z:LOG_ERR:a707bda418:dba_driver.php:463:db_logger: dba_pdo: ERROR: CREATE INDEX idx_workerq_processtimeout ON workerq (workerq_processtimeout);
SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block
2023-02-07T09:20:44Z:LOG_ERR:a707bda418:dba_driver.php:463:db_logger: dba_pdo: ERROR: CREATE INDEX idx_workerq_uuid ON workerq (workerq_uuid);
SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block
It claims it was
Update _1254
that failed. Maybe relevant:
* I'm using Postgres as database.
* I had the queueworker plugin active (which I possibly should have deactivated before upgrading...)
Thanks for your help everyone. :)