Stmt.exeC Env.ociError ORA-03135: connection lost contact\nProcess ID: 61366\nSession ID: 2867 Serial number: 6006

[chakrapani123]

hello,

i am making updates to oracle version 12.2.0.1 & ORA.V4 and using the following code snippet..

func (o *Oracle) UnReserveCdb(cdbname string) (unreserved bool, err error) {

fmt.Println(cdbname)
udb := o.Db
utx, err := udb.Begin()
if err != nil {
fmt.Println("error", err)
}
ures, err := utx.Exec("update testdb.DATABASE_INFO set CDB_CONSUMED = 'YES' , CDB_AVAILABLE = 'NO' where CDB_NAME = :1", cdbname)
if err != nil {
fmt.Println("error in exec: ", err)
utx.Rollback()
return unreserved, err
}
if err := utx.Commit(); err != nil {
fmt.Println("error", err)
}
urowCnt, err := ures.RowsAffected()
if err != nil {
fmt.Println("error", err)
}
fmt.Println("rows changed ", urowCnt)

if urowCnt > 0 {
return true, err
} else {
return false, err
}
}

type Oracle struct {
Driver string
ConnectString string
Db *sql.DB
logger log.Logger
}

func NewOracleConnection(cfg config.Config, log log.Logger) (Connection, error) {
var err error
o := &Oracle{
Driver: cfg.DB.Driver,
ConnectString: cfg.DB.ConnectString,
logger: log,
}
o.Db, err = sql.Open(o.Driver, o.ConnectString)
if err != nil {
log.Log("event", "connecting to database", "err", err.Error())
}
return o, err
}

thanks
Chakri

[tgulacsi]

Just use gopkg.in/goracle.v2, that's maintained!

BTW, you haven't stated what's your problem with the given code...

[chakrapani123]

sorry..might have jumped the gun on this one..when i do an update and commit post update

ures, err := utx.Exec("update testdb.DATABASE_INFO set CDB_CONSUMED = 'YES' , CDB_AVAILABLE = 'NO' where CDB_NAME = :1", cdbname)
if err != nil {
fmt.Println("error in exec: ", err)
utx.Rollback()
return unreserved, err
}
if err := utx.Commit(); err != nil {
fmt.Println("error", err)
}

i get this error

Stmt.exeC Env.ociError ORA-03135: connection lost

select statements work fine its just updates throw this error

thanks
CHakri

[tgulacsi]

Sorry, no idea - this should work.

Can you try gopkg.in/goracle.v2 ?
Just blank import it (import _ "gopkg.in/goracle.v2") instead of gopkg.in/rana/ora.v4 and use

db, err := sql.Open("goracle", "...")
...

and when you run your test, set the "DPI_DEBUG_LEVEL" environment variable to something bigger than 0. This will print a lot of debug information. Then the ODPI-C folks may be able to help.