Any idea why I'm getting `DPI Error: DPI-1080: connection was closed by ORA-3156`

kubo / rust-oracle

Oracle driver for Rust

189 stars 44 forks source link

Any idea why I'm getting `DPI Error: DPI-1080: connection was closed by ORA-3156` #65

Closed Niedzwiedzw closed 1 year ago

Niedzwiedzw commented 1 year ago

This happens randomly, I'm not getting it when executing the same queries using say DataGrip

kubo commented 1 year ago

What version of Oracle database client do you use? What version of Oracle database server do you use? What version of rust-oracle do you use?

ORA-3156 is related to OCI_ATTR_CALLTIMEOUT. Did you execute time-consuming queries?

How about call_timeout?

cjbj commented 1 year ago

Also are there any sqlnet.ora files with timeout parameters set?

Niedzwiedzw commented 1 year ago

Thank you for responding, I have simplified my code a bit (removed the r2d2 pool altogether). My use case is that the databases I'm connecting to are on some rural locations, with very bad internet connectivity. Oracle version is also pretty old (~11b I believe). Anyways, this problem no longer occurs, thank you for your answers