[
https://issues.apache.org/jira/browse/DERBY-4075?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12680398#action_12680398
]
Kristian Waagan commented on DERBY-4075:
----------------------------------------
My tests have been running since the 27th, 5th and 6th. The database sizes vary
from 7.2 GB to 11 GB.
I have seen the following errors in derby.log (merged output from all three
runs, grep error | sort -u, removed one caused by):
ERROR 23505: The statement was aborted because it would have caused a duplicate
key value in a unique or primary key constraint or unique index identified by
'ATTACH__PK' defined on 'ATTACH'.
ERROR 38000: The exception 'java.sql.SQLException: User 'BACKUP' can not
perform the operation in schema 'REFRESH'.' was thrown while evaluating an
expression.
ERROR 40001: A lock could not be obtained due to a deadlock, cycle of locks and
waiters is:
ERROR 40XL1: A lock could not be obtained within the time requested
ERROR 42504: User 'BACKUP' does not have execute permission on PROCEDURE
'SYSCS_UTIL'.'SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE_NOWAIT'.
ERROR 42507: User 'BACKUP' can not perform the operation in schema 'REFRESH'.
ERROR 42Z60: GRANT not allowed unless database property
derby.database.sqlAuthorization has value 'TRUE'.
I'll restart the two newer tests, removing derby.properties.
> ERROR XSDBB: Unknown page format at page Page(613,Container(0, 1024)) when
> running MailJdbc (Embedded) system tests
> -------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-4075
> URL: https://issues.apache.org/jira/browse/DERBY-4075
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.5.0.0
> Environment: windows 2000 professional, ibm 1.6 (sr2), revision 10.5:
> 745360
> Reporter: Myrna van Lunteren
> Priority: Blocker
> Fix For: 10.5.0.0
>
> Attachments: Activity.out, derbylog.zip, performance.out
>
>
> I started the org.apache.derbyTesting.system.mailJdbc Embedded test and after
> about 1 day it ran into an apparently corrupted database.
> 2009-02-19 14:02:44.221 GMT Thread[Refresh Thread,5,main] (XID = 349909),
> (SESSIONID = 1), (DATABASE = mailsdb), (DRDAID = null), Failed Statement is:
> insert into
> REFRESH.INBOX(from_name,to_name,date,Message,attach_id,size_problem) values
> (?,?,?,?,?,?) with 6 parameters begin parameter #1: ABCE :end parameter begin
> parameter #2: WXYY :end parameter begin parameter #3: 2009-02-19 06:02:43.705
> :end parameter begin parameter #4:
> CLOB(org.apache.derby.iapi.types.readertoutf8str...@41ba41ba) :end parameter
> begin parameter #5: 0 :end parameter begin parameter #6: This column is used
> only to by pass the space problem. If the problem still exists, then we are
> going to have a serious issue
> here.*****************************************************************************************************
> :end parameter
> ERROR XSDBB: Unknown page format at page Page(613,Container(0, 1024)), page
> dump follows: Hex dump:
> The error up to that point appear to me no different from other errors that
> this test is expected to produce (40001, 23505, 4XL01) except that the very
> first error is a grant error.
> I think we can't have a release until this corruption is explained away or
> fixed.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
