In Progress [CPANEL-27658] cPanel update fails with PostgreSQL error

m.eid

Well-Known Member
Jun 4, 2014
56
7
83
Jordan
cPanel Access Level
Root Administrator
Twitter
I've tried o retry update the system and the error has disappeared but new one appeared

Code:
[2019-05-30 03:20:24 +0300] E [/usr/local/cpanel/bin/postgrescheck] The “/usr/local/cpanel/bin/postgrescheck --check-auth --reset-pass-on-fail” command (process 23260) reported error number 1 when it ended.
...
[2019-05-30 03:20:36 +0300] - Finished command `/usr/local/cpanel/bin/cloudlinux_update` in 0.046 seconds
[2019-05-30 03:20:36 +0300] Processing: Updating plugins data cache
[2019-05-30 03:20:36 +0300] - Processing command `/usr/local/cpanel/bin/refresh_plugin_cache`
[2019-05-30 03:20:36 +0300] - Finished command `/usr/local/cpanel/bin/refresh_plugin_cache` in 0.025 seconds
[2019-05-30 03:20:36 +0300] Processing: Ensuring SSL certificate information for CCS is up to date.
[2019-05-30 03:20:36 +0300] - Processing command `/usr/local/cpanel/scripts/ccs-check --run --ssl`
[2019-05-30 03:20:36 +0300] [/usr/local/cpanel/scripts/ccs-check] SSL information updated.
[2019-05-30 03:20:36 +0300] - Finished command `/usr/local/cpanel/scripts/ccs-check --run --ssl` in 0.057 seconds
[2019-05-30 03:20:36 +0300] Processing: Ensure cpanel-plugins yum repo exists
[2019-05-30 03:20:36 +0300] - Finished in 0.019 seconds
[2019-05-30 03:20:36 +0300] Processing: Checking and provisioning LiteSpeed if licensed
[2019-05-30 03:20:36 +0300] - Processing command `/usr/local/cpanel/scripts/litespeed-check --run`
[2019-05-30 03:20:56 +0300] [/usr/local/cpanel/scripts/litespeed-check] No license found for LiteSpeed Web Server in cPanel Store.
[2019-05-30 03:20:56 +0300] - Finished command `/usr/local/cpanel/scripts/litespeed-check --run` in 20.516 seconds
[2019-05-30 03:20:56 +0300] Processing: Checking End Of Life for current version.
[2019-05-30 03:20:56 +0300] - Finished in 0.071 seconds
[2019-05-30 03:20:56 +0300] Processing:
[2019-05-30 03:20:56 +0300] Maintenance complete. [state=post]
=> Log closed Thu May 30 03:20:56 2019
----------------------------------------------------------------------------------------------------
=> Log opened from cPanel Update (upcp) - Slave (22017) at Thu May 30 03:20:56 2019
 

cPanelMichael

Technical Support Community Manager
Staff member
Apr 11, 2011
47,910
2,233
363
cPanel Access Level
DataCenter Provider
Twitter
Hello @m.eid,

I've moved this issue into a separate thread.

Actually, I've uninstalled it by this command since I don't need it, is there any issue with that?
yum remove postgresql
Can you verify how PostgreSQL was previously installed on the affected system?

Thank you.
 
Last edited:

cPanelMichael

Technical Support Community Manager
Staff member
Apr 11, 2011
47,910
2,233
363
cPanel Access Level
DataCenter Provider
Twitter
Hello @m.eid,

Thank you for providing the additional information.

PostgreSQL is a required dependency for the Calendar and Contacts Server plugin, and this plugin's installation process automatically installs the required PostgreSQL RPMs on servers where PostgreSQL was not previously installed. While the required PostgreSQL RPMs are automatically installed, PostgreSQL is not automatically restarted during the Calendar and Contacts Server plugin installation process. This leads to the following errors during subsequent cPanel updates:

Code:
[2019-05-30 11:39:49 -0500] - Processing command `/usr/local/cpanel/bin/postgrescheck --check-auth --reset-pass-on-fail`
[2019-05-30 11:39:49 -0500] [/usr/local/cpanel/bin/postgrescheck] 0
[2019-05-30 11:39:49 -0500] E [/usr/local/cpanel/bin/postgrescheck] The "/usr/local/cpanel/bin/postgrescheck --check-auth --reset-pass-on-fail" command (process 1559) reported error number 1 when it ended.
[2019-05-30 11:39:49 -0500] The Administrator will be notified to review this output when this script completes
[2019-05-30 11:39:49 -0500] - Finished command `/usr/local/cpanel/bin/postgrescheck --check-auth --reset-pass-on-fail` in 0.282 seconds
And:

Code:
[2019-05-30 11:39:53 -0500] E Pre Maintenance ended, however it did not exit cleanly (256). The following events were logged: "bin/postgrescheck", Please check the logs for an indication of what happened
Internal case CPANEL-27658 is now open to address this issue. I'll monitor the case and update this thread with more information as it becomes available.

In the meantime, the temporary workaround is to restart PostgreSQL, and start the cPanel update process again:

Code:
/scripts/restartsrv_postgresql
/scripts/upcp
Thank you.