[
https://issues.apache.org/jira/browse/DERBY-6398?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13815517#comment-13815517
]
Marty Backe edited comment on DERBY-6398 at 11/7/13 1:52 AM:
-------------------------------------------------------------
Auto-commit is not configured either way in our application. So I believe the
default is, auto-commit = on
There is one connection object for the life of the application, so yes, the
large update is performed using the same connection object as the freeze
command.
The large update is an INSERT for a CLOB column
I will try and modify Derby as you suggest.
was (Author: martybacke):
Auto-commit is not configured either way in our application. So I believe the
default is, auto-connect = on
There is one connection object for the life of the application, so yes, the
large update is performed using the same connection object as the freeze
command.
The large update is an INSERT for a CLOB column
I will try and modify Derby as you suggest.
> 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
>
> Attachments: report.txt
>
>
> 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)
