[jira] [Commented] (DERBY-6979) Derby is still in read-only mode，even through I had released the disk space, and can't update data in database

["jiangchao (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DERBY-6979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16274041#comment-16274041 ] 

jiangchao commented on DERBY-6979:
----------------------------------

The repro steps you described are completely accurate.
What we use is embedded.
The problem is easy to reproduce, but now I don't have the environment to reproduce it, so no log can be provided.
I hope this feature will fall into your implementation plan soon.
Thanks ！


> Derby is still in read-only mode，even through I had released the disk space, and can't update data in database
> --------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-6979
>                 URL: https://issues.apache.org/jira/browse/DERBY-6979
>             Project: Derby
>          Issue Type: Bug
>            Reporter: jiangchao
>
> I cleaned up disk and there are 80% of disk is freed for derby. But the derby is still in read-only mode:
> java.sql.SQLException: An SQL data change is not permitted for a read-only connection, user or database.
> org.apache.derby.impl.jdbc.EmbedSQLException: An SQL data change is not permitted for a read-only connection, user or database.
> org.apache.derby.iapi.error.StandardException: An SQL data change is not permitted for a read-only connection, user or database.
> Caused by: java.io.IOException: No space left on device
>         at java.io.RandomAccessFile.writeBytes0(Native Method)
>         at java.io.RandomAccessFile.writeBytes(RandomAccessFile.java:520)
>         at java.io.RandomAccessFile.write(RandomAccessFile.java:550)
>         at org.apache.derby.impl.store.raw.log.LogAccessFile.writeToLog(Unknown Source)
>         at org.apache.derby.impl.store.raw.log.LogAccessFile.flushDirtyBuffers(Unknown Source)
>         ... 23 more



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)