PKP PN fatal error (in progress)

Software Support
1

Hi @jonasraoni ,
Unfortunately, I have to open this issue once again

After waiting for three weeks, SJOM Vol 4 no 4 is still showing “in progress” and following error appear in php error log every day as well:

[26-Aug-2024 14:37:02 Asia/Riyadh] PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘as do where do.journal_id not in (select j.journal_id from `journal…’ at line 1 in /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:566
Stack trace:
#0 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(566): PDO->prepare()
#1 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database{closure}()
#2 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#3 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(558): Illuminate\Database\Connection->run()
#4 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(522): Illuminate\Database\Connection->affectingStatement()
#5 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3550): Illuminate\Database\Connection->delete()
#6 /home/seisense/journal.seisense.com/plugins/generic/pln/classes/depositObject/DAO.php(256): Illuminate\Database\Query\Builder->delete()
#7 /home/seisense/journal.seisense.com/plugins/generic/pln/classes/depositObject/Repository.php(258): APP\plugins\generic\pln\classes\depositObject\DAO->pruneOrphaned()
#8 /home/seisense/journal.seisense.com/plugins/generic/pln/classes/tasks/Depositor.php(308): APP\plugins\generic\pln\classes\depositObject\Repository->pruneOrphaned()
#9 /home/seisense/journal.seisense.com/plugins/generic/pln/classes/tasks/Depositor.php(148): APP\plugins\generic\pln\classes\tasks\Depositor->pruneOrphaned()
#10 /home/seisense/journal.seisense.com/lib/pkp/classes/scheduledTask/ScheduledTask.php(165): APP\plugins\generic\pln\classes\tasks\Depositor->executeActions()
#11 /home/seisense/journal.seisense.com/plugins/generic/acron/AcronPlugin.php(281): PKP\scheduledTask\ScheduledTask->execute()
#12 /home/seisense/journal.seisense.com/plugins/generic/acron/AcronPlugin.php(195): APP\plugins\generic\acron\AcronPlugin->_shutdownFunction()
#13 [internal function]: APP\plugins\generic\acron\AcronPlugin->APP\plugins\generic\acron{closure}()
#14 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'as do where do.journal_id not in (select j.journal_id from journal...' at line 1 (SQL: delete from pln_deposit_objectsasdowheredo.journal_idnot in (selectj.journal_idfromjournalsasj) or do.deposit_idnot in (selectd.deposit_idfrompln_depositsasd`)) in /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
Stack trace:
#0 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#1 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(558): Illuminate\Database\Connection->run()
#2 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(522): Illuminate\Database\Connection->affectingStatement()
#3 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3550): Illuminate\Database\Connection->delete()
#4 /home/seisense/journal.seisense.com/plugins/generic/pln/classes/depositObject/DAO.php(256): Illuminate\Database\Query\Builder->delete()
#5 /home/seisense/journal.seisense.com/plugins/generic/pln/classes/depositObject/Repository.php(258): APP\plugins\generic\pln\classes\depositObject\DAO->pruneOrphaned()
#6 /home/seisense/journal.seisense.com/plugins/generic/pln/classes/tasks/Depositor.php(308): APP\plugins\generic\pln\classes\depositObject\Repository->pruneOrphaned()
#7 /home/seisense/journal.seisense.com/plugins/generic/pln/classes/tasks/Depositor.php(148): APP\plugins\generic\pln\classes\tasks\Depositor->pruneOrphaned()
#8 /home/seisense/journal.seisense.com/lib/pkp/classes/scheduledTask/ScheduledTask.php(165): APP\plugins\generic\pln\classes\tasks\Depositor->executeActions()
#9 /home/seisense/journal.seisense.com/plugins/generic/acron/AcronPlugin.php(281): PKP\scheduledTask\ScheduledTask->execute()
#10 /home/seisense/journal.seisense.com/plugins/generic/acron/AcronPlugin.php(195): APP\plugins\generic\acron\AcronPlugin->_shutdownFunction()
#11 [internal function]: APP\plugins\generic\acron\AcronPlugin->APP\plugins\generic\acron{closure}()
#12 {main}
thrown in /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 760

Problem is with this specific issue only. All other issues before and after are deposited successfully

image
image1574×1355 205 KB

Hope you will investigate and help me fixing this problem.
Thanks
seisense

2

Hi!

There’s an issue in the repository to cover this: Fatal error when running under MariaDB · Issue #90 · pkp/pln · GitHub

I’ll get it done tomorrow, it’s a simple fix. Once it’s done, you’ll just need to upgrade your plugin through the plugin gallery.

Best,
Jonas Raoni

3

Hi @jonasraoni ,
I have updated the plugin, and it no longer logs any errors in the PHP error log. However, the status has remained “in progress” for the past three days.

Below is my jouranl unique identifier for journal 1:
5C27606A-486B-40FC-91EC-46DFD735FBB1

Journal 2:
45EF22D5-210E-48A4-9A73-3F283F1016EB

Looking forward for your support
Thanks
seisense

4

Hi!

Everything is fine on your side, for now I can say the deposit is going to take a couple of days to be moved to preserved, one of the nodes is under maintenance.

Best,
Jonas

5

Hi @jonasraoni ,
Just to let you know, problem is still not resolved and issue is still showing the current status “in process”.
Thanks
seisense

6

Hi @jonasraoni ,
May I know if there is anything further I need to do as the problem is still not resolved.
Thanks

7

Hi!

The problems should be vanished, just wait a couple of days to see the progress update :slight_smile:

Best,
Jonas Raoni