20 Mar
2008
20 Mar
'08
10:03 a.m.
Hi,
Sergiu Dumitriu wrote:
Update: I debugged it with the Curriki guys, and the
problem was that
while the setup should have been UTF-8, mysql was not configured
properly, so xwikircs and xwikirecyclebin were created with latin1, so
their problem was indeed pure XWIKI-1736, nothing else.
The problem Ricardo had was a bit more complex, xwikircs was created
with a shorter length for the xwr_patch field than it is specified now
in the mapping file, because the length released with 1.2M1 was not
specified at all, so Hibernate selected a length on its own.
I am in our production server now. I think I have followed the steps we
have done in the test box, but I am getting something new.
After correcting xwr_patch and set up xwiki.cfg to force migration in
all virtual wikis with the lines...
xwiki.store.migration.databases=all
xwiki.store.migration.force=com.xpn.xwiki.store.migration.hibernate.R6079XWIKI1878Migrator
I get this...
*****
HTTP Status 500 -
type Exception report
message
description The server encountered an internal error () that prevented
it from fulfilling this request.
exception
javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error
number 3 in 0: Could not initialize main XWiki context
Wrapped Exception: Error number 3001 in 3: Cannot load class
com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager
from param xwiki.store.migration.manager.class
Wrapped Exception: Error number 0 in 3: Exception while hibernate execute
Wrapped Exception: Could not create a DBCP pool
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
root cause
com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize
main XWiki context
Wrapped Exception: Error number 3001 in 3: Cannot load class
com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager
from param xwiki.store.migration.manager.class
Wrapped Exception: Error number 0 in 3: Exception while hibernate execute
Wrapped Exception: Could not create a DBCP pool
com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:302)
com.xpn.xwiki.XWiki.getXWiki(XWiki.java:490)
com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:118)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
note The full stack trace of the root cause is available in the Apache
Tomcat/6.0.10 logs.
Apache Tomcat/6.0.10
*****
All databases are 7351 now, BUT I am getting frequently Could not
connect to MySQL instance at mire.environmentalchange.net. Error: Too
many connections (code 1040)
MySQL is now MySQL 5.0.24a via TCP/IP.
Sorry if I am missing something obvious. Any hint? The problem is mostly
related to MySQL and nothing to do with XWiki?
I will wait for your feedback prior to try anything else... well, I've
not many options on my own :-(
Thank you for your help,
Ricardo
--
Ricardo RodrÃguez
Your EPEC Network ICT Team