{"id":3467,"date":"2017-07-21T20:49:07","date_gmt":"2017-07-21T20:49:07","guid":{"rendered":"https:\/\/qbytes.cloud\/?p=3467"},"modified":"2017-07-21T20:49:07","modified_gmt":"2017-07-21T20:49:07","slug":"installing-apps-application-vault-hangs","status":"publish","type":"post","link":"https:\/\/www.qbytes.cloud\/index.php\/2017\/07\/21\/installing-apps-application-vault-hangs\/","title":{"rendered":"Installing Apps from Plesk Application Vault Hangs"},"content":{"rendered":"<p>When the WordPress Install button is pressed (including the custom install option) in Application Vault, a progress bar is shown but never changes from 0%.<br \/>\n<a href=\"https:\/\/qbytes.cloud\/wp-content\/uploads\/2017\/07\/Capture56.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3474 size-full\" src=\"https:\/\/qbytes.cloud\/wp-content\/uploads\/2017\/07\/Capture56.png\" alt=\"\" width=\"947\" height=\"200\" srcset=\"https:\/\/www.qbytes.cloud\/wp-content\/uploads\/2017\/07\/Capture56.png 947w, https:\/\/www.qbytes.cloud\/wp-content\/uploads\/2017\/07\/Capture56-300x63.png 300w, https:\/\/www.qbytes.cloud\/wp-content\/uploads\/2017\/07\/Capture56-768x162.png 768w\" sizes=\"auto, (max-width: 947px) 100vw, 947px\" \/><\/a><\/p>\n<p>Log into Plesk.<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">Click &quot;Tools and Utilities&quot; &gt; &quot;Application Vault&quot; &gt; &quot;My Apps&quot;.\n\n<\/pre>\n<p>Try installing the app. Here, the notification bar shows: Please wait&#8230;. 0%.\u00a0This bar may remain the same for several hours with nothing happening.<\/p>\n<p><strong>Cause<\/strong><\/p>\n<p>A large number of applications are stuck in the psa.longtasks table.\u00a0Or MySQL service is down.<\/p>\n<p><strong>Resolution<\/strong><\/p>\n<p>Backup the psa database by following the instructions in <a href=\"https:\/\/support.plesk.com\/hc\/en-us\/articles\/213904125\" target=\"_blank\" rel=\"noopener\">KB #213904125<\/a><\/p>\n<p>Make sure that MySQL service is running:<\/p>\n<p>Linux:<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\"># service mysqld status \n# systemctl status mysqld.service \n# systemctl status mariadb\n<\/pre>\n<p>Windows:<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">&amp;gt; net start MySQL\n\n<\/pre>\n<p>Check that \/dev\/null has permissions crw-rw-rw-:<br \/>\nLinux:<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\"> ls -la \/dev\/null\ncrw-rw-rw-. 1 root root 1, 3 Jul 19 15:15 \/dev\/null\n<\/pre>\n<p>Log into MySQL and access the psa database:<\/p>\n<p>Linux:<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">MYSQL_PWD=`cat \/etc\/psa\/.psa.shadow` mysql -uadmin psa\n\n<\/pre>\n<p>Windows:<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">&quot;%plesk_dir%&quot;\\\\MySQL\\\\bin\\\\mysql.exe -uadmin -p psa -P8306\n\n<\/pre>\n<p>Check the long tasks that are present on the server:<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">mysql&amp;gt; select * from longtasks;\n\n<\/pre>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">+----+--------------+---------+-------------+-----------------+----------------+----------------+-------------+---------------+---------------------+---------------------+-------+\n| id | type         | context | status      | statusProcessed | progressStatus | progressParams | progressMax | progressValue | startTime           | finishTime          | pid   |\n+----+--------------+---------+-------------+-----------------+----------------+----------------+-------------+---------------+---------------------+---------------------+-------+\n|  1 | aps-download | NULL    | started     |               0 | queue          | NULL           |         100 |             0 | 2017-07-21 13:34:03 | 0000-00-00 00:00:00 |     0 |\n|  2 | aps-cache    | NULL    | done        |               0 | done           | NULL           |         100 |           100 | 2017-07-21 13:35:56 | 2017-07-21 13:35:56 | 31908 |\n|  3 | aps-cache    | NULL    | done        |               0 | done           | NULL           |         100 |           100 | 2017-07-21 13:36:23 | 2017-07-21 13:36:23 | 31973 |\n|  4 | aps-download | NULL    | not_started |               0 | queue          | NULL           |         100 |             0 | 2017-07-21 13:48:42 | 0000-00-00 00:00:00 |     0 |\n|  5 | aps-cache    | NULL    | done        |               0 | done           | NULL           |         100 |           100 | 2017-07-21 13:57:51 | 2017-07-21 13:57:51 |  4515 |\n+----+--------------+---------+-------------+-----------------+----------------+----------------+-------------+---------------+---------------------+---------------------+-------+\n\n<\/pre>\n<p>Delete these tasks:<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">mysql&amp;gt; truncate longtasks;\nmysql&amp;gt; truncate longtaskparams;\n\n<\/pre>\n<p>Make sure \/etc\/localtime file has 644 permissions:<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n# ls -la \/etc\/localtime\n<\/pre>\n<p>If not, set it:<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n\n# chmod 644 \/etc\/localtime\n\n<\/pre>\n<p>Try installing the application again.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When the WordPress Install button is pressed (including the custom install option) in Application Vault, a progress bar is shown but never changes from 0%. Log into Plesk. Click &quot;Tools and Utilities&quot; &gt; &quot;Application Vault&quot; &gt; &quot;My Apps&quot;. Try installing the app. Here, the notification bar shows: Please wait&#8230;. 0%.\u00a0This bar may remain the same &#8230; <a title=\"Installing Apps from Plesk Application Vault Hangs\" class=\"read-more\" href=\"https:\/\/www.qbytes.cloud\/index.php\/2017\/07\/21\/installing-apps-application-vault-hangs\/\" aria-label=\"Read more about Installing Apps from Plesk Application Vault Hangs\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[86],"tags":[],"class_list":["post-3467","post","type-post","status-publish","format-standard","hentry","category-plesk"],"_links":{"self":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/posts\/3467","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/comments?post=3467"}],"version-history":[{"count":0,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/posts\/3467\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/media?parent=3467"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/categories?post=3467"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/tags?post=3467"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}