Test oracle 19c TAC got error ORA-25412: transaction replay disabled by call to OCITransStart

[fhitom]

To verify the TAC(Transparent Application Continuity), I wrote a process that acquires the transaction, executes insert, waits 5 seconds, and commit repeatedly.
At this time, when I kill the session, ORA-25412: transaction replay disabled by call to OCITransStart occurs.
If TAC is installed, I think it will be replayed automatically, but how can I solve this problem?

I wrote like this:

....
for i := 1; i < 20; i++ {
    tx, err := db.BeginTx(ctx, nil)
    if err != nil {
        ....
    }
    defer func() {
        if err != nil {
            tx.Rollback()
            return
        }
    }()
    insertSql := "insert into test_table (id, text) values (" + strconv.Itoa(i) + ", 'text') "
    _, err = tx.ExecContext(ctx, insertSql)
    if err != nil {
        ...
    }
    // 5s sleep
    time.Sleep(time.Second * 5)

    // commit
    if err = tx.Commit(); err != nil {
        fmt.Println("Commit error:", err)
        return
    }
}
...

And I kill the session at Oracle as

alter system kill session '111, 11111, @1' immediate;

I got error as

Commit error: ORA-25412: transaction replay disabled by call to OCITransStart

[mattn]

for i := 1; i < 20; i++ {
    tx, err := db.BeginTx(ctx, nil)
    if err != nil {
        ....
    }
    defer func() {
        if err != nil {
            tx.Rollback()
            return
        }
    }()

Is this your expected? This defer will not called for each loops.

[fhitom]

@mattn
Thank you for your reply.
Sorry but I made a mistake.
I changed as

for i := 1; i < 20; i++ {
    tx, err := db.BeginTx(ctx, nil)
    if err != nil {
        ....
    }

    insertSql := "insert into test_table (id, text) values (" + strconv.Itoa(i) + ", 'text') "
    _, err = tx.ExecContext(ctx, insertSql)
    if err != nil {
        if err = tx.Rollback(); err != nil {
            return
        }
        return
    }

    // 5s sleep
    time.Sleep(time.Second * 5)

    // commit
    if err = tx.Commit(); err != nil {
        fmt.Println("Commit error:", err)
        return
    }
}

But the error remain the same.

Commit error: ORA-25412: transaction replay disabled by call to OCITransStart