go to post Alexander Pettitt · Jun 21, 2022 Two possible issues: Are you running a backup? Do you have a network mounted filesystem like NFS or SMB? We need to see messages.log or cconsole.log for the time it was happening.
go to post Alexander Pettitt · Jun 14, 2022 What does openssl version show? Guessing 3.x since that is the version that ships with Ubuntu 22.04. Bob is right, try on Ubuntu 20.04 instead. This shows the downside of IRIS being dependent on OS packages.
go to post Alexander Pettitt · Jun 1, 2022 One thing you can do is run it in steps for both the compaction and the free so you have performance effect data on your actual system. Do a run to compact and free of maybe 1 or 10 Gb. Be ready for the WIJ to expand. Try it on a non production copy if you can first and run an Integchk on the dataset after. Make sure you are on a current version of Cache or IRIS since some versions had issues. Know when your system really has it low utilization period. You might have midnight/end of day processing or someone might do the weekly ETL on the weekend.
go to post Alexander Pettitt · Jan 6, 2022 I no longer have a shadow to test with but something like:echo "d tag^routine \n h" | csession [instance] -U %SYSYou need Unix passthough authentication to work.Managing and Monitoring Shadowing might help you find the data you want
go to post Alexander Pettitt · Dec 13, 2021 The affected class is not part of the required install for Cache 2018.1.5.659.0 or IRIS 2020.1.1.408.0. I would search filesystems for JndiLookup and log4j.
go to post Alexander Pettitt · Oct 26, 2021 Have you tried URL encoding? CON would be equal to %43%4F%4E and con would be %63%6F%6E
go to post Alexander Pettitt · Oct 25, 2021 The ^DATABASE routine in %SYS allows you to edit the size. Sizing a CACHE.DAT avoids the on the fly expansion that would otherwise happen. Some people thought this would be a performance benefit.
go to post Alexander Pettitt · Oct 25, 2021 Looks like you can set charset to UTF-8 using the docs here. You might need the full version to do that.
go to post Alexander Pettitt · Oct 20, 2021 What charset do you want to use? That may be the issue. I use putty too.
go to post Alexander Pettitt · Oct 5, 2021 Intersystems has worked hard but encryption is not free. Do you have something like batch processing? You would notice an impact more there then on a 1 second query. I would worry more about key security and recovery. Encryption also has a serious impact on the ability of modern SAN storage to dedup and compress which could result in higher than expected storage costs.
go to post Alexander Pettitt · Sep 28, 2021 You might look at this tool combination for the last journal file. Convert Journal Files Using ^JCONVERT and ^%JREAD
go to post Alexander Pettitt · Sep 7, 2021 If you have not already, migrate to solid state disks. It is weird that the page Vic recommends does not mention that.
go to post Alexander Pettitt · Sep 2, 2021 I don't know a way that you can do that. You can run ^%GSIZE against a specific CACHE.DAT
go to post Alexander Pettitt · Sep 1, 2021 Here is a link to the Cache document - https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GCDI_journal#GCDI_journal_view
go to post Alexander Pettitt · Sep 1, 2021 Many things could be happening. How do you cleanup journal files? Purge after so many backups? Are your backup working? You could look in a journal file and see what global data is causing the expansion. If you have the system management portal you can look at journal data there too. You might need to go to the application vendor to tell what data a global holds.
go to post Alexander Pettitt · Aug 9, 2021 Roger is correct. I wonder if the error is controllable though through the cpf. The rules on global names - linked to the temporary doc location - http://dreamymclean.intersystems.skytapdns.com:52773/csp/docbook/Doc.View.cls?KEY=GGBL_structure
go to post Alexander Pettitt · Jun 9, 2021 You could try to compact and truncate. Dmitry's idea will also work and be faster.
go to post Alexander Pettitt · Jun 2, 2021 I think the WRC would be the only ones who could tell you what could be moved into CACHETEMP unless you found someone else who they had told already. If you just don't want to store so many journals you could just backup multiple times a day and do a journal purge. Congratulations on using Ensemble to the point you have this problem.