[sqlalchemy] instrumenting multiple sqlalchemy engines

[sungwonh]

I have two sqlalchemy engines. One for write operations and one for read only operations.

I am wonder how to instrument two sqlalchemy engines at the same time.

When I called SQLAlchemyInstrumentor().instrument() method for each engine as shown below, spans for the second called engine are not created.

write_engine = create_async_engine("postgresql://write-endpoint")
read_engine = create_async_engine("postgresql://read-endpoint")

SQLAlchemyInstrumentor().instrument(engine=write_engine.sync_engine)
SQLAlchemyInstrumentor().instrument(engine=read_engine.sync_engine)