Webtop DataBase Error

sgb77 · March 26, 2023, 12:53am

NethServer Version: 7.9.2009(final)
Module: webtop

Hi,
After installing updates in my server I am getting a popup as soon as I log in “DB Error”
There’s a similar thread out there, and tried to revive it, but was advised to create a new one.
Thanks for any help.
From the error logs:

t com.sonicle.webtop.core.dal.AuditLogDAO.insertAccess(AuditLogDAO.java:173)
	at com.sonicle.webtop.core.app.AuditLogManager.internalWriteSync(AuditLogManager.java:452)
	... 18 common frames omitted
Caused by: org.jooq.exception.DataAccessException: SQL [insert into "core"."access_log" ("timestamp", "domain_id", "user_id", "software_name", "session_id", "service_id", "context", "action", "reference_id", "data") values (cast(? as timestamp(6) with time zone), ?, ?, ?, ?, ?, ?, ?, ?, ?)]; ERROR: relation "core.access_log" does not exist
  Position: 13
	at org.jooq_3.14.15.POSTGRES.debug(Unknown Source)
	at org.jooq.impl.Tools.translate(Tools.java:2903)
	at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:757)
	at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:389)
	... 21 common frames omitted
Caused by: org.postgresql.util.PSQLException: ERROR: relation "core.access_log" does not exist
  Position: 13
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:355)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:490)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:408)
	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:166)
	at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:155)
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
	at org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:214)
	at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:458)
	at org.jooq.impl.AbstractDMLQuery.execute(AbstractDMLQuery.java:953)
	at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:375)
	... 21 common frames omitted
2023-03-25 20:40:05 [INFO ] c.sonicle.webtop.core.app.WebTopApp - WTA shutdown started [webtop]
2023-03-25 20:40:05 [INFO ] c.sonicle.webtop.core.app.WebTopApp - Task 'webappVersionCheck' destroyed
2023-03-25 20:40:06 [INFO ] c.s.webtop.core.app.ServiceManager - Cleaned up
2023-03-25 20:40:06 [INFO ] c.s.webtop.core.app.SessionManager - Cleaned up
2023-03-25 20:40:06 [INFO ] c.s.webtop.core.app.DocEditorManager - Cleaned up
2023-03-25 20:40:06 [INFO ] c.s.webtop.core.app.ReportManager - Cleaned up
2023-03-25 20:40:06 [INFO ] c.sonicle.webtop.core.app.OTPManager - Cleaned up
2023-03-25 20:40:06 [INFO ] c.s.webtop.core.app.AuditLogManager - Cleaned up
2023-03-25 20:40:08 [INFO ] c.s.w.core.app.DataSourcesManager - Cleaned up
2023-03-25 20:40:08 [INFO ] c.s.webtop.core.app.WebTopManager - Cleaned up
2023-03-25 20:40:08 [INFO ] c.s.w.core.app.ConnectionManager - Cleaned up
2023-03-25 20:40:08 [INFO ] c.s.webtop.core.app.I18nManager - Cleaned up
2023-03-25 20:40:08 [INFO ] c.sonicle.webtop.core.app.WebTopApp - WTA shutdown completed [webtop]
2023-03-25 20:42:32 [INFO ] c.sonicle.webtop.core.app.WebTopApp - webtop.etc.dir = /etc/webtop [/etc/webtop]
2023-03-25 20:42:32 [INFO ] c.sonicle.webtop.core.app.WebTopApp - webtop.log.dir = /var/log/webtop [/var/log/webtop]
2023-03-25 20:42:32 [INFO ] c.sonicle.webtop.core.app.WebTopApp - webtop.log.file.basename = webtop [webtop]
2023-03-25 20:42:32 [INFO ] c.sonicle.webtop.core.app.WebTopApp - webtop.log.target = file [file]
2023-03-25 20:42:32 [INFO ] c.sonicle.webtop.core.app.WebTopApp - webtop.log.file.policy = simple [simple]
2023-03-25 20:42:32 [INFO ] c.sonicle.webtop.core.app.WebTopApp - webtop.log.auth.target = file [file]
2023-03-25 20:42:32 [INFO ] c.sonicle.webtop.core.app.WebTopApp - webtop.logback.syslog.host = null [localhost]
2023-03-25 20:42:32 [INFO ] c.sonicle.webtop.core.app.WebTopApp - webtop.logback.syslog.port = null [514]
2023-03-25 20:42:32 [INFO ] c.sonicle.webtop.core.app.WebTopApp - webtop.extjs.debug = null [false]
2023-03-25 20:42:32 [INFO ] c.sonicle.webtop.core.app.WebTopApp - webtop.js.debug = false [false]
2023-03-25 20:42:32 [INFO ] c.sonicle.webtop.core.app.WebTopApp - webtop.soext.devmode = null [false]
2023-03-25 20:42:32 [INFO ] c.sonicle.webtop.core.app.WebTopApp - webtop.devmode = null [false]
2023-03-25 20:42:32 [INFO ] c.sonicle.webtop.core.app.WebTopApp - webtop.scheduler.disabled = null [false]
2023-03-25 20:42:32 [INFO ] c.sonicle.webtop.core.app.WebTopApp - webtop.quartz.maxthreads = null [10]
2023-03-25 20:42:32 [INFO ] c.sonicle.webtop.core.app.WebTopApp - webtop.atmosphere.maxschedulerthreads = null [10]
2023-03-25 20:42:32 [INFO ] c.sonicle.webtop.core.app.WebTopApp - webtop.atmosphere.maxprocessingthreads = null [10]
2023-03-25 20:42:32 [INFO ] c.sonicle.webtop.core.app.WebTopApp - webtop.atmosphere.maxwritethreads = null [10]
2023-03-25 20:42:32 [INFO ] c.sonicle.webtop.core.app.WebTopApp - webtop.tomcat.manager.uri = null [null]
2023-03-25 20:42:32 [INFO ] c.sonicle.webtop.core.app.WebTopApp - webtop.directory.similarity.leventhres = null [5]
2023-03-25 20:42:32 [INFO ] c.sonicle.webtop.core.app.WebTopApp - webtop.directory.similarity.tokensize = null [4]
2023-03-25 20:42:32 [INFO ] c.sonicle.webtop.core.app.WebTopApp - webtop.session.forcesecurecookie = true [true]
2023-03-25 20:42:32 [INFO ] c.sonicle.webtop.core.app.WebTopApp - WTA initialization started [webtop]
2023-03-25 20:42:33 [INFO ] c.s.w.core.app.ConnectionManager - Initialized
2023-03-25 20:42:33 [INFO ] c.s.webtop.core.app.AuditLogManager - Initialized
2023-03-25 20:42:33 [INFO ] c.s.webtop.core.app.SessionManager - Initialized
2023-03-25 20:42:33 [INFO ] c.sonicle.webtop.core.app.WebTopApp - Checking home structure...
2023-03-25 20:42:36 [INFO ] c.sonicle.webtop.core.app.WebTopApp - Initializing template engine
2023-03-25 20:42:36 [INFO ] c.s.webtop.core.app.LicenseManager - Initialized
2023-03-25 20:42:36 [INFO ] c.s.webtop.core.app.WebTopManager - Initialized
2023-03-25 20:42:36 [INFO ] c.sonicle.webtop.core.app.OTPManager - Initialized
2023-03-25 20:42:36 [INFO ] c.s.webtop.core.app.ReportManager - Initialized
2023-03-25 20:42:36 [INFO ] c.s.webtop.core.app.DocEditorManager - Initialized
2023-03-25 20:42:36 [INFO ] c.s.webtop.core.app.ServiceManager - [com.sonicle.webtop.core] Registering service...
2023-03-25 20:42:36 [INFO ] c.s.webtop.core.app.ServiceManager - [private:true, public:true, job:true, userOptions:true]
2023-03-25 20:42:36 [INFO ] c.s.webtop.core.app.ServiceManager - Not upgraded! [5.15.8 = 5.15.8]
2023-03-25 20:42:37 [INFO ] c.s.webtop.core.app.ServiceManager - Database upgrades will be appended to 1679791357078
2023-03-25 20:42:37 [INFO ] c.s.webtop.core.app.ServiceManager - [com.sonicle.webtop.core.admin] Registering service...
2023-03-25 20:42:37 [INFO ] c.s.webtop.core.app.ServiceManager - [private:true, public:false, job:false, userOptions:false]
2023-03-25 20:42:37 [INFO ] c.s.webtop.core.app.ServiceManager - Not upgraded! [5.15.8 = 5.15.8]
2023-03-25 20:42:37 [INFO ] c.s.webtop.core.app.ServiceManager - [com.sonicle.webtop.calendar] Registering service...
2023-03-25 20:42:37 [INFO ] c.s.webtop.core.app.ServiceManager - [private:true, public:true, job:true, userOptions:true]
2023-03-25 20:42:37 [INFO ] c.s.webtop.core.app.ServiceManager - Not upgraded! [5.15.3 = 5.15.3]
2023-03-25 20:42:37 [INFO ] c.s.webtop.core.app.ServiceManager - [com.sonicle.webtop.contacts] Registering service...
2023-03-25 20:42:37 [INFO ] c.s.webtop.core.app.ServiceManager - [private:true, public:false, job:true, userOptions:true]
2023-03-25 20:42:37 [INFO ] c.s.webtop.core.app.ServiceManager - Not upgraded! [5.14.1 = 5.14.1]
2023-03-25 20:42:37 [INFO ] c.s.webtop.core.app.ServiceManager - [com.sonicle.webtop.mail] Registering service...
2023-03-25 20:42:37 [INFO ] c.s.webtop.core.app.ServiceManager - [private:true, public:false, job:true, userOptions:true]
2023-03-25 20:42:37 [INFO ] c.s.webtop.core.app.ServiceManager - Not upgraded! [5.16.5 = 5.16.5]
2023-03-25 20:42:37 [INFO ] c.s.webtop.core.app.ServiceManager - [com.sonicle.webtop.tasks] Registering service...
2023-03-25 20:42:37 [INFO ] c.s.webtop.core.app.ServiceManager - [private:true, public:false, job:false, userOptions:true]
2023-03-25 20:42:37 [INFO ] c.s.webtop.core.app.ServiceManager - Not upgraded! [5.11.3 = 5.11.3]
2023-03-25 20:42:37 [INFO ] c.s.webtop.core.app.ServiceManager - [com.sonicle.webtop.vfs] Registering service...
2023-03-25 20:42:37 [INFO ] c.s.webtop.core.app.ServiceManager - [private:true, public:true, job:false, userOptions:true]
2023-03-25 20:42:37 [INFO ] c.s.webtop.core.app.ServiceManager - Not upgraded! [5.8.1 = 5.8.1]
2023-03-25 20:42:37 [INFO ] c.s.webtop.core.app.ServiceManager - Maintenance mode: false
2023-03-25 20:42:37 [INFO ] c.s.webtop.core.app.ServiceManager - Initialized
2023-03-25 20:42:37 [INFO ] c.s.webtop.core.app.I18nManager - Initialized
2023-03-25 20:42:37 [INFO ] c.sonicle.webtop.core.app.WebTopApp - WTA initialization completed [webtop]
2023-03-25 20:42:42 [INFO ] c.sonicle.webtop.core.app.WebTopApp - Checking domains homes structure...
2023-03-25 20:42:42 [INFO ] c.sonicle.webtop.core.app.WebTopApp - Checking webapp version...
2023-03-25 20:42:42 [WARN ] c.sonicle.webtop.core.app.WebTopApp - No configuration found for TomcatManager [tomcat.manager.uri]
2023-03-25 20:42:42 [WARN ] c.sonicle.webtop.core.app.WebTopApp - Webapp version automatic check will NOT be performed!
2023-03-25 20:42:42 [INFO ] c.sonicle.webtop.core.app.WebTopApp - This webapp [webtop] is the latest
2023-03-25 20:49:08 [ERROR] c.s.webtop.core.app.AuditLogManager - Unable to write entrie
com.sonicle.webtop.core.sdk.WTException: DB error
	at com.sonicle.webtop.core.app.util.ExceptionUtils.wrapThrowable(ExceptionUtils.java:53)
	at com.sonicle.webtop.core.app.AuditLogManager.internalWriteSync(AuditLogManager.java:470)
	at com.sonicle.webtop.core.app.AuditLogManager.lambda$write$1(AuditLogManager.java:176)
	at org.apache.shiro.subject.support.SubjectRunnable.doRun(SubjectRunnable.java:120)
	at org.apache.shiro.subject.support.SubjectRunnable.run(SubjectRunnable.java:108)
	at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:395)
	at com.sonicle.webtop.core.app.WT.runPrivileged(WT.java:285)
	at com.sonicle.webtop.core.app.AuditLogManager.write(AuditLogManager.java:174)
	at com.sonicle.webtop.core.app.shiro.WTFormAuthFilter.writeAuthLog(WTFormAuthFilter.java:249)
	at com.sonicle.webtop.core.app.shiro.WTFormAuthFilter.onLoginSuccess(WTFormAuthFilter.java:142)
	at org.apache.shiro.web.filter.authc.AuthenticatingFilter.executeLogin(AuthenticatingFilter.java:54)
	at org.apache.shiro.web.filter.authc.FormAuthenticationFilter.onAccessDenied(FormAuthenticationFilter.java:154)
	at com.sonicle.webtop.core.app.shiro.WTFormAuthFilter.onAccessDenied(WTFormAuthFilter.java:161)
	at org.apache.shiro.web.filter.AccessControlFilter.onAccessDenied(AccessControlFilter.java:133)
	at org.apache.shiro.web.filter.AccessControlFilter.onPreHandle(AccessControlFilter.java:162)
	at org.apache.shiro.web.filter.PathMatchingFilter.isFilterChainContinued(PathMatchingFilter.java:223)
	at org.apache.shiro.web.filter.PathMatchingFilter.preHandle(PathMatchingFilter.java:198)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:131)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at com.sonicle.webtop.core.app.shiro.filter.GZip.doFilterInternal(GZip.java:60)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:450)
	at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
	at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
	at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
	at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
	at com.sonicle.webtop.core.app.shiro.WTShiroFilter.doFilterInternal(WTShiroFilter.java:89)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:747)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:615)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1627)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:750)
Caused by: com.sonicle.webtop.core.dal.DAOException: JOOQ
	at org.jooq_3.14.15.POSTGRES.debug(Unknown Source)
	at com.sonicle.webtop.core.dal.BaseDAO$DAOExecuteListener.exception(BaseDAO.java:161)
	at org.jooq.impl.ExecuteListeners.exception(ExecuteListeners.java:274)
	at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:390)
	at org.jooq.impl.AbstractDelegatingQuery.execute(AbstractDelegatingQuery.java:119)
	at com.sonicle.webtop.core.dal.AuditLogDAO.insertAccess(AuditLogDAO.java:173)
	at com.sonicle.webtop.core.app.AuditLogManager.internalWriteSync(AuditLogManager.java:452)
	... 58 common frames omitted
Caused by: org.jooq.exception.DataAccessException: SQL [insert into "core"."access_log" ("timestamp", "domain_id", "user_id", "software_name", "session_id", "service_id", "context", "action", "reference_id", "data") values (cast(? as timestamp(6) with time zone), ?, ?, ?, ?, ?, ?, ?, ?, ?)]; ERROR: relation "core.access_log" does not exist
  Position: 13
	at org.jooq_3.14.15.POSTGRES.debug(Unknown Source)
	at org.jooq.impl.Tools.translate(Tools.java:2903)
	at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:757)
	at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:389)
	... 61 common frames omitted
Caused by: org.postgresql.util.PSQLException: ERROR: relation "core.access_log" does not exist
  Position: 13
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:355)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:490)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:408)
	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:166)
	at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:155)
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
	at org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:214)
	at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:458)
	at org.jooq.impl.AbstractDMLQuery.execute(AbstractDMLQuery.java:953)
	at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:375)
	... 61 common frames omitted
2023-03-25 20:49:09 [ERROR] c.s.webtop.core.app.AuditLogManager - Unable to write entrie
com.sonicle.webtop.core.sdk.WTException: DB error
	at com.sonicle.webtop.core.app.util.ExceptionUtils.wrapThrowable(ExceptionUtils.java:53)
	at com.sonicle.webtop.core.app.AuditLogManager.internalWriteSync(AuditLogManager.java:470)
	at com.sonicle.webtop.core.app.AuditLogManager.lambda$write$1(AuditLogManager.java:176)
	at org.apache.shiro.subject.support.SubjectRunnable.doRun(SubjectRunnable.java:120)
	at org.apache.shiro.subject.support.SubjectRunnable.run(SubjectRunnable.java:108)
	at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:395)
	at com.sonicle.webtop.core.app.WT.runPrivileged(WT.java:285)
	at com.sonicle.webtop.core.app.AuditLogManager.write(AuditLogManager.java:174)
	at com.sonicle.webtop.core.app.WebTopSession.internalInitPrivateEnvironment(WebTopSession.java:478)
	at com.sonicle.webtop.core.app.WebTopSession.initPrivateEnvironment(WebTopSession.java:404)
	at com.sonicle.webtop.core.app.servlet.UIPrivate.processRequest(UIPrivate.java:140)
	at com.sonicle.webtop.core.app.AbstractServlet.doGet(AbstractServlet.java:75)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at com.sonicle.webtop.core.app.shiro.filter.GZip.doFilterInternal(GZip.java:60)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:450)
	at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
	at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
	at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
	at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
	at com.sonicle.webtop.core.app.shiro.WTShiroFilter.doFilterInternal(WTShiroFilter.java:89)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:747)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:615)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1627)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:750)
Caused by: com.sonicle.webtop.core.dal.DAOException: JOOQ
	at org.jooq_3.14.15.POSTGRES.debug(Unknown Source)
	at com.sonicle.webtop.core.dal.BaseDAO$DAOExecuteListener.exception(BaseDAO.java:161)
	at org.jooq.impl.ExecuteListeners.exception(ExecuteListeners.java:274)
	at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:390)
	at org.jooq.impl.AbstractDelegatingQuery.execute(AbstractDelegatingQuery.java:119)
	at com.sonicle.webtop.core.dal.AuditLogDAO.insertAccess(AuditLogDAO.java:173)
	at com.sonicle.webtop.core.app.AuditLogManager.internalWriteSync(AuditLogManager.java:452)
	... 62 common frames omitted
Caused by: org.jooq.exception.DataAccessException: SQL [insert into "core"."access_log" ("timestamp", "domain_id", "user_id", "software_name", "session_id", "service_id", "context", "action", "reference_id", "data") values (cast(? as timestamp(6) with time zone), ?, ?, ?, ?, ?, ?, ?, ?, ?)]; ERROR: relation "core.access_log" does not exist
  Position: 13
	at org.jooq_3.14.15.POSTGRES.debug(Unknown Source)
	at org.jooq.impl.Tools.translate(Tools.java:2903)
	at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:757)
	at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:389)
	... 65 common frames omitted
Caused by: org.postgresql.util.PSQLException: ERROR: relation "core.access_log" does not exist
  Position: 13
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:355)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:490)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:408)
	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:166)
	at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:155)
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
	at org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:214)
	at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:458)
	at org.jooq.impl.AbstractDMLQuery.execute(AbstractDMLQuery.java:953)
	at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:375)
	... 65 common frames omitted

LayLow · March 26, 2023, 5:08am

[hint]
I am not able to help, but I am sure others would like to know exactly what got updated how and to what versions.

sgb77 · March 26, 2023, 3:22pm

Hi,
I just ran the software updates in the management console to Nethserver 7.9.2009

Any help is greatly appreciated.

federico.ballarini · March 27, 2023, 5:27pm

It seems something went wrong during one of last updates. Please login into webtop as admin and check if under “DB update” all rows are ok or there are some errors.

federico.ballarini · March 27, 2023, 6:41pm

You should have something like this:

sgb77 · March 28, 2023, 3:09pm

Hi,
Record 15 is the only one with a warning, everything else has an OK status

federico.ballarini · March 28, 2023, 3:32pm

Hi @sgb77
Please check if access_log table exists:

Access Webtop DB via SSH:

su - postgres -c 'psql webtop5'

Launch this query:

select count(*) from core.access_log;

You should have an output similar to this. Please post here your output:

webtop5=# select count(*) from core.access_log;
 count
-------
 15564
(1 row)

Thank you

sgb77 · March 28, 2023, 8:26pm

Hi @federico.ballarini

federico.ballarini · March 29, 2023, 9:08am

It seems something went wrong during the access_log table update… I don’t know if we can restore this situation easily.

Please check this:

Access webtop db: su - postgres -c 'psql webtop5'

Launch this query and give me the result:

SELECT count(*) FROM core.audit_log WHERE service_id = 'com.sonicle.webtop.core' AND context = 'AUTH';

Based on this result we can try to restore the situation.

sgb77 · March 29, 2023, 12:29pm

webtop5=# SELECT count(*) FROM core.audit_log WHERE service_id = 'com.sonicle.webtop.core' AND context = 'AUTH';
 count
-------
    98
(1 row)

sgb77 · March 31, 2023, 2:11am

just trying to get attention.

federico.ballarini · March 31, 2023, 8:15am

Hi @sgb77 I will answer you asap

sgb77 · March 31, 2023, 3:34pm

Thank you sir! I appreciate the help.

federico.ballarini · March 31, 2023, 6:05pm

Hi @sgb77
It seems your server skipped one db update. You shoul execute these queries and we can see if it works.

Check if you have updates in software center before proceed.
BEFORE PROCEED PLEASE MAKE A BACKUP

ALTER TABLE "core"."audit_log_bck" RENAME TO "audit_log_bck.old";
DROP INDEX IF EXISTS "core"."audit_log_ak1";
DROP INDEX IF EXISTS "core"."audit_log_ak2";
ALTER TABLE "core"."audit_log" RENAME TO "audit_log.old";
ALTER SEQUENCE "core"."seq_audit_log" RENAME TO "seq_audit_log.old";

-- ----------------------------
-- Table audit_log
-- ----------------------------

CREATE SEQUENCE "core"."seq_audit_log";
CREATE TABLE "core"."audit_log" (
"audit_log_id" int8 NOT NULL DEFAULT nextval('"core".seq_audit_log'::regclass),
"timestamp" timestamptz NOT NULL,
"domain_id" varchar(20) NOT NULL,
"user_id" varchar(100) NOT NULL,
"software_name" varchar(255),
"session_id" varchar(255),
"service_id" varchar(255) NOT NULL,
"context" varchar(50) NOT NULL,
"action" varchar(50) NOT NULL,
"reference_id" varchar(255),
"data" varchar(10000)
);

ALTER TABLE "core"."audit_log" ADD PRIMARY KEY ("audit_log_id");
CREATE INDEX "audit_log_ak1" ON "core"."audit_log" ("domain_id", "service_id", "context", "action", "reference_id");

CREATE INDEX "audit_log_ak2" ON "core"."audit_log" ("domain_id", "service_id", "context", "reference_id");

-- ----------------------------
-- Table access_log
-- ----------------------------

DROP SEQUENCE IF EXISTS "core"."seq_access_log";
CREATE SEQUENCE "core"."seq_access_log";
CREATE TABLE "core"."access_log" (
"access_log_id" int8 NOT NULL DEFAULT nextval('"core".seq_access_log'::regclass),
"timestamp" timestamptz NOT NULL,
"domain_id" varchar(20) NOT NULL,
"user_id" varchar(100) NOT NULL,
"software_name" varchar(255),
"session_id" varchar(255),
"service_id" varchar(255) NOT NULL,
"context" varchar(50) NOT NULL,
"action" varchar(50) NOT NULL,
"reference_id" varchar(255),
"data" varchar(10000)
);

ALTER TABLE "core"."access_log" ADD PRIMARY KEY ("access_log_id");
CREATE INDEX "access_log_ak1" ON "core"."access_log" ("domain_id", "user_id", "software_name", "session_id", "service_id", "context", "action");
CREATE INDEX "access_log_ak2" ON "core"."access_log" ("domain_id", "service_id", "context", "timestamp");

-- ----------------------------
-- Copy data into audit_log
-- ----------------------------

INSERT INTO "core"."audit_log" ("timestamp", "domain_id", "user_id", "session_id", "service_id", "context", "action", "reference_id", "data")
SELECT "timestamp", "domain_id", "user_id", "session_id", "service_id", "context", "action", "reference_id", "data"
FROM "core"."audit_log.old"
WHERE "service_id" <> 'com.sonicle.webtop.core' OR "context" <> 'AUTH'
ORDER BY "audit_log_id" ASC;

-- ----------------------------
-- Copy data into access_log
-- ----------------------------

INSERT INTO "core"."access_log" ("timestamp", "domain_id", "user_id", "session_id", "service_id", "context", "action", "reference_id", "data")
SELECT "timestamp", "domain_id", "user_id", "session_id", "service_id", "context", "action", "reference_id", "data"
FROM "core"."audit_log.old"
WHERE "service_id" = 'com.sonicle.webtop.core' AND "context" = 'AUTH'
ORDER BY "audit_log_id" ASC;

-- ----------------------------
-- Clear OLD audit_log
-- ----------------------------

DROP VIEW IF EXISTS "core"."vw_auth_details";
DROP VIEW IF EXISTS "core"."vw_access_log";
DROP TABLE IF EXISTS "core"."audit_log.old";

-- ----------------------------
-- Clear deprecated settings
-- ----------------------------

DELETE FROM "core"."settings" WHERE "key" = 'audit.enabled';
DELETE FROM "core"."domain_settings" WHERE "key" = 'audit.enabled';

Try and report here every output of these queries.
Thank you.

sgb77 · April 3, 2023, 8:02pm

Hi @federico.ballarini,
The sql scripts seem to ran without error, below the results. I am however still getting the DB error popup, I will paste the errors on a separate message because of character limit.

Thanks for all your help!

webtop5-# \dt core.*
                List of relations
 Schema |         Name         | Type  |  Owner
--------+----------------------+-------+----------
 core   | activities           | table | postgres
 core   | audit_known_devices  | table | sonicle
 core   | audit_log            | table | sonicle
 core   | audit_log_bck        | table | sonicle
 core   | autosave             | table | postgres
 core   | causals              | table | postgres
 core   | custom_fields        | table | sonicle
 core   | custom_panels        | table | sonicle
 core   | custom_panels_fields | table | sonicle
 core   | custom_panels_tags   | table | sonicle
 core   | domain_settings      | table | postgres
 core   | domains              | table | postgres
 core   | file_types           | table | postgres
 core   | im_chats             | table | postgres
 core   | im_messages          | table | postgres
 core   | ip_geo_cache         | table | sonicle
 core   | languages            | table | postgres
 core   | licenses             | table | sonicle
 core   | licenses_leases      | table | sonicle
 core   | local_vault          | table | postgres
 core   | master_data          | table | postgres
 core   | media_types          | table | postgres
 core   | messages_queue       | table | postgres
 core   | roles                | table | postgres
 core   | roles_associations   | table | postgres
 core   | roles_permissions    | table | postgres
 core   | servicestore_entries | table | postgres
 core   | settings             | table | postgres
 core   | settings_db          | table | postgres
 core   | shares               | table | postgres
 core   | shares_data          | table | postgres
 core   | snoozed_reminders    | table | postgres
 core   | syslog               | table | postgres
 core   | tags                 | table | sonicle
 core   | upgrade_statements   | table | postgres
 core   | user_settings        | table | postgres
 core   | users                | table | postgres
 core   | users_associations   | table | postgres
 core   | users_info           | table | postgres
(39 rows)


webtop5=# SET search_path TO core;
SET
webtop5=# ALTER TABLE "core"."audit_log_bck" RENAME TO "audit_log_bck.old";
ALTER TABLE
webtop5=# DROP INDEX IF EXISTS "core"."audit_log_ak1";
P INDEX IF EXISTS "core"."audit_log_ak2";
ALTER TABLE "core"."audit_log" RENAME TO "audit_log.old";
ALTER SEQUENCE "core"."seq_audit_log" RENAME TO "seq_audit_lDROP INDEX
webtop5=# DROP INDEX IF EXISTS "core"."audit_log_ak2";
NOTICE:  index "audit_log_ak2" does not exist, skipping
DROP INDEX
webtop5=# ALTER TABLE "core"."audit_log" RENAME TO "audit_log.old";
og.old";
ALTER TABLE
webtop5=# ALTER SEQUENCE "core"."seq_audit_log" RENAME TO "seq_audit_log.old";
ALTER SEQUENCE
webtop5=# CREATE SEQUENCE "core"."seq_audit_log";
ABLE "core"."audit_log" (
"audit_log_id" int8 NOT NULL DEFAULT nextval('"core".seq_audit_log'::regclass),
"timestamp" timestamptz NOT NULL,
"domain_id" varchar(CREATE SEQUENCE
webtop5=# CREATE TABLE "core"."audit_log" (
webtop5(# "audit_log_id" int8 NOT NULL DEFAULT nextval('"core".seq_audit_log'::regclass),
webtop5(# "timestamp" timestamptz NOT NULL,
webtop5(# "domain_id" varchar(20) NOT NULL,
webtop5(# "user_id" varchar(100) NOT NULL,
webtop5(# "software_name" varchar(255),
webtop5(# "session_id" varchar(255),
webtop5(# "service_id" varchar(255) NOT NULL,
webtop5(# "context" varchar(50) NOT NULL,
webtop5(# "action" varchar(50) NOT NULL,
webtop5(# "reference_id" varchar(255),
webtop5(# "data" varchar(10000)
webtop5(# );
ore"."audit_log" ADD PRIMARY KEY ("audit_log_id");
CREATE INDEX "audit_log_ak1" ON "core"."audit_log" ("domain_id", "service_id", "context", "action", "reference_id");

CREATE INDEX "audit_logCREATE TABLE
webtop5=#
webtop5=# ALTER TABLE "core"."audit_log" ADD PRIMARY KEY ("audit_log_id");
NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "audit_log_pkey1" for table "audit_log"
_ak2" ON "core"."audit_log" ("domain_id", "service_id", "context", "reference_id");
ALTER TABLE
webtop5=# CREATE INDEX "audit_log_ak1" ON "core"."audit_log" ("domain_id", "service_id", "context", "action", "reference_id");
CREATE INDEX
webtop5=#
webtop5=# CREATE INDEX "audit_log_ak2" ON "core"."audit_log" ("domain_id", "service_id", "context", "reference_id");
CREATE INDEX
webtop5=# DROP SEQUENCE IF EXISTS "core"."seq_access_log";
NOTICE:  sequence "seq_access_log" does not exist, skipping
DROP SEQUENCE
webtop5=# CREATE SEQUENCE "core"."seq_access_log";
 TABLE "core"."access_log" (
"access_log_id" int8 NOT NULL DEFAULT nextval('"core".seq_access_log'::regclass),
"timestamp" timestamptz NOT NULL,
"domain_id" varCREATE SEQUENCE
webtop5=# CREATE TABLE "core"."access_log" (
webtop5(# "access_log_id" int8 NOT NULL DEFAULT nextval('"core".seq_access_log'::regclass),
webtop5(# "timestamp" timestamptz NOT NULL,
webtop5(# "domain_id" varchar(20) NOT NULL,
webtop5(# "user_id" varchar(100) NOT NULL,
webtop5(# "software_name" varchar(255),
webtop5(# "session_id" varchar(255),
webtop5(# "service_id" varchar(255) NOT NULL,
webtop5(# "context" varchar(50) NOT NULL,
webtop5(# "action" varchar(50) NOT NULL,
webtop5(# "reference_id" varchar(255),
webtop5(# "data" varchar(10000)
webtop5(# );
LE "core"."access_log" ADD PRIMARY KEY ("access_log_id");
CREATE INDEX "access_log_ak1" ON "core"."access_log" ("domain_id", "user_id", "software_name", "session_id", "service_id", "context", "action");
CREATE INDEX "access_log_ak2" ON "core"."access_log" ("domain_id", "sCREATE TABLE
webtop5=#
webtop5=# ALTER TABLE "core"."access_log" ADD PRIMARY KEY ("access_log_id");
NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "access_log_pkey" for table "access_log"
ervice_id", "context", "timestamp");
ALTER TABLE
webtop5=# CREATE INDEX "access_log_ak1" ON "core"."access_log" ("domain_id", "user_id", "software_name", "session_id", "service_id", "context", "action");
CREATE INDEX
webtop5=# CREATE INDEX "access_log_ak2" ON "core"."access_log" ("domain_id", "service_id", "context", "timestamp");
CREATE INDEX
webtop5=# INSERT INTO "core"."audit_log" ("timestamp", "domain_id", "user_id", "session_id", "service_id", "context", "action", "reference_id", "data")
webtop5-# SELECT "timestamp", "domain_id", "user_id", "session_id", "service_id", "context", "action", "reference_id", "data"
webtop5-# FROM "core"."audit_log.old"
webtop5-# WHERE "service_id" <> 'com.sonicle.webtop.core' OR "context" <> 'AUTH'
webtop5-# ORDER BY "audit_log_id" ASC;
INSERT 0 0
webtop5=# INSERT INTO "core"."audit_log" ("timestamp", "domain_id", "user_id", "session_id", "service_id", "context", "action", "reference_id", "data") SELECT "timestamp", "domain_id", "user_id", "session_id", "service_id", "context", "a ction", "reference_id", "data" FROM "core"."audit_log.old" WHERE "service_id" <> 'com.sonicle.webtop.core' OR "context" <> 'AUTH' ORDER BY "audit_log_id" ASC;
INSERT 0 0
webtop5=# INSERT INTO "core"."access_log" ("timestamp", "domain_id", "user_id", "session_id", "service_id", "context", "action", "reference_id", "data")
webtop5-# SELECT "timestamp", "domain_id", "user_id", "session_id", "service_id", "context", "action", "reference_id", "data"
webtop5-# FROM "core"."audit_log.old"
webtop5-# WHERE "service_id" = 'com.sonicle.webtop.core' AND "context" = 'AUTH'
webtop5-# ORDER BY "audit_log_id" ASC;
INSERT 0 98
webtop5=# DROP VIEW IF EXISTS "core"."vw_auth_details";
OP VIEW IF EXISTS "core"."vw_access_log";
DROP TABLE IF EXISTS "core"."audit_log.old";DROP VIEW
webtop5=# DROP VIEW IF EXISTS "core"."vw_access_log";
DROP VIEW
webtop5=# DROP TABLE IF EXISTS "core"."audit_log.old";
DROP TABLE
webtop5=# DELETE FROM "core"."settings" WHERE "key" = 'audit.enabled';
DELETE 0
webtop5=# DELETE FROM "core"."domain_settings" WHERE "key" = 'audit.enabled';
DELETE 0

sgb77 · April 3, 2023, 8:02pm

Errors from the admin console, looks like they are different tables than the original, so I think we’re making progress.

FROM ERROR LOG:

er(ApplicationFilterChain.java:166)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at com.sonicle.webtop.core.app.shiro.filter.GZip.doFilterInternal(GZip.java:60)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:450)
	at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
	at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
	at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
	at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
	at com.sonicle.webtop.core.app.shiro.WTShiroFilter.doFilterInternal(WTShiroFilter.java:89)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:747)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:615)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1627)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:750)
Caused by: com.sonicle.webtop.core.dal.DAOException: JOOQ
	at org.jooq_3.14.15.POSTGRES.debug(Unknown Source)
	at com.sonicle.webtop.core.dal.BaseDAO$DAOExecuteListener.exception(BaseDAO.java:161)
	at org.jooq.impl.ExecuteListeners.exception(ExecuteListeners.java:274)
	at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:390)
	at org.jooq.impl.AbstractResultQuery.fetch(AbstractResultQuery.java:337)
	at org.jooq.impl.AbstractResultQuery.fetchInto(AbstractResultQuery.java:1522)
	at org.jooq.impl.SelectImpl.fetchInto(SelectImpl.java:3936)
	at com.sonicle.webtop.tasks.dal.TaskDAO.viewOnlineByCategoryRangeCondition(TaskDAO.java:677)
	at com.sonicle.webtop.tasks.TasksManager.listTaskInstances(TasksManager.java:989)
	... 65 common frames omitted
Caused by: org.jooq.exception.DataAccessException: SQL [select "tasks"."tasks"."task_id", "tasks"."tasks"."series_task_id", "tasks"."tasks"."series_instance_id", "tasks"."tasks"."category_id", "tasks"."tasks"."parent_task_id", "tasks"."tasks"."revision_status", "tasks"."tasks"."revision_timestamp", "tasks"."tasks"."creation_timestamp", "tasks"."tasks"."organizer", "tasks"."tasks"."organizer_id", "tasks"."tasks"."public_uid", "tasks"."tasks"."subject", "tasks"."tasks"."description", "tasks"."tasks"."description_type", "tasks"."tasks"."timezone", "tasks"."tasks"."start", "tasks"."tasks"."due", "tasks"."tasks"."completed_on", "tasks"."tasks"."progress", "tasks"."tasks"."status", "tasks"."tasks"."importance", "tasks"."tasks"."is_private", "tasks"."tasks"."document_ref", "tasks"."tasks"."reminder", case when "tasks"."tasks_recurrences"."task_id" is not null then ? else ? end as "has_recurrence", (exists (select 1 as "one" from "tasks"."tasks" as "ta1" where "ta1"."parent_task_id" = "tasks"."tasks"."task_id")) as "has_children", (select string_agg("tasks"."tasks_tags"."tag_id", '|') from "tasks"."tasks_tags" where "tasks"."tasks_tags"."task_id" = "tasks"."tasks"."task_id") as "tags", "tasks"."categories"."name" as "category_name", "tasks"."categories"."domain_id" as "category_domain_id", "tasks"."categories"."user_id" as "category_user_id" from "tasks"."tasks" join "tasks"."categories" on "tasks"."tasks"."category_id" = "tasks"."categories"."category_id" left outer join "tasks"."tasks_recurrences" on "tasks"."tasks"."task_id" = "tasks"."tasks_recurrences"."task_id" left outer join "tasks"."tasks" as "pta1" on "tasks"."tasks"."parent_task_id" = "pta1"."task_id" where (false and ("tasks"."tasks"."revision_status" = ? or "tasks"."tasks"."revision_status" = ?) and ("tasks"."tasks"."start" is null or "public"."rrule_event_overlaps"("tasks"."tasks"."start", cast(? as timestamp(6) with time zone), "tasks"."tasks_recurrences"."rule", cast(? as timestamp(6) with time zone), cast(? as timestamp(6) with time zone))) and "tasks"."tasks"."due" is not null and "tasks"."tasks"."status" not in (?, ?)) order by coalesce("pta1"."task_id", "tasks"."tasks"."task_id"), ("pta1"."task_id" is not null), "tasks"."tasks"."task_id"]; ERROR: relation "tasks.tasks_recurrences" does not exist
  Position: 1436
	at org.jooq_3.14.15.POSTGRES.debug(Unknown Source)
	at org.jooq.impl.Tools.translate(Tools.java:2903)
	at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:757)
	at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:389)
	... 70 common frames omitted
Caused by: org.postgresql.util.PSQLException: ERROR: relation "tasks.tasks_recurrences" does not exist
  Position: 1436
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:355)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:490)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:408)
	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:166)
	at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:155)
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
	at org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:214)
	at org.jooq.impl.Tools.executeStatementAndGetFirstResultSet(Tools.java:4217)
	at org.jooq.impl.AbstractResultQuery.execute(AbstractResultQuery.java:283)
	at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:375)
	... 70 common frames omitted
2023-04-03 15:50:55 [ERROR] com.sonicle.webtop.tasks.Service - Error in PortletTask
com.sonicle.webtop.core.sdk.WTException: DB error
	at com.sonicle.webtop.core.app.util.ExceptionUtils.wrapThrowable(ExceptionUtils.java:53)
	at com.sonicle.webtop.tasks.TasksManager.listTaskInstances(TasksManager.java:1101)
	at com.sonicle.webtop.tasks.TasksManager.listTaskInstances(TasksManager.java:916)
	at com.sonicle.webtop.tasks.Service.processPortletTasks(Service.java:1145)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.sonicle.webtop.core.app.servlet.BaseRequest.invokeMethod(BaseRequest.java:109)
	at com.sonicle.webtop.core.app.servlet.PrivateRequest.processRequest(PrivateRequest.java:86)
	at com.sonicle.webtop.core.app.servlet.PrivateRequest.doGet(PrivateRequest.java:113)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at com.sonicle.webtop.core.app.shiro.filter.GZip.doFilterInternal(GZip.java:60)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:450)
	at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
	at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
	at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
	at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
	at com.sonicle.webtop.core.app.shiro.WTShiroFilter.doFilterInternal(WTShiroFilter.java:89)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:747)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:615)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1627)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:750)
Caused by: com.sonicle.webtop.core.dal.DAOException: JOOQ
	at org.jooq_3.14.15.POSTGRES.debug(Unknown Source)
	at com.sonicle.webtop.core.dal.BaseDAO$DAOExecuteListener.exception(BaseDAO.java:161)
	at org.jooq.impl.ExecuteListeners.exception(ExecuteListeners.java:274)
	at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:390)
	at org.jooq.impl.AbstractResultQuery.fetch(AbstractResultQuery.java:337)
	at org.jooq.impl.AbstractResultQuery.fetchInto(AbstractResultQuery.java:1522)
	at org.jooq.impl.SelectImpl.fetchInto(SelectImpl.java:3936)
	at com.sonicle.webtop.tasks.dal.TaskDAO.viewOnlineByCategoryRangeCondition(TaskDAO.java:677)
	at com.sonicle.webtop.tasks.TasksManager.listTaskInstances(TasksManager.java:989)
	... 65 common frames omitted
Caused by: org.jooq.exception.DataAccessException: SQL [select "tasks"."tasks"."task_id", "tasks"."tasks"."series_task_id", "tasks"."tasks"."series_instance_id", "tasks"."tasks"."category_id", "tasks"."tasks"."parent_task_id", "tasks"."tasks"."revision_status", "tasks"."tasks"."revision_timestamp", "tasks"."tasks"."creation_timestamp", "tasks"."tasks"."organizer", "tasks"."tasks"."organizer_id", "tasks"."tasks"."public_uid", "tasks"."tasks"."subject", "tasks"."tasks"."description", "tasks"."tasks"."description_type", "tasks"."tasks"."timezone", "tasks"."tasks"."start", "tasks"."tasks"."due", "tasks"."tasks"."completed_on", "tasks"."tasks"."progress", "tasks"."tasks"."status", "tasks"."tasks"."importance", "tasks"."tasks"."is_private", "tasks"."tasks"."document_ref", "tasks"."tasks"."reminder", case when "tasks"."tasks_recurrences"."task_id" is not null then ? else ? end as "has_recurrence", (exists (select 1 as "one" from "tasks"."tasks" as "ta1" where "ta1"."parent_task_id" = "tasks"."tasks"."task_id")) as "has_children", (select string_agg("tasks"."tasks_tags"."tag_id", '|') from "tasks"."tasks_tags" where "tasks"."tasks_tags"."task_id" = "tasks"."tasks"."task_id") as "tags", "tasks"."categories"."name" as "category_name", "tasks"."categories"."domain_id" as "category_domain_id", "tasks"."categories"."user_id" as "category_user_id" from "tasks"."tasks" join "tasks"."categories" on "tasks"."tasks"."category_id" = "tasks"."categories"."category_id" left outer join "tasks"."tasks_recurrences" on "tasks"."tasks"."task_id" = "tasks"."tasks_recurrences"."task_id" left outer join "tasks"."tasks" as "pta1" on "tasks"."tasks"."parent_task_id" = "pta1"."task_id" where (false and ("tasks"."tasks"."revision_status" = ? or "tasks"."tasks"."revision_status" = ?) and ("tasks"."tasks"."start" is null or "public"."rrule_event_overlaps"("tasks"."tasks"."start", cast(? as timestamp(6) with time zone), "tasks"."tasks_recurrences"."rule", cast(? as timestamp(6) with time zone), cast(? as timestamp(6) with time zone))) and "tasks"."tasks"."due" is not null and "tasks"."tasks"."status" not in (?, ?)) order by coalesce("pta1"."task_id", "tasks"."tasks"."task_id"), ("pta1"."task_id" is not null), "tasks"."tasks"."task_id"]; ERROR: relation "tasks.tasks_recurrences" does not exist
  Position: 1436
	at org.jooq_3.14.15.POSTGRES.debug(Unknown Source)
	at org.jooq.impl.Tools.translate(Tools.java:2903)
	at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:757)
	at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:389)
	... 70 common frames omitted
Caused by: org.postgresql.util.PSQLException: ERROR: relation "tasks.tasks_recurrences" does not exist
  Position: 1436
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:355)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:490)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:408)
	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:166)
	at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:155)
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
	at org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:214)
	at org.jooq.impl.Tools.executeStatementAndGetFirstResultSet(Tools.java:4217)
	at org.jooq.impl.AbstractResultQuery.execute(AbstractResultQuery.java:283)
	at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:375)
	... 70 common frames omitted
2023-04-03 15:51:04 [ERROR] c.s.webtop.core.app.ServiceManager - [com.sonicle.webtop.tasks] PrivateService: cleanup() throws errors [com.sonicle.webtop.tasks.Service]
java.lang.NullPointerException: null
	at com.sonicle.webtop.tasks.Service.cleanup(Service.java:172)
	at com.sonicle.webtop.core.app.ServiceManager.privateServiceCallCleanup(ServiceManager.java:951)
	at com.sonicle.webtop.core.app.WebTopSession.emptyPrivateServices(WebTopSession.java:727)
	at com.sonicle.webtop.core.app.WebTopSession.cleanup(WebTopSession.java:138)
	at com.sonicle.webtop.core.app.SessionManager.onContainerSessionDestroyed(SessionManager.java:166)
	at com.sonicle.webtop.core.app.shiro.WTContainerSessionListener.sessionDestroyed(WTContainerSessionListener.java:69)
	at org.apache.catalina.session.StandardSession.expire(StandardSession.java:807)
	at org.apache.catalina.session.StandardSession.expire(StandardSession.java:749)
	at org.apache.catalina.session.StandardSession.invalidate(StandardSession.java:1229)
	at org.apache.catalina.session.StandardSessionFacade.invalidate(StandardSessionFacade.java:170)
	at org.apache.shiro.web.session.HttpServletSession.stop(HttpServletSession.java:113)
	at org.apache.shiro.session.ProxiedSession.stop(ProxiedSession.java:107)
	at org.apache.shiro.subject.support.DelegatingSubject$StoppingAwareProxiedSession.stop(DelegatingSubject.java:423)
	at org.apache.shiro.mgt.DefaultSecurityManager.stopSession(DefaultSecurityManager.java:590)
	at org.apache.shiro.mgt.DefaultSecurityManager.logout(DefaultSecurityManager.java:576)
	at org.apache.shiro.subject.support.DelegatingSubject.logout(DelegatingSubject.java:367)
	at com.sonicle.webtop.core.app.servlet.Logout.processRequest(Logout.java:67)
	at com.sonicle.webtop.core.app.AbstractServlet.doGet(AbstractServlet.java:75)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at com.sonicle.webtop.core.app.shiro.filter.GZip.doFilterInternal(GZip.java:60)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:450)
	at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
	at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
	at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
	at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
	at com.sonicle.webtop.core.app.shiro.WTShiroFilter.doFilterInternal(WTShiroFilter.java:89)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:747)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:615)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1627)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:750)

federico.ballarini · April 5, 2023, 12:50pm

Hi @sgb77, it seems you have lot of errors on DB… surely something went wrong during one of the last update. I need to ask @lucag how it’s better to proceed.

sgb77 · April 19, 2023, 2:03pm

Hi @federico.ballarini and @lucag

Do you think there’s a fix for this, or just too many errors to be worth recovery?