Openboxes not starting: Waiting for changelog lock…

Hello all,

My server was really slow, so I did some updates and rebooted… not openboxes doesn’t start anymore keeps hanging on: Waiting for changelog lock…

See catalina log:

Oct 28, 2024 8:55:18 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Server version name:   Apache Tomcat/7.0.109
Oct 28, 2024 8:55:18 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Server built:          Apr 22 2021 18:43:38 UTC
Oct 28, 2024 8:55:18 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Server version number: 7.0.109.0
Oct 28, 2024 8:55:18 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: OS Name:               Linux
Oct 28, 2024 8:55:18 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: OS Version:            3.10.0-1160.108.1.el7.x86_64
Oct 28, 2024 8:55:18 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Architecture:          amd64
Oct 28, 2024 8:55:18 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Java Home:             /usr/lib/jvm/java-1.7.0-openjdk-1.7.0.261-2.6.22.2.el7_8.x86_64/jre
Oct 28, 2024 8:55:18 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: JVM Version:           1.7.0_261-mockbuild_2020_04_29_08_59-b00
Oct 28, 2024 8:55:18 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: JVM Vendor:            Oracle Corporation
Oct 28, 2024 8:55:18 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: CATALINA_BASE:         /opt/tomcat
Oct 28, 2024 8:55:18 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: CATALINA_HOME:         /opt/tomcat
Oct 28, 2024 8:55:18 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Djava.util.logging.config.file=/opt/tomcat/conf/logging.properties
Oct 28, 2024 8:55:18 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
Oct 28, 2024 8:55:18 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Djava.awt.headless=true
Oct 28, 2024 8:55:18 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Djava.security.egd=file:/dev/./urandom
Oct 28, 2024 8:55:18 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
Oct 28, 2024 8:55:18 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Dorg.apache.catalina.security.SecurityListener.UMASK=0027
Oct 28, 2024 8:55:18 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Xms1024m
Oct 28, 2024 8:55:18 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Xmx4096m
Oct 28, 2024 8:55:18 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -XX:MaxPermSize=512m
Oct 28, 2024 8:55:18 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -XX:+UseParallelGC
Oct 28, 2024 8:55:18 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Dignore.endorsed.dirs=
Oct 28, 2024 8:55:18 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Dcatalina.base=/opt/tomcat
Oct 28, 2024 8:55:18 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Dcatalina.home=/opt/tomcat
Oct 28, 2024 8:55:18 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Djava.io.tmpdir=/opt/tomcat/temp
Oct 28, 2024 8:55:18 PM org.apache.catalina.core.AprLifecycleListener lifecycleEvent
INFO: The Apache Tomcat Native library which allows using OpenSSL was not found on the java.library.path: [/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib]
Oct 28, 2024 8:55:18 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-bio-8080"]
Oct 28, 2024 8:55:18 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-bio-8443"]
Oct 28, 2024 8:55:18 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["ajp-bio-0:0:0:0:0:0:0:0-8009"]
Oct 28, 2024 8:55:18 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 671 ms
Oct 28, 2024 8:55:18 PM org.apache.catalina.core.StandardService startInternal
INFO: Starting service [Catalina]
Oct 28, 2024 8:55:18 PM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.109
Oct 28, 2024 8:55:18 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive [/opt/apache-tomcat-7.0.109/webapps/openboxes.war]
Oct 28, 2024 8:55:22 PM org.apache.catalina.startup.TldConfig execute
INFO: 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.
Using configuration locations [classpath:openboxes-config.properties, classpath:openboxes-config.groovy, file:/opt/tomcat/.grails/openboxes-config.properties, file:/opt/tomcat/.grails/openboxes-config.groovy] [production]
Unable to load specified config location classpath:openboxes-config.properties : class path resource [openboxes-config.properties] cannot be opened because it does not exist
Unable to load specified config location classpath:openboxes-config.groovy : class path resource [openboxes-config.groovy] cannot be opened because it does not exist
log4j:ERROR setFile(null,true) call failed.
java.io.FileNotFoundException: stacktrace.log (Permission denied)
	at java.io.FileOutputStream.open(Native Method)
	at java.io.FileOutputStream.<init>(FileOutputStream.java:221)
	at java.io.FileOutputStream.<init>(FileOutputStream.java:142)
	at org.apache.log4j.FileAppender.setFile(FileAppender.java:282)
	at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:166)
	at org.apache.log4j.spi.OptionHandler$activateOptions.call(Unknown Source)
	at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)
	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:120)
	at org.codehaus.groovy.grails.plugins.logging.Log4jConfig.createFullstackTraceAppender(Log4jConfig.groovy:177)
	at org.codehaus.groovy.grails.plugins.logging.Log4jConfig.this$2$createFullstackTraceAppender(Log4jConfig.groovy)
	at org.codehaus.groovy.grails.plugins.logging.Log4jConfig$this$2$createFullstackTraceAppender.callCurrent(Unknown Source)
	at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:44)
	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:141)
	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:145)
	at org.codehaus.groovy.grails.plugins.logging.Log4jConfig.configure(Log4jConfig.groovy:145)
	at org.codehaus.groovy.grails.web.util.Log4jConfigListener.contextInitialized(Log4jConfigListener.java:62)
	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5128)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5653)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:1007)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:983)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:639)
	at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1128)
	at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:2020)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:473)
	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622)
	at java.lang.Thread.run(Thread.java:748)
2024-10-28 20:55:23,983 [localhost-startStop-1] INFO  context.ContextLoader  - Root WebApplicationContext: initialization started
2024-10-28 20:55:23,996 [localhost-startStop-1] INFO  support.XmlWebApplicationContext  - Refreshing Root WebApplicationContext: startup date [Mon Oct 28 20:55:23 CET 2024]; root of context hierarchy
2024-10-28 20:55:24,016 [localhost-startStop-1] INFO  xml.XmlBeanDefinitionReader  - Loading XML bean definitions from ServletContext resource [/WEB-INF/applicationContext.xml]
2024-10-28 20:55:24,197 [localhost-startStop-1] INFO  support.DefaultListableBeanFactory  - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@2419e928: defining beans [grailsApplication,pluginManager,grailsConfigurator,grailsResourceLoader,grailsResourceHolder,characterEncodingFilter]; root of factory hierarchy
2024-10-28 20:55:26,541 [localhost-startStop-1] INFO  cfg.Environment  - Hibernate 3.3.1.GA
2024-10-28 20:55:26,543 [localhost-startStop-1] INFO  cfg.Environment  - hibernate.properties not found
2024-10-28 20:55:26,545 [localhost-startStop-1] INFO  cfg.Environment  - Bytecode provider name : javassist
2024-10-28 20:55:26,546 [localhost-startStop-1] INFO  cfg.Environment  - using JDK 1.4 java.sql.Timestamp handling
2024-10-28 20:55:28,144 [localhost-startStop-1] INFO  annotation.ClassPathBeanDefinitionScanner  - JSR-250 'javax.annotation.ManagedBean' found and supported for component scanning
2024-10-28 20:55:28,921 [MLog-Init-Reporter] INFO  log.MLog  - MLog clients using slf4j logging.
2024-10-28 20:55:29,811 [localhost-startStop-1] INFO  c3p0.C3P0Registry  - Initializing c3p0-0.9.5.5 [built 11-December-2019 22:18:33 -0800; debug? true; trace: 10]
2024-10-28 20:55:30,035 [localhost-startStop-1] INFO  impl.AbstractPoolBackedDataSource  - Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 5, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, dataSourceName -> 1n9yw1ob61n0kubxhhxgq7|4c4c467, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 1n9yw1ob61n0kubxhhxgq7|4c4c467, idleConnectionTestPeriod -> 7200, initialPoolSize -> 10, jdbcUrl -> jdbc:mysql://localhost:3306/openboxes?useSSL=false, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 14400, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 1800, maxPoolSize -> 100, maxStatements -> 180, maxStatementsPerConnection -> 0, minPoolSize -> 5, numHelperThreads -> 3, preferredTestQuery -> SELECT 1, privilegeSpawnedThreads -> false, properties -> {user=******, password=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 1, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ]
2024-10-28 20:55:30,244 [localhost-startStop-1] INFO  annotations.Version  - Hibernate Annotations 3.4.0.GA
2024-10-28 20:55:30,270 [localhost-startStop-1] INFO  common.Version  - Hibernate Commons Annotations 3.1.0.GA
2024-10-28 20:55:30,525 [localhost-startStop-1] WARN  commons.GrailsDomainConfigurationUtil  - Derived properties may not be constrained. Property [statusSortOrder] of domain class org.pih.warehouse.inventory.OutboundStockMovementListItem will not be checked during validation.
2024-10-28 20:55:30,574 [localhost-startStop-1] WARN  commons.GrailsDomainConfigurationUtil  - Derived properties may not be constrained. Property [shipmentItemCount] of domain class org.pih.warehouse.shipping.Shipment will not be checked during validation.
2024-10-28 20:55:30,622 [localhost-startStop-1] WARN  commons.GrailsDomainConfigurationUtil  - Derived properties may not be constrained. Property [color] of domain class org.pih.warehouse.product.Product will not be checked during validation.
2024-10-28 20:55:30,647 [localhost-startStop-1] WARN  commons.GrailsDomainConfigurationUtil  - Derived properties may not be constrained. Property [monthRequested] of domain class org.pih.warehouse.requisition.Requisition will not be checked during validation.
2024-10-28 20:55:30,648 [localhost-startStop-1] WARN  commons.GrailsDomainConfigurationUtil  - Derived properties may not be constrained. Property [statusSortOrder] of domain class org.pih.warehouse.requisition.Requisition will not be checked during validation.
2024-10-28 20:55:30,668 [localhost-startStop-1] WARN  commons.GrailsDomainConfigurationUtil  - Derived properties may not be constrained. Property [statusSortOrder] of domain class org.pih.warehouse.inventory.OutboundStockMovement will not be checked during validation.
2024-10-28 20:55:30,674 [localhost-startStop-1] WARN  commons.GrailsDomainConfigurationUtil  - Derived properties may not be constrained. Property [quantityNotPicked] of domain class org.pih.warehouse.product.ProductAvailability will not be checked during validation.
2024-10-28 20:55:30,724 [localhost-startStop-1] INFO  validator.Version  - Hibernate Validator 3.1.0.GA
2024-10-28 20:55:30,794 [localhost-startStop-1] INFO  search.HibernateSearchEventListenerRegister  - Unable to find org.hibernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Search is not enabled.
2024-10-28 20:55:30,842 [localhost-startStop-1] WARN  mapping.RootClass  - composite-id class does not override equals(): org.pih.warehouse.invoice.InvoiceList
2024-10-28 20:55:30,842 [localhost-startStop-1] WARN  mapping.RootClass  - composite-id class does not override hashCode(): org.pih.warehouse.invoice.InvoiceList
2024-10-28 20:55:30,906 [localhost-startStop-1] INFO  connection.ConnectionProviderFactory  - Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
2024-10-28 20:55:30,906 [localhost-startStop-1] INFO  cfg.SettingsFactory  - RDBMS: MySQL, version: 5.5.5-10.6.19-MariaDB
2024-10-28 20:55:30,906 [localhost-startStop-1] INFO  cfg.SettingsFactory  - JDBC driver: MySQL Connector Java, version: mysql-connector-java-5.1.49 ( Revision: ad86f36e100e104cd926c6b81c8cab9565750116 )
2024-10-28 20:55:30,908 [localhost-startStop-1] INFO  dialect.Dialect  - Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect
2024-10-28 20:55:30,909 [localhost-startStop-1] INFO  transaction.TransactionFactoryFactory  - Transaction strategy: org.springframework.orm.hibernate3.SpringTransactionFactory
2024-10-28 20:55:30,910 [localhost-startStop-1] INFO  transaction.TransactionManagerLookupFactory  - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
2024-10-28 20:55:30,910 [localhost-startStop-1] INFO  cfg.SettingsFactory  - Automatic flush during beforeCompletion(): disabled
2024-10-28 20:55:30,910 [localhost-startStop-1] INFO  cfg.SettingsFactory  - Automatic session close at end of transaction: disabled
2024-10-28 20:55:30,910 [localhost-startStop-1] INFO  cfg.SettingsFactory  - JDBC batch size: 15
2024-10-28 20:55:30,910 [localhost-startStop-1] INFO  cfg.SettingsFactory  - JDBC batch updates for versioned data: disabled
2024-10-28 20:55:30,910 [localhost-startStop-1] INFO  cfg.SettingsFactory  - Scrollable result sets: enabled
2024-10-28 20:55:30,910 [localhost-startStop-1] INFO  cfg.SettingsFactory  - JDBC3 getGeneratedKeys(): enabled
2024-10-28 20:55:30,910 [localhost-startStop-1] INFO  cfg.SettingsFactory  - JDBC result set fetch size: 25
2024-10-28 20:55:30,910 [localhost-startStop-1] INFO  cfg.SettingsFactory  - Connection release mode: auto
2024-10-28 20:55:30,911 [localhost-startStop-1] INFO  cfg.SettingsFactory  - Maximum outer join fetch depth: 2
2024-10-28 20:55:30,911 [localhost-startStop-1] INFO  cfg.SettingsFactory  - Default batch fetch size: 25
2024-10-28 20:55:30,911 [localhost-startStop-1] INFO  cfg.SettingsFactory  - Generate SQL with comments: disabled
2024-10-28 20:55:30,911 [localhost-startStop-1] INFO  cfg.SettingsFactory  - Order SQL updates by primary key: enabled
2024-10-28 20:55:30,911 [localhost-startStop-1] INFO  cfg.SettingsFactory  - Order SQL inserts for batching: enabled
2024-10-28 20:55:30,911 [localhost-startStop-1] INFO  cfg.SettingsFactory  - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
2024-10-28 20:55:30,912 [localhost-startStop-1] INFO  ast.ASTQueryTranslatorFactory  - Using ASTQueryTranslatorFactory
2024-10-28 20:55:30,912 [localhost-startStop-1] INFO  cfg.SettingsFactory  - Query language substitutions: {}
2024-10-28 20:55:30,912 [localhost-startStop-1] INFO  cfg.SettingsFactory  - JPA-QL strict compliance: disabled
2024-10-28 20:55:30,912 [localhost-startStop-1] INFO  cfg.SettingsFactory  - Second-level cache: disabled
2024-10-28 20:55:30,912 [localhost-startStop-1] INFO  cfg.SettingsFactory  - Query cache: disabled
2024-10-28 20:55:30,912 [localhost-startStop-1] INFO  cfg.SettingsFactory  - Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory
2024-10-28 20:55:30,912 [localhost-startStop-1] INFO  cfg.SettingsFactory  - Optimize cache for minimal puts: enabled
2024-10-28 20:55:30,912 [localhost-startStop-1] INFO  cfg.SettingsFactory  - Structured second-level cache entries: disabled
2024-10-28 20:55:30,914 [localhost-startStop-1] INFO  cfg.SettingsFactory  - Statistics: disabled
2024-10-28 20:55:30,914 [localhost-startStop-1] INFO  cfg.SettingsFactory  - Deleted entity synthetic identifier rollback: disabled
2024-10-28 20:55:30,914 [localhost-startStop-1] INFO  cfg.SettingsFactory  - Default entity-mode: pojo
2024-10-28 20:55:30,914 [localhost-startStop-1] INFO  cfg.SettingsFactory  - Named query checking : enabled
2024-10-28 20:55:30,940 [localhost-startStop-1] INFO  impl.SessionFactoryImpl  - building session factory
2024-10-28 20:55:32,338 [localhost-startStop-1] INFO  util.NamingHelper  - JNDI InitialContext properties:{}
2024-10-28 20:55:33,222 [localhost-startStop-1] INFO  config.PropertiesFactoryBean  - Loading properties file from class path resource [gsp/views.properties]
2024-10-28 20:55:34,276 [localhost-startStop-1] INFO  ehcache.EhCacheManagerFactoryBean  - Initializing EHCache CacheManager
2024-10-28 20:55:34,890 [localhost-startStop-1] INFO  impl.StdSchedulerFactory  - Using default implementation for ThreadExecutor
2024-10-28 20:55:34,892 [localhost-startStop-1] INFO  simpl.SimpleThreadPool  - Job execution threads will use class loader of thread: localhost-startStop-1
2024-10-28 20:55:34,899 [localhost-startStop-1] INFO  core.SchedulerSignalerImpl  - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
2024-10-28 20:55:34,899 [localhost-startStop-1] INFO  core.QuartzScheduler  - Quartz Scheduler v.2.1.6 created.
2024-10-28 20:55:34,899 [localhost-startStop-1] INFO  simpl.RAMJobStore  - RAMJobStore initialized.
2024-10-28 20:55:34,900 [localhost-startStop-1] INFO  core.QuartzScheduler  - Scheduler meta-data: Quartz Scheduler (v2.1.6) 'DefaultPluginScheduler' with instanceId 'NON_CLUSTERED'
  Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
  NOT STARTED.
  Currently in standby mode.
  Number of jobs executed: 0
  Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads.
  Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support persistence. and is not clustered.

2024-10-28 20:55:34,900 [localhost-startStop-1] INFO  impl.StdSchedulerFactory  - Quartz scheduler 'DefaultPluginScheduler' initialized from an externally provided properties instance.
2024-10-28 20:55:34,900 [localhost-startStop-1] INFO  impl.StdSchedulerFactory  - Quartz scheduler version: 2.1.6
2024-10-28 20:55:34,903 [localhost-startStop-1] INFO  core.QuartzScheduler  - JobFactory set to: grails.plugin.quartz2.GrailsJobFactory@7d388c5a
2024-10-28 20:55:35,656 [localhost-startStop-1] INFO  support.DefaultLifecycleProcessor  - Starting beans in phase 2147483647
Starting Quartz Scheduler in QuartzFactoryBean
2024-10-28 20:55:35,657 [localhost-startStop-1] INFO  core.QuartzScheduler  - Scheduler DefaultPluginScheduler_$_NON_CLUSTERED started.
2024-10-28 20:55:36,281 [localhost-startStop-1] INFO  support.DefaultListableBeanFactory  - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@52293724: defining beans [org.grails.plugin.zippedresources.ZipResourceMapper,org.grails.plugin.resource.CSSRewriterResourceMapper,org.grails.plugin.cachedresources.HashAndCacheResourceMapper,org.grails.plugin.resource.BundleResourceMapperInstance,org.grails.plugin.resource.CSSRewriterResourceMapperInstance,org.grails.plugin.resource.BundleResourceMapper,org.grails.plugin.cachedresources.HashAndCacheResourceMapperInstance,org.grails.plugin.zippedresources.ZipResourceMapperInstance,org.grails.plugin.resource.CSSPreprocessorResourceMapperInstance,org.grails.plugin.resource.CSSPreprocessorResourceMapper]; parent: org.codehaus.groovy.grails.commons.spring.ReloadAwareAutowireCapableBeanFactory@15f9db52
2024-10-28 20:55:43,090 [localhost-startStop-1] WARN  commons.GrailsDomainConfigurationUtil  - Derived properties may not be constrained. Property [monthRequested] of domain class org.pih.warehouse.requisition.Requisition will not be checked during validation.
2024-10-28 20:55:43,090 [localhost-startStop-1] WARN  commons.GrailsDomainConfigurationUtil  - Derived properties may not be constrained. Property [statusSortOrder] of domain class org.pih.warehouse.requisition.Requisition will not be checked during validation.
2024-10-28 20:55:43,093 [localhost-startStop-1] WARN  commons.GrailsDomainConfigurationUtil  - Derived properties may not be constrained. Property [shipmentItemCount] of domain class org.pih.warehouse.shipping.Shipment will not be checked during validation.
2024-10-28 20:55:43,093 [localhost-startStop-1] WARN  commons.GrailsDomainConfigurationUtil  - Derived properties may not be constrained. Property [statusSortOrder] of domain class org.pih.warehouse.inventory.OutboundStockMovementListItem will not be checked during validation.
2024-10-28 20:55:43,094 [localhost-startStop-1] WARN  commons.GrailsDomainConfigurationUtil  - Derived properties may not be constrained. Property [statusSortOrder] of domain class org.pih.warehouse.inventory.OutboundStockMovement will not be checked during validation.
2024-10-28 20:55:43,096 [localhost-startStop-1] WARN  commons.GrailsDomainConfigurationUtil  - Derived properties may not be constrained. Property [quantityNotPicked] of domain class org.pih.warehouse.product.ProductAvailability will not be checked during validation.
2024-10-28 20:55:43,096 [localhost-startStop-1] WARN  commons.GrailsDomainConfigurationUtil  - Derived properties may not be constrained. Property [color] of domain class org.pih.warehouse.product.Product will not be checked during validation.
2024-10-28 20:55:43,317 [localhost-startStop-1] INFO  bootstrap.BootStrap  - Running liquibase changelog(s) ...
2024-10-28 20:55:43,392 [localhost-startStop-1] INFO  bootstrap.BootStrap  - Liquibase running: true
2024-10-28 20:55:43,394 [localhost-startStop-1] INFO  bootstrap.BootStrap  - Setting default schema to openboxes
2024-10-28 20:55:43,395 [localhost-startStop-1] INFO  bootstrap.BootStrap  - Product Version: 5.5.5-10.6.19-MariaDB
2024-10-28 20:55:43,395 [localhost-startStop-1] INFO  bootstrap.BootStrap  - Database Version: 5.5
2024-10-28 20:55:43,396 [localhost-startStop-1] INFO  liquibase  - Reading from `DATABASECHANGELOG`
Waiting for changelog lock....
Waiting for changelog lock....
2024-10-28 20:56:00,052 [DefaultPluginScheduler_Worker-1] INFO  jobs.JobUtils  - Postponing job execution for assignIdentifierJob until liquibase migrations are complete
Waiting for changelog lock....

Also this error in my Tomcat webmin module, don’t know if it was there before:

Never mind, fixed it!

For everyone wanting to know: in the database there is a table with CHANGELOCK. There was a row present that made it wait. Deleted it → restart → works!

For everyone wanting to know: in the database there is a table with CHANGELOCK. There was a row present that made it wait. Deleted it → restart → works!

Awesome. That is what I was going to suggest. Glad you got it fixed on your own.

If anyone else encounters the issue, you’ll need to execute the following SQL statement to remove the lock and allow the system to start up properly.

DELETE FROM DATABASECHANGELOGLOCK;

Waiting for changelog lock…

For more context, this is a Liquibase feature that prevents multiple parallel executions of the database migrations (the automated DDL/DML statements used to the update the data model and default system data). For example, if Tomcat is started twice it’s possible for the application to trigger the database migrations twice. So you could end up with a scenario where a CREATE TABLE or ADD COLUMN statement is executed twice. The DATABASECHANGELOGLOCK feature prevents that scenario from occuring.

Also this error in my Tomcat webmin module, don’t know if it was there before:

Unfortunately, I am not familiar with the Tomcat webmin module, so I can’t help with the other error message you with the other error message.