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 5643: Projection string is prejoin projection; 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 8887: USE AT YOUR OWN RISK. Branches created at random version are unsupported and undocumented

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