Backup and Restoring

[jllort]

My suggestion is migrate to MySQL ( not use HSQL for production ).

You're on linux or windows ? 32 or 64 bits ? How many RAM do you got on this server and how many free ?

Increase the -Xmx1024 to -Xmx2048m

[TMac]

Thanks. Will look into the Sql version an xmx.

We are running Ubuntu 64 bit. We have 8Gb ram and 5.4 Gb is used.

[jllort]

if you want to try a migration procedure can try with it http://downloads.mysql.com/archives/migration/

If is not going right changing the default Xmx value, post here your actual setenv.sh configuration.
Did you uploaded a lot of files ( some importing ? ). In case afirmative, some of these are pdf or big size on some of them ?

[TMac]

Hello Jllhort,

Well I feel like I am finally making some progress. I updated the xmx values and have moved a little further. I no longer get the memory errors and I can log in using my old user name (instead of the default okmAdmin one).

Now that I log in, I get an error saying:

Code: Select all

OKM-012024(GetRootFolder): database error
could not execute query

It does not load any folders or paths.

I have attached the error logs and the xml and conf files, in case you need to see what we have. This now looks like it can't communicate properly to the DB. Although it managed to find my username and password, which I assume is stored in the DB.

I hope we are getting close to a solution. Of course, if we are using hsql then we will need to migrate, but that will be a separate job, I hope.

Let me know what you think.
Thanks,

[jllort]

You got two errors:
First, seems other application is running on port 8080 ( should close it or change default port on server.xml )

Code: Select all

2015-04-27 16:33:30,908 [main] ERROR org.apache.coyote.http11.Http11Protocol- Failed to initialize end point associated with ProtocolHandler ["http-bio-0.0.0.0-8080"]
java.net.BindException: Address already in use /0.0.0.0:8080

Second, seems some table missing on database ? quite strange becase NODE_FOLDER should be an existing table ( be sure privileges are right to access all files into tomcat folder ( and subfolders )

Code: Select all

2015-04-27 16:34:36,226 [localhost-startStop-1] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM]- Servlet /OpenKM threw load() exception
org.hsqldb.HsqlException: user lacks privilege or object not found: NODEFOLDER0_1_.NBS7_71_