MariaDB crashes

Our Windows Server for Joget was shut down directly without executing the Joget shutdown program. When I restarted Joget, it could not connect to MariaDB instance.

catalina.2022-03-07:

07-Mar-2022 14:31:45.958 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version: Apache Tomcat/8.5.23
07-Mar-2022 14:31:45.958 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Sep 28 2017 10:30:11 UTC
07-Mar-2022 14:31:45.958 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number: 8.5.23.0
07-Mar-2022 14:31:45.958 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Windows NT (unknown)
07-Mar-2022 14:31:45.958 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 10.0
07-Mar-2022 14:31:45.958 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: x86
07-Mar-2022 14:31:45.958 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: C:\Joget-v6-Enterprise\jre1.8.0_112
07-Mar-2022 14:31:45.974 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 1.8.0_112-b15
07-Mar-2022 14:31:45.974 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Oracle Corporation
07-Mar-2022 14:31:45.974 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: C:\Joget-v6-Enterprise\apache-tomcat-8.5.23
07-Mar-2022 14:31:45.974 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: C:\Joget-v6-Enterprise\apache-tomcat-8.5.23
07-Mar-2022 14:31:45.974 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=.\apache-tomcat-8.5.23\conf\logging.properties
07-Mar-2022 14:31:45.974 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
07-Mar-2022 14:31:45.974 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:MaxHeapSize=2048M
07-Mar-2022 14:31:45.974 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx1024M
07-Mar-2022 14:31:45.974 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dwflow.home=./wflow/
07-Mar-2022 14:31:45.974 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:+UseConcMarkSweepGC
07-Mar-2022 14:31:45.974 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -javaagent:./wflow/aspectjweaver-1.8.5.jar
07-Mar-2022 14:31:45.974 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
07-Mar-2022 14:31:45.974 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
07-Mar-2022 14:31:45.974 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=.\apache-tomcat-8.5.23
07-Mar-2022 14:31:45.974 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=.\apache-tomcat-8.5.23
07-Mar-2022 14:31:45.974 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=.\apache-tomcat-8.5.23\temp
07-Mar-2022 14:31:45.974 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: [C:\Joget-v6-Enterprise\jre1.8.0_112\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn\;C:\Program Files\apache-maven-3.6.0\bin;C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\;C:\Program Files\Microsoft SQL Server\140\Tools\Binn\;C:\Program Files\Microsoft SQL Server\140\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\140\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\;C:\curl\curl-7.80.0-win64-mingw\bin;C:\Users\Administrator.PANGEOCORP\AppData\Local; C:\Program Files\apache-maven-3.6.0\bin;.]
07-Mar-2022 14:31:46.177 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
07-Mar-2022 14:31:46.271 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
07-Mar-2022 14:31:46.286 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-80"]
07-Mar-2022 14:31:46.286 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
07-Mar-2022 14:31:46.286 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["https-jsse-nio-8443"]
07-Mar-2022 14:31:46.536 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
07-Mar-2022 14:31:46.536 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["https-jsse-nio-443"]
07-Mar-2022 14:31:46.552 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
07-Mar-2022 14:31:46.552 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 1160 ms
07-Mar-2022 14:31:46.599 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
07-Mar-2022 14:31:46.599 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.23
07-Mar-2022 14:31:46.614 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [C:\Joget-v6-Enterprise\apache-tomcat-8.5.23\webapps\jw.war]
07-Mar-2022 14:31:59.521 INFO [localhost-startStop-1] 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.
07-Mar-2022 14:32:08.677 SEVERE [localhost-startStop-1] org.apache.tomcat.jdbc.pool.ConnectionPool.init Unable to create initial connections of pool.
java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=localhost)(port=3307)(type=master) : Connection refused: connect
at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:156)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:118)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.throwException(ExceptionMapper.java:92)
at org.mariadb.jdbc.Driver.connect_aroundBody0(Driver.java:111)
at org.mariadb.jdbc.Driver.connect_aroundBody1$advice(Driver.java:151)
at org.mariadb.jdbc.Driver.connect(Driver.java:1)
at com.mysql.jdbc.Driver.connect_aroundBody0(Driver.java:29)
at com.mysql.jdbc.Driver.connect_aroundBody1$advice(Driver.java:151)
at com.mysql.jdbc.Driver.connect(Driver.java:1)
at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:310)
at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:203)
at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:718)
at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:650)
at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:468)
at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:143)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:118)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:107)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:131)
at org.joget.commons.util.DynamicDataSource.getConnection_aroundBody0(DynamicDataSource.java:48)
at org.joget.commons.util.DynamicDataSource$AjcClosure1.run(DynamicDataSource.java:1)
at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149)
at org.joget.commons.util.AnalyzerAspect.analyzeDbcpOpenConnections(AnalyzerAspect.java:166)
at org.joget.commons.util.DynamicDataSource.getConnection(DynamicDataSource.java:20)
at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:139)
at org.hibernate.engine.jdbc.internal.JdbcServicesImpl$ConnectionProviderJdbcConnectionAccess.obtainConnection(JdbcServicesImpl.java:279)
at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:124)
at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:111)
at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:234)
at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:206)
at org.hibernate.cfg.Configuration.buildTypeRegistrations(Configuration.java:1887)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1845)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1930)
at org.springframework.orm.hibernate4.LocalSessionFactoryBuilder.buildSessionFactory(LocalSessionFactoryBuilder.java:372)
at org.springframework.orm.hibernate4.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:454)
at org.springframework.orm.hibernate4.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:439)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1689)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1627)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1534)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1281)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:551)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1534)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1281)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:551)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
at org.springframework.context.support.AbstractApplicationContext.initMessageSource(AbstractApplicationContext.java:713)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:531)
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:443)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:325)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)
at org.joget.commons.spring.web.CustomContextLoaderListener.contextInitialized(CustomContextLoaderListener.java:31)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4745)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5207)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:988)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1860)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: Could not connect to address=(host=localhost)(port=3307)(type=master) : Connection refused: connect
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1027)
at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:483)
at org.mariadb.jdbc.Driver.connect_aroundBody0(Driver.java:106)
... 78 more
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:589)
at java.net.Socket.connect(Socket.java:538)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connect(AbstractConnectProtocol.java:398)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1020)
... 80 more

07-Mar-2022 14:32:09.208 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [C:\Joget-v6-Enterprise\apache-tomcat-8.5.23\webapps\jw.war] has finished in [22,594] ms
07-Mar-2022 14:32:09.208 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [C:\Joget-v6-Enterprise\apache-tomcat-8.5.23\webapps\jwdesigner.war]
07-Mar-2022 14:32:10.224 INFO [localhost-startStop-1] 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.
07-Mar-2022 14:32:10.271 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [C:\Joget-v6-Enterprise\apache-tomcat-8.5.23\webapps\jwdesigner.war] has finished in [1,063] ms
07-Mar-2022 14:32:10.271 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Joget-v6-Enterprise\apache-tomcat-8.5.23\webapps\docs]
07-Mar-2022 14:32:10.302 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Joget-v6-Enterprise\apache-tomcat-8.5.23\webapps\docs] has finished in [31] ms
07-Mar-2022 14:32:10.302 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Joget-v6-Enterprise\apache-tomcat-8.5.23\webapps\examples]
07-Mar-2022 14:32:10.521 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Joget-v6-Enterprise\apache-tomcat-8.5.23\webapps\examples] has finished in [219] ms
07-Mar-2022 14:32:10.521 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Joget-v6-Enterprise\apache-tomcat-8.5.23\webapps\host-manager]
07-Mar-2022 14:32:10.536 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Joget-v6-Enterprise\apache-tomcat-8.5.23\webapps\host-manager] has finished in [15] ms
07-Mar-2022 14:32:10.536 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Joget-v6-Enterprise\apache-tomcat-8.5.23\webapps\manager]
07-Mar-2022 14:32:10.552 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Joget-v6-Enterprise\apache-tomcat-8.5.23\webapps\manager] has finished in [16] ms
07-Mar-2022 14:32:10.552 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Joget-v6-Enterprise\apache-tomcat-8.5.23\webapps\ROOT]
07-Mar-2022 14:32:10.583 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Joget-v6-Enterprise\apache-tomcat-8.5.23\webapps\ROOT] has finished in [31] ms
07-Mar-2022 14:32:10.583 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
07-Mar-2022 14:32:10.599 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-80"]
07-Mar-2022 14:32:10.599 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["https-jsse-nio-8443"]
07-Mar-2022 14:32:10.599 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["https-jsse-nio-443"]
07-Mar-2022 14:32:10.615 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 24051 ms

Then I checked the log for MariaDB, there are two errors:

Aras-Server.err

2022-03-07 14:41:01 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-03-07 14:41:01 0 [Note] InnoDB: Uses event mutexes
2022-03-07 14:41:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2022-03-07 14:41:01 0 [Note] InnoDB: Number of pools: 1
2022-03-07 14:41:01 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-03-07 14:41:01 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-03-07 14:41:01 0 [Note] InnoDB: Completed initialization of buffer pool
2022-03-07 14:41:01 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=5814239621
2022-03-07 14:41:05 0 [ERROR] InnoDB: Refusing to load '.\mysql\gtid_slave_pos.ibd' (id=4, flags=0x21); dictionary contains id=3, flags=0x21
2022-03-07 14:41:05 0 [ERROR] InnoDB: Could not find a valid tablespace file for ``mysql`.`gtid_slave_pos``. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2022-03-07 14:41:05 0 [Warning] InnoDB: Ignoring tablespace for `mysql`.`gtid_slave_pos` because it could not be opened.
2022-03-07 14:41:05 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-03-07 14:41:05 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-03-07 14:41:05 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-03-07 14:41:05 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-03-07 14:41:05 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2022-03-07 14:41:05 0 [Note] InnoDB: Waiting for purge to start
2022-03-07 14:41:05 0 [Note] InnoDB: Waiting for purge to start
2022-03-07 14:41:05 0 [Note] InnoDB: 10.3.9 started; log sequence number 5814239630; transaction id 17492792
2022-03-07 14:41:05 0 [Note] InnoDB: Loading buffer pool(s) from C:\Joget-DX7-Enterprise\mariadb-10.3.9-win32\data\ib_buffer_pool
2022-03-07 14:41:05 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-03-07 14:41:05 0 [Note] Server socket created on IP: '::'.

**my.ini**

[mysqld]
port=3307
character-set-server=utf8
collation-server=utf8_unicode_ci
innodb_strict_mode=0
[client]
port=3307

I tried adding "innodb_force_recovery=1/2/3" inside my.ini, I got:
Aras-Server.err

2022-03-07 16:31:19 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-03-07 16:31:19 0 [Note] InnoDB: Uses event mutexes
2022-03-07 16:31:19 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2022-03-07 16:31:19 0 [Note] InnoDB: Number of pools: 1
2022-03-07 16:31:19 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-03-07 16:31:19 0 [Note] InnoDB: Initializing buffer pool, total size = 512M, instances = 1, chunk size = 128M
2022-03-07 16:31:19 0 [Note] InnoDB: Completed initialization of buffer pool
2022-03-07 16:31:21 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-03-07 16:31:21 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-03-07 16:31:21 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-03-07 16:31:21 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-03-07 16:31:21 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2022-03-07 16:31:21 0 [Note] InnoDB: Waiting for purge to start
2022-03-07 16:31:21 0 [Note] InnoDB: 10.3.9 started; log sequence number 5814239648; transaction id 17492792
2022-03-07 16:31:21 0 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!!
2022-03-07 16:31:21 0 [Note] InnoDB: Loading buffer pool(s) from C:\Joget-DX7-Enterprise\mariadb-10.3.9-win32\data\ib_buffer_pool
2022-03-07 16:31:21 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-03-07 16:31:21 0 [Note] Server socket created on IP: '::'.

When I tried to connect to the database, I got:

C:\Joget-DX7-Enterprise\mariadb-10.3.9-win32\bin>mysql -uroot -p
Enter password:
ERROR 2002 (HY000): Can't connect to MySQL server on 'localhost' (10061)

I want to let this database work again, please help. Thank you.