Error when trying to start SAS Web Infrastructure Data Server

Aasth — Mon, 21 Dec 2020 14:06:19 GMT

We are seeing the following error when trying to start our SAS Web Infrastructure Data Server:

2020-12-20 17:00:54.097 CSTLOG: database system was interrupted while in recovery at 2020-12-20 16:49:43 CST
2020-12-20 17:00:54.097 CSTHINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
2020-12-20 17:00:54.097 CSTLOG: database system was not properly shut down; automatic recovery in progress
2020-12-20 17:00:54.100 CSTLOG: redo starts at D/C317090
2020-12-20 17:00:55.531 CSTFATAL: could not access status of transaction 0
2020-12-20 17:00:55.531 CSTDETAIL: Could not open file "pg_clog/0008": Permission denied.
2020-12-20 17:00:55.531 CSTCONTEXT: xlog redo zeropage: 256
2020-12-20 17:00:55.532 CSTLOG: startup process (PID 11731154) exited with exit code 1
2020-12-20 17:00:55.532 CSTLOG: aborting startup due to startup process failure

Please help

Re: Error when trying to start SAS Web Infrastructure Data Server

AnandVyas — Mon, 21 Dec 2020 14:28:42 GMT

Hi @Aasth

As the log suggests there might be some system events that have caused corruption to the WIPDS. Was the shutdown not done gracefully? As the log suggests, if you have a recent backup of system, you can try to recover using that. However do note that depending upon the last backup date and time some data might be lost.

Also, I see some issues related to access in the shared logs. Was there any manual changes made to the file system permissions or the files under sas-config directory? I would suggest you to check that as well.

2020-12-20 17:00:55.531 CSTDETAIL: Could not open file "pg_clog/0008": Permission denied.

My advise would be to raise a SAS Technical support track to help you with the recovery.

topic Re: Error when trying to start SAS Web Infrastructure Data Server in Administration and Deployment

Error when trying to start SAS Web Infrastructure Data Server

Re: Error when trying to start SAS Web Infrastructure Data Server