8 Oct
2015
8 Oct
'15
12:46 p.m.
We are running XWiki 5.4.3
We have upgraded the server on which XWiki runs, but we now get an error
when we want to delete a page:
Error number 0 in 3: Exception while hibernate execute
com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate
execute
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1266)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernateBaseStore.java:1346)
at
com.xpn.xwiki.store.XWikiHibernateRecycleBinStore.saveToRecycleBin(XWikiHibernateRecycleBinStore.java:123)
at com.xpn.xwiki.XWiki.deleteDocument(XWiki.java:3801)
at com.xpn.xwiki.XWiki.deleteDocument(XWiki.java:3776)
at com.xpn.xwiki.XWiki.deleteAllDocuments(XWiki.java:5521)
at com.xpn.xwiki.XWiki.deleteAllDocuments(XWiki.java:5510)
at com.xpn.xwiki.web.DeleteAction.action(DeleteAction.java:93)
at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:293)
at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:129)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:121)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:126)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at
com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:66)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at
org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at
org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:315)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.hibernate.exception.GenericJDBCException: could not insert:
[com.xpn.xwiki.doc.XWikiDeletedDocument]
at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at
org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:64)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2345)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2852)
at
org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
at
org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:320)
at
org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:203)
at
org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:129)
at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)
at
org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:56)
at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)
at
org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:50)
at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:713)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:701)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:697)
at
com.xpn.xwiki.store.XWikiHibernateRecycleBinStore$1.doInHibernate(XWikiHibernateRecycleBinStore.java:128)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1260)
... 46 more
Caused by: java.sql.SQLException: Field 'XDD_ID' doesn't have a default
value
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2113)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2049)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2034)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at
org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:94)
at
org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:57)
... 63 more
What could be the cause? Where should we start looking?
--
View this message in context:
http://xwiki.475771.n2.nabble.com/Delete-page-Error-number-0-in-3-Exception…
Sent from the XWiki- Users mailing list archive at Nabble.com.
8 Oct
8 Oct
1:16 p.m.
Hi Hamster,
On 8 Oct 2015 at 12:46:44, Hamster (teunham@hotmail.com(mailto:teunham@hotmail.com))
wrote:
We are running XWiki 5.4.3
We have upgraded the server on which XWiki runs, but we now get an error
when we want to delete a page:
First, could you tell us to what version you are upgrading?
Error number 0 in 3: Exception while hibernate
execute
com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate
execute
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1266)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernateBaseStore.java:1346)
at
com.xpn.xwiki.store.XWikiHibernateRecycleBinStore.saveToRecycleBin(XWikiHibernateRecycleBinStore.java:123)
at com.xpn.xwiki.XWiki.deleteDocument(XWiki.java:3801)
at com.xpn.xwiki.XWiki.deleteDocument(XWiki.java:3776)
at com.xpn.xwiki.XWiki.deleteAllDocuments(XWiki.java:5521)
at com.xpn.xwiki.XWiki.deleteAllDocuments(XWiki.java:5510)
at com.xpn.xwiki.web.DeleteAction.action(DeleteAction.java:93)
[snip]
Caused by: java.sql.SQLException: Field
'XDD_ID' doesn't have a default
value
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
[snip]
What could be the cause? Where should we start
looking?
This looks like some error of upgrading the schema. Are you sure that you have enabled
data migration:
xwiki.store.migration=1
xwiki.store.migration.databases=all
Thanks
-Vincent
3:05 p.m.
We are not upgrading XWiki at all, we created a new server where XWiki runs
on. :-)
In short:
Our ICT created a new ubuntu server with TomCat7, Java7 and localhost MySQL
server.
They then put xwiki.war in the TomCat7 folder.
They made an SQL dump of the "old" XWiki and restored that on the new MySQL
server (and created an xwiki user with all priveleges to the xwiki
database).
They edited the Hibernate file so it refers to the new xwiki database.
They edited setenv.sh with the settings for the Java Heap Space.
They then opened/started XWiki and SKIPPED the upgrade (it's not an upgrade
but a new server).
--
View this message in context:
http://xwiki.475771.n2.nabble.com/Delete-page-Error-number-0-in-3-Exception…
Sent from the XWiki- Users mailing list archive at Nabble.com.
3:19 p.m.
On Thu, Oct 8, 2015 at 4:05 PM, Hamster <teunham(a)hotmail.com> wrote:
We are not upgrading XWiki at all, we created a new
server where XWiki runs
on. :-)
In short:
Our ICT created a new ubuntu server with TomCat7, Java7 and localhost MySQL
server.
They then put xwiki.war in the TomCat7 folder.
They made an SQL dump of the "old" XWiki and restored that on the new MySQL
server (and created an xwiki user with all priveleges to the xwiki
database).
They edited the Hibernate file so it refers to the new xwiki database.
They edited setenv.sh with the settings for the Java Heap Space.
They then opened/started XWiki and SKIPPED the upgrade
(it's not an upgrade
but a new server).
Using a new XWiki war (with a different version) with an old (existing)
database (=wiki pages) is an upgrade. The wiki pages are using APIs
provided by the war. If you change the war version you need to update the
wiki pages. The job of the Distribution Wizard you skipped is to ensure the
wiki pages are in sync with the war version.
--
View this message in context:
http://xwiki.475771.n2.nabble.com/Delete-page-Error-number-0-in-3-Exception…
Sent from the XWiki- Users mailing list archive at Nabble.com.
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
3:56 p.m.
It's not a new war file, it's the same war file (only now on a different
server)
I will try to explain again :-)
We have "Server A" (running XWiki 5.4.3) but we want to move everyting to
"Server B" (which will also runs XWiki 5.4.3).
On "Server A" we made a dump of the MySQL (all the xwiki pages).
On "Server B" we have installed ubuntu, TomCat7, Java7.
We then copied the war file from "Server A" to "Server B". On server
"B"
TomCat extracted the war file automaticly. We then restored the dump on
"Server B".
So "Server B" has the same war file and xwiki pages as on "Server A".
Does this make any sense? :-)
--
View this message in context:
http://xwiki.475771.n2.nabble.com/Delete-page-Error-number-0-in-3-Exception…
Sent from the XWiki- Users mailing list archive at Nabble.com.
9 Oct
9 Oct
10:31 a.m.
So with the same war file and the same database...do we still need to run the
upgrade process?
--
View this message in context:
http://xwiki.475771.n2.nabble.com/Delete-page-Error-number-0-in-3-Exception…
Sent from the XWiki- Users mailing list archive at Nabble.com.
10:41 a.m.
If you put the same WAR version you won't get the Distribution Wizard
anyway (otherwise you would get it every time you restart).
On Fri, Oct 9, 2015 at 10:31 AM, Hamster <teunham(a)hotmail.com> wrote:
So with the same war file and the same database...do
we still need to run the
upgrade process?
--
View this message in context:
http://xwiki.475771.n2.nabble.com/Delete-page-Error-number-0-in-3-Exception…
Sent from the XWiki- Users mailing list archive at Nabble.com.
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
--
Thomas Mortagne
1:12 p.m.
On Fri, Oct 9, 2015 at 11:31 AM, Hamster <teunham(a)hotmail.com> wrote:
So with the same war file and the same database...do
we still need to run
the
upgrade process?
Besides the war and the database there is also the permanent directory
which holds important things like:
* the extension index (which extensions have been installed)
* the Solr search index
* various job statuses, including the status of the Distribution Wizard
* caches
* etc.
The Distribution Wizard appears because the extension index is empty. You
have the wiki pages but the XWiki UI is not properly marked as installed so
the Distribution Wizard offers to install (actually repair) it.
Hope this helps,
Marius
--
View this message in context:
http://xwiki.475771.n2.nabble.com/Delete-page-Error-number-0-in-3-Exception…
Sent from the XWiki- Users mailing list archive at Nabble.com.
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
2:17 p.m.
Thanks guys, that should give us some clues to work on!
--
View this message in context:
http://xwiki.475771.n2.nabble.com/Delete-page-Error-number-0-in-3-Exception…
Sent from the XWiki- Users mailing list archive at Nabble.com.
20 Oct
20 Oct
10:31 a.m.
We still receiving the error messages after trying to delete a page or
attachment.
I also tried to do a upgrade and repair with the Distribution Wizard, but
the error messages remain.
The error message in the Catalina.out:
2015-10-20 10:23:00,312 [] WARN o.h.u.JDBCExceptionReporter - SQL Error:
1364, SQLState: HY000
2015-10-20 10:23:00,312 [] ERROR o.h.u.JDBCExceptionReporter - Field
'XDD_ID' doesn't have a default value
2015-10-20 10:23:00,315 [] WARN c.x.x.w.XWikiAction - Uncaught
exception: Error number 0 in 3: Exception while hibernate exate execute
com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate
execute
Caused by: org.hibernate.exception.GenericJDBCException: could not insert:
[com.xpn.xwiki.doc.XWikiDeletedDocument]
Caused by: java.sql.SQLException: Field 'XDD_ID' doesn't have a default
value
--
View this message in context:
http://xwiki.475771.n2.nabble.com/Delete-page-Error-number-0-in-3-Exception…
Sent from the XWiki- Users mailing list archive at Nabble.com.
10:35 a.m.
Hi LA,
Could you confirm that you’ve done the DB migration as I suggested in my first reply to
Hamster?
“
This looks like some error of upgrading the schema. Are you sure that you have enabled
data migration:
xwiki.store.migration=1
xwiki.store.migration.databases=all
"
Thanks
-Vincent
On 20 Oct 2015 at 10:31:42, LA (l-aaldering@jazo.eu(mailto:l-aaldering@jazo.eu)) wrote:
We still receiving the error messages after trying to
delete a page or
attachment.
I also tried to do a upgrade and repair with the Distribution Wizard, but
the error messages remain.
The error message in the Catalina.out:
2015-10-20 10:23:00,312 [] WARN o.h.u.JDBCExceptionReporter - SQL Error:
1364, SQLState: HY000
2015-10-20 10:23:00,312 [] ERROR o.h.u.JDBCExceptionReporter - Field
'XDD_ID' doesn't have a default value
2015-10-20 10:23:00,315 [] WARN c.x.x.w.XWikiAction - Uncaught
exception: Error number 0 in 3: Exception while hibernate exate execute
com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate
execute
Caused by: org.hibernate.exception.GenericJDBCException: could not insert:
[com.xpn.xwiki.doc.XWikiDeletedDocument]
Caused by: java.sql.SQLException: Field 'XDD_ID' doesn't have a default
value
10:42 a.m.
I can confirm this, also tried to do a upgrade to 6.4.5, also with the
Distribution Wizard.
Everything works only deleting a page doesn't.
--
View this message in context:
http://xwiki.475771.n2.nabble.com/Delete-page-Error-number-0-in-3-Exception…
Sent from the XWiki- Users mailing list archive at Nabble.com.
10:47 a.m.
On 20 Oct 2015 at 10:42:47, LA (l-aaldering@jazo.eu(mailto:l-aaldering@jazo.eu)) wrote:
I can confirm this, also tried to do a upgrade to
6.4.5, also with the
Distribution Wizard.
Everything works only deleting a page doesn’t.
Are you using the Filesystem storage for attachments?
Thanks
-Vincent
10:53 a.m.
No, we do not using the Filesystem Storage for attachments.
--
View this message in context:
http://xwiki.475771.n2.nabble.com/Delete-page-Error-number-0-in-3-Exception…
Sent from the XWiki- Users mailing list archive at Nabble.com.
1:47 p.m.
Hi,
So I checked our schema and the XDD_ID field is the primary key for the Deleted Documents
table:
<class name="com.xpn.xwiki.doc.XWikiDeletedDocument"
table="xwikirecyclebin" mutable="false">
<id name="id" column="XDD_ID">
<generator class="native" />
</id>
This definition has not changed since forever so the problem is elsewhere.
Since that id is generated I don’t see how it cannot have a default value….
Now is it possible that you have enabled the STRICT_TRANS_TABLES mode for your mysql
instance (see
http://stackoverflow.com/questions/15438840/mysql-error-1364-field-doesnt-h…
What version of mysql are you running?
Thanks
-Vincent
On 20 Oct 2015 at 10:53:33, LA (l-aaldering@jazo.eu(mailto:l-aaldering@jazo.eu)) wrote:
No, we do not using the Filesystem Storage for
attachments.
--
View this message in context:
http://xwiki.475771.n2.nabble.com/Delete-page-Error-number-0-in-3-Exception…
Sent from the XWiki- Users mailing list archive at Nabble.com.
2:01 p.m.
Hi,
The version of mysql is 14.14 Distrib 5.5.44, it is running on Ubuntu and
xWiki is on the same server. The STRICT_TRANS_TABLES mode is not enabled.
--
View this message in context:
http://xwiki.475771.n2.nabble.com/Delete-page-Error-number-0-in-3-Exception…
Sent from the XWiki- Users mailing list archive at Nabble.com.
4:22 p.m.
Finally solved this problem, the Auto Increment in the xwikirecyclebin Column
Xdd_ID was unchecked.
Since I checked this button, I can delete pages again.
--
View this message in context:
http://xwiki.475771.n2.nabble.com/Delete-page-Error-number-0-in-3-Exception…
Sent from the XWiki- Users mailing list archive at Nabble.com.
4:29 p.m.
Also for the table xwikiattrecyclebin Column XDA_ID auto increment was
unchecked.
When check this button, Attachments can be removed.
Thanks for your fast response and your tips.
--
View this message in context:
http://xwiki.475771.n2.nabble.com/Delete-page-Error-number-0-in-3-Exception…
Sent from the XWiki- Users mailing list archive at Nabble.com.
6:18 p.m.
Hi,
Glad that you solve it. Do you know why you had a column with autoincrement removed?
Normally you shouldn’t have this by default AFAIK. Does it mean someone had played with
the schema on your side?
Thanks
-Vincent
On 20 Oct 2015 at 16:22:40, LA (l-aaldering@jazo.eu(mailto:l-aaldering@jazo.eu)) wrote:
Finally solved this problem, the Auto Increment in the
xwikirecyclebin Column
Xdd_ID was unchecked.
Since I checked this button, I can delete pages again.
--
View this message in context:
http://xwiki.475771.n2.nabble.com/Delete-page-Error-number-0-in-3-Exception…
21 Oct
21 Oct
7:42 a.m.
No, I don't know. Probably it has happen in the proces of migrating from
Windows Mysql to Linux Mysql.
--
View this message in context:
http://xwiki.475771.n2.nabble.com/Delete-page-Error-number-0-in-3-Exception…
Sent from the XWiki- Users mailing list archive at Nabble.com.
9:01 a.m.
Ok thanks anyway. This is good information. I don’t remember seeing this before on this
list so I’m sure it’ll help future users.
Thanks
-Vincent
On 21 Oct 2015 at 07:42:22, LA (l-aaldering(a)jazo.eu) wrote:
No, I don't know. Probably it has happen in the proces of migrating from
Windows Mysql to Linux Mysql.
View this message in context:
http://xwiki.475771.n2.nabble.com/Delete-page-Error-number-0-in-3-Exception…
Sent from the XWiki- Users mailing list archive at Nabble.com.
3349
days inactive
3362
days old
20 comments
5 participants
participants (5)
-
Hamster -
LA -
Marius Dumitru Florea -
Thomas Mortagne -
vincent＠massol.net