Module pages (Image Gallery, eShop, other) cannot be opened in Sitebuilder Wizard - the page is loaded and finally gives "Internal Server Error". The following error appears in the log file:
/var/log/httpd/sitebuilder_error.log --->8--- [Wed Nov 21 06:28:56 2012] [warn] [client 184.108.40.206] Timeout waiting for output from CGI script /opt/php52/cgi-bin/php5, referer: http://sitebuilder.hostname/Wizard/Edit/Html?currentPageId=fhxq2ly0rfa ---8<---
Where sitebuilder.hostname is hostname of Parallels Plesk Sitebuilder.
File sb_modules.php-journal with zero size, permission 000 and a random timestamp exits in subdirectory /data/storage/ near regular database file sb_modules.php:
~# ls -l /VAR/WWW/VHOSTS/site.tld/httpdocs/data/storage/ total 44 drwxrwxrwx 2 sb45 psacln 4096 Nov 15 14:04 attachments -rwxrwxrwx 1 sb45 psacln 40960 Nov 15 14:16 sb_modules.php ---------- 1 root root 0 May 31 2018 sb_modules.php-journal ~#
There "/VAR/WWW/VHOSTS/site.tld/httpdocs/" is publishing location of site site.tld.
When you edit modules through Wizard or publish a site with changed modules, Parallels Plesk Sitebuilder 4.5 updates SQLite database file sb_modules.php on the publishing host. File sb_modules.php-journal is created by SQLite at the start of a transaction and removed upon commit. Here you may find some detail:
--->8--- SQLite by default creates the journal file at the start of a transaction, which is a good thing. Normally it deletes the file upon commit. ---8<---
--->8--- The rollback journal is always located in the same directory as the database file and has the same name as the database file except with the 8 characters "-journal" appended. The rollback journal is usually created when a transaction is first started and is usually deleted when a transaction commits or rolls back. ---8<---
File sb_modules.php-journal remain because the publishing process was not completed successfully.
The issue might be caused by NFS share where to the sites are published.
- Add option "nolock" to NFS mount parameters
- Change site publishing location – the site should be published into real directory, not to NFS share.
- Migrate affected sites to Parallels Presence Builder that works without SQLite database.
Refer to this KB for the detail.
Note: all files sb_modules.php-journal are temporary ones, they may be safely removed.