Error Messages Associated with SQLSTATE 42710

This topic lists the errors associated with the SQLSTATE 42710.

SQLSTATE 42710 Description

ERRCODE_DUPLICATE_OBJECT

Error messages associated with this SQLState

ERROR 2101: A sequence named "string" already exists
ERROR 2105: A table named "string" already exists
ERROR 2107: A view named "string" already exists
ERROR 2273: Bootstrap error (most likely in Bootstrap.cpp): Oid value is already registered
ERROR 2276: Bootstrap error (most likely in Bootstrap.cpp):Name string is already registered
ERROR 2713: Constraint string already exists
ERROR 3153: Duplicated local temp table found in design queries: string
ERROR 3327: Existing object "string" is not a view
ERROR 3881: Location [string] already exists for node string
ERROR 4043: Network Interface "string" already exists
ERROR 4135: Node "string" already exists
ERROR 4213: Object "string" already exists
ERROR 4445: Profile "string" already exists
ERROR 4482: Projection with base name "string" already exists
ERROR 4564: Relation "string" already exists
ERROR 4565: Relation "string" already exists in schema "string"
ERROR 4593: Resource pool "string" already exists
ERROR 4621: Role "string" already exists
ERROR 4804: Subnet "string" already exists
ERROR 4805: Subnet "string" already exists for [string]
ERROR 5582: Fault Group "string" already exists
ERROR 5584: Fault Group "string" cannot depend on itself directly or indirectly
ERROR 5615: Location [string] conflicts with existing location [string] on node string
ERROR 5623: Network Interface "string" already exists for [string]
ERROR 6009: Resource pool string already exists
ERROR 6112: Unable to guarantee the same base name for all segmented buddy projections
ERROR 6148: Authentication "string" already exists
ERROR 6157: Can't create an index in schema "string": Schema cannot be found
ERROR 6158: Can't create an index named "string": Object already exists
ERROR 6188: Client authentication "string" already exists
ERROR 6735: Directed query with identifier "string" already exists
ERROR 6736: Directed query with identifier "string" does not exist
ERROR 7059: User "string" already exists
ERROR 7713: Error in blob creation: A blob with name 'string' already exists
ERROR 7963: Relation [string] specified in parameter 'output_view' already exists
ERROR 8059: Cannot add more than one cache location
ERROR 8201: The specified output Table/View [string] already exists
ERROR 8251: Node string is already subscribed to shard string in string state
ERROR 8398: A model named "string" already exists
ERROR 8861: Network Addresses "string" and "string" are on the same node. Network Addresses in Load Balance Groups must refer to distinct nodes
ERROR 8951: Fault Group "string" is already in load balance group "string"
ERROR 8967: Network Addresses "string" is already in load balance group "string"
ERROR 8972: Object of type string named "string" already exists
ERROR 9036: A complex type named "string" already exists
ERROR 9037: A field named "string" already exists
ERROR 9121: Subcluster "string" already exists

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