Dear @Vitaliy
I made a clean git install from stable-3_3_0 branch on an xcloud server.
Then I copied all the tables from the journal database to testing database.
Then, I copied contents of public folder and files folder to new testing domain. After configuring config.inc.php, I tried upgrade via command line.
- Current (Database) Version - e.g., OJS 3.2.1.3
Operating system | CentOS Linux 7.9.2009
Perl version | 5.016003
Apache version | 2.4.6
PHP versions 7.4.14
MariaDB version | 10.4.17
php runs as cgi-wrapper
But before starting the upgrade, I applied the query on Submission files upgrade step is slow · Issue #6474 · pkp/pkp-lib · GitHub page and get similar results
SELECT DISTINCT rf.file_id FROM review_files rf LEFT JOIN submission_files sf ON (rf.file_id = sf.file_id) WHERE sf.file_id IS NULL;
9581
9582
9583
9584
9585
Then I removed these rows by;
DELETE FROM review_files WHERE file_id IN (9581, 9582, 9583, 9584, 9585);
When I run the upgrade, I get an SQL error;
[migration: PKPv3_3_0UpgradeMigration]
ERROR: Upgrade failed: DB: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (
upgrade
.#sql-468_2026
, CONSTRAINTreview_files_submission_file_id_foreign
FOREIGN KEY (submission_file_id
) REFERENCESsubmission_files
(submission_file_id
)) (SQL: alter tablereview_files
add constraintreview_files_submission_file_id_foreign
foreign key (submission_file_id
) referencessubmission_files
(submission_file_id
))
I try to understand whether the issue is specific to my database, or some other people has experienced the same error eventhough after applying the SQL command above. But I still get the same error during upgrade via command line.
Although not urgent, I am looking for a solution as I am considering to upgrade soon.
I may share account information if needed.
Regards,