HADR standby encountered disk full error during log replay of a
newly created table space.
This resulted in not having this table space in the SQLSPCS
file. The following error is reported to db2diag.log for the
disk full error:
2020-09-08-10.01.06.124297+000 E38908749E1409 LEVEL:
Error (OS)
PID : 6176 TID : 46912958883584 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
APPHDL : 0-15 APPID: *LOCAL.DB2.200905124323
HOSTNAME:
EDUID : 67 EDUNAME: db2redom 0
FUNCTION: DB2 UDB, oper system services, sqlowrite, probe:70
MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
DIA8312C Disk was full.
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
...
[5] 0x00002AAAB26D95ED sqlowrite + 0x50D
[6] 0x00002AAAACFDF797
_Z18sqlbWritePoolAsBlkR12SQLO_FHANDLES0_tbPcP12SQLB_GLOBALS +
0x137
[7] 0x00002AAAACFE001F
_Z22sqlbWritePoolOnRefreshP12SQLB_POOL_CBtmPcP9sqeBsuEdu + 0x4FF
[8] 0x00002AAAACFC6F66
_Z18sqlbPoolTblNewPooltjjiP9SQLP_LSN8P9sqeBsuEduPP12SQLB_POOL_CB
+ 0x1696
[9] 0x00002AAAAD19963C
/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1 +
0x1F2963C
[10] 0x00002AAAAD1903C9
_Z8sqlbRedoP8sqeAgentP8SQLB_LRHP9SQLP_LSN8b + 0xF09
[11] 0x00002AAAAD47838B
_Z8sqldmrdoP8sqeAgenttP9SQLP_LSN8PcmmmmP8SQLP_TIDP15SQLD_RECOV_I
NFO + 0xB0B
2020-09-08-10.01.06.170466+000 I38920614E582 LEVEL:
Warning
PID : 6176 TID : 46912958883584 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
APPHDL : 0-15 APPID: *LOCAL.DB2.200905124323
HOSTNAME:
EDUID : 67 EDUNAME: db2redom () 0
FUNCTION: DB2 UDB, data management, sqldHandleBadPool, probe:700
DATA #1 : String, 92 bytes
Tablespace 5 was not in the rollforward set.
Request to remove it from the set is ignored.
2020-09-08-10.01.07.382032+000 I38967440E563 LEVEL:
Error
PID : 6176 TID : 46912958883584 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
APPHDL : 0-15 APPID: *LOCAL.DB2.200905124323
HOSTNAME:
EDUID : 67 EDUNAME: db2redom () 0
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePoolCBToSPCS,
probe:400
MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
DIA8312C Disk was full.
This condition did not cause failure of the HADR standby
database. Eventually, after TAKEOVER command this database
becomes the new primary database, the following error will be
reported.
2020-09-21-10.23.13.232783+000 I86952333E1667 LEVEL:
Severe
PID : 10572 TID : 46919208396544 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
APPHDL : 0-120 APPID: *LOCAL.DB2.200921102241
AUTHID : DB2INST1 HOSTNAME:
EDUID : 127 EDUNAME: db2agent () 0
FUNCTION: DB2 UDB, buffer pool services, sqlbIsAllowed,
probe:1064
DATA #1 :
Invalid table space ID 5 |
