Error Messages Associated with SQLSTATE 55000

This topic lists the errors associated with the SQLSTATE 55000.

SQLSTATE 55000 Description

ERRCODE_OBJECT_NOT_IN_PREREQUISITE_STATE

Error messages associated with this SQLState

ERROR 2088: A concurrent load into the partition or a concurrent mergeout operation interfered with this statement

ERROR 2143: AHM advanced beyond snapshot epoch

ERROR 2149: AHM can't be set

ERROR 2150: AHM can't be set while retentive refresh is running

ERROR 2151: AHM can't be set. (value nodes are down, out of value.)

ERROR 2152: AHM can't be set. (value nodes are down.)

ERROR 2159: All nodes must be UP to rebalance a cluster

ERROR 2163: Already released

ERROR 2175: An error occurred when loading library file on node string, message:
    string

ERROR 2200: AnalyzeStatsPlanMaxColumns configuration parameter 'value' invalid; must be greater than zero

ERROR 2201: AnalyzeStatsSampleBands configuration parameter 'value' invalid; must be greater than zero

ERROR 2241: Attempt to create view using an invalid relation

ERROR 2242: Attempt to run multi-node KV plan

ERROR 2294: CALL_USE_SESSION_NODES used without setting nodes

ERROR 2303: Can not tell if tables have data, too few responses (value) to be conclusive

ERROR 2316: Can't match imported node 'string' to node in current database

ERROR 2371: Cannot commit DML/DDL while a node is shutting down

ERROR 2380: Cannot create a library without an initialized LibraryPath on node: string

ERROR 2388: Cannot create projections on a temporary table that has data

ERROR 2409: Cannot drop any more columns in string

ERROR 2410: Cannot drop column "string" since it is referenced in the default expression of column "string"

ERROR 2413: Cannot drop column "string" since it was referenced in the default expression of added column "string"

ERROR 2422: Cannot Drop: string string depends on string string

ERROR 2424: Cannot execute query with temporary table because a node has recovered since the start of this session

ERROR 2448: Cannot issue this command in a read-only transaction

ERROR 2459: Cannot modify temporary table string because a node has recovered or rebalance data took place since the start of this string

ERROR 2483: Cannot remove snapshots without an initialized SnapshotPath

ERROR 2496: Cannot revoke EXECUTE permission from the owner: string

ERROR 2497: Cannot revoke EXECUTE permission from the super user

ERROR 2505: Cannot set column "string" in table "string" to NOT NULL since it contains null values

ERROR 2512: Cannot set memoryCap for session whose current user has been dropped

ERROR 2516: Cannot set runTimeCap for session whose current user has been dropped

ERROR 2517: Cannot set tempSpaceCap for session whose current user has been dropped

ERROR 2541: Cannot use addAny() with any other input column types

ERROR 2542: Cannot use addAny() with any other output column types

ERROR 2563: Cannot validate DV storage

ERROR 2564: Cannot validate storage

ERROR 2587: Changes cannot be made to [string]. It has been retired

ERROR 2762: COPY: Cannot load into IDENTITY column "string"

ERROR 2763: COPY: Cannot specify parsing options for IDENTITY column "string"

ERROR 2903: Could not reset epoch because DML locks are held

ERROR 2904: Could not reset epoch because projections exist

ERROR 2933: Couldn't force partition projection string

ERROR 2934: Couldn't force partition projections string

ERROR 2954: Current phase of recovery failed due to missed event at epoch value

ERROR 2955: Current set of up nodes do not satisfy dependencies

ERROR 2956: Current set of up nodes do not satisfy dependencies for table string

ERROR 2961: Current user has been dropped so no defaults are available

ERROR 2962: Current user has been dropped so no roles are available

ERROR 2969: Cursor can only scan forward

ERROR 3002: DDL statement interfered with alter column type

ERROR 3136: drop_partition failed for string on node string. The projection contains unpartitioned data

ERROR 3196: Error deserializing objects

ERROR 3229: Error loading library file:[string]

ERROR 3254: Error reading from file

ERROR 3278: Error writing to file

ERROR 3318: Execution aborted by node state change

ERROR 3807: JobTracker::getMarkedStorages(): Unknown job value

ERROR 3808: JobTracker::jobComplete(string): Unknown job value

ERROR 3809: JobTracker::setDetails(value,value,value): Unknown job value

ERROR 3810: JobTracker::setJobDescription(string): Unknown job value

ERROR 3838: Key value already in use

ERROR 3882: Location cannot be dropped as it stores data files

ERROR 3911: maxMemorySize for string can be changed only when the string WOS is empty

ERROR 3924: merge_partitions() failed on string because of unpartitioned data

ERROR 3925: Mergeout failed: projection string is not up-to-date

ERROR 4032: Naming conflict: string exists

ERROR 4092: No plan received at node

ERROR 4120: No transaction running on node

ERROR 4127: No valid cache found

ERROR 4138: Node string is not available for queries

ERROR 4144: Node has not been set up for plan execution

ERROR 4146: Node is not active or recovering, cannot plan query

ERROR 4148: Node not prepared to accept plan

ERROR 4151: Node unprepared for rebalance

ERROR 4177: Not enough nodes are up for Projection <string> to be available, marking it as out of date

ERROR 4403: Portal "string" cannot be run

ERROR 4457: Projection string checkpoint epoch lags snapshot epoch

ERROR 4458: Projection string contains data in the WOS

ERROR 4459: Projection string create epoch is greater than the epoch in the query

ERROR 4462: Projection string has HSE > snapshot epoch and buddy string has HSE <= snapshot epoch

ERROR 4464: Projection string is not up-to-date

ERROR 4467: Projection (name: string, oid: value) is newly added during current recovery

ERROR 4485: Projections string contain data in the WOS

ERROR 4530: Rebalance unable to moveout all data on projection string

ERROR 4592: reset_epoch is disabled because the EnableResetEpoch configuration parameter is 0

ERROR 4611: Returned string value '[string]' with length [value] is greater than declared field length of [value] of field [string] at output column index [value]

ERROR 4698: Sequence "string" has been created by an IDENTITY/AUTO_INCREMENT column and cannot be dropped

ERROR 4700: Sequence string has not been accessed in the session

ERROR 4765: Specified K-safety for projection creation is insufficient to support currently down nodes

ERROR 4791: Storage extends beyond specified segment range

ERROR 4793: Stream error: string

ERROR 4860: System is not k-safe. DDL is disallowed

ERROR 4861: System is not k-safe. DDL/DML is disallowed

ERROR 4879: Table "string" has projections in non-up-to-date state

ERROR 4880: Table "string" has projections that are not up-to-date that can refresh from buddy

ERROR 4903: Table or projection no longer exists

ERROR 4934: The attribute "string" in table "string" needs to be included in projection "string" because it is used in the partitioning expression

ERROR 4941: The data type requires length/precision specification

ERROR 4965: The restore violates K safety

ERROR 4972: The types/sizes of source column (index value, length value) and destination column (index value, length value) do not match

ERROR 5084: Tried to add field 'string' that already exists

ERROR 5085: Tried to add unknown node 'string' to user-defined query plan

ERROR 5132: Unable to evaluate the delete performance after dropping this column for projection "string"

ERROR 5151: Unable to validate data in string: string

ERROR 5204: Unknown data type

ERROR 5210: Unknown object: string

ERROR 5321: Usage of [string] cannot be changed. It has been retired

ERROR 5381: User Defined Scalar Function can only have 1 return column, but value is provided

ERROR 5522: A concurrent operation interfered with this statement

ERROR 5534: Can't create table in specified target schema

ERROR 5535: Can't find target table's schema

ERROR 5543: Cannot use column type 'any' with any other input column types

ERROR 5544: Cannot use column type 'any' with any other output column types

ERROR 5583: Fault Group "string" already exists in a fault group

ERROR 5587: Fault Group "string" not found in Fault Group "string"

ERROR 5590: Found value unsegmented projections with basename string; inconsistent with permanent nodes count value

ERROR 5626: Node "string" already exists in a fault group

ERROR 5627: Node "string" not found in Fault Group "string"

ERROR 5660: Source table can not be temp, virtual, system, or external

ERROR 5662: Storage tier string has not been found on all nodes

ERROR 5667: Target table can not be temp, virtual, system, or external

ERROR 5674: TM interfered with this statement

ERROR 5705: Dvmergeout failed: projection string is not up-to-date

ERROR 5712: JobTracker::reportStart: Unknown job value

ERROR 5735: Tier string is referenced by storage policies. Can not make storage location changes as requested

ERROR 5760: Can only change setting when all started nodes are UP

ERROR 5765: Cannot change control node away from self because other nodes depend on this node to be their control node

ERROR 5766: Cannot change final control node away from self until at least one other node is promoted to be a control node

ERROR 5772: Cannot manually alter automatically generated fault groups

ERROR 5786: Column value does not have corresponding storages yet. A concurrent add column operation might be running

ERROR 5883: Failed to list hcatalog tables

ERROR 6001: Recovery failed because DVROS straddles discard epoch

ERROR 6035: Table "string" has no non-null records under the column key_name

ERROR 6037: Table "string_string" cannot be found or was not created internally

ERROR 6065: Tried to allocate and initialize a value-byte string with value zero bytes; VString is too small

ERROR 6066: Tried to copy a value-byte string to value-byte VString object; VString is too small

ERROR 6105: View "string" is already linked to flex table "string".  Linked views will not be overwritten

ERROR 6106: View "string" is already linked to this table.  Linked views will not be overwritten

ERROR 6107: View "string_string" cannot be found or was not created internally

ERROR 6110: A design/deployment process is currently executing in this design space

ERROR 6121: A concurrent opertation interfered with this statement

ERROR 6176: Cannot replace node string because it is already a STANDBY

ERROR 6177: Cannot replace node string because it is not DOWN

ERROR 6184: Cannot swap partition between same table

ERROR 6185: Cannot transition node string to string because it still has data

ERROR 6186: Cannot transition node string to STANDBY because its loss would cause the cluster to shutdown

ERROR 6207: Could not create internal data-storage directory 'string': value

ERROR 6357: No standby nodes are currently available

ERROR 6359: Node string has not been replaced

ERROR 6360: Node string is a string node and cannot store data

ERROR 6374: Original node string is not currently available in STANDBY mode

ERROR 6419: Table string can not be temp, virtual, system, or external

ERROR 6422: Target node string is a string node, not a STANDBY node

ERROR 6424: Target standby node string is not currently available

ERROR 6446: UDx set BOOLEAN column value to non-boolean value value

ERROR 6478: Can only take object-level snapshot from local storage locations

ERROR 6524: DDL interfered with this statement. Table is not partitioned or partition expression got changed

ERROR 6553: Compact storage failed: projection string is not up-to-date

ERROR 6633: An enabled constraint can only be declared on a global temporary table during CREATE TABLE

ERROR 6634: An enabled constraint cannot be created on a temporary table with existing data

ERROR 6646: Attempted to commit when column value has value rows while column 0 has value rows

ERROR 6647: Attempted to use a string as a string

ERROR 6648: Attempted to write past the end of a column

ERROR 6658: Can not string to the same table

ERROR 6665: Can not set priority for text index, please use its source table

ERROR 6675: Cannot drop column "string" since it is the last non-IDENTITY, non-AUTO_INCREMENT column

ERROR 6677: Cannot execute query because table recovery status change

ERROR 6784: Final attempt at a database snapshot upgraded storage ids on the following nodes: string

ERROR 6811: Incorrect use of setter in processBlock

ERROR 6812: Incorrect use of setter in processPartition for [value] column

ERROR 6826: Invalid node Oid value

ERROR 6870: Multiple values for the parameter string. The parameter will not be set

ERROR 6937: Restore: Cannot overwrite object string

ERROR 6957: Source items are not the correct encoding for direct copies

ERROR 6958: Source items are not the correct size for direct copies

ERROR 6976: Table "string" has not been recovered. Please try later

ERROR 6982: Table can not be temp, virtual, system, or external

ERROR 6989: Terminate() must be overidden for a User Defined Aggregate

ERROR 6997: The key string doesn't exist

ERROR 7001: The sessionParamReader for namespace 'string' doesn't exist

ERROR 7002: The sessionParamWriter for namespace 'string' doesn't exist

ERROR 7016: UDx set BOOLEAN column value, row value to non-boolean value value

ERROR 7017: Unable to acquire side process info

ERROR 7072: WebHCat query [string] failed: string

ERROR 7093: Comment length of parameter 'string' is 'value' which exceeds the maximum allowed 'value'

ERROR 7119: Source and target table do not match: string

ERROR 7121: Staging table and target table do not match: string

ERROR 7173: Current set of up nodes do not satisfy dependencies for DFS file distribution value

ERROR 7193: RecoverByContainer::recover can't advance the cpe by recovering containers

ERROR 7212: Cannot restore data to node string

ERROR 7290: Trying to set the column "string" to size of value All data type lengths in table "string" must not be greater than value, the current maximum raw size for flex table values

ERROR 7299: Cannot alter type of column "string" since it is referenced in the default expression of table "string", column "string"

ERROR 7300: Cannot alter type of column "string" since it is referenced in the set using expression of table "string", column "string"

ERROR 7301: Cannot drop column "string" since it is referenced in the default expression of table "string", column "string"

ERROR 7302: Cannot drop column "string" since it is referenced in the set using expression of table "string", column "string"

ERROR 7343: string expression of IDENTITY/AUTO_INCREMENT column "string" cannot be altered

ERROR 7390: Cannot set idlesessiontimeout for session whose current user has been dropped

ERROR 7448: Location cannot be dropped as it stores DFS files

ERROR 7458: Mergeout failed: found missed string on table string

ERROR 7537: Sequence "string" has been created by an IDENTITY/AUTO_INCREMENT column and cannot be used in a string expression

ERROR 7583: User or Role value cannot be found

ERROR 7619: SBJobTracker::setAdditionalInfo: Unknown oid "value"

ERROR 7671: Wrong checksum for library file string

ERROR 7766: Cannot drop column "string" since it is referenced in the set using expression of column "string"

ERROR 7811: SendFiles on node string: file [string] has changed

ERROR 7821: Cannot rename user "string" since they use MD5 password format

ERROR 7856: Not all requested nodes are available at this moment

ERROR 7857: Not enough available nodes at this moment

ERROR 7866: DDL statement interfered with this statement. ProjCol value cannot be found

ERROR 7978: Can only use KV hint with SELECT queries

ERROR 7983: Cannot use KV Hint with a subquery

ERROR 8009: Running KV query inside existing transaction. There will be a performance implication. Consider rerunning the query outside of an existing transaction

ERROR 8061: Cannot create COMMUNAL storage location with usage string

ERROR 8062: Cannot create COMMUNAL storage location without sharding enabled

ERROR 8064: Cannot drop last subscription for a shard

ERROR 8069: Cannot set grace period for session whose current user has been dropped

ERROR 8083: Database does not have shards to rebalance

ERROR 8139: Projection must be created in the same schema as its anchor table

ERROR 8147: SALColumn found during restore. Restoring objects from on older vertica version is not supported

ERROR 8151: Session resource pool does not exist

ERROR 8159: Size can be changed only for DEPOT locations

ERROR 8173: Text index must be created in the same schema as its source table

ERROR 8181: Unable to read file string

ERROR 8185: Usage of [string] cannot be changed. It is a depot location

ERROR 8186: User lacks privileges on resource pool 'string'

ERROR 8210: Object value appears in the newborns of the Transaction Catalog.
     
                            Object is Global: string
     
                            Object has Shard Tag: value 
     
                            Object was created in this TXN tier: string 

ERROR 8222: No active subscriptions found for the session

ERROR 8228: Cannot load snapshot containing DOWN source node string into the current database

ERROR 8229: Cannot restore or replicate while a node is recovering

ERROR 8232: No snapshot to load in the current session.  Did load_snapshot_prep() succeed?

ERROR 8235: Sequence "string" has been created by an IDENTITY/AUTO_INCREMENT column and name is internal to Vertica, can not be changed  directly

ERROR 8236: Sequence "string" has been created by an IDENTITY/AUTO_INCREMENT column, the schema associate with it cannot be changed directly

ERROR 8237: Snapshot contains internally inconsistent epochs; unable to load

ERROR 8239: Unable to map excluded source node string

ERROR 8257: Cannot find an UP node with an ACTIVE subscription to the replica shard

ERROR 8261: Dvmergeout failed: not a participating subscriber

ERROR 8266: Mergeout failed: not a participating subscriber

ERROR 8305: Partition projection failed: not a participating subscriber

ERROR 8313: ROS/shard inconsistencies during partitioning

ERROR 8348: Shards string are missing participating subscription

ERROR 8360: Need to split partitions before copy/move/swap partitions

ERROR 8365: Unable to copy/move/swap partitions because some projection(s) contain unpartitioned data

ERROR 8384: ROS/shard inconsistencies during dvmergeout

ERROR 8385: ROS/shard inconsistencies during mergeout

ERROR 8400: Can not partition projection by given range due to the group by expression

ERROR 8423: Recovery failed due to missed event at epoch value

ERROR 8430: Some storage containers must be split before the specified partition range can be dropped

ERROR 8435: The number of nodes in communal storage (value) is less than the number of nodes specified (value)

ERROR 8445: Unable to moveout all data on projection string

ERROR 8453: Rebalance: Refreshing projection string

ERROR 8459: Node string is shut down

ERROR 8470: Attempting to load snapshot with inconsistently applied upgrade tasks

ERROR 8483: Execution aborted by cluster configuration changes at catalog version value, more recent than our latest sync at version value on this node

ERROR 8484: File string does not exist

ERROR 8501: Cannot create miniroses on node string

ERROR 8528: Subscription identified by (string,string) is already marked for removal

ERROR 8562: Node failure during planning

ERROR 8567: ROSs were moved/deleted during TM operation

ERROR 8570: Can't find the opened file [string]

ERROR 8592: Storage container value of table string has been moved to table string

ERROR 8594: Cannot do recovery by container for aggregate projection

ERROR 8603: cluster_config.json file does not exist!

ERROR 8605: Could not find spread security details in file

ERROR 8606: Database config parameter change interfered with this statement

ERROR 8613: Key id or contents are not of proper size. Id: string (value), Key hex len: value

ERROR 8618: Spread Decryption failed (value bytes)

ERROR 8620: Spread encryption key [string] not found

ERROR 8635: Attempted access to parameter 'string' of type 'string' using incompatible accessor 'string'

ERROR 8639: Error checking compatibility in cluster_config.json. Details -- string

ERROR 8640: Error parsing version information in string string - did not match expected format v%value%value%value-%value

ERROR 8655: DDL statement interfered with this statement; subscriptions changed

ERROR 8661: Storage may need to be reorganized in accordance with the partition GROUP BY policy

ERROR 8676: DML/DDL interfered with ALTER COLUMN TYPE

ERROR 8684: Cannot execute query with temporary table because session subscriptions have changed since the start of this session

ERROR 8685: Cannot modify temporary table string because session subscriptions have changed since the start of this string

ERROR 8690: Current column data does not conform to the new type

ERROR 8702: Schema string is already owned by string

ERROR 8713: Database can only be revived from an older release and from a database version on or after Vertica9.1.0-0. The current database version is string, while the configuration file version is string

ERROR 8715: Fail to compute network routing checksum

ERROR 8731: Cannot obtain row count for projection string

ERROR 8736: Partial recovery on projection string is detected (cpe = value, startEpoch = value). Need to restart recovery

ERROR 8738: The storage location "string" has changed during the plan

ERROR 8742: No response from nodes creating DFS files: string

ERROR 8743: No response from required nodes: string

ERROR 8745: Node string is not participating for shard string. Probably caused by concurrent subscription changes

ERROR 8748: Compact storage failed: storage containers have been dropped/moved

ERROR 8752: Mergeout failed: storage containers have been dropped/moved

ERROR 8754: Recovery failed because SC value [0xvalue, 0xvalue] straddles endEpoch value to discard

ERROR 8755: Recovery failed because SC straddles discard epoch

ERROR 8800: Metafunction in multi-statement command is not supported

ERROR 8806: UDx rejected row with invalid index value

ERROR 8825: Branch string does not have a base cluster_config.json

ERROR 8832: Cannot create a branch from a branch

ERROR 8834: Cannot create branches with count 0

ERROR 8835: Cannot drop branch from a branch, only from master

ERROR 8836: Cannot flip between branches with revive

ERROR 8837: Cannot run clean_communal_storage from a data immutable branch

ERROR 8842: Could not upload the library [string] to communal storage. The tar file [string] does not exist

ERROR 8843: Database on branch string appears to still be running.  Lease expires at [string]

ERROR 8869: The database has value existing branches and attempts to add value more branches. Only value branches can co-exist at any time

ERROR 8870: The database has value existing branches and attempts to add value more branches. Only value branches can co-exist at any time in Community Edition(CE) License

ERROR 8872: There is a problem creating branches

ERROR 8874: Branch name can only be 1-30 characters long

ERROR 8878: Invalid branch name. Branch name has to begin with a letter, and can only contain alphanumeric characters and _ (underscore)

ERROR 8879: The storage container value to reocver have been dropped by tuple mover operations

ERROR 8882: Cannot create branches with '*' and ',' syntaxes simultanesously

ERROR 8884: Cannot create Depot storage location. Target node is down and there is no depot location on the initiator to estimate the size

ERROR 8885: Cannot create branches at a future version. branch ver: value, current ver: value

ERROR 8886: Cannot create branches with 'LIKE' and 'AT VERSION' syntaxes simultanesously

ERROR 8888: Storage container value of projection string has been dropped

ERROR 8891: Unable to refresh column on partitions already merged

ERROR 8892: Unable to refresh column on partitions because some projection(s) contain unpartitioned data

ERROR 8925: Unable to analyze statistics on partitions already merged

ERROR 8926: Unable to analyze statistics on partitions because some projection(s) contain unpartitioned data

ERROR 8927: Update storage catalog failed: not a participating subscriber

ERROR 8948: DDL interferes with this statement: requested storages no longer exist

ERROR 8969: Node string does not subscribe to shard string during backup, which is different from current node subscriptions

ERROR 8970: Node string does not subscribe to shard string, which is different from node subscriptions of backup cluster

ERROR 8971: Node subscription has changed

ERROR 8984: Shard count in the restore db is different from backup db (backup db: value, restore db: value)

ERROR 8985: Shard of the backup db does not exists in restore db (shard oid : value)

ERROR 8987: Subscription (node string) to Shard value has changed or is changing or has changed

ERROR 8988: Subscription of node string is changing

ERROR 8991: The node string is no longer UP

ERROR 8992: The number of active node subscription has changed from value to value

ERROR 8993: The number of UP nodes is changed from value to value