[BUG]BQ AA Plugin create view with error

[haiyuan-eng-google]

ERROR:google_adk.google.adk.plugins.bigquery_agent_analytics_plugin:Failed to create view v_user_message_received: 409 Already Exists: Table agent-operations-ek-04:logging.v_user_message_received; reason: duplicate, message: Already Exists: Table agent-operations-ek-04:logging.v_user_message_received

Location: us-central1
Job ID: 7904eb94-c4f6-4ea5-95f7-b773bc45b53c
Traceback (most recent call last):
  File "/usr/local/google/home/evekhm/projects/adk/agent-operations/.venv/lib/python3.13/site-packages/google/adk/plugins/bigquery_agent_analytics_plugin.py", line 2205, in _create_analytics_views
    self.client.query(sql).result()
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^
  File "/usr/local/google/home/evekhm/projects/adk/agent-operations/.venv/lib/python3.13/site-packages/google/cloud/bigquery/job/query.py", line 1773, in result
    while not is_job_done():
              ~~~~~~~~~~~^^
  File "/usr/local/google/home/evekhm/projects/adk/agent-operations/.venv/lib/python3.13/site-packages/google/api_core/retry/retry_unary.py", line 294, in retry_wrapped_func
    return retry_target(
        target,
    ...<3 lines>...
        on_error=on_error,
    )
  File "/usr/local/google/home/evekhm/projects/adk/agent-operations/.venv/lib/python3.13/site-packages/google/api_core/retry/retry_unary.py", line 156, in retry_target
    next_sleep = _retry_error_helper(
        exc,
    ...<6 lines>...
        timeout,
    )
  File "/usr/local/google/home/evekhm/projects/adk/agent-operations/.venv/lib/python3.13/site-packages/google/api_core/retry/retry_base.py", line 216, in _retry_error_helper
    raise final_exc from source_exc
  File "/usr/local/google/home/evekhm/projects/adk/agent-operations/.venv/lib/python3.13/site-packages/google/api_core/retry/retry_unary.py", line 147, in retry_target
    result = target()
  File "/usr/local/google/home/evekhm/projects/adk/agent-operations/.venv/lib/python3.13/site-packages/google/cloud/bigquery/job/query.py", line 1722, in is_job_done
    raise job_failed_exception
google.api_core.exceptions.Conflict: 409 Already Exists: Table agent-operations-ek-04:logging.v_user_message_received; reason: duplicate, message: Already Exists: Table agent-operations-ek-04:logging.v_user_message_received

Location: us-central1
Job ID: 7904eb94-c4f6-4ea5-95f7-b773bc45b53c

[haiyuan-eng-google]

This issue is caused by a race condition during application startup. Whenever the plugin initializes, it calls _create_analytics_views(), which attempts to create several views using the CREATE OR REPLACE VIEW statement. While CREATE OR REPLACE is designed to be idempotent when run sequentially, executing it concurrently across multiple application instances—for example, when Cloud Run scales out and starts several containers simultaneously—results in a race condition. If two or more instances execute the CREATE OR REPLACE VIEW BigQuery jobs at the exact same millisecond, both processes see that the view requires replacing. However, when they simultaneously try to finalize the metadata in the BigQuery catalog, one job commits successfully while the others fail with a 409 Already Exists Conflict (or duplicate). Since the get_result() call inside _create_analytics_views is wrapped in a try...except Exception as e, it catches this error and prevents the application from crashing. Unfortunately, it was logging the error entirely at the logger.error level, along with the trace, which was polluting the application logs and making it appear to be a severe issue. The Fix: This 409 Conflict error is entirely harmless and can be safely ignored because it simply implies that another concurrent instance successfully updated the view just as this instance attempted to.