New Image Upload - Stuck on Updating Database

[Scott B]

Pushing up a new image and everything seems to go fine until the very end where it updates the database. It will sit for a long time, eventually retry, and eventually fail and reboot.

FOG 1.5.6.2
Ubuntu 18.04.2

[Sebastian Roth]

@Scott-B Are you able to access the FOG web UI just fine while it hangs at that stage? Also check the PHP FPM log (see my signature).

[Scott B]

@Sebastian-Roth said in New Image Upload - Stuck on Updating Database:

@Scott-B Are you able to access the FOG web UI just fine while it hangs at that stage? Also check the PHP FPM log (see my signature).

GUI is working great during that time. Error on using the command in your sig.

root@fogserver:/# php-fpm log (/var/log/php*-fpm.log)
-bash: syntax error near unexpected token `('

[george1421]

@Scott-B Can you manually look at the end of the php-fpm error log for any signs of an error. The error may be on multiple lines. You should not normally see html code in the console screen.

[Scott B]

@george1421 said in New Image Upload - Stuck on Updating Database:

php-fpm error log

root@fogserver:/# tail /var/log/php7.2-fpm.log

[28-May-2019 18:58:44] NOTICE: [pool www] child 820 exited with code 0 after 989.730318 seconds from start
[28-May-2019 18:58:44] NOTICE: [pool www] child 11586 started
[28-May-2019 18:58:44] NOTICE: [pool www] child 813 exited with code 0 after 990.608738 seconds from start
[28-May-2019 18:58:44] NOTICE: [pool www] child 11587 started
[28-May-2019 18:58:47] NOTICE: [pool www] child 836 exited with code 0 after 991.969990 seconds from start
[28-May-2019 18:58:47] NOTICE: [pool www] child 11632 started
[28-May-2019 19:04:56] NOTICE: [pool www] child 4953 exited with code 0 after 990.381560 seconds from start
[28-May-2019 19:04:56] NOTICE: [pool www] child 15598 started
[28-May-2019 19:05:41] NOTICE: [pool www] child 5491 exited with code 0 after 983.723588 seconds from start
[28-May-2019 19:05:41] NOTICE: [pool www] child 16055 started

[george1421]

@Scott-B Yeah that’s not helpful (not you, but the errors). You will need to look back in time to see when that error was created (or make a new error) and correlate the error with the action.

[Scott B]

@george1421 said in New Image Upload - Stuck on Updating Database:

I have an image going up now. I’ll see what it does.

[Scott B]

@Scott-B said in New Image Upload - Stuck on Updating Database:

@george1421 said in New Image Upload - Stuck on Updating Database:

I have an image going up now. I’ll see what it does.

Well those two images just completed successfully, so I don’t know what the deal was. The 4 test images before them all had the error.

[Sebastian Roth]

@Scott-B Pleas run find /var -type f -name "*fpm*log*" and post results here.

Ahhh, forget about that. Ubuntu has the errors in apache error log as far as I remember. Please take a look at /var/log/apache2/error.log and maybe paste the whole log messages from yesterday and today here.