Up to Discussions in  Clearspace

This Question is Possibly Answered

1 "correct" answer available (4 pts)
7 Replies Last post: Jul 8, 2008 2:52 PM by Vinh  
Frederic Piard Novice
Frederic Piard
5 posts since
Jun 26, 2008
Currently Being Moderated

Jun 26, 2008 10:04 AM

Migrating from 1.10.1 to 2.0.4

Hi,

 

 

We are using Clearspace v.1.10.1 with the evaluation database (as it was easy to set-up) on Windows. Now we want to move Clearspace from one computer to another. We think it will be a good idea to upgrade our old version th the current one, so I hav einstalled Clearspace 2.0.4 on the same computer than the 1.10.1 and I have initiated the upgrade through  the migration menu from Clearspace 1.10.1 "System / Import-Export / Database Migration / Start Migration" with this parameters :

  • JDBC

  • databse driver presets :

  • JDBC Driver Class : com.jivesoftware.base.database.EmbeddedConnectionProvider

  • Databse URL : jdbc:hsqldb:C:\Program Files\Clearspace 2.0\database\jive_clearspace_hsqldb

  • Username : SA

  • Password :

  • Clic "Test Connection" :

    • I obtain : Success! The database server configuration parameters appear to be valid. Click the 'Start Migration' button below to being the migration process.

  • "Start Migration"

    • It starts to run, I see some elements and I got an error

  1. Status Code: 500
    # Exception Type:
    # Error Message: INTERNAL_SERVER_ERROR
    # Request URI: /clearspace/admin/database-migration-task.jspa
    # Stack Trace:
        * sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        * sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        * sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        * java.lang.reflect.Method.invoke(Unknown Source)
        * com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvoca tion.java:358)
        * com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(DefaultActionIn vocation.java:218)
        * com.opensymphony.webwork.interceptor.BackgroundProcess$1.run(BackgroundProcess. java:28)
        * java.lang.Thread.run(Unknown Source)
    # java.lang.reflect.InvocationTargetException

I also tried to directly move the data from the 1.10.1 version to the 2.0.4 folder and (as I expected) it does not works either, Clearspace 2.0 don't wants to run with this data.

 

I think this is somethong a lot of people should have done, but I haven't found any relevant informations ...

 

Do you know how to do this migration ?

 

Another way to move the database will be to keep the old version 1.10.1 on th enew server  but we can't find the installer. We haven't keep it and I don't see it in the jive web site ...

 

Thank you !

Tags: 1.10.1, 2.0.4, upgrade
Vinh Expert
Vinh
1,746 posts since
Apr 1, 2008
Currently Being Moderated
Jun 26, 2008 5:05 PM in response to: Frederic Piard
Re: Migrating from 1.10.1 to 2.0.4

Not sure about the upgrade, using the installer and the evaluation database can lead to a lot of funny business and we don't recommend using both for the long term.

 

I've PMed you a download link to the 1.10.1 exe.

Report Abuse
Frederic Piard Novice
Frederic Piard
5 posts since
Jun 26, 2008
Currently Being Moderated
Jun 27, 2008 1:22 AM in response to: Vinh
Re: Migrating from 1.10.1 to 2.0.4

Thanks a lot. It worked.

I have installed  the Clearspace 1.10.1 you gave me on our new server. I have moved the data and it's OK.

Clearspace 1.10.1 is working. 

 

On this new server, I try to migrate to the 2.0.4 version, but it crashed as before.

The migration process started :

Clearspace database Migration2.gif

Then crash.

 

In the logs I have

2008.06.27 10:00:59 [error] Could not execute action
java.lang.reflect.InvocationTargetException
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvoca tion.java:358)
    at com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(DefaultActionIn vocation.java:218)
    at com.opensymphony.webwork.interceptor.BackgroundProcess$1.run(BackgroundProcess. java:28)
    at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.OutOfMemoryError: Java heap space
    at java.lang.Object.clone(Native Method)
    at org.hsqldb.types.Binary.getClonedBytes(Unknown Source)
    at org.hsqldb.jdbc.jdbcResultSet.getObject(Unknown Source)
    at org.hsqldb.jdbc.jdbcResultSet.getBytes(Unknown Source)
    at org.hsqldb.jdbc.jdbcResultSet.getBlob(Unknown Source)
    at com.jivesoftware.community.migration.MigrateTable$1.read(MigrateTable.java:414)
    at com.jivesoftware.community.migration.MigrateTable$1.read(MigrateTable.java:329)
    at com.jivesoftware.community.importer.ResultSetIterator.getBlock(ResultSetIterato r.java:165)
    at com.jivesoftware.community.importer.ResultSetIterator.fillCache(ResultSetIterat or.java:108)
    at com.jivesoftware.community.importer.ResultSetIterator.hasNext(ResultSetIterator .java:69)
    at com.jivesoftware.community.migration.MigrateTable.performStep(MigrateTable.java :130)
    at com.jivesoftware.community.migration.DatabaseMigrationRoutine.start(DatabaseMig rationRoutine.java:54)
    at com.jivesoftware.community.action.admin.DatabaseMigrationTaskAction.execute(Dat abaseMigrationTaskAction.java:48)
    ... 8 more

 

 

It seems to be a java memory error. Maybe the database is not consistent ?

 

What is the recommended way to migrate from 1.x to 2.x

 

Thanks a lot. We are happy to use our new server, it just will be better to have the new version too ...

Report Abuse
Vinh Expert
Vinh
1,746 posts since
Apr 1, 2008
Currently Being Moderated
Jun 27, 2008 1:45 PM in response to: Frederic Piard
Re: Migrating from 1.10.1 to 2.0.4

What are you JVM parameters? Have you tried increasing the memory? Say to -Xmx768m or -Xmx1024m ?

Report Abuse
Frederic Piard Novice
Frederic Piard
5 posts since
Jun 26, 2008
Currently Being Moderated
Jul 2, 2008 6:28 AM in response to: Vinh
Re: Migrating from 1.10.1 to 2.0.4

Hi, I am back on this topic.

I am affraid this is a stupid question, but how can I the memory? where do I use this parameter -Xmx768m or -Xmx1024m ?

 

Thank you !

Report Abuse
Frederic Piard Novice
Frederic Piard
5 posts since
Jun 26, 2008
Currently Being Moderated
Jul 2, 2008 9:00 AM in response to: Frederic Piard
Re: Migrating from 1.10.1 to 2.0.4

I think I have the answer to my last question.

 

The answer is : http://www.jivesoftware.com/community/docs/DOC-1950

 

When using the installer version of Clearspace for Windows, setting JVM parameters for the JVM that Clearspace will run in requires putting a separate file with the JVM parameters in it.

 

This file must be placed in the <CS_INSTALL_DIR>/bin directory and needs to be named appropriately:

  • name the file clearspace-service.vmoptions if Clearspace is run as a Windows service.

  • name the file clearspaced.vmoptions if Clearspace is run with the clearspaced.exe file.

 

Put the JVM parameters in this file with one parameter per line. For example, if you wanted to specify a maximum heap size of 512 MB and a maximum permgen size of 128 MB, you would put the following lines in the file:

 

-Xmx512m

-XX:MaxPermSize=128m

 

I will try it very soon ...

Report Abuse
Frederic Piard Novice
Frederic Piard
5 posts since
Jun 26, 2008
Currently Being Moderated
Jul 8, 2008 4:07 PM in response to: Frederic Piard
Re: Migrating from 1.10.1 to 2.0.4

So, I succedded in the migration process. I gave more memory to the JVM and I did an upgade not an Export / Import operation.

 

I installed Clearspace 1.10.4on the new server. I transferred the date (jiveHome) from the old server. It was OK.

I Installed Clearspace 2.0.4 on the new server and I used exactly the same path for the data (jiveHome) as the 1.10.4 installation.

 

Clearspace 2.0.4 detected the upgrade and tryed several times to upgarde the data and finally it worked.

 

Clearspace 2.0.4 is running on thenew server with the upgraded data ...

 

Thanks for your help !

 

fred.

Report Abuse
Vinh Expert
Vinh
1,746 posts since
Apr 1, 2008
Currently Being Moderated
Jul 8, 2008 2:52 PM in response to: Frederic Piard
Re: Migrating from 1.10.1 to 2.0.4

Glad everything is working for you now :)

Report Abuse

More Like This

  • Retrieving data ...