Scada-LTS installation on Windows without Docker

[rodrigoms2004]

Folks,

I am in a trouble to install Scada-LTS from scratch on Windows.

When I run the catalina script I get this error

I am using Tomcat 9, JDK-11, Mysql 5.7 and [Scada-LTS 2.6.10 WAR file] (https://github.com/SCADA-LTS/Scada-LTS/releases).

Initially I've used JDK-11 from this source http://jdk.java.net/archive and got an error. Then I got JDK from Scada-LTS documentation, same error. https://github.com/SCADA-LTS/Scada-LTS/wiki/Getting-started---Development#java https://jdk.java.net/java-se-ri/11

Then, I've took a look inside a Linux Docker Image that is working root@b4ce1672ba27:/usr/local/tomcat# java -version openjdk version "11.0.12" 2021-07-20 OpenJDK Runtime Environment 18.9 (build 11.0.12+7) OpenJDK 64-Bit Server VM 18.9 (build 11.0.12+7, mixed mode, sharing) root@b4ce1672ba27:/usr/local/tomcat# javac -version javac 11.0.12 And put the same version from redhat site https://developers.redhat.com/products/openjdk/download

And got the same error again...

General configuration

Catalina correctly searches by JAVA_HOME throught file C:\Program Files\SCADA-LTS\bin\setenv.bat set JAVA_HOME=C:\Program Files\SCADA-LTS\java\jdk-11

The JDBC connector used is in mysql-connector-java-5.1.49.jar and it was put inside C:\Program Files\SCADA-LTS\lib folder.

The C:\Program Files\SCADA-LTS\conf\context.xml configuration model is context.xml, but with other DB parameters. username="scadadbuser" password="scadapass" driverClassName="com.mysql.jdbc.Driver" defaultTransactionIsolation="READ_COMMITTED" connectionProperties="useSSL=false" url="jdbc:mysql://localhost:3306/scadalts"

The tables in DB were correctly created by Scada-LTS during catalina initialization.

Error logs scadaLTSDAO.log mango.log localhost.2021-11-03.log flyway.log catalina.2021-11-03.log

The error in the catalina log

cataliana.bat run

03-Nov-2021 00:31:10.005 INFORMAÇÕES [mysql-cj-abandoned-connection-cleanup] org.apache.catalina.loader.WebappClassLoaderBase.checkStateForResourceLoading Illegal access: this web application instance has been stopped already. Could not load []. The following stack trace is thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access. java.lang.IllegalStateException: Illegal access: this web application instance has been stopped already. Could not load []. The following stack trace is thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access. at org.apache.catalina.loader.WebappClassLoaderBase.checkStateForResourceLoading(WebappClassLoaderBase.java:1427) at org.apache.catalina.loader.WebappClassLoaderBase.getResource(WebappClassLoaderBase.java:1052) at com.mysql.jdbc.AbandonedConnectionCleanupThread.checkThreadContextClassLoader(AbandonedConnectionCleanupThread.java:112) at com.mysql.jdbc.AbandonedConnectionCleanupThread.run(AbandonedConnectionCleanupThread.java:79) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) 03-Nov-2021 00:33:25.320 INFORMAÇÕES [http-nio-8080-exec-3] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time. 03-Nov-2021 00:33:49.500 GRAVE [http-nio-8080-exec-3] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file 03-Nov-2021 00:33:49.502 GRAVE [http-nio-8080-exec-3] org.apache.catalina.core.StandardContext.startInternal Context [/Scada-LTS] startup failed due to previous errors 03-Nov-2021 00:33:49.604 ADVERTÊNCIA [http-nio-8080-exec-3] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [Scada-LTS] appears to have started a thread named [Log4j2-TF-2-Scheduled-1] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: [email protected]/jdk.internal.misc.Unsafe.park(Native Method) [email protected]/java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:234) [email protected]/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2123) [email protected]/java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:1182) [email protected]/java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:899) [email protected]/java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1054) [email protected]/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1114) [email protected]/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [email protected]/java.lang.Thread.run(Thread.java:829) 03-Nov-2021 00:33:49.608 ADVERTÊNCIA [http-nio-8080-exec-3] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [Scada-LTS] appears to have started a thread named [AsyncAppender-ASYNC_MODBUS] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: [email protected]/jdk.internal.misc.Unsafe.park(Native Method) [email protected]/java.util.concurrent.locks.LockSupport.park(LockSupport.java:194) [email protected]/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2081) [email protected]/java.util.concurrent.ArrayBlockingQueue.take(ArrayBlockingQueue.java:417) org.apache.logging.log4j.core.appender.AsyncAppender$AsyncThread.run(AsyncAppender.java:398) 03-Nov-2021 00:33:49.610 ADVERTÊNCIA [http-nio-8080-exec-3] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [Scada-LTS] appears to have started a thread named [AsyncAppender-ASYNC_SCADA-LTS_DAO] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: [email protected]/jdk.internal.misc.Unsafe.park(Native Method) [email protected]/java.util.concurrent.locks.LockSupport.park(LockSupport.java:194) [email protected]/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2081) [email protected]/java.util.concurrent.ArrayBlockingQueue.take(ArrayBlockingQueue.java:417) org.apache.logging.log4j.core.appender.AsyncAppender$AsyncThread.run(AsyncAppender.java:398) 03-Nov-2021 00:33:49.612 ADVERTÊNCIA [http-nio-8080-exec-3] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [Scada-LTS] appears to have started a thread named [AsyncAppender-ASYNC] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: [email protected]/jdk.internal.misc.Unsafe.park(Native Method) [email protected]/java.util.concurrent.locks.LockSupport.park(LockSupport.java:194) [email protected]/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2081) [email protected]/java.util.concurrent.ArrayBlockingQueue.take(ArrayBlockingQueue.java:417) org.apache.logging.log4j.core.appender.AsyncAppender$AsyncThread.run(AsyncAppender.java:398) 03-Nov-2021 00:33:49.614 ADVERTÊNCIA [http-nio-8080-exec-3] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [Scada-LTS] appears to have started a thread named [AsyncAppender-ASYNC_DAO] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: [email protected]/jdk.internal.misc.Unsafe.park(Native Method) [email protected]/java.util.concurrent.locks.LockSupport.park(LockSupport.java:194) [email protected]/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2081) [email protected]/java.util.concurrent.ArrayBlockingQueue.take(ArrayBlockingQueue.java:417) org.apache.logging.log4j.core.appender.AsyncAppender$AsyncThread.run(AsyncAppender.java:398) 03-Nov-2021 00:33:49.617 ADVERTÊNCIA [http-nio-8080-exec-3] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [Scada-LTS] appears to have started a thread named [AsyncAppender-ASYNC_FLYWAY] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: [email protected]/jdk.internal.misc.Unsafe.park(Native Method) [email protected]/java.util.concurrent.locks.LockSupport.park(LockSupport.java:194) [email protected]/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2081) [email protected]/java.util.concurrent.ArrayBlockingQueue.take(ArrayBlockingQueue.java:417) org.apache.logging.log4j.core.appender.AsyncAppender$AsyncThread.run(AsyncAppender.java:398) 03-Nov-2021 00:33:49.619 ADVERTÊNCIA [http-nio-8080-exec-3] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [Scada-LTS] appears to have started a thread named [AsyncAppender-ASYNC_VIEW_HIERARCHY] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: [email protected]/jdk.internal.misc.Unsafe.park(Native Method) [email protected]/java.util.concurrent.locks.LockSupport.park(LockSupport.java:194) [email protected]/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2081) [email protected]/java.util.concurrent.ArrayBlockingQueue.take(ArrayBlockingQueue.java:417) org.apache.logging.log4j.core.appender.AsyncAppender$AsyncThread.run(AsyncAppender.java:398) 03-Nov-2021 00:33:49.621 ADVERTÊNCIA [http-nio-8080-exec-3] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [Scada-LTS] appears to have started a thread named [AsyncAppender-ASYNC_SCRIPT] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: [email protected]/jdk.internal.misc.Unsafe.park(Native Method) [email protected]/java.util.concurrent.locks.LockSupport.park(LockSupport.java:194) [email protected]/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2081) [email protected]/java.util.concurrent.ArrayBlockingQueue.take(ArrayBlockingQueue.java:417) org.apache.logging.log4j.core.appender.AsyncAppender$AsyncThread.run(AsyncAppender.java:398) 03-Nov-2021 00:33:49.623 ADVERTÊNCIA [http-nio-8080-exec-3] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [Scada-LTS] appears to have started a thread named [AsyncAppender-ASYNC_API] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: [email protected]/jdk.internal.misc.Unsafe.park(Native Method) [email protected]/java.util.concurrent.locks.LockSupport.park(LockSupport.java:194) [email protected]/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2081) [email protected]/java.util.concurrent.ArrayBlockingQueue.take(ArrayBlockingQueue.java:417) org.apache.logging.log4j.core.appender.AsyncAppender$AsyncThread.run(AsyncAppender.java:398) 03-Nov-2021 00:33:49.626 ADVERTÊNCIA [http-nio-8080-exec-3] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [Scada-LTS] appears to have started a thread named [Serotonin Timer] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: [email protected]/java.lang.Object.wait(Native Method) [email protected]/java.lang.Object.wait(Object.java:328) com.serotonin.timer.TimerThread.mainLoop(TimerThread.java:79) com.serotonin.timer.TimerThread.run(TimerThread.java:37) 03-Nov-2021 00:33:49.627 ADVERTÊNCIA [http-nio-8080-exec-3] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [Scada-LTS] appears to have started a thread named [Image Fetcher 3] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: [email protected]/java.lang.Object.wait(Native Method) [email protected]/sun.awt.image.ImageFetcher.nextImage(ImageFetcher.java:154) [email protected]/sun.awt.image.ImageFetcher.fetchloop(ImageFetcher.java:207) [email protected]/sun.awt.image.ImageFetcher.run(ImageFetcher.java:176) 03-Nov-2021 00:33:49.629 ADVERTÊNCIA [http-nio-8080-exec-3] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [Scada-LTS] appears to have started a thread named [mysql-cj-abandoned-connection-cleanup] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: [email protected]/java.lang.Object.wait(Native Method) [email protected]/java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:155) com.mysql.jdbc.AbandonedConnectionCleanupThread.run(AbandonedConnectionCleanupThread.java:80) [email protected]/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [email protected]/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [email protected]/java.lang.Thread.run(Thread.java:829) 03-Nov-2021 00:33:54.605 INFORMAÇÕES [mysql-cj-abandoned-connection-cleanup] org.apache.catalina.loader.WebappClassLoaderBase.checkStateForResourceLoading Illegal access: this web application instance has been stopped already. Could not load []. The following stack trace is thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access. java.lang.IllegalStateException: Illegal access: this web application instance has been stopped already. Could not load []. The following stack trace is thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access. at org.apache.catalina.loader.WebappClassLoaderBase.checkStateForResourceLoading(WebappClassLoaderBase.java:1427) at org.apache.catalina.loader.WebappClassLoaderBase.getResource(WebappClassLoaderBase.java:1052) at com.mysql.jdbc.AbandonedConnectionCleanupThread.checkThreadContextClassLoader(AbandonedConnectionCleanupThread.java:112) at com.mysql.jdbc.AbandonedConnectionCleanupThread.run(AbandonedConnectionCleanupThread.java:79) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829)

[Limraj]

Hi! Looks like {tomcat_home}/lib is missing library:

tomcat_lib and it is important that the connector is also in tomcat libs: mysql-connector-java-5.1.49.jar

We need to update it in the documentation and in the script creating the docker image. Thanks for paying attention and a detailed description of the problem. If you are still having problems, let me know.

[rodrigoms2004]

Hi

I added this four files to tomcat/lib, and the same error occurred

In catalina log

03-Nov-2021 23:42:44.560 INFORMAÇÕES [http-nio-8080-exec-6] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time. 03-Nov-2021 23:42:46.847 GRAVE [http-nio-8080-exec-6] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file 03-Nov-2021 23:42:46.850 GRAVE [http-nio-8080-exec-6] org.apache.catalina.core.StandardContext.startInternal Context [/Scada-LTS] startup failed due to previous errors 03-Nov-2021 23:42:46.956 ADVERTÊNCIA [http-nio-8080-exec-6] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [Scada-LTS] appears to have started a thread named [Log4j2-TF-2-Scheduled-1] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: [email protected]/jdk.internal.misc.Unsafe.park(Native Method) [email protected]/java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:234) [email protected]/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2123) [email protected]/java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:1182) [email protected]/java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:899) [email protected]/java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1054) [email protected]/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1114) [email protected]/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [email protected]/java.lang.Thread.run(Thread.java:829) 03-Nov-2021 23:42:46.980 ADVERTÊNCIA [http-nio-8080-exec-6] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [Scada-LTS] appears to have started a thread named [AsyncAppender-ASYNC_MODBUS] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: [email protected]/jdk.internal.misc.Unsafe.park(Native Method) [email protected]/java.util.concurrent.locks.LockSupport.park(LockSupport.java:194) [email protected]/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2081) [email protected]/java.util.concurrent.ArrayBlockingQueue.take(ArrayBlockingQueue.java:417) org.apache.logging.log4j.core.appender.AsyncAppender$AsyncThread.run(AsyncAppender.java:398) 03-Nov-2021 23:42:46.985 ADVERTÊNCIA [http-nio-8080-exec-6] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [Scada-LTS] appears to have started a thread named [AsyncAppender-ASYNC_SCADA-LTS_DAO] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: [email protected]/jdk.internal.misc.Unsafe.park(Native Method) [email protected]/java.util.concurrent.locks.LockSupport.park(LockSupport.java:194) [email protected]/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2081) [email protected]/java.util.concurrent.ArrayBlockingQueue.take(ArrayBlockingQueue.java:417) org.apache.logging.log4j.core.appender.AsyncAppender$AsyncThread.run(AsyncAppender.java:398) 03-Nov-2021 23:42:46.990 ADVERTÊNCIA [http-nio-8080-exec-6] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [Scada-LTS] appears to have started a thread named [AsyncAppender-ASYNC] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: [email protected]/jdk.internal.misc.Unsafe.park(Native Method) [email protected]/java.util.concurrent.locks.LockSupport.park(LockSupport.java:194) [email protected]/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2081) [email protected]/java.util.concurrent.ArrayBlockingQueue.take(ArrayBlockingQueue.java:417) org.apache.logging.log4j.core.appender.AsyncAppender$AsyncThread.run(AsyncAppender.java:398) 03-Nov-2021 23:42:47.017 ADVERTÊNCIA [http-nio-8080-exec-6] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [Scada-LTS] appears to have started a thread named [AsyncAppender-ASYNC_DAO] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: [email protected]/jdk.internal.misc.Unsafe.park(Native Method) [email protected]/java.util.concurrent.locks.LockSupport.park(LockSupport.java:194) [email protected]/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2081) [email protected]/java.util.concurrent.ArrayBlockingQueue.take(ArrayBlockingQueue.java:417) org.apache.logging.log4j.core.appender.AsyncAppender$AsyncThread.run(AsyncAppender.java:398) 03-Nov-2021 23:42:47.022 ADVERTÊNCIA [http-nio-8080-exec-6] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [Scada-LTS] appears to have started a thread named [AsyncAppender-ASYNC_FLYWAY] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: [email protected]/jdk.internal.misc.Unsafe.park(Native Method) [email protected]/java.util.concurrent.locks.LockSupport.park(LockSupport.java:194) [email protected]/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2081) [email protected]/java.util.concurrent.ArrayBlockingQueue.take(ArrayBlockingQueue.java:417) org.apache.logging.log4j.core.appender.AsyncAppender$AsyncThread.run(AsyncAppender.java:398) 03-Nov-2021 23:42:47.027 ADVERTÊNCIA [http-nio-8080-exec-6] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [Scada-LTS] appears to have started a thread named [AsyncAppender-ASYNC_VIEW_HIERARCHY] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: [email protected]/jdk.internal.misc.Unsafe.park(Native Method) [email protected]/java.util.concurrent.locks.LockSupport.park(LockSupport.java:194) [email protected]/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2081) [email protected]/java.util.concurrent.ArrayBlockingQueue.take(ArrayBlockingQueue.java:417) org.apache.logging.log4j.core.appender.AsyncAppender$AsyncThread.run(AsyncAppender.java:398) 03-Nov-2021 23:42:47.046 ADVERTÊNCIA [http-nio-8080-exec-6] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [Scada-LTS] appears to have started a thread named [AsyncAppender-ASYNC_SCRIPT] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: [email protected]/jdk.internal.misc.Unsafe.park(Native Method) [email protected]/java.util.concurrent.locks.LockSupport.park(LockSupport.java:194) [email protected]/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2081) [email protected]/java.util.concurrent.ArrayBlockingQueue.take(ArrayBlockingQueue.java:417) org.apache.logging.log4j.core.appender.AsyncAppender$AsyncThread.run(AsyncAppender.java:398) 03-Nov-2021 23:42:47.052 ADVERTÊNCIA [http-nio-8080-exec-6] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [Scada-LTS] appears to have started a thread named [AsyncAppender-ASYNC_API] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: [email protected]/jdk.internal.misc.Unsafe.park(Native Method) [email protected]/java.util.concurrent.locks.LockSupport.park(LockSupport.java:194) [email protected]/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2081) [email protected]/java.util.concurrent.ArrayBlockingQueue.take(ArrayBlockingQueue.java:417) org.apache.logging.log4j.core.appender.AsyncAppender$AsyncThread.run(AsyncAppender.java:398) 03-Nov-2021 23:42:47.061 ADVERTÊNCIA [http-nio-8080-exec-6] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [Scada-LTS] appears to have started a thread named [Serotonin Timer] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: [email protected]/java.lang.Object.wait(Native Method) [email protected]/java.lang.Object.wait(Object.java:328) com.serotonin.timer.TimerThread.mainLoop(TimerThread.java:79) com.serotonin.timer.TimerThread.run(TimerThread.java:37) 03-Nov-2021 23:42:47.065 ADVERTÊNCIA [http-nio-8080-exec-6] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [Scada-LTS] appears to have started a thread named [Image Fetcher 3] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: [email protected]/java.lang.Object.wait(Native Method) [email protected]/sun.awt.image.ImageFetcher.nextImage(ImageFetcher.java:154) [email protected]/sun.awt.image.ImageFetcher.fetchloop(ImageFetcher.java:207) [email protected]/sun.awt.image.ImageFetcher.run(ImageFetcher.java:176) 03-Nov-2021 23:42:47.075 ADVERTÊNCIA [http-nio-8080-exec-6] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [Scada-LTS] appears to have started a thread named [mysql-cj-abandoned-connection-cleanup] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: [email protected]/java.lang.Object.wait(Native Method) [email protected]/java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:155) com.mysql.jdbc.AbandonedConnectionCleanupThread.run(AbandonedConnectionCleanupThread.java:80) [email protected]/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [email protected]/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [email protected]/java.lang.Thread.run(Thread.java:829) 03-Nov-2021 23:42:51.964 INFORMAÇÕES [mysql-cj-abandoned-connection-cleanup] org.apache.catalina.loader.WebappClassLoaderBase.checkStateForResourceLoading Illegal access: this web application instance has been stopped already. Could not load []. The following stack trace is thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access. java.lang.IllegalStateException: Illegal access: this web application instance has been stopped already. Could not load []. The following stack trace is thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access. at org.apache.catalina.loader.WebappClassLoaderBase.checkStateForResourceLoading(WebappClassLoaderBase.java:1427) at org.apache.catalina.loader.WebappClassLoaderBase.getResource(WebappClassLoaderBase.java:1052) at com.mysql.jdbc.AbandonedConnectionCleanupThread.checkThreadContextClassLoader(AbandonedConnectionCleanupThread.java:112) at com.mysql.jdbc.AbandonedConnectionCleanupThread.run(AbandonedConnectionCleanupThread.java:79) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829)

flyway.log

INFO 2021-11-03T23:42:46,511 (?.:) - Initializing pooled connection manager INFO 2021-11-03T23:42:46,513 (?.:) - Looking for Datasource: java:comp/env/jdbc/scadalts INFO 2021-11-03T23:42:46,518 (?.:) - DataSource meta: MySQL 5.7.36-log INFO 2021-11-03T23:42:46,546 (?.:) - schemaExist:true INFO 2021-11-03T23:42:46,549 (?.:) - BaseLineNotExist:false ERROR 2021-11-03T23:42:46,662 (?.:) - org.flywaydb.core.api.FlywayException: Validate failed: Detected failed migration to version 1 (BaseVersion)

localhost log

03-Nov-2021 23:42:46.937 GRAVE [http-nio-8080-exec-6] org.apache.catalina.core.StandardContext.listenerStop Exception sending context destroyed event to listener instance of class [com.serotonin.mango.MangoContextListener] org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select id, username, password, email, phone, admin, disabled, selectedWatchList, homeUrl, lastLogin, receiveAlarmEmails, receiveOwnAuditEvents, hideMenu, theme from users order by username ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'hideMenu' in 'field list' at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:419) ... Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'hideMenu' in 'field list' ... at com.sun.proxy.$Proxy76.executeQuery(Unknown Source) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:461) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:408) ... 66 more 03-Nov-2021 23:42:46.937 INFORMAÇÕES [http-nio-8080-exec-6] org.apache.catalina.core.ApplicationContext.log Closing Spring root WebApplicationContext

scadaLTSDAO.log

ERROR 2021-11-03T23:42:46,892 (?.:) - org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'shortMessage' in 'field list'

All logs attached

scadaLTSDAO.log flyway.log localhost_access_log.2021-11-03.txt manager.2021-11-02.log manager.2021-11-03.log localhost_access_log.2021-11-02.txt catalina.2021-11-02.log catalina.2021-11-03.log localhost.2021-11-02.log localhost.2021-11-03.log mango.log

[grzesiekb]

The installer for Scada-LTS is being developed and is not yet finished. https://github.com/SCADA-LTS/installer. The current version does not finished for windows.

[KMKAR]

Hi @rodrigoms2004 / @grzesiekb I installed the latest 2.6.1 war release in a fresh install of raspbian 11 (rpi4) Application is failing to start on tomcat and the scadaLTSDAO.log file shows the same in my case: ERROR 2021-11-18T11:18:13,081 (?.:) - org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'shortMessage' in 'field list'

Do you know how to fix this issue? Thanks

[rodrigoms2004]

The installer for Scada-LTS is being developed and is not yet finished. https://github.com/SCADA-LTS/installer. The current version does not finished for windows.

@grzesiekb our colleague @KMKAR had the same issue in linux platform, maybe it could be a DB issue

[celsou]

Hello everyone,

I tried to install on Linux and got the same error as @KMKAR. I've been inspecting the database tables and found that there was no "shortMessage" column in my database.

My guess is that this and other database modifications are performed by these classes but for some reason I don't know they aren't running during manual installation.

I hope this info can help.

[grzesiekb]

Feel free to test and comment on the installer - It downloads a set of matching components like a particular version of tomcat java, downloads the appropriate libraries and configures tomcat and downloads Scada-LTS.war which should work in that environment. This assumes you have mysql 5.7 installed. https://github.com/SCADA-LTS/installer/releases

you can try to use inst_linux and at the end of the file start.sh

1. download the inst_linux file into a separate directory
2. download the file start.sh
3. Run inst_linux -h
4. If we have a default configuration: root/root on localhost 3306 with scadalts database, it runs inst_linux
5. If you have a different configuration you have to provide it in the proper arguments for inst_linux which you can see by running inst_linux -h
6. When everything is downloaded and configured run start.sh file (you may need to give it permissions to execute)

[Limraj]

Hi, sorry that I didn't reply, for some reason I didn't get notifications about the update of this topic.

Try to do what @grzesiekb wrote, but the problems in your installation seem to be not including the appropriate libs in tomcat/lib if you want to come back to this, try again:

1. In addition to these jars from the link, you also need to put a connector to the database: mysql-connector-java-5.1.49.jar (tomcat/lib)
2. If these jars are in this location, you'd have to run the application on a clean database. If the default database does not contain your important data, you can do it: drop database sacadalts; create database scadalts; and run application;

edit: Before the first run, it is worth removing folder: tomcat/webapps/ScadaBR

This should help looking at the attached logs. (now there are no bugs related to missing libs) Regards and sorry again for the late reaction.

[celsou]

Good news!

Deleting the "scadalts" database and recreating it solved the problem and I was able to run Scada-LTS. Now I'm going to download the installer in Rust and try it out so I can give you feedback.

[jrajnhold]

Hi Everyone! I try to run ScadaLTS on ubuntu but at the end I have the same problem as you all: _ERROR 2021-11-18T11:18:13,081 (?.:) - org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'shortMessage' in 'field list' How to fix it to check the new version of SCADA-LTS?

PS. I try to drop and create database - it's not helping!

[Limraj]

Hello @jrajnhold, Have you tried on newer versions or does the problem occur? This error shows that he did not perform the migration, hence the column that is created in a certain version of the migration is missing.