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 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 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 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 4467: Projection (name: string, oid: value) is newly added during current recovery
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 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) in '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 8842: Could not upload the library [string] to communal storage. The tar file [string] does not exist
ERROR 8879: The storage container value to reocver have been dropped by tuple mover operations
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 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 subscription for node: string has changed between backup and restore
ERROR 8984: Shard count in the restore db is different from backup db (backup db: value, restore db: value)
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 9034: string expression of complex type column "string" cannot be altered
ERROR 9082: Error loading library file [string]: string
ERROR 9084: Missing library tarball on communal storage [string]
ERROR 9099: Cannot find participating nodes to run the query
ERROR 9105: DDL interferes with this statement: table value no longer exists
ERROR 9115: Node is not up yet
ERROR 9119: Primary subcluster "string" cannot be promoted
ERROR 9120: Secondary subcluster "string" cannot be demoted
ERROR 9157: Dependent storage containers are dropped during dvmergeout
ERROR 9193: Subscription (node string) to Shard string(value) has changed or is changing or has changed
ERROR 9217: Attempted to access element past end of array
ERROR 9218: Attempted to write data for a null array element
ERROR 9219: Cannot cast array with dimensions value to primitive
ERROR 9224: Multi-dimensional array expression has array with unexpected dimensionality value, expecting value
ERROR 9287: Complex type string inside Row type is not supported
ERROR 9288: Complex type string of column value is not supported
ERROR 9315: Both operands must have the same dimensionality
ERROR 9316: Current set of up nodes do not satisfy dependencies for DFS file retrieval from DFS file distribution value
ERROR 9319: Function only supports 1D array input
ERROR 9320: Function resize is only for inline VString!
ERROR 9331: Tried to resize a value-byte string; VString is too small
ERROR 9351: Unable to take snapshot when subscription to string is not ACTIVE
ERROR 9381: Column "string" does not exist in table string
ERROR 9396: Node string has resubscribed to shard string. Probably caused by concurrent subscription changes or node restart
ERROR 9412: Depot location has not been found on all nodes
ERROR 9429: All nodes must be node_state UP and node_type PERMANENT/EPHEMERAL. Node string is string
ERROR 9432: Communal storage location [string] is an invalid path for file system [string]
ERROR 9433: Communal storage location is empty
ERROR 9434: Concurrent database migration jobs are running against the same communal storage location [string]
ERROR 9438: Database must be elastic to start migration
ERROR 9439: Database on string appears to be in use. Lease expires at [string]
ERROR 9440: Depot location [string] is an invalid path for file system [string]
ERROR 9441: Depot location is empty
ERROR 9442: Down/recovering nodes are detected. All nodes must be UP to start migration
ERROR 9453: HDFS path [string] detected. HDFS is not supported at this time
ERROR 9455: Local path [string] detected. Please set a cloud location for communal storage
ERROR 9461: No unbundled storage files allowed. Unbundled DVMiniRos detected
ERROR 9462: Node string are added during database migration
ERROR 9463: Path [string] is not a local path. Please enter a local path
ERROR 9464: Path [string] is not an absolute path. Please enter an absolute path
ERROR 9475: The state of nodes are changing during database migration
ERROR 9494: Error writing error log to [string]
ERROR 9496: Inconsistent projections found. See error log at [string]
ERROR 9504: Unbundled storage containers or groupROSes found. See error log at [string]
ERROR 9513: Refresh cannot be finished when nodes are recovering
ERROR 9514: The states of UP nodes have been changed
ERROR 9522: DDL interferes with this statement: projection value no longer exists
ERROR 9523: DDL interferes with this statement: table string is no longer partitioned
ERROR 9525: A different database[string (revive ID string)] exists on the communal storage location [string]
ERROR 9526: A different database[string (revive ID string)] has already existed on the communal storage location [string]
The Vertica User Community contains knowledge base articles, blogs, and forum posts that may help you resolve these errors.