PostgreSQL / SQLalchemy returns id of object but it is not persisted

Question

I am using Pyramid, SQLalchemy (with ZopeTransactionExtension), Postgresql and uwsgi and I have a problem with my web app.

So when I save object using DBSession.add(object) and flush DBSession.flush() I get no error and I even get the id of the newly created object, but when the page reloads I see success message but the object does not appear in the list of all objects. (No error was thrown. In PostgreSQL I can see my insert query and even COMMIT right after it)

This can be seen in API. When I create the new object it returns me it's id, 2 seconds later I delete this object and I get the error that object with this id does not exist. The problem occurs randomly (sometimes more often and sometimes less often) only on production/testing environment (not local) and disappears after rebuilding (It comes back after 1-2 days of uptime).

Had someone a similar problem?

For debugging questions it'd be beneficial to include at least some kind of example of what you're doing. — Ilja Everilä, Jul 01 '16 at 08:39

score 0 · Answer 1 · edited May 23 '17 at 12:08

0

Check out this answer. Generally, everything that is flushed will be temporarily stored into the database and will be persisted when a .commit() happens.

edited May 23 '17 at 12:08

Community

1
1

answered Jul 01 '16 at 08:37

alexpeits

847
8
18

PostgreSQL / SQLalchemy returns id of object but it is not persisted

1 Answers1