473,695 Members | 2,752 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

can someone help me figure out what caused the rollback?

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.0 60403193435
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
1 2147
> Rollback SQL statements: 2
Your program executed 2 EXEC SQL ROLLBACK statements. Check the code.

<bo******@gmail .com> wrote in message
news:11******** **************@ u72g2000cwu.goo glegroups.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.0 60403193435
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
12878
by: tkestell | last post by:
Is their anyway to perform mass deletes (several million records) without "maxing out" rollback segments? I'm working on archiving data from an Oracle 8.1.7 database The system is about 4 years old and no data has EVER been archived /removed. So the two largest tables contain well over 25 million records! As part of the archive process I'm deleting out-dated records, but because of the sheer volume keep receiving "Unable to extend...
2
3726
by: Alice | last post by:
Hi all, Given a rollback segment with storage as follows : Initial Extent 5 MB Next Extent 5 MB Min Extents 20 Does this mean that every time a transaction uses this rollback segment it allocates 100 MB ? Does this mean that if there are two transactions using this rollback
1
6886
by: Bilo Aga | last post by:
The installation of MSDE fails and I dont find any solution to get it work. If I start the setup than a windows with the time bar appears and says it will take 1 minute. After nearly 1 minute it closes the window and gives no additional information. But I see that it generates first all the directories and files in c:\Programme but after the setup is end everything is deleted. Nearly everything , I see a service "MSSQLServerADHelper" is...
0
1894
by: Mark Vuksani | last post by:
Hi, I have a trigger like this (simplified to illustrate the problem): -------- CREATE TRIGGER Test ON . FOR INSERT, UPDATE, DELETE AS RAISERROR( 'test trigger error !', 16, 1)
1
8404
by: efiryago | last post by:
I have about 200 tables in a DB2 V8.1.4 LUW application schema. There is a third party java appllication that accesses this schema. It started failing and relevant entries in db2diag.log have this: COM.ibm.db2.jdbc.DB2Exception: SQL1476N The current transaction was rolled back because of error "-952". SQLSTATE=40506 which caused by SQL1476N The current transaction was rolled back because of
3
1747
by: Guy Penfold | last post by:
Hi all, I have an asp.net application exhibiting rather alarming behaviour. Among other things, the application provides actors with an online profile that allows them to showcase their skills, photographs, experience etc. Basically it is an asp.net front end with SQL Server 2000 as the data store. The problem behaviour occurs when two users are editing the same type of data (and therefore requesting the same aspx page). If they both...
9
7606
by: John Sidney-Woollett | last post by:
Is it possible to use the dblink and dblink_exec features from inside pl/pgsql functions to mimic the behaviour of nested transactions by calling another function or executing some SQL via the dblink (into the same database)? Does the SQL statement executed within the dblink sit in its own isolated transaction/session? And would an error thrown in the dblink statement abort the enclosing session that initiated the call? What is the...
1
5744
by: cheesey_toastie | last post by:
I have a long query which I have set off and would like to stop, and rename one of the tables used. My query is due to my lack of understanding of the underlying structure of MSSQL-Server... So say and update updates TABLE_A and I stop it, whilst this transaction is rolling back I attempt to rename TABLE_A to TABLE_A_OLD and rename a different table to become TABLE_A. I am assuming that the rollback actions will use the object...
1
3149
by: varmamkm | last post by:
I am new to db2 and want to know more about rollback and exception handling.... I am using AS/400 operations navigator to write the stored procedures. I am trying this by using SAVEPOING and ROLLBACK but no luck... please help me out..... Declare exit handler for sqlexception set nerror = sqlcode; insert into empmaster (empname) values('test'); set emp_id = identity_val_local(); savepoint a on rollback retain cursors; insert into...
0
8642
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8583
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9002
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8861
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8833
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7673
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6500
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5841
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4588
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.