----------------------------------------------------------------------

ELOQUENCE B.08.30 - patch PE83-1909130

----------------------------------------------------------------------

This patch adds enhancements or fixes defects of the eloqdb server
as released with Eloquence B.08.30-1810. This patch will be integrated
in the Eloquence B.08.30 release.

Eloquence B.08.30-1810 must be installed before applying this patch.

Severity:
 PE83-1909130: BUG FIX

Superseded patches:
 PE83-1907090: BUG FIX
 PE83-1906240: BUG FIX
 PE83-1905220: BUG FIX
 PE83-1903040: BUG FIX


Patch PE83-1909130
------------------

Platforms: All

* Fixed a potential deadlock condition which could happen on a replication
  slave server if an FTS query was executed while FTS updates were
  replicated (#4263).

Platforms: HP-UX and Linux

* Fixed a problem where some files were not closed on a eloqdb server
  panic and automatic restart (#4301).

Platforms: Linux

* Fixed a problem where an eloqdb server panic and automatic restart
  could ignore command line arguments.


Patch PE83-1907090
------------------

Platforms: All

* Fixed a rare race condition where enumerating the internal threads
  could access a terminating thread (#4061). This could in some cases
  result in a failed lock or removal operation.
  Threads are enumerated when using the http status or the dbctl list
  functionality. An error message as below was logged

    T0: [#] pthread_mutex_destroy(p_mutex) failed (errno 16)

    T0: [#] pthread_mutex_lock(tcp->p_mutex) failed (errno 22)
    D0: [#] server panic: Fatal problem detected in thread__lock

* Sync forward log file changes to disk on a checkpoint. In case
  of a system abort this limits data loss in the forward log to the
  last checkpoint and ensures replication can be resumed.


Patch PE83-1906240
------------------

Platforms: All

* Fixed a problem where a replication slave server could abort with
  a message like below while processing a large transaction (#4292):

  Fwr_PageHashAdd() failed: key ... already present ...
  server panic: Fatal problem detected in Fwr_PageHash__Add
  Assertion failed: Fwr_PageHashAdd() failed: key already present
  server panic: Aborting on internal failure, file volfwr.c ...

Notes / Related patches:

* Patch PE83-1906241 or superseding (dbrecover utility) fixes a related
  problem and should be installed with this patch.


Patch PE83-1905220
------------------

Platforms: All

* Improved async disk i/o overhead with replication.

* HP-UX: Fixed possible latency problem on I/O completion using Posix
  async I/O and replication.

* HP-UX: When using Posix async I/O the configured number of eloqdb
  I/O threads ([Config] AIOThreads) is now ignored other than a
  non-zero value is used to enable async I/O.
  Two threads are used: One thread to handle I/O completion and
  a second thread to handle a possible resource shortage when
  submitting disk read requests.


Patch PE83-1903040
------------------

Platforms: All

* Fixed database server internal deadlock condition that could in rare
  cases result in a hanging server process (#4285).

  A deadlock condition was fixed in the database server cache management
  that could result in a (partially) hanging server process.
  A thread status (dbctl list thread or thread status dumped on shutdown)
  indicates a block in the mpool subsystem.

  This was caused by a potential lock ordering problem when a cache buffer
  was reused by a concurrent connection.


Installation:
-------------

Please download the patch archive that corresponds with the installed
release.  The patch files follow the conventions below:

   PE83-1909130-hpux-ia64.tar.gz
        ^       ^    ^
        |       |    Architecture / OS specific build
        |       Operating system
        Patch ID


HP-UX IA64:

In order to install this patch, you need to unpack it with gzip and tar.
Gzip is included with HP-UX. Installation requires root privileges.

cd /opt/eloquence/8.3
gzip -dc /path/to/PE83-1909130-hpux.tar.gz | tar xf -

Files:

   bin/eloqdb (database server)
   share/doc/PE83-1909130-README


HP-UX PA-RISC:

In order to install this patch, you need to unpack it with gzip and tar.
Gzip is included with HP-UX. Installation requires root privileges.

cd /opt/eloquence/8.3
gzip -dc /path/to/PE83-1909130-hpux.tar.gz | tar xf -

Files:

   bin/eloqdb32 (32 bit database server)
   bin/eloqdb64 (64 bit database server)
   share/doc/PE83-1909130-README


Linux:

In order to install this patch, you need to unpack it with tar.
Installation requires root privileges.

cd /opt/eloquence/8.3
tar xzf /path/to/PE83-1909130-linux.tar.gz

Files:

   bin/eloqdb (database server)
   share/doc/PE83-1909130-README


Windows:

Two options are available for patch installation. The patch is
available as self extracting archive for automatic installation
and as a zip archive for manual installation. Both patches are
equivalent. Installation requires administrative capabilities.

For automatic installation of this patch, please download the patch
file PE83-1909130-win32.exe. Before installation, please consider
stopping the database server, then execute the patch installation
program. Installation does not require a reboot unless the patched
files were active.

For a manual installation of the patch, please download the patch
file PE83-1909130-win32.zip and unpack its contents. Then perform
the following steps:

* Please make sure the eloqdb service is stopped before installing
  the patch (in the Service Control Manager or with net stop eloqdb).

* Please copy the eloqdb32.exe file into the Eloquence bin directory.
  (Default location: C:\Program Files\Eloquence\8.3\bin)

* Please copy the eloqdb64.exe file into the Eloquence bin64 directory.
  (Default location: C:\Program Files\Eloquence\8.3\bin64)

* Please copy the PE83-1909130-README.txt file into the Eloquence
  share\doc directory.
  (Default location: C:\Program Files\Eloquence\8.3\share\doc)

Files:

   eloqdb32.exe (32 bit database server)
   eloqdb64.exe (64 bit database server)
   PE83-1909130-README.txt