Difference between revisions of "Escidoc-core Migration v1.1 to v1.2"
Jump to navigation
Jump to search
(21 intermediate revisions by 4 users not shown) | |||
Line 8: | Line 8: | ||
*faces.mpdl.mpg.de (Faces) | *faces.mpdl.mpg.de (Faces) | ||
*virr.mpdl.mpg.de (Virr) | *virr.mpdl.mpg.de (Virr) | ||
*peer-coreservice.mpdl.mpg.de (PubMan) | |||
*any other instance accessing coreservice.mpdl.mpg.de | *any other instance accessing coreservice.mpdl.mpg.de | ||
Line 18: | Line 19: | ||
*foxml_migration-jar-with-dependencies.jar | *foxml_migration-jar-with-dependencies.jar | ||
**plus xsl folder containing xslt styesheets: | **plus xsl folder containing xslt styesheets: | ||
wget https:// | wget https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/foxml_migration/xsl/foxml_context.xsl --no-check-certificate | ||
wget https:// | wget https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/foxml_migration/xsl/foxml_face.xsl --no-check-certificate | ||
wget https:// | wget https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/foxml_migration/xsl/foxml_facesAlbum.xsl --no-check-certificate | ||
wget https:// | wget https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/foxml_migration/xsl/foxml_file.xsl --no-check-certificate | ||
wget https:// | wget https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/foxml_migration/xsl/foxml_orgUnit.xsl --no-check-certificate | ||
wget https:// | wget https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/foxml_migration/xsl/foxml_pubItem.xsl --no-check-certificate | ||
wget https:// | wget https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/foxml_migration/xsl/foxml_virrElement.xsl --no-check-certificate | ||
wget https:// | wget https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/foxml_migration/xsl/transform_context.xsl --no-check-certificate | ||
wget https:// | wget https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/foxml_migration/xsl/transform_face.xsl --no-check-certificate | ||
wget https:// | wget https://subversion.mpdl.mpg.gwdg.de/repos/common/trunk/common_services/foxml_migration/xsl/transform_facesAlbum.xsl --no-check-certificate | ||
wget https:// | wget https://subversion.mpdl.mpg.gwdg.de/repos/common/trunk/common_services/foxml_migration/xsl/transform_file.xsl --no-check-certificate | ||
wget https:// | wget https://subversion.mpdl.mpg.gwdg.de/repos/common/trunk/common_services/foxml_migration/xsl/transform_orgUnit.xsl --no-check-certificate | ||
wget https:// | wget https://subversion.mpdl.mpg.gwdg.de/repos/common/trunk/common_services/foxml_migration/xsl/transform_pubItem.xsl --no-check-certificate | ||
wget https:// | wget https://subversion.mpdl.mpg.gwdg.de/repos/common/trunk/common_services/foxml_migration/xsl/transform_virrElement.xsl --no-check-certificate | ||
wget https:// | wget https://subversion.mpdl.mpg.gwdg.de/repos/common/trunk/common_services/foxml_migration/xsl/ves-mapping.xml --no-check-certificate | ||
**plus migration.properties file | **plus migration.properties file | ||
available at https:// | available at https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/foxml_migration | ||
==Pre-Migration requirements== | ==Pre-Migration requirements== | ||
*shutdown all solutions accessing coreservice.mpdl.mpg.de | *shutdown all solutions accessing coreservice.mpdl.mpg.de | ||
**stop JBoss application server on | **stop JBoss application server on | ||
*** | ***pubman.mpdl.mpg.de | ||
***faces.mpdl.mpg.de | ***faces.mpdl.mpg.de | ||
***virr.mpdl.mpg.de | ***virr.mpdl.mpg.de | ||
Line 48: | Line 49: | ||
*shutdown Fedora instance | *shutdown Fedora instance | ||
**/X/fedora/tomcat/bin/shutdown.sh on srv01.mpdl.mpg.de | **/X/fedora/tomcat/bin/shutdown.sh on srv01.mpdl.mpg.de | ||
*'''coreservice.mpdl.mpg.de''' only | |||
**shutdown PostgreSQL database | |||
**proceed with [[ESciDoc-core_Migration_v1.1_to_v1.2_coreservice_splitting | Migration of coreservice.mpdl.mpg.de and splitting of Publication from Research data]] | |||
==Main migration steps== | ==Main migration steps== | ||
Line 66: | Line 70: | ||
***copy the entire data directory located in the old Fedora instance (/X/fedora3.2.1/data) into the newly installed Fedora instance | ***copy the entire data directory located in the old Fedora instance (/X/fedora3.2.1/data) into the newly installed Fedora instance | ||
=== | ===Migration of the FOXML files=== | ||
this will backup the Fedora data diectory! | this will backup the Fedora data diectory! | ||
*go to escidoc-core-admin-1.2 | *go to escidoc-core-admin-1.2 | ||
Line 75: | Line 79: | ||
*call ant foxml-migration-from1.1-to1.2 | *call ant foxml-migration-from1.1-to1.2 | ||
===Migrating old escidoc:TOC content model=== | ===Research Data Repository Only: Migrating old escidoc:TOC content model=== | ||
*locate the escidoc_TOC file inside /X/fedora/data/objects and open it for editing | *locate the escidoc_TOC file inside /X/fedora/data/objects and open it for editing | ||
**replace all occurances of "TOC" with "toc" | **replace all occurances of "TOC" with "toc" | ||
Line 91: | Line 95: | ||
**Location: <fedora-dir>/server/bin | **Location: <fedora-dir>/server/bin | ||
**Script: fedora-rebuild.sh | **Script: fedora-rebuild.sh | ||
***'''CAUTION! causes NoClassDefFoundError on "exotic" variants of JDK. (Let the SUN shine in ...) | |||
***rebuild first the database | ***rebuild first the database | ||
***rebuild next the resource index | ***rebuild next the resource index | ||
Line 115: | Line 120: | ||
**run the script (as postgres user) | **run the script (as postgres user) | ||
https:// | https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/framework_access/src/test/resources/migration_1.1_1.2/create_tablespaces.sql (create new tablespaces) | ||
*'''Fedora database''' | *'''Fedora database''' | ||
**run the scripts (as postgres user) | **run the scripts (as postgres user) | ||
https:// | https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/framework_access/src/test/resources/migration_1.1_1.2/set_fedora_tables_to_tablespace.sql (re-set fedora tables tablespace) | ||
https:// | https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/framework_access/src/test/resources/migration_1.1_1.2/set_fedora_indexes_to_tablespace.sql (re-set fedora indexes tablespace) | ||
Line 128: | Line 133: | ||
**this has to be done AFTER Fedora resource index is rebuilt. | **this has to be done AFTER Fedora resource index is rebuilt. | ||
https:// | https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/framework_access/src/test/resources/migration_1.1_1.2/set_triples_tables_to_tablespace.sql (re-set triples tables tablespace) | ||
https:// | https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/framework_access/src/test/resources/migration_1.1_1.2/set_triples_indexes_to_tablespace.sql (re-set triples indexes tablespace) | ||
===Migration of the escidoc-core database=== | ===Migration of the escidoc-core database=== | ||
*ensure there is enough disk space, because the db-migration ant task requires far too much of it! | |||
*backup the escidoc-core database on coreservice.mpdl.mpg.de !!! | *backup the escidoc-core database on coreservice.mpdl.mpg.de !!! | ||
**log-in as postgres-user to the system | **log-in as postgres-user to the system | ||
Line 147: | Line 153: | ||
**usually (except for very old versions of escidoc-admin tool) there is an information whether the database is consistent or not | **usually (except for very old versions of escidoc-admin tool) there is an information whether the database is consistent or not | ||
*IF the database is not consistent run the following script prior to the db-migration: | *IF the database is not consistent run the following script prior to the db-migration: | ||
**https:// | **https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/framework_access/src/test/resources/migration_1.1_1.2/fingerprint-pre-script.sql (Pre-migration script RUN AS POSTGRES USER) | ||
* Modify admin-tool.properties. | * Modify admin-tool.properties. | ||
**Check the following entries: | **Check the following entries: | ||
Line 167: | Line 173: | ||
* call '''ant db-migration''' | * call '''ant db-migration''' | ||
**'''NOTE''': for the '''research data repository''', prior to calling ant-db-migration please drop table aa.user_account_backup. All the rest is prepared. --[[User:Natasab|Natasa]] 12:20, 17 September 2010 (UTC) | |||
**DO NOT USE THE JAR FILE with the db-migration argument! | **DO NOT USE THE JAR FILE with the db-migration argument! | ||
Line 172: | Line 179: | ||
*backup escidoc-core.properties | *backup escidoc-core.properties | ||
*copy everything inside jboss-patch-1.2/server to /usr/share/jboss on coreservice.mpdl.mpg.de, ignore jboss-patch-1.2/bin | *copy everything inside jboss-patch-1.2/server to /usr/share/jboss on coreservice.mpdl.mpg.de, ignore jboss-patch-1.2/bin | ||
*remove old file wstx-asl-3.2.4.jar from <JBOSS_HOME>/server/default/lib. | |||
*Change properties in escidoc-core.properties according to escidoc-core.properties backup | *Change properties in escidoc-core.properties according to escidoc-core.properties backup | ||
Line 191: | Line 199: | ||
run the script (as postgres user) | run the script (as postgres user) | ||
[https:// | [https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/framework_access/src/test/resources/migration_1.1_1.2/set_escidoc_tables_to_tablespace.sql re-set escidoc-core tables tablespace] | ||
*drop list.property indexes (chance for faster recache), create some aa.indexes, list.filter indexes | *drop list.property indexes (chance for faster recache), create some aa.indexes, list.filter indexes | ||
run the script (as postgres user) | run the script (as postgres user) | ||
[https:// | [https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/framework_access/src/test/resources/migration_1.1_1.2/postmigration-pre-recache.sql postmigration-pre-recache script] | ||
===escidoc-core deployment=== | ===escidoc-core deployment=== | ||
Line 202: | Line 210: | ||
===Recache and reindex=== | ===Recache and reindex=== | ||
*Change Property for Lucene Indexing stylesheet in escidoc-core.properties: | |||
gsearch.escidoc.indexingStylesheet = http://escidoc1.escidoc.mpg.de/resources/searchIndexDefinition/mpdlEscidocXmlToLucene_1.2.xslt | |||
*start JBoss on coreservice.mpdl.mpg.de | *start JBoss on coreservice.mpdl.mpg.de | ||
*start Fedora on srv01.mpdl.mpg.de | *start Fedora on srv01.mpdl.mpg.de | ||
*launch the escidoc-core admin | *launch the escidoc-core admin tool at http://coreservice.mpdl.mpg.de/adm/admin.jsp | ||
*recache (ensure the "clear cache" checkbox is selected!) (MUST BE RUN FIRST, see afterwards POST-RECACHE below) | *recache (ensure the "clear cache" checkbox is selected!) (MUST BE RUN FIRST, see afterwards POST-RECACHE below) | ||
*reindex (ensure the "clear index" checkbox is selected!) (MUST BE RUN SECOND, as it reads the SOAP representation from the cache) | *reindex (ensure the "clear index" checkbox is selected!) (MUST BE RUN SECOND, as it reads the SOAP representation from the cache) | ||
===Post-recache=== | ===Post-recache=== | ||
*NOTE: POST-recache procedure can run in parallel with "reindexing" from eSciDoc Admin | *NOTE: POST-recache procedure can run in parallel with "reindexing" from eSciDoc Admin ('''DONE''' on coreservice pubman) | ||
*create new indexes on list.property | *create new indexes on list.property | ||
run the script (as postgres user) | run the script (as postgres user on psql from command line) | ||
[https:// | [https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/framework_access/src/test/resources/migration_1.1_1.2/set_list_property_indexes.sql set_list_property_indexes script] | ||
Line 223: | Line 235: | ||
*run the script with changed policies (as postgres user) | *run the script with changed policies (as postgres user) | ||
[https:// | [https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/framework_access/src/test/resources/migration_1.1_1.2/Policy%20changes%201.2-MPDL.sql change of policies] | ||
Line 237: | Line 249: | ||
[[Category:ESciDoc|Core Migration v1.1 to v1.2]] | |||
[[Category:Solutions|Core Migration v1.1 to v1.2]] | |||
[[Category:ESciDoc | |||
[[Category:Solutions| |
Latest revision as of 14:38, 25 April 2012
step-by-step instructioncs to migrate escidoc-core 1.1 to escidoc-core 1.2. (detailed information is related to the MPDL productive environment).
Affected servers[edit]
- srv01.mpdl.mpg.de (PortgreSQL and Fedora)
- coreservice.mpdl.mpg.de (srv02.mpdl.mpg.de) (escidoc-core)
- pubman.mpdl.mpg.de (PubMan)
- faces.mpdl.mpg.de (Faces)
- virr.mpdl.mpg.de (Virr)
- peer-coreservice.mpdl.mpg.de (PubMan)
- any other instance accessing coreservice.mpdl.mpg.de
Required software packages[edit]
- fcrepo-installer-3.3-fix01.jar: http://www.escidoc.org/software/fedora/fcrepo-installer-3.3-fix01.jar
- escidoc-core-admin-1.2: http://www.escidoc.org/software/builds/stable-releases/1.2/escidoc-core-admin-1.2.zip
- escidoc-core-bin-1.2: http://www.escidoc.org/software/builds/stable-releases/1.2/escidoc-core-bin-1.2.zip
- jboss-patch-1.2: http://www.escidoc.org/software/builds/stable-releases/1.2/jboss-patch-1.2.zip
all available at https://www.escidoc.org/JSPWiki/en/DownloadForRelease1.2
- foxml_migration-jar-with-dependencies.jar
- plus xsl folder containing xslt styesheets:
wget https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/foxml_migration/xsl/foxml_context.xsl --no-check-certificate wget https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/foxml_migration/xsl/foxml_face.xsl --no-check-certificate wget https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/foxml_migration/xsl/foxml_facesAlbum.xsl --no-check-certificate wget https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/foxml_migration/xsl/foxml_file.xsl --no-check-certificate wget https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/foxml_migration/xsl/foxml_orgUnit.xsl --no-check-certificate wget https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/foxml_migration/xsl/foxml_pubItem.xsl --no-check-certificate wget https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/foxml_migration/xsl/foxml_virrElement.xsl --no-check-certificate wget https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/foxml_migration/xsl/transform_context.xsl --no-check-certificate wget https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/foxml_migration/xsl/transform_face.xsl --no-check-certificate wget https://subversion.mpdl.mpg.gwdg.de/repos/common/trunk/common_services/foxml_migration/xsl/transform_facesAlbum.xsl --no-check-certificate wget https://subversion.mpdl.mpg.gwdg.de/repos/common/trunk/common_services/foxml_migration/xsl/transform_file.xsl --no-check-certificate wget https://subversion.mpdl.mpg.gwdg.de/repos/common/trunk/common_services/foxml_migration/xsl/transform_orgUnit.xsl --no-check-certificate wget https://subversion.mpdl.mpg.gwdg.de/repos/common/trunk/common_services/foxml_migration/xsl/transform_pubItem.xsl --no-check-certificate wget https://subversion.mpdl.mpg.gwdg.de/repos/common/trunk/common_services/foxml_migration/xsl/transform_virrElement.xsl --no-check-certificate wget https://subversion.mpdl.mpg.gwdg.de/repos/common/trunk/common_services/foxml_migration/xsl/ves-mapping.xml --no-check-certificate
- plus migration.properties file
available at https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/foxml_migration
Pre-Migration requirements[edit]
- shutdown all solutions accessing coreservice.mpdl.mpg.de
- stop JBoss application server on
- pubman.mpdl.mpg.de
- faces.mpdl.mpg.de
- virr.mpdl.mpg.de
- stop JBoss application server on any other instance, which is accessing coreservice.mpdl.mpg.de
- stop JBoss application server on
- shutdown the escidoc-core instance
- stop JBoss application server on coreservice.mpdl.mpg.de
- shutdown Fedora instance
- /X/fedora/tomcat/bin/shutdown.sh on srv01.mpdl.mpg.de
- coreservice.mpdl.mpg.de only
- shutdown PostgreSQL database
- proceed with Migration of coreservice.mpdl.mpg.de and splitting of Publication from Research data
Main migration steps[edit]
Installation of Fedora 3.3.1[edit]
- on srv01.mpdl.mpg.de change to directory /X
- delete the symbolic link fedora
- DO NOT DELETE THE EXISTING FEDORA INSTANCE INSIDE /X/fedora3.2.1 !!!
- create a new directory fedora3.3
- create a new symbolic link fedora pointing to the new directory fedora3.3
- drop old fedora databases "fedora32" and "riTriples"
- CREATE DATABASE "fedora3" WITH ENCODING='UTF8' OWNER="fedoraAdmin";
- CREATE DATABASE "riTriples" WITH ENCODING='SQL_ASCII' OWNER="fedoraAdmin" TEMPLATE=template0;
- install Fedora 3.3.1
- java -jar fcrepo-installer-3.3-fix01.jar
- instructions can be found here: https://www.escidoc.org/JSPWiki/en/Fedora3.3Installation
- when the installation is finished
- copy the entire data directory located in the old Fedora instance (/X/fedora3.2.1/data) into the newly installed Fedora instance
Migration of the FOXML files[edit]
this will backup the Fedora data diectory!
- go to escidoc-core-admin-1.2
- edit the admin-tool.properties file
- check Fedora properties
- especially fedora-src.home=/X/fedora
- ANT_OPTS=-Xmx1024m -Xms512m -XX:MaxPermSize=256m
- call ant foxml-migration-from1.1-to1.2
Research Data Repository Only: Migrating old escidoc:TOC content model[edit]
- locate the escidoc_TOC file inside /X/fedora/data/objects and open it for editing
- replace all occurances of "TOC" with "toc"
- check the creation date of the RELS-EXT.0 and the RELS-EXT.1 datastreams
- if both dates "CREATED=<date>" are equal, decrease the one in RELS-EXT.0
- update all references to escidoc:TOC in any resource
- the current migration.properties file has a list of all relevant resources
- java -jar foxml_migration-jar-with-dependencies.jar cmodel
Rebuild Fedora[edit]
- edit <fedora-dir>/server/bin/env-server.sh:
exec_cmd="exec \"$java\" -server -Xmn64m -Xms256m -Xmx1024m \
- start fedora: <fedora-dir>/tomcat/bin/startup.sh
- rebuild the Fedora database and the Fedora resource index
- Location: <fedora-dir>/server/bin
- Script: fedora-rebuild.sh
- CAUTION! causes NoClassDefFoundError on "exotic" variants of JDK. (Let the SUN shine in ...)
- rebuild first the database
- rebuild next the resource index
Post-rebuild Fedora steps[edit]
- create new tablespaces
- check if tablespaces for directories are created
mkdir /var/lib/pgsql/data/tables mkdir /var/lib/pgsql/data/tables/fedora mkdir /var/lib/pgsql/data/tables/triples mkdir /var/lib/pgsql/data/tables/escidoc-core mkdir /var/lib/pgsql/data/tables/statistics
mkdir /var/lib/pgsql/data/indexes mkdir /var/lib/pgsql/data/indexes/fedora mkdir /var/lib/pgsql/data/indexes/triples mkdir /var/lib/pgsql/data/indexes/escidoc-core-large mkdir /var/lib/pgsql/data/indexes/escidoc-core-normal mkdir /var/lib/pgsql/data/indexes/statistics
cd /var/lib/pgsql/data/ chown -R postgres:postgres *
- run the script (as postgres user)
https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/framework_access/src/test/resources/migration_1.1_1.2/create_tablespaces.sql (create new tablespaces)
- Fedora database
- run the scripts (as postgres user)
https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/framework_access/src/test/resources/migration_1.1_1.2/set_fedora_tables_to_tablespace.sql (re-set fedora tables tablespace) https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/framework_access/src/test/resources/migration_1.1_1.2/set_fedora_indexes_to_tablespace.sql (re-set fedora indexes tablespace)
- RiTriples database
- run the scripts (as postgres user)
- NOTE: Recommended is to re-run the select queries in these scripts and to create additional scripts.
- Data in triples are changed daily, so are the tables (in case there are new data or predicates).
- this has to be done AFTER Fedora resource index is rebuilt.
https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/framework_access/src/test/resources/migration_1.1_1.2/set_triples_tables_to_tablespace.sql (re-set triples tables tablespace) https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/framework_access/src/test/resources/migration_1.1_1.2/set_triples_indexes_to_tablespace.sql (re-set triples indexes tablespace)
Migration of the escidoc-core database[edit]
- ensure there is enough disk space, because the db-migration ant task requires far too much of it!
- backup the escidoc-core database on coreservice.mpdl.mpg.de !!!
- log-in as postgres-user to the system
- issue
pg_dump -f escidoc_core_database.dmp -C escidoc-core
in a desired backup directory, you need to know the password of user postgres in the pg database
- The database migration uses certain fingerprints in order to determine the current version of the db. The layout of our databases sometimes differs from the one assumed by the db-migration tool.
- To check if the database layout is fine
- go to escidoc-admin tool
- getrepository info
- usually (except for very old versions of escidoc-admin tool) there is an information whether the database is consistent or not
- IF the database is not consistent run the following script prior to the db-migration:
- https://subversion.mpdl.mpg.de/repos/common/trunk/common_services/framework_access/src/test/resources/migration_1.1_1.2/fingerprint-pre-script.sql (Pre-migration script RUN AS POSTGRES USER)
- Modify admin-tool.properties.
- Check the following entries:
- datasource.script.prefix=
- datasource.url=check-which-one
- datasource.driverClassName=org.postgresql.Driver
- datasource.username=check-which-one
- datasource.password=check-which-one
- creator_id=the user-id of a sysadmin user (e.g. escidoc:user42 for roland)
- persistentHandle=the handle taken from aa.user_login_data
- escidoc.database.tablespace.list=pg_default
- go to admin-tool
- Get repository info (shall tell if the fingerscript is different)
- DO NOT RUN db-migration unless database is consistent!!!
- if this is the case, compare the fingerprint script of 1.1.0 with the fingerprint script /tmp/fingerprint.xml
- this should give an idea what to modify manually
- repeat get-repository-info as long as consistency is achieved
- DO NOT RUN db-migration unless database is consistent!!!
- call ant db-migration
- NOTE: for the research data repository, prior to calling ant-db-migration please drop table aa.user_account_backup. All the rest is prepared. --Natasa 12:20, 17 September 2010 (UTC)
- DO NOT USE THE JAR FILE with the db-migration argument!
JBoss patch[edit]
- backup escidoc-core.properties
- copy everything inside jboss-patch-1.2/server to /usr/share/jboss on coreservice.mpdl.mpg.de, ignore jboss-patch-1.2/bin
- remove old file wstx-asl-3.2.4.jar from <JBOSS_HOME>/server/default/lib.
- Change properties in escidoc-core.properties according to escidoc-core.properties backup
Post-Migration steps[edit]
- shutdown core-service
- shutdown fedora
- Postgresql shall run
- vacuum analyze all tables in escidoc-core, riTriples, Fedora database (all as postgres user)
helper: issue following sql to get the script (on each of the mentioned databases): select 'vacuum analyze '||table_schema||'.'||table_name||'; ' from information_schema.tables where table_schema in ('list', 'aa', 'public')
copy/paste result in a new PgAdmin SQL Editor
replace all " with nothing (Edit->Find and Replace->Find what " -> Replace All)
run all commands together as PgScript (or use F6)
- change the tablespaces in escidoc-core database
run the script (as postgres user) re-set escidoc-core tables tablespace
- drop list.property indexes (chance for faster recache), create some aa.indexes, list.filter indexes
run the script (as postgres user) postmigration-pre-recache script
escidoc-core deployment[edit]
- copy the escidoc-core-bin-1.2/ear/escidoc-core.ear file into /usr/share/jboss/server/default/deploy on coreservice.mpdl.mpg.de
Recache and reindex[edit]
- Change Property for Lucene Indexing stylesheet in escidoc-core.properties:
gsearch.escidoc.indexingStylesheet = http://escidoc1.escidoc.mpg.de/resources/searchIndexDefinition/mpdlEscidocXmlToLucene_1.2.xslt
- start JBoss on coreservice.mpdl.mpg.de
- start Fedora on srv01.mpdl.mpg.de
- launch the escidoc-core admin tool at http://coreservice.mpdl.mpg.de/adm/admin.jsp
- recache (ensure the "clear cache" checkbox is selected!) (MUST BE RUN FIRST, see afterwards POST-RECACHE below)
- reindex (ensure the "clear index" checkbox is selected!) (MUST BE RUN SECOND, as it reads the SOAP representation from the cache)
Post-recache[edit]
- NOTE: POST-recache procedure can run in parallel with "reindexing" from eSciDoc Admin (DONE on coreservice pubman)
- create new indexes on list.property
run the script (as postgres user on psql from command line) set_list_property_indexes script
- re-vacuum analyze databases escidoc-core, riTriples, Fedora database
vacuum analyze
- run the script with changed policies (as postgres user)
change of policies
- (optional) see Performance
- NOTE: the escidoc-core database on production is prepared, no need to change anything, use these tipps for the other databases
deployment of solutions[edit]
- pror to the deployment of Faces and Virr
- the Java version on virr.mpdl.mpg.de and on faces.mpdl.mpg.de has to be upgarded to version 1.6
- deploy the appropriate solution ear files to pubman, faces and virr
- apply necessary updates to the solution specific properties files
- start the Jboss instances for the three solutions