It appears no longer needed to use LD_LIBRARY_PATH to ensure the
correct runtime path resolution of libsecret in theia's `keytar`
component. Also LD_LIBRARY_PATH was leaking into theia's environment
and affecting tests launched from within theia.

This reverts commit 681ec188.

See merge request !1096

Always format the partitions to ensure the slapformat configuration is
valid, because the constructor overwrites it with invalid values.

We need a valid configuration so that `slapos node format` works,
and we need `slapos node format` for the resiliency import script.

Aggregate monitoring URLs from the main theia, clones and PBS.

Also add monitor-setup-url to the parameters published by the PBS.

32fbf0d4 (recipe/postgres: support non standard port, 2021-11-12)
broke support for empty port, it was generating config file with
`port = ` , which is an invalid config file syntax for postgresql.

The import script was overwriting the contents of ~/etc
which destroyed all the services running in the clone,
including the ones that allow the PBS to push new backup files.

See merge request nexedi/slapos!1091

This will force a password reset

Include the changes from 0b7511b4 (stack/erp5: expose random_activity_priority
argument of testrunner, 2021-11-22) to customized profiles from slapos
master

By setting this in the test suite configuration, we can force ERP5 tests
to use random priorities for activity processing.

The intended usage is to set this to an empty string, in which case
ERP5's runUnitTest chooses a random value for the seed and prints the
chosen value. It may also be possible to use a value, to reproduce a
previous run.

https://github.com/facebook/rocksdb/commit/7291a3f813e563efbd6870465b1063a115480373
is not enough.

Anway, given how SST files are written, fallocate
is unlikely to be useful, even less on SSD.

RocksDB seems to have options to disable at runtime (see env/io_posix.cc)
but I see nothing for that in MariaDB configuration.

Steps to reproduce:

With a Btrfs partition (no specific mkfs option and for example 2GB size)
and following MariaDB configuration:

  [mysqld]
  datadir = /tmp/datadir
  disable-log-bin
  plugin-load = ha_rocksdb
  rocksdb_default_cf_options = compression=kNoCompression;bottommost_compression=kZSTD

execute the following queries with `mysql -uroot`:

> USE test;
> CREATE TABLE t(x MEDIUMBLOB) ENGINE=RocksDB;
> INSERT INTO t VALUES(repeat('.',16777215));
> INSERT INTO t SELECT x FROM t UNION ALL SELECT x FROM t;
> INSERT INTO t SELECT x FROM t UNION ALL SELECT x FROM t;
> INSERT INTO t SELECT x FROM t UNION ALL SELECT x FROM t;

Disk usage can be checked with:

> SHOW ENGINE RocksDB STATUS \G

Level    Files   Size     ...
------------------------- ...
  L0      1/0   144.00 MB ...
  L2      1/0   288.00 MB ...
 Sum      2/0   432.00 MB ...

and this can be compacted as follows:

> SET GLOBAL rocksdb_compact_cf='default';

> SHOW ENGINE RocksDB STATUS \G

Level    Files   Size     ...
------------------------- ...
  L0      0/0    0.00 KB  ...
  L1      0/0    0.00 KB  ...
  L2      1/0   16.28 KB  ...
 Sum      1/0   16.28 KB  ...

Now using `compsize` (on Debian, it's provided by btrfs-compsize package):

# with -DWITH_FALLOCATE=NO

$ compsize /tmp/datadir/#rocksdb/000029.sst
Type       Perc     Disk Usage   Uncompressed Referenced
TOTAL      100%       20K          20K          20K
none       100%       20K          20K          20K

# without -DWITH_FALLOCATE=NO

$ compsize /tmp/datadir/#rocksdb/000029.sst
Type       Perc     Disk Usage   Uncompressed Referenced
TOTAL      100%       35M          35M          20K
none       100%       35M          35M          20K