Re: [sqlalchemy] Inexplicable NoResultFound error

2015-09-04 Thread Demitri Muna
Hi, On Sunday, August 30, 2015 at 11:18:49 PM UTC-4, Michael Bayer wrote: > > if it happens every time with that exact same numeric identifier, that's a > clue. If it happens on more than just one particular Postgresql database > server with the same data, that's another clue. > > You'd want t

Re: [sqlalchemy] Inexplicable NoResultFound error

2015-08-30 Thread Mike Bayer
On 8/29/15 7:51 PM, Demitri Muna wrote: Hi Michael, On Friday, August 28, 2015 at 11:54:17 AM UTC-4, Michael Bayer wrote: this log shows clearly that the second query is not returning any rows at the DBAPI driver level - you can see that unlike the first query, there is no "Row"

Re: [sqlalchemy] Inexplicable NoResultFound error

2015-08-29 Thread Demitri Muna
Hi Michael, On Friday, August 28, 2015 at 11:54:17 AM UTC-4, Michael Bayer wrote: > > > this log shows clearly that the second query is not returning any rows at > the DBAPI driver level - you can see that unlike the first query, there is > no "Row" logged. The query you want to run on your d

[sqlalchemy] Inexplicable NoResultFound error

2015-08-29 Thread thatsanicehatyouhave
Hi, I have a script that's basically been running unmodified for years. In it, it performs an SQLAlchemy query that does a simple join between two tables: platePointing = session.query(PlatePointing).join(Plate).filter(Plate.plate_id==plateid).one() Suddenly, I'm getting a "NoResultFound" erro

Re: [sqlalchemy] Inexplicable NoResultFound error

2015-08-28 Thread Mike Bayer
On 8/27/15 4:41 PM, Demitri Muna wrote: Hi, Thanks for the help. 2015-08-27 19:03:18,095 INFO sqlalchemy.engine.base.Engine BEGIN (implicit) 2015-08-27 19:03:18,096 INFO sqlalchemy.engine.base.Engine SELECT platedb.plate_pointing.pk AS platedb_plate_pointing_pk, platedb.plate_pointing.hour

Re: [sqlalchemy] Inexplicable NoResultFound error

2015-08-27 Thread Demitri Muna
Hi, Thanks for the help. On Thursday, August 27, 2015 at 2:23:59 PM UTC-4, Michael Bayer wrote: > > > So, next thing, has anything changed other than database data? versions > of anything? > Really, none that I can think of. It's a production system, so almost no one even has access to change

Re: [sqlalchemy] Inexplicable NoResultFound error

2015-08-27 Thread Mike Bayer
On 8/27/15 2:12 PM, Demitri Muna wrote: On Thursday, August 27, 2015 at 1:36:46 PM UTC-4, Michael Bayer wrote: have you upgraded cx_Oracle to 5.2 lately? An API change was introduced which corresponds to some users reporting this issue. The issue is fixed for SQLAlchemy 1.0.9.

Re: [sqlalchemy] Inexplicable NoResultFound error

2015-08-27 Thread Demitri Muna
On Thursday, August 27, 2015 at 1:36:46 PM UTC-4, Michael Bayer wrote: > > have you upgraded cx_Oracle to 5.2 lately? An API change was introduced > which corresponds to some users reporting this issue. The issue is fixed > for SQLAlchemy 1.0.9. > No, I'm using PostgreSQL v9.3.9. Sorry, I s

Re: [sqlalchemy] Inexplicable NoResultFound error

2015-08-27 Thread Mike Bayer
On 8/27/15 1:05 PM, Demitri Muna wrote: Hi, I have a script that's basically been running unmodified for years. In it, it performs an SQLAlchemy query that does a simple join between two tables: platePointing = session.query(PlatePointing).join(Plate).filter(Plate.plate_id==plateid).one()

[sqlalchemy] Inexplicable NoResultFound error

2015-08-27 Thread Demitri Muna
Hi, I have a script that's basically been running unmodified for years. In it, it performs an SQLAlchemy query that does a simple join between two tables: platePointing = session.query(PlatePointing).join(Plate).filter(Plate.plate_id==plateid).one() Suddenly, I'm getting a "NoResultFound" erro