By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,925 Members | 1,778 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,925 IT Pros & Developers. It's quick & easy.

can someone help me figure out what caused the rollback?

P: n/a
I am testing a database application. It works fine when only one user
uses the application, however, when there are concurrent users, I saw
rollbacks in event log.

Can experts in this group tell me what is going on?

Thanks,

jz

================================================== ==========

17081) Connection Event
Appl Handle: 1723
Appl Id: *LOCAL.ssmm22.060403193435
Appl Seq number: 0005

Record is the result of a flush: FALSE

Application Status: SQLM_UOWWAIT

Lock Statistics:
Lock Waits: 0
Total time waited on locks (milliseconds): 0
Deadlocks: 0
Lock escalations: 0
X lock escalations: 0
Lock timeouts: 0

Sort Statistics:
Sorts: 0
Total sort time (milliseconds): 0
Sort overflows: 0

Hash Statistics:
Hash Joins: 0
Hash Loops: 0
Hash Join Small Overflows: 0
Hash Join Overflows: 0

Buffer Pool Statistics:
Buffer pool logical data page reads: 0
Buffer pool physical data page reads: 0
Buffer pool data page writes: 0
Buffer pool logical index page reads: 0
Buffer pool physical index page reads: 0
Buffer pool index page writes: 0
Buffer pool read time (milliseconds): 0
Buffer pool write time (milliseconds): 0
Time spent waiting for a prefetch: 0 milliseconds
Unread prefetch pages: 0

Workspace Statistics:
Shared workspace high water mark: 0
Total shared workspace overflows: 0
Total shared workspace section lookups: 0
Total shared workspace section inserts: 0
Private workspace high water mark: 0
Total private workspace overflows: 0
Total private workspace section lookups: 0
Total private workspace section inserts: 0

Direct I/O Statistics:
Sectors read directly: 0
Sectors written directly: 0
Direct read requests: 0
Direct write requests: 0
Direct read time: 0
Direct write time: 0

SQL Statement counts
Commit SQL statements: 1
Rollback SQL statements: 2
Dynamic SQL statements: 1
Static SQL stmts: 3
Failed SQL statements: 0
Select SQL statements: 0
Data Definition Language SQL statements: 0
Update/Insert/Delete SQL statements: 0

Internal counts
Internal auto rebinds: 0
Internal rows deleted: 0
Internal rows updated: 0
Internal rows inserted: 0
Internal commits: 1
Internal rollbacks: 0
Internal rollbacks due to deadlock: 0

Row counts
Rows deleted: 0
Rows inserted: 0
Rows updated: 0
Rows selected: 0
Rows read: 0
Rows written: 0
Binds/Precompiles: 0
Rejected block cursor requests: 0
Accepted block cursor requests: 0

Package Cache Statistics
Package Cache Lookups: 1
Package Cache Inserts: 0
Section Lookups: 1
Section Inserts: 0

Catalog Cache Statistics
Catalog Cache Overflows: 0
Catalog Cache High Water Mark: 0
Catalog Cache Lookups: 3
Catalog Cache Inserts: 0

CPU times
User CPU time: 0.002388 seconds
System CPU time: 0.000058 seconds

Memory usage:

Memory Pool Type: Application Heap
Current size (bytes): 147456
High water mark (bytes): 147456
Configured size (bytes): 4423680

Disconnection Time: 04/05/2006 17:17:24.962793

Apr 10 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
> Rollback SQL statements: 2
Your program executed 2 EXEC SQL ROLLBACK statements. Check the code.

<bo******@gmail.com> wrote in message
news:11**********************@u72g2000cwu.googlegr oups.com...
I am testing a database application. It works fine when only one user
uses the application, however, when there are concurrent users, I saw
rollbacks in event log.

Can experts in this group tell me what is going on?

Thanks,

jz

================================================== ==========

17081) Connection Event
Appl Handle: 1723
Appl Id: *LOCAL.ssmm22.060403193435
Appl Seq number: 0005

Record is the result of a flush: FALSE

Application Status: SQLM_UOWWAIT

Lock Statistics:
Lock Waits: 0
Total time waited on locks (milliseconds): 0
Deadlocks: 0
Lock escalations: 0
X lock escalations: 0
Lock timeouts: 0

Sort Statistics:
Sorts: 0
Total sort time (milliseconds): 0
Sort overflows: 0

Hash Statistics:
Hash Joins: 0
Hash Loops: 0
Hash Join Small Overflows: 0
Hash Join Overflows: 0

Buffer Pool Statistics:
Buffer pool logical data page reads: 0
Buffer pool physical data page reads: 0
Buffer pool data page writes: 0
Buffer pool logical index page reads: 0
Buffer pool physical index page reads: 0
Buffer pool index page writes: 0
Buffer pool read time (milliseconds): 0
Buffer pool write time (milliseconds): 0
Time spent waiting for a prefetch: 0 milliseconds
Unread prefetch pages: 0

Workspace Statistics:
Shared workspace high water mark: 0
Total shared workspace overflows: 0
Total shared workspace section lookups: 0
Total shared workspace section inserts: 0
Private workspace high water mark: 0
Total private workspace overflows: 0
Total private workspace section lookups: 0
Total private workspace section inserts: 0

Direct I/O Statistics:
Sectors read directly: 0
Sectors written directly: 0
Direct read requests: 0
Direct write requests: 0
Direct read time: 0
Direct write time: 0

SQL Statement counts
Commit SQL statements: 1
Rollback SQL statements: 2
Dynamic SQL statements: 1
Static SQL stmts: 3
Failed SQL statements: 0
Select SQL statements: 0
Data Definition Language SQL statements: 0
Update/Insert/Delete SQL statements: 0

Internal counts
Internal auto rebinds: 0
Internal rows deleted: 0
Internal rows updated: 0
Internal rows inserted: 0
Internal commits: 1
Internal rollbacks: 0
Internal rollbacks due to deadlock: 0

Row counts
Rows deleted: 0
Rows inserted: 0
Rows updated: 0
Rows selected: 0
Rows read: 0
Rows written: 0
Binds/Precompiles: 0
Rejected block cursor requests: 0
Accepted block cursor requests: 0

Package Cache Statistics
Package Cache Lookups: 1
Package Cache Inserts: 0
Section Lookups: 1
Section Inserts: 0

Catalog Cache Statistics
Catalog Cache Overflows: 0
Catalog Cache High Water Mark: 0
Catalog Cache Lookups: 3
Catalog Cache Inserts: 0

CPU times
User CPU time: 0.002388 seconds
System CPU time: 0.000058 seconds

Memory usage:

Memory Pool Type: Application Heap
Current size (bytes): 147456
High water mark (bytes): 147456
Configured size (bytes): 4423680

Disconnection Time: 04/05/2006 17:17:24.962793

Apr 11 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.