InterSystems IRIS.DAT file corrupted

Question

Question

Ephraim Malane · Dec 22, 2022

Hi Community,

My IRIS.DAT file is corrupted on one of my Edge productions in the development environment and as a result, I cannot start production.

I would like to recover it if there is a way to do so, please assist.

Regards,

Product version: IRIS 2020.2

Discussion (8)4

Log in or sign up to continue

Dmitry Maslennikov · Dec 22, 2022

You should ask WRC, for the help if you have support

0 0

Tomas Vaverka · Dec 22, 2022

If you are a supported customer (with the license under support - SUTA), please contact WRC. More details you can find at https://www.intersystems.com/support/

0 0

Enrico Parisi · Dec 22, 2022

I haven't seen a database corruption for many years, I literally forgot the last time I saw it, it may be 15+ years or more. And in the past (last millennium) I've seen and dealt db corruption.

Out of curiosity, what are the symptoms or your corruption? How did it happened?

0 0

Danny Wijnschenk · Dec 24, 2022

To check if a database is corrupt : Do ^INTEGRIT

To repair a database : Do ^REPAIR (But if you don't know this utility or the internals of database blocks and pointers : don't use it !!!)

0 0

Yaron Munz · Dec 30, 2022

Ephraim,

When you say "corrupted" to better understand...
- Did you try to mount the DB (from the SMP of with ^MOUNT)? Sometimes if IRIS/Cache was "forced" than a *.lck file on the DB folder need to be deleted in order to allow a successful mount.
- If the DB is mounted, did you got a <DATABASE> (or other) error? if so, then what was said using ^Integrity and ^Repair could help - but only if you fully understand how to use those tools (!) Most of the time, a corrupted DB is fixable using those tools, or at least data can be 99% recovered. Depending on the number of errors: if its huge than sometimes it is faster to recover the DB from a valid backup + journal files.

BTW - if this is a mirrored DB than there are other considerations as well.

Happy new year!

0 0

score 0 · Answer 1 · 2022-12-28T11:01:45-05:00

^INTEGRIT is the simplest way to check integrity. Run the integrity check output to a file and contact WRC, as others have said, if you have support. The most direct way to resolve database errors is to restore from a good backup and replay journals. If you can't do that, the other alternatives almost always involve loss of information. The WRC has specialists who understand database internals, and WRC always wants to investigate for the root cause of any database problems.

score 0 · Answer 2 · 2023-01-09T01:49:22-05:00

Thank you so much everyone,

I logged a tiket with WRC and managed to resolve the issue by restoring IRIS.DAT file from another instance

Regards,

Ephraim Malane

score 0 · Answer 3 · 2023-01-09T08:45:35-05:00

Erik Hemdal · Jan 9, 2023

I'm glad to hear that you contacted WRC and got this resolved.

0 0