db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From myrn...@apache.org
Subject svn commit: r480594 [2/2] - in /db/derby/code/branches/10.2/java: drda/org/apache/derby/loc/drda/ engine/org/apache/derby/loc/ testing/org/apache/derbyTesting/functionTests/master/ testing/org/apache/derbyTesting/functionTests/master/j9_13/ testing/org...
Date Wed, 29 Nov 2006 15:21:29 GMT
Modified: db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_22/errorCode.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_22/errorCode.out?view=diff&rev=480594&r1=480593&r2=480594
==============================================================================
--- db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_22/errorCode.out (original)
+++ db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/j9_22/errorCode.out Wed Nov 29 07:21:28 2006
@@ -1,411 +1,411 @@
-ij> --
---   Licensed to the Apache Software Foundation (ASF) under one or more
---   contributor license agreements.  See the NOTICE file distributed with
---   this work for additional information regarding copyright ownership.
---   The ASF licenses this file to You under the Apache License, Version 2.0
---   (the "License"); you may not use this file except in compliance with
---   the License.  You may obtain a copy of the License at
---
---      http://www.apache.org/licenses/LICENSE-2.0
---
---   Unless required by applicable law or agreed to in writing, software
---   distributed under the License is distributed on an "AS IS" BASIS,
---   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
---   See the License for the specific language governing permissions and
---   limitations under the License.
---
---
--- this test shows the error code functionality
---
--- specify an invalid driver
-driver 'java.lang.Integer';
-IJ ERROR: Could not locate class java.lang.Integer
-ij> -- now a valid driver
-driver 'org.apache.derby.jdbc.EmbeddedDriver';
-ij> -- specify an invalid database
-connect 'asdfasdf';
-ERROR 08001: Driver not found: asdfasdf (errorCode = 0)
-ij> -- now a valid database, but no create
-connect 'jdbc:derby:wombat';
-ERROR XJ004: Database 'wombat' not found. (errorCode = 40000)
-ij> -- now a valid database
-connect 'jdbc:derby:wombat;create=true';
-ij> -- create the table
-create table t(i int, s smallint);
-0 rows inserted/updated/deleted
-ij> -- populate the table
-insert into t values (1,2);
-1 row inserted/updated/deleted
-ij> insert into t values (null,2);
-1 row inserted/updated/deleted
-ij> -- parser error
--- bug 5701
-create table t(i nt, s smallint);
-ERROR 42X01: Syntax error: Encountered "" at line 3, column 18. (errorCode = 30000)
-ij> -- non-boolean where clause
-select * from t where i;
-ERROR 42X19: The WHERE or HAVING clause or CHECK CONSTRAINT definition is a 'INTEGER' expression.  It must be a BOOLEAN expression. (errorCode = 30000)
-ij> -- invalid correlation name for "*"
-select asdf.* from t;
-ERROR 42X10: 'ASDF' is not an exposed table name in the scope in which it appears. (errorCode = 30000)
-ij> -- execution time error
-select i/0 from t;
-1          
------------
-ERROR 22012: Attempt to divide by zero. (errorCode = 30000)
-ij> -- test ErrorMessages VTI
-select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = '07000';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-07000|At least one parameter to the current statement is uninitialized.                                                               |20000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = '22012';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-22012|Attempt to divide by zero.                                                                                                      |20000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = '42X74';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-42X74|Invalid CALL statement syntax.                                                                                                  |20000      
-ij> -- test ErrorMessages VTI for severe errors
--- session_severity
-select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = '04501';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-04501|Database connection refused.                                                                                                    |40000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = '28502';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-28502|The user name '{0}' is not valid.                                                                                               |40000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XJ004';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XJ004|Database '{0}' not found.                                                                                                       |40000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XJ028';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XJ028|The URL '{0}' is not properly formed.                                                                                           |40000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XJ040';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XJ040|Failed to start database '{0}', see the next exception for details.                                                             |40000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XJ041';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XJ041|Failed to create database '{0}', see the next exception for details.                                                            |40000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XJ049';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XJ049|Conflicting create attributes specified.                                                                                        |40000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XJ081';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XJ081|Invalid value '{0}' passed as parameter '{1}' to method '{2}'                                                                   |20000      
-XJ081|Conflicting create/restore/recovery attributes specified.                                                                       |40000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XJ05B';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XJ05B|JDBC attribute '{0}' has an invalid value '{1}', valid values are '{2}'.                                                        |40000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XXXXX';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XXXXX|Normal database session close.                                                                                                  |40000      
-ij> -- database_severity
-select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM01';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XBM01|Startup failed due to an exception. See next exception for details.                                                             |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM02';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XBM02|Startup failed due to missing functionality for {0}. Please ensure your classpath includes the correct Derby software.          |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM05';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XBM05|Startup failed due to missing product version information for {0}.                                                              |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM06';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XBM06|Startup failed. An encrypted database cannot be accessed without the correct boot password.                                     |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM07';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XBM07|Startup failed. Boot password must be at least 8 bytes long.                                                                    |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM08';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XBM08|Could not instantiage {0} StorageFactory class {1}.                                                                             |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0G';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XBM0G|Failed to start encryption engine. Please make sure you are running Java 2 and have downloaded an encryption provider such as j&|45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0H';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XBM0H|Directory {0} cannot be created.                                                                                                |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0I';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XBM0I|Directory {0} cannot be removed.                                                                                                |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0J';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XBM0J|Directory {0} already exists.                                                                                                   |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0K';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XBM0K|Unknown sub-protocol for database name {0}.                                                                                     |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0L';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XBM0L|Specified authentication scheme class {0} does implement the authentication interface {1}.                                      |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0M';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XBM0M|Error creating instance of authentication scheme class {0}.                                                                     |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0N';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XBM0N|JDBC Driver registration with java.sql.DriverManager failed. See next exception for details.                                    |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0P';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XBM0P|Service provider is read-only. Operation not permitted.                                                                         |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0Q';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XBM0Q|File {0} not found. Please make sure that backup copy is the correct one and it is not corrupted.                               |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0R';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XBM0R|Unable to remove File {0}.                                                                                                      |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0S';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XBM0S|Unable to rename file '{0}' to '{1}'                                                                                            |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0T';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XBM0T|Ambiguous sub-protocol for database name {0}.                                                                                   |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0X';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XBM0X|Supplied territory description '{0}' is invalid, expecting ln[_CO[_variant]]
-ln=lower-case two-letter ISO-639 language code, CO&|45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0Y';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XBM0Y|Backup database directory {0} not found. Please make sure that the specified backup path is right.                              |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0Z';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XBM0Z|Unable to copy file '{0}' to '{1}'. Please make sure that there is enough space and permissions are correct.                    |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XCW00';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XCW00|Unsupported upgrade from '{0}' to '{1}'.                                                                                        |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLA0';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSLA0|Cannot flush the log file to disk {0}.                                                                                          |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLA1';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSLA1|Log Record has been sent to the stream, but it cannot be applied to the store (Object {0}).  This may cause recovery problems a&|45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLA2';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSLA2|System will shutdown, got I/O Exception while accessing log file.                                                               |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLA3';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSLA3|Log Corrupted, has invalid data in the log stream.                                                                              |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLA4';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSLA4|Cannot write to the log, most likely the log is full.  Please delete unnecessary files.  It is also possible that the file syst&|45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLA5';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSLA5|Cannot read log stream for some reason to rollback transaction {0}.                                                             |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLA6';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSLA6|Cannot recover the database.                                                                                                    |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLA7';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSLA7|Cannot redo operation {0} in the log.                                                                                           |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLA8';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSLA8|Cannot rollback transaction {0}, trying to compensate {1} operation with {2}                                                    |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAA';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSLAA|The store has been marked for shutdown by an earlier exception.                                                                 |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAB';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSLAB|Cannot find log file {0}, please make sure your logDevice property is properly set with the correct path separator for your pla&|45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAC';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSLAC|Database at {0} have incompatible format with the current version of software, it may have been created by or upgraded by a lat&|45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAD';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSLAD|log Record at instant {2} in log file {3} corrupted. Expected log record length {0}, real length {1}.                           |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAE';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSLAE|Control file at {0} cannot be written or updated.                                                                               |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAF';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSLAF|A Read Only database was created with dirty data buffers.                                                                       |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAH';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSLAH|A Read Only database is being updated.                                                                                          |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAI';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSLAI|Cannot log the checkpoint log record                                                                                            |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAJ';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSLAJ|The logging system has been marked to shut down due to an earlier problem and will not allow any more operations until the syst&|45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAK';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSLAK|Database has exceeded largest log file number {0}.                                                                              |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAL';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSLAL|log record size {2} exceeded the maximum allowable log file size {3}. Error encounted in log file {0}, position {1}             |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAM';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSLAM|Cannot verify database format at {1} due to IOException.                                                                        |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAN';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSLAN|Database at {0} has an incompatible format with the current version of the software.  The database was created by or upgraded b&|45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAO';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSLAO|Recovery failed unexpected problem {0}.                                                                                         |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAP';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSLAP|Database at {0} is at version {1}. Beta databases cannot be upgraded,                                                           |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAQ';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSLAQ|cannot create log file at directory {0}.                                                                                        |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAR';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSLAR|Unable to copy log file '{0}' to '{1}' during restore. Please make sure that there is enough space and permissions are correct. |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAS';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSLAS|Log directory {0} not found in backup during restore. Please make sure that backup copy is the correct one and it is not corrup&|45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAT';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSLAT|The log directory '{0}' exists. The directory might belong to another database. Check that the location specified for the logDe&|45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSDB0';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSDB1';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSDB2';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSDB3';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSDB4';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSDB5';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSDB6';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSDB7';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSDB8';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSDB9';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSDBA';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSDG0';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSDG0|Page {0} could not be read from disk.                                                                                           |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSDG1';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSDG1|Page {0} could not be written to disk, please check if disk is full.                                                            |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSDG2';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSDG2|Invalid checksum on Page {0}, expected={1}, on-disk version={2}, page dump follows: {3}                                         |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSDG3';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSDG3|Meta-data for Container {0} could not be accessed                                                                               |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSDG5';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSDG5|Database is not in create mode when createFinished is called.                                                                   |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSDG6';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSDG6|Data segment directory not found in {0} backup during restore. Please make sure that backup copy is the right one and it is not&|45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSDG7';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSDG7|Directory {0} could not be removed during restore. Please make sure that permissions are correct.                               |45000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSDG8';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSDG8|Unable to copy directory '{0}' to '{1}' during restore. Please make sure that there is enough space and permissions are correct&|45000      
-ij> -- system_severity
-select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSTB0';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSTB0|An exception was thrown during transaction abort.                                                                               |50000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSTB2';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSTB2|Cannot log transaction changes, maybe trying to write to a read only database.                                                  |50000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSTB3';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSTB3|Cannot abort transaction because the log manager is null, probably due to an earlier error.                                     |50000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSTB5';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSTB5|Creating database with logging disabled encountered unexpected problem.                                                         |50000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSTB6';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XSTB6|Cannot substitue a transaction table with another while one is already in use.                                                  |50000      
-ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XJ015';
-SQL_&|MESSAGE                                                                                                                         |SEVERITY   
---------------------------------------------------------------------------------------------------------------------------------------------------
-XJ015|Derby system shutdown.                                                                                                          |50000      
-ij> -- cleanup
-drop table t;
-0 rows inserted/updated/deleted
-ij> 
+ij> --
+--   Licensed to the Apache Software Foundation (ASF) under one or more
+--   contributor license agreements.  See the NOTICE file distributed with
+--   this work for additional information regarding copyright ownership.
+--   The ASF licenses this file to You under the Apache License, Version 2.0
+--   (the "License"); you may not use this file except in compliance with
+--   the License.  You may obtain a copy of the License at
+--
+--      http://www.apache.org/licenses/LICENSE-2.0
+--
+--   Unless required by applicable law or agreed to in writing, software
+--   distributed under the License is distributed on an "AS IS" BASIS,
+--   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+--   See the License for the specific language governing permissions and
+--   limitations under the License.
+--
+--
+-- this test shows the error code functionality
+--
+-- specify an invalid driver
+driver 'java.lang.Integer';
+IJ ERROR: Could not locate class java.lang.Integer
+ij> -- now a valid driver
+driver 'org.apache.derby.jdbc.EmbeddedDriver';
+ij> -- specify an invalid database
+connect 'asdfasdf';
+ERROR 08001: Driver not found: asdfasdf (errorCode = 0)
+ij> -- now a valid database, but no create
+connect 'jdbc:derby:wombat';
+ERROR XJ004: Database 'wombat' not found. (errorCode = 40000)
+ij> -- now a valid database
+connect 'jdbc:derby:wombat;create=true';
+ij> -- create the table
+create table t(i int, s smallint);
+0 rows inserted/updated/deleted
+ij> -- populate the table
+insert into t values (1,2);
+1 row inserted/updated/deleted
+ij> insert into t values (null,2);
+1 row inserted/updated/deleted
+ij> -- parser error
+-- bug 5701
+create table t(i nt, s smallint);
+ERROR 42X01: Syntax error: Encountered "" at line 3, column 18. (errorCode = 30000)
+ij> -- non-boolean where clause
+select * from t where i;
+ERROR 42X19: The WHERE or HAVING clause or CHECK CONSTRAINT definition is a 'INTEGER' expression.  It must be a BOOLEAN expression. (errorCode = 30000)
+ij> -- invalid correlation name for "*"
+select asdf.* from t;
+ERROR 42X10: 'ASDF' is not an exposed table name in the scope in which it appears. (errorCode = 30000)
+ij> -- execution time error
+select i/0 from t;
+1          
+-----------
+ERROR 22012: Attempt to divide by zero. (errorCode = 30000)
+ij> -- test ErrorMessages VTI
+select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = '07000';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+07000|At least one parameter to the current statement is uninitialized.                                                               |20000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = '22012';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+22012|Attempt to divide by zero.                                                                                                      |20000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = '42X74';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+42X74|Invalid CALL statement syntax.                                                                                                  |20000      
+ij> -- test ErrorMessages VTI for severe errors
+-- session_severity
+select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = '04501';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+04501|Database connection refused.                                                                                                    |40000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = '28502';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+28502|The user name '{0}' is not valid.                                                                                               |40000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XJ004';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XJ004|Database '{0}' not found.                                                                                                       |40000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XJ028';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XJ028|The URL '{0}' is not properly formed.                                                                                           |40000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XJ040';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XJ040|Failed to start database '{0}', see the next exception for details.                                                             |40000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XJ041';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XJ041|Failed to create database '{0}', see the next exception for details.                                                            |40000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XJ049';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XJ049|Conflicting create attributes specified.                                                                                        |40000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XJ081';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XJ081|Invalid value '{0}' passed as parameter '{1}' to method '{2}'                                                                   |20000      
+XJ081|Conflicting create/restore/recovery attributes specified.                                                                       |40000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XJ05B';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XJ05B|JDBC attribute '{0}' has an invalid value '{1}', valid values are '{2}'.                                                        |40000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XXXXX';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XXXXX|Normal database session close.                                                                                                  |40000      
+ij> -- database_severity
+select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM01';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XBM01|Startup failed due to an exception. See next exception for details.                                                             |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM02';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XBM02|Startup failed due to missing functionality for {0}. Please ensure your classpath includes the correct Derby software.          |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM05';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XBM05|Startup failed due to missing product version information for {0}.                                                              |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM06';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XBM06|Startup failed. An encrypted database cannot be accessed without the correct boot password.                                     |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM07';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XBM07|Startup failed. Boot password must be at least 8 bytes long.                                                                    |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM08';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XBM08|Could not instantiate {0} StorageFactory class {1}.                                                                             |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0G';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XBM0G|Failed to start encryption engine. Please make sure you are running Java 2 and have downloaded an encryption provider such as j&|45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0H';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XBM0H|Directory {0} cannot be created.                                                                                                |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0I';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XBM0I|Directory {0} cannot be removed.                                                                                                |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0J';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XBM0J|Directory {0} already exists.                                                                                                   |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0K';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XBM0K|Unknown sub-protocol for database name {0}.                                                                                     |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0L';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XBM0L|Specified authentication scheme class {0} does implement the authentication interface {1}.                                      |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0M';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XBM0M|Error creating instance of authentication scheme class {0}.                                                                     |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0N';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XBM0N|JDBC Driver registration with java.sql.DriverManager failed. See next exception for details.                                    |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0P';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XBM0P|Service provider is read-only. Operation not permitted.                                                                         |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0Q';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XBM0Q|File {0} not found. Please make sure that backup copy is the correct one and it is not corrupted.                               |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0R';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XBM0R|Unable to remove File {0}.                                                                                                      |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0S';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XBM0S|Unable to rename file '{0}' to '{1}'                                                                                            |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0T';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XBM0T|Ambiguous sub-protocol for database name {0}.                                                                                   |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0X';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XBM0X|Supplied territory description '{0}' is invalid, expecting ln[_CO[_variant]]
+ln=lower-case two-letter ISO-639 language code, CO&|45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0Y';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XBM0Y|Backup database directory {0} not found. Please make sure that the specified backup path is right.                              |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XBM0Z';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XBM0Z|Unable to copy file '{0}' to '{1}'. Please make sure that there is enough space and permissions are correct.                    |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XCW00';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XCW00|Unsupported upgrade from '{0}' to '{1}'.                                                                                        |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLA0';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XSLA0|Cannot flush the log file to disk {0}.                                                                                          |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLA1';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XSLA1|Log Record has been sent to the stream, but it cannot be applied to the store (Object {0}).  This may cause recovery problems a&|45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLA2';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XSLA2|System will shutdown, got I/O Exception while accessing log file.                                                               |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLA3';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XSLA3|Log Corrupted, has invalid data in the log stream.                                                                              |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLA4';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XSLA4|Cannot write to the log, most likely the log is full.  Please delete unnecessary files.  It is also possible that the file syst&|45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLA5';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XSLA5|Cannot read log stream for some reason to rollback transaction {0}.                                                             |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLA6';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XSLA6|Cannot recover the database.                                                                                                    |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLA7';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XSLA7|Cannot redo operation {0} in the log.                                                                                           |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLA8';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XSLA8|Cannot rollback transaction {0}, trying to compensate {1} operation with {2}                                                    |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAA';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XSLAA|The store has been marked for shutdown by an earlier exception.                                                                 |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAB';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XSLAB|Cannot find log file {0}, please make sure your logDevice property is properly set with the correct path separator for your pla&|45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAC';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XSLAC|Database at {0} have incompatible format with the current version of software, it may have been created by or upgraded by a lat&|45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAD';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XSLAD|log Record at instant {2} in log file {3} corrupted. Expected log record length {0}, real length {1}.                           |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAE';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XSLAE|Control file at {0} cannot be written or updated.                                                                               |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAF';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XSLAF|A Read Only database was created with dirty data buffers.                                                                       |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAH';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XSLAH|A Read Only database is being updated.                                                                                          |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAI';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XSLAI|Cannot log the checkpoint log record                                                                                            |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAJ';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XSLAJ|The logging system has been marked to shut down due to an earlier problem and will not allow any more operations until the syst&|45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAK';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XSLAK|Database has exceeded largest log file number {0}.                                                                              |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAL';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XSLAL|log record size {2} exceeded the maximum allowable log file size {3}. Error encountered in log file {0}, position {1}.          |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAM';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XSLAM|Cannot verify database format at {1} due to IOException.                                                                        |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAN';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XSLAN|Database at {0} has an incompatible format with the current version of the software.  The database was created by or upgraded b&|45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAO';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XSLAO|Recovery failed unexpected problem {0}.                                                                                         |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAP';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XSLAP|Database at {0} is at version {1}. Beta databases cannot be upgraded,                                                           |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAQ';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XSLAQ|cannot create log file at directory {0}.                                                                                        |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAR';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XSLAR|Unable to copy log file '{0}' to '{1}' during restore. Please make sure that there is enough space and permissions are correct. |45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAS';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XSLAS|Log directory {0} not found in backup during restore. Please make sure that backup copy is the correct one and it is not corrup&|45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSLAT';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+XSLAT|The log directory '{0}' exists. The directory might belong to another database. Check that the location specified for the logDe&|45000      
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSDB0';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSDB1';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSDB2';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSDB3';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSDB4';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSDB5';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSDB6';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSDB7';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSDB8';
+SQL_&|MESSAGE                                                                                                                         |SEVERITY   
+--------------------------------------------------------------------------------------------------------------------------------------------------
+ij> select * from new org.apache.derby.diag.ErrorMessages() c where sql_state = 'XSDB9';

[... 67 lines stripped ...]


Mime
View raw message