Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 95607 invoked from network); 29 Nov 2006 15:22:10 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 29 Nov 2006 15:22:10 -0000 Received: (qmail 27526 invoked by uid 500); 29 Nov 2006 15:22:19 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 27506 invoked by uid 500); 29 Nov 2006 15:22:19 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 27495 invoked by uid 99); 29 Nov 2006 15:22:19 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 29 Nov 2006 07:22:19 -0800 X-ASF-Spam-Status: No, hits=-9.4 required=10.0 tests=ALL_TRUSTED,NO_REAL_NAME X-Spam-Check-By: apache.org Received: from [140.211.11.3] (HELO eris.apache.org) (140.211.11.3) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 29 Nov 2006 07:22:07 -0800 Received: by eris.apache.org (Postfix, from userid 65534) id 0D74A1A984D; Wed, 29 Nov 2006 07:21:30 -0800 (PST) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit 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 -0000 To: derby-commits@db.apache.org From: myrnavl@apache.org X-Mailer: svnmailer-1.1.0 Message-Id: <20061129152130.0D74A1A984D@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org 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 ...]