imm: Decrement sqliteTransLock if pbeBeginTrans fails in sqlite3_exec

Brought to you by: anders-w, gary_lee, hansnordeback, jonasarndt, and 3 others

#1426 imm: Decrement sqliteTransLock if pbeBeginTrans fails in sqlite3_exec

Milestone: 4.5.2

Status: fixed

Owner: Neelakanta Reddy

Labels: None

Type: defect

Component: imm

Part: tools

Version: 4.5.2

Priority: minor

Blocker:

Updated: 2015-08-13

Created: 2015-07-29

Creator: Neelakanta Reddy

Private: No

2015-07-16 12:30:22 SystemEvent osafimmpbed SC-2-1 err osafimmpbed: ER SQL statement ('BEGIN EXCLUSIVE TRANSACTION') failed because: disk I/O error

           2015-07-16 12:30:22 SystemEvent osafimmpbed SC-2-1 warning osafimmpbed: WA Sqlite db locked by other thread.

Related

Tickets: ~~#1426~~
Wiki: ChangeLog-4.5.2
Wiki: ChangeLog-4.6.1

Discussion

Neelakanta Reddy - 2015-07-30

summary: imm: decrement the lock when pbeBeginTrans fails --> imm: pbe should exit if pbeBeginTrans fails in sqlite3_exec

Description has changed:

Diff:

--- old +++ new @@ -1,4 +1,3 @@ - 2015-07-16 12:30:22 SystemEvent osafimmpbed SC-2-1 err osafimmpbed: ER SQL statement ('BEGIN EXCLUSIVE TRANSACTION') failed because: disk I/O error
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Neelakanta Reddy - 2015-07-30

In the disk I/O error case the PBE file is not accessible,(because of NFS or other share storage), the PBE should exit in this case and try to regenerate. If the error code is other than SQLITE_OK the PBE must exit.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Neelakanta Reddy - 2015-07-30

There is a chance that NFS may re-attach after few seconds, and transaction is not yet started instead of exit, decrement sqliteTransLock in pbeBeginTrans

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Neelakanta Reddy - 2015-07-30

summary: imm: pbe should exit if pbeBeginTrans fails in sqlite3_exec --> imm: Decrement sqliteTransLock if pbeBeginTrans fails in sqlite3_exec

Description has changed:

Diff:

--- old +++ new @@ -1,4 +1,3 @@ - 2015-07-16 12:30:22 SystemEvent osafimmpbed SC-2-1 err osafimmpbed: ER SQL statement ('BEGIN EXCLUSIVE TRANSACTION') failed because: disk I/O error 2015-07-16 12:30:22 SystemEvent osafimmpbed SC-2-1 warning osafimmpbed: WA Sqlite db locked by other thread.

status: accepted --> review
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Neelakanta Reddy - 2015-08-13

changeset: 6724:f5eec770824f
branch: opensaf-4.5.x
parent: 6718:5ce161f02237
user: Neelakanta Reddy reddy.neelakanta@oracle.com
date: Thu Aug 13 15:22:45 2015 +0530
summary: imm:Decrement sqliteTransLock when BEGIN EXCLUSIVE TRANSACTION fails [#1426]

changeset: 6725:96bb34041e63
branch: opensaf-4.6.x
parent: 6722:5c15253714d4
user: Neelakanta Reddy reddy.neelakanta@oracle.com
date: Thu Aug 13 15:22:45 2015 +0530
summary: imm:Decrement sqliteTransLock when BEGIN EXCLUSIVE TRANSACTION fails [#1426]

changeset: 6726:283591bccb72
tag: tip
parent: 6723:1d19b68b9ea1
user: Neelakanta Reddy reddy.neelakanta@oracle.com
date: Thu Aug 13 15:22:45 2015 +0530
summary: imm:Decrement sqliteTransLock when BEGIN EXCLUSIVE TRANSACTION fails [#1426]

Related

Tickets: ~~#1426~~

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Neelakanta Reddy - 2015-08-13

status: review --> fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.