[xwiki-users] History throws exceptions
Hi all, we use XEM for a little xwiki Farm, now we have problems with our History. If i look at a previews version of an document i get the error show here --> http://pastebin.centos.org/9499 I thougt update to 1.4 will fix this. But nothing happend. Now i'm backu to the old version. On my CentOS 5.1 x86_64 box the following is installed Kernel 2.6.18-8.1.15.el5xen Java java version "1.6.0_03" Java(TM) SE Runtime Environment (build 1.6.0_03-b05) Java HotSpot(TM) 64-Bit Server VM (build 1.6.0_03-b05, mixed mode) xwiki-enterprise-hsqldb-1.2 "1.2.6932" with jetty (the XEM funktionality was added on a later date) Pluins for XEM xwiki-plugin-application-manager-1.0-rc-1.jar xwiki-plugin-wiki-manager-1.0-rc-1.jar Database is mysql Ver 14.12 Distrib 5.0.22, for redhat-linux-gnu (x86_64) using readline 5.0 mysql-connector-java-3.1.7-bin.jar Here is my xwiki.cfg http://pastebin.centos.org/9507 I think the database shema was not update, i was reading about a bug, but i don't find a soulution that works for me. Hope someone can help. Best regards Marco Weiß Kessler GmbH - Netzwerke und mehr Marco Weiss Gewerbegebiet 6 82399 Raisting Tel.: 08807 / 94 67 7 - 13 Fax: 08807 / 94 67 7 - 99 Mail: marco.weiss(at)kesslernetworks.de Web: www.kesslernetworks.de Sitz der Gesellschaft: Raisting Geschaeftsfuehrer: Florian Kessler HRB 163710
Marco Weiß wrote:
we use XEM for a little xwiki Farm, now we have problems with our History. If i look at a previews version of an document i get the error show here
Is this happen on any page? Is xwiki export/import is working? See below also.
I thougt update to 1.4 will fix this. But nothing happend.
Now i'm backu to the old version.
On my CentOS 5.1 x86_64 box the following is installed
Kernel 2.6.18-8.1.15.el5xen
Java java version "1.6.0_03" Java(TM) SE Runtime Environment (build 1.6.0_03-b05) Java HotSpot(TM) 64-Bit Server VM (build 1.6.0_03-b05, mixed mode)
xwiki-enterprise-hsqldb-1.2 "1.2.6932" with jetty (the XEM funktionality was added on a later date)
Pluins for XEM
xwiki-plugin-application-manager-1.0-rc-1.jar xwiki-plugin-wiki-manager-1.0-rc-1.jar
Database is mysql Ver 14.12 Distrib 5.0.22, for redhat-linux-gnu (x86_64) using readline 5.0 mysql-connector-java-3.1.7-bin.jar
Here is my xwiki.cfg http://pastebin.centos.org/9507
There is wrong migration configuration. Correct is: xwiki.store.migration=1 xwiki.store.migration.databases=oewxwiki (or all) Database migration is off with your configuration. Please turn it on and see what happened. See at xwiki.log while migration is running. -- Artem Melentyev
Am 16.07.2008 um 13:07 schrieb Artem Melentyev:
Marco Weiß wrote:
we use XEM for a little xwiki Farm, now we have problems with our History. If i look at a previews version of an document i get the error show here
Is this happen on any page? Is xwiki export/import is working? See below also.
Yes this happens on any page Do you meen the export/import of xar files? If yes it works. If no what export/import do you meen?
I thougt update to 1.4 will fix this. But nothing happend.
Now i'm backu to the old version.
On my CentOS 5.1 x86_64 box the following is installed
Kernel 2.6.18-8.1.15.el5xen
Java java version "1.6.0_03" Java(TM) SE Runtime Environment (build 1.6.0_03-b05) Java HotSpot(TM) 64-Bit Server VM (build 1.6.0_03-b05, mixed mode)
xwiki-enterprise-hsqldb-1.2 "1.2.6932" with jetty (the XEM funktionality was added on a later date)
Pluins for XEM
xwiki-plugin-application-manager-1.0-rc-1.jar xwiki-plugin-wiki-manager-1.0-rc-1.jar
Database is mysql Ver 14.12 Distrib 5.0.22, for redhat-linux-gnu (x86_64) using readline 5.0 mysql-connector-java-3.1.7-bin.jar
Here is my xwiki.cfg http://pastebin.centos.org/9507
There is wrong migration configuration. Correct is: xwiki.store.migration=1 xwiki.store.migration.databases=oewxwiki (or all)
Ok i changed this and tried again. My logfile tells me --> http://pastebin.centos.org/9558 And the xwiki page looks so --> http://pastebin.centos.org/9560
Database migration is off with your configuration. Please turn it on and see what happened. See at xwiki.log while migration is running.
-- Artem Melentyev _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Thx to you Kessler GmbH - Netzwerke und mehr Marco Weiss Gewerbegebiet 6 82399 Raisting Tel.: 08807 / 94 67 7 - 13 Fax: 08807 / 94 67 7 - 99 Mail: marco.weiss(at)kesslernetworks.de Web: www.kesslernetworks.de Sitz der Gesellschaft: Raisting Geschaeftsfuehrer: Florian Kessler HRB 163710
Marco Weiß wrote:
Am 16.07.2008 um 13:07 schrieb Artem Melentyev:
Marco Weiß wrote:
we use XEM for a little xwiki Farm, now we have problems with our History. If i look at a previews version of an document i get the error show here
--> http://pastebin.centos.org/9499 Is this happen on any page? Is xwiki export/import is working? See below also.
Yes this happens on any page
Is this happens on any virtual wikis and main wiki?
Do you meen the export/import of xar files? yes
If yes it works. If no what export/import do you meen?
You can try to export a whole wiki and import it in new version of xwiki. If export is working it is likely to resolve the problem. ...
Ok i changed this and tried again. My logfile tells me --> http://pastebin.centos.org/9558
And the xwiki page looks so --> http://pastebin.centos.org/9560
Exception says that archive is broken, but it is strange that all documents are affected. Is saving of document working? (Try to add comment, edit/save document) You can look at xwikircs db table. (sql example: select * from xwikircs where doc.XWR_DOCID=<somedocid>) If nothing will help, you can give me a dump of some affected database, and I'll look. -- Artem Melentyev
Am 17.07.2008 um 18:18 schrieb Artem Melentyev:
Marco Weiß wrote:
Am 16.07.2008 um 13:07 schrieb Artem Melentyev:
Marco Weiß wrote:
we use XEM for a little xwiki Farm, now we have problems with our History. If i look at a previews version of an document i get the error show here
--> http://pastebin.centos.org/9499 Is this happen on any page? Is xwiki export/import is working? See below also.
Yes this happens on any page
Is this happens on any virtual wikis and main wiki?
Yes that happens on any virtual wiki!
Do you meen the export/import of xar files? yes
If yes it works. If no what export/import do you meen?
You can try to export a whole wiki and import it in new version of xwiki. If export is working it is likely to resolve the problem.
Ok i exported a wiki with 50,8 MB as xar, i had to increase the max_upload in xwiki and max_allowed_packet size in mysql. But if i'll upload the file i get the followin error. http://pastebin.centos.org/9998
...
Ok i changed this and tried again. My logfile tells me --> http://pastebin.centos.org/9558
And the xwiki page looks so --> http://pastebin.centos.org/9560
Exception says that archive is broken, but it is strange that all documents are affected.
Is saving of document working? (Try to add comment, edit/save document)
That works fine, the wiki is productive, that means till today 30 user in my company works with this xwiki
You can look at xwikircs db table. (sql example: select * from xwikircs where doc.XWR_DOCID=<somedocid>)
from where can i get a DOCID?
If nothing will help, you can give me a dump of some affected database, and I'll look.
That's what will help me i think but i may not because of the sensetive datas in this wiki (passwords and so on... )
-- Artem Melentyev _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Best regards Marco Weiß Kessler GmbH - Netzwerke und mehr Marco Weiss Gewerbegebiet 6 82399 Raisting Tel.: 08807 / 94 67 7 - 13 Fax: 08807 / 94 67 7 - 99 Mail: marco.weiss(at)kesslernetworks.de Web: www.kesslernetworks.de Sitz der Gesellschaft: Raisting Geschaeftsfuehrer: Florian Kessler HRB 163710
Marco Weiß wrote:
... Ok i exported a wiki with 50,8 MB as xar, i had to increase the max_upload in xwiki and max_allowed_packet size in mysql. But if i'll upload the file i get the followin error. http://pastebin.centos.org/9998
You need to increase XWA_CONTENT field. See http://jira.xwiki.org/jira/browse/XWIKI-2339 You can also remove some pages inside xar (it is just zip package) and update package.xml to make it smaller.
...
Ok i changed this and tried again. My logfile tells me --> http://pastebin.centos.org/9558
And the xwiki page looks so --> http://pastebin.centos.org/9560 Exception says that archive is broken, but it is strange that all documents are affected.
Is saving of document working? (Try to add comment, edit/save document)
That works fine, the wiki is productive, that means till today 30 user in my company works with this xwiki
You can look at xwikircs db table. (sql example: select * from xwikircs where doc.XWR_DOCID=<somedocid>)
from where can i get a DOCID?
you have it in http://pastebin.centos.org/9499:
com.xpn.xwiki.XWikiException: Error number 3103 in 3: Exception while reading version [69.1] for document id [1 425 385 510] so 1425385510 is docid.
also it available from velocity: $doc.getId() -- Artem Melentyev
Am 21.07.2008 um 16:36 schrieb Artem Melentyev:
Marco Weiß wrote:
... Ok i exported a wiki with 50,8 MB as xar, i had to increase the max_upload in xwiki and max_allowed_packet size in mysql. But if i'll upload the file i get the followin error. http://pastebin.centos.org/9998
You need to increase XWA_CONTENT field. See http://jira.xwiki.org/jira/browse/XWIKI-2339
I hope i had understood it right, i used following to mysql commands on my database to increas it. ALTER TABLE xwikiattachment_content CHANGE XWA_CONTENT XWA_CONTENT LONGBLOB NOT NULL; ALTER TABLE xwikiattachment_archive CHANGE XWA_ARCHIVE XWA_ARCHIVE LONGBLOB NOT NULL; But it won't work i get now this message http://pastebin.centos.org/10120 Good the second failure brought me to increas the max_packet_size of my mysql database to 512M Yeha now i can upload the file. By clicking on the xar file two messages apears in the log file see http://pastebin.centos.org/10121 OK after importing i get thousands of lucene index update erroro like this http://pastebin.centos.org/10122 And xwiki wrotes that two documents have errors while importing these. But i don't think i have to worry about it, i think a new import from a fresh xar downloaded from the xwiki page will overwrites this on the other will be deleted. import_listoferrorsfiles * Main.howto_opi * Photos.NewAlbum But it's not over now, the history is gone away, no page has one. The Navigation panel, don't looks right the effect when clicking on a space is off. The panel wizard shows ugly white in white to 80% On the beginning it had looked good but in the end i have to say this way won't work for me. Do you have still have a idea?
You can also remove some pages inside xar (it is just zip package) and update package.xml to make it smaller.
...
Ok i changed this and tried again. My logfile tells me --> http://pastebin.centos.org/9558
And the xwiki page looks so --> http://pastebin.centos.org/9560 Exception says that archive is broken, but it is strange that all documents are affected.
Is saving of document working? (Try to add comment, edit/save document)
That works fine, the wiki is productive, that means till today 30 user in my company works with this xwiki
You can look at xwikircs db table. (sql example: select * from xwikircs where doc.XWR_DOCID=<somedocid>)
from where can i get a DOCID?
you have it in http://pastebin.centos.org/9499:
com.xpn.xwiki.XWikiException: Error number 3103 in 3: Exception while reading version [69.1] for document id [1 425 385 510] so 1425385510 is docid.
here i get these as answer mysql> select * from xwikircs where doc.XWR_DOCID=1425385510; ERROR 1054 (42S22): Unknown column 'doc.XWR_DOCID' in 'where clause'
also it available from velocity: $doc.getId()
ok thx thats nice
-- Artem Melentyev _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Kessler GmbH - Netzwerke und mehr Marco Weiss Gewerbegebiet 6 82399 Raisting Tel.: 08807 / 94 67 7 - 13 Fax: 08807 / 94 67 7 - 99 Mail: marco.weiss(at)kesslernetworks.de Web: www.kesslernetworks.de Sitz der Gesellschaft: Raisting Geschaeftsfuehrer: Florian Kessler HRB 163710
participants (2)
-
Artem Melentyev -
Marco Weiß