ory/ladon

Error: Transaction has already been committed or rolled back

kminehart opened this issue · 3 comments

Hi there,
We're using CockroachDB (which is wire-compatible with postgres). Whenever we call sqlmanager.Create(...), we get the error:

2017/10/31 15:58:16 sql: Transaction has already been committed or rolled back

It's a bit hard for us to track down. We think the transaction may be failing / rolled back because of the structure of the prepared statements, but we're not totally sure.

I'll try to test it on postgres here in a few hours.

Ah, it seems that CockroachDB does not support ON DELETE CASCADE.

Can you please update to the latest commit? It should then show you the appropriate error, as this was fixed a few days ago.

Closing due to inactivity.