www-infrastructure-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hernan Cunico (JIRA)" <j...@apache.org>
Subject [jira] Created: (INFRA-1170) Error while deleting a Confluence space
Date Tue, 20 Feb 2007 14:59:05 GMT
Error while deleting a Confluence space
---------------------------------------

                 Key: INFRA-1170
                 URL: https://issues.apache.org/jira/browse/INFRA-1170
             Project: Infrastructure
          Issue Type: Bug
      Security Level: public (Regular issues)
          Components: Confluence
            Reporter: Hernan Cunico


Need to remove GMOxMoinMoin space but I receive the following error.

Cause:
org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [] in task 'Hibernate operation';
nested exception is java.sql.SQLException: 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 'select
distinct lc.LABELID from CONTENT_LABEL lc)' at line 1
 at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:85)
caused by: java.sql.SQLException: 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 'select distinct
lc.LABELID from CONTENT_LABEL lc)' at line 1
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)

Stack Trace: [hide]

org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [] in task 'Hibernate operation';
nested exception is java.sql.SQLException: 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 'select
distinct lc.LABELID from CONTENT_LABEL lc)' at line 1
java.sql.SQLException: 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 'select distinct lc.LABELID
from CONTENT_LABEL lc)' at line 1
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:75)
	at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:89)
	at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:880)
	at net.sf.hibernate.loader.Loader.doQuery(Loader.java:273)
	at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
	at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
	at net.sf.hibernate.loader.Loader.list(Loader.java:1054)
	at net.sf.hibernate.loader.SQLLoader.list(SQLLoader.java:92)
	at net.sf.hibernate.impl.SessionImpl.findBySQL(SessionImpl.java:3867)
	at net.sf.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:52)
	at com.atlassian.confluence.labels.persistence.dao.hibernate.HibernateLabelDao$9.doInHibernate(HibernateLabelDao.java:519)
	at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200)
	at com.atlassian.confluence.labels.persistence.dao.hibernate.HibernateLabelDao.findUnusedLabels(HibernateLabelDao.java:513)
	at com.atlassian.confluence.labels.DefaultLabelManager.removeAllLabels(DefaultLabelManager.java:207)
	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:585)
	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:18)
	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 $Proxy7.removeAllLabels(Unknown Source)
	at com.atlassian.confluence.spaces.DefaultSpaceManager.removeSpace(DefaultSpaceManager.java:122)
	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:585)
	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:18)
	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 $Proxy18.removeSpace(Unknown Source)
	at com.atlassian.confluence.spaces.actions.RemoveSpaceAction.doRemove(RemoveSpaceAction.java:17)
	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:585)
	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:39)
	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:39)
	at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
	at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:114)
	at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
	at com.atlassian.confluence.spaces.actions.SpaceAwareInterceptor.intercept(SpaceAwareInterceptor.java:82)
	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:39)
	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.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:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:117)
	at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:143)
	at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:51)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.confluence.util.ServletContextThreadLocalFilter.doFilter(ServletContextThreadLocalFilter.java:30)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.confluence.util.UserThreadLocalFilter.doFilter(UserThreadLocalFilter.java:45)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:182)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:170)
	at bucket.custom.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:31)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:73)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:122)
	at com.atlassian.confluence.util.error.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:27)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.core.filters.gzip.GzipFilter.doFilter(GzipFilter.java:61)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:831)
	at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:639)
	at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1285)
	at java.lang.Thread.run(Thread.java:595)

Referer URL: http://cwiki.apache.org/confluence/spaces/removespace.action?key=GMOxMoinMoin

Build Information:
Confluence Home: /usr/local/tomcat/tomcat-confluence/var/confluence
Uptime: 23 days, 7 hours, 38 minutes, 39 seconds
Version: 2.2.9
Build Number: 527

Server Information:
Application Server: Apache Tomcat/5.5.16
Servlet Version: 2.4
Database Dialect: bucket.dialect.MySQLDialect
Database Driver Name: com.mysql.jdbc.Driver
Database Driver Version: 3.1

Memory Information:
Total Memory: 393 MB
Free Memory: 60 MB
Used Memory: 333 MB

System Information:
System Date: Tuesday, 20 Feb 2007
System Time: 06:53:41
System Favourite Colour: Taupe
Java Version: 1.5.0_06
Java Vendor: Sun Microsystems Inc.
JVM Version: 1.0
JVM Vendor: Sun Microsystems Inc.
JVM Implementation Version: 1.5.0_06-b05
Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition
Java VM: Java HotSpot(TM) Server VM
User Name: www-data
User Timezone: US/Pacific
Operating System: Linux 2.6.12-9-686-smp
OS Architecture: i386
Filesystem Encoding: UTF-8

Enabled Plugins:
Utilities Plugin (org.randombits.confluence.utilities, Version: 2.1.3)
Auto Export Plugin (confluence.extra.autoexport, Version: 0.14-dev)
Basic Macros (confluence.macros.basic, Version: 1.3)
Gliffy Plugin (com.gliffy.integration.confluence, Version: 1.0.3)
Adaptavist Advanced Search (com.adaptavist.confluence.advancedSearch, Version: 1.0.2)
Chart Plugin (confluence.extra.chart, Version: 1.5)
User Listener (confluence.extra.userlister, Version: 1.2)
Global Labels Sections (confluence.sections.labels, Version: 1.0)
Information Macros (confluence.extra.information, Version: 0.1)
WebDAV Plugin (confluence.extra.webdav, Version: 1.0.1)
Confluence Remote API (confluence.extra.confluencerpc, Version: 1.4)
Profile Tabs (confluence.sections.profile, Version: 1.0)
Admin Sections (confluence.sections.admin, Version: 1.0)
Navigation Plugin (com.pentec.confluence.navigation, Version: 1.11)
Table of Contents Macros (org.randombits.confluence.toc, Version: 1.4.7)
Space Pages Sections (confluence.sections.space.pages, Version: 1.0)
Snippet Plugin (com.atlassian.confluence.extra.snippet, Version: 2.0.3-SNAPSHOT2)
News Tabs (confluence.sections.news, Version: 1.0)
Space Advanced Sections (confluence.sections.space.advanced, Version: 1.0)
Attachments Macros (confluence.extra.attachments, Version: 1.3)
IM Presence Macros (confluence.extra.impresence, Version: 0.1)
Footnote Macros (com.adaptavist.confluence.footnoteMacros, Version: 1.1.2)
Space Actions Sections (confluence.sections.space.actions, Version: 1.0)
Adaptavist Content Formatting Macros (com.adaptavist.confluence.contentFormattingMacros, Version:
1.6.4)
Task List Macros (confluence.extra.tasklist, Version: 1.3)
Redirection Macros (org.randombits.confluence.redirection, Version: 2.2)
New Code Macro (confluence.ext.code, Version: 1.0.3)
Space Labels Sections (confluence.sections.space.labels, Version: 1.0)
Dynamic Task List Macros (confluence.extra.dynamictasklist, Version: 1.3)
Core Extractors (confluence.extractors.core, Version: 1.4)
Composition Plugin (org.randombits.confluence.composition, Version: 2.2)
Compatibility Macros (confluence.macros.compatibility, Version: 1.3)
Page Tabs (confluence.sections.page, Version: 1.0)
Page Tree (bnpparibas.confluence.pagetree, Version: 1.3)
Core Listeners (confluence.listeners.core, Version: 1.3)
Dashboard Macros (confluence.macros.dashboard, Version: 1.3)
Live Search Macros (confluence.extra.livesearch, Version: 1.4)
Metadata Plugin (com.pantero.confluence.plugins.metadata, Version: 1.5)
JIRA Macros (confluence.extra.jira, Version: 1.4)
Layout Macros (confluence.extra.layout, Version: 0.1)
Excel Plugin (org.swift.confluence.excel, Version: 3.1)
Tabular Metadata (confluence.extra.masterdetail, Version: 1.0)
Space Admin Sections (confluence.sections.space.admin, Version: 1.0)
Cache Plugin (org.swift.confluence.cache, Version: 3.0.2)
Confluence Repository Client (confluence.repository.client, Version: 1.2)
Advanced Macros (confluence.macros.advanced, Version: 1.3)
HTML Plugin (org.swift.confluence.html, Version: 3.0.1)
Edit Profile Sections (confluence.sections.profile.edit, Version: 1.0)
Sudoku Game (com.adaptavist.confluence.games.sudoku, Version: 1.3.2)
Visibility Macros (org.randombits.visiblity, Version: 1.4.4)
Attachment Extractors (confluence.extractors.attachments, Version: 1.4)
Left Navigation Theme (com.atlassian.confluence.themes.leftnavigation, Version: 1.0)
Zones Plugin (com.atlassian.confluence.contrib.zones, Version: 1.2)
Space Item Tabs (confluence.sections.space, Version: 1.0)
Code Macro (confluence.macros.code, Version: 1.4)
Request

Information:
URL: http://localhost:8888/confluence/500page.jsp
- Scheme: http
- Server: localhost
- Port: 8888
- URI: /confluence/500page.jsp
- - Context Path: /confluence
- - Servlet Path: /500page.jsp
- - Path Info: null
- - Query String: key=GMOxMoinMoin

Attributes:
- javax.servlet.forward.request_uri : /confluence/spaces/doremovespace.action
- javax.servlet.forward.context_path : /confluence
- javax.servlet.forward.servlet_path : /spaces/doremovespace.action
- javax.servlet.forward.path_info : /500page.jsp
- javax.servlet.forward.query_string : key=GMOxMoinMoin
- javax.servlet.error.message :
- javax.servlet.error.exception : org.springframework.jdbc.BadSqlGrammarException: Bad SQL
grammar [] in task 'Hibernate operation'; nested exception is java.sql.SQLException: 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 'select distinct lc.LABELID from CONTENT_LABEL lc)' at line
1
- os_securityfilter_already_filtered : true
- __sitemesh__using_stream : false
- com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true
- javax.servlet.error.request_uri : /confluence/spaces/doremovespace.action
- javax.servlet.error.status_code : 500
- __sitemesh__filterapplied : true
- javax.servlet.error.servlet_name : action
- webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@cc355c
- atlassian.core.seraph.original.url : /spaces/doremovespace.action?key=GMOxMoinMoin
- loginfilter.already.filtered : true
- javax.servlet.jsp.jspException : org.springframework.jdbc.BadSqlGrammarException: Bad SQL
grammar [] in task 'Hibernate operation'; nested exception is java.sql.SQLException: 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 'select distinct lc.LABELID from CONTENT_LABEL lc)' at line
1
- sessioninview.FILTERED : true
- com.atlassian.core.filters.gzip.GzipFilter_already_filtered : true

Parameters:
- key = GMOxMoinMoin
- confirm = OK
Confluence User:
- anonymous

Logging:
0 log statements generated by this request.


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message