Menu

#1426 imm: Decrement sqliteTransLock if pbeBeginTrans fails in sqlite3_exec

4.5.2
fixed
None
defect
imm
tools
4.5.2
minor
2015-08-13
2015-07-29
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

    • 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
    
     
  • Neelakanta Reddy

    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.

     
  • Neelakanta Reddy

    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

     
  • Neelakanta Reddy

    • 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
     
  • Neelakanta Reddy

    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

  • Neelakanta Reddy

    • status: review --> fixed
     

Log in to post a comment.