The problem seems to be independent of context. Happens both when I run
python interactively from the prompt, and from within a Pyramid-based web
app.
I have not tried other connectors or raw DBAPI. Will try that.
On Sat, Jun 13, 2015 at 5:48 AM, Mike Bayer <mike...@zzzcomputing.com>
wrote:
>
>
> On 6/13/15 3:54 AM, Dr. wrote:
>
> I have a very simple table and query. For some reason it hangs after a few
> executions and I have to restart the application.
>
> Code to set it up:
>
> from sqlalchemy import (
> Column,
> Integer,
> String
> )
>
> from sqlalchemy.ext.declarative import declarative_base
> Base = declarative_base()
>
> class User(Base):
> __tablename__ = 'users'
>
> id = Column(Integer, primary_key=True)
> pname = Column(String)
>
>
> from sqlalchemy import create_engine
> engine = create_engine('mysql+mysqlconnector://user:pass@server/database',
> echo=True)
> Base.metadata.bind = engine
> from sqlalchemy.orm import sessionmaker
> Session = sessionmaker(bind=engine)
> session = Session()
>
> The query I run is simply
>
> session.query(User).all()
>
> System:
>
> - Python 3.4.3
> - The database is a remote MySQL Ver 5.5.41-0ubuntu0.14.04.1 running
> on debian-linux-gnu on x86_64
> - MySQL Connector/Python 2.0.3
> - SQLAlchemy package: SQLAlchemy-1.0.5-py3.4.egg-info (I had the same
> problem with a ver < 1.0 so I upgraded but no improvement)
> - The clients are local, whether run on PC or Mac the problem is the
> same
>
> Some observations:
>
> - After I run the query a few times, the program hangs.
>
> in what context? running the whole program from a command line each
> time? Running the query inside of a loop inside of one program ?
> what's important here is how are connection resources being allocated and
> freed?
>
>
>
> - If I uncomment the pname field, however, it seems like it will never
> hang.
>
>
> - If I replace .all() with .first() the program won't hang
> - The general log on the MySQL server shows that the server receives
> the query so the problem is likely on the receiving end of SQLAlchemy
> - The server runs a Wordpress too which continues to function even if
> the SQLAlchemy connection hangs
> - echo True or False makes no difference
>
>
> did you try a different driver like pymysql (much more popular Py3k
> driver) ? Also what happens if you use a raw DBAPI program (e.g. with
> mysqlconnector or pymysql ?) try looking at the database (e.g.
> https://dev.mysql.com/doc/refman/5.0/en/show-engine.html) ?
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to sqlalchemy+unsubscr...@googlegroups.com.
> To post to this group, send email to sqlalchemy@googlegroups.com.
> Visit this group at http://groups.google.com/group/sqlalchemy.
> For more options, visit https://groups.google.com/d/optout.
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
