java.sql.SQLException: Invalid argument value, message from server: "Duplicate entry '0' for key 1"

Atlassian JIRA | Ross Mason | 1 decade ago
  1. 0

    The 'sign up' link on the conflu title bar used to be hidden if external user management was being used. If a user tries to sign up you get - bucket.core.InfrastructureException: com.opensymphony.user.ImmutableException: No provider successfully created entity test@test.com at bucket.user.DefaultUserAccessor.addUser(DefaultUserAccessor.java:48) at com.atlassian.confluence.user.DefaultUserAccessor.addUser(DefaultUserAccessor.java:90) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:61) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:116) at com.atlassian.confluence.util.profiling.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:16) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:152) at $Proxy8.addUser(Unknown Source) at com.atlassian.confluence.user.actions.SignupAction.execute(SignupAction.java:49) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:33) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:16) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:40) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:73) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.core.ConfluenceAutowireInterceptor.intercept(ConfluenceAutowireInterceptor.java:25) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.user.actions.AuthenticatedUserInterceptor.intercept(AuthenticatedUserInterceptor.java:51) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.util.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:133) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:115) at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:229) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:199) at javax.servlet.http.HttpServlet.service(HttpServlet.java:103) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:159) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:168) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:170) at bucket.custom.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:30) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:73) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.confluence.util.error.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:26) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:36) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135) at com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:346) at com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:274) at com.caucho.server.TcpConnection.run(TcpConnection.java:139) at java.lang.Thread.run(Thread.java:534) Caused by: com.opensymphony.user.ImmutableException: No provider successfully created entity test@test.com at com.opensymphony.user.UserManager.createEntity(UserManager.java:376) at com.opensymphony.user.UserManager.createUser(UserManager.java:242) at bucket.user.DefaultUserAccessor.addUser(DefaultUserAccessor.java:21) ... 76 more Referer URL: http://wiki.muleumo.org/signup.action Build Information: Uptime: 1 day, 13 hours, 11 minutes, 50 seconds Version: 1.3 Build Number: 112 Server Information: Application Server: Resin/2.1.12 Servlet Version: 2.3 Database Dialect: N/A Memory Information: Total Memory: 99 MB Free Memory: 29 MB Used Memory: 70 MB System Information: System Date: Sunday, 12 Dec 2004 System Time: 19:52:58 System Favourite Colour: Lime Java Version: 1.4.2_03 Java Vendor: Sun Microsystems Inc. JVM Version: 1.0 JVM Vendor: Sun Microsystems Inc. JVM Implementation Version: 1.4.2_03-b02 Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition Java VM: Java HotSpot(TM) Client VM User Name: root User Timezone: America/New_York Operating System: Linux 2.4.26-1um OS Architecture: i386 Request Information: URL: http://wiki.muleumo.org/500page.jsp - Scheme: http - Server: wiki.muleumo.org - Port: 80 - URI: /500page.jsp - - Context Path: - - Servlet Path: /500page.jsp - - Path Info: null - - Query String: null Attributes: - __sitemesh__filterapplied : true - javax.servlet.error.request_uri : /dosignup.action - sessioninview.FILTERED : true - loginfilter.already.filtered : true - javax.servlet.error.message : com.opensymphony.user.ImmutableException: No provider successfully created entity test@test.com - javax.servlet.error.status_code : 500 - webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@b3149d - javax.servlet.error.servlet_name : action - os_securityfilter_already_filtered : true - com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true - atlassian.core.seraph.original.url : /dosignup.action - javax.servlet.error.exception : bucket.core.InfrastructureException: com.opensymphony.user.ImmutableException: No provider successfully created entity test@test.com - javax.servlet.jsp.jspException : bucket.core.InfrastructureException: com.opensymphony.user.ImmutableException: No provider successfully created entity test@test.com Parameters: - password = test - checkboxUsername = on - username = test@test.com - confirm = test - email = test@test.com - fullname = test Logging: 3 log statements generated by this request: [WARN] Sun Dec 12 19:52:58 EST 2004 [com.opensymphony.user.provider.jdbc.JDBCCredentialsProvider] User [test@test.com] must already exist Throwable: java.sql.SQLException: Invalid argument value, message from server: "Duplicate entry '0' for key 1" at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1905) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1109) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1203) at com.mysql.jdbc.Connection.execSQL(Connection.java:2090) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1680) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1527) at com.opensymphony.user.provider.jdbc.JDBCCredentialsProvider.create(JDBCCredentialsProvider.java:98) at bucket.user.providers.ChainedUserProvider.create(ChainedUserProvider.java:115) at bucket.user.providers.CachingCredentialsProvider.create(CachingCredentialsProvider.java:62) at com.opensymphony.user.UserManager.createEntity(UserManager.java:370) at com.opensymphony.user.UserManager.createUser(UserManager.java:242) at bucket.user.DefaultUserAccessor.addUser(DefaultUserAccessor.java:21) at com.atlassian.confluence.user.DefaultUserAccessor.addUser(DefaultUserAccessor.java:90) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:61) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149) [ERROR] Sun Dec 12 19:52:58 EST 2004 [com.atlassian.confluence.util.XWorkTransactionInterceptor] Invoking rollback for transaction on action '/dosignup.action (SignupAction.execute())' due to throwable: bucket.core.InfrastructureException: com.opensymphony.user.ImmutableException: No provider successfully created entity test@test.com Throwable: bucket.core.InfrastructureException: com.opensymphony.user.ImmutableException: No provider successfully created entity test@test.com at bucket.user.DefaultUserAccessor.addUser(DefaultUserAccessor.java:48) at com.atlassian.confluence.user.DefaultUserAccessor.addUser(DefaultUserAccessor.java:90) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:61) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:116) at com.atlassian.confluence.util.profiling.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:16) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:152) at $Proxy8.addUser(Unknown Source) at com.atlassian.confluence.user.actions.SignupAction.execute(SignupAction.java:49) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) [ERROR] Sun Dec 12 19:52:58 EST 2004 [com.opensymphony.webwork.dispatcher.ServletDispatcher] Could not execute action Throwable: bucket.core.InfrastructureException: com.opensymphony.user.ImmutableException: No provider successfully created entity test@test.com at bucket.user.DefaultUserAccessor.addUser(DefaultUserAccessor.java:48) at com.atlassian.confluence.user.DefaultUserAccessor.addUser(DefaultUserAccessor.java:90) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:61) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:116) at com.atlassian.confluence.util.profiling.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:16) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:152) at $Proxy8.addUser(Unknown Source) at com.atlassian.confluence.user.actions.SignupAction.execute(SignupAction.java:49) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)

    Atlassian JIRA | 1 decade ago | Ross Mason
    java.sql.SQLException: Invalid argument value, message from server: "Duplicate entry '0' for key 1"
  2. 0

    The 'sign up' link on the conflu title bar used to be hidden if external user management was being used. If a user tries to sign up you get - bucket.core.InfrastructureException: com.opensymphony.user.ImmutableException: No provider successfully created entity test@test.com at bucket.user.DefaultUserAccessor.addUser(DefaultUserAccessor.java:48) at com.atlassian.confluence.user.DefaultUserAccessor.addUser(DefaultUserAccessor.java:90) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:61) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:116) at com.atlassian.confluence.util.profiling.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:16) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:152) at $Proxy8.addUser(Unknown Source) at com.atlassian.confluence.user.actions.SignupAction.execute(SignupAction.java:49) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:33) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:16) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:40) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:73) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.core.ConfluenceAutowireInterceptor.intercept(ConfluenceAutowireInterceptor.java:25) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.user.actions.AuthenticatedUserInterceptor.intercept(AuthenticatedUserInterceptor.java:51) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.util.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:133) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:115) at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:229) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:199) at javax.servlet.http.HttpServlet.service(HttpServlet.java:103) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:159) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:168) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:170) at bucket.custom.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:30) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:73) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.confluence.util.error.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:26) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:36) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135) at com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:346) at com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:274) at com.caucho.server.TcpConnection.run(TcpConnection.java:139) at java.lang.Thread.run(Thread.java:534) Caused by: com.opensymphony.user.ImmutableException: No provider successfully created entity test@test.com at com.opensymphony.user.UserManager.createEntity(UserManager.java:376) at com.opensymphony.user.UserManager.createUser(UserManager.java:242) at bucket.user.DefaultUserAccessor.addUser(DefaultUserAccessor.java:21) ... 76 more Referer URL: http://wiki.muleumo.org/signup.action Build Information: Uptime: 1 day, 13 hours, 11 minutes, 50 seconds Version: 1.3 Build Number: 112 Server Information: Application Server: Resin/2.1.12 Servlet Version: 2.3 Database Dialect: N/A Memory Information: Total Memory: 99 MB Free Memory: 29 MB Used Memory: 70 MB System Information: System Date: Sunday, 12 Dec 2004 System Time: 19:52:58 System Favourite Colour: Lime Java Version: 1.4.2_03 Java Vendor: Sun Microsystems Inc. JVM Version: 1.0 JVM Vendor: Sun Microsystems Inc. JVM Implementation Version: 1.4.2_03-b02 Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition Java VM: Java HotSpot(TM) Client VM User Name: root User Timezone: America/New_York Operating System: Linux 2.4.26-1um OS Architecture: i386 Request Information: URL: http://wiki.muleumo.org/500page.jsp - Scheme: http - Server: wiki.muleumo.org - Port: 80 - URI: /500page.jsp - - Context Path: - - Servlet Path: /500page.jsp - - Path Info: null - - Query String: null Attributes: - __sitemesh__filterapplied : true - javax.servlet.error.request_uri : /dosignup.action - sessioninview.FILTERED : true - loginfilter.already.filtered : true - javax.servlet.error.message : com.opensymphony.user.ImmutableException: No provider successfully created entity test@test.com - javax.servlet.error.status_code : 500 - webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@b3149d - javax.servlet.error.servlet_name : action - os_securityfilter_already_filtered : true - com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true - atlassian.core.seraph.original.url : /dosignup.action - javax.servlet.error.exception : bucket.core.InfrastructureException: com.opensymphony.user.ImmutableException: No provider successfully created entity test@test.com - javax.servlet.jsp.jspException : bucket.core.InfrastructureException: com.opensymphony.user.ImmutableException: No provider successfully created entity test@test.com Parameters: - password = test - checkboxUsername = on - username = test@test.com - confirm = test - email = test@test.com - fullname = test Logging: 3 log statements generated by this request: [WARN] Sun Dec 12 19:52:58 EST 2004 [com.opensymphony.user.provider.jdbc.JDBCCredentialsProvider] User [test@test.com] must already exist Throwable: java.sql.SQLException: Invalid argument value, message from server: "Duplicate entry '0' for key 1" at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1905) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1109) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1203) at com.mysql.jdbc.Connection.execSQL(Connection.java:2090) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1680) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1527) at com.opensymphony.user.provider.jdbc.JDBCCredentialsProvider.create(JDBCCredentialsProvider.java:98) at bucket.user.providers.ChainedUserProvider.create(ChainedUserProvider.java:115) at bucket.user.providers.CachingCredentialsProvider.create(CachingCredentialsProvider.java:62) at com.opensymphony.user.UserManager.createEntity(UserManager.java:370) at com.opensymphony.user.UserManager.createUser(UserManager.java:242) at bucket.user.DefaultUserAccessor.addUser(DefaultUserAccessor.java:21) at com.atlassian.confluence.user.DefaultUserAccessor.addUser(DefaultUserAccessor.java:90) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:61) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149) [ERROR] Sun Dec 12 19:52:58 EST 2004 [com.atlassian.confluence.util.XWorkTransactionInterceptor] Invoking rollback for transaction on action '/dosignup.action (SignupAction.execute())' due to throwable: bucket.core.InfrastructureException: com.opensymphony.user.ImmutableException: No provider successfully created entity test@test.com Throwable: bucket.core.InfrastructureException: com.opensymphony.user.ImmutableException: No provider successfully created entity test@test.com at bucket.user.DefaultUserAccessor.addUser(DefaultUserAccessor.java:48) at com.atlassian.confluence.user.DefaultUserAccessor.addUser(DefaultUserAccessor.java:90) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:61) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:116) at com.atlassian.confluence.util.profiling.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:16) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:152) at $Proxy8.addUser(Unknown Source) at com.atlassian.confluence.user.actions.SignupAction.execute(SignupAction.java:49) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) [ERROR] Sun Dec 12 19:52:58 EST 2004 [com.opensymphony.webwork.dispatcher.ServletDispatcher] Could not execute action Throwable: bucket.core.InfrastructureException: com.opensymphony.user.ImmutableException: No provider successfully created entity test@test.com at bucket.user.DefaultUserAccessor.addUser(DefaultUserAccessor.java:48) at com.atlassian.confluence.user.DefaultUserAccessor.addUser(DefaultUserAccessor.java:90) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:61) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:116) at com.atlassian.confluence.util.profiling.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:16) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:152) at $Proxy8.addUser(Unknown Source) at com.atlassian.confluence.user.actions.SignupAction.execute(SignupAction.java:49) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)

    Atlassian JIRA | 1 decade ago | Ross Mason
    java.sql.SQLException: Invalid argument value, message from server: "Duplicate entry '0' for key 1"
  3. 0

    Syntax error

    Oracle Community | 1 decade ago | 843854
    java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'order (username,productId,Quantity) VALUES('eoiny','21','1')' a"
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    How to setup Spring/HIbernate JPA @Entiry to create a auto incrementing column (none id)

    Stack Overflow | 5 months ago | ALM
    org.springframework.orm.jpa.JpaSystemException: could not execute statement; nested exception is org.hibernate.exception.GenericJDBCException: could not execute statement
  6. 0

    MySQL logging error

    GitHub | 3 years ago | kfleischmann
    org.apache.logging.log4j.core.appender.AppenderLoggingException: Failed to insert record for log event in JDBC manager: Incorrect string value: '\xF0\x9F\x92\x99\xF0\x9F...' for column 'message' at row 1
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    Invalid argument value, message from server: "Duplicate entry '0' for key 1"

    at com.mysql.jdbc.MysqlIO.checkErrorPacket()
  2. MySQL jdbc
    PreparedStatement.executeUpdate
    1. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1905)
    2. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1109)
    3. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1203)
    4. com.mysql.jdbc.Connection.execSQL(Connection.java:2090)
    5. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1680)
    6. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1527)
    6 frames
  3. com.opensymphony.user
    JDBCCredentialsProvider.create
    1. com.opensymphony.user.provider.jdbc.JDBCCredentialsProvider.create(JDBCCredentialsProvider.java:98)
    1 frame
  4. bucket.user.providers
    CachingCredentialsProvider.create
    1. bucket.user.providers.ChainedUserProvider.create(ChainedUserProvider.java:115)
    2. bucket.user.providers.CachingCredentialsProvider.create(CachingCredentialsProvider.java:62)
    2 frames
  5. com.opensymphony.user
    UserManager.createUser
    1. com.opensymphony.user.UserManager.createEntity(UserManager.java:370)
    2. com.opensymphony.user.UserManager.createUser(UserManager.java:242)
    2 frames
  6. bucket.user
    DefaultUserAccessor.addUser
    1. bucket.user.DefaultUserAccessor.addUser(DefaultUserAccessor.java:21)
    1 frame
  7. com.atlassian.confluence
    DefaultUserAccessor.addUser
    1. com.atlassian.confluence.user.DefaultUserAccessor.addUser(DefaultUserAccessor.java:90)
    1 frame
  8. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:324)
    4 frames
  9. Spring AOP
    ReflectiveMethodInvocation.invokeJoinpoint
    1. org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:61)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149)
    2 frames