Hi, i've just installed xwiki (with the sample db: first with
xwiki-db-0.7.460.txt and then with xwiki-db-0.9.1.sql) and when I edit
(as admin) a page and save it I get the error message (see below). The
page is correctly saved though.
I have looked in the Db and the table "xwikilock" does no exist. The
following is the list of the tables (see below) in the xwiki DB.
I'm using java 1.5, tomcat5.5, mysql4.1
Dou you know what the reason for the problems can be?
Thanks in advance,
Miguel A. Bayona
====== list of tables in xwiki database created by script
xwiki-db-0.9.1.sql =====
CREATE TABLE xwikiattachment (
CREATE TABLE xwikiattachment_archive (
CREATE TABLE xwikiattachment_content (
CREATE TABLE xwikibooleanclasses (
CREATE TABLE xwikiclasses (
CREATE TABLE xwikiclassesprop (
CREATE TABLE xwikidateclasses (
CREATE TABLE xwikidates (
CREATE TABLE xwikidblistclasses (
CREATE TABLE xwikidoc (
CREATE TABLE xwikidoubles (
CREATE TABLE xwikifloats (
CREATE TABLE xwikiintegers (
CREATE TABLE xwikilargestrings (
CREATE TABLE xwikilistitems (
CREATE TABLE xwikilists (
CREATE TABLE xwikilongs (
CREATE TABLE xwikinumberclasses (
CREATE TABLE xwikiobjects (
CREATE TABLE xwikiproperties (
CREATE TABLE xwikislistclasses (
CREATE TABLE xwikistatsdoc (
CREATE TABLE xwikistatsreferer (
CREATE TABLE xwikistatsvisit (
CREATE TABLE xwikistringclasses (
CREATE TABLE xwikistrings (
======= errors and warnings in xwiki.log =========16:55:06,233 WARN
Finalizer JDBCContext:finalize:333 - afterTransactionCompletion() was
never called
16:58:00,649 WARN http-8080-Processor23
RequestUtils:createActionForm:177 - No FormBeanConfig found under 'view'
16:58:00,775 WARN http-8080-Processor23
http://<myserver>:8080/xwiki/bin/view/Main/WebHome
XWikiStatsServiceImpl:addCookie:474 - Setting cookie BV9L1ZG8NVZO
O0MLH37JFTRULRVPXZQW for name visitid with domain null and path / and
maxage 421133
16:58:00,777 WARN http-8080-Processor23
http://<myserver>:8080/xwiki/bin/view/Main/WebHome
XWikiStatsServiceImpl:findVisit:314 - Found visit with cookie R40
F0EXZHJHSXJGB1TCDEFPTDMHDSYGA in session
F892767861A94F264B2FD845B1D6A00E for request with cookie
BV9L1ZG8NVZOO0MLH37JFTRULRVPXZQW
16:58:45,063 WARN http-8080-Processor24
RequestUtils:createActionForm:177 - No FormBeanConfig found under 'view'
16:58:45,270 WARN http-8080-Processor24
http://<myserver>:8080/xwiki/bin/view/XWiki/XWikiUsers
XWikiStatsServiceImpl:addCookie:474 - Setting cookie BS0CHDAW
FDNII0CXXSZEJQBOH0YSQ7XL for name visitid with domain null and path /
and maxage 421088
16:58:45,271 WARN http-8080-Processor24
http://<myserver>:8080/xwiki/bin/view/XWiki/XWikiUsers
XWikiStatsServiceImpl:findVisit:314 - Found visit with cookie
BV9L1ZG8NVZOO0MLH37JFTRULRVPXZQW in session
F892767861A94F264B2FD845B1D6A00E for request with cookie
BS0CHDAWFDNII0CXXSZEJQBOH0YSQ7XL
16:58:59,933 WARN http-8080-Processor24
RequestUtils:createActionForm:177 - No FormBeanConfig found under 'view'
16:59:00,066 WARN http-8080-Processor24
http://<myserver>:8080/xwiki/bin/view/XWiki/Admin
XWikiStatsServiceImpl:addCookie:474 - Setting cookie YBOFE9LSAWOOB
FEQSLRXJW2UZ3ZTQEOK for name visitid with domain null and path / and
maxage 421073
16:59:00,067 WARN http-8080-Processor24
http://<myserver>:8080/xwiki/bin/view/XWiki/Admin
XWikiStatsServiceImpl:findVisit:314 - Found visit with cookie BV9L
1ZG8NVZOO0MLH37JFTRULRVPXZQW in session F892767861A94F264B2FD845B1D6A00E
for request with cookie YBOFE9LSAWOOBFEQSLRXJW2UZ3ZTQEOK
16:59:18,882 WARN http-8080-Processor24
RequestUtils:createActionForm:177 - No FormBeanConfig found under 'login'
16:59:18,886 WARN http-8080-Processor24
http://<myserver>:8080/xwiki/bin/login/XWiki/XWikiLogin?xredirect=http://<myserver>:8080/xwiki/bin/view/Main/WebHome
RequestUtils:createActionForm:177 - No FormBeanConfig found under
'loginerror'
16:59:44,153 WARN http-8080-Processor24
http://<myserver>:8080/xwiki/bin/edit/XWiki/XWikiPreferences?xpage=editrights&global=1
JDBCExceptionReporter:logExce
ptions:71 - SQL Error: 1146, SQLState: 42S02
16:59:44,155 ERROR http-8080-Processor24
http://<myserver>:8080/xwiki/bin/edit/XWiki/XWikiPreferences?xpage=editrights&global=1
JDBCExceptionReporter:logExce
ptions:72 - Table 'xwiki.xwikilock' doesn't exist
16:59:44,157 ERROR http-8080-Processor24
http://<myserver>:8080/xwiki/bin/edit/XWiki/XWikiPreferences?xpage=editrights&global=1
XWikiService:renderEdit:830 -
Exception while setting up lock
com.xpn.xwiki.XWikiException: Error number 13007 in 3: Exception while
loading lock
........
17:00:21,044 ERROR http-8080-Processor23
http://<myserver>:8080/xwiki/bin/objectadd/XWiki/XWikiPreferences
AbstractFlushingEventListener:performExecutions:27
7 - Could not synchronize database state with session
org.hibernate.StaleObjectStateException: Row was updated or deleted by
another transaction (or unsaved-value mapping was incorrect):
[com.xpn.xwiki.objects.c
lasses.StringClass#<?xml version="1.0" encoding="UTF-8"?>
<authenticate_edit>
<name>authenticate_edit</name>
<prettyName>Authenticate On Edit</prettyName>
<unmodifiable>0</unmodifiable>
<size>30</size>
<number>7</number>
<classType>com.xpn.xwiki.objects.classes.StringClass</classType>
</authenticate_edit>
]
at
org.hibernate.persister.entity.BasicEntityPersister.check(BasicEntityPersister.java:1431)
at
org.hibernate.persister.entity.BasicEntityPersister.update(BasicEntityPersister.java:1976)
at
org.hibernate.persister.entity.BasicEntityPersister.updateOrInsert(BasicEntityPersister.java:1899)
at
org.hibernate.persister.entity.BasicEntityPersister.update(BasicEntityPersister.java:2139)
.......
17:13:54,756 WARN http-8080-Processor25
http://<myserver>:8080/xwiki/bin/save/Main/WebHome
XWikiStatsServiceImpl:addCookie:474 - Setting cookie QBBALLSXMJCI
D7V2TZZ9RYKQKX3OHQRI for name visitid with domain null and path / and
maxage 420179
17:13:54,761 WARN http-8080-Processor25
http://<myserver>:8080/xwiki/bin/save/Main/WebHome
XWikiStatsServiceImpl:findVisit:314 - Found visit with cookie VDU
ZYLYTNEUTFDUG2GADQNTDZOFI8CJL in session
F892767861A94F264B2FD845B1D6A00E for request with cookie
QBBALLSXMJCID7V2TZZ9RYKQKX3OHQRI
17:15:07,125 WARN http-8080-Processor24
http://<myserver>:8080/xwiki/bin/save/Main/WebHome
JDBCExceptionReporter:logExceptions:71 - SQL Error: 1146, SQLStat
e: 42S02
17:15:07,126 ERROR http-8080-Processor24
http://<myserver>:8080/xwiki/bin/save/Main/WebHome
JDBCExceptionReporter:logExceptions:72 - Table 'xwiki.xwikilock'
doesn't exist
17:15:07,128 WARN http-8080-Processor24
http://<myserver>:8080/xwiki/bin/save/Main/WebHome
ViewEditAction:execute:242 - Uncaught exception: Error number 130
07 in 3: Exception while loading lock
Wrapped Exception: could not execute query
com.xpn.xwiki.XWikiException: Error number 13007 in 3: Exception while
loading lock
Wrapped Exception: could not execute query
.........
17:47:58,081 WARN http-8080-Processor25
http://<myserver>:8080/xwiki/bin/save/Main/WebHome
XWikiStatsServiceImpl:addCookie:474 - Setting cookie RQH6TYW9XXLY
PW4W9HBT5JATLVZVDHRO for name visitid with domain null and path / and
maxage 418135
17:47:58,082 WARN http-8080-Processor25
http://<myserver>:8080/xwiki/bin/save/Main/WebHome
XWikiStatsServiceImpl:findVisit:314 - Found visit with cookie VDU
ZYLYTNEUTFDUG2GADQNTDZOFI8CJL in session
F892767861A94F264B2FD845B1D6A00E for request with cookie
RQH6TYW9XXLYPW4W9HBT5JATLVZVDHRO
17:48:14,641 WARN http-8080-Processor25
http://<myserver>:8080/xwiki/bin/save/Main/WebHome
JDBCExceptionReporter:logExceptions:71 - SQL Error: 1146, SQLStat
e: 42S02
17:48:14,642 ERROR http-8080-Processor25
http://<myserver>:8080/xwiki/bin/save/Main/WebHome
JDBCExceptionReporter:logExceptions:72 - Table 'xwiki.xwikilock'
doesn't exist
17:48:14,643 WARN http-8080-Processor25
http://<myserver>:8080/xwiki/bin/save/Main/WebHome
ViewEditAction:execute:242 - Uncaught exception: Error number 130
07 in 3: Exception while loading lock
Wrapped Exception: could not execute query
com.xpn.xwiki.XWikiException: Error number 13007 in 3: Exception while
loading lock
=============== message error ===============================
Error number 13007 in 3: Exception while loading lock
Wrapped Exception: could not execute query
com.xpn.xwiki.XWikiException: Error number 13007 in 3: Exception while loading lock
Wrapped Exception: could not execute query
at com.xpn.xwiki.store.XWikiHibernateStore.loadLock(XWikiHibernateStore.java:1549)
at com.xpn.xwiki.doc.XWikiDocument.getLock(XWikiDocument.java:2117)
at com.xpn.xwiki.XWikiService.actionSave(XWikiService.java:446)
at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:155)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
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.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127)
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.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)
Wrapped Exception:
java.sql.SQLException: Table 'xwiki.xwikilock' doesn't exist
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1570)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2978)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:930)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1024)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:118)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1239)
at org.hibernate.loader.Loader.doQuery(Loader.java:374)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:210)
at org.hibernate.loader.Loader.doList(Loader.java:1562)
at org.hibernate.loader.Loader.list(Loader.java:1545)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:840)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:603)
at com.xpn.xwiki.store.XWikiHibernateStore.loadLock(XWikiHibernateStore.java:1539)
at com.xpn.xwiki.doc.XWikiDocument.getLock(XWikiDocument.java:2117)
at com.xpn.xwiki.XWikiService.actionSave(XWikiService.java:446)
at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:155)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
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.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127)
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.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)
