IRISTEMP Database in IRIS instance brings down the Production instance

Question

Question

Sudhir Sinha · Nov 30, 2022

#Databases #InterSystems IRIS for Health

IRISTEMP - IRIS.DAT took up all the available disk space of almost 2 TB that leads to Production instance down.

After RCA the suspected cause was some SQL query but not confirmed as query result was received within a minute.

Currently we are monitoring the IRIS.DAT and it is continuously increasing and currently we set the MAX size for this DB, but not sure what will happen once it hit the MAX SIZE ?

Any clue why the IRISTEMP DB is not flushing the data from IRIS.DAT as i believe it is being mostly used for system processes and is in increasing trend at ~ 1GB/day?

Is it some sort of bug for IRIS for Healthcare to store more index or globals to enable additional capability and features, especially for AI/ML and Analytics ?

Thanks

Sudhir

Product version: IRIS 2021.2

$ZV: IRIS for UNIX (Red Hat Enterprise Linux for x86-64) 2021.1.2 (Build 338U) Tue Apr 12 2022 12:03:31 EDT [Health:3.3.0]

Discussion (3)2

Log in or sign up to continue

score 1 · Answer 1 · 2022-11-30T18:24:17-05:00

I would go straight to support for this to be honest! They can look at the contents of IRISTEMP with you to help figure out why there's leftover data there.

score 0 · Answer 2 · 2022-12-08T10:43:45-05:00

Sudhir Sinha · Dec 8, 2022

We reached out to support and shared pbutton and not much clue what is leftover and why still increasing.

0 0

score 0 · Answer 3 · 2022-11-30T21:53:52-05:00

You could use d ^%GSIZE to see where global is growing up and where they came from.

Alternatively, see this post.
https://community.intersystems.com/post/database-table-size