FAQ about manual operations on log streams

After you execute a manual operation on a log stream, such as ALTER SYSTEM CREATE LS or ALTER SYSTEM MODIFY LS, the system may return an error message. This error message indicates the reason why the operation failed. This topic describes the causes of these errors and their solutions.

Error message 1: The tenant status is not NORMAL. CREATE LS is not allowed

Cause

The tenant status is not NORMAL, so you cannot create a log stream.

Solution

Query the DBA_OB_TENANTS view to confirm the tenant status. If the tenant status is CREATING, wait until the tenant is created before creating a log stream.

Error message 2: The tenant's switchover status is not normal, CREATE LS is not allowed

Cause

The tenant's SWITCHOVER_STATUS is not NORMAL, so you cannot create a log stream.

Error message 3: Unknown tenant 'tenant_name'

Cause

You cannot create or modify a log stream for a tenant that does not exist.

Solution

Verify that the tenant exists.

Error message 4: Access denied

Cause

You cannot specify a tenant name that does not match your own when operating under a user tenant.

Error message 5: Access denied; you need (at least one of) the SUPER or ALTER SYSTEM privilege(s) for this operation

Cause

You cannot create or modify a log stream without the ALTER SYSTEM privilege.

Solution

You can grant the ALTER SYSTEM privilege to the current user using the GRANT statement. For more information about user authorization, see Directly grant privileges (MySQL-compatible mode) and Directly grant privileges (Oracle-compatible mode).

Error message 6: CREATE LS of META or SYS tenant is not supported

Cause

You cannot create a log stream for the system tenant or Meta tenant.

Solution

Create a log stream for a user tenant.

Error message 7: The tenant role is not primary, CREATE LS is not allowed

Cause

You can create a log stream only in the primary tenant.

Solution

Create a log stream in the primary tenant.

Error message 8: The specified unit_group is not active or does not exist, CREATE LS is not allowed

Cause

You cannot create a log stream on a UNIT_GROUP that does not exist or a UNIT_GROUP with UNIT_GROUP_ID of 0.

Solution

Query the DBA_OB_UNITS view to confirm the validity of the specified UNIT_GROUP.

Error message 9: Incorrect arguments to set invalid unit group

Cause

You cannot create a log stream on a UNIT_GROUP with UNIT_GROUP_ID less than 1000.

Solution

Query the DBA_OB_UNITS view to confirm the validity of the specified UNIT_GROUP.

Error message 10: The specified primary_zone is not in the tenant's zone list, CREATE LS is not allowed

Cause

The specified PRIMARY_ZONE is not in the ZONE_LIST of the tenant. You cannot create a log stream. When you create a log stream, you must specify a PRIMARY_ZONE in the ZONE_LIST of the tenant, and you cannot specify multiple PRIMARY_ZONE parameters.

Solution

Query the DBA_OB_TENANTS view to confirm the zones of the tenant based on the tenant's Locality.

Error message 11: The specified LS does not exist, MODIFY LS is not allowed

Cause

The log stream does not exist. Modifying the log stream is not allowed.

Solution

Query the CDB_OB_LS or DBA_OB_LS view to confirm whether the specified log stream exists.

Error message 12: The specified LS's status is not normal, MODIFY LS is not allowed

Cause

The status of the log stream is not NORMAL. Modifying the log stream is not allowed.

Solution

Query the CDB_OB_LS or DBA_OB_LS view to confirm the status of the log stream. If the log stream is in the CREATING state, you can wait for the log stream to be created and then modify it. If the log stream is in any other state, you cannot modify it.

Error message 13: The specified primary_zone is not in the tenant's zone list, MODIFY LS is not allowed

Cause

The PRIMARY_ZONE of the log stream is not in the ZONE_LIST of the tenant. Modifying the log stream is not allowed. When you modify a log stream, the specified PRIMARY_ZONE must be in the ZONE_LIST of the tenant, and you can specify only one PRIMARY_ZONE.

Solution

Query the DBA_OB_TENANTS view to confirm the zones of the tenant based on the tenant's locality.

Error message 14: The specified unit_group is not active or does not exist, MODIFY LS is not allowed

Cause

The specified UNIT_GROUP does not exist or is not in the ACTIVE state. Modifying the log stream is not allowed.

Solution

Query the DBA_OB_UNITS view to confirm whether the specified UNIT_GROUP exists.

Error message 15: The specified LS has balance tasks, MODIFY LS is not allowed

Cause

When you modify the UNIT_GROUP of a primary tenant, the tenant must not be performing load balancing.

Solution

Query the CDB_OB_BALANCE_TASKS or DBA_OB_BALANCE_TASKS view to confirm whether the log stream is performing load balancing. If so, wait for the load balancing task to complete before you modify the log stream.

Error message 16: The tenant status is not NORMAL. CREATE LS is not allowed

Cause

The status of the tenant is not NORMAL. Modifying the log stream is not allowed.

Solution

Query the DBA_OB_TENANTS view to confirm the status of the tenant. If the tenant is in the CREATING state, you can wait for the tenant to be created and then modify the log stream.