Hi @asmecher,
We’ve updated postgres to 13 and now the following error appears:
ERROR: Upgrade failed: DB: PDOException: SQLSTATE[23502]: Not null violation: 7 ERROR: column "review_round_id" of relation "review_assignments" contains null values in /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:115
Stack trace:
#0 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(115): PDOStatement->execute(NULL)
#1 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(464): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}('ALTER TABLE rev...', Array)
#3 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback('ALTER TABLE rev...', Array, Object(Closure))
#4 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(465): Illuminate\Database\Connection->run('ALTER TABLE rev...', Array, Object(Closure))
#5 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(102): Illuminate\Database\Connection->statement('ALTER TABLE rev...')
#6 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(290): Illuminate\Database\Schema\Blueprint->build(Object(Illuminate\Database\PostgresConnection), Object(Illuminate\Database\Schema\Grammars\PostgresGrammar))
#7 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(151): Illuminate\Database\Schema\Builder->build(Object(Illuminate\Database\Schema\Blueprint))
#8 /var/www/ojs-3.3.0-7/lib/pkp/classes/migration/upgrade/PKPv3_3_0UpgradeMigration.inc.php(114): Illuminate\Database\Schema\Builder->table('review_assignme...', Object(Closure))
#9 /var/www/ojs-3.3.0-7/lib/pkp/classes/install/Installer.inc.php(405): PKPv3_3_0UpgradeMigration->up()
#10 /var/www/ojs-3.3.0-7/lib/pkp/classes/install/Installer.inc.php(251): Installer->executeAction(Array)
#11 /var/www/ojs-3.3.0-7/lib/pkp/classes/install/Installer.inc.php(174): Installer->executeInstaller()
#12 /var/www/ojs-3.3.0-7/lib/pkp/classes/cliTool/UpgradeTool.inc.php(89): Installer->execute()
#13 /var/www/ojs-3.3.0-7/lib/pkp/classes/cliTool/UpgradeTool.inc.php(65): UpgradeTool->upgrade()
#14 /var/www/ojs-3.3.0-7/tools/upgrade.php(22): UpgradeTool->execute()
#15 {main}
Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[23502]: Not null violation: 7 ERROR: column "review_round_id" of relation "review_assignments" contains null values in /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException))
#1 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(464): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}('ALTER TABLE rev...', Array)
#3 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback('ALTER TABLE rev...', Array, Object(Closure))
#4 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(465): Illuminate\Database\Connection->run('ALTER TABLE rev...', Array, Object(Closure))
#5 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(102): Illuminate\Database\Connection->statement('ALTER TABLE rev...')
#6 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(290): Illuminate\Database\Schema\Blueprint->build(Object(Illuminate\Database\PostgresConnection), Object(Illuminate\Database\Schema\Grammars\PostgresGrammar))
#7 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(151): Illuminate\Database\Schema\Builder->build(Object(Illuminate\Database\Schema\Blueprint))
#8 /var/www/ojs-3.3.0-7/lib/pkp/classes/migration/upgrade/PKPv3_3_0UpgradeMigration.inc.php(114): Illuminate\Database\Schema\Builder->table('review_assignme...', Object(Closure))
#9 /var/www/ojs-3.3.0-7/lib/pkp/classes/install/Installer.inc.php(405): PKPv3_3_0UpgradeMigration->up()
#10 /var/www/ojs-3.3.0-7/lib/pkp/classes/install/Installer.inc.php(251): Installer->executeAction(Array)
#11 /var/www/ojs-3.3.0-7/lib/pkp/classes/install/Installer.inc.php(174): Installer->executeInstaller()
#12 /var/www/ojs-3.3.0-7/lib/pkp/classes/cliTool/UpgradeTool.inc.php(89): Installer->execute()
#13 /var/www/ojs-3.3.0-7/lib/pkp/classes/cliTool/UpgradeTool.inc.php(65): UpgradeTool->upgrade()
#14 /var/www/ojs-3.3.0-7/tools/upgrade.php(22): UpgradeTool->execute()
#15 {main}
Next Illuminate\Database\QueryException: SQLSTATE[23502]: Not null violation: 7 ERROR: column "review_round_id" of relation "review_assignments" contains null values (SQL: ALTER TABLE review_assignments ALTER review_round_id SET NOT NULL) in /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671
Stack trace:
#0 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback('ALTER TABLE rev...', Array, Object(Closure))
#1 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(465): Illuminate\Database\Connection->run('ALTER TABLE rev...', Array, Object(Closure))
#2 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(102): Illuminate\Database\Connection->statement('ALTER TABLE rev...')
#3 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(290): Illuminate\Database\Schema\Blueprint->build(Object(Illuminate\Database\PostgresConnection), Object(Illuminate\Database\Schema\Grammars\PostgresGrammar))
#4 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(151): Illuminate\Database\Schema\Builder->build(Object(Illuminate\Database\Schema\Blueprint))
#5 /var/www/ojs-3.3.0-7/lib/pkp/classes/migration/upgrade/PKPv3_3_0UpgradeMigration.inc.php(114): Illuminate\Database\Schema\Builder->table('review_assignme...', Object(Closure))
#6 /var/www/ojs-3.3.0-7/lib/pkp/classes/install/Installer.inc.php(405): PKPv3_3_0UpgradeMigration->up()
#7 /var/www/ojs-3.3.0-7/lib/pkp/classes/install/Installer.inc.php(251): Installer->executeAction(Array)
#8 /var/www/ojs-3.3.0-7/lib/pkp/classes/install/Installer.inc.php(174): Installer->executeInstaller()
#9 /var/www/ojs-3.3.0-7/lib/pkp/classes/cliTool/UpgradeTool.inc.php(89): Installer->execute()
#10 /var/www/ojs-3.3.0-7/lib/pkp/classes/cliTool/UpgradeTool.inc.php(65): UpgradeTool->upgrade()
#11 /var/www/ojs-3.3.0-7/tools/upgrade.php(22): UpgradeTool->execute()
#12 {main}
We found 15 different submissions with this sql:
select submission_id from review_assignments where review_round_id is null;
We searched for these submissions through the site and I managed to delete some, but others didn’t appear the option to delete. These are apparently incomplete submissions, without any information, just a file.
We remember that at the beginning of the system, predefined command lines were used to add the first editions. We believe it could be one of those files.
How could it delete from the database without causing damage?