2018-10-30 10:52:26,794 1 INFO [grails.plugin.hibernate3.HibernatePluginSupport] (localhost-startStop-1:) Using dataSource bean definition from /WEB-INF/spring/resources.groovy 2018-10-30 10:52:26,819 26 INFO [grails.plugin.hibernate3.HibernatePluginSupport] (localhost-startStop-1:) Set db generation strategy to 'none' for datasource DEFAULT 2018-10-30 10:52:31,031 4238 INFO [grails.plugin.remoting.RemotingPluginHelper] (localhost-startStop-1:) Unrecognised invoker protocol: cxfjax - ignoring for this service ('MigrationService'). 2018-10-30 10:52:40,913 14120 INFO [com.mchange.v2.log.MLog] (localhost-startStop-1:) MLog clients using log4j logging. 2018-10-30 10:52:41,200 14407 INFO [com.mchange.v2.c3p0.C3P0Registry] (localhost-startStop-1:) Initializing c3p0-0.9.2.1 [built 20-March-2013 10:47:27 +0000; debug? true; trace: 10] 2018-10-30 10:52:41,872 15079 INFO [com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource] (localhost-startStop-1:) Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 2, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 10000, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> z8kfsx9y1ihohbj1l35ucj|3815a682, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> z8kfsx9y1ihohbj1l35ucj|3815a682, idleConnectionTestPeriod -> 30, initialPoolSize -> 10, jdbcUrl -> jdbc:mysql://192.168.1.81:3306/jbilling, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 300, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 50, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 10, numHelperThreads -> 3, preferredTestQuery -> /* ping */ SELECT 1, properties -> {user=******, password=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ] 2018-10-30 10:53:05,975 39182 DEBUG [com.sapienter.jbilling.common.SystemProperties] (localhost-startStop-1:) System properties loaded from: /root/jbilling/jbilling_community/jbilling/jbilling.properties 2018-10-30 10:53:05,980 39187 DEBUG [com.sapienter.jbilling.common.SystemProperties] (localhost-startStop-1:) Resolved jbilling resources directory to: /root/jbilling/jbilling_community/jbilling/resources/ 2018-10-30 10:53:48,484 81691 INFO [org.apache.activemq.broker.jmx.ManagementContext] (JMX connector:) JMX consoles can connect to service:jmx:rmi:///jndi/rmi://localhost:1099/jmxrmi 2018-10-30 10:53:48,974 82181 INFO [org.apache.activemq.broker.BrokerService] (localhost-startStop-1:) Using Persistence Adapter: AMQPersistenceAdapter(activemq-data/localhost) 2018-10-30 10:53:48,978 82185 INFO [org.apache.activemq.store.amq.AMQPersistenceAdapter] (localhost-startStop-1:) AMQStore starting using directory: activemq-data/localhost 2018-10-30 10:53:49,263 82470 INFO [org.apache.activemq.kaha.impl.KahaStore] (localhost-startStop-1:) Kaha Store using data directory activemq-data/localhost/kr-store/state 2018-10-30 10:53:49,539 82746 INFO [org.apache.activemq.store.amq.AMQPersistenceAdapter] (localhost-startStop-1:) Active data files: [] 2018-10-30 10:53:49,554 82761 WARN [org.apache.activemq.store.amq.AMQPersistenceAdapter] (localhost-startStop-1:) The ReferenceStore is not valid - recovering ... 2018-10-30 10:53:49,603 82810 INFO [org.apache.activemq.kaha.impl.KahaStore] (localhost-startStop-1:) Kaha Store successfully deleted data directory activemq-data/localhost/kr-store/data 2018-10-30 10:53:49,606 82813 INFO [org.apache.activemq.store.amq.AMQPersistenceAdapter] (localhost-startStop-1:) Journal Recovery Started from: DataManager:(data-) 2018-10-30 10:53:49,802 83009 INFO [org.apache.activemq.kaha.impl.KahaStore] (localhost-startStop-1:) Kaha Store using data directory activemq-data/localhost/kr-store/data 2018-10-30 10:53:50,077 83284 INFO [org.apache.activemq.store.amq.AMQPersistenceAdapter] (localhost-startStop-1:) Recovered 2 operations from redo log in 0.467 seconds. 2018-10-30 10:53:50,079 83286 INFO [org.apache.activemq.store.amq.AMQPersistenceAdapter] (localhost-startStop-1:) Finished recovering the ReferenceStore 2018-10-30 10:53:50,118 83325 INFO [org.apache.activemq.broker.BrokerService] (localhost-startStop-1:) ActiveMQ 5.3.2 JMS Message Broker (localhost) is starting 2018-10-30 10:53:50,126 83333 INFO [org.apache.activemq.broker.BrokerService] (localhost-startStop-1:) For help or more information please see: http://activemq.apache.org/ 2018-10-30 10:53:51,057 84264 INFO [org.apache.activemq.transport.TransportServerThreadSupport] (localhost-startStop-1:) Listening for connections at: tcp://localhost:61616 2018-10-30 10:53:51,060 84267 INFO [org.apache.activemq.broker.TransportConnector] (localhost-startStop-1:) Connector tcp://localhost:61616 Started 2018-10-30 10:53:51,093 84300 INFO [org.apache.activemq.broker.TransportConnector] (localhost-startStop-1:) Connector vm://localhost Started 2018-10-30 10:53:51,106 84313 INFO [org.apache.activemq.broker.BrokerService] (localhost-startStop-1:) ActiveMQ JMS Message Broker (localhost, ID:debian-9-43553-1540893230308-0:0) started 2018-10-30 10:53:55,811 89018 INFO [org.grails.plugin.resource.ResourceProcessor] (localhost-startStop-1:) Performing a full reload 2018-10-30 10:53:57,281 90488 INFO [org.grails.plugin.resource.ResourceProcessor] (localhost-startStop-1:) Loading resource declarations... 2018-10-30 10:53:57,293 90500 INFO [org.grails.plugin.resource.ResourceProcessor] (localhost-startStop-1:) Forgetting all known modules... 2018-10-30 10:53:57,306 90513 INFO [org.grails.plugin.resource.ResourceProcessor] (localhost-startStop-1:) Forgetting all known resources... 2018-10-30 10:54:01,203 94410 DEBUG [grails.app.resourceMappers.org.grails.plugin.resource.CSSPreprocessorResourceMapper] (localhost-startStop-1:) CSS Preprocessor munging ResourceMeta for URI /jquery-ui/themes/jbilling/jquery-ui-1.10.4.custom.css served by /jquery-ui/themes/jbilling/jquery-ui-1.10.4.custom.css (delegate: none) 2018-10-30 10:54:02,717 95924 DEBUG [grails.app.resourceMappers.org.grails.plugin.resource.CSSPreprocessorResourceMapper] (localhost-startStop-1:) CSS Preprocessor munging ResourceMeta for URI /css/all.css served by /css/all.css (delegate: none) 2018-10-30 10:54:03,725 96932 DEBUG [grails.app.resourceMappers.org.grails.plugin.resource.CSSPreprocessorResourceMapper] (localhost-startStop-1:) CSS Preprocessor munging ResourceMeta for URI /css/lt7.css served by /css/lt7.css (delegate: none) 2018-10-30 10:54:04,224 97431 DEBUG [grails.app.resourceMappers.org.grails.plugin.resource.CSSPreprocessorResourceMapper] (localhost-startStop-1:) CSS Preprocessor munging ResourceMeta for URI /css/ict.css served by /css/ict.css (delegate: none) 2018-10-30 10:54:04,321 97528 DEBUG [grails.app.resourceMappers.org.grails.plugin.resource.CSSPreprocessorResourceMapper] (localhost-startStop-1:) CSS Preprocessor munging ResourceMeta for URI /css/alpaca.min.css served by /css/alpaca.min.css (delegate: none) 2018-10-30 10:54:04,354 97561 DEBUG [grails.app.resourceMappers.org.grails.plugin.resource.CSSPreprocessorResourceMapper] (localhost-startStop-1:) CSS Preprocessor munging ResourceMeta for URI /css/alpaca-jqueryui.min.css served by /css/alpaca-jqueryui.min.css (delegate: none) 2018-10-30 10:54:04,377 97584 DEBUG [grails.app.resourceMappers.org.grails.plugin.resource.CSSPreprocessorResourceMapper] (localhost-startStop-1:) CSS Preprocessor munging ResourceMeta for URI /css/evol.colorpicker.css served by /css/evol.colorpicker.css (delegate: none) 2018-10-30 10:54:04,407 97614 DEBUG [grails.app.resourceMappers.org.grails.plugin.resource.CSSPreprocessorResourceMapper] (localhost-startStop-1:) CSS Preprocessor munging ResourceMeta for URI /css/jstree/invoice-template-tree.css served by /css/jstree/invoice-template-tree.css (delegate: none) 2018-10-30 10:54:04,749 97956 DEBUG [grails.app.resourceMappers.org.grails.plugin.resource.CSSPreprocessorResourceMapper] (localhost-startStop-1:) CSS Preprocessor skipping ResourceMeta for URI /bundle-bundle_itg_head.css, /css/ict.css, /css/alpaca.min.css, /css/alpaca-jqueryui.min.css, /css/evol.colorpicker.css, /css/jstree/invoice-template-tree.css served by /bundle-bundle_itg_head.css (delegate: none) because it is aggregated (already processed each file in it) 2018-10-30 10:54:04,865 98072 ERROR [org.grails.plugin.resource.ResourceMeta] (localhost-startStop-1:) While processing /bundle-bundle_itg_head.css, /css/ict.css, /css/alpaca.min.css, /css/alpaca-jqueryui.min.css, /css/evol.colorpicker.css, /css/jstree/invoice-template-tree.css, a resource was required but not found: /css/images/down.png 2018-10-30 10:54:04,879 98086 WARN [org.grails.plugin.resource.util.ResourceMetaStore] (localhost-startStop-1:) Cannot locate resource [/css/images/down.png] 2018-10-30 10:54:04,883 98090 WARN [org.grails.plugin.resource.mapper.cssrewriter] (localhost-startStop-1:) Cannot resolve CSS resource, leaving link as is: resource:/css/images/down.png 2018-10-30 10:54:04,943 98150 ERROR [org.grails.plugin.resource.ResourceMeta] (localhost-startStop-1:) While processing /bundle-bundle_itg_head.css, /css/ict.css, /css/alpaca.min.css, /css/alpaca-jqueryui.min.css, /css/evol.colorpicker.css, /css/jstree/invoice-template-tree.css, a resource was required but not found: /css/images/left.png 2018-10-30 10:54:04,946 98153 WARN [org.grails.plugin.resource.util.ResourceMetaStore] (localhost-startStop-1:) Cannot locate resource [/css/images/left.png] 2018-10-30 10:54:04,950 98157 WARN [org.grails.plugin.resource.mapper.cssrewriter] (localhost-startStop-1:) Cannot resolve CSS resource, leaving link as is: resource:/css/images/left.png 2018-10-30 10:54:05,183 98390 INFO [org.grails.plugin.resource.ResourceProcessor] (localhost-startStop-1:) Finished full reload 2018-10-30 10:54:18,330 111537 INFO [org.codehaus.groovy.grails.web.context.GrailsConfigUtils] (localhost-startStop-1:) [GrailsContextLoader] Grails application loaded. 2018-10-30 10:54:19,890 113097 INFO [org.quartz.impl.StdSchedulerFactory] (localhost-startStop-1:) Using default implementation for ThreadExecutor 2018-10-30 10:54:19,945 113152 INFO [org.quartz.simpl.SimpleThreadPool] (localhost-startStop-1:) Job execution threads will use class loader of thread: localhost-startStop-1 2018-10-30 10:54:20,184 113391 INFO [org.quartz.core.SchedulerSignalerImpl] (localhost-startStop-1:) Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2018-10-30 10:54:20,186 113393 INFO [org.quartz.core.QuartzScheduler] (localhost-startStop-1:) Quartz Scheduler v.2.2.1 created. 2018-10-30 10:54:20,204 113411 INFO [org.quartz.simpl.RAMJobStore] (localhost-startStop-1:) RAMJobStore initialized. 2018-10-30 10:54:20,227 113434 INFO [org.quartz.core.QuartzScheduler] (localhost-startStop-1:) Scheduler meta-data: Quartz Scheduler (v2.2.1) 'DefaultQuartzScheduler' 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. 2018-10-30 10:54:20,242 113449 INFO [org.quartz.impl.StdSchedulerFactory] (localhost-startStop-1:) Quartz scheduler 'DefaultQuartzScheduler' initialized from default resource file in Quartz package: 'quartz.properties' 2018-10-30 10:54:20,244 113451 INFO [org.quartz.impl.StdSchedulerFactory] (localhost-startStop-1:) Quartz scheduler version: 2.2.1 2018-10-30 10:54:21,447 114654 ERROR [org.hibernate.util.JDBCExceptionReporter] (localhost-startStop-1:) Table 'jbilling.reseller_entityid_map' doesn't exist 2018-10-30 10:54:21,657 114864 ERROR [org.codehaus.groovy.grails.web.context.GrailsContextLoaderListener] (localhost-startStop-1:) Error initializing the application: could not execute query org.hibernate.exception.SQLGrammarException: could not execute query at com.sapienter.jbilling.server.user.db.CompanyDAS.findEntities(CompanyDAS.java:40) at com.sapienter.jbilling.server.util.SchedulerBootstrapHelper.schedulePluggableTasks(SchedulerBootstrapHelper.java:65) at BootStrap$_closure1.doCall(BootStrap.groovy:78) at grails.util.Environment.evaluateEnvironmentSpecificBlock(Environment.java:327) at grails.util.Environment.executeForEnvironment(Environment.java:320) at grails.util.Environment.executeForCurrentEnvironment(Environment.java:296) 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:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jbilling.reseller_entityid_map' doesn't exist at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2818) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2157) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2324) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116) ... 11 more 2018-10-30 10:54:21,676 114883 ERROR [org.codehaus.groovy.grails.web.context.GrailsContextLoaderListener] (localhost-startStop-1:) Error initializing Grails: could not execute query org.hibernate.exception.SQLGrammarException: could not execute query at com.sapienter.jbilling.server.user.db.CompanyDAS.findEntities(CompanyDAS.java:40) at com.sapienter.jbilling.server.util.SchedulerBootstrapHelper.schedulePluggableTasks(SchedulerBootstrapHelper.java:65) at BootStrap$_closure1.doCall(BootStrap.groovy:78) at grails.util.Environment.evaluateEnvironmentSpecificBlock(Environment.java:327) at grails.util.Environment.executeForEnvironment(Environment.java:320) at grails.util.Environment.executeForCurrentEnvironment(Environment.java:296) 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:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jbilling.reseller_entityid_map' doesn't exist at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2818) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2157) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2324) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116) ... 11 more 2018-10-30 10:54:21,850 115057 WARN [org.codehaus.groovy.grails.lifecycle.ShutdownOperations] (localhost-startStop-1:) Error occurred running shutdown operation: BeanFactory not initialized or already closed - call 'refresh' before accessing beans via the ApplicationContext java.lang.IllegalStateException: BeanFactory not initialized or already closed - call 'refresh' before accessing beans via the ApplicationContext 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:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) 2018-10-30 10:54:21,857 115064 INFO [org.codehaus.groovy.grails.web.context.GrailsContextLoaderListener] (localhost-startStop-1:) Destroying Spring parent WebApplicationContext Root WebApplicationContext