External Interface Design for PP-756

PP-756 - Getting issue details... STATUS

forum discussion.

Interface 1: New server log message indicating that PBS database needs to be upgraded: 

  • Visibility: Public
  • Change Control: Stable
  • Synopsis: Server log to indicate that the PBS database needs to be upgraded along with postgresql. 
  • Details: When postgresql is upgraded outside PBS and PBS database is not upgraded, PBS dataservice fails to come up.
    • PBS does not package postgresql, so postgresql gets installed (if not already installed on the system) when pbs is installed through a package manager.
    • There is a possibility that the admin upgrades postgresql and does not upgrade PBS database using pg_upgrade from the newer version of postgresql.
    • In this case, when PBS is started, PBS dataservice fails to come up.
    • This new log is added to inform the admin that PBS database needs to be upgraded and also provides a link to the steps to perform the upgrade.
    • This message is also displayed on the console when PBS is started.
    • Example: 
      • Failed to start PBS dataservice:[2018-05-30 23:02:16 UTCFATAL: database files are incompatible with server
        2018-05-30 23:02:16 UTCDETAIL: The data directory was initialized by PostgreSQL version 9.2, which is not compatible with this version 9.3.23.
        PBS database needs to be upgraded.
        Please follow the upgrade instructions in the release notes for the v18.1.2 release at:
        https://github.com/PBSPro/pbspro/releases]

Interface 2: pbs_habitat message indicating that PBS database needs to be upgraded: 

  • Visibility: Public
  • Change Control: Stable
  • Synopsis: pbs_habitat to indicate that the PBS database needs to be upgraded along with postgresql. 
  • Details: When postgresql is upgraded outside PBS and PBS database is not upgraded, PBS dataservice fails to come up.
    • PBS does not package postgresql, so postgresql gets installed (if not already installed on the system) when pbs is installed through a package manager.
    • There is a possibility that the admin upgrades postgresql and at the same time upgrades PBS as well, but does not upgrade PBS database.
    • In this case, pbs_habitat will find that PBS database version is different from the postgres version. 
    • This new message is added to inform the admin that PBS database needs to be upgraded and also provides a link to the steps to perform the upgrade.
    • Example: 
      • It appears that PostgreSQL has been upgraded independently of PBS Pro.
        The PBS Pro database must be manually upgraded. Please refer to the
        instructions in the release notes for version 18.1.1 located here:
        https://github.com/PBSPro/pbspro/releases