Table 'xwiki.xwikilock' doesn't exist

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Table 'xwiki.xwikilock' doesn't exist

mabayona
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)







--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws