Messages associated with SQLSTATE 01000
This topic lists the messages associated with the SQLSTATE 01000.
This topic lists the messages associated with the SQLSTATE 01000.
SQLSTATE 01000 description
WARNING
Messages associated with this SQLState
Error messages
ERROR 5922: Insufficient privileges to alter table string
Notice messages
NOTICE 2005: string
NOTICE 2519: Cannot shut down while users are connected
NOTICE 2690: Compression hint specified for column 'string' does nothing
because column is GROUPED
NOTICE 3175: Encoding requested for column 'string' does nothing
NOTICE 3512: Ignoring data path, change unsupported
NOTICE 4927: The string string depends on string
NOTICE 4929: The string [string] depends on string
NOTICE 5748: API limitation: affinities will be set only for the first
value (out of value) CPUs
NOTICE 6008: Resetting CPU affinity set for resource pool string to the
default (ANY)
NOTICE 6182: Cannot shut down while DBD sessions are running
NOTICE 7090: Cannot set affinity set for resource pool 'string' because
the affinity mode is ANY
NOTICE 7338: The column "string" of table "string" is referenced by table
"string", column "string"
NOTICE 8689: value objects could not be re-parented
NOTICE 9088: Omitting rest of dependent objects, overall value objects
depending on string
NOTICE 9503: The string [value] depends on string
Warning messages
WARNING 2005: string
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 4539: Received no response from stringstring
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 6800: Hint string must have one argument
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
WARNING 9740: Changed max_depth to [value] to avoid a structural limit
WARNING 9974: No DFS file replicas available for retrieval of DFS file
located at string (Oid: value)from its DFS file distribution
value. This file will be dropped by Recovery
WARNING 9975: No nodes in cluster contain DFSFileBlocks for retrieving
DFS file located at string: (Oid: value).This file will be
dropped
WARNING 9990: :c hint in Create directed query CUSTOM has no effect,
every constant counts by default
WARNING 9994: IgnoreConst/:v hint in Create directed query OPT has no
effect, all constants are ignored by default
WARNING 10003: Unsupported hint for Constant type
WARNING 10251: Failed to disable debugging: string
WARNING 10252: Failed to enable debugging: string
WARNING 10365: No mergeout ran because mergeout is disabled on
table(s) string
WARNING 10395: New query label string will replace already set label string
WARNING 10420: New range-partitioned projection string is segmented.
Because anchor table string has no unsegmented super
projections, the new projection cannot be used to
process queries
WARNING 10440: Endpoint does not exist (http_code=value).Phone home data
upload to [string] failed: string
WARNING 10441: Failed to collect Phone home data
WARNING 10447: Phone home data upload to [string] failed: string
WARNING 10582: Failed to parse schema [string] with error [string]
WARNING 10586: Token introspection request to [string] failed: string
WARNING 10606: Discovery URL request to [string] failed: string
WARNING 10608: Failed to parse schema of discovery URL response [string]
with error [string]