Article Number: 516032

printer Print mail Email

AppSync: Postgres upgrade fails

Primary Product: AppSync

Product: AppSync 3.5 more...

Last Published: 23 Mar 2020

Article Type: Break Fix

Published Status: Online

Version: 4

AppSync: Postgres upgrade fails

Article Content

Issue


Postgres is being upgraded per KB 000504125, and it fails to upgrade Postgres.

The appsync_dbupgrade.log will show:
 
Command.run(): C:\Users\userid\AppData\Local\Temp\2\011266.tmp\executeScriptTmp0.bat:stdout [Failure, exiting]
Command.complete(): process completed with exit code: 1

The pg_upgrade_utility.log will show:
 
command: xcopy /e /y /q /r "E:\EMC\AppSync\jboss\datastore\data/pg_clog" "E:\EMC\AppSync\NewDatastore\data/pg_clog\" >> "pg_upgrade_utility.log" 2>&1
Invalid drive specification
0 File(s) copied

Note: The pg_upgrade_utility.log located in %AppData% will be removed when clicking OK when the failed upgrade message is presented during the upgrade dialog. Therefor this file must be collected before clicking OK and existing the upgrade dialog.

Note: The AppSync database resides in a non-default location, the E: drive in this example.
Cause
The trigger is a permission related issue for which the precise cause is not known.
The upgrade utility is being run as administrator and the user who is logged in when the upgrade utility is run as administrator via the right click method is a Domain administrator which exists in the local admin group which has full rights to the E: drive.

Regardless, should you use procmon to debug, you will find permission errors for the logged in user to the E: drive.
Resolution
Explicitly provide full administrative right to the E: drive for the specific user that is logged in when running the upgrade process.
Notes

Issue


Postgres is being upgraded per KB 000504125, and it fails to upgrade Postgres.

The appsync_dbupgrade.log will show:
 
Command.run(): C:\Users\userid\AppData\Local\Temp\2\011266.tmp\executeScriptTmp0.bat:stdout [Failure, exiting]
Command.complete(): process completed with exit code: 1

The pg_upgrade_utility.log will show:
 
command: xcopy /e /y /q /r "E:\EMC\AppSync\jboss\datastore\data/pg_clog" "E:\EMC\AppSync\NewDatastore\data/pg_clog\" >> "pg_upgrade_utility.log" 2>&1
Invalid drive specification
0 File(s) copied

Note: The pg_upgrade_utility.log located in %AppData% will be removed when clicking OK when the failed upgrade message is presented during the upgrade dialog. Therefor this file must be collected before clicking OK and existing the upgrade dialog.

Note: The AppSync database resides in a non-default location, the E: drive in this example.
Cause
The trigger is a permission related issue for which the precise cause is not known.
The upgrade utility is being run as administrator and the user who is logged in when the upgrade utility is run as administrator via the right click method is a Domain administrator which exists in the local admin group which has full rights to the E: drive.

Regardless, should you use procmon to debug, you will find permission errors for the logged in user to the E: drive.
Resolution

Explicitly provide full administrative right to the E: drive for the specific user that is logged in when running the upgrade process.

Notes

Article Attachments

Attachments

Attachments

Article Properties

First Published

Thu Jan 18 2018 17:58:12 GMT

First Published

Thu Jan 18 2018 17:58:12 GMT

Rate this article

Accurate
Useful
Easy to understand
Was this article helpful?
0/3000 characters