Error in event_generator: (builtins.TypeError) 'tuple' object cannot be interpreted as an integer #3296
Description
Hi everyone! I am a newbie to developing agents with the ADK. I am hosting an agent I built on Google Cloud Run. After my last deployment I encountered errors that usage_metadata and citation_metadata columns where missing from events table. I have added them and then I got the error :
Error in event_generator: (builtins.TypeError) 'tuple' object cannot be interpreted as an integer
[SQL: INSERT INTO events (id, app_name, user_id, session_id, invocation_id, author, actions, long_running_tool_ids_json, branch, timestamp, content, grounding_metadata, custom_metadata, usage_metadata, citation_metadata, partial, turn_complete, error_code, error_message, interrupted) VALUES (%(id)s, %(app_name)s, %(user_id)s, %(session_id)s, %(invocation_id)s, %(author)s, %(actions)s, %(long_running_tool_ids_json)s, %(branch)s, %(timestamp)s, %(content)s, %(grounding_metadata)s, %(custom_metadata)s, %(usage_metadata)s, %(citation_metadata)s, %(partial)s, %(turn_complete)s, %(error_code)s, %(error_message)s, %(interrupted)s)]
[parameters: [{'app_name': 'campaign_agent', 'session_id': '*********69747', 'content': {'parts': [{'text': 'hi'}], 'role': 'user'}, 'invocation_i ... (602 characters truncated) ... ne, 'partial': None, 'turn_complete': None, 'long_running_tool_ids_json': None, 'branch': None, 'citation_metadata': None, 'grounding_metadata': None}]]
google-adk version --> 1.17.0
Below is the Traceback :
File "/usr/local/lib/python3.12/site-packages/google/adk/cli/adk_web_server.py", line 1418, in event_generator
async for event in agen:
File "/usr/local/lib/python3.12/site-packages/google/adk/runners.py", line 442, in run_async
async for event in agen:
File "/usr/local/lib/python3.12/site-packages/google/adk/runners.py", line 406, in _run_with_trace
invocation_context = await self._setup_context_for_new_invocation(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/google/adk/runners.py", line 961, in _setup_context_for_new_invocation
await self._handle_new_message(
File "/usr/local/lib/python3.12/site-packages/google/adk/runners.py", line 1162, in _handle_new_message
await self._append_new_message_to_session(
File "/usr/local/lib/python3.12/site-packages/google/adk/runners.py", line 738, in _append_new_message_to_session
await self.session_service.append_event(session=session, event=event)
File "/usr/local/lib/python3.12/site-packages/google/adk/sessions/database_session_service.py", line 681, in append_event
sql_session.commit()
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 2030, in commit
trans.commit(_to_root=True)
File "", line 2, in commit
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/state_changes.py", line 137, in _go
ret_value = fn(self, *arg, **kw)
^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 1311, in commit
self._prepare_impl()
File "", line 2, in _prepare_impl
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/state_changes.py", line 137, in _go
ret_value = fn(self, *arg, **kw)
^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 1286, in _prepare_impl
self.session.flush()
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 4331, in flush
self._flush(objects)
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 4466, in _flush
with util.safe_reraise():
^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/util/langhelpers.py", line 224, in exit
raise exc_value.with_traceback(exc_tb)
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 4427, in _flush
flush_context.execute()
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/unitofwork.py", line 466, in execute
rec.execute(self)
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/unitofwork.py", line 642, in execute
util.preloaded.orm_persistence.save_obj(
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/persistence.py", line 93, in save_obj
_emit_insert_statements(
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/persistence.py", line 1048, in _emit_insert_statements
result = connection.execute(
^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1419, in execute
return meth(
^^^^^
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/sql/elements.py", line 526, in _execute_on_connection
return connection._execute_clauseelement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1641, in _execute_clauseelement
ret = self._execute_context(
^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1821, in _execute_context
self._handle_dbapi_exception(
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1815, in _execute_context
context = constructor(
^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 1527, in _init_compiled
flattened_processorskey
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/sql/type_api.py", line 2102, in process
return fixed_impl_processor(
^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/sql/sqltypes.py", line 918, in process
return DBAPIBinary(value)
^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/pymysql/init.py", line 129, in Binary
return bytes(x)
^^^^^^^^
sqlalchemy.exc.StatementError: (builtins.TypeError) 'tuple' object cannot be interpreted as an integer