ASH-Viewer icon indicating copy to clipboard operation
ASH-Viewer copied to clipboard

Fix no data displayed when loading DB under heavy load

Open rstribrn opened this issue 2 years ago • 1 comments

Fix problem that no data is displayed at all when connecting to DB under heavy load.

Stacktrace and overall wrong behavior could be seen from log below:

/opt/java/ash-viewer$ ./run.sh

02.05.22 08:36:41.997 [main] INFO Main - Start application 02.05.22 08:36:43.547 [main] INFO BasicFrame - Start instantiating new BasicFrame 02.05.22 08:36:47.953 [main] INFO ConnectToDbAction - ConnectToDbAction button pressed 02.05.22 08:36:54.367 [Thread-4] DEBUG RemoteDBManager - Setting optimizer_mode = 'ALL_ROWS' 02.05.22 08:36:54.476 [Thread-4] DEBUG RemoteDBManager - Setting optimizer_mode = 'ALL_ROWS' 02.05.22 08:36:56.437 [Thread-4] INFO GetFromRemoteAndStore - Start loading 02.05.22 08:37:09.328 [Thread-4] INFO GetFromRemoteAndStore - Start loading olap 02.05.22 08:39:42.996 [Thread-4] INFO GetFromRemoteAndStore - Start loading stacked chart java.lang.ArrayIndexOutOfBoundsException: 50 at org.jfree.data.extension.impl.XYDatasetSelectionExtension.initSelection(XYDatasetSelectionExtension.java:142) at org.jfree.data.extension.impl.XYDatasetSelectionExtension.datasetChanged(XYDatasetSelectionExtension.java:111) at org.jfree.data.general.AbstractDataset.notifyListeners(AbstractDataset.java:189) at org.jfree.data.general.AbstractDataset.fireDatasetChanged(AbstractDataset.java:172) at org.jfree.data.xy.CategoryTableXYDataset.add(CategoryTableXYDataset.java:118) at gui.chart.CategoryTableXYDatasetRDA.addSeriesValue(CategoryTableXYDatasetRDA.java:34) at core.processing.GetFromRemoteAndStore.lambda$null$8(GetFromRemoteAndStore.java:274) at java.util.Iterator.forEachRemaining(Iterator.java:116) at java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1801) at java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:580) at core.processing.GetFromRemoteAndStore.lambda$null$9(GetFromRemoteAndStore.java:271) at java.lang.Iterable.forEach(Iterable.java:75) at core.processing.GetFromRemoteAndStore.lambda$loadToMainStackedChart$10(GetFromRemoteAndStore.java:269) at java.lang.Iterable.forEach(Iterable.java:75) at core.processing.GetFromRemoteAndStore.loadToMainStackedChart(GetFromRemoteAndStore.java:269) at core.processing.GetFromRemoteAndStore.loadDataFromRemoteToLocalStore(GetFromRemoteAndStore.java:174) at gui.connect.ConnectToDbArea.loadObjectsByConnectionName(ConnectToDbArea.java:602) at gui.util.ProgressBarUtil$1.run(ProgressBarUtil.java:79) 02.05.22 08:40:08.777 [pool-2-thread-1] INFO GetFromRemoteAndStore - Start loading 02.05.22 08:40:20.664 [pool-2-thread-1] INFO GetFromRemoteAndStore - Start loading olap 02.05.22 08:40:26.672 [pool-2-thread-1] INFO GetFromRemoteAndStore - Start loading stacked chart java.lang.ArrayIndexOutOfBoundsException 02.05.22 08:40:33.457 [pool-2-thread-1] INFO GetFromRemoteAndStore - Start loading 02.05.22 08:40:44.469 [pool-2-thread-1] INFO GetFromRemoteAndStore - Start loading olap 02.05.22 08:40:45.631 [pool-2-thread-1] INFO GetFromRemoteAndStore - Start loading stacked chart java.lang.ArrayIndexOutOfBoundsException 02.05.22 08:40:51.655 [pool-2-thread-1] INFO GetFromRemoteAndStore - Start loading 02.05.22 08:41:03.050 [pool-2-thread-1] INFO GetFromRemoteAndStore - Start loading olap 02.05.22 08:41:03.798 [pool-2-thread-1] INFO GetFromRemoteAndStore - Start loading stacked chart java.lang.ArrayIndexOutOfBoundsException 02.05.22 08:41:09.627 [pool-2-thread-1] INFO GetFromRemoteAndStore - Start loading 02.05.22 08:41:21.641 [pool-2-thread-1] INFO GetFromRemoteAndStore - Start loading olap 02.05.22 08:41:22.358 [pool-2-thread-1] INFO GetFromRemoteAndStore - Start loading stacked chart java.lang.ArrayIndexOutOfBoundsException 02.05.22 08:41:28.129 [pool-2-thread-1] INFO GetFromRemoteAndStore - Start loading 02.05.22 08:41:40.770 [pool-2-thread-1] INFO GetFromRemoteAndStore - Start loading olap 02.05.22 08:41:41.560 [pool-2-thread-1] INFO GetFromRemoteAndStore - Start loading stacked chart java.lang.ArrayIndexOutOfBoundsException 02.05.22 08:41:47.130 [pool-2-thread-1] INFO GetFromRemoteAndStore - Start loading 02.05.22 08:41:59.110 [pool-2-thread-1] INFO GetFromRemoteAndStore - Start loading olap 02.05.22 08:42:00.177 [pool-2-thread-1] INFO GetFromRemoteAndStore - Start loading stacked chart java.lang.ArrayIndexOutOfBoundsException 02.05.22 08:42:06.176 [pool-2-thread-1] INFO GetFromRemoteAndStore - Start loading 02.05.22 08:42:16.820 [pool-2-thread-1] INFO GetFromRemoteAndStore - Start loading olap 02.05.22 08:42:17.755 [pool-2-thread-1] INFO GetFromRemoteAndStore - Start loading stacked chart java.lang.ArrayIndexOutOfBoundsException 02.05.22 08:42:23.575 [pool-2-thread-1] INFO GetFromRemoteAndStore - Start loading 02.05.22 08:42:34.408 [pool-2-thread-1] INFO GetFromRemoteAndStore - Start loading olap 02.05.22 08:42:35.690 [pool-2-thread-1] INFO GetFromRemoteAndStore - Start loading stacked chart java.lang.ArrayIndexOutOfBoundsException 02.05.22 08:42:41.464 [pool-2-thread-1] INFO GetFromRemoteAndStore - Start loading

rstribrn avatar May 02 '22 06:05 rstribrn

image

rstribrn avatar May 02 '22 08:05 rstribrn