org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [SELECT usr.user_name AS user_name, grp.group_name as group_name FROM cwd_membership AS mem INNER JOIN cwd_group AS grp ON mem.parent_id = grp.id INNER JOIN cwd_user as usr ON mem.child_id = usr.ID WHERE membership_type = 'GROUP_USER' AND directory_id = ?]; Column 'directory_id' in where clause is ambiguous; nested exception is java.sql.SQLException: Column 'directory_id' in where clause is ambiguous

Atlassian JIRA | Renan Battaglin | 6 years ago
  1. 0

    *Problem 1:* * Name in uppercased for "CWD_DIRECTORY" causes issues in DBs with lowercased table names: {code} org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT id, directory_name FROM CWD_DIRECTORY WHERE directory_type = 'INTERNAL']; nested exception is java.sql.SQLException: Table 'jira4.CWD_DIRECTORY' doesn't exist at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:220) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407) {code} *Problem 2:* * Ambiguity in the Membership Query: {code} Cause : org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [SELECT usr.user_name AS user_name, grp.group_name as group_name FROM cwd_membership AS mem INNER JOIN cwd_group AS grp ON mem.parent_id = grp.id INNER JOIN cwd_user as usr ON mem.child_id = usr.ID WHERE membership_type = 'GROUP_USER' AND directory_id = ?]; Column 'directory_id' in where clause is ambiguous; nested exception is java.sql.SQLException: Column 'directory_id' in where clause is ambiguous Stack Trace : org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [SELECT usr.user_name AS user_name, grp.group_name as group_name FROM cwd_membership AS mem INNER JOIN cwd_group AS grp ON mem.parent_id = grp.id INNER JOIN cwd_user as usr ON mem.child_id = usr.ID WHERE membership_type = 'GROUP_USER' AND directory_id = ?]; Column 'directory_id' in where clause is ambiguous; nested exception is java.sql.SQLException: Column 'directory_id' in where clause is ambiguous at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:100) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) {code} I fixed the problem adding "mem." to the "WHERE" conditions: {code} SELECT usr.user_name AS user_name, grp.group_name as group_name FROM cwd_membership AS mem INNER JOIN cwd_group AS grp ON mem.parent_id = grp.id INNER JOIN cwd_user as usr ON mem.child_id = usr.ID WHERE mem.membership_type = 'GROUP_USER' AND mem.directory_id = ?; {code} More details and full stack traces: https://support.atlassian.com/browse/CWDSUP-4676

    Atlassian JIRA | 6 years ago | Renan Battaglin
    org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [SELECT usr.user_name AS user_name, grp.group_name as group_name FROM cwd_membership AS mem INNER JOIN cwd_group AS grp ON mem.parent_id = grp.id INNER JOIN cwd_user as usr ON mem.child_id = usr.ID WHERE membership_type = 'GROUP_USER' AND directory_id = ?]; Column 'directory_id' in where clause is ambiguous; nested exception is java.sql.SQLException: Column 'directory_id' in where clause is ambiguous
  2. 0

    *Problem 1:* * Name in uppercased for "CWD_DIRECTORY" causes issues in DBs with lowercased table names: {code} org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT id, directory_name FROM CWD_DIRECTORY WHERE directory_type = 'INTERNAL']; nested exception is java.sql.SQLException: Table 'jira4.CWD_DIRECTORY' doesn't exist at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:220) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407) {code} *Problem 2:* * Ambiguity in the Membership Query: {code} Cause : org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [SELECT usr.user_name AS user_name, grp.group_name as group_name FROM cwd_membership AS mem INNER JOIN cwd_group AS grp ON mem.parent_id = grp.id INNER JOIN cwd_user as usr ON mem.child_id = usr.ID WHERE membership_type = 'GROUP_USER' AND directory_id = ?]; Column 'directory_id' in where clause is ambiguous; nested exception is java.sql.SQLException: Column 'directory_id' in where clause is ambiguous Stack Trace : org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [SELECT usr.user_name AS user_name, grp.group_name as group_name FROM cwd_membership AS mem INNER JOIN cwd_group AS grp ON mem.parent_id = grp.id INNER JOIN cwd_user as usr ON mem.child_id = usr.ID WHERE membership_type = 'GROUP_USER' AND directory_id = ?]; Column 'directory_id' in where clause is ambiguous; nested exception is java.sql.SQLException: Column 'directory_id' in where clause is ambiguous at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:100) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) {code} I fixed the problem adding "mem." to the "WHERE" conditions: {code} SELECT usr.user_name AS user_name, grp.group_name as group_name FROM cwd_membership AS mem INNER JOIN cwd_group AS grp ON mem.parent_id = grp.id INNER JOIN cwd_user as usr ON mem.child_id = usr.ID WHERE mem.membership_type = 'GROUP_USER' AND mem.directory_id = ?; {code} More details and full stack traces: https://support.atlassian.com/browse/CWDSUP-4676

    Atlassian JIRA | 6 years ago | Renan Battaglin
    org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [SELECT usr.user_name AS user_name, grp.group_name as group_name FROM cwd_membership AS mem INNER JOIN cwd_group AS grp ON mem.parent_id = grp.id INNER JOIN cwd_user as usr ON mem.child_id = usr.ID WHERE membership_type = 'GROUP_USER' AND directory_id = ?]; Column 'directory_id' in where clause is ambiguous; nested exception is java.sql.SQLException: Column 'directory_id' in where clause is ambiguous
  3. 0

    SQL Scripts with wrong description separator fail due to DB constraints

    GitHub | 3 years ago | flyway
    org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [INSERT INTO public.schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES (?, ?, ?, ?, ?, current_user, ?, ?, TRUE)]; ERROR: value too long for type character varying(20); nested exception is org.postgresql.util.PSQLException: ERROR: value too long for type character varying(20)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    I ran into this exception when I failed to enter a "Description" for the request, and clicked Save, saw the error msg, entered a description, and then clicked 'Save' again. Document Id 3296 Error Message The system has encountered an error and is unable to complete your request at this time. Please provide more information regarding this error by completing this Incident Report. User Input ******************Stack Trace-Only shown when not in production***************** org.springframework.dao.DataIntegrityViolationException: OJB operation; SQL []; Cannot add or update a child row: a foreign key constraint fails (`kms`.`kms_doc_t`, CONSTRAINT `FK_FIL_DOC_ID` FOREIGN KEY (`DOC_ID`) REFERENCES `kms_fil_nm_t` (`DOC_ID`)); nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`kms`.`kms_doc_t`, CONSTRAINT `FK_FIL_DOC_ID` FOREIGN KEY (`DOC_ID`) REFERENCES `kms_fil_nm_t` (`DOC_ID`)) at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:100) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springmodules.orm.ojb.OjbAccessor.convertJdbcAccessException(OjbAccessor.java:107) at org.springmodules.orm.ojb.OjbAccessor.convertOjbAccessException(OjbAccessor.java:89) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:144) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.store(PersistenceBrokerTemplate.java:244) at

    Kuali JIRA | 5 years ago | Mike Riley
    org.springframework.dao.DataIntegrityViolationException: OJB operation; SQL []; Cannot add or update a child row: a foreign key constraint fails (`kms`.`kms_doc_t`, CONSTRAINT `FK_FIL_DOC_ID` FOREIGN KEY (`DOC_ID`) REFERENCES `kms_fil_nm_t` (`DOC_ID`)); nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`kms`.`kms_doc_t`, CONSTRAINT `FK_FIL_DOC_ID` FOREIGN KEY (`DOC_ID`) REFERENCES `kms_fil_nm_t` (`DOC_ID`))
  6. 0

    Hellow! I can't save pages. Thank you for your help. {code} Cause org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: com.atlassian.confluence.core.BodyContent#10322018; SQL []; integrity constraint violation: unique constraint or index violation; SYS_PK_10126 table: BODYCONTENT; nested exception is java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation; SYS_PK_10126 table: BODYCONTENT at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:100) caused by: java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation; SYS_PK_10126 table: BODYCONTENT at org.hsqldb.jdbc.Util.sqlException(Unknown Source) caused by: org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; SYS_PK_10126 table: BODYCONTENT at org.hsqldb.error.Error.error(Unknown Source) Stack Trace:[hide] org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: com.atlassian.confluence.core.BodyContent#10322018; SQL []; integrity constraint violation: unique constraint or index violation; SYS_PK_10126 table: BODYCONTENT; nested exception is java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation; SYS_PK_10126 table: BODYCONTENT at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:100) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.orm.hibernate.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:364) at org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:351) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:375) at org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java:341) at com.atlassian.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:350) at com.atlassian.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:335) at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernateDraftDao.getDraft(HibernateDraftDao.java:68) at com.atlassian.confluence.pages.DefaultDraftManager.findDraft(DefaultDraftManager.java:77) at sun.reflect.GeneratedMethodAccessor897.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at com.atlassian.spring.interceptors.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:16) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy69.findDraft(Unknown Source) at com.atlassian.confluence.content.service.page.CreateAbstractPageCommandImpl.executeInternal(CreateAbstractPageCommandImpl.java:108) at com.atlassian.confluence.core.service.AbstractServiceCommand$ServiceCommandState$2.execute(AbstractServiceCommand.java:149) at com.atlassian.confluence.core.service.AbstractServiceCommand.execute(AbstractServiceCommand.java:61) 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:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy1132.execute(Unknown Source) at com.atlassian.confluence.core.service.CommandActionHelper.execute(CommandActionHelper.java:41) at com.atlassian.confluence.pages.actions.CreatePageAction.doAdd(CreatePageAction.java:133) 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:597) at com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:302) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) 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:37) 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.xwork.interceptors.XsrfTokenInterceptor.intercept(XsrfTokenInterceptor.java:100) at com.atlassian.confluence.xwork.ConfluenceXsrfTokenInterceptor.intercept(ConfluenceXsrfTokenInterceptor.java:25) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.security.interceptors.CaptchaInterceptor.intercept(CaptchaInterceptor.java:49) 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.util.LoggingContextInterceptor.intercept(LoggingContextInterceptor.java:49) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.core.CancellingInterceptor.intercept(CancellingInterceptor.java:23) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.xwork.HttpMethodValidationInterceptor.intercept(HttpMethodValidationInterceptor.java:72) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.security.websudo.WebSudoInterceptor.intercept(WebSudoInterceptor.java:63) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.themes.ThemeContextInterceptor.intercept(ThemeContextInterceptor.java:68) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:57) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.setup.webwork.BootstrapAwareInterceptor.intercept(BootstrapAwareInterceptor.java:26) 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.UserAwareInterceptor.intercept(UserAwareInterceptor.java:58) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.pages.actions.CommentAwareInterceptor.intercept(CommentAwareInterceptor.java:50) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:140) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.spaces.actions.SpaceAwareInterceptor.intercept(SpaceAwareInterceptor.java:77) 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.actions.LastModifiedInterceptor.intercept(LastModifiedInterceptor.java:38) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.core.ConfluenceAutowireInterceptor.intercept(ConfluenceAutowireInterceptor.java:49) 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.xwork.interceptors.TransactionalInvocation.invokeAndHandleExceptions(TransactionalInvocation.java:76) at com.atlassian.xwork.interceptors.TransactionalInvocation.invokeInTransaction(TransactionalInvocation.java:61) at com.atlassian.xwork.interceptors.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:56) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.xwork.SetupIncompleteInterceptor.intercept(SetupIncompleteInterceptor.java:43) 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.atlassian.confluence.servlet.ConfluenceServletDispatcher.serviceAction(ConfluenceServletDispatcher.java:53) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:199) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:25) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.security.websudo.MessagesDecoratorFilter.doFilter(MessagesDecoratorFilter.java:59) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:129) at com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:77) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.jmx.JmxFilter.doFilter(JmxFilter.java:106) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.ServletContextThreadLocalFilter.doFilter(ServletContextThreadLocalFilter.java:19) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.util.LoggingContextFilter.doFilter(LoggingContextFilter.java:40) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.web.filter.ThreadLocalCacheFilter.doFilter(ThreadLocalCacheFilter.java:22) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.util.UserThreadLocalFilter.doFilter(UserThreadLocalFilter.java:44) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:211) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98) at com.atlassian.confluence.util.AbstractBootstrapHotSwappingFilter.doFilter(AbstractBootstrapHotSwappingFilter.java:30) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:150) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter(OAuthFilter.java:71) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.util.ClusterHeaderFilter.doFilter(ClusterHeaderFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:170) at com.atlassian.spring.filter.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:29) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.util.ConfluenceErrorFilter.doFilter(ConfluenceErrorFilter.java:22) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.core.datetime.RequestTimeThreadLocalFilter.doFilter(RequestTimeThreadLocalFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:80) at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.cache.AbstractCachingFilter.doFilter(AbstractCachingFilter.java:33) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.atlassian.confluence.extra.webdav.servlet.filter.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:427) at com.atlassian.confluence.extra.webdav.servlet.filter.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:34) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.web.filter.validateparam.RequestParamValidationFilter.doFilter(RequestParamValidationFilter.java:58) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.web.filter.TranslationModeFilter.doFilter(TranslationModeFilter.java:43) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.plugin.servlet.filter.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:71) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.web.filter.LanguageExtractionFilter.doFilter(LanguageExtractionFilter.java:54) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.util.RequestCacheThreadLocalFilter.doFilter(RequestCacheThreadLocalFilter.java:25) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:41) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.HeaderSanitisingFilter.doFilter(HeaderSanitisingFilter.java:44) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.servlet.FourOhFourErrorLoggingFilter.doFilter(FourOhFourErrorLoggingFilter.java:65) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) Caused by: java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation; SYS_PK_10126 table: BODYCONTENT at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(Unknown Source) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:436) at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2451) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2437) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2394) at net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1823) at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1580) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1545) at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49) at com.atlassian.hibernate.HibernateObjectDao$5.doInHibernate(HibernateObjectDao.java:383) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370) ... 239 more Caused by: org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; SYS_PK_10126 table: BODYCONTENT at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.Constraint.getException(Unknown Source) at org.hsqldb.index.IndexAVLMemory.insert(Unknown Source) at org.hsqldb.persist.RowStoreAVL.indexRow(Unknown Source) at org.hsqldb.TransactionManagerMVCC.addInsertAction(Unknown Source) at org.hsqldb.Session.addInsertAction(Unknown Source) at org.hsqldb.Table.insertSingleRow(Unknown Source) at org.hsqldb.StatementDML.insertSingleRow(Unknown Source) at org.hsqldb.StatementInsert.getResult(Unknown Source) at org.hsqldb.StatementDMQL.execute(Unknown Source) at org.hsqldb.Session.executeCompiledStatement(Unknown Source) at org.hsqldb.Session.execute(Unknown Source) ... 255 more Referer URL http://nsd-shp-vrt:8090/pages/createpage.action?spaceKey=aser&fromPageId=3277347 Confluence Application Information Build Information baseUrl: http://nsd-shp-vrt:8090 home: C:\Program Files\Atlassian\Application Data\Confluence buildNumber: 3273 upTime: 6 days, 5 hours, 43 minutes, 22 seconds devMode: false serverId: B007-OI5H-UPGU-BHQH supportEntitlementNumber: SEN-2250203 version: 4.2 Unique ID: d0e0f1fc-c843-412d-bf96-bf3bd4bbcd1e Server information Application Server: Apache Tomcat/6.0.32 Servlet Version: 2.5 Database Dialect: com.atlassian.hibernate.dialect.HSQL2Dialect Database Driver Name: org.hsqldb.jdbcDriver Memory Information Maximum Heap: 494 MB Allocated Heap: 494 MB Used Memory: 452 MB Unused Allocated Memory: 42 MB Available Memory: 42 MB Maximum Permgen: 256 MB Used Permgen: 165 MB System Information favouriteColour: Hot Pink javaRuntime: Java(TM) SE Runtime Environment operatingSystem: Windows Server 2008 R2 6.1 jvmVersion: 1.0 fileSystemEncoding: Cp1251 javaVm: Java HotSpot(TM) 64-Bit Server VM javaVendor: Sun Microsystems Inc. jvmImplementationVersion: 20.1-b02 systemTimezone: Europe/Moscow appServer: Apache Tomcat favouriteCharacter: Devon Woodcomb tempDirectory: C:\Program Files\Atlassian\Confluence\temp date: вторник, 19 июн 2012 jvmInputArguments: -Dcatalina.base=C:\Program Files\Atlassian\Confluence -Dcatalina.home=C:\Program Files\Atlassian\Confluence -Djava.endorsed.dirs=C:\Program Files\Atlassian\Confluence\endorsed -Djava.io.tmpdir=C:\Program Files\Atlassian\Confluence\temp -XX:MaxPermSize=256m -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.util.logging.config.file=C:\Program Files\Atlassian\Confluence\conf\logging.properties -Xms256m -Xmx512m time: 09:06:47 jvmVendor: Sun Microsystems Inc. userName: NSD-SHP-VRT$ javaVersion: 1.6.0_26 systemLanguage: ru operatingSystemArchitecture: amd64 workingDirectory: C:\Windows\system32 Cluster Information Not clustered. Plugins • Add Content Menu Sections (confluence.menu.add, Version: 1.0, Installed: bundled) • Admin Sections (confluence.sections.admin, Version: 1.0, Installed: bundled) • Advanced Macros (confluence.macros.advanced, Version: 2.0.43, Installed: Jan 12, 2012) • Apache HttpClient OSGi bundle (org.apache.httpcomponents.httpclient-4.0, Version: 4.0, Installed: bundled) • Apache HttpCore OSGi bundle (org.apache.httpcomponents.httpcore-4.0, Version: 4.0, Installed: bundled) • Applinks Product Plugin (com.atlassian.applinks.applinks-plugin, Version: 3.7.0, Installed: bundled) • Atlassian Editor Plugin (com.atlassian.plugins.editor, Version: 4.2, Installed: bundled) • Atlassian Embedded Crowd - Administration Plugin (com.atlassian.crowd.embedded.admin, Version: 1.4-rc1, Installed: bundled) • Atlassian Gadgets API (com.atlassian.gadgets.atlassian-gadgets-api-3.2.0.m3, Version: 3.2.0.m3, Installed: bundled) • Atlassian Gadgets OAuth Service Provider Plugin (com.atlassian.gadgets.oauth.serviceprovider, Version: 3.2.0-m3, Installed: bundled) • Atlassian Gadgets SPI (com.atlassian.gadgets.atlassian-gadgets-spi-3.2.0.m3, Version: 3.2.0.m3, Installed: bundled) • Atlassian Keyboard Shortcuts - Module Type (com.atlassian.plugins.shortcuts.atlassian-shortcuts-module, Version: 1.0, Installed: bundled) • Atlassian OAuth API (com.atlassian.oauth.atlassian-oauth-api-1.4.0, Version: 1.4.0, Installed: bundled) • Atlassian OAuth Admin Plugin (com.atlassian.oauth.admin, Version: 1.4.0, Installed: bundled) • Atlassian OAuth Consumer Plugin (com.atlassian.oauth.consumer, Version: 1.4.0, Installed: bundled) • Atlassian OAuth Consumer SAL SPI Implementation (com.atlassian.oauth.consumer.sal, Version: 1.4.0, Installed: bundled) • Atlassian OAuth Consumer SPI (com.atlassian.oauth.atlassian-oauth-consumer-spi-1.4.0, Version: 1.4.0, Installed: bundled) • Atlassian OAuth Service Provider Plugin (com.atlassian.oauth.serviceprovider, Version: 1.4.0, Installed: bundled) • Atlassian OAuth Service Provider SAL SPI Implementation (com.atlassian.oauth.serviceprovider.sal, Version: 1.4.0, Installed: bundled) • Atlassian OAuth Service Provider SPI (com.atlassian.oauth.atlassian-oauth-service-provider-spi-1.4.0, Version: 1.4.0, Installed: bundled) • Atlassian REST - Module Types (com.atlassian.plugins.rest.atlassian-rest-module, Version: 2.6.2, Installed: bundled) • Atlassian Search Results Enhancer (com.atlassian.confluence.plugins.search-resultenhancer, Version: 1.0, Installed: bundled) • Atlassian Soy Templates - Plugin (com.atlassian.soy.soy-template-plugin, Version: 1.1.0, Installed: bundled) • Atlassian Template Renderer API (com.atlassian.templaterenderer.api, Version: 1.4.0, Installed: bundled) • Atlassian Template Renderer Velocity 1.6 Plugin (com.atlassian.templaterenderer.atlassian-template-renderer-velocity1.6-plugin, Version: 1.4.0, Installed: bundled) • Atlassian Templates Import Framework (com.atlassian.confluence.plugins.templates-framework, Version: 0.2, Installed: bundled) • Atlassian Templates: Default Package (com.atlassian.confluence.plugins.templates-default, Version: 0.4, Installed: bundled) • Atlassian UI Plugin (com.atlassian.auiplugin, Version: 3.6.5, Installed: bundled) • Atlassian Universal Plugin Manager Plugin (com.atlassian.upm.atlassian-universal-plugin-manager-plugin, Version: 2.2, Installed: May 2, 2012) • Attachment Actions (confluence.sections.attachments, Version: 1.0, Installed: bundled) • Attachment Extractors (com.atlassian.confluence.plugins.attachmentExtractors, Version: 1.1, Installed: bundled) • BND Library (biz.aQute.bndlib-0.0.255, Version: 0.0.255, Installed: bundled) • Basic Macros (confluence.macros.basic, Version: 2.0.4, Installed: bundled) • Browse Menu Items (confluence.sections.browse, Version: 1.0, Installed: bundled) • Chart Plugin (confluence.extra.chart, Version: 2.0.1, Installed: bundled) • Checklists Macros (com.comalatech.checklists, Version: 1.6, Installed: May 28, 2012) • Code Macro Plugin (com.atlassian.confluence.ext.newcode-macro-plugin, Version: 2.0.11, Installed: Apr 20, 2012) • Comment Action Sections (confluence.comment.action, Version: 1.0, Installed: bundled) • Confluence AUI Staging (confluence.aui.staging, Version: 4.2, Installed: bundled) • Confluence Activity Stream Plugin (com.atlassian.streams.confluence, Version: 5.0.9, Installed: bundled) • Confluence Activity Streams Inline Actions Plugin (com.atlassian.streams.confluence.inlineactions, Version: 5.0.9, Installed: bundled) • Confluence Attachments Plugin (confluence.extra.attachments, Version: 3.3.2, Installed: bundled) • Confluence Blogging RPC Plugin (com.atlassian.confluence.plugins.xmlrpc.bloggingrpc, Version: 2.0.0, Installed: bundled) • Confluence Contributors Plugin (com.atlassian.confluence.contributors, Version: 1.3.1, Installed: Apr 20, 2012) • Confluence Core Macros (confluence.macros.core, Version: 4.2, Installed: bundled) • Confluence Dashboard Actions (com.atlassian.confluence.plugins.dashboard-actions, Version: 4.2, Installed: bundled) • Confluence Drag and Drop Plugin (com.atlassian.confluence.plugins.drag-and-drop, Version: 4.2, Installed: bundled) • Confluence Easy-User Admin (com.atlassian.confluence.plugins.confluence-easyuser-admin, Version: 4.2, Installed: bundled) • Confluence Edge Index (com.atlassian.confluence.plugins.confluence-edge-index, Version: 4.2, Installed: bundled) • Confluence Expand Macro (com.atlassian.confluence.plugins.expand-macro, Version: 4.2, Installed: bundled) • Confluence HTML Macros (confluence.macros.html, Version: 2.0.0, Installed: bundled) • Confluence Image Effects Plugin (com.atlassian.confluence.image.effects.ImageEffectsPlugin, Version: 1.0-beta7, Installed: bundled) • Confluence JSON-RPC Plugin (com.atlassian.confluence.rpc.confluence-json-rpc-plugin, Version: 1.0.4, Installed: bundled) • Confluence Keyboard Shortcuts Plugin (com.atlassian.confluence.keyboardshortcuts, Version: 4.2, Installed: bundled) • Confluence Legacy Web Resources (legacy.confluence.web.resources, Version: 2.0, Installed: bundled) • Confluence Like Plugin (com.atlassian.confluence.plugins.confluence-like, Version: 4.2, Installed: bundled) • Confluence Mail Archiving Plugin (com.atlassian.confluence.plugins.confluence-mail-archiving, Version: 4.2, Installed: bundled) • Confluence Mentions Plugin (com.atlassian.confluence.plugins.confluence-mentions-plugin, Version: 1.4.0, Installed: bundled) • Confluence Mobile Plugin (com.atlassian.confluence.plugins.confluence-mobile, Version: 4.2, Installed: bundled) • Confluence PDF Export (com.atlassian.confluence.extra.flyingpdf, Version: 2.5.6, Installed: May 28, 2012) • Confluence Paste (com.atlassian.confluence.plugins.confluence-paste, Version: 4.2, Installed: bundled) • Confluence Quick Comment Plugin (com.atlassian.confluence.plugins.quickcomments, Version: 4.2, Installed: bundled) • Confluence REST API (com.atlassian.confluence.restplugin, Version: 4.2, Installed: bundled) • Confluence Remote API (confluence.extra.confluencerpc, Version: 4.2, Installed: bundled) • Confluence SAL Plugin (com.atlassian.confluence.plugins.confluence-sal-plugin, Version: 4.2, Installed: bundled) • Confluence Scheduled Job Administration UI (com.atlassian.confluence.plugins.confluence-schedule-admin, Version: 4.2, Installed: bundled) • Confluence Soy Template Support (com.atlassian.confluence.plugins.soy, Version: 4.2, Installed: bundled) • Confluence Space Directory (com.atlassian.confluence.plugins.confluence-space-directory, Version: 4.2, Installed: bundled) • Confluence Thread Dump Plugin (com.atlassian.confluence.plugin.threaddump, Version: 2.0.0, Installed: bundled) • Confluence View Source (com.atlassian.confluence.plugins.view-source, Version: 4.2, Installed: bundled) • Confluence View Storage Format (com.atlassian.confluence.plugins.view-storage-format, Version: 4.2, Installed: bundled) • Confluence What's New (com.atlassian.confluence.whatsnew, Version: 4.2, Installed: bundled) • Confluence Wiki Markup Styler Plug-in (com.atlassian.labs.confluence.wiki-styler, Version: 1.1, Installed: Feb 29, 2012) • Confluence daily summary email (com.atlassian.confluence.plugins.confluence-daily-summary-email, Version: 4.2, Installed: bundled) • Content Action Menu Sections (confluence.content.action.menu, Version: 1.0, Installed: bundled) • Content Buttons (confluence.sections.page.temp, Version: 1.0, Installed: bundled) • Content Metadata (confluence.sections.content.metadata, Version: 1.0, Installed: bundled) • Core Extractors (confluence.extractors.core, Version: 1.4, Installed: bundled) • Core Listeners (confluence.listeners.core, Version: 1.3, Installed: bundled) • Core Path Converters (confluence.converters.core, Version: 1.0, Installed: bundled) • Core Startup and Shutdown (confluence.lifecycle.core, Version: 1, Installed: bundled) • Crowd System Password Encoders (crowd.system.passwordencoders, Version: 1.0, Installed: bundled) • Dashboard Macros (confluence.macros.dashboard, Version: 4.2, Installed: bundled) • Default Macro Metadata Provider (confluence.macro.metadata.provider, Version: 1.0, Installed: bundled) • Default Space Content Interface (confluence.sections.admin.defaultspacecontent, Version: 1.0, Installed: bundled) • Default Theme (com.atlassian.confluence.themes.default, Version: 1.0, Installed: bundled) • Did You Mean Index Building Interface (confluence.sections.admin.indexing, Version: 1.0, Installed: bundled) • Documentation Theme (com.atlassian.confluence.plugins.doctheme, Version: 4.2, Installed: Dec 2, 2011) • Dynamic Task List 2 Plugin (confluence.extra.dynamictasklist2, Version: 4.1.1, Installed: Feb 29, 2012) • Easy Reader Theme (com.atlassian.confluence.plugins.fixedwidth-theme, Version: 4.2, Installed: bundled) • Edit Settings Sections (confluence.sections.settings.edit, Version: 1.0, Installed: bundled) • Editor Actions (confluence.editor.actions, Version: 1.0, Installed: bundled) • EhCache Plugins (confluence.cache.ehcache, Version: 3.0, Installed: bundled) • Embedded Gadgets Plugin (com.atlassian.gadgets.embedded, Version: 3.2.0-m3, Installed: bundled) • Enterprise Directory (com.appfusions.confluence.enterprise-directory, Version: 2.0.7, Installed: Apr 20, 2012) • Follow list resources (confluence.sections.user.follow.list, Version: 1.0, Installed: bundled) • French (France) Language Pack (tac.confluence.languages.fr_FR, Version: 4.2.0-rc1-v2r777-2012-04-03, Installed: bundled) • Gadget Directory Plugin (com.atlassian.gadgets.directory, Version: 3.2.0-m3, Installed: bundled) • Gadget Spec Publisher Plugin (com.atlassian.gadgets.publisher, Version: 3.2.0-m3, Installed: bundled) • Gadgets Plugin (com.atlassian.confluence.plugins.gadgets, Version: 4.2, Installed: bundled) • Gadgets Plugin SPI (com.atlassian.confluence.plugins.gadgets.spi, Version: 4.2, Installed: bundled) • German (Germany) Language Pack (tac.confluence.languages.de_DE, Version: 4.2.0-rc1-v2r4461-2012-04-03, Installed: bundled) • Gliffy Confluence Plugin (com.gliffy.integration.confluence, Version: 4.2.4, Installed: May 28, 2012) • Global Labels Sections (confluence.sections.labels, Version: 1.0, Installed: bundled) • ICU4J (com.atlassian.bundles.icu4j-3.8.0.1, Version: 3.8.0.1, Installed: bundled) • IM Presence NG Plugin (confluence.extra.impresence2, Version: 2.8.1, Installed: Apr 20, 2012) • Image Searchresult Renderer (com.atlassian.confluence.plugins.confluence-imagesearchrenderer-plugin, Version: 2.2, Installed: bundled) • Information Macros (confluence.extra.information, Version: 2.0.6, Installed: bundled) • JDOM DOM Processor (com.springsource.org.jdom-1.0.0, Version: 1.0.0, Installed: bundled) • JIRA Macros (confluence.extra.jira, Version: 4.0.14, Installed: Feb 29, 2012) • JSON Library (com.atlassian.bundles.json-20070829.0.0.1, Version: 20070829.0.0.1, Installed: bundled) • JSR 305 Annotations (com.atlassian.bundles.jsr305-1.0, Version: 1.0, Installed: bundled) • Java Concurrency in Practice Annotations (com.springsource.net.jcip.annotations-1.0.0, Version: 1.0.0, Installed: bundled) • Layout Macros (confluence.extra.layout, Version: 2.0.1, Installed: bundled) • Live Search Macros (confluence.extra.livesearch, Version: 3.0.0, Installed: bundled) • Lucene Boosting Strategies (confluence.search.lucene.boosting, Version: 1.0, Installed: bundled) • Macro Usage Extractor (com.atlassian.confluence.plugins.confluence-macro-usage, Version: 1.0.3, Installed: bundled) • Navitabs Plugin (ch.bitvoodoo.confluence.plugins.navitabs, Version: 3.1.2, Installed: Apr 20, 2012) • News Tabs (confluence.sections.news, Version: 1.0, Installed: bundled) • Numbered Headings (nl.avisi.confluence.plugins.numberedheadings, Version: 2.0.3, Installed: Oct 28, 2011) • Office Connector plugin (com.atlassian.confluence.extra.officeconnector, Version: 2.1.4, Installed: Nov 14, 2011) • Opensocial Plugin (com.atlassian.gadgets.opensocial, Version: 3.2.0-m3, Installed: bundled) • Page Operations (confluence.sections.page.operations, Version: 1.0, Installed: bundled) • Page Tabs (confluence.search.mappers.lucene, Version: 1.0, Installed: bundled) • Page Tabs (confluence.sections.page, Version: 1.0, Installed: bundled) • Page Tree (com.atlassian.confluence.plugins.pagetree, Version: 2.0.2, Installed: bundled) • Profile Macros (confluence.macros.profile, Version: 1.0, Installed: bundled) • Profile Picture (com.atlassian.confluence.plugins.profile-picture, Version: 1.6, Installed: bundled) • Profile Tabs (confluence.sections.profile, Version: 1.0, Installed: bundled) • ROME, RSS and atOM utilitiEs for Java (rome.rome-1.0, Version: 1.0, Installed: bundled) • Russian (Russia) Language Pack (tac.confluence.languages.ru_RU, Version: 4.0.0-v2r8860-2011-10-21, Installed: Oct 24, 2011) • SQL Plugin (org.swift.confluence.sql, Version: 4.2.2, Installed: Feb 29, 2012) • Scroll Office (com.k15t.scroll.scroll-office, Version: 2.5.6, Installed: May 28, 2012) • Search Web Interface (confluence.sections.admin.generalconfig, Version: 1.0, Installed: bundled) • Search Web Interface (confluence.sections.search.view, Version: 1.0, Installed: bundled) • Share Page (com.atlassian.confluence.plugins.share-page, Version: 1.20, Installed: bundled) • Space Admin Sections (confluence.sections.space.admin, Version: 1.0, Installed: bundled) • Space Advanced Sections (confluence.sections.space.advanced, Version: 1.0, Installed: bundled) • Space Browse Sections (confluence.sections.space.browse, Version: 1.0, Installed: bundled) • Space Export Web Interface (confluence.sections.space.export.view, Version: 1.0, Installed: bundled) • Space Item Tabs (confluence.sections.space, Version: 1.0, Installed: bundled) • Space Labels Sections (confluence.sections.space.labels, Version: 1.0, Installed: bundled) • Space Pages Sections (confluence.sections.space.pages, Version: 1.0, Installed: bundled) • Status Macro (com.atlassian.confluence.plugins.status-macro, Version: 1.13, Installed: bundled) • Streams API (com.atlassian.streams.streams-api-5.0.9, Version: 5.0.9, Installed: bundled) • Streams Core Plugin (com.atlassian.streams.core, Version: 5.0.9, Installed: bundled) • Streams Inline Actions Plugin (com.atlassian.streams.actions, Version: 5.0.9, Installed: bundled) • Streams Plugin (com.atlassian.streams, Version: 5.0.9, Installed: bundled) • Streams SPI (com.atlassian.streams.streams-spi-5.0.9, Version: 5.0.9, Installed: bundled) • Support Tools Plugin (com.atlassian.support.stp, Version: 2.10.1, Installed: Feb 29, 2012) • System Web Components (confluence.web.components, Version: 1.0, Installed: bundled) • System Web Panels (confluence.web.panel.renderers, Version: 1.0, Installed: bundled) • System Web Panels (confluence.web.panels, Version: 1.0, Installed: bundled) • System Web Resources (confluence.web.resources, Version: 1.0, Installed: bundled) • TDM Merger (com.atlassian.plugins.confluence-tdm-merger, Version: 4.2, Installed: bundled) • Table of Contents Plugin (org.randombits.confluence.toc, Version: 2.5.12, Installed: May 28, 2012) • Tabular Metadata (confluence.extra.masterdetail, Version: 2.11.3, Installed: Oct 27, 2011) • TinyMCE Editor Plugin (com.atlassian.confluence.tinymceplugin, Version: 4.2, Installed: bundled) • UWC Importer Admin Panel (com.atlassian.confluence.plugins.uwc.uwcimporter-adminpanel, Version: 1.2.1, Installed: bundled) • Upgrade Administration Interface (confluence.sections.admin.upgrade, Version: 1.0, Installed: bundled) • User Administration (confluence.admin.user, Version: 1.0, Installed: bundled) • User Hover Menu Sections (confluence.user.hover.menu, Version: 1.0, Installed: bundled) • User Lister (confluence.extra.userlister, Version: 2.5.1, Installed: Apr 20, 2012) • User Menu Sections (confluence.user.menu.concise, Version: 1.0, Installed: bundled) • User Menu Sections (confluence.user.menu, Version: 1.0, Installed: bundled) • User Profile Plugin (de.communardo.confluence.plugins.userprofile, Version: 1.5, Installed: May 2, 2012) • User Status (confluence.userstatus, Version: 1.0, Installed: bundled) • View Profile Web Interface (confluence.sections.profile.view, Version: 1.0, Installed: bundled) • View follow resources (confluence.sections.user.view.follow, Version: 1.0, Installed: bundled) • WebDAV Plugin (confluence.extra.webdav, Version: 3.0.2, Installed: bundled) • Widget Connector (com.atlassian.confluence.extra.widgetconnector, Version: 2.0.1, Installed: Apr 20, 2012) • Wiki Markup Plugin (confluence.xhtml.wikimarkup, Version: 1.0, Installed: bundled) • Wiki Renderer Components (confluence.renderer.components, Version: 1.0, Installed: bundled) • jira-connector (com.atlassian.confluence.plugins.jira.jira-connector, Version: 1.4.1, Installed: bundled) Request Information URL http://nsd-shp-vrt:8090/500page.jsp URI /500page.jsp Context Path Servlet Path /500page.jsp Headers (Limited subset) host nsd-shp-vrt:8090 user-agent Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko/20100101 Firefox/11.0 connection keep-alive Attributes javax.servlet.forward.request_uri /pages/docreatepage.action javax.servlet.forward.context_path javax.servlet.forward.servlet_path /pages/docreatepage.action javax.servlet.forward.path_info /500page.jsp os_securityfilter_already_filtered true javax.servlet.jsp.jspException org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: com.atlassian.confluence.core.BodyContent#10322018; SQL []; integrity constraint violation: unique constraint or index violation; SYS_PK_10126 table: BODYCONTENT; nested exception is java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation; SYS_PK_10126 table: BODYCONTENT com.atlassian.seraph.auth.LoginReason OK com.atlassian.confluence.security.websudo.MessagesDecoratorFilter_already_filtered_ true atlassian.core.seraph.original.url /pages/docreatepage.action confluence.themecontext com.atlassian.confluence.themes.ThemeContext@4a455189 javax.servlet.error.status_code 500 javax.servlet.error.servlet_name action com.opensymphony.sitemesh.USINGSTREAM false com.atlassian.gzipfilter.GzipFilter_already_filtered true loginfilter.already.filtered true com.atlassian.confluence.web.ConfluenceJohnsonFilter_already_filtered true Confluence-Request-Time 1340082407486 javax.servlet.error.message com.opensymphony.sitemesh.APPLIED_ONCE true com.atlassian.core.filters.HeaderSanitisingFilter_already_filtered true __cleanup_recursion_counter 0 webwork.valueStack com.opensymphony.xwork.util.OgnlValueStack@cec1f77 com.atlassian.confluence.web.filter.validateparam.RequestParamValidationFilter_already_filtered true javax.servlet.error.exception org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: com.atlassian.confluence.core.BodyContent#10322018; SQL []; integrity constraint violation: unique constraint or index violation; SYS_PK_10126 table: BODYCONTENT; nested exception is java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation; SYS_PK_10126 table: BODYCONTENT javax.servlet.error.request_uri /pages/docreatepage.action Parameters (Limited subset) draftId 10518627 position viewPermissionsGroups linkCreation false editPermissionsUsers viewPermissionsUsers atl_token 423370d7fe6a2cdd7c2e9d13c883443bd099a0da entityId 10518627 editPermissionsGroups targetId fromPageId 3277347 title test wysiwygContent <p>test</p> parentPageString Home moveHierarchy true labelsString newSpaceKey aser spaceKey aser titleWritten false confirm Save Confluence User Logging: 3 log statements generated by this request: [ERROR] Tue Jun 19 09:06:47 MSD 2012 [net.sf.hibernate.util.JDBCExceptionReporter] integrity constraint violation: unique constraint or index violation; SYS_PK_10126 table: BODYCONTENT [ERROR] Tue Jun 19 09:06:47 MSD 2012 [net.sf.hibernate.impl.SessionImpl] Could not synchronize database state with session [ERROR] Tue Jun 19 09:06:47 MSD 2012 [com.atlassian.confluence.servlet.ConfluenceServletDispatcher] Could not execute action Throwable: org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: com.atlassian.confluence.core.BodyContent#10322018; SQL []; integrity constraint violation: unique constraint or index violation; SYS_PK_10126 table: BODYCONTENT; nested exception is java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation; SYS_PK_10126 table: BODYCONTENT at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:100) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.orm.hibernate.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:364) at org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:351) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:375) at org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java:341) at com.atlassian.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:350) at com.atlassian.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:335) at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernateDraftDao.getDraft(HibernateDraftDao.java:68) at com.atlassian.confluence.pages.DefaultDraftManager.findDraft(DefaultDraftManager.java:77) at sun.reflect.GeneratedMethodAccessor897.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at com.atlassian.spring.interceptors.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:16) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) {code}

    Atlassian JIRA | 4 years ago | Vladimir
    org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: com.atlassian.confluence.core.BodyContent#10322018; SQL []; integrity constraint violation: unique constraint or index violation; SYS_PK_10126 table: BODYCONTENT; nested exception is java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation; SYS_PK_10126 table: BODYCONTENT

    1 unregistered visitors
    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. org.springframework.dao.DataIntegrityViolationException

      PreparedStatementCallback; SQL [SELECT usr.user_name AS user_name, grp.group_name as group_name FROM cwd_membership AS mem INNER JOIN cwd_group AS grp ON mem.parent_id = grp.id INNER JOIN cwd_user as usr ON mem.child_id = usr.ID WHERE membership_type = 'GROUP_USER' AND directory_id = ?]; Column 'directory_id' in where clause is ambiguous; nested exception is java.sql.SQLException: Column 'directory_id' in where clause is ambiguous

      at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate()
    2. Spring Framework
      AbstractFallbackSQLExceptionTranslator.translate
      1. org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:100)
      2. org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
      3. org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
      3 frames