Moving existing Derby installation to Postgresql
|
View:
New views
3 Messages
—
Rating Filter:
Alert me
|
 |
Moving existing Derby installation to Postgresql
by iantopanto
::
Rate this Message:
How would I go about moving my existing artifactory (running on derby) to use postgresql as the backend?
I have searched for documentation on how to do this. I have setup a fresh artifactory and used the instructions on setting up postgresql (new install) and tried to restore a system backup to it. This restore is flakey and I get some warning, but it states that it is successful. BUT, when I try and build a project it stops at the only big file I have which is ~90Mb and hangs there. If I restore the system backup to a fresh derby installation everything is fine. Here is the error I get when it hangs. ----------- [#|2009-08-06T12:26:29.045+0100|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=18;_ThreadName=pool-5-thread-1;|2009-08-06 12:26:29,045 [WARN ] (o.a.j.c.q.l.QueryResultImpl:494) - Exception retrieving Node with UUID: bd2ec7af-3e31-417d-b9a6-35dbd51141fb: javax.jcr.ItemNotFoundException: bd2ec7af-3e31-417d-b9a6-35dbd51141fb |#] [#|2009-08-06T12:26:30.256+0100|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=18;_ThreadName=pool-5-thread-1;|2009-08-06 12:26:30,253 [WARN ] (o.a.j.c.q.l.QueryResultImpl:494) - Exception retrieving Node with UUID: 893686fd-044a-4b8d-801c-14bf7fdb1c42: javax.jcr.ItemNotFoundException: 893686fd-044a-4b8d-801c-14bf7fdb1c42 |#] [#|2009-08-06T12:26:30.508+0100|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=18;_ThreadName=pool-5-thread-1;|2009-08-06 12:26:30,507 [WARN ] (o.a.j.c.q.l.QueryResultImpl:494) - Exception retrieving Node with UUID: d7953c5b-fe1f-46ce-8654-1cefc9bc8d6a: javax.jcr.ItemNotFoundException: d7953c5b-fe1f-46ce-8654-1cefc9bc8d6a |#] [#|2009-08-06T12:26:30.633+0100|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=18;_ThreadName=pool-5-thread-1;|2009-08-06 12:26:30,632 [WARN ] (o.a.j.c.q.l.QueryResultImpl:494) - Exception retrieving Node with UUID: cca8c719-5835-425d-b03b-cff64d6c36df: javax.jcr.ItemNotFoundException: cca8c719-5835-425d-b03b-cff64d6c36df |#] [#|2009-08-06T12:26:31.451+0100|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=18;_ThreadName=pool-5-thread-1;|2009-08-06 12:26:31,450 [WARN ] (o.a.j.c.q.l.QueryResultImpl:494) - Exception retrieving Node with UUID: 279163a7-a1a4-46de-b2ff-c832dd29a649: javax.jcr.ItemNotFoundException: 279163a7-a1a4-46de-b2ff-c832dd29a649 |#] [#|2009-08-06T12:26:35.537+0100|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=18;_ThreadName=pool-5-thread-1;|2009-08-06 12:26:35,536 [INFO ] (o.a.j.j.ArtifactoryGarbageCollector:332) - Artifactory Jackrabbit's datastore garbage collector report: Total execution: 7693ms : Data Store Query: 42ms Binary Properties Query: 79ms Total Scanning: 7693ms Element count: 5345 Total size: 1482100945 bytes Marked for deletion: 373 |#] ------------ I also got some errors when restoring to the postgres fresh install. ------------------- [#|2009-08-06T11:10:52.919+0100|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=18;_ThreadName=pool-5-thread-2;|2009-08-06 11:10:52,919 [WARN ] (o.a.s.TaskServiceImpl:37) - Could not locate active task with token b32dcd12-950e-4527-8ba9-ac3a80848b5b. Task may have been canceled.. |#] [#|2009-08-06T11:10:52.919+0100|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=18;_ThreadName=pool-5-thread-2;|2009-08-06 11:10:52,919 [WARN ] (o.a.s.TaskServiceImpl:37) - Could not locate active task with token a1fdb88d-c822-46f1-ad44-f96b6756a1d7. Task may have been canceled.. |#] [#|2009-08-06T11:11:54.175+0100|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=25;_ThreadName=pool-5-thread-8;|2009-08-06 11:11:54,175 [INFO ] (o.a.r.j.JcrRepoBase :199) - Repository 'repo1-cache' imported from /backups/crafnant/artifactory/newBack.bak/20090805.144807/repositories/repo1-cache. |#] [#|2009-08-06T11:11:54.176+0100|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=18;_ThreadName=pool-5-thread-2;|2009-08-06 11:11:54,176 [WARN ] (o.a.s.TaskServiceImpl:37) - Could not locate active task with token f2f4d721-3ee6-4b0e-bdf1-d4d4d8320c8a. Task may have been canceled.. |#] [#|2009-08-06T11:11:54.176+0100|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=18;_ThreadName=pool-5-thread-2;|2009-08-06 11:11:54,176 [WARN ] (o.a.s.TaskServiceImpl:37) - Could not locate active task with token f67d38ee-85b2-40d8-9e97-a2b4aa8968b6. Task may have been canceled.. |#] [#|2009-08-06T11:11:54.177+0100|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=18;_ThreadName=pool-5-thread-2;|2009-08-06 11:11:54,176 [WARN ] (o.a.s.TaskServiceImpl:37) - Could not locate active task with token b6618bbb-f18c-40d4-89ba-8cfeeb111176. Task may have been canceled.. |#] [#|2009-08-06T11:11:54.177+0100|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=18;_ThreadName=pool-5-thread-2;|2009-08-06 11:11:54,177 [INFO ] (o.a.r.s.RepositoryServiceImpl:199) - Finished importing repositories... |#] [#|2009-08-06T11:11:54.179+0100|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=17;_ThreadName=httpSSLWorkerThread-8080-0;|2009-08-06 11:11:54,178 [INFO ] (o.a.s.SecurityServiceImpl:199) - Importing security... |#] [#|2009-08-06T11:11:54.337+0100|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=18;_ThreadName=pool-5-thread-2;|2009-08-06 11:11:54,336 [INFO ] (o.a.j.JcrServiceImpl:481) - Committing working copy (2558 files)... [#|2009-08-05T15:09:22.745+0100|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=21;_ThreadName=httpSSLWorkerThread-8080-0;|2009-08-05 15:09:22,745 [INFO ] (o.a.s.ArtifactoryApplicationContext:199) - ### Full system import finished ### |#] [#|2009-08-05T15:09:27.084+0100|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=18;_ThreadName=pool-5-thread-6;|2009 -08-05 15:09:27,084 [WARN ] (o.a.c.x.EntityResolvingContentHandler:103) - Received the following error during xml parsing: 'The prefix "xsi" for attribute "xsi:schemaLocation" associated with an element type "project" is not bound.'.|#] [#|2009-08-05T15:11:55.496+0100|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=18;_ThreadName=pool-5-thread-6;|2009-08-05 15:11:55,495 [WARN ] (o.a.c.x.EntityResolvingContentHandler:103) - Received the following error during xml parsing: 'The entity "oslash" was referenced, but not declared.'. |#] [#|2009-08-05T15:12:41.817+0100|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=18;_ThreadName=pool-5-thread-6;|2009 -08-05 15:12:41,816 [WARN ] (o.a.c.x.EntityResolvingContentHandler:103) - Received the following error during xml parsing: 'The entity "oslash" was referenced, but not declared.'. |#] [#|2009-08-05T15:24:13.966+0100|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=18;_ThreadName=pool-5-thread-6;|2009 -08-05 15:24:13,965 [WARN ] (o.a.c.x.EntityResolvingContentHandler:103) - Received the following error during xml parsing: 'The entity "oslash" was referenced, but not declared.'.|#] [#|2009-08-05T15:24:14.756+0100|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=18;_ThreadName=pool-5-thread-6;|2009-08-05 15:24:14,756 [WARN ] (o.a.c.x.EntityResolvingContentHandler:103) - Received the following error during xml parsing: 'The entity "oslash" was referenced, but not declared.'. |#] ------------- Has someone achieved this move with no problems? Thanks, Ian Thanks |
|
|
Re: Moving existing Derby installation to Postgresql
by Yoav Landman-3
::
Rate this Message:
Ian,
The warnings you see have to do with an out of date index - you can rebuild the index by moving aside the $ARTIFACTORY_HOME/data/index, while Artifactory is down, and restarting (please allow some time for re-indexing to complete - it may take a couple of minutes on a large repo). It is possible that the problem with the specific artifact is related to Postgresql's (JDBC driver) binary-data handling. Is it reproducible with files of similar or bigger size deployed to the repository? Yoav On Thu, Aug 6, 2009 at 2:53 PM, iantopanto <ir@...> wrote:
------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Artifactory-users mailing list Artifactory-users@... https://lists.sourceforge.net/lists/listinfo/artifactory-users |
|
|
Re: Moving existing Derby installation to Postgresql
by iantopanto
::
Rate this Message:
Reindex the derby original install fine, then upgraded the jdbc3 driver to match the postgres version and tried to import.
The import was fine, but now I got a more clear error as to why it was failing - it was running out of heap space so i increased to 1G and now its fine. Thanks for the help. Ian
|
| Free embeddable forum powered by Nabble | Forum Help |
