Hi,
I am using DB - 4.3.28 as TDS in SUSE9.
My configuration parameters are as follows:
env flags = DB_RECOVER |DB_CREATE | DB_INIT_LOCK | DB_INIT_LOG |
DB_INIT_MPOOL | DB_INIT_TXN|DB_THREAD
db flags = DB_CREATE| DB_AUTO_COMMIT|DB_THREAD
I am using db with --enable-diagnostic configured.
Problem:
In one of the test scenarios, 20000 items are added to the DB in a
single transaction. The 20000th operation fails.
txn-abort() is called. This method hangs, CPU usage shoots to 100%.
PID PR NI VIRT RES SHR S %CPU %MEM
25033 18 0 98144 44m 68m R 63.7 1.2 /*Before
txn->abort() */
25033 25 0 98148 44m 68m R 99.9 1.2 /*after
txn->abort() */
After this process hangs. I get following message from kernel
--------------------------------------------------------
Message from syslogd@[EMAIL PROTECTED]
at Thu Jan 11 02:54:17 2007 ...
enip6 kernel: CPU#1: Temperature above threshold
Message from syslogd@[EMAIL PROTECTED]
at Thu Jan 11 02:54:17 2007 ...
enip6 kernel: CPU#1: Running in modulated clock mode
-------------------------------------------------------
What can be the reasong for this? How to solve this.
Please help.
I have provided the db_stat information just before calling and after
calling txn->abort()
1) Before calling txn->abort
<117 seeAtca6 [sijo] :>db_stat -c
4 Last allocated locker ID
0x7fffffff Current maximum unused locker ID
9 Number of lock modes
30000 Maximum number of locks possible
30000 Maximum number of lockers possible
30000 Maximum number of lock objects possible
10124 Number of current locks
10128 Maximum number of locks at any one time
4 Number of current lockers
5 Maximum number of lockers at any one time
6457 Number of current lock objects
6457 Maximum number of lock objects at any one time
689314 Total number of locks requested
517568 Total number of locks released
0 Total number of lock requests failing because DB_LOCK_NOWAIT
was set
0 Total number of locks not immediately available due to
conflicts
0 Number of deadlocks
0 Lock timeout value
0 Number of locks that have timed out
0 Transaction timeout value
0 Number of transactions that have timed out
13MB 368KB The size of the lock region
0 The number of region locks that required waiting (0%)
<118 seeAtca6 [sijo] :>db_stat -e
4.3.28 Environment version
0x120897 Magic number
0 Panic value
2 References
0 The number of region locks that required waiting (0%)
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
0x40988 Log magic number
10 Log version number
10MB Log record cache size
0660 Log file mode
1Mb Current log file size
48MB 912KB 148B Log bytes written
48MB 912KB 148B Log bytes written since last checkpoint
78 Total log file writes
0 Total log file write due to overflow
78 Total log file flushes
49 Current log file number
1038398 Current log file offset
49 On-disk log file number
1038398 On-disk log file offset
1 Maximum commits in a log flush
1 Minimum commits in a log flush
10MB 64KB Log region size
0 The number of region locks that required waiting (0%)
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
4 Last allocated locker ID
0x7fffffff Current maximum unused locker ID
9 Number of lock modes
30000 Maximum number of locks possible
30000 Maximum number of lockers possible
30000 Maximum number of lock objects possible
10124 Number of current locks
10128 Maximum number of locks at any one time
4 Number of current lockers
5 Maximum number of lockers at any one time
6457 Number of current lock objects
6457 Maximum number of lock objects at any one time
689314 Total number of locks requested
517568 Total number of locks released
0 Total number of lock requests failing because DB_LOCK_NOWAIT
was set
0 Total number of locks not immediately available due to
conflicts
0 Number of deadlocks
0 Lock timeout value
0 Number of locks that have timed out
0 Transaction timeout value
0 Number of transactions that have timed out
13MB 368KB The size of the lock region
0 The number of region locks that required waiting (0%)
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
1MB 260KB 48B Total cache size
1 Number of caches
1MB 264KB Pool individual cache size
0 Maximum memory-mapped file size
0 Maximum open file descriptors
0 Maximum sequential buffer writes
0 Sleep after writing maximum sequential buffers
0 Requested pages mapped into the process' address space
680197 Requested pages found in the cache (99%)
2669 Requested pages not found in the cache
6453 Pages created in the cache
2669 Pages read into the cache
8609 Pages written from the cache to the backing file
205 Clean pages forced from the cache
8609 Dirty pages forced from the cache
0 Dirty pages written by trickle-sync thread
308 Current total page count
3 Current clean page count
305 Current dirty page count
131 Number of hash buckets used for page location
691988 Total number of times hash chains searched for a page
7 The longest hash chain searched for a page
2089819 Total number of hash buckets examined for page location
0 The number of hash bucket locks that required waiting (0%)
0 The maximum number of times any hash bucket lock was waited for
0 The number of region locks that required waiting (0%)
9126 The number of page allocations
17647 The number of hash buckets examined during allocations
3 The maximum number of hash buckets examined for an allocation
8814 The number of pages examined during allocations
1 The max number of pages examined for an allocation
Pool File: configserviceDB
4096 Page size
0 Requested pages mapped into the process' address space
680197 Requested pages found in the cache (99%)
2669 Requested pages not found in the cache
6453 Pages created in the cache
2669 Pages read into the cache
8609 Pages written from the cache to the backing file
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
1/47786 File/offset for last checkpoint LSN
Mon Jan 15 20:39:01 2007 Checkpoint timestamp
0x8001387d Last transaction ID allocated
20 Maximum number of active transactions configured
1 Active transactions
2 Maximum active transactions
79997 Number of transactions begun
2 Number of transactions aborted
79994 Number of transactions committed
0 Number of transactions restored
16KB Transaction region size
0 The number of region locks that required waiting (0%)
List of active transactions:
ID: 80000004; begin LSN: file/offset 1/48010
db_stat-E
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Default cache region information:
1MB 260KB 48B Total cache size
1 Number of caches
1MB 264KB Pool individual cache size
0 Maximum memory-mapped file size
0 Maximum open file descriptors
0 Maximum sequential buffer writes
0 Sleep after writing maximum sequential buffers
0 Requested pages mapped into the process' address space
680197 Requested pages found in the cache (99%)
2669 Requested pages not found in the cache
6453 Pages created in the cache
2669 Pages read into the cache
8609 Pages written from the cache to the backing file
205 Clean pages forced from the cache
8609 Dirty pages forced from the cache
0 Dirty pages written by trickle-sync thread
308 Current total page count
3 Current clean page count
305 Current dirty page count
131 Number of hash buckets used for page location
691988 Total number of times hash chains searched for a page
7 The longest hash chain searched for a page
2089819 Total number of hash buckets examined for page location
0 The number of hash bucket locks that required waiting (0%)
0 The maximum number of times any hash bucket lock was waited for
0 The number of region locks that required waiting (0%)
9126 The number of page allocations
17647 The number of hash buckets examined during allocations
3 The maximum number of hash buckets examined for an allocation
8814 The number of pages examined during allocations
1 The max number of pages examined for an allocation
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Pool File: configserviceDB
4096 Page size
0 Requested pages mapped into the process' address space
680197 Requested pages found in the cache (99%)
2669 Requested pages not found in the cache
6453 Pages created in the cache
2669 Pages read into the cache
8609 Pages written from the cache to the backing file
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Mpool REGINFO information:
Mpool Region type
2 Region ID
__db.002 Region name
0x4022d000 Original region address
0x4022d000 Region address
0x4036ef38 Region primary address
0 Region maximum allocation
0 Region allocated
REGION_JOIN_OK Region flags
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
MPOOL structure:
0/0 Maximum checkpoint LSN
131 Hash table entries
26 Hash table last-checked
689319 Hash table LRU count
689319 Put counter
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
DB_MPOOL handle information:
!Set DB_MPOOL handle mutex
1 Underlying cache regions
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
DB_MPOOLFILE structures:
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
MPOOLFILE structures:
File #1: configserviceDB
0 Mutex (0%)
1 Reference count
308 Block count
6458 Last page number
5 Original last page number
0 Maximum page number
0 Type
0 Priority
0 Page's LSN offset
32 Page's clear length
d8 83 2 0 2 21 0 0 2a 9f e7 8e 6b e4 1 0 0 0 0 0 ID
file written Flags
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Cache #1:
BH hash table (131 hash slots)
bucket #: priority, mutex
pageno, file, ref, LSN, mutex, address, priority, flags
2) After calling txn->abort()
<123 seeAtca6 [sijo] :>db_stat -c
4 Last allocated locker ID
0x7fffffff Current maximum unused locker ID
9 Number of lock modes
30000 Maximum number of locks possible
30000 Maximum number of lockers possible
30000 Maximum number of lock objects possible
6457 Number of current locks
10128 Maximum number of locks at any one time
4 Number of current lockers
5 Maximum number of lockers at any one time
6457 Number of current lock objects
6457 Maximum number of lock objects at any one time
689314 Total number of locks requested
557564 Total number of locks released
0 Total number of lock requests failing because DB_LOCK_NOWAIT
was set
0 Total number of locks not immediately available due to
conflicts
0 Number of deadlocks
0 Lock timeout value
0 Number of locks that have timed out
0 Transaction timeout value
0 Number of transactions that have timed out
13MB 368KB The size of the lock region
0 The number of region locks that required waiting (0%)
<124 seeAtca6 [sijo] :>db_stat -e
4.3.28 Environment version
0x120897 Magic number
0 Panic value
3 References
0 The number of region locks that required waiting (0%)
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
0x40988 Log magic number
10 Log version number
10MB Log record cache size
0660 Log file mode
1Mb Current log file size
48MB 912KB 148B Log bytes written
48MB 912KB 148B Log bytes written since last checkpoint
78 Total log file writes
0 Total log file write due to overflow
78 Total log file flushes
49 Current log file number
1038398 Current log file offset
49 On-disk log file number
1038398 On-disk log file offset
1 Maximum commits in a log flush
0 Minimum commits in a log flush
10MB 64KB Log region size
0 The number of region locks that required waiting (0%)
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
4 Last allocated locker ID
0x7fffffff Current maximum unused locker ID
9 Number of lock modes
30000 Maximum number of locks possible
30000 Maximum number of lockers possible
30000 Maximum number of lock objects possible
6457 Number of current locks
10128 Maximum number of locks at any one time
4 Number of current lockers
5 Maximum number of lockers at any one time
6457 Number of current lock objects
6457 Maximum number of lock objects at any one time
689314 Total number of locks requested
557564 Total number of locks released
0 Total number of lock requests failing because DB_LOCK_NOWAIT
was set
0 Total number of locks not immediately available due to
conflicts
0 Number of deadlocks
0 Lock timeout value
0 Number of locks that have timed out
0 Transaction timeout value
0 Number of transactions that have timed out
13MB 368KB The size of the lock region
0 The number of region locks that required waiting (0%)
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
1MB 260KB 48B Total cache size
1 Number of caches
1MB 264KB Pool individual cache size
0 Maximum memory-mapped file size
0 Maximum open file descriptors
0 Maximum sequential buffer writes
0 Sleep after writing maximum sequential buffers
0 Requested pages mapped into the process' address space
682993 Requested pages found in the cache (99%)
2672 Requested pages not found in the cache
6453 Pages created in the cache
2672 Pages read into the cache
8609 Pages written from the cache to the backing file
205 Clean pages forced from the cache
8609 Dirty pages forced from the cache
0 Dirty pages written by trickle-sync thread
184 Current total page count
4294M Current clean page count (4294967172)
308 Current dirty page count
131 Number of hash buckets used for page location
694790 Total number of times hash chains searched for a page
7 The longest hash chain searched for a page
2096255 Total number of hash buckets examined for page location
0 The number of hash bucket locks that required waiting (0%)
0 The maximum number of times any hash bucket lock was waited for
0 The number of region locks that required waiting (0%)
9129 The number of page allocations
17647 The number of hash buckets examined during allocations
3 The maximum number of hash buckets examined for an allocation
8814 The number of pages examined during allocations
1 The max number of pages examined for an allocation
Pool File: configserviceDB
4096 Page size
0 Requested pages mapped into the process' address space
682993 Requested pages found in the cache (99%)
2672 Requested pages not found in the cache
6453 Pages created in the cache
2672 Pages read into the cache
8609 Pages written from the cache to the backing file
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
1/47786 File/offset for last checkpoint LSN
Mon Jan 15 20:39:01 2007 Checkpoint timestamp
0x8001387d Last transaction ID allocated
20 Maximum number of active transactions configured
1 Active transactions
2 Maximum active transactions
79997 Number of transactions begun
2 Number of transactions aborted
79994 Number of transactions committed
0 Number of transactions restored
16KB Transaction region size
0 The number of region locks that required waiting (0%)
List of active transactions:
ID: 80000004; begin LSN: file/offset 1/48010
db_stat -E
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Default cache region information:
1MB 260KB 48B Total cache size
1 Number of caches
1MB 264KB Pool individual cache size
0 Maximum memory-mapped file size
0 Maximum open file descriptors
0 Maximum sequential buffer writes
0 Sleep after writing maximum sequential buffers
0 Requested pages mapped into the process' address space
682993 Requested pages found in the cache (99%)
2672 Requested pages not found in the cache
6453 Pages created in the cache
2672 Pages read into the cache
8609 Pages written from the cache to the backing file
205 Clean pages forced from the cache
8609 Dirty pages forced from the cache
0 Dirty pages written by trickle-sync thread
184 Current total page count
4294M Current clean page count (4294967172)
308 Current dirty page count
131 Number of hash buckets used for page location
694790 Total number of times hash chains searched for a page
7 The longest hash chain searched for a page
2096255 Total number of hash buckets examined for page location
0 The number of hash bucket locks that required waiting (0%)
0 The maximum number of times any hash bucket lock was waited for
0 The number of region locks that required waiting (0%)
9129 The number of page allocations
17647 The number of hash buckets examined during allocations
3 The maximum number of hash buckets examined for an allocation
8814 The number of pages examined during allocations
1 The max number of pages examined for an allocation
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Pool File: configserviceDB
4096 Page size
0 Requested pages mapped into the process' address space
682993 Requested pages found in the cache (99%)
2672 Requested pages not found in the cache
6453 Pages created in the cache
2672 Pages read into the cache
8609 Pages written from the cache to the backing file
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Mpool REGINFO information:
Mpool Region type
2 Region ID
__db.002 Region name
0x4022d000 Original region address
0x4022d000 Region address
0x4036ef38 Region primary address
0 Region maximum allocation
0 Region allocated
REGION_JOIN_OK Region flags
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
MPOOL structure:
0/0 Maximum checkpoint LSN
131 Hash table entries
26 Hash table last-checked
691864 Hash table LRU count
691991 Put counter
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
DB_MPOOL handle information:
!Set DB_MPOOL handle mutex
1 Underlying cache regions
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
DB_MPOOLFILE structures:
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
MPOOLFILE structures:
File #1: configserviceDB
0 Mutex (0%)
1 Reference count
184 Block count
6331 Last page number
5 Original last page number
0 Maximum page number
0 Type
0 Priority
0 Page's LSN offset
32 Page's clear length
d8 83 2 0 2 21 0 0 2a 9f e7 8e 6b e4 1 0 0 0 0 0 ID
file written Flags
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Cache #1:
BH hash table (131 hash slots)
bucket #: priority, mutex
pageno, file, ref, LSN, mutex, address, priority, flags
|
