Showing results for 
Search instead for 
Did you mean: 

Data loss on MaxDB after system crash

Former Member
0 Kudos

I have a Solution Manager 4.0 SP2 system running on SLES 9, 64 bit hardware and MaxDB Everything seemed to be OK until a few days ago. After offline backup the system didn't start anymore properly (log showed entires like "No license found for hardware ID", "Broken pipe in Module rslgsend" etc.). The backup procedure is controlled by a cronjob: stopsap, backup of files, startsap. Initially it looked like the system had restarted properly but surveillance showed that there were errors. We stopped it again and found out that there were still running processes under the <sys>adm user. We assumed they were zombies and deleted them using kill -9. Now the system started again without any problems - or that's what it looked like initally. Later I found out that more or less all data since the initial backup after installation (17.05.2007) was lost. Verification of the database doesn't show any corrupt structures (???). My assumption is that data was actually never really written to the database files but only cached in system memory (actually not much, just a bit of customizing and user data), no checkpoints set etc.. Did anyone else ever come across that problem and, if yes, is there any way to solve this issue permanently? Actually it's not the first time this happend: some time ago I had a 4.0 SP1 test system with the same problem when I tried to patch it. Back then I just thought I messed it up with the support packages and reinstalled it.

By the way: I didn't get anything useful out of SAPNet

Thanks in advance for any hint.



Message was edited by:

Andy Rohr

View Entire Topic
Active Contributor
0 Kudos

And to your second question about "data loss":

It's possible that your log area was full, the database was stuck (in Oracle terms this would be something like an "archiver stuck").

After your stopped/killed/reboot the system, the system did roll back until the latest successfully savepoint/checkpoint.



Former Member
0 Kudos

Hi Markus,

OK - thanks a lot - i guess that explains my problem.