CSV Import, 500 Error, gearman working

41 views
Skip to first unread message

r.ruti...@docuteam.ch

unread,
Jul 7, 2020, 7:50:13 AM7/7/20
to AtoM Users
Hi there

Whether I import a CSV globally or within an archival description and using the link on the right hand side, I get a 500 error.

(Import via command line works)

nginx log:

2020/07/07 13:41:48 [error] 1475#1475: *1 FastCGI sent in stderr: "PHP message: No Gearman worker available that can handle the job arFileImportJob" while reading response header from upstream, client: 10.81.234.17, server: server-name-hidden.ch, request: "POST /index.php/object/importSelect HTTP/1.1", upstream: "fastcgi://unix:/run/php7.0-fpm.atom-test.sock:", host: "server-name-hidden.ch", referrer: "https://server-name-hidden.ch/index.php/object/importSelect?type=csv"

But the worker is running:

atom-test-worker.service - AtoM worker test
   Loaded: loaded (/usr/lib/systemd/system/atom-test-worker.service; enabled; vendor preset: enabled)
   Active: active (running) since Tue 2020-07-07 13:41:39 CEST; 5s ago
  Process: 3472 ExecStop=/bin/kill -s TERM $MAINPID (code=exited, status=0/SUCCESS)
 Main PID: 3585 (php)
    Tasks: 1
   Memory: 15.1M
      CPU: 171ms
   CGroup: /system.slice/atom-test-worker.service
           └─3585 /usr/bin/php -d memory_limit=-1 -d error_reporting=E_ALL symfony jobs:worker

Jul 07 13:41:39 atom810 php[3585]: 2020-07-07 13:41:39 > New ability: arUpdatePublicationStatusJob
Jul 07 13:41:39 atom810 php[3585]: 2020-07-07 13:41:39 > New ability: arFileImportJob
Jul 07 13:41:39 atom810 php[3585]: 2020-07-07 13:41:39 > New ability: arInformationObjectXmlExportJob
Jul 07 13:41:39 atom810 php[3585]: 2020-07-07 13:41:39 > New ability: arXmlExportSingleFileJob
Jul 07 13:41:39 atom810 php[3585]: 2020-07-07 13:41:39 > New ability: arGenerateReportJob
Jul 07 13:41:39 atom810 php[3585]: 2020-07-07 13:41:39 > New ability: arActorCsvExportJob
Jul 07 13:41:39 atom810 php[3585]: 2020-07-07 13:41:39 > New ability: arActorXmlExportJob
Jul 07 13:41:39 atom810 php[3585]: 2020-07-07 13:41:39 > New ability: arRepositoryCsvExportJob
Jul 07 13:41:39 atom810 php[3585]: 2020-07-07 13:41:39 > Running worker...
Jul 07 13:41:39 atom810 php[3585]: 2020-07-07 13:41:39 > PID 3585

I restarted the worker, executed php symfony cc, even rebooted the server - nothing. Still the same.
Do you know what's going on? 
Many thanks in advance

Roger

r.ruti...@docuteam.ch

unread,
Jul 7, 2020, 6:37:58 PM7/7/20
to AtoM Users
I have an update on this:
I found out that the import job works if I set the language (in the Web-GUI, top right) to the default language. 
If I switch to another language, and import the same CSV, then the 500 Error appears as described above.

José Raddaoui

unread,
Jul 7, 2020, 7:43:13 PM7/7/20
to AtoM Users
Hi Roger,

That kind of rings a bell, good job finding that out. Could that be an AtoM 2.5.1 or lower instance, it looks like you are facing this issue:


Best regards.

r.ruti...@docuteam.ch

unread,
Jul 8, 2020, 4:51:02 AM7/8/20
to AtoM Users
Hi Radda
Yes, the customer is using AtoM 2.4. 
Thanks!
Roger

Reply all
Reply to author
Forward
0 new messages