db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kristian Waagan (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4075) ERROR XSDBB: Unknown page format at page Page(613,Container(0, 1024)) when running MailJdbc (Embedded) system tests
Date Tue, 10 Mar 2009 07:46:50 GMT

    [ 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.ReaderToUTF8Stream@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.


Mime
View raw message