spacemanager: Make help strings less ambiguous

Target: trunk
Require-notes: no
Require-book: no
Acked-by: Paul Millar <paul.millar@desy.de>
Patch: http://rb.dcache.org/r/6486/
Revert "spacemanager: Make help strings less ambiguous"

This reverts commit 9c35c335822eeb0449786f17f149f8a7ed00ca43.
spacemanager: Make help strings less ambiguous

Target: trunk
Require-notes: no
Require-book: no
Acked-by: Paul Millar <paul.millar@desy.de>
Patch: http://rb.dcache.org/r/6486/
deb: Append timestamp to snapshot builds

Target: trunk
Require-notes: no
Require-book: no
Acked-by: Paul Millar <paul.millar@desy.de>
Patch: http://rb.dcache.org/r/6448/
spacemanager: Fix slow SQL query

On small tables the two queries generate the same plan, but when
testing it on a clone of our production system, the queries produce
significantly different results (despite being equivalent when
the columns involved are marked not null).

The new query produces the same query plan as a left outer join
query, so there is no reason to use an explicit join (which would
be difficult to get into the criterion api).

Target: trunk
Require-notes: no
Require-book: no
Acked-by: Dmitry Litvintsev <litvinse@fnal.gov>
Patch: http://rb.dcache.org/r/6487/
spacemanager: Fix update of file entity

Path changes were not made persistent.

Target: trunk
Require-notes: no
Require-book: no
Acked-by: Dmitry Litvintsev <litvinse@fnal.gov>
Patch: http://rb.dcache.org/r/6490/
spacemanager: Fix case statements in db triggers

Apparently CASE throws an exception if a branch is missing. Since
there is no noop statement and thus adding an empty else line isn't
possible, I changed the CASE to chained IF statements.

Also added missing DROP TRIGGER IF EXISTS statements prior to all
CREATE TRIGGER statements - otherwise applying the changeset a second
time (after having modified it) will fail.

Target: trunk
Require-notes: no
Require-book: no
Acked-by: Dmitry Litvintsev <litvinse@fnal.gov>
Patch: http://rb.dcache.org/r/6492/
spacemanager: Avoid aggressive error output on cell communication

Without this patch we may quickly fill the log file with the same
error message about cell communication failure.

The patch also tries to distinguish between transient and non-transient
database failures when expiring files. Both are retried, but non-transient
failures are not retried until the expiration period has passed
(usually 3 minutes).

Target: trunk
Require-notes: no
Require-book: no
Acked-by: Paul Millar <paul.millar@desy.de>
Patch: http://rb.dcache.org/r/6488/
pom: Fix duplicate include of release plugin

Commit 5a5ccd2d5c3353331881dc5df0645a429df836e9 introduced lots
of errors in the Maven build caused by duplicate declaration of
the release plugin.

Target: trunk
Require-notes: no
Require-book: no
Acked-by: Paul Millar <paul.millar@desy.de>
Patch: http://rb.dcache.org/r/6491/
spacemanager,pinmanager,xrootd: Don't block during startup if pool manager is down

Target: trunk
Require-notes: no
Require-book: no
Acked-by: Paul Millar <paul.millar@desy.de>
Patch: http://rb.dcache.org/r/6489/
gplazma2-ldap: Ignore junit tests

These don't work outside of DESY, thus blocking unit tests from running.

Target: trunk
Require-notes: no
Require-book: no
Acked-by: Paul Millar <paul.millar@desy.de>
Patch: http://rb.dcache.org/r/6493/
chimera: Optimize schema migration

Also add empty rollback rules to allow the schema to be downgraded.

Target: trunk
Require-notes: yes
Require-book: no
Acked-by: Tigran Mkrtchyan <tigran.mkrtchyan@desy.de>
Patch: http://rb.dcache.org/r/6494/
spacemanager: Fix option value in ls files command

Target: trunk
Require-notes: no
Require-book: no
Acked-by: Paul Millar <paul.millar@desy.de>
Patch: http://rb.dcache.org/r/6495/
spacemanager: Fix expiration check

A small bug sneaked in when changing lifetime to expirationtime.

Target: trunk
Require-notes: no
Require-book: no
Acked-by: Paul Millar <paul.millar@desy.de>
Patch: http://rb.dcache.org/r/6496/
spacemanager: Fix queries searching for glob match

Postgresql can only make use of indexes for the LIKE operator if the index
using C encoding. With UTF-8 encoding or any other local, the index cannot be
used, even when the pattern contains no wildcards and is equivalent to an
equality check.

This patch updates the space manager to detect this common case and use
an equality check if the pattern contains no wildcards.

Target: trunk
Require-book: no
Require-notes: no
Acked-by: Paul Millar <paul.millar@desy.de>
Patch: http://rb.dcache.org/r/6499/
spacemanager: Fix extraction of null values

Target: trunk
Require-notes: no
Require-book: no
Acked-by: Paul Millar <paul.millar@desy.de>
Patch: http://rb.dcache.org/r/6509/
Restore compatibility with 2.6 pools

CHANGE_TIME is not available in 2.6 code and the enum can thus
not be deserialized. This is obviously a flaw in the design of
the FileAttributes class making it difficult to add new
attributes, but for now this patch restored pool compatibility
by not including that attribute by default.

Target: trunk
Require-notes: yes
Require-book: no
Acked-by: Paul Millar <paul.millar@desy.de>
Acked-by: Tigran Mkrtchyan <tigran.mkrtchyan@desy.de>
Patch: http://rb.dcache.org/r/6510/
spacemanager: Remove file count from space reservation list

The file count is way too expensive to retrieve.

Target: trunk
Require-notes: no
Require-book: yes
Acked-by: Paul Millar <paul.millar@desy.de>
Patch: http://rb.dcache.org/r/6511/
nfs: Prevent NFS door from starting if schema is not up to date

Although we do not want NFS doors to update the Chimera schema
(PnfsManager does that), we should still check whether the schema
is up to date.

Target: trunk
Require-notes: yes
Require-book: no
Acked-by: Paul Millar <paul.millar@desy.de>
Acked-by: Tigran Mkrtchyan <tigran.mkrtchyan@desy.de>
Patch: http://rb.dcache.org/r/6505/
spacemanager: Improve CLI errors

In case of lookups for specific entities, the EmptyResultDataAccessExcption
message contains enough information to describe the error. This patch avoids
that a lengthy causal chain of exceptions are printed to the shell for something
that must be considered a common error.

Target: trunk
Require-notes: no
Require-book: no
Acked-by: Paul Millar <paul.millar@desy.de>
Patch: http://rb.dcache.org/r/6513/