Re: [sqlalchemy] long transaction after database switched over

Hi Michael, Thanks for your detailed answers. 1, We can see sereral transactions hang in the failover, including: "select 1" "select xxx from instances" even, we see the transaction hang after "update services set " So I am not sure whether the problem is related to the connection

[sqlalchemy] SQLAlchemy leaves MySQL open connections

Hi, We have implemented web applications using Django and SQLAlchemy framework. We have distributed system in the company and some API used frequently. We are facing a problem where MySQL connections reached a maximum limit. In Django applications, we are using SQLAlchemy with *pool engine*

Re: [sqlalchemy] long transaction after database switched over

On Sun, Nov 12, 2017 at 9:44 PM, JinRong Cai wrote: > Hi Michael , > > I am using openstack with postgresql which sqlalchemy and oslo_db module > were used. > And there are some problems after my pg database switched over. > > Here is my switch over process: > 1.

[sqlalchemy] long transaction after database switched over

Hi Michael , I am using openstack with postgresql which sqlalchemy and oslo_db module were used. And there are some problems after my pg database switched over. Here is my switch over process: 1. nova-conductor(python application) is running with DB connection strings point to vip , which is