Crash -FBM - Illegal conversion of block 2/27398 from state [Occupied,Free]

[Former Member]

Hi,

today the system crash with the follow, message on knldiag file:

739:  2008-06-06 08:53:25  2985 ERR 20005 FBM      Illegal conversion of block 2/27398 from state [Occupied,Free] to [Occupied,Free]
740:  2008-06-06 08:53:25  2985 ERR 20008 Converte Error occured by processing pageno 145158 (perm)
741:  2008-06-06 08:53:25  2985 ERR 11196 DBCRASH  vabort:Emergency Shutdown, Converter_Converter.cpp: 531
...

i tried to restart and always get same message, and cant put the database on-line again.

any idea to solve this?

best regards

Clóvis

[henrik_hempelmann · Accepted solution]

Clovis,

the converter stores for at least two different pages the same block address on the volumes. Page 145158 is the second one to reference block number 27398 on data volume 2.

There is no fix for this besides restoring the database from backup.

But what happened to the database? Do you experience memory or storage problems?

Special operation conditions?

What version was the database running on?

Regards,

Henrik

[Former Member · Accepted solution]

Hi, Henrik

The version is 7.6.03.15, i just shutdown the system yesterday and today on reboot i get this problem, i restored from a old complete backup, my luck is that this is running in a test database then if i loss data that is in log i dont have problems, but if that occurs on a production system, and i have just the one complete backup, and only autolog backup, the data that is in log area and not restored from autolog backup, will be lost?

best regards

Clóvis

[henrik_hempelmann · Accepted solution]

Clóvis,

all the data in your productive scenario can be restored.

You'll restore the full data backup, the log from the auto-log files and finally the log entries from the log area - which is still intact. The defects converter entries do not affect the log area, just the data area.

regards,

Henrik