glite-SE_dcache_srm - Updated to version 3.1.24-0

Normal priority update
Released on Update 68 (12/01/2011)

Description (See the patch #4108)

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

Dependent Patches

NumberDescription
There are no dependent patches.

Fixed Bugs

NumberDescription
There are no bugs fixed in this version.

Updated Rpms (See the full list)

NameVersionFull Rpm NameDescription
dcache-server 1.9.5-19 dcache-server-1.9.5-19.noarch.rpm dCache Server
dcacheVoms2Gplasma 0.0.8-0 dcacheVoms2Gplasma-0.0.8-0.noarch.rpm org.dcache.voms2gplasma
fetch-crl 2.7.0-2 fetch-crl-2.7.0-2.noarch.rpm fetch-crl
glite-SE_dcache_srm 3.1.24-0 glite-SE_dcache_srm-3.1.24-0.slc4.i386.rpm org.dcache.node.glite-SE_dcache_srm_3_2_0
glite-yaim-core 4.0.11-2 glite-yaim-core-4.0.11-2.noarch.rpm YAIM core package
glite-yaim-dcache 4.0.2-8 glite-yaim-dcache-4.0.2-8.noarch.rpm org.glite.yaim.dcache
postgresql 8.4.1-1PGDG postgresql-8.4.1-1PGDG.rhel4.i386.rpm A highly scalable, SQL compliant, open source object-relational database management system
postgresql-libs 8.4.1-1PGDG postgresql-libs-8.4.1-1PGDG.rhel4.i386.rpm A highly scalable, SQL compliant, open source object-relational database management system
postgresql-server 8.4.1-1PGDG postgresql-server-8.4.1-1PGDG.rhel4.i386.rpm The postgresql-server package includes the programs needed to create and run a PostgreSQL server, which will in turn allow you to create and maintain PostgreSQL databases. PostgreSQL is an advanced Object-Relational database management system (DBMS) th...

Service reconfiguration after update

Service must be reconfigured.

Service restart after update

Service must be restarted.