Marty Backe created DERBY-6398:
----------------------------------
Summary: SYSCS_FREEZE_DATABASE locks-up if there are large records
that haven't been flushed to the disk
Key: DERBY-6398
URL: https://issues.apache.org/jira/browse/DERBY-6398
Project: Derby
Issue Type: Bug
Components: Miscellaneous
Affects Versions: 10.10.1.1
Environment: Reliably demonstrated on Windows 7 with JDK 1.6.0_31
Reporter: Marty Backe
Fix For: 10.10.1.1
If after writing a record that contains a large data column (>100KB), the
FREEZE command is issued, the command never returns (Derby appears to be
dead-locked).
E.g. sqlStatement.executeUpdate("CALL SYSCS_UTIL.SYSCS_FREEZE_DATABASE()");
If the CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE() command is first used before
calling FREEZE, it does not lock-up.
It's my opinion that calling FREEZE should never result in a dead-locked Derby
instance.
--
This message was sent by Atlassian JIRA
(v6.1#6144)