IC91007: SERVER DEADLOCKS AFTER A FALSE CHECKPOINT COMPLETION

7.0 Fix Pack 6 download information for IBM solidDB

APAR status

• Closed as program error.

Error description

• When creating a checkpoint, the checkpoint
  flushing times out. However, only a second later, solidDB
  returns a message that a checkpoint creation has completed,
  although there might have been almost a million pages to be
  flushed. The false completion of the checkpoint might lead to a
  deadlock.
  
  2013-02-25 15:10:32 Checkpoint DBE flushing timed out, 793081 of
  793081 pages left.
  
  2013-02-25 15:10:33 Checkpoint creation completed
  2013-02-25 15:10:33 Checkpoint creation started
  2013-02-25 15:48:18 Checkpoint not started; denied by user
  callback.
  2013-02-25 15:48:18 Checkpoint not started; denied by user
  callback.
  
  
  When you try to restart the server, the startup fails with the
  following type of error. The database file is corrupted, most
  likely due to the unfinished checkpoint flushing.
  
  ------------------------------------------------------------
  2013-02-25 15:51:20
  Version: 6.5.0.5 Build 2011-03-01
  Operating system: Windows NT 6.1 AMD64 64bit MT
  IBM solidDB - Version 6.5.0.5 Build 2011-03-01 (Windows NT 6.1
  AMD64 64bit MT)
  Copyright Oy International Business Machines Ab 1993, 2011.
  Using license file C:\Solid\solid.lic
  IBM solidDB 6.5
  Current working directory changed to d:\Database\solid
  Using configuration file d:\Database\solid\solid.ini
  2013-02-25 15:51:22 IBM solidDB process has encountered an
  internal error and is unable to
  continue normally. The database file is incomplete or corrupt.
  If the file is on a hot
  standby secondary server, use the 'hotstandby copy' or
  'hotstandby netcopy'
  command to send the file from the primary server again. If you
  use the
  'hotstandby' command, make sure that
  2013-02-25 15:51:22 Server emergency shutdown.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users.                                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM solidDB V7.0 Interim Fix 8.                   *
  ****************************************************************
  

Problem conclusion

• Fix is included in IBM solidDB V7.0 Interim Fix 8.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  IC91006

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  SOLIDDB-DB2/IDS

• Fixed component ID

  5724V1700

Applicable component levels

• R650 PSY

     UP

• R700 PSY

     UP