Import Products - Internal Server Error 500

[vm0824]

I am trying to load some products using a xlsx file. I get varyingly far into the import before I receive a generic error on the import screen. In Chromes Network Tools I see its a 500 error underlyingly. I have tried to import in smaller chunks but the point in which it fails continues to change. Sometimes it'll fail after just 30 items, or even during validation. Each time it provides no useful information.

I have seen many similar issues in other forum posts with no solution. Only one mentioned that it wasnt actually broken and that if we checked in the console that it was still importing even though it'd thrown an error. However I have no way to validate it imported successfully since I am updating existing records (reusing and forcing IDs). 

PS 1.7.3.1

PHP 5.6.35

Memory Limit 712MB

Max Execution 300 seconds

Upload Max File Size 1024MB

[jetx]

What does your server log say regarding what triggered the 500? It could be Mod Security rules. Also have you tried using a csv?

[vm0824]

I have tried a CSV. I have asked NameCheap to disable mod_security, but that did not help either. I am not sure I know how to see the server logs (its a shared hosting platform).

[vm0824]

If it were mod_security, .htaccess, or permissions, wouldnt it fail right at the beginning? It seems to get started and make it varying lengths before failing. 

[vm0824]

I can also confirm via TOP that when the error occurs, the php-cgi process stops consuming resources. So its not still running in the background.

[vm0824]

I was able to find this in the log:

[Fri May 04 08:27:09.624757 2018] [fcgid:error] [pid 460330] mod_fcgid: process /home/turbgbql/.system/fcgid/turboarmory.com.cgi(587361) exit(communication error), get unexpected signal 11

Running php 5.6 with zend_guard_loader and opcache. also the extensions listed in this screenshot

[vm0824]

NameCheap is now stating that they have a 30 second timeout on Apache that is causing this. Its because I'm on the shared hosting platform. Soooo, I was under the impression that each submission of 5 or 10 items to import was sort of its own timer and they didnt cumulatively reach 30 seconds. Also it appears to be sporadic when it is actually killed, often more than 30 seconds. 

Any ideas?

[mrbatyo]

hello, step by step 

1 unable debug mod on yours site BO 

2 after seeing why get vóback the server  500 server error

for example to me - must unable apcu extension on my server cpanel

thx

Edited March 31, 2019 by mrbatyo (see edit history)