The annoying case of ORA-08177 solved

We had setup a foreign data wrapper from postgres to oracle using the oracle_fdw

But, about 50% of the time it would throw a ORA-08177: can’t serialize access for the transaction

Argh… why is it being so buggy. Well, reading here

If you don’t specify it isolation_level (optional, defaults to serializable)

BUT, Unfortunately Oracle’s implementation of SERIALIZABLE is rather bad and causes serialization errors (ORA-08177) in unexpected situations…

To fix it,

alter server oracle options ( set isolation_level 'read_committed ');

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s