CSV Import, 500 Error, gearman working

[r.ruti...@docuteam.ch]

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]

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]

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:

https://projects.artefactual.com/issues/13108

Best regards.

[r.ruti...@docuteam.ch]

Hi Radda

Yes, the customer is using AtoM 2.4. 

Thanks!

Roger