Left Nav Errors

Post your Server Bug Report

Left Nav Errors

Unread postby pcsteve » 16 Nov 2014, 14:25

After rebooting my 2012R2 box post MS updates I logged back into Madsonic and am now getting the following errors. It had been working fine prior to reboot. I have restarted the service logged in as admin but still the same errors. See attached error text and log file
Attachments
madsonic.log
Log file
(23.92 KiB) Downloaded 65 times
Error.txt
errors from left Nav
(11.61 KiB) Downloaded 63 times
pcsteve
 
Posts: 2
Joined: 23 Feb 2014, 13:26
Has thanked: 0 time
Been thanked: 1 time

Re: Left Nav Errors

Unread postby Magica » 16 Nov 2014, 17:17

Hi,

I get also left nav errors. One was caused by removing one folder in music folders.
I did some tests and I manage to focus the problem to Access rights.

None of my users are not in ALL-group so i disabled the Access rights on this group. Then left nav error start.
I enabled Access rights to group ALL Madsonic starts working normally.

I thing there is something wrong in Groups handling because you can´t name them differently from default naming or the groups cannot be deleted.
Deleting gives this error:

Code: Select all
Madsonic encountered an internal error. You can report this error in the Madsonic Forum. Please include the information below.

Exception   org.springframework.dao.DataIntegrityViolationException
Message   PreparedStatementCallback; SQL [delete from user_group where id=?]; integrity constraint violation: foreign key no action; FK_GROUP_ID table: USER; nested exception is java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: foreign key no action; FK_GROUP_ID table: USER
Java version   Oracle Corporation 1.8.0_25
Operating system   Windows 7 6.1
Server   Apache Tomcat/8.0.14
Memory   Used 632 of 742 MB
Stack trace   org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [delete from user_group where id=?]; integrity constraint violation: foreign key no action; FK_GROUP_ID table: USER; nested exception is java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: foreign key no action; FK_GROUP_ID table: USER
   at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:86)
   at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
   at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
   at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
   at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:818)
   at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:874)
   at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:882)
   at org.madsonic.dao.AbstractDao.update(AbstractDao.java:71)
   at org.madsonic.dao.GroupDao.deleteGroup(GroupDao.java:70)
   at org.madsonic.service.SecurityService.deleteGroup(SecurityService.java:259)
   at org.madsonic.controller.GroupSettingsController.handleParameters(GroupSettingsController.java:87)
   at org.madsonic.controller.GroupSettingsController.handleRequestInternal(GroupSettingsController.java:47)
   at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
   at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
   at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:919)
   at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:851)
   at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:953)
   at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:855)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:644)
   at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:829)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
   at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
   at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
   at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
   at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
   at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
   at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:146)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
   at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
   at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
   at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
   at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
   at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
   at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
   at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)
   at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
   at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
   at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
   at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
   at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)
   at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.madsonic.filter.RequestEncodingFilter.doFilter(RequestEncodingFilter.java:49)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.madsonic.filter.ParameterDecodingFilter.doFilter(ParameterDecodingFilter.java:60)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.madsonic.filter.BootstrapVerificationFilter.doFilter(BootstrapVerificationFilter.java:54)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
   at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:537)
   at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1081)
   at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:658)
   at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:222)
   at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1566)
   at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1523)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
   at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
   at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: foreign key no action; FK_GROUP_ID table: USER
   at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
   at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
   at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)
   at org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(Unknown Source)
   at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:824)
   at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:818)
   at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:589)
   ... 83 more
Caused by: org.hsqldb.HsqlException: integrity constraint violation: foreign key no action; FK_GROUP_ID table: USER
   at org.hsqldb.error.Error.error(Unknown Source)
   at org.hsqldb.StatementDML.performReferentialActions(Unknown Source)
   at org.hsqldb.StatementDML.delete(Unknown Source)
   at org.hsqldb.StatementDML.executeDeleteStatement(Unknown Source)
   at org.hsqldb.StatementDML.getResult(Unknown Source)
   at org.hsqldb.StatementDMQL.execute(Unknown Source)
   at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
   at org.hsqldb.Session.execute(Unknown Source)
   ... 88 more


I´m running version:
MADSONIC 5.2.5250.20141025.1033
Apache Tomcat/8.0.14, java 1.8.0_25, Windows 7

Br
-m-
Magica
 
Posts: 19
Joined: 11 Jan 2013, 14:39
Has thanked: 6 times
Been thanked: 13 times


Return to Bug Reports 5.x

Who is online

Users browsing this forum: No registered users and 1 guest