|
Problem IC63418
|
Status: Closed |
DB2 FAILED TO READ FROM RAW DEVICE BECAUSE MIS-ALIGNED BUFFER ADDRESS WAS PASSED. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
DB2 failed to read from raw device because mis-aligned buffer
address was passed.
One of the possible db2diag.log may looks like:
2009-09-25-13.56.37.106124+060 E465435E1262 LEVEL: Error
(OS)
PID : 30650 TID : 47949363013952PROC :
db2sysc 2
INSTANCE: lntxt010 NODE : 002 DB : ATHENA
APPHDL : 2-237 APPID: *N2.lntxt010.090925125624
AUTHID : YANGRACH
EDUID : 463 EDUNAME: db2agent (ATHENA) 2
FUNCTION: DB2 UDB, oper system services, sqloread, probe:60
MESSAGE : ZRC=0x870F0002=-2029060094=SQLO_BPSE "Debug logic
error detected"
DIA8501C A buffer pool logic error has occurred.
CALLED : OS, -, read OSERR: EINVAL
(22)
DATA #1 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes
File Handle = 131
File System Block Size = 0 bytes
File System Type = UNKNOWN
File Handle Flags :
Require Sector Align = No
DIO/CIO Mode = No
Raw Block Device = No
Reserved Handle = No
Flush On Close = No
Thread-Level Lock = Yes
Write-through Mode = Yes
File Not Tracked = No
DATA #2 : unsigned integer, 8 bytes
1024
DATA #3 : signed integer, 8 bytes
-1
DATA #4 : String, 105 bytes
Search for ossError*Analysis probe point after this log entry
for further
self-diagnosis of this problem.
2009-09-25-13.56.37.107993+060 I466698E1820 LEVEL: Error
(OS)
PID : 30650 TID : 47949363013952PROC :
db2sysc 2
INSTANCE: lntxt010 NODE : 002 DB : ATHENA
APPHDL : 2-237 APPID: *N2.lntxt010.090925125624
AUTHID : YANGRACH
EDUID : 463 EDUNAME: db2agent (ATHENA) 2
FUNCTION: DB2 Common, OSSe, ossErrorIOAnalysis, probe:100
CALLED : OS, -, read OSERR: EINVAL
(22)
DATA #1 : String, 117 bytes
A total of 3 analysis will be performed :
- User info
- Target file info
- I/O attempt
Target file handle = 131
DATA #2 : String, 190 bytes
Real user ID of current process = 86881
Effective user ID of current process = 86881
Real group ID of current process = 6179
Effective group ID of current process = 6179
DATA #3 : String, 257 bytes
Target File Information :
Size = 0
Link = No
Reference path = N/A
Type = 0x2000
Permissions = rw-rw----
UID = 14246
GID = 6179
Last modified time = 1253883369
DATA #4 : String, 33 bytes
I/O attempt not implemented yet.
CALLSTCK:
[0] 0x00002B9C04D0C8C2 pdOSSeLoggingCallback + 0x20C
[1] 0x00002B9C092563EC
/var/ibmdb2/lntxt010/sqllib/lib64/libdb2osse.so.1 + 0x1B23EC
[2] 0x00002B9C092562E3 ossLogSysRC + 0xBF
[3] 0x00002B9C0924B51E
/var/ibmdb2/lntxt010/sqllib/lib64/libdb2osse.so.1 + 0x1A751E
[4] 0x00002B9C0924889D ossErrorAnalysis + 0x2D
[5] 0x00002B9C06626BB9 sqloSystemErrorHandler + 0x6D7
[6] 0x00002B9C0521C0F2 sqloread + 0x458
[7] 0x00002B9C058AA11A
/var/ibmdb2/lntxt010/sqllib/lib64/libdb2e.so.1 + 0x19EE11A
[8] 0x00002B9C04D6E8CF sqlbinit + 0xFCF
[9] 0x00002B9C04E59975
/var/ibmdb2/lntxt010/sqllib/lib64/libdb2e.so.1 + 0xF9D975
2009-09-25-13.56.37.145687+060 I468519E537 LEVEL: Error
PID : 30650 TID : 47949363013952PROC :
db2sysc 2
INSTANCE: lntxt010 NODE : 002 DB : ATHENA
APPHDL : 2-237 APPID: *N2.lntxt010.090925125624
AUTHID : YANGRACH
EDUID : 463 EDUNAME: db2agent (ATHENA) 2
FUNCTION: DB2 UDB, buffer pool services, sqlbinit, probe:570
MESSAGE : ZRC=0x870F0002=-2029060094=SQLO_BPSE "Debug logic
error detected"
DIA8501C A buffer pool logic error has occurred.
Trace may shows:
642389 sqloopenp entry [eduid 3901 eduname db2agent]
642390 | sqloThreadLevelFileLockUnlock entry [eduid 3901
eduname db2agent]
642391 | sqloThreadLevelFileLockUnlock exit
642392 | sqloflock entry [eduid 3901 eduname db2agent]
642393 | sqloflock exit
642394 sqloopenp exit
642395 sqloseek entry [eduid 3901 eduname db2agent]
642396 sqloseek exit
642397 sqloread entry [eduid 3901 eduname db2agent]
642398 | sqloSystemErrorHandler entry [eduid 3901 eduname
db2agent]
642399 sqloread errtrans [probe 60] [ OSERRNO = 22 --> ZRC
= 0x870F0002 = -2029060094 = SQLO_BPSE ] |
| Problem Summary: |
Problem Description:
DB2 FAILED TO READ FROM RAW DEVICE BECAUSE MIS-ALIGNED BUFFER
ADDRESS WAS PASSED.
Problem Summary:
DB2 failed to read from raw device because mis-aligned buffer
address was passed.
One of the possible db2diag.log may looks like:
2009-09-25-13.56.37.106124+060 E465435E1262 LEVEL: Error
(OS)
PID : 30650 TID : 47949363013952PROC :
db2sysc 2
INSTANCE: lntxt010 NODE : 002 DB : ATHENA
APPHDL : 2-237 APPID: *N2.lntxt010.090925125624
AUTHID : YANGRACH
EDUID : 463 EDUNAME: db2agent (ATHENA) 2
FUNCTION: DB2 UDB, oper system services, sqloread, probe:60
MESSAGE : ZRC=0x870F0002=-2029060094=SQLO_BPSE "Debug logic
error detected"
DIA8501C A buffer pool logic error has occurred.
CALLED : OS, -, read OSERR: EINVAL
(22)
DATA #1 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes
File Handle = 131
File System Block Size = 0 bytes
File System Type = UNKNOWN
File Handle Flags :
Require Sector Align = No
DIO/CIO Mode = No
Raw Block Device = No
Reserved Handle = No
Flush On Close = No
Thread-Level Lock = Yes
Write-through Mode = Yes
File Not Tracked = No
DATA #2 : unsigned integer, 8 bytes
1024
DATA #3 : signed integer, 8 bytes
-1
DATA #4 : String, 105 bytes
Search for ossError*Analysis probe point after this log entry
for further
self-diagnosis of this problem.
2009-09-25-13.56.37.107993+060 I466698E1820 LEVEL: Error
(OS)
PID : 30650 TID : 47949363013952PROC :
db2sysc 2
INSTANCE: lntxt010 NODE : 002 DB : ATHENA
APPHDL : 2-237 APPID: *N2.lntxt010.090925125624
AUTHID : YANGRACH
EDUID : 463 EDUNAME: db2agent (ATHENA) 2
FUNCTION: DB2 Common, OSSe, ossErrorIOAnalysis, probe:100
CALLED : OS, -, read OSERR: EINVAL
(22)
DATA #1 : String, 117 bytes
A total of 3 analysis will be performed :
- User info
- Target file info
- I/O attempt
Target file handle = 131
DATA #2 : String, 190 bytes
Real user ID of current process = 86881
Effective user ID of current process = 86881
Real group ID of current process = 6179
Effective group ID of current process = 6179
DATA #3 : String, 257 bytes
Target File Information :
Size = 0
Link = No
Reference path = N/A
Type = 0x2000
Permissions = rw-rw----
UID = 14246
GID = 6179
Last modified time = 1253883369
DATA #4 : String, 33 bytes
I/O attempt not implemented yet.
CALLSTCK:
[0] 0x00002B9C04D0C8C2 pdOSSeLoggingCallback + 0x20C
[1] 0x00002B9C092563EC
/var/ibmdb2/lntxt010/sqllib/lib64/libdb2osse.so.1 + 0x1B23EC
[2] 0x00002B9C092562E3 ossLogSysRC + 0xBF
[3] 0x00002B9C0924B51E
/var/ibmdb2/lntxt010/sqllib/lib64/libdb2osse.so.1 + 0x1A751E
[4] 0x00002B9C0924889D ossErrorAnalysis + 0x2D
[5] 0x00002B9C06626BB9 sqloSystemErrorHandler + 0x6D7
[6] 0x00002B9C0521C0F2 sqloread + 0x458
[7] 0x00002B9C058AA11A
/var/ibmdb2/lntxt010/sqllib/lib64/libdb2e.so.1 + 0x19EE11A
[8] 0x00002B9C04D6E8CF sqlbinit + 0xFCF
[9] 0x00002B9C04E59975
/var/ibmdb2/lntxt010/sqllib/lib64/libdb2e.so.1 + 0xF9D975
2009-09-25-13.56.37.145687+060 I468519E537 LEVEL: Error
PID : 30650 TID : 47949363013952PROC :
db2sysc 2
INSTANCE: lntxt010 NODE : 002 DB : ATHENA
APPHDL : 2-237 APPID: *N2.lntxt010.090925125624
AUTHID : YANGRACH
EDUID : 463 EDUNAME: db2agent (ATHENA) 2
FUNCTION: DB2 UDB, buffer pool services, sqlbinit, probe:570
MESSAGE : ZRC=0x870F0002=-2029060094=SQLO_BPSE "Debug logic
error detected"
DIA8501C A buffer pool logic error has occurred.
Trace may shows:
642389 sqloopenp entry [eduid 3901 eduname db2agent]
642390 | sqloThreadLevelFileLockUnlock entry [eduid 3901
eduname db2agent]
642391 | sqloThreadLevelFileLockUnlock exit
642392 | sqloflock entry [eduid 3901 eduname db2agent]
642393 | sqloflock exit
642394 sqloopenp exit
642395 sqloseek entry [eduid 3901 eduname db2agent]
642396 sqloseek exit
642397 sqloread entry [eduid 3901 eduname db2agent]
642398 | sqloSystemErrorHandler entry [eduid 3901 eduname
db2agent]
642399 sqloread errtrans [probe 60] [ OSERRNO = 22 --> ZRC
= 0x870F0002 = -2029060094 = SQLO_BPSE ] |
| Local Fix: |
n/a |
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem is first fixed in Version 9.7 Fix Pack 1 |
| Workaround |
n/a |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 29.09.2009
21.12.2009
21.12.2009 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
