Express 15.00.8_Sles11 worked fine for 2 weeks then "RDBMS CRASHED or SESSION RESET Recovery in progress"

Teradata Express Software
Formerly this board name was Cloud Computing. The name was changed to better represent the product areas covered.
Enthusiast

Express 15.00.8_Sles11 worked fine for 2 weeks then "RDBMS CRASHED or SESSION RESET Recovery in progress"

15 has bee working fine, then stopped with "CRASHED" error, I cannot logon using sqla,bteq  or run any console utilities as root.

I can still open the console as Root. Pdestate is Run/Ready. I've gone through the exercise of deinstalling and restarting.

I also have 14.10 Sles 11 installed and it is still working fine.

Any help would be appreciated.

thanks, 

Rglass

3 REPLIES
Senior Apprentice

Re: Express 15.00.8_Sles11 worked fine for 2 weeks then "RDBMS CRASHED or SESSION RESET Recovery in progress"

Hi Robert,

what's returned by pdestate -a?

And check /var/log/messages for Teradata related messages

Enthusiast

Re: Express 15.00.8_Sles11 worked fine for 2 weeks then "RDBMS CRASHED or SESSION RESET Recovery in progress"

pdestate - a = DBS is not running

 

/var/log/messages

Application not started because all amps are in NewProc or Fatal State.

 

--the last command I ran was tpareset

Senior Apprentice

Re: Express 15.00.8_Sles11 worked fine for 2 weeks then "RDBMS CRASHED or SESSION RESET Recovery in progress"

Something killed your AMPs :-(

The reason should be somewhere in the messages, too.

I don't know if this can be fixed or you need to use a new VM, you hopefully kept the ZIP file...