db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Matrigali <mikem_...@sbcglobal.net>
Subject Re: failure in lang/miscerrors, anyone?
Date Sun, 12 Jun 2005 15:39:16 GMT
The XID can vary just based on background thread activity, so from 
machine to machine it can vary.  Since release build runs much faster
than SANE build this can be a reason for different background thread
timing.  The background threads reclaim space and each
space reclamation operation is a transaction, which will bump the
transaction number.

Also whenever some object is added to the system catalogs, then the
total amount of space in the database may change which also may change
the transaction number.

David Van Couvering wrote:
> It appears the XID is different for different runs.  I had assumed this 
> would be an invariant, but it's not.
> 
> This has convinced me that I should pull away from using a master file 
> to verify the correct format of the ids.  Instead I will write a new 
> test that does this verification.
> 
> For now, however, I am providing a patch that reverts miscerrors.sql and 
> miscerrors.out to their previous form.  I will create a new JIRA id to 
> add a test to verify that the format of the connection string is correct.
> 
> I ran this against lang/miscerrors.sql and it passes. I did not see that 
> it was necessary to run derbyall, as this is a very localized bug in a 
> single test.  It would be great if the committer verifies miscerrors.sql 
> passes for them too prior to checkin.
> 
> Thanks,
> 
> David
> 
> Myrna van Lunteren wrote:
> 
>> Hi,
>>  
>> lang/miscerrors failed, at least with 189787 (see 
>> http://www.multinet.no/~solberg/public/Apache/Derby/index.html/testSummary-189787.html

>> <http://www.multinet.no/~solberg/public/Apache/Derby/index.html/testSummary-189787.html>)

>>
>>  
>> Interestingly, our nightlies showed a different diff (build 189872), 
>> but still the test fails...
>>  
>> Anyone thinks this might be related to their check-in/commit?
>>  
>>  
>> diff1 (our run, build :
>> -------------------------
>> 35 del
>> < 
>> xxxxxxFILTERED-TIMESTAMPxxxxx|main,5,main                             
>> |92             |0              | 
>> wombat                                                                          
                                              
>> | null                                             |Cleanup action 
>> starting                                                                        
                                
>>
>> 36 del
>> < 
>> xxxxxxFILTERED-TIMESTAMPxxxxx|main,5,main                             
>> |92             |0              | 
>> wombat                                                                          
                                              
>> | null                                             |Failed Statement 
>> is: 
>> --                                                                              
                          
>>
>> 37 del
>> < 
>> xxxxxxFILTERED-TIMESTAMPxxxxx|main,5,main                             
>> |97             |0              | 
>> wombat                                                                          
                                              
>> | null                                             |Cleanup action 
>> starting                                                                        
                                
>>
>> 38 del
>> < 
>> xxxxxxFILTERED-TIMESTAMPxxxxx|main,5,main                             
>> |97             |0              | 
>> wombat                                                                          
                                              
>> | null                                             |Failed Statement 
>> is: create table a (one int, two 
>> int)                                                                          
>>
>> 39 del
>> < 
>> xxxxxxFILTERED-TIMESTAMPxxxxx|main,5,main                             
>> |100            |0              | 
>> wombat                                                                          
                                              
>> | null                                             |Cleanup action 
>> starting                                                                        
                                
>>
>> 40 del
>> < 
>> xxxxxxFILTERED-TIMESTAMPxxxxx|main,5,main                             
>> |100            |0              | 
>> wombat                                                                          
                                              
>> | null                                             |Failed Statement 
>> is: create table a (one 
>> int)                                                                            
      
>>
>> 40a35,40
>>  > 
>> xxxxxxFILTERED-TIMESTAMPxxxxx|main,5,main                             
>> |91             |0              | 
>> wombat                                                                          
                                              
>> | null                                             |Cleanup action 
>> starting                                                                        
                                
>>
>>  > 
>> xxxxxxFILTERED-TIMESTAMPxxxxx|main,5,main                             
>> |91             |0              | 
>> wombat                                                                          
                                              
>> | null                                             |Failed Statement 
>> is: 
>> --                                                                              
                          
>>
>>  > 
>> xxxxxxFILTERED-TIMESTAMPxxxxx|main,5,main                             
>> |96             |0              | 
>> wombat                                                                          
                                              
>> | null                                             |Cleanup action 
>> starting                                                                        
                                
>>
>>  > 
>> xxxxxxFILTERED-TIMESTAMPxxxxx|main,5,main                             
>> |96             |0              | 
>> wombat                                                                          
                                              
>> | null                                             |Failed Statement 
>> is: create table a (one int, two 
>> int)                                                                          
>>
>>  > 
>> xxxxxxFILTERED-TIMESTAMPxxxxx|main,5,main                             
>> |99             |0              | 
>> wombat                                                                          
                                              
>> | null                                             |Cleanup action 
>> starting                                                                        
                                
>>
>>  > 
>> xxxxxxFILTERED-TIMESTAMPxxxxx|main,5,main                             
>> |99             |0              | 
>> wombat                                                                          
                                              
>> | null                                             |Failed Statement 
>> is: create table a (one 
>> int)                                                                            
      
>>
>> Test Failed.
>> -------------------------
>>  
>> sun run, diff build 189787:
>> -------------------------
>> 35,40d34
>> < 
>> xxxxxxFILTERED-TIMESTAMPxxxxx|main,5,main                             
>> |92             |0              | 
>> wombat                                                                          
                                              
>> | null                                             |Cleanup action 
>> starting                                                                        
                                
>>
>> < 
>> xxxxxxFILTERED-TIMESTAMPxxxxx|main,5,main                             
>> |92             |0              | 
>> wombat                                                                          
                                              
>> | null                                             |Failed Statement 
>> is: 
>> --                                                                              
                          
>>
>> < 
>> xxxxxxFILTERED-TIMESTAMPxxxxx|main,5,main                             
>> |97             |0              | 
>> wombat                                                                          
                                              
>> | null                                             |Cleanup action 
>> starting                                                                        
                                
>>
>> < 
>> xxxxxxFILTERED-TIMESTAMPxxxxx|main,5,main                             
>> |97             |0              | 
>> wombat                                                                          
                                              
>> | null                                             |Failed Statement 
>> is: create table a (one int, two 
>> int)                                                                          
>>
>> < 
>> xxxxxxFILTERED-TIMESTAMPxxxxx|main,5,main                             
>> |100            |0              | 
>> wombat                                                                          
                                              
>> | null                                             |Cleanup action 
>> starting                                                                        
                                
>>
>> < 
>> xxxxxxFILTERED-TIMESTAMPxxxxx|main,5,main                             
>> |100            |0              | 
>> wombat                                                                          
                                              
>> | null                                             |Failed Statement 
>> is: create table a (one 
>> int)                                                                            
      
>>
>> Test Failed.
>>  
>>  
>>  
> 
> 
> ------------------------------------------------------------------------
> 
> Index: java/testing/org/apache/derbyTesting/functionTests/tests/lang/miscerrors.sql
> ===================================================================
> --- java/testing/org/apache/derbyTesting/functionTests/tests/lang/miscerrors.sql	(revision
190034)
> +++ java/testing/org/apache/derbyTesting/functionTests/tests/lang/miscerrors.sql	(working
copy)
> @@ -29,5 +29,3 @@
>  -- set isolation to repeatable read
>  set isolation serializable;
>  
> --- Print the output of the ErrorLogVTI, make sure it's valid
> -SELECT * FROM new org.apache.derby.diag.ErrorLogReader() vti;
> Index: java/testing/org/apache/derbyTesting/functionTests/master/miscerrors.out
> ===================================================================
> --- java/testing/org/apache/derbyTesting/functionTests/master/miscerrors.out	(revision
190034)
> +++ java/testing/org/apache/derbyTesting/functionTests/master/miscerrors.out	(working
copy)
> @@ -28,14 +28,4 @@
>  ij> -- set isolation to repeatable read
>  set isolation serializable;
>  0 rows inserted/updated/deleted
> -ij> -- Print the output of the ErrorLogVTI, make sure it's valid
> -SELECT * FROM new org.apache.derby.diag.ErrorLogReader() vti;
> -TS                        |THREADID                                |XID            |LCCID
         |DATABASE                                                                       
                                                |DRDAID                                  
         |LOGTEXT                                                                        
                                                
> -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> -xxxxxxFILTERED-TIMESTAMPxxxxx|main,5,main                             |92          
  |0              | wombat                                                               
                                                         | null                          
                  |Cleanup action starting                                               
                                                         
> -xxxxxxFILTERED-TIMESTAMPxxxxx|main,5,main                             |92          
  |0              | wombat                                                               
                                                         | null                          
                  |Failed Statement is: --                                               
                                                         
> -xxxxxxFILTERED-TIMESTAMPxxxxx|main,5,main                             |97          
  |0              | wombat                                                               
                                                         | null                          
                  |Cleanup action starting                                               
                                                         
> -xxxxxxFILTERED-TIMESTAMPxxxxx|main,5,main                             |97          
  |0              | wombat                                                               
                                                         | null                          
                  |Failed Statement is: create table a (one int, two int)                
                                                         
> -xxxxxxFILTERED-TIMESTAMPxxxxx|main,5,main                             |100         
  |0              | wombat                                                               
                                                         | null                          
                  |Cleanup action starting                                               
                                                         
> -xxxxxxFILTERED-TIMESTAMPxxxxx|main,5,main                             |100         
  |0              | wombat                                                               
                                                         | null                          
                  |Failed Statement is: create table a (one int)                         
                                                         
>  ij> 


Mime
View raw message