Warning Messages Associated with SQLSTATE 01000

This topic lists the warnings associated with the SQLSTATE 01000.

SQLSTATE 01000 Description

ERRCODE_WARNING

Warning messages associated with this SQLState

WARNING 2362: Cannot begin transaction; transaction is already running
WARNING 3084: Design couldn't be dropped
WARNING 3152: Duplicate values in columns marked as UNIQUE will now be ignored for the remainder of your session or until reenable_duplicate_key_error() is called
WARNING 3372: Failed to disable profiling: string
WARNING 3373: Failed to enable profiling: string
WARNING 3539: Incorrect results are possible. Please contact Vertica Support if unsure
WARNING 3791: Invalid view string: string
WARNING 4071: NO COMMIT option will be ignored for external table "string"
WARNING 4088: No new valid default roles specified. Retaining previous set of default roles for user string
WARNING 4098: No projections found
WARNING 4102: No rows are inserted into table "string"."string" because ON COMMIT DELETE ROWS is the default for create temporary table
WARNING 4116: No super projections created for table string. 
WARNING 4246: Only GLOBAL scope is supported for clearing string profiles
WARNING 4463: Projection string is not up to date
WARNING 4468: Projection <string> is not available for query processing. Execute the select start_refresh() function to copy data into this projection.
     The projection must have a sufficient number of buddy projections and all nodes must be up before starting a refresh
WARNING 4792: Storage option "string" will be ignored for external table "string"
WARNING 4871: System view string for tuning rule string is currently invalid
WARNING 4873: System view for tuning rule string does not exist
WARNING 4996: This request may deadlock the system.  Please report the details to technical support
WARNING 5068: Total declared length of columns of one of the constraints exceeds the limit, truncation may happen
WARNING 5119: UDx code didn't respond when Vertica tried to get function prototype for string in library string: string
WARNING 5448: View string is currently invalid
WARNING 5451: Violations of some of foreign key constraints may not be reported because of no privilege on the foreign tables
WARNING 5642: Projection string is not persistent or not up to date; it will not be copied
WARNING 5717: No statistics has been exported. Either the DB is empty or you try to export an external table or you do not have access to the available objects
WARNING 5724: Segmentation clause contains a string - data loads may be slowed significantly
WARNING 5727: Sort clause contains a string - data loads may be slowed significantly
WARNING 5741: View string depends on other relations
WARNING 5819: Design could not be reset
WARNING 5821: Detected keys sharing the same case-insensitive key name
WARNING 5860: Due to the data isolation of temp tables with an on-commit-delete-rows policy, the compute_flextable_keys() and compute_flextable_keys_and_build_view() functions cannot access this table's data. The build_flextable_view() function can be used with a user-provided keys table to create a view, but involves a DDL commit which will delete the table's rows
WARNING 5873: Failed to add table string of hcatalog schema string to catalog: string
WARNING 5875: Failed to alter table string of hcatalog schema string to catalog: string
WARNING 5880: Failed to describe table string in hcatalog database string: string
WARNING 5881: Failed to describe table string in schema string: HCatalog database string does not exist
WARNING 5884: Failed to list hcatalog tables of hcatalog schema string: string
WARNING 5886: Failed to mirror table string in schema string: string
WARNING 5909: Found and ignored keys with names longer than the maximum column-name length limit
WARNING 5912: HASH() arguments contain expressions that reference table columns
WARNING 5917: Ignored some keys since the total key count exceeds the view column limit
WARNING 5922: Insufficient privileges to alter table string
WARNING 5923: Insufficient privileges to drop table string
WARNING 5991: Projection basename "string" hint was ignored. "string" is used as the basename
WARNING 5993: Projection is irregularly segmented by column
WARNING 6053: The view creation involved a DDL commit which deleted the table's rows
WARNING 6256: Error while analyzing constraint(s) string on string
WARNING 6257: Error while creating LTT for analyzing constraints on string
WARNING 6356: No partitions have been swapped. Neither table has partitions fall in range
WARNING 6417: Swapped partitions are not immediately moved to a new storage location
WARNING 6515: Projection with name "string" already exists in schema "string" for anchor table "string.string"
WARNING 6565: Inequal query trees produced the same hash code query1:
    string
    query2:
    string
WARNING 6594: Unknown RangeTblEntry:value
WARNING 6608: string is an invalid argument for hint string
WARNING 6765: Error parsing distrib value string in Distrib hint's arguments. The whole hint will be ignored
WARNING 6773: Failed to compare plans for query 'string'
WARNING 6797: Hint string can accept at most one argument, the hint with value arguments is ignored
WARNING 6798: Hint string can be specified only once for each join, if multiple instances listed only the first is considered
WARNING 6799: Hint string is not feasible and will be ignored
WARNING 6801: Hint string requires exactly two arguments, the hint with value arguments is ignored
WARNING 6813: Inherited privileges are globally disabled; schema parameter is set but has no effect
WARNING 6814: Inherited privileges are globally disabled; table parameter is set but has no effect
WARNING 6815: Inherited privileges are globally disabled; view parameter is set but has no effect
WARNING 6818: Input operations specified for Hint string is not feasible and will be ignored
WARNING 6922: Projection name was changed to string because it conflicts with the basename of the table string
WARNING 6990: Text index has invalid tokenizer
WARNING 6991: The active saved plan for this query has incompatible output column set. Continuing with the original query
WARNING 7000: The projection 'string' was used to enforce the enabled key constraint 'string', and may be regenerated to validate a DML statement on the base table
WARNING 7020: Unable to find the following query in the export file: 'string'
WARNING 7030: Unexpected group clause found during query comparison
WARNING 7031: Unexpected group clause found during query hashing
WARNING 7033: Unexpected sort clause found during query comparison
WARNING 7036: Unknown Expr:value during query comparison
WARNING 7037: Unknown Expr:value found
WARNING 7038: Unknown Expr:value found during query hashing
WARNING 7039: Unknown Inequality OpOid:value found during query hashing
WARNING 7040: Unknown Logic OpExpr:value found during query comparison
WARNING 7041: Unknown Logic OpExpr:value found during query hashing
WARNING 7044: Unknown OpExpr:value found during query comparison
WARNING 7045: Unknown OpExpr:value found during query hashing
WARNING 7046: Unknown RangeTblEntry:value found during query comparison
WARNING 7047: Unknown RangeTblEntry:value found during query hashing
WARNING 7048: Unknown Sublink:value found during query comparison
WARNING 7049: Unknown Sublink:value found during query hashing
WARNING 7052: Unsupported JoinExpr Type found during query comparison
WARNING 7053: Unsupported JoinExpr Type found during query hashing
WARNING 7070: View "string" will include privileges from schema "string"
WARNING 7074: You appear to be using an old version of HDFS that may have stability problems under high load. See the Vertica documentation for supported HDFS versions
WARNING 7186: Inherited privileges are globally disabled. Privileges will be materialized and visibility of table string may change
WARNING 7265: Inherited privileges are globally disabled. Privileges will be materialized and visibility of view string may change
WARNING 7709: Could not drop table 'string'. Please remove manually if necessary.
    Detail: string
WARNING 7752: Cannot make a local query plan for "try local" hint, please check hash function, segment quantity, segment boundary, etc
WARNING 7793: The cache will be set to 1 instead
WARNING 7942: Unknown expression found during hashing: value
WARNING 7994: Not converged before max_iterations [value]
WARNING 8012: The parameter [string] is not defined for this function
WARNING 8086: Encoding option specified for attribute (string) of external table (string) will be ignored
WARNING 8275: The following shards missed the string due to missing primary subscriber (probably down): string
WARNING 8343: Not converged before max_iterations value
WARNING 8413: Lambda provided without regularization type: default for regularization is [string]; lambda will have no effect
WARNING 8414: max_depth is set to value while max_breadth to value. This means the size of trees may become limited by string first
WARNING 8419: Parameters [string] are not supported for optimizer [string], only for [string]
WARNING 8506: CGD optimizer could not invert covariance matrix which is required for calculating statistics. Coefficients are not affected
WARNING 8526: Regularization type [string] may cause optimizer [string] to not converge
WARNING 8531: string Directory for errors files was not created.
     Unable to write errors for this instance of COPY command
WARNING 8547: Not converged before maximum inner iterations value
WARNING 8557: Feature string not applicable in Eon mode
WARNING 8580: Failed to convert internal form to readable form: string
WARNING 8581: Failed to convert to internal form: string
WARNING 8582: Failed to describe hcatalog tables of hcatalog schema string: string
WARNING 8583: Given lambda value [value] will result in all zero coefficients; use a value lower than lambda max for this dataset [value]
WARNING 8602: Caught exception while parsing JSON
WARNING 8621: The following string provided is not valid JSON: string
WARNING 8704: This table is not partitioned. Ignore activePartitionCount changes
WARNING 8737: The meta function set_recover_by_table is disabled in 9.1SP1. set_recover_test_settings() is supposed to be used only for testing purpose by developers
WARNING 8818: Library and dependencies have a combined size of value GB,
WARNING 8841: Consider enabling MergeOutCache when reflexive mergeout is disabled. Otherwise background TM Mergeout service may affect the query performance
WARNING 8953: Hint ECSMode is not feasible and will be ignored
WARNING 9002: Setting the token timeout greater than value msec may severely decrease cluster responsiveness to node shutdowns and failures
WARNING 9011: MergeOutCache doesn't work when reflexive mergeout is enabled
WARNING 9127: UPDATE/DELETE a table with aggregate projections (LAPs) will automatically run refresh on the LAPs when this transaction commits
WARNING 9210: Target node string is down, so depot size has been estimated from depot location on initiator. As soon as the node comes up, its depot size might be altered depending on its disk size
WARNING 9337: Caught exception while connecting to LDAP: string

The Vertica User Community contains knowledge base articles, blogs, and forum posts that may help you resolve these errors.