Blocker on checkpoint

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--===============5915451378787291295==
Content-Type: multipart/signed; micalg=pgp-sha256;
 protocol="application/pgp-signature";
 boundary="C0kLGYj6sBAf3VKNN94C60AhRKZbsAvJD"

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--C0kLGYj6sBAf3VKNN94C60AhRKZbsAvJD
Content-Type: multipart/mixed; boundary="NEpErMp0AJbsXT69KiIVhkLerq3wJzwEr";
 protected-headers="v1"
From: =?UTF-8?B?U8OpYmFzdGllbiBQw6lyw6hzLUxhYm91cmRldHRl?=
 <[email protected]>
To: HSQLDB user list <[email protected]>
Message-ID: <[email protected]>
Subject: Blocker on checkpoint

--NEpErMp0AJbsXT69KiIVhkLerq3wJzwEr
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Content-Language: fr-classic

Hi there.

Use case is the following
=C2=A0- Hsqldb server 2.5.1 with 14 database instances, some 100% memory,=

some 100% cached.
=C2=A0- Background java job to perform checkpoint defrag on all instances=
=2E
=C2=A0- Job running well for 4/5 days.
=C2=A0- At some point, checkpoint defrag does never end on one specific i=
nstance
=C2=A0- Shutdown server does never end (waiting for the problematic insta=
nce
to shutdown but never comes)
=C2=A0- Force to kill the server process
=C2=A0- Restart server and all goes well for the next 4/5 days

The problematic instance does not mention any memory table (all cached)

For this one, as well as some others, we have
=C2=A0- SET FILES WRITE DELAY FALSE

As well as
=C2=A0- SET FILES BACKUP INCREMENT TRUE
=C2=A0- SET FILES NIO TRUE
=C2=A0- SET FILES NIO SIZE 1024

Statements such as "perform check all table index and fix" does never
end as well.

Storage / hardware is the same for all 14 instances, database "size" is
33Mb, other non-problematic databases goes beyond +600Mb

Any clues ?

--
S=C3=A9bastien


--NEpErMp0AJbsXT69KiIVhkLerq3wJzwEr--

--C0kLGYj6sBAf3VKNN94C60AhRKZbsAvJD
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQEzBAEBCAAdFiEEznMZYIYm11GH+LgZbWUMMqvegosFAmJQAukACgkQbWUMMqve
gosWYwgArg5Gv30nbhZvjNd/t1WFTDxrDQlFSMybpz7xidOeRe16hqwgFSmJFB27
BMOf9jgm5EKPXV/puKdep888tXUgOD0G9Mv69BjQgXD4WCb0gbkJRU2/2BJctJfC
vBeDuWIQUPMx0DcHCrf4Ni68SOng7vmqzPL3QrQaEIDHsmOqHJScKhQpQdOGmgFB
BMTB7CxmAZ3aoKKXqtty0fWx2CCs6poPsg7coglp6mN9dd/u0edhFkq/cRAQYV/A
b2yDdwp4+GbgUzuZ2LviUk2eapmiYkfAglUWjsbQ8vXvL6s1WdJ+wrrDdGIaD4cj
ASp1I+IxOkONs0WqhMwpO3kN8Jr27A==
=9gtC
-----END PGP SIGNATURE-----

--C0kLGYj6sBAf3VKNN94C60AhRKZbsAvJD--


--===============5915451378787291295==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline


--===============5915451378787291295==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

--===============5915451378787291295==--