Hi Ricardo, I've tried the dump you sent and it worked perfectly fine... Here's what I did: 1) dropped existing xwiki database 2) created it again and assigned permissions 3) imported the dump 4) unzippped the HSQLDB zip distribution 5) removed the database/ dir 6) copied the mysql 5.1.5 connector driver 7) edited the hibernate.cfg.xml file and removed the HSQLDB section and uncommented the MySQL one without changing a single line 8) started xwiki with the start_xwiki.sh script 9) opened a browser and called http://localhost:8080/xwiki/bin/view/Main/ 10) navigated to other pages Thanks -Vincent On Feb 25, 2008, at 1:59 PM, [Ricardo Rodriguez] Your EPEC Network ICT Team wrote:

Trying to answer to Vincent about Toucan use I am facing a problem while updating a 1.3M1 to 1.3M2 in my test box.

Here the error:

javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences Wrapped Exception: Error number 3211 in 3: Exception while updating archive XWiki.XWikiPreferences Wrapped Exception: Error number 3212 in 3: Exception while loading archive 104,408,758 Wrapped Exception: Error number 0 in 3: Exception while hibernate execute Wrapped Exception: Null value was assigned to a property of primitive type setter of com.xpn.xwiki.doc.rcs.XWikiRCSNodeInfo.diff

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)

I am using the same MySQL connector than with 1.3M1, mysql-connector-java-5.1.5-bin, and hibernate has been edited to uncomment and set up a MySQL connection. I noticed that hibernate includes a new line (or at least it is I think the first time I read it) in the MySQL configuration comment:

We need to set the sql_mode to a less strict value, see XWIKI-1945

And connection.url is slightly different:

jdbc:mysql://localhost/xwiki? useServerPrepStmts=false&sessionVariables=sql_mode=''

Perhaps I am doing something wrong, but I think I am following the same proces I've used before.

Thanks for your help,

Ricardo

-- Ricardo Rodríguez Your EPEC Network ICT Team

_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users

[Ricardo Rodriguez] Your EPEC Network ICT Team wrote:

Vincent Massol wrote:

...

Hi Ricardo,

I've tried the dump you sent and it worked perfectly fine... Here's what I did:

Some more information on this issue, now once I've moved ahead to 1.3RC1. I can now reproduce the issue. It only happens once when the servlet container is restarted. The first time I access any wiki, the main one (controller) or any virtual one, the same error message appears. It is the same posted before... javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences Wrapped Exception: Error number 3211 in 3: Exception while updating archive XWiki.XWikiPreferences Wrapped Exception: Error number 3212 in 3: Exception while loading archive 104,408,758 Wrapped Exception: Error number 0 in 3: Exception while hibernate execute Wrapped Exception: Null value was assigned to a property of primitive type setter of com.xpn.xwiki.doc.rcs.XWikiRCSNodeInfo.diff 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) If I hit the reload page button in the browser, the page loads just fine. While this exception is shown in the browser, here the output in catalina.out: sh-3.2# tail -n1000 catalina.out | grep com.xpn.xwiki.XWikiExceptio 2008-03-01 00:07:06,192 [] [http-80-3] WARN action.RequestProcessor - Unhandled Exception thrown: class com.xpn.xwiki.XWikiException 2008-03-01 00:07:50,602 [] [http-80-3] WARN action.RequestProcessor - Unhandled Exception thrown: class com.xpn.xwiki.XWikiException 2008-03-01 00:07:58,703 [] [http-80-7] WARN action.RequestProcessor - Unhandled Exception thrown: class com.xpn.xwiki.XWikiException 2008-03-01 00:08:17,321 [] [http-80-3] WARN action.RequestProcessor - Unhandled Exception thrown: class com.xpn.xwiki.XWikiException 2008-03-01 00:08:23,146 [] [http-80-8] WARN action.RequestProcessor - Unhandled Exception thrown: class com.xpn.xwiki.XWikiException 2008-03-01 00:08:28,954 [] [http-80-13] WARN action.RequestProcessor - Unhandled Exception thrown: class com.xpn.xwiki.XWikiException 2008-03-01 00:19:18,933 [] [http-80-1] WARN action.RequestProcessor - Unhandled Exception thrown: class com.xpn.xwiki.XWikiException 2008-03-01 00:24:01,840 [] [http-80-1] WARN action.RequestProcessor - Unhandled Exception thrown: class com.xpn.xwiki.XWikiException Each of these entries corresponds with each failure. Once the page loads after the reload, some other warning messages are recorded. Here a record that shows the correct migration of all databases, a first failure throwing the expection pasted before and the warning messages recorded after hitting the reload button. http://tinyurl.com/3y9ljz Once the page is reloaded, any new access only throws the warning messages. I I restart the server, the error message happens again. Hope this has some sense for you. Please, let me know how I could be of any further help. Thank you. Best regards, Ricardo -- Ricardo Rodríguez Your EPEC Network ICT Team

Please, allow me to post this for our reference... http://rafb.net/p/Ek4UlE10.html http://mire.environmentalchange.net/~webmaster/txt/ApiUser13RC1.txt Regards, Ricardo -- Ricardo Rodríguez Your EPEC Network ICT Team

Hi, The solution to this issue has been discussed out of the list and I've not created a Jira Issue for it. As it seems to affect only to a given update path, how and where must it be documented? Thank you, Ricardo -- Ricardo Rodríguez Your EPEC Network ICT Team

Hi Vincent, Vincent Massol wrote:

Isn't this the same as http://jir​ a.xwiki.or​g/jira/bro​wse/XWIKI-​ 1736? <http://jira.xwiki.org/jira/browse/XWIKI-1736>

Ludovic has had the same exception reported today and was asking me if I knew how to fix it. I couldn't find a solution in this thread.

What was the outcome and how did you solve it Ricardo?

We have been chatting about this in the #IRC channel on March the 7th. I remember we have considered this issue at some moment, but it seems it is not the same problem. Here the explanation and the solutions posted by Sergiu: <envelope> <sender hostmask="[email protected]">sdumitriu</sender> <message id="NUUF7K1PPN1" received="2008-03-07 02:03:20 +0100">So the problem is</message> <message id="VUD4F22PPN1" received="2008-03-07 02:03:38 +0100">- You used 1.2 M1</message> <message id="F9R77M2PPN1" received="2008-03-07 02:03:58 +0100">- 1.2 M1 did not contain a minimum length for the XWR_PATCH column</message> </envelope> <envelope> <sender self="yes" hostmask="[email protected]">rrodriguez</sender> <message id="XHUGKS2PPN1" received="2008-03-07 02:04:04 +0100">that is sure. In fact I received a warning from Vincent for doing that <span class="emoticon smile"><samp>:-)</samp></span></message> </envelope> <envelope> <sender hostmask="[email protected]">sdumitriu</sender> <message id="S8WKE63PPN1" received="2008-03-07 02:04:18 +0100">- Thus, it was created as "text", which is small</message> <message id="TTE5GX3PPN1" received="2008-03-07 02:04:45 +0100">- Hibernate does not update column definitions</message> <message id="U912KA5PPN1" received="2008-03-07 02:05:34 +0100">- XWikiPreferences is poorly designed, so it is HUGE when exported as XML</message> <message id="IEVO8J6PPN1" received="2008-03-07 02:06:19 +0100">- On top of that, there seems to be a bug either in hibernate on in XWiki, as it allows partial commit of a transaction, or it doesn't use a transaction at all</message> <message id="FDMB3Z6PPN1" received="2008-03-07 02:06:35 +0100">What we can do now</message> <message id="M4PBI79PPN1" received="2008-03-07 02:07:55 +0100">- The fast workaround is to write a migrator that checks if the column is of type text instead of longtext, and if so, to manually update it, and delete all the bad columns</message> <message id="DS82GT9PPN1" received="2008-03-07 02:08:17 +0100">- The longterm idea is to solve the transaction bug</message> <message id="FMT1C3APPN1" received="2008-03-07 02:08:27 +0100">and to recover from such errors</message> <message id="TI7MJJAPPN1" received="2008-03-07 02:08:43 +0100">Now, I hope there aren't many users that used 1.2M1</message> </envelope> <envelope> <sender self="yes" hostmask="[email protected]">rrodriguez</sender> <message id="FLYO8KCPPN1" received="2008-03-07 02:09:56 +0100">At least another server: our production one</message> </envelope> <envelope> <sender hostmask="[email protected]">sdumitriu</sender> <message id="LYX9FGDPPN1" received="2008-03-07 02:10:28 +0100">Well, you know what to do</message> <message id="JN73EPPN1" received="2008-03-07 02:10:51 +0100">alter table xwikircs modify column xwr_patch longtext;</message> <message id="QQRZHCEPPN1" received="2008-03-07 02:11:00 +0100">delete from xwikircs where xwr_isdiff is null;</message> <message id="Y98QKFEPPN1" received="2008-03-07 02:11:03 +0100">restart</message> </envelope> When Ludovic got the same exception reported, I tried to reconstruct the flow and find that we have not documented the solution. I keep asking how is the best way of doing it. HTH, Ricardo -- Ricardo Rodríguez Your EPEC Network ICT Team

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

[Ricardo Rodriguez] Your EPEC Network ICT Team wrote:

It seems to me clear that the only problem is that the allowed number of connections to MySQL has been reached.

Could XWiki upgrade need much more connections than previous releases?

I will set a larger value for this variable and report back with results.

Thanks,

Ricardo

Please, consider this output if you try to debug the problem... SHOW FULL PROCESSLIST http://mire.environmentalchange.net/~webmaster/html/MySQLXWikiProcesses.html Thanks!! -- Ricardo Rodríguez Your EPEC Network ICT Team

Just one more entry: top output before rebooting: top - 22:27:32 up 45 days, 12:03, 3 users, load average: 2.17, 2.12, 2.05 Tasks: 217 total, 3 running, 214 sleeping, 0 stopped, 0 zombie Cpu(s): 50.3% us, 0.2% sy, 0.0% ni, 48.8% id, 0.7% wa, 0.0% hi, 0.0% si Mem: 3111536k total, 3018744k used, 92792k free, 31224k buffers Swap: 1052216k total, 1052216k used, 0k free, 109976k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 24143 root 25 0 706m 586m 8364 S 99.9 19.3 80:44.78 java 4190 root 16 0 114m 4156 3064 S 0.3 0.1 119:50.80 httpstkd 18730 root 16 0 2816 1456 1084 R 0.3 0.0 0:16.10 top 1 root 16 0 588 76 44 S 0.0 0.0 0:17.12 init 2 root RT 0 0 0 0 S 0.0 0.0 0:00.04 migration/0 3 root 34 19 0 0 0 S 0.0 0.0 0:00.03 ksoftirqd/0 4 root RT 0 0 0 0 S 0.0 0.0 0:00.02 migration/1 5 root 34 19 0 0 0 S 0.0 0.0 0:00.03 ksoftirqd/1 6 root 5 -10 0 0 0 S 0.0 0.0 0:00.02 events/0 7 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/1 8 root 14 -10 0 0 0 S 0.0 0.0 0:00.01 khelper 9 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 kacpid 66 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 kblockd/0 67 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 kblockd/1 86 root 15 0 0 0 0 S 0.0 0.0 0:00.00 kirqd 91 root 16 0 0 0 0 S 0.0 0.0 0:48.19 kswapd0 92 root 9 -10 0 0 0 S 0.0 0.0 0:00.00 aio/0 Cheers, Ricardo -- Ricardo Rodríguez Your EPEC Network ICT Team