aiguofer opened a new issue, #2040:
URL: https://github.com/apache/arrow-adbc/issues/2040

   ### What happened?
   
   We have a Python API that uses the ADBC driver to execute queries against 
our Java Arrow Flight SQL server. The Python server uses FastAPI + Strawberry, 
and when we receive a request to execute a query, we spin up a background 
thread to handle the execution against the AFS server. Multiple threads on the 
same pod could be executing queries against the AFS server at any given moment. 
   
   We recently noticed some issues with hanging queries, and when looking at 
our DataDog traces, we notice that there is almost a 30 minute difference 
between the `createPreparedStatement` request and the 
`getFlightInfoPreparedStatement` request.
   
   My initial guess is that this could be related to having multiple requests 
at the same time through the ADBC driver, but I don't have enough context about 
how the bindings between Go and Python work.
   
   Is there anything that jumps out at you? Is there anything we could do to 
help debug this? Here's pictures of the traces:
   
   ![Screenshot 2024-07-25 at 2 53 31 
PM](https://github.com/user-attachments/assets/690bb99e-8a6a-484d-8a68-5b9fbfed1012)
   ![Screenshot 2024-07-25 at 2 53 09 
PM](https://github.com/user-attachments/assets/c8cbb194-8f3d-4c5e-a0f0-84d2d4016f49)
   
   
   ### Stack Trace
   
   _No response_
   
   ### How can we reproduce the bug?
   
   _No response_
   
   ### Environment/Setup
   
   Python 3.12
   ADBC FlightSQL driver 1.0.0
   ADBC driver manager 1.0.0


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscr...@arrow.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org

Reply via email to