于 2011/10/27 19:39, Thomas Mortagne 写道: > On Thu, Oct 27, 2011 at 1:14 PM, Yang Li<yang.lee.c...@gmail.com> wrote: >> 于 2011/10/27 16:24, Thomas Mortagne 写道: >>> On Wed, Oct 26, 2011 at 7:22 PM, Yang Li<yang.lee.c...@gmail.com> wrote: >>>> 于 2011/10/27 1:16, Thomas Mortagne 写道: >>>>> On Wed, Oct 26, 2011 at 4:18 PM, Yang Li<yang.lee.c...@gmail.com> >>>>> wrote: >>>>>> Hi all, >>>>>> >>>>>> We tried xwiki a month ago with the standalone vertion including jetty >>>>>> and hsqldb. And now we changed jetty to Tomcat for better performances >>>>>> which is easy. However, we also want to change the database from hsqldb >>>>>> to mysql because the there is a database size limit for hsqldb. But it >>>>>> is difficult. We tried to export the wiki pages (including the user >>>>>> registration infomation), however the pages with chinese characters as >>>>>> their names has encoding problems, that is, their contents are all right >>>>>> in utf8, however the names have disordered codes. >>>>> You sure your MySQL database use UTF8 charset ? >>>>> >>>>> Where exactly to you see that page names are wrong ? After importing >>>>> the xar ? In the xar itself ? >>>>> >>>> MySQL use utf8 for sure. After exporting the xar, I use winrar to open >>>> the xar files, where the page name are wrong. >>> If you are talking about the files names they could be anything it's >>> not very important, the real page name is in each xml file. >>> >>>> However, when they are imported into the xwiki, the names become right. >>>>>> We also tried to use the Large Wiki Export, but got no lucky. It simply >>>>>> doest work at all :( >>>>> What error do you get ? >>>>> >>>>> Note that if you are able to export your wiki with standard export UI >>>>> there is no reason to use large export script which is here only when >>>>> the wiki is too big for the allocated memory. >>>>> >>>> The reason is that I want to change the database from hsqldb to mysql, >>>> and I can export but I cannot import >>>> from the standard import UI. >>>> >>>> The large wiki import worked once....and now doesn't work any more, >>>> which drives me mad : ( >>> Same question: any error ? You should get some log of the import on server >>> side. >>> >>>>>> Any suggestions? >>>>>> >>>>>> Thank you all! >>>>>> _______________________________________________ >>>>>> 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 >>>> >>> >> I have such items in my logs, do you know why? >> >> 严重: The web application [/xwiki] created a ThreadLocal with key of >> type [org.jboss.cache.invocation.InvocationContextContainer] (value >> [org.jboss.cache.invocation.InvocationContextContainer@17bb813]) and a >> value of type [org.jboss.cache.invocation.MVCCInvocationContext] (value >> [InvocationContext{transaction=null, globalTransaction=null, >> transactionContext=null, optionOverrides=Option{failSilently=false, >> cacheModeLocal=false, dataVersion=null, suppressLocking=false, >> lockAcquisitionTimeout=-1, forceDataGravitation=false, >> skipDataGravitation=false, forceAsynchronous=false, >> forceSynchronous=false, suppressPersistence=false, >> suppressEventNotification=false}, originLocal=true, >> bypassUnmarshalling=false}]) but failed to remove it when the web >> application was stopped. Threads are going to be renewed over time to >> try and avoid a probable memory leak. > Not really but I doubt you get that during import. Looks like an error > when tomcat is stopping. > Yes, when I tried to import something into xe3.1 with the Large Wiki Import script, nothing happens, and the page just refreshed... When I tried the same thing on xe3.2 with exactly the same Large Wiki Import script with the xar file in the tomcat working direction, a table showed up and warned me about "overide with version, overide without version...", and it worked. Very tricky. I also tried other extensions like ExportImport and tried the export by date and so on, non of them worked.
So, these memory leak problems are not that important, right? Besides, I have some questions. When I tried the standalone xe, I found there was a long startup time, usually up to 10 minutes and took up more memory. However, the xe ran fast after the startup. I wounder whether it is because of the hsqldb that has to be loaded into the memory. Because when I transferred to MySQL, I find less memory are needed and a faster startup time (less than 1 minutes). However, a little bit slower performance. Besides, pages with the activity macro are slow to load, including the profile page. Our XE is running on Windows Server 2003 (x86), with 4 processors and 8G memory. Tomcat 7.0.22 and MySQL5.5.17-win32 and Java 1.6 >> I am running xwiki with tomcat/mysql. >> Thanks! >> _______________________________________________ >> 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
