Re: [xwiki-users] Delete page - Error number 0 in 3: Exception while hibernate execute

[vinc...@massol.net]

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-aalder...@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-while-hibernate-execute-tp7596386p7596554.html
  
Sent from the XWiki- Users mailing list archive at Nabble.com.  
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Delete page - Error number 0 in 3: Exception while hibernate execute

[vinc...@massol.net]

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-aalder...@jazo.eu(mailto:l-aalder...@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
>  
>  
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Delete page - Error number 0 in 3: Exception while hibernate execute

[LA]

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-while-hibernate-execute-tp7596386p7596536.html
Sent from the XWiki- Users mailing list archive at Nabble.com.
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Delete page - Error number 0 in 3: Exception while hibernate execute

[LA]

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-while-hibernate-execute-tp7596386p7596538.html
Sent from the XWiki- Users mailing list archive at Nabble.com.
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Delete page - Error number 0 in 3: Exception while hibernate execute

[LA]

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-while-hibernate-execute-tp7596386p7596534.html
Sent from the XWiki- Users mailing list archive at Nabble.com.
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Delete page - Error number 0 in 3: Exception while hibernate execute

[vinc...@massol.net]

On 20 Oct 2015 at 10:42:47, LA 
(l-aalder...@jazo.eu(mailto:l-aalder...@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

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Delete page - Error number 0 in 3: Exception while hibernate execute

[LA]

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-while-hibernate-execute-tp7596386p7596543.html
Sent from the XWiki- Users mailing list archive at Nabble.com.
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Delete page - Error number 0 in 3: Exception while hibernate execute

[vinc...@massol.net]

Hi,
 
So I checked our schema and the XDD_ID field is the primary key for the Deleted 
Documents table:

    
        
            
        

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-have-a-default-values)?

What version of mysql are you running?

Thanks
-Vincent

On 20 Oct 2015 at 10:53:33, LA 
(l-aalder...@jazo.eu(mailto:l-aalder...@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-while-hibernate-execute-tp7596386p7596538.html
> Sent from the XWiki- Users mailing list archive at Nabble.com.

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Delete page - Error number 0 in 3: Exception while hibernate execute

[LA]

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-while-hibernate-execute-tp7596386p7596550.html
Sent from the XWiki- Users mailing list archive at Nabble.com.
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Delete page - Error number 0 in 3: Exception while hibernate execute

[LA]

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-while-hibernate-execute-tp7596386p7596549.html
Sent from the XWiki- Users mailing list archive at Nabble.com.
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Delete page - Error number 0 in 3: Exception while hibernate execute

[vinc...@massol.net]

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-aalder...@jazo.eu(mailto:l-aalder...@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-while-hibernate-execute-tp7596386p7596549.html

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Delete page - Error number 0 in 3: Exception while hibernate execute

[LA]

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-while-hibernate-execute-tp7596386p7596554.html
Sent from the XWiki- Users mailing list archive at Nabble.com.
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Delete page - Error number 0 in 3: Exception while hibernate execute

[Thomas Mortagne]

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  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-while-hibernate-execute-tp7596386p7596402.html
> Sent from the XWiki- Users mailing list archive at Nabble.com.
> ___
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users



-- 
Thomas Mortagne
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Delete page - Error number 0 in 3: Exception while hibernate execute

[Hamster]

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-while-hibernate-execute-tp7596386p7596402.html
Sent from the XWiki- Users mailing list archive at Nabble.com.
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Delete page - Error number 0 in 3: Exception while hibernate execute

[Marius Dumitru Florea]

On Fri, Oct 9, 2015 at 11:31 AM, Hamster  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-while-hibernate-execute-tp7596386p7596402.html
> Sent from the XWiki- Users mailing list archive at Nabble.com.
> ___
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
>
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Delete page - Error number 0 in 3: Exception while hibernate execute

[Hamster]

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-while-hibernate-execute-tp7596386p7596407.html
Sent from the XWiki- Users mailing list archive at Nabble.com.
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Delete page - Error number 0 in 3: Exception while hibernate execute

[vinc...@massol.net]

Hi Hamster,

On 8 Oct 2015 at 12:46:44, Hamster 
(teun...@hotmail.com(mailto:teun...@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

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Delete page - Error number 0 in 3: Exception while hibernate execute

[Hamster]

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-while-hibernate-execute-tp7596386p7596390.html
Sent from the XWiki- Users mailing list archive at Nabble.com.
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Delete page - Error number 0 in 3: Exception while hibernate execute

[Marius Dumitru Florea]

On Thu, Oct 8, 2015 at 4:05 PM, Hamster  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-while-hibernate-execute-tp7596386p7596390.html
> Sent from the XWiki- Users mailing list archive at Nabble.com.
> ___
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
>
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Delete page - Error number 0 in 3: Exception while hibernate execute

[Hamster]

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-while-hibernate-execute-tp7596386p7596392.html
Sent from the XWiki- Users mailing list archive at Nabble.com.
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users