What's new:

Large performance increase, Databases holding pools, so pools can be run on file systems with slow lookup speed. At least 5X performance upgrade. Many bug fixes.

Installation and configuration:

#first stop your dcache.

/opt/d-cache/bin/dcache stop
umount -f /pnfs/
/etc/init.d/dcacheChimeraNfs stop

#then check no java is running
ps aux | grep java

The files format of /opt/d-cache/etc/node_config has changed before upgrading please do the following command

mv /opt/d-cache/etc/node_config /opt/d-cache/etc/node_config.bak

if this is not done you will get multiple copys of dcache domains running

The dCacheConfigure.sh script does not manage upgrades to PoolManager.conf very much so we do the following before moving this back later

mv /opt/d-cache/config/PoolManager.conf /opt/d-cache/config/PoolManager.conf.bak

org.postgresql.util.PSQLException: ERROR: function path2inode(character varying, character varying) does not exist Hint: No function matches the given name and argument types. You may need to add explicit type casts. Position: 8

        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
        at org.dcache.chimera.PgSQLFsSqlDriver.path2inode(PgSQLFsSqlDriver.java:148)
        at org.dcache.chimera.JdbcFs.path2inode(JdbcFs.java:861)
        at org.dcache.chimera.JdbcFs.path2inode(JdbcFs.java:843)
        at org.dcache.chimera.JdbcFs.getWormID(JdbcFs.java:137)
        at org.dcache.chimera.JdbcFs.<init>(JdbcFs.java:120)
        at org.dcache.chimera.JdbcFs.<init>(JdbcFs.java:82)
        at org.dcache.chimera.examples.cli.Ls.main(Ls.java:31)

20 Nov 2009 12:45:40 () [] path2inode
org.postgresql.util.PSQLException:ERROR : function path2inode(character varying, character varying) does not exist Hint: No function matches the given name and argument types. You may need to add explicit type casts. Position: 8

        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
        at org.dcache.chimera.PgSQLFsSqlDriver.path2inode(PgSQLFsSqlDriver.java:148)
        at org.dcache.chimera.JdbcFs.path2inode(JdbcFs.java:861)
        at org.dcache.chimera.JdbcFs.path2inode(JdbcFs.java:843)
        at org.dcache.chimera.examples.cli.Ls.main(Ls.java:34)

su postgres
bash-3.00$ psql chimera < /opt/d-cache/libexec/chimera/sql/migrate-2-1.9.3.sql SELECT
SELECT
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
bash-3.00$ psql chimera < /opt/d-cache/libexec/chimera/sql/add-timezone.sql ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
bash-3.00$ psql chimera < /opt/d-cache/libexec/chimera/sql/addACLtoChimeraDB.sql NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "t_acl_pkey" for table "t_acl" CREATE TABLE
CREATE INDEX
bash-3.00$ psql chimera < /opt/d-cache/libexec/chimera/sql/pgsql-procedures.sql CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
ERROR: trigger "tgr_locationinfo_trash" for relation "t_inodes" already exists CREATE FUNCTION
ERROR: trigger "tgr_populate_tags" for relation "t_dirs" already exists CREATE SEQUENCE
CREATE FUNCTION
CREATE TRIGGER
bash-3.00$ psql -f /opt/d-cache/libexec/chimera/sql/pgsql-procedures.sql chimera CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
psql:/opt/d-cache/libexec/chimera/sql/pgsql-procedures.sql:89: ERROR: trigger "tgr_locationinfo_trash" for relation "t_inodes" already exists CREATE FUNCTION
psql:/opt/d-cache/libexec/chimera/sql/pgsql-procedures.sql:110: ERROR: trigger "tgr_populate_tags" for relation "t_dirs" already exists psql:/opt/d-cache/libexec/chimera/sql/pgsql-procedures.sql:122: ERROR: relation "serial" already exists CREATE FUNCTION
psql:/opt/d-cache/libexec/chimera/sql/pgsql-procedures.sql:166: ERROR: trigger "tgr_insertacl" for relation "t_dirs" already exists

run this script to complete the process

/opt/d-cache/bin/dCacheConfigure.sh -s /root/site-info.def -c config_sedcache