File: //usr/lib/x86_64-linux-gnu/firebird/3.0/firebird.msg
E /1 < arithmetic exception, numeric overflow, or string truncation invalid database key file @1 is not a valid database . invalid database handle (no active connection) + bad parameters on attach or create database % unrecognized database parameter block invalid request handle invalid BLOB handle invalid BLOB ID
0 invalid parameter in transaction parameter block . invalid format for transaction parameter block A invalid transaction handle (expecting explicit transaction start)
( internal Firebird consistency check (@1) ! conversion error from string "@1" " database file appears corrupt (@1) deadlock * attempt to start more than @1 transactions # no match for first value expression 3 information type inappropriate for object specified : no information of this type available for object specified unknown information item ; action cancelled by trigger (@1) to preserve data integrityr invalid request BLR at offset @1 - I/O error during "@1" operation for file "@2"ata $ lock conflict on no wait transaction corrupt system table * validation error for column @1, value "@2"me % no current record for fetch operation V attempt to store duplicate value (visible to active transactions) in unique index "@1"et 4 program attempted to exit without finishing database unsuccessful metadata update $ no permission for @1 access to @2 @3! transaction is not in limboc" invalid database key# BLOB was not closed $ metadata is obsolete% = cannot disconnect database with open transactions (@1 active) tr& 2 message length error (encountered @1, expected @2) ' $ attempted update of read-only column( # attempted update of read-only tablet) - attempted update during read-only transactionnfo* cannot update read-only view @1 + no transaction for requestr , request synchronization error - * request referenced an unavailable databasedu. + segment buffer length shorter than expectedn/ / attempted retrieval of more segments than existe0 % attempted invalid operation on a BLOB "@1 " attempted read of a new, open BLOBer2 , attempted action on BLOB outside transaction3 ! attempted write to read-only BLOBnde4 3 attempted reference to BLOB in unavailable database 5 $ operating system directive @1 failed6 8 attempt to fetch past the last record in a record stream7 unavailable database8 8 table @1 was omitted from the transaction reserving list9 F request includes a DSRI extension not supported in this implementationtr: feature is not supported; E unsupported on-disk structure for file @1; found @2.@3, support @4.@5 < ! wrong number of arguments on call = Implementation limit exceedednsa> @1 ? 0 unrecoverable conflict with limbo transaction @1@ internal error A internal error aB too many requests C internal errorgtD - block size exceeds implementation restrictionf mE buffer exhaustedF : BLR syntax error: expected @1 at offset @2, encountered @3reG
buffer in useBerH internal erroronI request in useacJ ) incompatible version of on-disk structure K table @1 is not defined L $ column @1 is not defined in table @2M internal erroredN internal errorchO internal errorinP internal error Q internal error R internal erroredS 0 page @1 is of wrong type (expected @2, found @3)T database corruptedsuU " checksum error on database page @1atV index is broken W database handle not zeroX transaction handle not zero Y 5 transaction--request mismatch (synchronization error)mplZ bad handle count[ , wrong version of transaction parameter block\ 5 unsupported BLR version (expected @1, encountered @2) ] ) wrong version of database parameter blockoo ^ < BLOB and array data types are not supported for @1 operation_ database corrupted m` internal erroreda internal errororb transaction in limboc transaction not in limbod transaction outstandingne ' connection rejected by remote interfacerf internal errorurg internal errors h no lock manager availablenoti " context already in use (BLR error)edj context not defined (BLR error)lk data operation not supportedl undefined message numberm undefined parameter numberwrn / unable to allocate memory from operating systemto ! blocking signal has been receivedge p lock manager errorn q % communication error with journal "@1"actr : key size exceeds implementation restriction for index "@1"nis null segment of UNIQUE KEY ct SQL error code = @1fu wrong DYN version v function @1 is not definedxpw function @1 could not be matchedx y % database detach completed with errorsandz ' database system cannot read argument @1a{ ( database system cannot write argument @1| operation not supportedr} @1 extension errorbo~
not updatableot no rollback performeduts @1 r ' update conflicts with concurrent updater product @1 is not licensed object @1 is in uset . filter not found to convert type @1 to type @2nt cannot attach active shadow file / invalid slice description language at offset @1r subscript out of boundsb D column not array or invalid dimensions (expected @1, encountered @2) , record from transaction @1 is stuck in limbo ) a file in manual shadow @1 is unavailableact 6 secondary server attachments cannot validate databases"@ 4 secondary server attachments cannot start journaling generator @1 is not defined 1 secondary server attachments cannot start loggingoul invalid BLOB type for operatione 6 violation of FOREIGN KEY constraint "@1" on table "@2" r + minor version too high found @1 expected @2e transaction @1 is @2 2 transaction marked invalid and cannot be committedda cache buffer for page @1 invalid ( there is no index in table @1 with id @2 h Your user name and password are not defined. Ask your database administrator to set up a Firebird login. invalid bookmark handle invalid lock level @1ive - lock on table @1 conflicts with existing locke a 2 requested record lock conflicts with existing lock n ' maximum indexes per table (@1) exceededc 7 enable journal for database before starting online dumpo online dump failure. Retry dumpn % an online dump is already in progressnts 5 no more disk/tape space. Cannot continue online dumpnts 7 journaling allowed only if database has Write-ahead Log ? maximum number of online dump files that can be specified is 16a 5 error in opening Write-ahead Log file during recoverycon invalid statement handle ! Write-ahead log subsystem failureted WAL Writer error Log file header of @1 too smalll Invalid version of log file @1ch ; Log file @1 not latest in the chain but open flag still seti B Log file @1 not closed properly; database recovery may be requiredba - Database name in the log file @1 is differentnva * Unexpected end of log file @1 at offset @2ve 1 Incomplete log record at offset @1 in log file @2 7 Log record header too small at offset @1 in log file @2 / Log block too small at offset @1 in log file @2j @ Illegal attempt to attach to an uninitialized WAL segment for @1 % Invalid WAL parameter block option @1ead ( Cannot roll over to the next log file @1 % database does not use Write-ahead Logali / cannot drop log file when journaling is enabled " reference to invalid stream numbers WAL subsystem encountered erroro WAL subsystem corruptedl b must specify archive file when enabling long term journal for databases with round-robin log filesL database @1 shutdown in progress & refresh range number @1 already in usee ! refresh range number @1 not found ch CHARACTER SET @1 is not defined ! lock time-out on wait transactionove procedure @1 is not definede ) Input parameter mismatch for procedure @1nex , Database @1: WAL subsystem bug for pid @2
@3 0 Could not expand the WAL segment for database @1 status code @1 unknown o exception @1 not defined exception @1 restart shared cache manager invalid lock handleo $ long-term journaling already enabled , Unable to roll over please see Firebird log. ( WAL I/O error. Please see Firebird log. J WAL writer - Journal server communication error. Please see Firebird log. : WAL buffers cannot be increased. Please see Firebird log.en * WAL setup error. Please see Firebird log. obsolete + Cannot start WAL writer for the database @1a database @1 shutdown ( cannot modify an existing user privilege ? Cannot delete PRIMARY KEY being used in FOREIGN KEY definition.u 5 Column used in a PRIMARY constraint must be NOT NULL. @ Name of Referential Constraint not defined in constraints table. = Non-existent PRIMARY or UNIQUE KEY specified for FOREIGN KEY.ase 0 Cannot update constraints (RDB$REF_CONSTRAINTS). 2 Cannot update constraints (RDB$CHECK_CONSTRAINTS). u < Cannot delete CHECK constraint entry (RDB$CHECK_CONSTRAINTS) ; Cannot delete index segment used by an Integrity Constraintg ; Cannot update index segment used by an Integrity Constraints 3 Cannot delete index used by an Integrity Constraint 3 Cannot modify index used by an Integrity Constraint 0 Cannot delete trigger used by a CHECK Constraint 0 Cannot update trigger used by a CHECK Constraint ; Cannot delete column being used in an Integrity Constraint.a ; Cannot rename column being used in an Integrity Constraint.n 5 Cannot update constraints (RDB$RELATION_CONSTRAINTS).in " Cannot define constraints on viewsd A internal Firebird consistency check (invalid RDB$CONSTRAINT_TYPE)ons 9 Attempt to define a second PRIMARY KEY for the same tableARY ' cannot modify or erase a system trigger 0 only the owner of a table may reassign ownership could not find object for GRANTK could not find column for GRANTH 1 user does not have GRANT privileges for operationt d ) object has non-SQL security class definedntg ) column has non-SQL security class definedteg > Write-ahead Log without shared cache configuration not allowedra database shutdown unsuccessful : Operation violates CHECK constraint @1 on view or table @2nn invalid service handleEC " database @1 shutdown in @2 secondsei ( wrong version of service parameter block $ unrecognized service parameter block service @1 is not defined co long-term journaling not enabled 5 Cannot transliterate character between character setsFir 0 WAL defined; Cache Manager must be started first 7 Overflow log specification required for round-robin logl . Implementation of text subtype @1 not located. Dynamic SQL Errorabl Invalid commandp Data type for constant unknownTK Invalid cursor reference Data type unknown no Invalid cursor declarationio Cursor @1 is not updatableur Attempt to reopen an open cursor " Attempt to reclose a closed cursorit Column unknownar Internal error n
Table unknownata Procedure unknownly Request unknown. SQLDA error : Count of read-write columns does not equal count of valuesnn Invalid statement handle
Function unknown Column is not a BLOB 0 COLLATION @1 for CHARACTER SET @2 is not defined
5 COLLATION @1 is not valid for specified CHARACTER SET co Option specified more than onced Unknown transaction optionct Invalid array reference ' Array declared with too many dimensionsf Illegal array dimension rangen r Trigger unknown ! Subselect illegal in this contexte @ 1 Cannot prepare a CREATE DATABASE/SCHEMA statementid 3 must specify column name for view select expressiona , number of columns does not match select list = Only simple column names permitted for VIEW WITH CHECK OPTION * No WHERE clause for VIEW WITH CHECK OPTIONt 1 Only one table allowed for VIEW WITH CHECK OPTION B DISTINCT, GROUP or HAVING not permitted for VIEW WITH CHECK OPTION 3 FOREIGN KEY column count does not match PRIMARY KEY 2 No subqueries permitted for VIEW WITH CHECK OPTIONnk # expression evaluation not supportedL gen.c: node not supportednot Unexpected end of commandot ! INDEX @1" EXCEPTION @1# COLUMN @1eci$
Token unknown % union not supportedi& Unsupported DSQL constructe ' column used with aggregateny( invalid column reference) invalid ORDER BY clauseg* 3 Return mode by value not allowed for this data type + 6 External functions cannot have more than 10 parameters , 6 alias @1 conflicts with an alias in the same statementmb- 9 alias @1 conflicts with a procedure in the same statementn n. 5 alias @1 conflicts with a table in the same statementcla/ Illegal use of keyword VALUE0 ' segment count of 0 defined for index @1O1 K A node name is not permitted in a secondary, shadow, cache or log file name 2 TABLE @13 PROCEDURE @14 cannot create index @1nt5 8 Write-ahead Log with shadowing configuration not allowed6 there are @1 dependenciesxpr7 " too many keys defined for index @1n.8 N Preceding file did not specify length, so @1 must include starting page numberCE9 ( Shadow number must be a positive integer: " Token unknown - line @1, column @2su; 7 there is no alias or table named @1 at this scope level < ! there is no index @1 for table @2id = " table @1 is not referenced in planue> I table @1 is referenced more than once in plan; use aliases to distinguish10 ? 8 table @1 is referenced in the plan but not the from list@ ' Invalid use of CHARACTER SET or COLLATErA 3 Specified domain or source column @1 does not existwB - index @1 cannot be used in the specified planse C > the table @1 is referenced twice; use aliases to differentiate D ; attempt to fetch before the first record in a record streamiE " the current position is on a crack F database or file existstG . invalid comparison operator for find operationotH Connection lost to pipe serverieI bad checksumJ wrong page type K G Cannot insert because the file is readonly or is on a read only medium.pL ! multiple rows in singleton select a M " cannot attach to password databaseneN . cannot start transaction for password databaseedO $ invalid direction for find operationP 6 variable @1 conflicts with parameter in same procedureplQ 4 Array/BLOB/DATE data types not allowed in arithmeticR 2 @1 is not a valid base table of the specified view iS A table @1 is referenced twice in view; use an alias to distinguishOLLT @ view @1 has more than one base table; use aliases to distinguishU * cannot add index, index root page is full. V BLOB SUB_TYPE @1 is not definedsW 2 Too many concurrent executions of the same requeste X - duplicate specification of @1 - not supported Y @ violation of PRIMARY or UNIQUE KEY constraint "@1" on table "@2"Z = server version too old to support all CREATE DATABASE optionshec[ # drop database completed with errorsi\ ' procedure @1 does not return any valuese] 3 count of column list and variable list do not match ^ ( attempt to index BLOB column in index @1_ ) attempt to index array column in index @1eed` ? too few key columns found for index @1 (incorrect column name?)ta
cannot deleteameb ( last column in a table cannot be deletedc
sort errorhmd sort error: not enough memoryblee too many versions f invalid key positiong + segments not allowed in expression index @1 h ( sort error: corruption in data structurei & new record size of @1 bytes is too bigx j & Inappropriate self-reference of columns k / request depth exceeded. (Recursive definition?)hl " cannot access column @1 in view @2atm ) dbkey not available for multi-table views n journal file wrong formatNIQo intermediate journal file full p H The prepare statement identifies a prepare statement with an open cursorq Firebird errorthr Cache redefinedrs 1 Insufficient memory to allocate page buffer cacheistt
Log redefined nou Log size too small iv Log partition size too smallw < Partitions not supported in series of log file specificationx 3 Total length of a partitioned log must be specifiedny Precision must be from 1 to 18abz ( Scale must be between zero and precision{ Short integer expectedle| Long integer expected } Unsigned short integer expecteds~ Invalid ESCAPE sequencex 1 service @1 does not have an associated executable Failed to locate host machine.x Undefined service @1/@2. K The specified name was not found in the hosts file or Domain Name Services.n D user does not have GRANT privileges on base table/view for operation Ambiguous column reference.Q Invalid aggregate referenceu F navigational stream @1 references a view with more than one base tablecu 7 Attempt to execute an unprepared dynamic SQL statement.u Positive value expectede ' Incorrect values within SQLDA structure invalid blob id 2 Operation not supported for EXTERNAL FILE table @1po Service is currently busy: @1ion 1 stack size insufficent to execute current requestedn Invalid key for find operationab ( Error initializing the network software. # Unable to load required library @1.g 0 Unable to complete network request to host "@1". ! Failed to establish a connection. 1 Error while listening for an incoming connection. @ Failed to establish a secondary connection for event processing. ? Error while listening for an incoming event connection request.c ' Error reading data from the connection. % Error writing data to the connection. 7 Cannot deactivate index used by an integrity constrainte ; Cannot deactivate index used by a PRIMARY/UNIQUE constraintt 3 Client/Server Express not supported in this released 5 Access to databases on file servers is not supported.rec ! Error while trying to create filenva Error while trying to open filer Error while trying to close file $ Error while trying to read from file # Error while trying to write to files ! Error while trying to delete filenab ! Error while trying to access fileftw K A fatal exception occurred during the execution of a user defined function.r connection lost to databaset ( User cannot write to RDB$USER_PRIVILEGES token size exceeds limit B Maximum user count exceeded. Contact your database administrator.ss t Your login @1 is same as one of the SQL role name. Ask your database administrator to set up a valid Firebird login. N "REFERENCES table" without "(column)" requires PRIMARY KEY on referenced tableat > The username entered is too long. Maximum length is 31 bytes.es ? The password specified is too long. Maximum length is 8 bytes.f * A username is required for this operation.e ) A password is required for this operationg t ) The network protocol specified is invalidile 8 A duplicate user name was found in the security database > The user name specified was not found in the security database 3 An error occurred while attempting to add the user.e = An error occurred while attempting to modify the user record. = An error occurred while attempting to delete the user record.VIL 7 An error occurred while updating the security database.e ' sort record size of @1 bytes is too bigs ; can not define a not null column with NULL as default value invalid clause --- '@1'p ! too many open handles to database size of optimizer block exceeded / a string constant is delimited by double quotes ! DATE must be changed to TIMESTAMPm l & attempted update on read-only databasefi 0 SQL dialect @1 is not supported in this database A A fatal exception occurred during the execution of a blob filter.r t ] Access violation. The code attempted to access a virtual address without privilege to do so. fo h Datatype misalignment. The attempted to read or write a value that was not stored on a memory boundary. \ Array bounds exceeded. The code attempted to access an array element that is out of bounds. m Float denormal operand. One of the floating-point operands is too small to represent a standard float value. wh \ Floating-point divide by zero. The code attempted to divide a floating-point value by zero. u Floating-point inexact result. The result of a floating-point operation cannot be represented as a deciaml fraction. c Floating-point invalid operand. An indeterminant error occurred during a floating-point operation.E k Floating-point overflow. The exponent of a floating-point operation is greater than the magnitude allowed.r m Floating-point stack check. The stack overflowed or underflowed as the result of a floating-point operation.ion i Floating-point underflow. The exponent of a floating-point operation is less than the magnitude allowed.he e Integer divide by zero. The code attempted to divide an integer value by an integer divisor of zero.he m Integer overflow. The result of an integer operation caused the most significant bit of the result to carry.poi M An exception occurred that does not have a description. Exception number @1.t d i Stack overflow. The resource requirements of the runtime stack have exceeded the memory available to it.. K Segmentation Fault. The code attempted to access memory without privileges. H Illegal Instruction. The Code attempted to perform an illegal operation. . Bus Error. The Code caused a system bus error.rf \ Floating Point Error. The Code caused an Arithmetic Exception or a floating point exception. ' Cannot delete rows from external files.r % Cannot update rows in external files.t o P Unable to perform operation. You must be either SYSDBA or owner of the database 7 Specified EXTRACT part does not exist in input datatypeb b Service @1 requires SYSDBA permissions. Reattach to the Service Manager using the SYSDBA account.er E The file @1 is currently in use by another process. Try again later.the ! Cannot attach to services managerocc O Metadata update statement is not allowed by the current database SQL dialect @1 operation was cancelledh 7 unexpected item in service parameter block, expected @1 ? Client SQL dialect @1 does not support reference to @2 datatype K user name and password are required while attaching to the services manager g You created an indirect dependency on uncommitted metadata. You must roll back the current transaction. # The service name was not specified. E Too many Contexts of Relation/Procedure/Views. Maximum allowed is 256ern & data type not supported for arithmeticn. * Database dialect being changed from 3 to 1se Database dialect not changed.ot Unable to create database @1 + Database dialect @1 is not a valid dialect.e Valid database dialects are @1.n SQL warning code = @1rre & DATE data type is now called TIMESTAMPer S Function @1 is in @2, which is not in a permitted directory for external functions.l ' value exceeds the range for valid dates 0 passed client dialect @1 is not a valid dialect. Valid client dialects are @1. 6 Unsupported field type specified in BETWEEN predicate. K Services functionality will be supported in a later version of the product GENERATOR @1 UDF @1pe D Invalid parameter to FETCH or FIRST. Only integers >= 0 are allowed. D Invalid parameter to OFFSET or SKIP. Only integers >= 0 are allowed. f File exceeded maximum size of 2GB. Add another database file or use a 64 bit I/O version of Firebird.se < Unable to find savepoint with name @1 in transaction context - Invalid column position used in the @1 clauseata e Cannot use an aggregate or window function in a WHERE clause, use HAVING (for aggregate only) insteadrre ? Cannot use an aggregate or window function in a GROUP BY clausei c Invalid expression in the @1 (not contained in either an aggregate function or the GROUP BY clause)i ^ Invalid expression in the @1 (neither an aggregate function nor a part of the GROUP BY clause) 5 Nested aggregate and window functions are not allowed @ Invalid argument in EXECUTE STATEMENT - cannot convert to string , Wrong request type in EXECUTE STATEMENT '@1' ^ Variable type (position @1) in EXECUTE STATEMENT '@2' INTO does not match returned column typeFF . Too many recursion levels of EXECUTE STATEMENTle ? Use of @1 at location @2 is not allowed by server configurationi C Cannot change difference file name while database is in backup moden > Physical backup is not allowed while Write-Ahead Log is in useus Cursor is not openag 1 Target shutdown mode is invalid for database "@1"(fo M Concatenation overflow. Resulting string cannot exceed 32765 bytes in length.ROU M Invalid offset parameter @1 to SUBSTRING. Only positive integers are allowed.e f + Foreign key reference target does not existr 1 Foreign key references are present for the recordt o
cannot update) Cursor is already openin
@1on 0 Context variable @1 is not found in namespace @2 & Invalid namespace name @1 passed to @2-
Too many context variableson Invalid argument passed to @1@1' . BLR syntax error. Identifier @1... is too longNT exception @1 Malformed string * Output parameter mismatch for procedure @1TA . Unexpected end of command - line @1, column @2d 6 partner index segment no @1 has incompatible data typena L Invalid length parameter @1 to SUBSTRING. Negative integers are not allowed. ! CHARACTER SET @1 is not installed no 2 COLLATION @1 for CHARACTER SET @2 is not installedse connection shutdowno Maximum BLOB size exceededt < Can't have relation with only computed fields or constraints + Time precision exceeds allowed range (0-@1)f 7 Unsupported conversion to target type BLOB (subtype @1)e + Unsupported conversion to target type ARRAY & Stream does not support record locking U Cannot create foreign key constraint @1. Partner index does not exist or is inactive.nva W Transactions count exceeded. Perform backup and restore to make database operable againe! $ Column has been unexpectedly deleted" @1 cannot depend on @2ed# = Blob sub_types bigger than 1 (text) are for internal use only $ H Procedure @1 is not selectable (it does not contain a SUSPEND statement)% 2 Datatype @1 is not supported for sorting operationd.& COLLATION @1' DOMAIN @1lle( domain @1 is not defined) + Array data type can use up to @1 dimensionss* ? A multi database transaction cannot span more than @1 databases + Bad debug info formatcon, & Error while parsing procedure @1's BLR r- index key too bigpor. # concurrent transaction number is @1 / , validation error for variable @1, value "@2"0 # validation error for @1, value "@2"l1 H Difference file name should be set explicitly for database on raw device2 7 Login name too long (@1 characters, maximum allowed @2)d3 ( column @1 is not defined in procedure @24 Invalid SIMILAR TO patternp 5 Invalid TEB formatse6 0 Found more than one transaction isolation in TPB7 @ Table reservation lock type @1 requires table name before in TPB8 + Found more than one @1 specification in TPBr9 2 Option @1 requires READ COMMITTED isolation in TPBem: 7 Option @1 is not valid if @2 was used previously in TPB.; ; Table name length missing after table reservation @1 in TPBf< B Table name length @1 is too long after table reservation @2 in TPBta= I Table name length @1 without table name after table reservation @2 in TPBcon> R Table name length @1 goes beyond the remaining TPB size after table reservation @2re? ; Table name length is zero after table reservation @1 in TPB1@ O Table or view @1 not defined in system tables after table reservation @2 in TPB A ` Base table or view @1 for view @2 not defined in system tables after table reservation @3 in TPBB , Option length missing after option @1 in TPBC 5 Option length @1 without value after option @2 in TPBsolD C Option length @1 goes beyond the remaining TPB size after option @2rE 7 Option length is zero after table reservation @1 in TPB F 7 Option length @1 exceeds the range for option @2 in TPB G 3 Option value @1 is invalid for the option @2 in TPB H R Preserving previous table reservation @1 for table @2, stronger than new @3 in TPB@1I V Table reservation @1 for table @2 already specified and is stronger than new @3 in TPBe J M Table reservation reached maximum recursion of @1 when expanding views in TPBiniK M Table reservation in TPB cannot be applied to @1 because it's a virtual table reL L Table reservation in TPB cannot be applied to @1 because it's a system tableM X Table reservation @1 or @2 in TPB cannot be applied to @3 because it's a temporary tableN ` Cannot set the transaction in read only mode after a table reservation isc_tpb_lock_write in TPBO f Cannot take a table reservation isc_tpb_lock_write in TPB because the transaction is in read only mode lP ( value exceeds the range for a valid timeQ , value exceeds the range for valid timestampsR string right truncationeS B blob truncation when converting to a string: length limit exceededreT numeric value is out of rangehanU B Firebird shutdown is still in progress after the specified timeoutd V Attachment handle is busyBe W b Bad written UDF detected: pointer returned in FREE_IT function was not allocated by ib_util_mallocrvX , External Data Source provider '@1' not foundY 2 Execute statement error at @1 :
@2Data source : @3 aZ & Execute statement preprocess SQL errorrv[ Statement expected e\ Parameter name expected ] Unclosed comment found near '@1'^ A Execute statement error at @1 :
@2Statement : @3
Data source : @4t t_ Input parameters mismatchaft` Output parameters mismatchk_a & Input parameter '@1' have no value setatb 4 BLR stream length @1 exceeds implementation limit @2c Monitoring table space exhaustedd , module name or entrypoint could not be founde nothing to cancel f U ib_util library has not been loaded to deallocate memory returned by FREE_IT function exg 6 Cannot have circular dependencies with computed fieldsrdh Security database errorai S Invalid data type in DATE/TIME/TIMESTAMP addition or subtraction in add_datettime()ej . Only a TIME value can be added to a DATE valueock . Only a DATE value can be added to a TIME valuerol D TIMESTAMP values can be subtracted only from another TIMESTAMP valuem ) Only one operand can be of type TIMESTAMPrrvn K Only HOUR, MINUTE, SECOND and MILLISECOND can be extracted from TIME values o I HOUR, MINUTE, SECOND and MILLISECOND cannot be extracted from DATE values2Stp D Invalid argument for EXTRACT() not being of DATE/TIME/TIMESTAMP typeq H Arguments for @1 must be integral types or NUMERIC/DECIMAL without scaler B First argument for @1 must be integral type or floating point type ts : Human readable UUID argument for @1 must be of string type ft > Human readable UUID argument for @2 must be of exact length @1oau P Human readable UUID argument for @3 must have "-" at position @2 instead of "@1"v V Human readable UUID argument for @3 must have hex digit at position @2 instead of "@1"ATw K Only HOUR, MINUTE, SECOND and MILLISECOND can be added to TIME values in @1ux B Invalid data type in addition of part to DATE/TIME/TIMESTAMP in @1a y @ Invalid part @1 to be added to a DATE/TIME/TIMESTAMP value in @2z 8 Expected DATE/TIME/TIMESTAMP type in evlDateAdd() result{ D Expected DATE/TIME/TIMESTAMP type as first and second argument to @1| P The result of TIME-<value> in @1 cannot be expressed in YEAR, MONTH, DAY or WEEK} o The result of TIME-TIMESTAMP or TIMESTAMP-TIME in @1 cannot be expressed in HOUR, MINUTE, SECOND or MILLISECOND ~ f The result of DATE-TIME or TIME-DATE in @1 cannot be expressed in HOUR, MINUTE, SECOND and MILLISECOND V Invalid part @1 to express the difference between two DATE/TIME/TIMESTAMP values in @2gu Argument for @1 must be positive Base for @1 must be positive , Argument #@1 for @2 must be zero or positive $ Argument #@1 for @2 must be positive 2 Base for @1 cannot be zero if exponent is negative C Base for @1 cannot be negative if exponent is not an integral valueu 4 The numeric scale must be between -128 and 127 in @1 ( Argument for @1 must be zero or positive 2 Binary UUID argument for @1 must be of string typeAT - Binary UUID argument for @2 must use @1 bytesxpe 3 Missing required item @1 in service parameter block @1 server is shutdownalu Invalid connection stringEAR Unrecognized events blockesu 5 Could not start first worker thread - shutdown serversed N Timeout occurred while waiting for a secondary connection for event processingn + Argument for @1 must be different than zeroM , Argument for @1 must be in the range [-1, 1] 1 Argument for @1 must be greater or equal than one , Argument for @1 must be in the range ]-1, 1[ 5 Incorrect parameters provided to internal function @1or / Floating point overflow in built-in function @1 - Floating point overflow in result from UDF @1e / Invalid floating point value returned by UDF @1o Y Database is probably already opened by another engine instance in another Windows sessionfor , No free space found in temporary directories + Explicit transaction control is not allowedU 9 Use of TRUSTED switches in spb_command_line is prohibitedite
PACKAGE @1 I Cannot make field @1 of table @2 NOT NULL because there are NULLs presentogn # Feature @1 is not supported anymore VIEW @1r & Can not access lock files directory @1ed 6 Fetch option @1 is invalid for a non-scrollable cursorn % Error while parsing function @1's BLRn z : Cannot execute function @1 of the unimplemented package @2gu ; Cannot execute procedure @1 of the unimplemented package @2r B External function @1 not returned by the external engine plugin @2nt C External procedure @1 not returned by the external engine plugin @2 A External trigger @1 not returned by the external engine plugin @2loa 5 Incompatible plugin version @1 for external engine @2bly External engine @1 not found Attachment is in use Transaction is in use fo Error loading plugin @1 Loadable module @1 not found 6 Standard plugin entrypoint does not exist in module @1e & Module @1 exists but can not be loaded , Module @1 does not contain plugin @2 type @3 . Invalid usage of context namespace DDL_TRIGGERno 3 Value is NULL but isNull parameter was not informedl ! Type @1 is incompatible with BLOBion Invalid date Invalid time Invalid timestampars Invalid index @1 in function @2e @1ct 8 Asynchronous call is already running for this attachment $ Function @1 is private to package @2 % Procedure @1 is private to package @2the H Request can't access new records in relation @1 and should be recompiled invalid events id (handle)te Cannot copy statement @1 # Invalid usage of boolean expressiono $ Arguments for @1 cannot both be zero missing service ID in spb1 n B External BLR message mismatch: invalid null descriptor at field @1 7 External BLR message mismatch: length = @1, expected @2 # Subscript @1 out of bounds [@2, @3] _ Install incomplete, please read the Compatibility chapter in the release notes for this versionG / @1 operation is not allowed for system table @2i ' Libtommath error code @1 in function @2O D unsupported BLR version (expected between @1 and @2, encountered @3) expected length @1, actual @2 = Wrong info requested in isc_svc_query() for anonymous serviceent N No isc_info_svc_stdin in user request, but service thread requested stdin data @ 1 Start request for anonymous service is impossible@1 ; All services except for getting server log require switches 9 Size of stdin data is more than was requested from clientono Crypt plugin @1 failed to loade 6 Length of crypt plugin name should not exceed @1 byteses ( Crypt failed - already crypting database 5 Crypt failed - database is already in requested stateted 0 Missing crypt plugin, but page appears encrypted No providers loadedx " NULL data with non-zero SPB length 9 Maximum (@1) number of arguments exceeded for function @2 in ? External BLR message mismatch: names count = @1, blr count = @2 0 External BLR message mismatch: name @1 not found Invalid resultset interface I Message length passed from user application does not match set of columnsctu . Resultset is missing output format information) 4 Message metadata not ready - item @1 is not finished Missing configuration file: @1d @1: illegal line <@2>ues ' Invalid include operator in @1 for <@2> Include depth too bigng File to include not found ' Only the owner can change the ownershipr undefined variable number@1 Missing security context for @1 : Missing segment @1 in multisegment connect block parameterea E Different logins in connect and attach packets - client library errortat 7 Exceeded exchange limit during authentication handshake B Incompatible wire encryption levels requested on client and server F Client attempted to attach unencrypted but wire encryption is requiredal > Client attempted to start wire encryption using unknown key @1rf E Client attempted to start wire encryption using unsupported plugin @1 co < Error getting security database name from configuration file A Client authentication plugin is missing required data from serveronf H Client authentication plugin expected @2 bytes of @3 from server, got @1 E Attempt to get information about an unprepared dynamic SQL statement.ot Problematic key value is @1c 3 Cannot select virtual table @1 for update WITH LOCK 2 Cannot select system table @1 for update WITH LOCKt 5 Cannot select temporary table @1 for update WITH LOCK lo System @1 @2 cannot be modifiedi 3 Server misconfigured - contact administrator please p Deprecated backward compatibility ALTER ROLE ... SET/DROP AUTO ADMIN mapping may be used only for RDB$ADMIN role Mapping @1 already existsdal Mapping @1 does not exist wi $ @1 failed when loading mapping cache ( Invalid name <*> in authentication block Multiple maps found for @1ro @ Undefined mapping result - more than one different results found 3 Incompatible mode of attachment to damaged databasef U Attempt to set in database number of buffers which is out of acceptable range [@1:@2]pt 9 Attempt to temporarily set number of buffers less than @1 ? Global mapping is not available when database @1 is not presentf P Global mapping is not available when table RDB$MAP is not present in database @1 # Your attachment has no trusted role ! Role @1 is invalid or unavailablee m - Cursor @1 is not positioned in a valid recordstr Duplicated user attribute @1 ( There is no privilege for this operation $ Using GRANT OPTION on @1 not allowed % read conflicts with concurrent updatebe 2 @1 failed when working with CREATE DATABASE grantsst
L CREATE DATABASE grants check is not possible when database @1 is not present e CREATE DATABASE grants check is not possible when table RDB$DB_CREATORS is not present in database @1 re 3 Interface @3 version too old: expected @1, found @2t
( Input parameter mismatch for function @1 8 Error during savepoint backout - transaction invalidated F Domain used in the PRIMARY KEY constraint of table @1 must be NOT NULLrs = CHARACTER SET @1 cannot be used as a attachment character set @1 ? Some database(s) were shutdown when trying to read mapping dataM I Error occurred during login, please check server firebird.log for details G Database already opened with engine instance, incompatible with currentl Invalid crypt key @1 4 Page requires encryption but crypt plugin is missing'
expected type ' bad block typeTI' bad block size ' corrupt pool' bad pool IDt' memory exhausted' set option not implementedan' show option not implementedc' show_fields: dtype not done@' INTERNAL: @1' " ** QLI error from database "@1" **ss' ** QLI error from database **t p ' ** QLI error: @1 ** ' expected @1, encountered "@2"ect ' integer overflow ' integer division by zero ' floating overflow trapav!' floating division by zerolid"' floating underflow trapP#' floating overflow fault@$' floating underflow fault%' arithmetic exception&' - illegal instruction or address, recovering...(s)'' 7 Please retry, supplying an application script file namec(' ) Welcome to QLI
Query Language Interpreter.lo)' qli version @1 *'
Statistics for database "@1"
@2+' HSH_remove failedurr,' EVAL_boolean: not finished -' EVAL_value: not finished.' & data type not supported for arithmetic /' * user name is supported in RSEs temporarily 0' Input value is too longl1' EXEC_execute: not implementedet 2' print_blob: expected field nodet3' # output pipe is not supported on VMSy4' could not create pipe @15'
fdopen failedfro6' execution terminated by signalor7' field validation error Q8' # Request terminated by statement: @1t9' Request terminated by statement :' Cannot open output file "@1";' Could not run "@1" <' comparison not doner=' conversion not implementedpP>' conversion not implemented ?' MOVQ_move: conversion not doneit@' BLOB conversion is not supportedA' conversion errorB' conversion errorC' conversion errorD' conversion errorE' conversion errorF' conversion errorG' BLOB conversion is not supportedH' $ Error converting string "@1" to dateI' overflow during conversionnoJ' gds_$put_segment failed K' fseek failedL' unterminated quoted string M' could not open scratch fileSN' fseek failedO' unterminated quoted string P' + unexpected end of procedure in procedure @1 Q' ! unexpected end of file in file @1s nR' unexpected eof S' cannot open command file "@1"dopT' # PIC_edit: class not yet implemented U' conversion errorV' procedure "@1" is undefinedmW' * procedure "@1" is undefined in database @2 bX' procedure "@1" is undefinedpY' ) Could not create QLI$PROCEDURE_NAME fieldompZ' $ Could not create QLI$PROCEDURE field[' % Could not create QLI$PROCEDURES table' \' ) procedure name "@1" in use in database @2con]' database handle required^' B QLI$PROCEDURES table must be created with RDO in Rdb/VMS databasesnv_' ! procedure name over 31 characters `' [@1 topics matched @2]na'
@1Sub-topics available:b'
No help is available for @1 @2 c' !
Sub-topics available for @1 are:ds_d' 8 Procedures can not be renamed across databases. Try COPYe' % Procedure @1 not found in database @2seef' ! substitute prompt string too longg g' ! substitute prompt string too longoceh' % Procedure @1 not found in database @2e @i' % Procedure @1 not found in database @2en j' No security classes definedtk' ! Security class @1 is not definedrsil' No views defined "@m' No indexes definedcn' No indexes defineddo' No databases are currently readyp' " Procedure @1 in database "@2" (@3)DUq' text, length @1 r' varying text, length @1fs' null terminated text, length @1Ut' short binaryu' long binary v' quadw' short floatingtax'
long floating' y' BLOBz' , segment length @1d{' , subtype @1|'
, subtype BLRroc}'
, subtype ACLara~' date'
, scale @1tc' , subtype fixedt' Database "@1" readied as @2 '
Database "@1"' ' No databases are currently ready' ; Page size is @1 bytes. Current allocation is @2 pages. ' & Field @1 does not exist in database @2ee' , Field @1 does not exist in any open database' (computed expression)on' * There are no forms defined for database @1 @' / There are no forms defined in any open database ' - Global field @1 does not exist in database @21 i' 3 Global field @1 does not exist in any open databasee' + There are no fields defined for database @1d' 0 There are no fields defined in any open database' % Procedure @1 not found in database @2 ' Procedure @1 not found ' ! Procedures in database "@1" (@2):hor' $ No triggers are defined for table @1' & No triggers are defined in database @1 ' & No triggers are defined in database @1su'
Variables:su' QLI, version "@1" AC' Version(s) for database "@1"' & expand_expression: not yet implementedie' % expand_statement: not yet implementedtab' ) variables may not be based on BLOB fields@1 ' . cannot perform assignment to computed field @1 ' no context for ERASE' cannot erase from a join' 5 @1.* cannot be used when a single element is requiredpre' ( "@1" is undefined or used out of context' no default form name' No database for form @1d' ' form @1 is not defined in database "@2"i' $ no context for form ACCEPT statement' " field @1 is not defined in form @2er' no context for modifyata' field list required for modifyfi' No items in print list ' No items in print listba' invalid ORDER BY ordinal' ; asterisk expressions require exactly one qualifying contextg' unrecognized context' I field referenced in BASED ON cannot be resolved against readied databasesn d' $ expected statement, encountered "@1"' # Expected PROCEDURE encountered "@1"f' period in qualified name' no databases are readyie' BLOB variables are not supported' end of statement' end of commandBL' quoted edit string p' variable definition clause ' @1 is not a database' @1 is not a table in database @2' variable data type s' = no data type may be specified for a variable based on a fieldcon' object type for DEFINEme'
table namee ' comma between field definitionsn' FROM' table or view name f' [CCE' ]ent' No statements issued yet' ON or TO' quoted edit stringta' column definition clause' . global fields may not be based on other fieldsms' ! field name or asterisk expressionord' FROM RSE clausep' commaire' quoted header segmentxtg' left parenthesis' & comma or terminating right parenthesist ' left parenthesis' VALUES list or SELECT clause' 6 the number of values do not match the number of fields "' value expression' right parenthesistab'
quoted string '
ENTREE or ENDt s'
quoted stringf s' index state optionma'
table name e' ADD, MODIFY, or DROP' comma between field definitionsi'
identifierat' positive numbere' FORM' period in qualified table namefo' @1 is not a table in database @2' $ database file name required on READY' EXISTS (SELECT * <sql rse>)i' relational operatorl' a database has not been readiedt' ' expected "table_name", encountered "@1"O'
table namet ' PROCEDUREolu'
TOP or BOTTOM' ' report writer SET option' report items'
set option o' RELATIONS or TRIGGERS '
table name '
database nameuot'
table nametg'
database namesis'
table nameer'
database namehes'
table namear'
table nameLU' FROM clausel' AVG, MAX, MIN, SUM, or COUNT' COUNT (*)ber' left parenthesis' OFon' database handlei' SET ' $ database block not found for removal' show_fields: dtype not donet' global field @1 already exists ' Cannot define an index in a view' Index @1 already existsi' $ Column @1 does not occur in table @2' Table @1 already existsi' . Field @1 is in use in the following relations:in' # Field @1 is in use in database "@2"i ( ( Field @1 is not defined in database "@2"( ( Index @1 is not defined in database "@2"( metadata operation failedted( no active database for operation( 5 Interactive metadata updates are not available on Rdb ( global field @1 is not defined i( & Index @1 does not exist in database @2RI( field @1 does not exist ( no active database for operation ( 5 Interactive metadata updates are not available on Rdbnam
( Unlicensed for database "@1" ( & Field @1 already exists in relation @2MI ( # data type cannot be changed locally
( global field @1 does not existta( ! field @1 not found in relation @2blo( 0 Data type conflict with existing global field @1( # No data type specified for field @1 ( database info call failed ( ! do not understand BLR operator @1olu( & Operation unlicensed for database "@1"@1( " Security class for database @1 i( Database description: ( Database description:2"i( File: @1 starting at page @2tab( Field @1 in @2 @3 of database @4( Global field @1a( Field description: ( Datatype information:( ( Field is computed from:e ( Field validation: ( Security class @1d i ( Query name: @1x ( Query name: @1 !( Edit string: @1"( Edit string: @1#( Query header:ve $( Global field @1 in database @2Rd%( Field description:ab&( Datatype information:exi'( Field is computed from:p(( Field validation:( )( Query name: @1t*( Edit string: @1+( Query header:( ,( 2 @1 is not used in any relations in database @2 -( Forms in database @1.( Global fields for database @1: /( Field description:op0( Index @1@2io1( " index @1 is NOT active 2( Index @1@2e 3( Description:4( Security class @1ata5( Stored in external file @1st6( 4 OBSOLETE - An erase trigger is defined for @17( 4 OBSOLETE - A modify trigger is defined for @18( 3 OBSOLETE - A store trigger is defined for @1m9( $ Security classes for database @1:( $ OBSOLETE - Triggers for relation @1:;( J OBSOLETE - Source for the erase trigger is not available. Trigger BLR: <( , OBSOLETE - Erase trigger for relation @1:=( K OBSOLETE - Source for the modify trigger is not available. Trigger BLR:e>( - OBSOLETE - Modify trigger for relation @1:( ?( J OBSOLETE - Source for the store trigger is not available. Trigger BLR:@1@( , OBSOLETE - Store trigger for relation @1:A( ' OBSOLETE - Triggers for relation @1: B( J OBSOLETE - Source for the erase trigger is not available. Trigger BLR:deC( , OBSOLETE - Erase trigger for relation @1:D( K OBSOLETE - Source for the modify trigger is not available. Trigger BLR:fE( - OBSOLETE - Modify trigger for relation @1: deF( J OBSOLETE - Source for the store trigger is not available. Trigger BLR:SOG( , OBSOLETE - Store trigger for relation @1:H( =
View source for relation @1 is not available. View BLR:or I( &
Relation @1 is a view defined as:heJ( Views in database @1:le.K( @1 comprised of :ETEL( Views in database @1:ionM( @1 comprised of:N( BLOBO( , segment length @1lP( , subtype text Q(
, subtype BLRifyR(
, subtype ACL @1S( , subtype @1T( text, length @1oU( varying text, length @1rV( null terminated text, length @1 W( short binaryX( long binaryEY( quadword binarytZ( short floating@1[(
long floating fo\( date](
, scale @1 ^( , subtype fixedt_( / Global field @1 is used in database @2 as :E`( @1 in relation @2laa( Field @1 in @2 @3 of database @4b( Global field @1ac( Field description: d( Datatype informatione( Field is computed from: f( Field validation:r ig( Query name: @1Lh( Query name: @1ti( Query header:@1:j( Edit string: @1k( Edit string: @1. l( @1 Based on field @2 of @3@4m( @1Base field description for @2:n(
END PROCEDURE o( & Do you want to roll back your updates?asp( $ gen_descriptor: dtype not recognizedq( gen_expression: not understood r( " gen_statement: not yet implemented s( gen_statistical: not understood1t( " EDIT argument must be a BLOB fieldxtu( / relations from multiple databases in single RSE v( " cannot find database for BLOB edit w( ' compile_expression: not yet implemented x( ' not yet implemented (compile_statement) y( computable: not yet implementedbz( $ make_descriptor: not yet implemented{( missing messagef|( lost message}( Triggers for relation @1:iel~( @1 @2, Sequence @3, @4pe( Pre-store (
Post-storete(
Pre-modify ( Post-modifyi( Pre-erase na(
Post-erase ( Active1t( Inactive(
Description: ( Source for the trigger:( 7 Source for the trigger is not available. Trigger BLR:a( No system triggers are definedD ( System Trigger for relation @1l ( $ Triggers defined for this relation:( Trigger for relation @1:(
TOP or BOTTOMsto(
sort fieldat( Too many WITHsnt( ( Shadow @1, File: @2 starting at page @3( DATABASE, TABLE, or INDEXfie( $ Database filename required in CREATE( FLOATSE ( INDEXt f( ! Multiple page size specificationsle_( ' GROUP BY not allowed in view definition ( ) Aggregates not allowed in view definition( ( NULL( ASt ( SELECT ( =des( ONot(
field name (
table nameef( user name identifier( GRANTrel( OPTION ( FROM( TOe ( ADD or DROP-( Dynamic DDL buffer exceeded ( TABLE( ( 5 Database handle @1 conflicts with an established name ( % Could not create QLI$PROCEDURES index ( Cannot convert from @1 to @2( & Cannot convert "@1" to a numeric value T( $ function @1 not found in database @2( > Incompatible global field @1 already exists in target databasene( # Relation @1 is missing or undefineda( ! matching language string too longort( Functions in database "@1" (@2):( + Functions are not supported in database @1.A( 4 There are no functions defined in any open database.( 1 Functions are not supported in any open database.pag( Function description:ROU( * Function @1 is not defined in database @2. ( 0 Function @1 is not defined in any open database.( ' Function @1 (@2) in database "@3" (@4):s( " Function @1 in database "@2" (@3):bl( Function library is @1er( Return argument is ( Argument @1 is ( , database file name required on DROP DATABASE( Unlicensed for database "@1"( ! Could not drop database file "@1" ( & Operation unlicensed for database "@1" ( array c( " memory pool free list is incorrect "( block released twice( , released block overlaps following free block( ( released block overlaps prior free block( C References to array fields like @1 in relation @2 are not supportedn( ) Filters are not supported in database @1.bas( ( Filter @1 is not defined in database @2.( . Filter @1 is not defined in any open database. i( / Filters are not supported in any open database. ( 2 There are no filters defined in any open database.OU( Filter @1 in database "@2" (@3):( Filter library is @1( Input sub-type is @1( Output sub-type is @1 (@( Filter description:b( Filters in database @1 (@2):( Index @1@2@3@4 ( 7 simple field reference not allowed in global aggregatesa( * prompting not allowed in select field listli( & output pipe is not supported on MPE/XL d( 2 could not resolve context for aggregate expressionas( ! source relation @1 does not existol ( Messages associated with @1:( message @1: @2e( < Connection to database @1 lost.
Please FINISH the database!( Unable to create form window( ' Do you want to rollback updates for @1?o( * functions are not supported in database @1at( ' no functions are defined in database @1 ( ( filters are not supported in database @1( & no filters are defined for database @1pp( f Error during two phase commit on database @1.
Roll back all databases or commit databases individuallyat( Only fields may be subscripted ( 1 "@1" is not a field and so may not be subscriptede i( 8 Data type of field @1 may not be changed to or from BLOB( qli: ignoring unknown switch -@1( 0 literal string <MAXSYMLEN> characters or longer( Variable @1l( Query name: @1m( Edit string: @1( ! Variable @1 has not been declaredppo( Datatype information: re( input line too long ( input line too longr(
number > 0t ( (@1) ( $ cannot format unsubscripted array @1( / unsuccessful attempt to extend pool beyond 64KBe( F field width (@1) * header segments (@2) greater than 60,000 characterst ( Relation @1 does not exist ( FORMs not supported ( Expression index BLR:ct( Invalid argument for UDF( SINGULAR (SELECT * <sql rse>)dat( JOIN( " Field @1 in view @2 of database @3pp ) & Field @1 in relation @2 of database @3as) YESb) NOta) Re-enter) Enterivi) ' bad kanji found while formatting output )
Subtopic? t ) - \ntype <cr> for next topic or <EOF> to stop: typ) unknown data type @1 ) 2 reads = !r writes = !w fetches = !f marks = !m@1
) ; elapsed = !e cpu = !u system = !s mem = !x buffers = !bi ) # @1 Based on field @2 of relation @3 ) @1 Based on field @2 of view @3
) PRECISIONare) ! Field scale exceeds allowed range( ) " Field length exceeds allowed range t) ( Field length should be greater than zero) " Usage: qli [options] ["<command>"] ) ` <command> may be a single qli command or a series of qli commands\n separated by semicolons) Valid options are:t ) 0 -a(pp_script) application script <name>) + -b(uffers) set page buffers <n>a) / -f(etch_password) fetch password from file>) , -i(nit_script) startup script <name>) 6 -n(obanner) do not show the welcome message ) & -p(assword) user's password ) 4 -tra(ce) show internal parser's tokens) 1 -tru(sted_auth) use trusted authenticationead ) -u(ser) user name ) ! -v(erify) echo inputtem ) + -z show program versionl ) ? Options can be abbreviated to the unparenthesized charactersC ) 5 Start qli without [command] to enter interactive modeiel!) qli: ignoring unknown switch @1 ") : Warning: cannot issue DDL statements against database "@1"s]#) 3 -nod(btriggers) do not run database triggersm$) O -e(xit) exit after end of script instead going to command prompt 1u & data base file name (@1) already givenip2u invalid switch @1ers3u gfix version @1f4u incompatible switch combinationf5u replay log pathname required6u ) number of page buffers for cache required -7u numeric value required t8u positive numeric value requiredr9u ) number of transactions per sweep required :u $ transaction number or "all" required;u "sync" or "async" requireded<u "full" or "reserve" required=u user name required >u password required -?u subsystem nameo @u "wal" required Au number of seconds requirednlBu 4 numeric value between 0 and 32767 inclusive requiredCu must specify type of shutdown [cDu " please retry, specifying an option Eu plausible options are:1 Fu B \n Options can be abbreviated to the unparenthesized characters Gu $ please retry, giving a database nameHu Summary of validation errorsIu ? -ac(tivate_shadow) activate shadow file for database usageaJu 9 -at(tach) shutdown new database attachmentsu Ku , -begin_log begin logging for replay utilityLu , -b(uffers) set page buffers <n>Mu 5 -co(mmit) commit transaction <tr / all>aluNu . -ca(che) shutdown cache manager Ou -disable disable WAL Pu 6 -fu(ll) validate record fragments (-v)"aQu / -fo(rce_shutdown) force database shutdown Ru . -h(ousekeeping) set sweep interval <n> Su . -i(gnore) ignore checksum errorsmbTu 9 -k(ill_shadow) kill all unavailable shadow files inUu / -l(ist) show limbo transactionscVu ; -me(nd) prepare corrupt database for backupnWu 1 -n(o_update) read-only validation (-v)npaXu A -o(nline) database online <single / multi / normal> Yu 7 -pr(ompt) prompt for commit/rollback (-l)iZu ( -pa(ssword) default password[u * -quit_log quit logging for replay utilitynt\u 7 -r(ollback) rollback transaction <tr / all> ]u 0 -sw(eep) force garbage collection^u 8 -sh(utdown) shutdown <full / single / multi>_u < -tw(o_phase) perform automated two-phase recovery`u 4 -tra(nsaction) shutdown transaction startupau > -u(se) use full or reserve space for versions -bu ) -user default user name cu 3 -v(alidate) validate database structure-du = -w(rite) write synchronously or asynchronously(iseu $ -x set debug onfu 5 -z print software version numberupngu % \n Number of record level errors : @1idahu Number of Blob page errors : @1iu Number of data page errors : @1ju ! Number of index page errors : @1romku # Number of pointer page errors : @1slu ' Number of transaction page errors : @1lmu $ Number of database page errors : @1nu bad block type ou # internal block exceeds maximum size-pu corrupt poolqu virtual memory exhaustedru bad pool id su ( Transaction state @1 not in valid range.tu ( ATTACH_DATABASE: attempted attach of @1,uu failedsvu
succeeded wu Transaction @1 is in limbo.txu , More limbo transactions than fit. Try againyu Unrecognized info item @1 vezu 9 A commit of transaction @1 will violate two-phase commit. {u D A rollback of transaction @1 is needed to preserve two-phase commit.|u 4 Transaction @1 has already been partially committed.}u = A rollback of this transaction will violate two-phase commit. so~u , Transaction @1 has been partially committed.u 7 A commit is necessary to preserve the two-phase commit. u 2 Insufficient information is available to determineexu # a proper action for transaction @1.tu 7 Transaction @1: All subtransactions have been prepared.:u & Either commit or rollback is possible.@1u unexpected end of input u * Commit, rollback, or neither (c, r, or n)?t u 2 Could not reattach to database for transaction @1. u Original path: @1notu Enter a valid path:Au Attach unsuccessful.u 3 failed to reconnect to a transaction in database @1 u Transaction @1:iu Multidatabase transaction:u Host Site: @1ainu Transaction @1itu has been prepared.f u has been committed. u has been rolled back. rou is not available.is u # is not found, assumed not prepared. u & is not found, assumed to be committed.itu Remote Site: @1tu Database Path: @1 cou 3 Automated recovery would commit this transaction..u 5 Automated recovery would rollback this transaction.t. u I Warning: Multidatabase transaction is in inconsistent state for recovery.on u > Transaction @1 was committed, but prior ones were rolled back.eeu > Transaction @1 was rolled back, but prior ones were committed.exu $ Transaction description item unknownu 8 -mo(de) read_only or read_write databaseu $ "read_only" or "read_write" requiredu . -sq(l_dialect) set database dialect nucu ( database SQL dialect must be one of '@1'u dialect number required u ' positive or zero numeric value requiredtu 2 -tru(sted) use trusted authenticationreu ) could not open password file @1, errno @2rolu ) could not read password file @1, errno @2s nu empty password file @1. u 0 -fe(tch_password) fetch password from fileu usage: gfix [options] <database>u E -nol(inger) close database ignoring linger setting for itn..u % Number of inventory page errors : @1hisu % Number of record level warnings : @1e tu " Number of blob page warnings : @1cou " Number of data page warnings : @1edu # Number of index page warnings : @1 u % Number of pointer page warnings : @1s wu ) Number of transaction page warnings : @1temu & Number of database page warnings : @1nlu ' Number of inventory page warnings : @1"u J -icu fix database to be usable with present ICU version u ) -role set SQL role name u SQL role name requiredd r 1 Cannot SELECT RDB$DB_KEY from a stored procedure. -s k Precision 10 to 18 changed from DOUBLE PRECISION in SQL dialect 1 to 64-bit scaled integer in SQL dialect 3ot N Use of @1 expression that returns different results in dialect 1 and dialect 3_pu A Database SQL dialect @1 does not support reference to @2 datatypese>v w R DB dialect @1 and client dialect @2 conflict with respect to numeric precision @3. ix > WARNING: Numeric literal @1 is interpreted as a floating-point @y G value in SQL dialect 1, but as an exact numeric value in SQL dialect 3.rz K WARNING: NUMERIC and DECIMAL fields with precision 10 or greater are storedp{ D as approximate floating-point values in SQL dialect 1, but as 64-bit| integers in SQL dialect 3.ng} & Ambiguous field name between @1 and @2in~ > External function should have return position between 1 and @1 p Label @1 @2 in the current scope / Datatypes @1are not comparable in expression @2D Empty cursor name is not allowed * Statement already has a cursor @1 assignedON - Cursor @1 is not found in the current contextlec / Cursor @1 already exists in the current context % Relation @1 is ambiguous in cursor @2ata % Relation @1 is not found in cursor @2e t Cursor is not open L Data type @1 is not supported for EXTERNAL TABLES. Relation '@2', field '@3' 5 Feature not supported on ODS version older than @1.@2loa Primary key required on table @1 B UPDATE OR INSERT field list does not match primary key of table @1IC : UPDATE OR INSERT field list does not match MATCHING clause [ UPDATE OR INSERT without MATCHING could not be used with views based on more than one table Incompatible trigger typebet & Database trigger type can't be changedld P To be used with RDB$RECORD_VERSION, @1 must be a table or a view of single table 2 SQLDA version expected between @1 and @2, found @3 at SQLVAR index @1ot ( empty pointer to NULL indicator variable empty pointer to data is " No SQLDA for input values provided # No SQLDA for output values providedt 0 Wrong number of parameters (expected @1, got @2)8 ODS version not supported by DYN8 unsupported DYN verb8 ! STORE RDB$FIELD_DIMENSIONS failed fo8 unsupported DYN verb8 @1d 8 unsupported DYN verb8 DEFINE BLOB FILTER failed1.@8 DEFINE GENERATOR failedd8 $ DEFINE GENERATOR unexpected DYN verb8 DEFINE FUNCTION failed o8 unsupported DYN verb8 DEFINE FUNCTION ARGUMENT failedH8 STORE RDB$FIELDS failedN8 No table specified for index8 STORE RDB$INDEX_SEGMENTS faileda8 unsupported DYN verb8 PRIMARY KEY column lookup failed8 R could not find UNIQUE or PRIMARY KEY constraint in table @1 with specified columnsew8 PRIMARY KEY lookup failed 8 6 could not find PRIMARY KEY index in specified table @1 8 STORE RDB$INDICES failed8 STORE RDB$FIELDS failed 8 STORE RDB$RELATION_FIELDS failed8 STORE RDB$RELATIONS failedpr8 1 STORE RDB$USER_PRIVILEGES failed defining a table 8 unsupported DYN verb8 STORE RDB$RELATIONS failedrs8 STORE RDB$FIELDS failed 8 STORE RDB$RELATION_FIELDS failed8 unsupported DYN verb8 DEFINE TRIGGER failed 8 unsupported DYN verb8 DEFINE TRIGGER MESSAGE failed1.@8 STORE RDB$VIEW_RELATIONS failed 8 ERASE RDB$FIELDS failed 8 ERASE BLOB FILTER failed8 BLOB Filter @1 not found8 unsupported DYN verb8 # ERASE RDB$FUNCTION_ARGUMENTS failedN8 ERASE RDB$FUNCTIONS failedex8 Function @1 not foundNTS8 unsupported DYN verb8 C Domain @1 is used in table @2 (local name @3) and cannot be droppedU8 ERASE RDB$FIELDS failedt8 ERASE RDB$FIELDS failedw8 Column not found8 ERASE RDB$INDICES failed8 Index not founda8 ERASE RDB$INDEX_SEGMENTS failedd8 No segments found for index 8 No table specified in ERASE RFR 8 0 Column @1 from table @2 is referenced in view @38 ERASE RDB$RELATION_FIELDS failed8 View @1 not found8 8 Column not found for table 8 ERASE RDB$INDEX_SEGMENTS failedR8 ERASE RDB$INDICES failed8 ERASE RDB$RELATION_FIELDS failed8 ERASE RDB$VIEW_RELATIONS failed 8 ERASE RDB$RELATIONS failed f8 Table not foundD8 ERASE RDB$USER_PRIVILEGES failed8 ERASE RDB$FILES failedBL8 unsupported DYN verb8 ! ERASE RDB$TRIGGER_MESSAGES failedYN 8 ERASE RDB$TRIGGERS failedGUM8 Trigger not found RD8 MODIFY RDB$VIEW_RELATIONS failed8 unsupported DYN verb8 TRIGGER NAME expected is8 ERASE TRIGGER MESSAGE failed8 Trigger Message not found RD8 unsupported DYN verb8 ! ERASE RDB$SECURITY_CLASSES failed 8 Security class not found8 unsupported DYN verb8 * SELECT RDB$USER_PRIVILEGES failed in grantme8 * SELECT RDB$USER_PRIVILEGES failed in grantER8 ) STORE RDB$USER_PRIVILEGES failed in grantnce8 0 Specified domain or source column does not exist8 Generation of column name failed8 Generation of index name failedN8 ! Generation of trigger name failedICE8 MODIFY DATABASE failedTI8 MODIFY RDB$CHARACTER_SETS failed8 MODIFY RDB$COLLATIONS failed8 MODIFY RDB$FIELDS failed8 MODIFY RDB$BLOB_FILTERS failedGE8 Domain not found8 unsupported DYN verb8 MODIFY RDB$INDICES failed$TR8 MODIFY RDB$FUNCTIONS failedS8 Index column not found 8 MODIFY RDB$GENERATORS failed8 ! MODIFY RDB$RELATION_FIELDS faileded 8 Local column @1 not foundcte8 add EXTERNAL FILE not allowedled8 drop EXTERNAL FILE not allowed 8 MODIFY RDB$RELATIONS failedS8 & MODIFY RDB$PROCEDURE_PARAMETERS failed 8 Table column not foundnd8 MODIFY TRIGGER failed8 8 TRIGGER NAME expectedS f8 unsupported DYN verb8 MODIFY TRIGGER MESSAGE failedtER8 Create metadata BLOB faileda8 Write metadata BLOB faileddo8 Close metadata BLOB failedst8 1 Triggers created automatically cannot be modifiedn o8 unsupported DYN verb8 - ERASE RDB$USER_PRIVILEGES failed in revoke(1)TAB8 1 Access to RDB$USER_PRIVILEGES failed in revoke(2) 8 . ERASE RDB$USER_PRIVILEGES failed in revoke (3)fa8 2 Access to RDB$USER_PRIVILEGES failed in revoke (4) n8 CREATE VIEW failedd 8 ) attempt to index BLOB column in INDEX @1 8 * attempt to index array column in index @1ot8 key size too big for index @1 fa8 no keys for index @18 Unknown columns in index @1o8 % STORE RDB$RELATION_CONSTRAINTS failed no8 " STORE RDB$CHECK_CONSTRAINTS failed a8 X Column: @1 not defined as NOT NULL - cannot be used in PRIMARY KEY constraint definition8 = A column name is repeated in the definition of constraint: @1 8 " Integrity Constraint lookup failedd 8 c Same set of columns cannot be used in more than one PRIMARY KEY and/or UNIQUE constraint definitionB8 STORE RDB$REF_CONSTRAINTS failed 9 ' No table specified in delete_constraintc9 % ERASE RDB$RELATION_CONSTRAINTS failederb9 CONSTRAINT @1 does not exist.led9 $ Generation of constraint name failed9 Table @1 already exists 9 G Number of referencing columns do not equal number of referenced columnsS9 STORE RDB$PROCEDURES failedn9 Procedure @1 already exists 9 % STORE RDB$PROCEDURE_PARAMETERS failed8 9 ! Store into system table @1 failedex
9 % ERASE RDB$PROCEDURE_PARAMETERS failed8 9 ERASE RDB$PROCEDURES failedn 9 Procedure @1 not found
9 MODIFY RDB$PROCEDURES failed9 DEFINE EXCEPTION failedS9 ERASE EXCEPTION failed: 9 Exception not found-9 MODIFY EXCEPTION failed 9 & Parameter @1 in procedure @2 not foundit9 Trigger @1 not found9 < Only one data type change to the domain @1 allowed at a time9 ; Only one data type change to the field @1 allowed at a timet9 STORE RDB$FILES failedRE9 Character set @1 not foundle9 Collation @1 not foundtc9 ERASE RDB$LOG_FILES failedIN9 STORE RDB$LOG_FILES faileddo9 Role @1 not foundene 9 Difference file lookup failed 9 DEFINE SHADOW failed 9 MODIFY RDB$ROLES failedn 9 % Name longer than database column size9 9 * "Only one constraint allowed for a domain"@1"9 ! Looking up column position failedRE_#9 E A node name is not permitted in a table with external file definition RD$9 Shadow lookup failed%9 Shadow @1 already exists&9 A Cannot add file with the same name as the database or added filesled'9 > no grant option for privilege @1 on column @2 of table/view @3 (9 C no grant option for privilege @1 on column @2 of base table/view @3 )9 A no grant option for privilege @1 on table/view @2 (for column @3)und*9 F no grant option for privilege @1 on base table/view @2 (for column @3)ly+9 B no @1 privilege with grant option on table/view @2 (for column @3)FI,9 G no @1 privilege with grant option on base table/view @2 (for column @3)c-9 1 no grant option for privilege @1 on table/view @2_FI.9 2 no @1 privilege with grant option on table/view @2 f/9 table/view @1 does not exist09 ) column @1 does not exist in table/view @2 19 Can not alter a view29 1 EXTERNAL FILE table not supported in this contextmai39 / attempt to index COMPUTED BY column in INDEX @1 49 Table Name lookup failed59 attempt to index a viewn69 $ SELECT RDB$RELATIONS failed in grant79 * SELECT RDB$RELATION_FIELDS failed in grantth89 3 SELECT RDB$RELATIONS/RDB$OWNER_NAME failed in grantg99 * SELECT RDB$USER_PRIVILEGES failed in grant/v:9 A SELECT RDB$VIEW_RELATIONS/RDB$RELATION_FIELDS/... failed in grant ;9 1 column @1 from table @2 is referenced in index @3 (f<9 SQL role @1 does not existpt=9 0 user @1 has no grant admin option on SQL role @2>9 & user @1 is not a member of SQL role @2on?9 " @1 is not the owner of SQL role @2 @@9 @1 is a SQL role and not a useraA9 + user name @1 could not be used for SQL role B9 SQL role @1 already existsFIC9 - keyword @1 can not be used as a SQL role nameew D9 t SQL roles are not supported in on older versions of the database. A backup and restore of the database is required.L9 G Cannot rename domain @1 to @2. A domain with that name already exists.xM9 S Cannot rename column @1 to @2. A column with that name already exists in table @3.vN9 + Column @1 from table @2 is referenced in @3 O9 d Cannot change datatype for column @1. Changing datatype is not supported for BLOB or ARRAY columns.P9 @ New size specified for column @1 must be at least @2 characters.Q9 T Cannot change datatype for @1. Conversion from base type @2 to @3 is not supported.R9 S Cannot change datatype for column @1 from a character type to a non-character type. S9 3 unable to allocate memory from the operating system@T9 ' Zero length identifiers are not allowed U9 ERASE RDB$GENERATORS failedSV9 Sequence @1 not foundlreW9 Difference file is not defined bX9 " Difference file is already definedleY9 / Database is already in the physical backup modeeZ9 + Database is not in the physical backup mode.[9 DEFINE COLLATION failed \9 q CREATE COLLATION statement is not supported in older versions of the database. A backup and restore is required.xis]9 7 Maximum number of collations per character set exceededn^9 Invalid collation attributes_9 / Collation @1 not installed for character set @2L`9 : Cannot use the internal domain @1 as new type for field @2bea9 7 Default value is not allowed for array type in field @1 b9 8 Default value is not allowed for array type in domain @1c9 & DYN_UTIL_is_array failed for domain @1ngd9 ) DYN_UTIL_copy_domain failed for domain @1 a e9 & Local column @1 doesn't have a default mf9 , Local column @1 default belongs to domain @2g9 File name is invalidh9 @1 cannot reference @2aii9 7 Local column @1 is computed, cannot set a default valuenj9 ERASE RDB$COLLATIONS failed k9 F Collation @1 is used in table @2 (field name @3) and cannot be dropped l9 7 Collation @1 is used in domain @2 and cannot be droppedCm9 Cannot delete system collationONn9 3 Cannot delete default collation of CHARACTER SET @1so9 K Domain @1 is used in procedure @2 (parameter name @3) and cannot be droppedap9 ) Field @1 cannot be used twice in index @2ribq9 Table @1 not foundotr9 1 attempt to reference a view (@1) in a foreign keyters9 N Collation @1 is used in procedure @2 (parameter name @3) and cannot be dropped t9 5 New scale specified for column @1 must be at most @2. @1u9 : New precision specified for column @1 must be at least @2.opv9 $ @1 is not grantor of @2 on @3 to @4.w9 ' Warning: @1 on @2 is not granted to @3.ax9 * Feature '@1' is not supported in ODS @2.@3ley9 , Cannot add or remove COMPUTED from column @1z9 # Password should not be empty string {9 Index @1 already existsD|9 3 Only @1 or database owner can use GRANTED BY clause2}9 Exception @1 already existsp~9 Sequence @1 already existsn 9 5 ERASE RDB$USER_PRIVILEGES failed in REVOKE ALL ON ALLcol9 Package @1 not found9 Schema @1 not foundA9 ( Cannot ALTER or DROP system procedure @19 & Cannot ALTER or DROP system trigger @1da9 ' Cannot ALTER or DROP system function @1@9 & Invalid DDL statement for procedure @1t 9 $ Invalid DDL statement for trigger @19 7 Function @1 has not been defined on the package body @2)9 8 Procedure @1 has not been defined on the package body @29 7 Function @1 has a signature mismatch on package body @219 8 Procedure @1 has a signature mismatch on package body @29 Y Default values for parameters are allowed only in declaration of packaged procedure @1.@29 9 Function @1 already existsin9 Package body @1 already existsve9 % Invalid DDL statement for function @1ld 9 \ Cannot alter new style function @1 with ALTER EXTERNAL FUNCTION. Use ALTER FUNCTION instead.9 ! Cannot delete system generator @1exi9 K Identity column @1 of table @2 must be of exact number type with zero scale 9 < Identity column @1 of table @2 cannot be changed to NULLable9 8 Identity column @1 of table @2 cannot have default value9 ^ Domain @1 must be of exact number type with zero scale because it's used in an identity columnd 9 # Generation of generator name faileda9 % Parameter @1 in function @2 not foundion9 $ Parameter @1 of routine @2 not found9 j Parameter @1 of routine @2 is ambiguous (found in both procedures and functions). Use a specifier keyword.ac9 M Collation @1 is used in function @2 (parameter name @3) and cannot be droppedpac9 J Domain @1 is used in function @2 (parameter name @3) and cannot be dropped1 9 7 ALTER USER requires at least one clause to be specified 9 Cannot delete system SQL role @19 # Column @1 is not an identity columnF9 Duplicate @1 @2 9 System @1 @2 cannot be modified 9 3 INCREMENT BY 0 is an illegal option for sequence @1t9 & Can't use @1 in FOREIGN KEY constraint o9 X Default values for parameters are allowed only in declaration of packaged function @1.@29 - Password must be specified when creating usere w This is a modified text messagei This is a test messageti * could not locate appropriate error messagen found unknown switch page size parameter missingf 9 Page size specified (@1) greater than limit (16384 bytes) - redirect location for output is not specifiedd i ' conflicting switches for backup/restoree device type @1 not known protection is not there yetn . page size is allowed only on restore or createse * multiple sources or destinations specified d ( requires both input and output filenames 1 input and output have the same name. Disallowed.rol $ expected page size, encountered "@1" 6 REPLACE specified, but the first file @1 is a databaseif ? database @1 already exists. To replace it, use the -REP switch device type not specifiedrai , cannot create APOLLO tape descriptor file @1 2 cannot set APOLLO tape descriptor attribute for @1ss 1 cannot create APOLLO cartridge descriptor file @1is + cannot close APOLLO tape descriptor file @1a gds_$blob_info failedapp # do not understand BLOB INFO item @1w gds_$get_segment failede gds_$close_blob failedsp gds_$open_blob failed Failed in put_blr_gen_id data type @1 not understoodf gds_$compile_request failede gds_$start_request failed gds_$receive failed gds_$release_request failedl gds_$database_info failedult $ Expected database description record failed to create database @1 # RESTORE: decompression length errora cannot find table @1 Cannot find column for BLOB gds_$create_blob failedb gds_$put_segment faileda expected record lengthy / wrong length record, expected @1 encountered @2i expected data attribute Failed in store_blr_gen_idor do not recognize record type @1d ( Expected backup version 1..10. Found @1 " expected backup description record string truncated ' warning -- record could not be restoredf gds_$send failed no table name for data % unexpected end of file on backup filee_b + database format @1 is too old to restore to ( array dimension for column @1 is invalid 5 expected array version number @1 but instead found @2 0 expected array dimension @1 but instead found @2 Expected XDR record lengthdl ) Unexpected I/O error while @1 backup fileted # adding file @1, starting at page @2t arraybas backupST 2 @1B(ACKUP_DATABASE) backup database to file@1 backup file is compressed G @1D(EVICE) backup file device type on APOLLO (CT or MT)d : @1M(ETA_DATA) backup or restore metadata onlyed blob cannot open backup file @1il + cannot open status and error output file @1c ' closing file, committing, and finishing1 committing metadatad commit failed on table @1 committing secondary files r creating index @1edf committing data for table @1 E @1C(REATE_DATABASE) create database from backup file (restore)ata
' created database @1, page_size @2 bytes creating file @1 creating indexes
( database @1 has a page size of @2 bytes. < @1I(NACTIVE) deactivate indexes during restore # do not understand BLOB INFO item @1 . do not recognize @1 attribute @2 -- continuing , error accessing BLOB column @1 -- continuing ' Exiting before completion due to errors ' Exiting before completion due to errorsl columnd file file length filter d " finishing, closing, and going home function function argumentmet gbak version @1b domain o indexle trigger @1 is invalids a legal switches are: < length given for initial file (@1) is less than minimum (@2)! . @1E(XPAND) no data compressionti" 7 @1L(IMBO) ignore transactions in limboi# 6 @1O(NE_AT_A_TIME) restore one table at a timeda$ opened file @1e % 5 @1P(AGE_SIZE) override default page size & page sizefil' 5 page size specified (@1 bytes) rounded up to @2 bytesze ( / @1Z print version numbert) privilegeres* @1 records ignoredL+ @1 records restored r, @1 records written- - B @1Y <path> redirect/suppress status message outputit. 9 Reducing the database page size from @1 bytes to @2 bytestio/ tablersl0 F @1REP(LACE_DATABASE) replace database from backup file (restore)in1 3 @1V(ERIFY) report each action takenn2 % restore failed for record in table @1oma3 restoring column @1g4 restoring file @1ega5 restoring filter @1g6 restoring function @1 le7 & restoring argument for function @1 8 " restoring gen id value of: @1L(9 restoring domain @1r: restoring index @1 ; # restoring privilege for user @1 < restoring data for table @1 = restoring security class @1 > restoring trigger @1? $ restoring trigger message for @1@ # restoring type @1 for column @2pA started transaction B starting transactionC security class D = switches can be abbreviated to the unparenthesized characters<paE * transportable backup -- data in XDR formattpF triggeruG trigger messagesH trigger typeI unknown switch "@1"lJ & validation error on column in table @1abK Version(s) for database "@1"L viewM $ writing argument for function @1N writing data for table @1e @O writing gen id of: @11gP writing column @1 Q writing filter @1 R writing filters@S writing function @1eT writing functions U writing domain @1f: V writing domainsoW writing index @1X ! writing privilege for user @1ge Y writing table @1Z writing tables [ writing security class @1 \ writing trigger @1@1] " writing trigger message for @1@1^ writing trigger messages_ writing triggers` ! writing type @1 for column @2iona
writing typess b writing shadow filesc writing shadow file @1rad writing id generators bae ! writing generator @1 value @2eruf readied database @1 for backupr g restoring table @1 "h typei gbak:rorj committing metadata for table @1k & error committing metadata for table @1 l ; @1K(ILL) restore without creating shadows@m cannot commit index @1d n cannot commit filesio E @1T(RANSPORTABLE) transportable backup -- data in XDR format p 9 closing file, committing, and finishing. @1 bytes writtenritq 5 @1G(ARBAGE_COLLECT) inhibit garbage collectionnder / @1IG(NORE) ignore bad checksums s 2 column @1 used in index @2 seems to have vanished t > index @1 omitted because @2 of the expected @3 keys were foundr u * @1FA(CTOR) blocking factorg v ! blocking factor parameter missingoluw * expected blocking factor, encountered "@1"adx ? a blocking factor may not be used in conjunction with device CTry restoring generator @1 value: @2z ? @1OL(D_DESCRIPTIONS) save old style metadata descriptions { F @1N(O_VALIDITY) do not restore database validity conditions | user name parameter missing } password parameter missing ~ , @1PAS(SWORD) Firebird password - @1USER Firebird user name writing stored proceduresble writing stored procedure @1 ) writing parameter @1 for stored procedureyte restoring stored procedure @1LLE / restoring parameter @1 for stored procedureR writing exceptionsch writing exception @1 restoring exception @1 8 missing parameter for the number of bytes to be skipped 8 expected number of bytes to be skipped, encountered "@1" 7 adjusting an invalid decompression length from @1 to @2n 1 skipped @1 bytes after reading a bad attribute @2 no F @1S(KIP_BAD_DATA) skip number of bytes after reading bad data@2 K skipped @1 bytes looking for next valid attribute, encountered attribute @2 writing table constraintstor writing constraint @1s table constraint writing referential constraintsm writing check constraints writing character sets writing collations F
character set writing character set @1 collationtor writing collation @1 3 Unexpected I/O error while reading from backup filet 1 Unexpected I/O error while writing to backup filer s
Could not open file name "@1"o
Could not write to file "@1"
Could not read from file "@1"u Done with volume #@1, "@2" c Press return to reopen that file, or type a new
name followed by return to open a different file.p ' Type a file name to open and hit returnd Name:
ERROR: Backup incompleted ' Expected backup start time @1, found @2 % Expected backup database @1, found @2 by * Expected volume number @1, found volume @2es 5 could not drop database @1 (database might be in use) $ Skipped bad security class entry: @1 % Unknown V3 SUB_TYPE: @1 in FIELD: @2. E Converted V3 sub_type: @1 to character_set_id: @2 and collate_id: @3. B Converted V3 scale: @1 to character_set_id: @2 and callate_id: @3. System memory exhausted1 ? @1NT Non-Transportable backup file formate & Index "@1" failed to activate because:ex 1 The unique index has duplicate values or NULLs.
Co E Delete or Update duplicate values or NULLs, and activate index with
Co ALTER INDEX "@1" ACTIVE; = Not enough disk space to create the sort file for an index.ed v Set the TMP environment variable to a directory on a filesystem that does have enough space, and activate index withco F Database is not online due to failure to activate one or more indices.p A Run gfix -online to bring database online without active indices.2es writing SQL rolestab writing SQL role: @1 SQL role restoring SQL role: @1 , @1RO(LE) Firebird SQL role SQL role parameter missingct : @1CO(NVERT) backup external files as tables t gbak: WARNING: a gbak: ERROR: 8 @1BU(FFERS) override page buffers default page buffers parameter missingte ' expected page buffers, encountered "@1"x 1 page buffers is allowed only on restore or create
Co Starting with volume #@1, "@2"al : size specification either missing or incorrect for file @1 A file @1 out of sequence & can't join -- one of the files missingso : standard input is not supported when using join operation t N standard output is not supported when using split operation or in verbose mode backup file @1 might be corruptr # database file specification missing & can't write a header record to file @1ou free disk space exhaustedng 6 file size given (@1) is less than minimum allowed (@2) g Warning -- free disk space exhausted for file @1, the rest of the bytes (@2) will be written to file @3m service name parameter missing W Cannot restore over current database, must be SYSDBA or owner of the existing database.U C @1USE_(ALL_SPACE) do not reserve space for record versionsi / @1SE(RVICE) use services manager = @1MO(DE) <access> "read_only" or "read_write" accessing $ "read_only" or "read_write" required $ setting database to read-only access % just data ignore all constraints etc.gso N restoring data only ignoring foreign key, unique, not null & other constraintsut 9 closing file, committing, and finishing. @1 bytes writtene v @1R(ECREATE_DATABASE) [O(VERWRITE)] create (or replace if OVERWRITE used)\n database from backup file (restore)e - activating and creating deferred index @1siz check constraint exception (@ array dimensions generatorhau procedure th procedure parameterl referential constraint type (in RDB$TYPES)i 7 @1NOD(BTRIGGERS) do not run database triggersA 5 @1TRU(STED) use trusted authentication_(A writing names mapping sp writing map for @1 restoring map for @1 name mapping cannot restore arbitrary mapping restoring names mapping 9 @1FIX_FSS_D(ATA) fix malformed UNICODE_FSS data = @1FIX_FSS_M(ETADATA) fix malformed UNICODE_FSS metadataa o Character set parameter missingu Character set @1 not foundos 3 @1FE(TCH_PASSWORD) fetch password from file too many passwords providedR ) could not open password file @1, errno @2 d ) could not read password file @1, errno @2cti empty password file @1nd 3 Attribute @1 was already processed for exception @2 I Skipping attribute @1 because the message already exists for exception @2erl [ Trying to recover from unexpected attribute @1 due to wrong message length for exception @2o > Attribute not specified for storing text bigger than 255 bytes a , Unable to store text bigger than 65536 bytes + Failed while fixing the security class namea Usage: E gbak -b <db set> <backup set> [backup options] [general options]app F gbak -c <backup set> <db set> [restore options] [general options] C <db set> = <database> | <db1 size1>...<dbN> (size in db pages) M <backup set> = <backup> | <bk1 size1>...<bkN> (size in bytes = n[K|M|G])1FE ? -recreate overwrite and -replace can be used instead of -cp backup options are:p restore options are: general options are: ( verbose interval value parameter missing 0 verbose interval value cannot be smaller than @1 E @1VERBI(NT) <n> verbose information with explicit intervalsts ; verify (verbose) and verbint options are mutually exclusiveb
/ option -@1 is allowed only on restore or create $ option -@1 is allowed only on backup * options -@1 and -@2 are mutually exclusivext
> parameter for option -@1 was already specified with value "@2" n option -@1 was already specified writing package @1ck writing packages restoring package @1 packaged , dependency depth greater than @1 for view @2 G value greater than @1 when calculating length of rdb$db_key for view @2 8 Invalid metadata detected. Use -FIX_FSS_METADATA option. 0 Invalid data detected. Use -FIX_FSS_DATA option. @ text for attribute @1 is too large in @2, truncating to @3 bytes ) Expected backup version @2..@3. Found @1 writing view @1p table @1 is a viewe writing security classes ' database format @1 is too old to backupo backup version is @1 fixing system generators - Error closing database, but backup file is OK database! 6 required mapping attributes are missing in backup fileon" ) missing regular expression to skip tableslly# . @1SKIP_D(ATA) skip data for tabledy$ 1 regular expression to skip tables was already sety s% fixing views dbkey length1ck& 5 updating ownership of packages, procedures and tablesack' adding missing privilegester( , adjusting the ONLINE and FORCED WRITES flags) + @1ST(ATISTICS) TDRW show statistics:t* ) T time from startata+ $ D delta time, $ R page reads- % W page writeslar. statistics parameter missing/ ' wrong char "@1" at statistics parameter 0 & too many chars at statistics parameter@11 total statistics Firebird error Rollback not performedol Connection error Connection not establishedte ! Connection authorization failure.e, ' deadlock( * Unsuccessful execution caused by deadlock.tt) , record from transaction @1 is stuck in limbo+ operation completed with errors . $ the SQL statement cannot be executed0 9 Unsuccessful execution caused by an unavailable resource.y s2 l Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements3 r Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements n Wrong numeric type o too many versions p intermediate journal file full q journal file wrong formatstir " database @1 shutdown in @2 seconds" s restart shared cache managert exception @1u bad checksumv ! refresh range number @1 not foundr w # expression evaluation not supportednx 3 FOREIGN KEY column count does not match PRIMARY KEYny 9 Attempt to define a second PRIMARY KEY for the same tablefulz column used with aggregate { invalid column reference| invalid key position} $ invalid direction for find operation~ Invalid statement handle invalid lock handlec invalid lock level @1rce invalid bookmark handlei wrong or obsolete versionpre u The INSERT, UPDATE, DELETE, DDL or authorization statement cannot be executed because the transaction is inquiry only , external file could not be opened for output ! multiple rows in singleton selecttio 2 No subqueries permitted for VIEW WITH CHECK OPTION B DISTINCT, GROUP or HAVING not permitted for VIEW WITH CHECK OPTIONur 1 Only one table allowed for VIEW WITH CHECK OPTION2 s * No WHERE clause for VIEW WITH CHECK OPTION = Only simple column names permitted for VIEW WITH CHECK OPTIONoun U An error was found in the application program input parameters for the SQL statement.ch t Invalid insert or update value(s): object columns are constrained - no 2 table rows can have duplicate column values 5 Arithmetic overflow or division by zero has occurred.nva " cannot access column @1 in view @2va 2 Too many concurrent executions of the same requestva ' maximum indexes per table (@1) exceededn & new record size of @1 bytes is too big + segments not allowed in expression index @1a wrong page typee invalid ARRAY or BLOB operation @1 extension errord : key size exceeds implementation restriction for index "@1"io! definition error for index @1IEW$ cannot create index ; - duplicate specification of @1 - not supported CHG N The insert failed because a column definition includes validation constraints.REN 1 Cannot delete object referenced by another objectoluO 1 Cannot modify object referenced by another objectn eP & Object is referenced by another objectt Q $ lock on conflicts with existing lockY 0 This operation is not defined for system tables.[ & Inappropriate self-reference of column c\ Illegal array dimension rangeow _ database or file existsd` ( sort error: corruption in data structurea node not supportedt b ( Shadow number must be a positive integerc N Preceding file did not specify length, so @1 must include starting page number d - illegal operation when at beginning of streamrone " the current position is on a crack ( cannot modify an existing user privilege 5 user does not have the privilege to perform operationiti K This user does not have privilege to perform this operation on this object. ' transaction marked invalid by I/O errore 1 Cannot prepare a CREATE DATABASE/SCHEMA statementint ( violation of FOREIGN KEY constraint "@1" H The prepare statement identifies a prepare statement with an open cursor Unknown statement or request & Attempt to update non-updatable cursorg S The cursor identified in the UPDATE or DELETE statement is not positioned on a row.r Unknown cursor ; The cursor identified in an OPEN statement is already open. @ The cursor identified in a FETCH or CLOSE statement is not open. . Overflow occurred during data type conversion. ! null segment of UNIQUE KEYgt" subscript out of boundsp& data operation not supported' . invalid comparison operator for find operation ~ 5 Cannot transliterate character between character setsdoe 3 count of column list and variable list do not matchs + Incompatible column/host variable data typet 7 Operation violates CHECK constraint @1 on view or tabler A internal Firebird consistency check (invalid RDB$CONSTRAINT_TYPE)iol 5 Cannot update constraints (RDB$RELATION_CONSTRAINTS).men < Cannot delete CHECK constraint entry (RDB$CHECK_CONSTRAINTS) 2 Cannot update constraints (RDB$CHECK_CONSTRAINTS).e 0 Cannot update constraints (RDB$REF_CONSTRAINTS). 5 Column used in a PRIMARY constraint must be NOT NULL.urs - index @1 cannot be used in the specified plant i 8 table @1 is referenced in the plan but not the from list > the table @1 is referenced twice; use aliases to differentiateve " table @1 is not referenced in plangt & Log file specification partition errorpe Cache or Log redefinedva 8 Write-ahead Log with shadowing configuration not allowed 7 Overflow log specification required for round-robin loge 0 WAL defined; Cache Manager must be started first > Write-ahead Log without shared cache configuration not allowedio + Cannot start WAL writer for the database @1 4 WAL writer synchronization error for the database @1 * WAL setup error. Please see Firebird log.$R : WAL buffers cannot be increased. Please see Firebird log.ry J WAL writer - Journal server communication error. Please see Firebird log.e ( WAL I/O error. Please see Firebird log. - Unable to roll over; please see Firebird log.ust obsolete obsolete obsolete obsolete % database does not use Write-ahead Log pl ( Cannot roll over to the next log file @1 obsolete obsolete Cache or Log size too small 7 Log record header too small at offset @1 in log file @2n 1 Incomplete log record at offset @1 in log file @2ad * Unexpected end of log file @1 at offset @2 - Database name in the log file @1 is different-ro B Log file @1 not closed properly; database recovery may be requiredit ; Log file @1 not latest in the chain but open flag still set Invalid version of log file @1se Log file header of @1 too smalle obsolete table @1 is not defined. invalid ORDER BY clause * Column does not belong to referenced tableir $ column @1 is not defined in table @2 Undefined namer. Ambiguous column reference. function @1 is not definedd
# Invalid data type, length, or value Invalid number of arguments ) dbkey not available for multi-table views , number of columns does not match select list 3 must specify column name for view select expression 2 @1 is not a valid base table of the specified viewco! W This column cannot be updated because it is derived from an SQL function or expression. " r The object of the INSERT, DELETE or UPDATE statement is a view for which the requested operation is not permitted.reO Invalid StringleP
Invalid token chQ Invalid numeric literal c > An error occurred while trying to update the security databasesmd non-SQL security class defineds e + ODS versions before ODS@1 are not supported f Table @1 does not existeg View @1 does not existish At line @1, column @2 i At unknown line and columncoj , Column @1 cannot be repeated in @2 statementk > Too many values (more than @1) in member list to match againstarl 7 Array and BLOB data types not allowed in computed field m : Implicit domain name @1 not allowed in user created domainfyn 6 scalar operator used on field @1 which is not an arraylio " cannot sort on more than 255 items p # cannot group on more than 255 items q c Cannot include the same field (@1.@2) twice in the ORDER BY clause with conflicting sorting options r c column list from derived table @1 has more columns than the number of items in its SELECT statement s c column list from derived table @1 has less columns than the number of items in its SELECT statementet A no column name specified for column number @1 in derived table @2QL u ; column @1 was specified multiple times for derived table @2uv D Internal dsql error: alias type expected by pass1_expand_select_nodew 7 Internal dsql error: alias type expected by pass1_fieldox J Internal dsql error: column position out of range in pass1_union_auto_castthy > Recursive CTE member (@1) can refer itself only in FROM clausepez CTE '@1' has cyclic dependencies{ 8 Recursive member of CTE can't be member of an outer join| = Recursive member of CTE can't reference itself more than onceann} # Recursive CTE (@1) must be an UNIONn~ 5 CTE '@1' defined non-recursive member after recursiveme * Recursive member of CTE '@1' has @2 clause O Recursive members of CTE (@1) must be linked with another members via UNION ALLi + Non-recursive member is missing in CTE '@1'd WITH clause can't be nested 0 column @1 appears more than once in USING clause & feature is not supported in dialect @1ed CTE "@1" is not used in querycif . column @1 appears more than once in ALTER VIEWal : @1 is not supported inside IN AUTONOMOUS TRANSACTION block % Unknown node type @1 in dsql/GEN_exprass 6 Argument for @1 in dialect 1 must be string or numericng , Argument for @1 in dialect 3 must be numeric @ Strings cannot be added to or subtracted from DATE or TIME types I Invalid data type for subtraction involving DATE, TIME or TIMESTAMP types 8 Adding two DATE values or two TIME values is not allowed ; DATE value cannot be subtracted from the provided data typef 2 Strings cannot be added or subtracted in dialect 3iv : Invalid data type for addition or subtraction in dialect 3 1 Invalid data type for multiplication in dialect 1 an ) Strings cannot be multiplied in dialect 3 me 1 Invalid data type for multiplication in dialect 3nes 8 Division in dialect 1 must be between numeric data types & Strings cannot be divided in dialect 3 + Invalid data type for division in dialect 3@ C Strings cannot be negated (applied the minus operator) in dialect 3I / Invalid data type for negation (minus operator)p 0 Cannot have more than 255 items in DISTINCT list ALTER CHARACTER SET @1 failed COMMENT ON @1 failed CREATE FUNCTION @1 failedann ALTER FUNCTION @1 failed " CREATE OR ALTER FUNCTION @1 failedyp DROP FUNCTION @1 failedE RECREATE FUNCTION @1 failed CREATE PROCEDURE @1 failed v ALTER PROCEDURE @1 failedval # CREATE OR ALTER PROCEDURE @1 faileda DROP PROCEDURE @1 failed RECREATE PROCEDURE @1 failed CREATE TRIGGER @1 failed ALTER TRIGGER @1 failed ! CREATE OR ALTER TRIGGER @1 failedion DROP TRIGGER @1 faileds RECREATE TRIGGER @1 failedme CREATE COLLATION @1 failedip DROP COLLATION @1 failed CREATE DOMAIN @1 failede ALTER DOMAIN @1 failed DROP DOMAIN @1 faileddia CREATE EXCEPTION @1 failedfo ALTER EXCEPTION @1 failedtri # CREATE OR ALTER EXCEPTION @1 failede RECREATE EXCEPTION @1 failed DROP EXCEPTION @1 failed CREATE SEQUENCE @1 failedtha CREATE TABLE @1 failed ALTER TABLE @1 failedile DROP TABLE @1 failed RECREATE TABLE @1 failed CREATE PACKAGE @1 failed ALTER PACKAGE @1 failed ! CREATE OR ALTER PACKAGE @1 failed @1 DROP PACKAGE @1 failedIO RECREATE PACKAGE @1 failedRE CREATE PACKAGE BODY @1 failed1 f DROP PACKAGE BODY @1 failedC RECREATE PACKAGE BODY @1 failed@ CREATE VIEW @1 failedEDU ALTER VIEW @1 failed CREATE OR ALTER VIEW @1 failed RECREATE VIEW @1 failed DROP VIEW @1 failedI DROP SEQUENCE @1 failedE RECREATE SEQUENCE @1 failedC DROP INDEX @1 failed DROP FILTER @1 failed DROP SHADOW @1 failed DROP ROLE @1 failed DROP USER @1 faileda CREATE ROLE @1 failedail ALTER ROLE @1 failed ALTER INDEX @1 failed AL ALTER DATABASE failed CREATE SHADOW @1 failed DECLARE FILTER @1 failed CREATE INDEX @1 failedha CREATE USER @1 failedd ALTER USER @1 failed GRANT failed
REVOKE failedECR ? Recursive member of CTE cannot use aggregate or window functionG @2 MAPPING @1 failed ALTER SEQUENCE @1 failed CREATE GENERATOR @1 failed SET GENERATOR @1 failed 7 WITH LOCK can be used only with a single physical table1 3 FIRST/SKIP cannot be used with OFFSET/FETCH or ROWSA ( WITH LOCK cannot be used with aggregates WITH LOCK cannot be used with @1 U Number of arguments (@1) exceeds the maximum (@2) number of EXCEPTION USING arguments C String literal with @1 bytes exceeds the maximum length of @2 bytesL f String literal with @1 characters exceeds the maximum length of @2 characters for the @3 character set 1 Too many BEGIN...END nesting. Maximum level is @1 D# V Row not found for fetch, update or delete, or the result of a query is an empty table. E# + segment buffer length shorter than expectedl
$ Datatype needs modification D% & Duplicate column or domain name found.edJ invalid block type encounteredivJ wrong packet typee aJ cannot map pagetJ & request to allocate invalid block typeSEJ 7 request to allocate block type larger than maximum size J memory pool free list is invalidJ invalid pool id encounteredaJ attempt to release free blockuseJ 9 attempt to release block overlapping following free block J 5 attempt to release block overlapping prior free blockberJ * cannot sort on a field that does not existerJ database file not availablemJ cannot assert logical lock lJ wrong ACL version exJ shadow block not found cJ % shadow lock not synchronized properlyoo J $ root file name not listed for shadowJ ' failed to remove symbol from hash tabledJ cannot find tip pageJ invalid rsb typeJ invalid SEND requestJ " looper: action not yet implementedeeJ return data type not supportedmnJ $ unexpected reply from journal serverJ & journal server is incompatible version aJ ! journal server refused connectiono aJ & referenced index description not found aJ index key too big thJ # partner index description not foundsJ bad difference recordoolJ * applied differences will not fit in recordocJ record length inconsistentckJ decompression overran bufferJ / cannot reposition for update after sort for RMS J $ external access type not implementedJ differences record too longsJ wrong record lengthtJ limbo impossibleJ wrong record versionJ record disappeared lJ cannot delete system tables J cannot update erased recorddJ 1 comparison not supported for specified data typese nJ 1 conversion not supported for specified data typeshasJ conversion errorJ overflow during conversionpeJ null or invalid arrayJ J BLOB not found yJ cannot update old BLOB dJ relation for array not knownJ field for array not knownJ J ! array subscript computation errorn aJ expected field nodesJ invalid BLOB ID J cannot find BLOB pagenotJ unknown data type toJ & shadow block not found for extend filefoJ index inconsistent rJ index bucket overfillednJ exceeded index levelJ page already in usesJ page not accessed for writeaJ $ attempt to release page not acquiredJ page in use during flushJ : attempt to remove page from dirty page list when not thererdJ CCH_precedence: block markedJ insufficient cache size J $ no cache buffers available for reuseJ , page @1, page type @2 lock conversion deniedJ ! page @1, page type @2 lock deniedd dJ buffer marked for updateJ CCH: @1, status = @2 (218)peJ request of unknown resource J release of unknown resource J (CMP) copy: cannot remapJ bad BLR -- invalid streamdatJ - argument of scalar operation must be an array J " quad word arithmetic not supportedsuJ & data type not supported for arithmeticieJ request size limit exceeded J ! cannot access field @1 in view @2wn J cannot access field in view @1ouJ EVL_assign_to: invalid operationJ EVL_bitmap: invalid operationednJ EVL_boolean: invalid operationgeJ EVL_expr: invalid operationcJ # eval_statistical: invalid operation J - Unimplemented conversion, FAO directive O,Z,SmovJ + Unimplemented conversion, FAO directive X,U J Error parsing RDB FAO msg stringJ Error parsing RDB FAO msg strbufJ & unknown parameter in RdB status vectortyJ # Firebird status vector inconsistent,J , Firebird/RdB message parameter inconsistencyJ $ error parsing RDB FAO message stringJ unimplemented FAO directive J & missing pointer page in DPM_data_pagesMPJ Fragment does not exist J & pointer page disappeared in DPM_deletealJ * pointer page lost from DPM_delete_relationarJ missing pointer page in DPM_dumpJ cannot find record fragment J # pointer page vanished from DPM_nextnJ temporary page buffer too small J damaged data pageew J header fragment length changedraJ * pointer page vanished from extend_relation J 8 pointer page vanished from relation list in locate_spaceJ cannot find free spaceinJ $ pointer page vanished from mark_fullJ bad record in RDB$PAGESnJ page slot not empty J bad pointer pageJ index unexpectedly deletedroJ 3 scalar operator used on field which is not an arraysJ active J committed inJ rolled backyJ in an ill-defined stateiJ 5 next transaction older than oldest active transactionncyJ . next transaction older than oldest transactionimJ ! buffer marked during cache unwindoinJ % error in recovery! database corrupteddoeJ ) error in recovery! wrong data page recordPM_J ( error in recovery! no space on data page K + error in recovery! wrong header page recordpK . error in recovery! wrong generator page recordgeK + error in recovery! wrong b-tree page recordeK 3 error in recovery! wrong page inventory page recordmK , error in recovery! wrong pointer page recordK / error in recovery! wrong index root page recordrK 0 error in recovery! wrong transaction page recordK 9 error in recovery! out of sequence log record encountered K $ error in recovery! unknown page type K & error in recovery! unknown record typewh
K < journal server cannot archive to specified archive directory K 7 checksum error in log record when reading from log filen K $ cannot restore singleton select data
K ' lock not found in internal lock manageriK size of opt block exceededacK Too many savepointsnK " garbage collect record disappearedroK Unknown BLOB FILTER ACTION_rK error during savepoint backoute K cannot find record back versionwK Illegal user_type. K bad ACLcK inconsistent LATCH_mark release K inconsistent LATCH_mark callK ! inconsistent latch downgrade callongK bdb is unexpectedly marked K missing exclusive latchrK 2 exceeded maximum number of shared latches on a bdbge K can't find shared latchr K / Non-zero use_count of a buffer in the empty que K $ Unexpected page change from latching K ! Invalid expression for evaluationrec K 5 RDB$FLAGS for trigger @1 in RDB$TRIGGERS is corruptedcor!K Blobs accounting is inconsistent"K 2 Found array data type with more than 16 dimensions i Statement failed, SQLSTATE = @1n % usage: isql [options] [<database>]K Unknown switch: @1rn 4 Use CONNECT or CREATE DATABASE to specify a database Unable to open @1 ! Commit current transaction (y/n)? Committing. Rolling back work.ng Command error: @1 3 Enter data or NULL for each column. RETURN to end. ISQL Version: @1 E -a(ll) extract metadata incl. legacy non-SQL tablesnco ! Number of DB pages allocated = @1db Sweep interval = @1 Number of wal buffers = @1 Wal buffer size = @1 Check point length = @1 ! Check point interval = @1on-" Wal group commit wait = @1em# Base level = @1 $ Transaction in limbo = @1om % Frontend commands:pr& 6 BLOBVIEW <blobid> -- view BLOB in text editorB$' 1 BLOBDUMP <blobid> <file> -- dump BLOB to a filesis( > EDIT [<filename>] -- edit SQL script file and execute ) @ INput <filename> -- take input from the named SQL file* 8 OUTput [<filename>] -- write output to named file+ K SHELL <command> -- execute Operating System command in sub-shellt, / HELP -- display this menu -
Set commands:omm. 9 SET -- display current SET optionsRN / A SET AUTOddl -- toggle autocommit of DDL statementsmet0 A SET BLOB [ALL|<n>] -- display BLOBS of subtype <n> or ALL= @1 B SET COUNT -- toggle count of selected rows on/off 2 8 SET ECHO -- toggle command echo on/off3 F SET STATs -- toggle display of performance statistics 4 @ SET TERM <string> -- change statement terminator string5 8 SHOW <object> [<name>] -- display system information6 O <object> = CHECK, COLLATION, DATABASE, DOMAIN, EXCEPTION, FILTER, FUNCTION,-7 5 EXIT -- exit and commit changese> 8 8 QUIT -- exit and roll back changes9 6 All commands may be abbreviated to letters in CAPitalsco: 4 SET SCHema/DB <db name> -- changes current database; Yes < K Current memory = !c
Delta memory = !d
Max memory = !x
Elapsed time= !e sec
= = Cpu = !u sec
Buffers = !b
Reads = !r
Writes = !w
Fetches = !fET > 7 BLOB display set to subtype @1. This BLOB: subtype = @2 ? * BLOB: @1, type 'edit' or filename to load> s@ Enter @1 as Y/M/D> A Enter @1> B Bad date @1uC CON> d rD C SET LIST -- toggle column or table display formatfE @1 not foundF A Errors occurred (possibly duplicate domains) in creating @1 in @2 G 2 Server version too old to support the isql commandmiH Records affected: @1I Unlicensed for database "@1"J K SET WIDTH <col> [<n>] -- set/unset print width to <n> for column <col>IK A SET PLAN -- toggle display of query access planngeL J SET TIME -- toggle display of timestamp with DATE valuesmmM E EDIT -- edit current command buffer and executeme>N 5 OUTput -- return output to stdouty =O ? SET NAMES <csname> -- set name of runtime character set P N GENERATOR, GRANT, INDEX, PACKAGE, PROCEDURE, ROLE, SQL DIALECT,o Q 3 SET BLOB -- turn off BLOB display'R > SET <option> -- (Use HELP SET for complete list)@1S $ There are no tables in this databaseT % There is no table @1 in this databasemn U # There are no views in this databasedV $ There is no view @1 in this databaseW 1 There are no indices on table @1 in this databasedmiX . There is no table or index @1 in this databaseabY % There are no indices in this database seZ & There is no domain @1 in this database [ % There are no domains in this databaselay\ ) There is no exception @1 in this database ] ( There are no exceptions in this database^ & There is no filter @1 in this databaseed_ % There are no filters in this database ` 5 There is no user-defined function @1 in this database a 4 There are no user-defined functions in this databaseb ) There is no generator @1 in this databaseX, c ( There are no generators in this databased : There is no privilege granted on table @1 in this database e E There is no privilege granted on stored procedure @1 in this databasetabf 9 There is no table or stored procedure @1 in this databasemn g 0 There is no stored procedure @1 in this databaseh / There are no stored procedures in this database i 2 There are no triggers on table @1 in this databasemij 0 There is no table or trigger @1 in this databasek & There are no triggers in this databasesel ; There are no check constraints on table @1 in this databaseom . Buffers = !b
Reads = !r
Writes !w
Fetches = !fion 0 Single isql command exceeded maximum buffer sizeo # There are no roles in this database@p / There is no metadata object @1 in this databasesq ? There is no membership privilege granted on @1 in this databasesr * Expected end of statement, encountered EOF tu Bad TIME: @1v ; SYSTEM, TABLE, TRIGGER, VERSION, USERS, VIEWnw $ There is no role @1 in this databasex 5 -b(ail) bail on errors (set bail on) isy Incomplete string in @1 z 4 SET SQL DIALECT <n> -- set sql dialect to <n>{ . There is no privilege granted in this databaseis| L SET PLANONLY -- toggle display of query plan without executing * > [ u p d ` T# ,' * . 3 2 E 6 X x: m L> 8B F J M Q U XY $] ` d h 1 Dl @ 0p L s \ w n x{ { x l \ @ 0 @ ' , .' ( L' $ d' ' ' ' ' ' ( .( A( \( w( p ( D ( ( ( ( ) ) 9u Ou _u vu d u P u L u 4 ( 8 8 8 8 8 # 9 |' (9 `+ :9 \/ P9 P3 a9 7 s9 : 9 > 9 B xF pJ XN
HR % @V = <Z [ ^ s b e i m q u dy ,} ( Ԅ 2 ̈ | x e p ' ` < , ! $ q ܧ ԫ J J \ J X J @ J K K # 3 F V x h P | @ } C SET HEADING -- toggle display of query column titless~ R SET BAIL -- toggle bailing out on errors in non-interactive mode 0 -c(ache) <num> number of cache buffers Enter @1 as H:M:S>!b # Enter @1 as Y/MON/D H:MIN:S[.MSEC]> Bad TIMESTAMP: @1ded 2 There are no comments for objects in this databaseab ! Printing only the first @1 blobs.1 i Tables:s
Functions:o At line @1 in file @2on After line @1 in file @2 ' There is no trigger @1 in this database 7 -ch(arset) <charset> connection charset (set names)I @ -d(atabase) <database> database name to put in script creation 4 -e(cho) echo commands (set echo on) ) -ex(tract) extract metadataCT / -i(nput) <file> input file (set input)v - -m(erge) merge standard errorNLY ) -m2 merge diagnostic < -n(oautocommit) no autocommit DDL (set autoddl off) - -now(arnings) do not show warningsbai 1 -o(utput) <file> output file (set output)che $ -pag(elength) <size> page length , -p(assword) <password> connection password A -q(uiet) do not show the message "Use CONNECT..." fo " -r(ole) <role> role nameng 6 -r2 <role> role (uses quoted identifier)o 6 -s(qldialect) <dialect> SQL dialect (set sql dialect)@2 6 -t(erminator) <term> command terminator (set term)rs " -u(ser) <user> user nameam ) -x extract metadatae t 8 -z show program and server version missing argument for switch "@1" / argument "@1" for switch "@2" is not an integer> * value "@1" for switch "@2" is out of range 1 switch "@1" or its equivalent used more than once ' more than one database name: "@1", "@2" ! No dependencies for @1 were foundomm ) There is no collation @1 in this database 5 There are no user-defined collations in this databaseout Collations:t $ There are no security classes for @1 ( There is no database-wide security class 5 Cannot get server version without database connectionage 5 -nod(btriggers) do not run database triggerseng 3 -tr(usted) use trusted authenticatione BULK> s( There are no connected users Users in the databasermi Output was truncated Valid options are: 1 -f(etch_password) fetch password from file ) could not open password file @1, errno @2 ) could not read password file @1, errno @2iss empty password file @1 M SET MAXROWS [<n>] -- limit select stmt to <n> rows, zero is no limit" i ' There is no package @1 in this databasev & There are no packages in this database & There is no schema @1 in this database % There are no schemas in this database 3 Unable to convert @1 to a number for MAXROWS options 5 Value @1 for MAXROWS is out of range. Max value is @2 fo 2 The value (@1) for MAXROWS must be zero or greater W SET EXPLAIN -- toggle display of query access plan in the explained form > There is no privilege granted on generator @1 in this databaseut > There is no privilege granted on exception @1 in this database ; There is no privilege granted on domain @1 in this databasep B There is no privilege granted on character set @1 in this database > There is no privilege granted on collation @1 in this database pØ < There is no privilege granted on package @1 in this databaseĘ = There is no privilege granted on function @1 in this databaseno Ř G Current memory = !
Delta memory = !
Max memory = !
Elapsed time= ~ sec
cƘ Cpu = ~ sec
ǘ , Buffers = !
Reads = !
Writes = !
Fetches = !Ș ' There is no mapping @1 in this database ɘ & There are no mappings in this databaseWSʘ , Invalid characters for SET TERMINATOR are @1˘ Records displayed: @1he ̘ . Full NULL columns hidden due to RecordBuff: @1 ͘ N SET RECORDBuf -- toggle limited buffering and trimming of columnsm Θ Number of DB pages used = @1Ϙ Number of DB pages free = @1И Database encryptedegј Database not encryptedhiҘ crypt thread not completeriv! GSEC> on" gsec# ADD add users$ DELETE delete user s% DISPLAY display user(s)is& MODIFY modify user @' PW user's passwordo ( UID user's ID) GID user's group IDiv* " PROJ user's project nameas+ ' ORG user's organization name
, FNAME user's first name- ) MNAME user's middle name/initial . LNAME user's last name!/ unable to open database 0 error in switch specificationser1 no operation specifiedba2 no user name specified f3 add record error4 modify record error@5 find/modify record error6 record not found for user: @1 7 delete record erroro8 find/delete record error9 users defined for node o: ? user name uid gid admin full namee; ` ------------------------------------------------------------------------------------------------< find/display record errorers= $ invalid parameter, no switch defined> operation already specified ? password already specified @ uid already specifiedswoA gid already specifieder'B project already specified grC organization already specifiedprD first name already specifiedE middle name already specified F last name already specifiedMG gsec versionH invalid switch specifiedI ambiguous switch specifiedabJ % no operation specified for parameters K ( no parameters allowed for this operationL incompatible switches specified M / gsec utility - maintains user password databaserN command line usage:rO <command> [ <parameter> ... ]oroP interactive usage: eQ available commands:oR adding a new user:naS add <name> [ <parameter> ... ] T deleting a current user:U
delete <name>---V displaying all users:---W display-X displaying one user:Y display <name> Z modifying a user's parameters:ed[ - modify <name> <parameter> [ <parameter> ... ]alr\ help:d ] ? (interactive only)^ help_ quit interactive session:roj` quit (interactive only) a available parameters:dprb -pw <password>eac
-uid <uid> d
-gid <uid>y e -proj <projectname>mf -org <organizationname>cg -fname <firstname> h -mname <middlename>ii -lname <lastname>tchj gsec - memory allocation errorfik
gsec error l , Invalid user name (maximum 31 bytes allowed)m 6 Warning - maximum 8 significant bytes of password usedntn database already specified o - database administrator name already specified.. p 1 database administrator password already specifieds:oq SQL role name already specified r [ <options> ... ]] s available options: ut # -user <database administrator name>iu + -password <database administrator password>ov , -role <database administrator SQL role name>w -database <database to manage>mex -zery displaying version number:lpz z (interactive only){ % -trusted (use trusted authentication)ion| , invalid switch specified in interactive mode} error closing security databasea~ , error releasing request in security database - -fetch_password <file to fetch password from> ! error fetching password from filee < 7 error changing AUTO ADMINS MAPPING in security databasec ? changing admins mapping to RDB$ADMIN role in security database:n < invalid parameter for -MAPPING, only SET or DROP is accepted mapping {set|drop} use gsec -? to get helpe -admin {yes|no} 8 invalid parameter for -ADMIN, only YES or NO is accepted + not enough privileges to complete operation Q4 found unknown switchR4 $ please retry, giving a database nameS4 . Wrong ODS version, expected @1, encountered @2>oT4 Unexpected end of database file.U4 gstat version @1V4
Database "@1"agW4
Database file sequence:g vX4 File @1 continues as file @2Y4 File @1 is the @2 filetrZ4
Analyzing database pages ...id [4 1 Primary pointer page: @1, Index root page: @2 se\4 9 Data pages: @1, data page slots: @2, average fill: @3ase]4 Fill distribution:to^4 Index @1 (@2) _4 ' Depth: @1, leaf buckets: @2, nodes: @3 `4 4 Average data length: @1, total dup: @2, max dup: @3a4 Fill distribution:pb4 Expected data on page @1c4 - Expected b-tree bucket on page @1 from @2SETd4 unknown switch "@1" e4 Available switches: f4 ( -a analyze data and index pagesg4 -d analyze data pagesonh4 $ -h analyze header page ONLYi4 $ -i analyze index leaf pagesj4 -l analyze log pagek4 ? -s analyze system relations in addition to user tablesel4 " -z display version number fm4 Can't open database file @1 n4 Can't read a database page fo4 System memory exhausted p4 -u usernameq4 -p passwordr4 5 -r analyze average record and version lengther s4 6 -t tablename <tablename2...> (case sensitive)tat4 & -tr use trusted authentication u4 $ -fetch fetch password from filev4 @ option -h is incompatible with options -a, -d, -i, -r, -s and -tw4 A usage: gstat [options] <database> or gstat <database> [options] x4 # database name was already specifieddy4 option -t needs a table namez4 & option -t got a too long table name @1sw{4 C option -t accepts several table names only if used after <database> |4 table "@1" not found}4 use gstat -? to get help~4 ; Primary pages: @1, secondary pages: @2, swept pages: @3 4 Big record pages: @14 / Blobs: @1, total length: @2, blob pages: @3e4 - Level 0: @1, Level 1: @2, Level 2: @3an'4 D option -e is incompatible with options -a, -d, -h, -i, -r, -s and -t4 ' -e analyze database encryption 4 2 Data pages: total @1, encrypted @2, non-crypted @3e 4 3 Index pages: total @1, encrypted @2, non-crypted @3t4 2 Blob pages: total @1, encrypted @2, non-crypted @3us4 9 no encrypted database support, only -e and -h can be used 4 # Empty pages: @1, full pages: @2o4 -role SQL role name a[ Wrong value for access mode b[ Wrong value for write mode c[ Wrong value for reserve spaceeddd[ @ Unknown tag (@1) in info_svr_db_info block after isc_svc_query()e[ + Unknown tag (@1) in isc_svc_query() results f[ Unknown switch "@1"ag[ Service Manager Versionfh[ Server version-?i[ Server implementationry j[ Path to firebird.msgk[ Server root l[ Path to lock filesesm[ Security database, tn[ Databasesbloo[ Database in use p[ Number of attachmentsq[ Number of databasesncr[ Information truncated, -s[ ( Usage: fbsvcmgr manager-name switches...t[ B Manager-name should be service_mgr, may be prefixed with host named u[ A according to common rules (host:service_mgr, \\host\service_mgr).lobv[ : Switches exactly match SPB tags, used in abbreviated form. w[ D Remove isc_, spb_ and svc_ parts of tag and you will get the switch.x[ A For example: isc_action_svc_backup is specified as action_backup,e y[ & isc_spb_dbname => dbname, z[ @ isc_info_svc_implementation => info_implementation,{[ > isc_spb_prp_db_online => prp_db_online and so on."a|[ P You may specify single action or multiple info items when calling fbsvcmgr once.}[ Full command line samples: ~[ a fbsvcmgr service_mgr user sysdba password masterkey action_db_stats dbname employee sts_hdr_pagesse [ ? (will list header info in database employee on local machine)c[ c fbsvcmgr yourserver:service_mgr user sysdba password masterkey info_server_version info_svr_db_info [ @ (will show firebird version and databases usage on yourserver)[ Transaction @1 is in limbot\[ ( Multidatabase transaction @1 is in limbo[
Host Site: @1evi[ Transaction @1su[ has been prepared be[ has been committed [ has been rolled back[ is not available[ Remote Site: @1.[ Database Path: @1act[ 0 Automated recovery would commit this transaction[ 2 Automated recovery would rollback this transaction [ , No idea should it be commited or rolled back[ Wrong value for shutdown modenli[ could not open file @1"a[ could not read file @1 a[
empty file @1o i[ $ Firebird Services Manager version @1[ * Invalid or missing parameter for switch @1gr[ 5 To get full list of known services run with -? switchee [ Attaching to services manager:ea[ Information requests: on[ Actions:[ Server capabilities:q J Switches trusted_user and trusted_role are not supported from command line ERROR: w G Physical Backup Manager Copyright (C) 2004 Firebird development teamn > Original idea is of Sean Leyne <sean@@broadviewsoftware.com>it E Designed and implemented by Nickolay Samofatov <skidder@@bssys.com> F This work was funded through a grant from BroadView Software, Inc.\n Usage: nbackup <options> exclusive options are:t J -L(OCK) <database> Lock database for filesystem copy J -UN(LOCK) <database> Unlock previously locked databaseli M -F(IXUP) <database> Fixup database after filesystem copyo i B -B(ACKUP) <level> <db> [<file>] Create incremental backupam C -R(ESTORE) <db> [<file0> [<file1>...]] Restore incremental backups 2 -U(SER) <user> User namefo 1 -P(ASSWORD) <password> Passwordlit A -FETCH_PASSWORD <file> Fetch password from file co E -NOD(BTRIGGERS) Do not run database triggers200 P -S(IZE) Print database size in pages after lock > -Z Print program versionsk Notes: ( <database> may specify database alias. D Incremental backups of multi-file databases are not supported yet. > "stdout" may be used as a value of <filename> for -B option.oc PROBLEM ON "@1". general options are: = switches can be abbreviated to the unparenthesized characters 5 Option -S(IZE) only is valid together with -L(OCK). fi 7 For historical reasons, -N is equivalent to -UN(LOCK) * and -T is equivalent to -NOD(BTRIGGERS).db Missing parameter for switch @1e K Only one of -LOCK, -UNLOCK, -FIXUP, -BACKUP or -RESTORE should be specifiedP Unrecognized parameter @1 Unknown switch @1TCH , Fetch password can't be used in service mode % Error working with password file "@1" ( Switch -SIZE can be used only with -LOCK = None of -LOCK, -UNLOCK, -FIXUP, -BACKUP or -RESTORE specified af Failure: -Z I Enter name of the backup file of level @1 ("." - do not restore further): IO error reading file: @1dat IO error writing file: @1 ba IO error seeking file: @1 no Error opening database file: @1b * Error in posix_fadvise(@1) for database @2 Error creating database file: @1 Error opening backup file: @1via Error creating backup file: @1 " Unexpected end of database file @1et 6 Database @1 is not in state (@2) to be safely fixed upui Database error Username or password is too long J Cannot find record for database "@1" backup level @2 in the backup history, 7 Internal error. History query returned null SCN or GUIDn K Unexpected end of file when reading header of database file "@1" (stage @2)d 9 Internal error. Database file is not locked. Flags are @1 / Internal error. Cannot get backup guid clumplete \ Internal error. Database page @1 had been changed during backup (page SCN=@2, backup SCN=@3) 1 Database file size is not a multiple of page size Level 0 backup is not restored = Unexpected end of file when reading header of backup file: @1 # Invalid incremental backup file: @1 5 Unsupported version @1 of incremental backup file: @2ati < Invalid level @1 of incremental backup file: @2, expected @3 Q Wrong order of backup files or invalid incremental backup file detected, file: @1ase ! Unexpected end of backup file: @1ed 5 Error creating database file: @1 via copying from: @2oo © O Unexpected end of file when reading header of restored database file (stage @1) é . Cannot get backup guid clumplet from L0 backupN ĩ " Physical Backup Manager version @1n ũ I Enter name of the backup file of level @1 ("." - do not restore further):filƩ W -D(IRECT) [ON | OFF] Use or not direct I/O when backing up database ǩ 0 Wrong parameter @1 for switch -D, need ON or OFFȩ special options are:ɩ Terminated due to user request ʩ S -DE(COMPRESS) <command> Command to extract archives during restoreo˩ / Too complex decompress command (> @1 arguments)f̩ 6 -RO(LE) <role> SQL role nameil ! Firebird Trace Manager version @1men ERROR: : Firebird Trace Manager.r ) Usage: fbtracemgr <action> [<parameters>] fi Actions: ; -STA[RT] Start trace sessionr : -STO[P] Stop trace session e = -SU[SPEND] Suspend trace session < -R[ESUME] Resume trace session D -L[IST] List existing trace sessions < -Z Show program version Action parameters:t 4 -N[AME] <string> Session name 2 -I[D] <number> Session IDe: E -C[ONFIG] <string> Trace configuration file name Connection parameters:nd 4 -SE[RVICE] <string> Service name 1 -U[SER] <string> User name 0 -P[ASSWORD] <string> Password @ -FE[TCH] <string> Fetch password from file D -T[RUSTED] <string> Force trusted authentication Examples: K fbtracemgr -SE remote_host:service_mgr -USER SYSDBA -PASS masterkey -LIST E fbtracemgr -SE service_mgr -START -NAME my_trace -CONFIG my_cfg.txt + fbtracemgr -SE service_mgr -SUSPEND -ID 2R * fbtracemgr -SE service_mgr -RESUME -ID 2es ( fbtracemgr -SE service_mgr -STOP -ID 4 Notes:in 0 Press CTRL+C to stop interactive trace session ' conflicting actions "@1" and "@2" foundm action switch not foundt ! switch "@1" must be set only once value for switch "@1" is missing $ invalid value ("@1") for switch "@2" unknown switch "@1" encountered ' switch "@1" can be used by service onlyV 0 switch "@1" can be used by interactive user only 3 mandatory parameter "@1" for switch "@2" is missingP / parameter "@1" is incompatible with action "@2"F mandatory switch "@1" is missing $ Ƙ - G g h
\ ^4 < u4 4 v[ [ $ ( , l0 `4 ɩ P8 $< @ D | $ E