Re: [xwiki-users] HELP: Cannot save new panel layout and preferences while logged in as Admin
Hi Vincent, Yes, you're right but according to xwiki-992 at jira.xwiki.org I thought that issue was not completely settled yet. That's why I decided for this new thread. Well, I tried something else! What? I decided to import xwiki-1.0.xar again. My skin remained intact because I copied the default skin to a new skin, and I used that at the very beginning when setting up the wiki about a month ago now. Next I changed from the default skin to our own one, rearranged the panels, menus and voila saving the layout and preferences was no more problem! After that I still had to fine tune the access rights! Maybe this little experiment is of value to you, any way it seems that everything is working properly again! Regards, Gerard
[email protected] 06/09/2007 13:39 >>> Hi Gerard,
I thought I had already answered you about this this morning... I'll repeat my suggestion: try tweaking the HBM file for PostGreSQL. Alternatively try using a different database (like MYSQL) if you can as I believe the problem is why PostGreSQL. Last, check the online mail archives since several people got XWiki working with PostGreSQL with some tweakings. Thanks -Vincent On Sep 6, 2007, at 12:08 PM, Geert Verhaag wrote:
Hi XWiki Users,
I try to start a new thread about this problem, because the problem is very urgent.
This matter has been a topic around April this year as I found at jira.xwiki.org (key: xwiki-992: Cannot save new panel layout while logged in as Admin), but wasn't really solved if I understand it all well!
I experience problems saving both my layout and preferences, getting the following message:
Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences Wrapped Exception: Could not execute JDBC batch update com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences Wrapped Exception: Could not execute JDBC batch update at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc (XWikiHibernateStore.java:314) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc (XWikiCacheStore.java:100) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc (XWikiCacheStore.java:94) at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:914) at com.xpn.xwiki.web.SaveAction.save(SaveAction.java:114) at com.xpn.xwiki.web.SaveAction.action(SaveAction.java:123) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:149) at org.apache.struts.action.RequestProcessor.processActionPerform (RequestProcessor.java:431) at org.apache.struts.action.RequestProcessor.process (RequestProcessor.java:236) at org.apache.struts.action.ActionServlet.process(ActionServlet.java: 1196) at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:188) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter (SetCharacterEncodingFilter.java:118) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke (StandardWrapperValve.java:210) at org.apache.catalina.core.StandardContextValve.invoke (StandardContextValve.java:174) at org.apache.catalina.core.StandardHostValve.invoke (StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke (StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service (CoyoteAdapter.java:151) at org.apache.coyote.http11.Http11Processor.process (Http11Processor.java:870) at org.apache.coyote.http11.Http11BaseProtocol $Http11ConnectionHandler.processConnection(Http11BaseProtocol.java: 665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket (PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt (LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run (ThreadPool.java:685) at java.lang.Thread.run(Unknown Source)
Wrapped Exception:
java.sql.BatchUpdateException: Batch entry 0 update xwikidoc set XWD_ARCHIVE=head .....
Our consideration using xwiki for our institute's wiki site is in danger because of this error! Currently I'm unable to continue configuring it properly.
I use XWiki version 1.0.3342 in combination with PostgreSQL-8.2, TomCat 5.5 and jdk-6u2!
The strange thing is that it has been working properly at the beginning. Setting up the layout, preferences, and saving it all wasn't a problem!
Thanks!
Regards, Gerard
==========================================
Dit bericht is uitsluitend bestemd voor de geadresseerde. Het bericht kan vertrouwelijke informatie bevatten. Als u dit bericht per abuis hebt ontvangen, wordt u verzocht onmiddellijk de afzender te informeren. Ook verzoeken wij u het bericht te vernietigen en de inhoud niet onder derden te verspreiden of te gebruiken.
This message is intended exclusively for the addressee. It may contain information that is confidential. If you are not the intended recipient, we request that you notify the sender immediately. In that case, we also request that you destroy the message and that you neither use the contents nor disclose them in any manner to third parties. ==========================================
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users ========================================== Dit bericht is uitsluitend bestemd voor de geadresseerde. Het bericht kan vertrouwelijke informatie bevatten. Als u dit bericht per abuis hebt ontvangen, wordt u verzocht onmiddellijk de afzender te informeren. Ook verzoeken wij u het bericht te vernietigen en de inhoud niet onder derden te verspreiden of te gebruiken. This message is intended exclusively for the addressee. It may contain information that is confidential. If you are not the intended recipient, we request that you notify the sender immediately. In that case, we also request that you destroy the message and that you neither use the contents nor disclose them in any manner to third parties. ==========================================
Hi Gerard, On Sep 6, 2007, at 2:52 PM, Geert Verhaag wrote:
Hi Vincent,
Yes, you're right but according to xwiki-992 at jira.xwiki.org I thought that issue was not completely settled yet. That's why I decided for this new thread.
As you can see on http://jira.xwiki.org/jira/browse/XWIKI-992, we have closed it since we couldn't reproduce it.
Well, I tried something else! What?
I decided to import xwiki-1.0.xar again. My skin remained intact because I copied the default skin to a new skin, and I used that at the very beginning when setting up the wiki about a month ago now. Next I changed from the default skin to our own one, rearranged the panels, menus and voila saving the layout and preferences was no more problem! After that I still had to fine tune the access rights!
Maybe this little experiment is of value to you, any way it seems that everything is working properly again!
Cool. However the problem remains a mystery ;) Thanks -Vincent
[email protected] 06/09/2007 13:39 >>> Hi Gerard,
I thought I had already answered you about this this morning...
I'll repeat my suggestion: try tweaking the HBM file for PostGreSQL.
Alternatively try using a different database (like MYSQL) if you can as I believe the problem is why PostGreSQL.
Last, check the online mail archives since several people got XWiki working with PostGreSQL with some tweakings.
Thanks -Vincent
On Sep 6, 2007, at 12:08 PM, Geert Verhaag wrote:
Hi XWiki Users,
I try to start a new thread about this problem, because the problem is very urgent.
This matter has been a topic around April this year as I found at jira.xwiki.org (key: xwiki-992: Cannot save new panel layout while logged in as Admin), but wasn't really solved if I understand it all well!
I experience problems saving both my layout and preferences, getting the following message:
Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences Wrapped Exception: Could not execute JDBC batch update com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences Wrapped Exception: Could not execute JDBC batch update at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc (XWikiHibernateStore.java:314) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc (XWikiCacheStore.java:100) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc (XWikiCacheStore.java:94) at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:914) at com.xpn.xwiki.web.SaveAction.save(SaveAction.java:114) at com.xpn.xwiki.web.SaveAction.action(SaveAction.java:123) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:149) at org.apache.struts.action.RequestProcessor.processActionPerform (RequestProcessor.java:431) at org.apache.struts.action.RequestProcessor.process (RequestProcessor.java:236) at org.apache.struts.action.ActionServlet.process(ActionServlet.java: 1196) at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:188) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter (SetCharacterEncodingFilter.java:118) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke (StandardWrapperValve.java:210) at org.apache.catalina.core.StandardContextValve.invoke (StandardContextValve.java:174) at org.apache.catalina.core.StandardHostValve.invoke (StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke (StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service (CoyoteAdapter.java:151) at org.apache.coyote.http11.Http11Processor.process (Http11Processor.java:870) at org.apache.coyote.http11.Http11BaseProtocol $Http11ConnectionHandler.processConnection(Http11BaseProtocol.java: 665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket (PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt (LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run (ThreadPool.java:685) at java.lang.Thread.run(Unknown Source)
Wrapped Exception:
java.sql.BatchUpdateException: Batch entry 0 update xwikidoc set XWD_ARCHIVE=head .....
Our consideration using xwiki for our institute's wiki site is in danger because of this error! Currently I'm unable to continue configuring it properly.
I use XWiki version 1.0.3342 in combination with PostgreSQL-8.2, TomCat 5.5 and jdk-6u2!
The strange thing is that it has been working properly at the beginning. Setting up the layout, preferences, and saving it all wasn't a problem!
Thanks!
Regards, Gerard
==========================================
Dit bericht is uitsluitend bestemd voor de geadresseerde. Het bericht kan vertrouwelijke informatie bevatten. Als u dit bericht per abuis hebt ontvangen, wordt u verzocht onmiddellijk de afzender te informeren. Ook verzoeken wij u het bericht te vernietigen en de inhoud niet onder derden te verspreiden of te gebruiken.
This message is intended exclusively for the addressee. It may contain information that is confidential. If you are not the intended recipient, we request that you notify the sender immediately. In that case, we also request that you destroy the message and that you neither use the contents nor disclose them in any manner to third parties. ==========================================
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
==========================================
Dit bericht is uitsluitend bestemd voor de geadresseerde. Het bericht kan vertrouwelijke informatie bevatten. Als u dit bericht per abuis hebt ontvangen, wordt u verzocht onmiddellijk de afzender te informeren. Ook verzoeken wij u het bericht te vernietigen en de inhoud niet onder derden te verspreiden of te gebruiken.
This message is intended exclusively for the addressee. It may contain information that is confidential. If you are not the intended recipient, we request that you notify the sender immediately. In that case, we also request that you destroy the message and that you neither use the contents nor disclose them in any manner to third parties. ==========================================
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
On 9/6/07, Vincent Massol <[email protected]> wrote:
Hi Gerard,
On Sep 6, 2007, at 2:52 PM, Geert Verhaag wrote:
Hi Vincent,
Yes, you're right but according to xwiki-992 at jira.xwiki.org I thought that issue was not completely settled yet. That's why I decided for this new thread.
As you can see on http://jira.xwiki.org/jira/browse/XWIKI-992, we have closed it since we couldn't reproduce it.
Well, I tried something else! What?
I decided to import xwiki-1.0.xar again. My skin remained intact because I copied the default skin to a new skin, and I used that at the very beginning when setting up the wiki about a month ago now. Next I changed from the default skin to our own one, rearranged the panels, menus and voila saving the layout and preferences was no more problem! After that I still had to fine tune the access rights!
Maybe this little experiment is of value to you, any way it seems that everything is working properly again!
Cool. However the problem remains a mystery ;)
I think that the XWiki.XWikiPreferences document somehow got into a fragile state. Either the archive field got too big, and couldn't be updated anymore, or it simply got corrupt. Perhaps the new archive mechanism from 1.2 will prevent this error to occur. Sergiu -- http://purl.org/net/sergiu
participants (3)
-
Geert Verhaag -
Sergiu Dumitriu -
Vincent Massol