Using Ignition database shrink tool on Linux

Ignition
1

First, I realize that this may be less of a priority now that there are versions for 7.7 and 7.8 that deal with the internal database growth issue. We are using 7.7.6 in production.

We have been testing 7.8.2, but we have an ongoing issue that we cannot resolve definitely until we rule out performance issues with our database infrastructure. So we cannot upgrade in production just yet.

We tried to use the shrink tool on Linux, but found that it would not work in a headless mode. We then opened the tool in a VNC session, and got the error shown below. We cannot just type in the path to the database, because the “Clean” button is never enabled. We would therefore ask for one of the following.

[ul]
change the tool so that it can run in headless mode (as the installer does)
do not use translucency for the chooser (if that is an option)
[/ul]

Java version is

java -version
java version "1.8.0_60"
Java(TM) SE Runtime Environment (build 1.8.0_60-b27)
Java HotSpot(TM) 64-Bit Server VM (build 25.60-b23, mixed mode)

Partial stack trace is

Exception in thread "AWT-EventQueue-0" java.lang.UnsupportedOperationException: TRANSLUCENT translucency is not supported.
	at java.awt.Window.setOpacity(Window.java:3633)
	at java.awt.Dialog.setOpacity(Dialog.java:1333)
	at com.inductiveautomation.ignition.tools.adapter.SynchronousJFXCaller.call(SynchronousJFXCaller.java:68)
	at com.inductiveautomation.ignition.tools.gui.JfxDirChooser.showDialog(JfxDirChooser.java:104)
	at com.inductiveautomation.ignition.tools.gui.JfxDirChooser.showDialog(JfxDirChooser.java:66)
	at com.inductiveautomation.ignition.tools.gui.JfxDirChooser.showOpenDialog(JfxDirChooser.java:123)
	at com.inductiveautomation.ignition.tools.DbToolApp.openChooser(DbToolApp.java:141)
	at com.inductiveautomation.ignition.tools.DbToolApp.lambda$createUI$4(DbToolApp.java:88)
	at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
	at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
	at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
	at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
2

The shrink tool is only a temporary bandaid - if your database has grown to the point it needs the shrink tool it will likely do so again after the tool is run as well. If possible you should upgrade to 7.7.8 so the issue is fixed for good.