cancel
Showing results for 
Search instead for 
Did you mean: 

MaxDB Database error signal 11 code 2 (ILL_ILLOPN:illegal operand)

Former Member
0 Kudos

Dear all,

this morning we ran into a database error with our maxdb which caused it to crash. After a manual restart it seems to run fine again. It is the first crash since we started the database about 2 years ago. The applications (perl) connecting against the database have not changed during the last days, so we have no idea what the possible error could be. The MaxDB is running on Solaris 10 Any help is appreciated.

Sebastian

Below is the relevant part from the MaxDB error log

47: 2010-06-24 09:34:06 0 ERR 11330 COREHAND ABORTING due to signal 11

<snip>

185: 2010-06-24 09:34:06 0 ERR 11330 COREHAND dump of siginfo content:

186: 2010-06-24 09:34:06 0 ERR 11330 COREHAND signal 11 (SIGSEGV)

187: 2010-06-24 09:34:06 0 ERR 11330 COREHAND code 2 (ILL_ILLOPN:illegal operand)

188: 2010-06-24 09:34:06 0 ERR 11330 COREHAND errno 0

189: 2010-06-24 09:34:06 0 ERR 11330 COREHAND value(int) 0

190: 2010-06-24 09:34:06 0 ERR 11330 COREHAND value(ptr) @0

191: 2010-06-24 09:34:06 0 ERR 11330 COREHAND pid 17712073

192: 2010-06-24 09:34:06 0 ERR 11330 COREHAND addr @10E43C9

193: 2010-06-24 09:34:06 0 ERR 11599 BTRACE analysing LVCMem_Allocator_001

194: 2010-06-24 09:34:06 0 ERR 11599 BTRACE

195: 2010-06-24 09:34:06 0 ERR 11599 BTRACE no problems detected in LVCMem_Allocator_001

196: 2010-06-24 09:34:09 0 ERR 12006 DBCRASH Kernel exited without core and exit status 0x2f00

197: 2010-06-24 09:34:09 0 ERR 12008 DBCRASH Kernel exited due to reentered signal handler

198: 2010-06-24 09:34:12 ___ Stopping GMT 2010-06-24 07:34:12 7.6.05 Build 009-123-191-997

Edited by: Sebastian2 on Jun 24, 2010 11:12 AM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

gratulations for not having major problems during the last 2 years.

Now you have trouble with a feature named Shared SQL which means that several tasks can share the internal structures prepared for one statement. When trying to store this info for a new command the kernel crashed for some reason.

Therefore it is clear that after a restart everything works fine again as after restart all these internal info is gone and will be prepared anew for the statements sent to the kernel.

As YOUR data does not cause the trouble, YOUR data is fine, not corrupted at all, you have three opportunities:

- hope, that this trouble will not arise again (or not within the next mooooooonths/years)

- switch off this feature named SharedSQL (this is the installation parameter-name, which could be set to NO). If usually only one task does one statement (and not 10 tasks doing the same thing with different data) this switching-off would not matter.

- increase the size of installation parameter SHAREDSQL_COMMANDCACHESIZE, so that being-full-problems of this cache holding the internal structures will not arise within the near future.

Hope this helps,

Elke

Former Member
0 Kudos

Hi,

Currently the SHAREDSQL_COMMANDCACHESIZE is roughly 250MB, so we will just increase. Since we have many similar statements but accessing different parts of the data, I believe that the error in the commandcachesize caused the error.

Have a nice weekend

Sebastian

Answers (2)

Answers (2)

Former Member
0 Kudos

The beginning of the knldiag file. I split it up in several posts so the text doesn't get screwed up again...

3 -


4 2010-06-07 10:42:12 1 12600 VERSION 'Kernel 7.6.05 Build 009-123-191-997'

5 2010-06-07 10:42:12 2 12821 TASKING Thread 2 starting

6 2010-06-07 10:42:12 1 12600 VERSION 'X64/SUX64 7.6.05 Build 009-123-191-997'

7 2010-06-07 10:42:12 1 12769 INFO Starting SERVERDB: 'WOD'

8 2010-06-07 10:42:12 1 12770 INFO SERVERNODE: 'maxdb'

9 2010-06-07 10:42:12 1 12773 INFO Date: 2010-06-07

10 2010-06-07 10:42:12 1 12771 INFO Process ID: 25809

11 2010-06-07 10:42:12 1 12772 INFO Owner: 'sdb'

12 2010-06-07 10:42:12 1 12772 INFO Group: 'sdba'

13 2010-06-07 10:42:12 1 12781 INFO Version: '64BIT Kernel'

14 2010-06-07 10:42:12 1 12781 INFO Version: 'X64/SUX64 7.6.05 Build 009-123-191-997'

15 2010-06-07 10:42:12 1 12781 INFO Version: 'FAST'

16 2010-06-07 10:42:12 1 12806 INFO Machine: 'AMD64 (i86pc)'

17 2010-06-07 10:42:12 1 12775 INFO Processors: 8

18 2010-06-07 10:42:12 1 12780 INFO Current directory: '/data/sdb/wrk/WOD'

19 2010-06-07 10:42:12 1 12780 INFO LD_LIBRARY_PATH: '/opt/sdb/7605/lib/lib64:/opt/sdb/7605/sap'

20 2010-06-07 10:42:12 1 20234 RTE Dump of all kernel parameters start

21 2010-06-07 10:42:12 1 20207 RTE Using mode NORMAL for data volume 1

22 2010-06-07 10:42:12 1 20207 RTE Using mode NORMAL for data volume 2

23 2010-06-07 10:42:12 1 20207 RTE Using mode NORMAL for data volume 3

24 2010-06-07 10:42:12 1 20235 RTE ADMIN=1

25 2010-06-07 10:42:12 1 20235 RTE AKDUMP_ALLOWED=YES

26 2010-06-07 10:42:12 1 20235 RTE ALLOW_MULTIPLE_SERVERTASK_UKTS=NO

27 2010-06-07 10:42:12 1 20235 RTE AUTHENTICATION_ALLOW=

28 2010-06-07 10:42:12 1 20235 RTE AUTHENTICATION_DENY=

29 2010-06-07 10:42:12 1 20235 RTE AUTOSAVE=1

30 2010-06-07 10:42:12 1 20235 RTE AUTO_RECREATE_BAD_INDEXES=NO

31 2010-06-07 10:42:12 1 20235 RTE BACKUPRESULT=1

32 2010-06-07 10:42:12 1 20235 RTE BACKUP_BLOCK_CNT=64

33 2010-06-07 10:42:12 1 20235 RTE BACKUPHISTFILE=dbm.knl

34 2010-06-07 10:42:12 1 20235 RTE BACKUPMED_DEF=dbm.mdf

35 2010-06-07 10:42:12 1 20235 RTE CACHE_IN_SHARED_MEMORY=NO

36 2010-06-07 10:42:12 1 20235 RTE CACHE_SIZE=2500

37 2010-06-07 10:42:12 1 20235 RTE CALLSTACKLEVEL=0

38 2010-06-07 10:42:12 1 20235 RTE CATCACHE_MINSIZE=262144

39 2010-06-07 10:42:12 1 20235 RTE CAT_CACHE_SUPPLY=6464

40 2010-06-07 10:42:12 1 20235 RTE CHECKDATA=1

41 2010-06-07 10:42:12 1 20235 RTE CHECK_BACKUP=NO

42 2010-06-07 10:42:12 1 20235 RTE CHECK_COMMON=0

43 2010-06-07 10:42:12 1 20235 RTE CHECK_CONVERTER=0

44 2010-06-07 10:42:12 1 20235 RTE CHECK_DATACACHE=NO

45 2010-06-07 10:42:12 1 20235 RTE CHECK_DATAINDEX=0

46 2010-06-07 10:42:12 1 20235 RTE CHECK_DATAPAGELOG=0

47 2010-06-07 10:42:12 1 20235 RTE CHECK_FBM=0

48 2010-06-07 10:42:12 1 20235 RTE CHECK_HASHED_RESULTSET=0

49 2010-06-07 10:42:12 1 20235 RTE CHECK_IOMAN=0

50 2010-06-07 10:42:12 1 20235 RTE CHECK_KB_REGIONS=NO

51 2010-06-07 10:42:12 1 20235 RTE CHECK_LOCK_SUPPLY=NO

52 2010-06-07 10:42:12 1 20235 RTE CHECK_LOCK=NO

53 2010-06-07 10:42:12 1 20235 RTE CHECK_LOGHISTORY=0

54 2010-06-07 10:42:12 1 20235 RTE CHECK_LOGPAGE=0

55 2010-06-07 10:42:12 1 20235 RTE CHECK_LOGTRANS=0

56 2010-06-07 10:42:12 1 20235 RTE CHECK_LOGVOLUME=0

57 2010-06-07 10:42:12 1 20235 RTE CHECK_QUERYREWRITE=0

58 2010-06-07 10:42:12 1 20235 RTE CHECK_REGIONS=NO

59 2010-06-07 10:42:12 1 20235 RTE CHECK_SRVTASKS=0

60 2010-06-07 10:42:12 1 20235 RTE CHECK_TABLE_WIDTH=NO

61 2010-06-07 10:42:12 1 20235 RTE CHECK_TASK_SPECIFIC_CATALOGCACHE=NO

62 2010-06-07 10:42:12 1 20235 RTE CHECK_TRANSLIST=NO

63 2010-06-07 10:42:12 1 20235 RTE CHECK_TREE_LOCKS=NO

64 2010-06-07 10:42:12 1 20235 RTE CHECK_TREE=NO

Former Member
0 Kudos

65 2010-06-07 10:42:12 1 20235 RTE CLUSTERCOMPRESSIONFILLTHRESHOLD=10

66 2010-06-07 10:42:12 1 20235 RTE CLUSTERCOMPRESSIONTHRESHOLD=1000

67 2010-06-07 10:42:12 1 20235 RTE CLUSTERED_LOBS=NO

68 2010-06-07 10:42:12 1 20235 RTE CLUSTER_WRITE_THRESHOLD=80

69 2010-06-07 10:42:12 1 20235 RTE COLUMNCOMPRESSION=YES

70 2010-06-07 10:42:12 1 20235 RTE _COMMENT=

71 2010-06-07 10:42:12 1 20235 RTE CONTROLPASSWORD=***

72 2010-06-07 10:42:12 1 20235 RTE CONTROLUSERID=DBM

73 2010-06-07 10:42:12 1 20235 RTE CONVERTER_REGIONS=8

74 2010-06-07 10:42:12 1 20235 RTE DATABASEFULL=1

75 2010-06-07 10:42:12 1 20235 RTE DATACACHE_RGNS=8

76 2010-06-07 10:42:12 1 20235 RTE DATA_IO_BLOCK_COUNT=64

77 2010-06-07 10:42:12 1 20235 RTE DATA_VOLUME_GROUPS=1

78 2010-06-07 10:42:12 1 20235 RTE DATA_VOLUME_MODE_0001=NORMAL

79 2010-06-07 10:42:12 1 20235 RTE DATA_VOLUME_MODE_0002=NORMAL

80 2010-06-07 10:42:12 1 20235 RTE DATA_VOLUME_MODE_0003=NORMAL

81 2010-06-07 10:42:12 1 20235 RTE DATA_VOLUME_NAME_0001=DATA_0001

82 2010-06-07 10:42:12 1 20235 RTE DATA_VOLUME_NAME_0002=DATA_0002

83 2010-06-07 10:42:12 1 20235 RTE DATA_VOLUME_NAME_0003=DATA_0003

84 2010-06-07 10:42:12 1 20235 RTE DATA_VOLUME_SIZE_0001=2097152

85 2010-06-07 10:42:12 1 20235 RTE DATA_VOLUME_SIZE_0002=2097152

86 2010-06-07 10:42:12 1 20235 RTE DATA_VOLUME_SIZE_0003=2097152

87 2010-06-07 10:42:12 1 20235 RTE DATA_VOLUME_TYPE_0001=F

88 2010-06-07 10:42:12 1 20235 RTE DATA_VOLUME_TYPE_0002=F

89 2010-06-07 10:42:12 1 20235 RTE DATA_VOLUME_TYPE_0003=F

90 2010-06-07 10:42:12 1 20235 RTE DATE_TIME_FORMAT=INTERNAL

91 2010-06-07 10:42:12 1 20235 RTE DBFILLINGABOVELIMIT=70L80M85M90H95H96H97H98H99H

92 2010-06-07 10:42:12 1 20235 RTE DBFILLINGBELOWLIMIT=70L80L85L90L95L

93 2010-06-07 10:42:12 1 20235 RTE DDLTRIGGER=YES

94 2010-06-07 10:42:12 1 20235 RTE DEADLOCK_DETECTION=4

95 2010-06-07 10:42:12 1 20235 RTE DEADLOCK_DUMP_FILENAME=

96 2010-06-07 10:42:12 1 20235 RTE DEFAULT_CODE=ASCII

97 2010-06-07 10:42:12 1 20235 RTE DELAYCOMMIT=NO

98 2010-06-07 10:42:12 1 20235 RTE DELAYLOGWRITER=0

99 2010-06-07 10:42:12 1 20235 RTE DIAG_HISTORY_NUM=2

100 2010-06-07 10:42:12 1 20235 RTE DIAG_HISTORY_PATH=/data/sdb/wrk/WOD/DIAGHISTORY

101 2010-06-07 10:42:12 1 20235 RTE DIAGSEM=0

102 2010-06-07 10:42:12 1 20235 RTE DWIO_AREA_FLUSH=50

103 2010-06-07 10:42:12 1 20235 RTE DWIO_AREA_SIZE=50

104 2010-06-07 10:42:12 1 20235 RTE DWLRU_TAIL_FLUSH=25

105 2010-06-07 10:42:12 1 20235 RTE DYNTASK_STACK=NO

106 2010-06-07 10:42:12 1 20235 RTE ENABLE_CHECK_INSTANCE=YES

107 2010-06-07 10:42:12 1 20235 RTE ENABLE_SYSTEM_TRIGGERS=YES

108 2010-06-07 10:42:12 1 20235 RTE ERROR=3

109 2010-06-07 10:42:12 1 20235 RTE _EVENTFILE=knldiag.evt

110 2010-06-07 10:42:12 1 20235 RTE _EVENTSIZE=0

111 2010-06-07 10:42:12 1 20235 RTE EVENT=1

112 2010-06-07 10:42:12 1 20235 RTE EXPAND_COM_TRACE=NO

113 2010-06-07 10:42:12 1 20235 RTE EXTERNAL_DUMP_REQUEST=NO

114 2010-06-07 10:42:12 1 20235 RTE FBM_CLUSTER_MODE=MIXED

115 2010-06-07 10:42:12 1 20235 RTE FBMLOW_IO_RATE=10

116 2010-06-07 10:42:12 1 20235 RTE FBM_VOLUME_BALANCE=10

117 2010-06-07 10:42:12 1 20235 RTE FBM_VOLUME_COMPRESSION=50

118 2010-06-07 10:42:12 1 20235 RTE FILEDIR_SPINLOCKPOOL_SIZE=10

119 2010-06-07 10:42:12 1 20235 RTE FORBID_LOAD_BALANCING=NO

120 2010-06-07 10:42:12 1 20235 RTE FORMATTING_MODE=PARALLEL

121 2010-06-07 10:42:12 1 20235 RTE FORMAT_DATAVOLUME=YES

122 2010-06-07 10:42:12 1 20235 RTE HASHED_RESULTSET_CACHESIZE=262144

123 2010-06-07 10:42:12 1 20235 RTE HASHED_RESULTSET=YES

124 2010-06-07 10:42:12 1 20235 RTE HEAP_CHECK_LEVEL=0

125 2010-06-07 10:42:12 1 20235 RTE HS_STORAGE_DLL=libhsscopy

126 2010-06-07 10:42:12 1 20235 RTE HS_SYNC_INTERVAL=50

127 2010-06-07 10:42:12 1 20235 RTE IDXFILELIST_SIZE=0

Former Member
0 Kudos

128 2010-06-07 10:42:12 1 20235 RTE INDEX_LEAF_CACHING=2

129 2010-06-07 10:42:12 1 20235 RTE INIT_ALLOCATORSIZE=262144

130 2010-06-07 10:42:12 1 20235 RTE INSTANCE_TYPE=OLTP

131 2010-06-07 10:42:12 1 20235 RTE IOPROCSFOR_PRIO=0

132 2010-06-07 10:42:12 1 20235 RTE IOPROCSFOR_READER=0

133 2010-06-07 10:42:12 1 20235 RTE IOPROCSPER_DEV=2

134 2010-06-07 10:42:12 1 20235 RTE IOPROCSSWITCH=2

135 2010-06-07 10:42:12 1 20235 RTE JOIN_MAXTAB_LEVEL4=16

136 2010-06-07 10:42:12 1 20235 RTE JOIN_MAXTAB_LEVEL9=5

137 2010-06-07 10:42:12 1 20235 RTE JOIN_SEARCH_LEVEL=0

138 2010-06-07 10:42:12 1 20235 RTE JOIN_TABLEBUFFER=128

139 2010-06-07 10:42:12 1 20235 RTE _KERNELDIAGFILE=knldiag

140 2010-06-07 10:42:12 1 20235 RTE KERNELDIAGSIZE=800

141 2010-06-07 10:42:12 1 20235 RTE _KERNELDUMPFILE=knldump

142 2010-06-07 10:42:12 1 20235 RTE _KERNELTRACEFILE=knltrace

143 2010-06-07 10:42:12 1 20235 RTE KERNELTRACESIZE=1899

144 2010-06-07 10:42:12 1 20235 RTE KERNELVERSION=KERNEL 7.6.05 BUILD 009-123-191-997

145 2010-06-07 10:42:12 1 20235 RTE LMLOCK_REGIONS=0

146 2010-06-07 10:42:12 1 20235 RTE LMREQUEST_REGIONS=0

147 2010-06-07 10:42:12 1 20235 RTE LMTRANS_REGIONS=0

148 2010-06-07 10:42:12 1 20235 RTE LOAD_BALANCING_CHK=0

149 2010-06-07 10:42:12 1 20235 RTE LOAD_BALANCING_DIF=10

150 2010-06-07 10:42:12 1 20235 RTE LOAD_BALANCING_EQ=5

151 2010-06-07 10:42:12 1 20235 RTE LOCAL_REDO_LOG_BUFFER_SIZE=0

152 2010-06-07 10:42:12 1 20235 RTE LOCKMANAGERENABLED=NO

153 2010-06-07 10:42:12 1 20235 RTE LOCKSUPPLY_BLOCK=100

154 2010-06-07 10:42:12 1 20235 RTE LOGABOVELIMIT=50L75L90M95M96H97H98H99H

155 2010-06-07 10:42:12 1 20235 RTE LOGFULL=1

156 2010-06-07 10:42:12 1 20235 RTE LOGSEGMENTFULL=1

157 2010-06-07 10:42:12 1 20235 RTE LOG_BACKUP_TO_PIPE=NO

158 2010-06-07 10:42:12 1 20235 RTE LOG_IO_BLOCK_COUNT=8

159 2010-06-07 10:42:12 1 20235 RTE LOG_IO_QUEUE=50

160 2010-06-07 10:42:12 1 20235 RTE LOG_MIRRORED=NO

161 2010-06-07 10:42:12 1 20235 RTE LOG_QUEUE_COUNT=0

162 2010-06-07 10:42:12 1 20235 RTE LOG_SEGMENT_SIZE=2133

163 2010-06-07 10:42:12 1 20235 RTE LOG_VOLUME_NAME_001=LOG_0001

164 2010-06-07 10:42:12 1 20235 RTE LOG_VOLUME_SIZE_001=6400

165 2010-06-07 10:42:12 1 20235 RTE LOG_VOLUME_TYPE_001=F

166 2010-06-07 10:42:12 1 20235 RTE LRU_FOR_SCAN=NO

167 2010-06-07 10:42:12 1 20235 RTE MAXBACKUPDEVS=2

168 2010-06-07 10:42:12 1 20235 RTE MAXCPU=1

169 2010-06-07 10:42:12 1 20235 RTE MAXDATAVOLUMES=64

170 2010-06-07 10:42:12 1 20235 RTE _MAXEVENTS=100

171 2010-06-07 10:42:12 1 20235 RTE _MAXEVENTTASKS=2

172 2010-06-07 10:42:12 1 20235 RTE MAXGARBAGECOLL=1

173 2010-06-07 10:42:12 1 20235 RTE MAXLOCKS=8040

174 2010-06-07 10:42:12 1 20235 RTE MAXLOGVOLUMES=2

175 2010-06-07 10:42:12 1 20235 RTE MAXPAGER=64

176 2010-06-07 10:42:12 1 20235 RTE MAXRGN_REQUEST=-1

177 2010-06-07 10:42:12 1 20235 RTE MAXSERVERTASKS=134

178 2010-06-07 10:42:12 1 20235 RTE MAXTASKSTACK=1024

179 2010-06-07 10:42:12 1 20235 RTE _MAXTRANS=804

180 2010-06-07 10:42:12 1 20235 RTE MAXUSERTASKS=100

181 2010-06-07 10:42:12 1 20235 RTE MAXVOLUMES=67

182 2010-06-07 10:42:12 1 20235 RTE MAX_HASHTABLE_MEMORY=5120

183 2010-06-07 10:42:12 1 20235 RTE MAX_LOG_QUEUE_COUNT=0

184 2010-06-07 10:42:12 1 20235 RTE MAXMESSAGE_FILES=0

185 2010-06-07 10:42:12 1 20235 RTE MAX_MESSAGE_LIST_LENGTH=100

186 2010-06-07 10:42:12 1 20235 RTE MAX_RETENTION_TIME=480

187 2010-06-07 10:42:12 1 20235 RTE MAX_SERVERTASK_STACK=500

188 2010-06-07 10:42:12 1 20235 RTE MAX_SINGLE_HASHTABLE_SIZE=512

189 2010-06-07 10:42:12 1 20235 RTE MAX_SPECIALTASK_STACK=500

190 2010-06-07 10:42:12 1 20235 RTE MBLOCKDATA_SIZE=32768

Former Member
0 Kudos

191 2010-06-07 10:42:12 1 20235 RTE MBLOCKQUAL_SIZE=32768

192 2010-06-07 10:42:12 1 20235 RTE MBLOCKSTACK_SIZE=32768

193 2010-06-07 10:42:12 1 20235 RTE MBLOCKSTRAT_SIZE=16384

194 2010-06-07 10:42:12 1 20235 RTE MCOD=NO

195 2010-06-07 10:42:12 1 20235 RTE MEMORY_ALLOCATION_LIMIT=0

196 2010-06-07 10:42:12 1 20235 RTE MINREPLYSIZE=4096

197 2010-06-07 10:42:12 1 20235 RTE MINSERVERTASKS=134

198 2010-06-07 10:42:12 1 20235 RTE MIN_RETENTION_TIME=60

199 2010-06-07 10:42:12 1 20235 RTE MONITOR_READ=2147483647

200 2010-06-07 10:42:12 1 20235 RTE MONITOR_ROWNO=0

201 2010-06-07 10:42:12 1 20235 RTE MONITOR_SELECTIVITY=0

202 2010-06-07 10:42:12 1 20235 RTE MONITOR_TIME=2147483647

203 2010-06-07 10:42:12 1 20235 RTE MPDISP_LOOPS=2

204 2010-06-07 10:42:12 1 20235 RTE MPDISP_PRIO=DEFAULT

205 2010-06-07 10:42:12 1 20235 RTE MPRGN_BUSY_WAIT=DEFAULT

206 2010-06-07 10:42:12 1 20235 RTE MPRGN_DIRTY_READ=DEFAULT

207 2010-06-07 10:42:12 1 20235 RTE MP_RGN_LOOP=-1

208 2010-06-07 10:42:12 1 20235 RTE MPRGN_PRIO=DEFAULT

209 2010-06-07 10:42:12 1 20235 RTE MPRGN_QUEUE=YES

210 2010-06-07 10:42:12 1 20235 RTE NO_SYNC_TO_DISK_WANTED=NO

211 2010-06-07 10:42:12 1 20235 RTE OFFICIAL_NODE=

212 2010-06-07 10:42:12 1 20235 RTE OMS_HEAP_BLOCKSIZE=10000

213 2010-06-07 10:42:12 1 20235 RTE OMS_HEAP_COUNT=1

214 2010-06-07 10:42:12 1 20235 RTE OMS_HEAP_LIMIT=0

215 2010-06-07 10:42:12 1 20235 RTE OMS_HEAP_THRESHOLD=100

216 2010-06-07 10:42:12 1 20235 RTE OMSREGIONS=0

217 2010-06-07 10:42:12 1 20235 RTE OMSRGNS=7

218 2010-06-07 10:42:12 1 20235 RTE OMS_RUN_IN_UDE_SERVER=NO

219 2010-06-07 10:42:12 1 20235 RTE OMS_STREAM_TIMEOUT=30

220 2010-06-07 10:42:12 1 20235 RTE OMS_VERS_THRESHOLD=2097152

221 2010-06-07 10:42:12 1 20235 RTE ONLINE=1

222 2010-06-07 10:42:12 1 20235 RTE OPMSG1=/dev/console

223 2010-06-07 10:42:12 1 20235 RTE OPMSG2=/dev/null

224 2010-06-07 10:42:12 1 20235 RTE OPTIMIZE_AGGREGATION=YES

225 2010-06-07 10:42:12 1 20235 RTE OPTIMIZE_FETCH_REVERSE=YES

226 2010-06-07 10:42:12 1 20235 RTE OPTIMIZE_FIRST_ROWS=YES

227 2010-06-07 10:42:12 1 20235 RTE OPTIMIZE_JOIN_HASHTABLE=YES

228 2010-06-07 10:42:12 1 20235 RTE OPTIMIZE_JOIN_HASH_MINIMAL_RATIO=1

229 2010-06-07 10:42:12 1 20235 RTE OPTIMIZE_JOIN_ONEPHASE=YES

230 2010-06-07 10:42:12 1 20235 RTE OPTIMIZE_JOIN_OPERATOR_SORT=YES

231 2010-06-07 10:42:12 1 20235 RTE OPTIMIZE_JOIN_OUTER=YES

232 2010-06-07 10:42:12 1 20235 RTE OPTIMIZE_JOIN_PARALLEL_MINSIZE=1000000

233 2010-06-07 10:42:12 1 20235 RTE OPTIMIZE_JOIN_PARALLEL_SERVERS=0

234 2010-06-07 10:42:12 1 20235 RTE OPTIMIZE_MIN_MAX=YES

235 2010-06-07 10:42:12 1 20235 RTE OPTIMIZE_OPERATOR_JOIN_COSTFUNC=YES

236 2010-06-07 10:42:12 1 20235 RTE OPTIMIZE_OPERATOR_JOIN=YES

237 2010-06-07 10:42:12 1 20235 RTE OPTIMIZE_QUAL_ON_INDEX=YES

238 2010-06-07 10:42:12 1 20235 RTE OPTIMIZE_QUERYREWRITE=OPERATOR

239 2010-06-07 10:42:12 1 20235 RTE OPTIMIZE_STAR_JOIN=YES

240 2010-06-07 10:42:12 1 20235 RTE OPTIM_CACHE=NO

241 2010-06-07 10:42:12 1 20235 RTE OPTIM_INV_ONLY=YES

242 2010-06-07 10:42:12 1 20235 RTE OPTIM_JOIN_FETCH=0

243 2010-06-07 10:42:12 1 20235 RTE OPTIM_MAX_MERGE=500

244 2010-06-07 10:42:12 1 20235 RTE OUTOFSESSIONS=3

245 2010-06-07 10:42:12 1 20235 RTE PACKETSIZE=131072

246 2010-06-07 10:42:12 1 20235 RTE PAGESIZE=8192

247 2010-06-07 10:42:12 1 20235 RTE PREALLOCATE_IOWORKER=NO

248 2010-06-07 10:42:12 1 20235 RTE PRIOBASE_COM=10

249 2010-06-07 10:42:12 1 20235 RTE PRIOBASE_IOC=80

250 2010-06-07 10:42:12 1 20235 RTE PRIOBASE_RAV=80

251 2010-06-07 10:42:12 1 20235 RTE PRIOBASE_REX=40

252 2010-06-07 10:42:12 1 20235 RTE PRIOBASE_U2U=100

253 2010-06-07 10:42:12 1 20235 RTE PRIOFACTOR=80

Former Member
0 Kudos

254 2010-06-07 10:42:12 1 20235 RTE PROTECT_DATACACHE_MEMORY=NO

255 2010-06-07 10:42:12 1 20235 RTE READAHEADBLOBS=32

256 2010-06-07 10:42:12 1 20235 RTE READAHEAD_TABLE_THRESHOLD=0

257 2010-06-07 10:42:12 1 20235 RTE REQUEST_TIMEOUT=5000

258 2010-06-07 10:42:12 1 20235 RTE RESERVEDSERVERTASKS=69

259 2010-06-07 10:42:12 1 20235 RTE RESTARTTIME=600

260 2010-06-07 10:42:12 1 20235 RTE ROW_LOCKS_PER_TRANSACTION=50

261 2010-06-07 10:42:12 1 20235 RTE ROWRGNS=8

262 2010-06-07 10:42:12 1 20235 RTE _RTEDUMPFILE=rtedump

263 2010-06-07 10:42:12 1 20235 RTE RTE_TEST_REGIONS=0

264 2010-06-07 10:42:12 1 20235 RTE RUNDIRECTORY=/data/sdb/wrk/WOD

265 2010-06-07 10:42:12 1 20235 RTE SEQUENCE_CACHE=1

266 2010-06-07 10:42:12 1 20235 RTE SERVERDBFOR_SAP=YES

267 2010-06-07 10:42:12 1 20235 RTE SESSION_TIMEOUT=900

268 2010-06-07 10:42:12 1 20235 RTE SET_VOLUME_LOCK=YES

269 2010-06-07 10:42:12 1 20235 RTE SHAREDSQL_CLEANUPTHRESHOLD=25

270 2010-06-07 10:42:12 1 20235 RTE SHAREDSQL_COMMANDCACHESIZE=262144

271 2010-06-07 10:42:12 1 20235 RTE SHAREDSQL=YES

272 2010-06-07 10:42:12 1 20235 RTE _SHMKERNEL=16700

273 2010-06-07 10:42:12 1 20235 RTE SHOW_MAX_KB_STACK_USE=NO

274 2010-06-07 10:42:12 1 20235 RTE SHOW_MAX_STACK_USE=NO

275 2010-06-07 10:42:12 1 20235 RTE SIMULATE_VECTORIO=NEVER

276 2010-06-07 10:42:12 1 20235 RTE SPINLOCK_BACKOFF_BASE=1

277 2010-06-07 10:42:12 1 20235 RTE SPINLOCK_BACKOFF_FACTOR=2

278 2010-06-07 10:42:12 1 20235 RTE SPINLOCK_BACKOFF_MAXIMUM=64

279 2010-06-07 10:42:12 1 20235 RTE SPINLOCK_LOOP_COUNT=30000

280 2010-06-07 10:42:12 1 20235 RTE STANDBY=1

281 2010-06-07 10:42:12 1 20235 RTE SUBTREE_LOCKS=NO

282 2010-06-07 10:42:12 1 20235 RTE SUPPRESS_CORE=YES

283 2010-06-07 10:42:12 1 20235 RTE SYMBOL_DEMANGLING=NO

284 2010-06-07 10:42:12 1 20235 RTE SYMBOL_RESOLUTION=YES

285 2010-06-07 10:42:12 1 20235 RTE SYSTEMERROR=3

286 2010-06-07 10:42:12 1 20235 RTE TABRGNS=8

287 2010-06-07 10:42:12 1 20235 RTE TASKCLUSTER01=tw;al;ut;2000sv,100bup;10ev,10gc;

288 2010-06-07 10:42:12 1 20235 RTE TASKCLUSTER02=ti,100dw;30000us;

289 2010-06-07 10:42:12 1 20235 RTE TASKCLUSTER03=compress

290 2010-06-07 10:42:12 1 20235 RTE TIME_MEASUREMENT=NO

291 2010-06-07 10:42:12 1 20235 RTE TRACE_AK=NO

292 2010-06-07 10:42:12 1 20235 RTE TRACE_ALLOCATOR=0

293 2010-06-07 10:42:12 1 20235 RTE TRACE_CATALOG=0

294 2010-06-07 10:42:12 1 20235 RTE TRACE_CLIENTKERNELCOM=0

295 2010-06-07 10:42:12 1 20235 RTE TRACE_COMMON=0

296 2010-06-07 10:42:12 1 20235 RTE TRACE_COMMUNICATION=0

297 2010-06-07 10:42:12 1 20235 RTE TRACE_CONVERTER=0

298 2010-06-07 10:42:12 1 20235 RTE TRACE_DATACACHE=0

299 2010-06-07 10:42:12 1 20235 RTE TRACE_DATACHAIN=0

300 2010-06-07 10:42:12 1 20235 RTE TRACE_DATAINDEX=0

301 2010-06-07 10:42:12 1 20235 RTE TRACE_DATAPAM=0

302 2010-06-07 10:42:12 1 20235 RTE TRACE_DATATREE=0

303 2010-06-07 10:42:12 1 20235 RTE TRACE_DBPROC=0

304 2010-06-07 10:42:12 1 20235 RTE TRACE_DEFAULT=NO

305 2010-06-07 10:42:12 1 20235 RTE TRACE_DELETE=NO

306 2010-06-07 10:42:12 1 20235 RTE TRACE_FBM=0

307 2010-06-07 10:42:12 1 20235 RTE TRACE_FILEDIR=0

308 2010-06-07 10:42:12 1 20235 RTE TRACE_FRAMECTRL=0

309 2010-06-07 10:42:12 1 20235 RTE TRACE_INDEX=NO

310 2010-06-07 10:42:12 1 20235 RTE TRACE_INSERT=NO

311 2010-06-07 10:42:12 1 20235 RTE TRACE_IOMAN=0

312 2010-06-07 10:42:12 1 20235 RTE TRACE_IPC=0

313 2010-06-07 10:42:12 1 20235 RTE TRACE_JOIN=0

314 2010-06-07 10:42:12 1 20235 RTE TRACE_KSQL=0

315 2010-06-07 10:42:12 1 20235 RTE TRACE_LOCKMANAGER=0

316 2010-06-07 10:42:12 1 20235 RTE TRACE_LOCK=NO

Former Member
0 Kudos

317 2010-06-07 10:42:12 1 20235 RTE TRACE_LOGACTION=0

318 2010-06-07 10:42:12 1 20235 RTE TRACE_LOGHISTORY=0

319 2010-06-07 10:42:12 1 20235 RTE TRACE_LOGPAGE=0

320 2010-06-07 10:42:12 1 20235 RTE TRACE_LOGTRANS=0

321 2010-06-07 10:42:12 1 20235 RTE TRACE_LOGVOLUME=0

322 2010-06-07 10:42:12 1 20235 RTE TRACE_LONG=NO

323 2010-06-07 10:42:12 1 20235 RTE TRACE_MEMORY=0

324 2010-06-07 10:42:12 1 20235 RTE TRACE_MESSAGES=0

325 2010-06-07 10:42:12 1 20235 RTE TRACE_OBJECTCONTAINER=0

326 2010-06-07 10:42:12 1 20235 RTE TRACE_OBJECT_ADD=NO

327 2010-06-07 10:42:12 1 20235 RTE TRACE_OBJECT_ALTER=NO

328 2010-06-07 10:42:12 1 20235 RTE TRACE_OBJECT_FREE=NO

329 2010-06-07 10:42:12 1 20235 RTE TRACE_OBJECT_GET=NO

330 2010-06-07 10:42:12 1 20235 RTE TRACE_OBJECT=NO

331 2010-06-07 10:42:12 1 20235 RTE TRACE_OMS_CONTAINERDIR=0

332 2010-06-07 10:42:12 1 20235 RTE TRACE_OMS_CONTEXT=0

333 2010-06-07 10:42:12 1 20235 RTE TRACE_OMS_ERROR=0

334 2010-06-07 10:42:12 1 20235 RTE TRACE_OMS_FLUSHCACHE=0

335 2010-06-07 10:42:12 1 20235 RTE TRACE_OMS_INTERFACE=0

336 2010-06-07 10:42:12 1 20235 RTE TRACE_OMS_KEYRANGE=0

337 2010-06-07 10:42:12 1 20235 RTE TRACE_OMS_KEY=0

338 2010-06-07 10:42:12 1 20235 RTE TRACE_OMS_LOCK=0

339 2010-06-07 10:42:12 1 20235 RTE TRACE_OMS_MEMORY=0

340 2010-06-07 10:42:12 1 20235 RTE TRACE_OMS_NEWOBJ=0

341 2010-06-07 10:42:12 1 20235 RTE TRACE_OMS_SESSION=0

342 2010-06-07 10:42:12 1 20235 RTE TRACE_OMS_STREAM=0

343 2010-06-07 10:42:12 1 20235 RTE TRACE_OMS_VAROBJECT=0

344 2010-06-07 10:42:12 1 20235 RTE TRACE_OMS_VERSION=0

345 2010-06-07 10:42:12 1 20235 RTE TRACE_OPTIMIZE=NO

346 2010-06-07 10:42:12 1 20235 RTE TRACE_ORDER_STANDARD=NO

347 2010-06-07 10:42:12 1 20235 RTE TRACE_ORDER=NO

348 2010-06-07 10:42:12 1 20235 RTE TRACE_PAGER=0

349 2010-06-07 10:42:12 1 20235 RTE TRACE_PAGES_BUP=0

350 2010-06-07 10:42:12 1 20235 RTE TRACE_PAGES_EV=2

351 2010-06-07 10:42:12 1 20235 RTE TRACE_PAGES_GC=20

352 2010-06-07 10:42:12 1 20235 RTE TRACE_PAGES_LW=5

353 2010-06-07 10:42:12 1 20235 RTE TRACE_PAGES_PG=3

354 2010-06-07 10:42:12 1 20235 RTE TRACE_PAGES_SV=5

355 2010-06-07 10:42:12 1 20235 RTE TRACE_PAGES_TI=2

356 2010-06-07 10:42:12 1 20235 RTE TRACE_PAGES_US=10

357 2010-06-07 10:42:12 1 20235 RTE TRACE_PAGES_UT=5

358 2010-06-07 10:42:12 1 20235 RTE TRACE_PAGES=NO

359 2010-06-07 10:42:12 1 20235 RTE TRACE_PRIMARY_TREE=NO

360 2010-06-07 10:42:12 1 20235 RTE TRACE_QUERYREWRITE=0

361 2010-06-07 10:42:12 1 20235 RTE TRACE_RUNTIME=0

362 2010-06-07 10:42:12 1 20235 RTE TRACE_SELECT=NO

363 2010-06-07 10:42:12 1 20235 RTE TRACE_SHAREDSQL=0

364 2010-06-07 10:42:12 1 20235 RTE TRACE_SQLMANAGER=0

365 2010-06-07 10:42:12 1 20235 RTE TRACE_SRVTASKS=0

366 2010-06-07 10:42:12 1 20235 RTE TRACE_STOP_ERRORCODE=0

367 2010-06-07 10:42:12 1 20235 RTE TRACE_SYNCHRONISATION=0

368 2010-06-07 10:42:12 1 20235 RTE TRACE_SYSVIEW=0

369 2010-06-07 10:42:12 1 20235 RTE TRACE_TABLE=0

370 2010-06-07 10:42:12 1 20235 RTE TRACE_TIME=NO

371 2010-06-07 10:42:12 1 20235 RTE TRACE_UPDATE=NO

372 2010-06-07 10:42:12 1 20235 RTE TRACE_VOLUME=0

373 2010-06-07 10:42:12 1 20235 RTE TRANS_HISTORY_SIZE=0

374 2010-06-07 10:42:12 1 20235 RTE TRANSRGNS=8

375 2010-06-07 10:42:12 1 20235 RTE TRANS_THRESHOLD_VALUE=60

376 2010-06-07 10:42:12 1 20235 RTE _UNICODE=YES

377 2010-06-07 10:42:12 1 20235 RTE UPDATESTAT_PARALLEL_SERVERS=0

378 2010-06-07 10:42:12 1 20235 RTE UPDATESTAT_SAMPLE_ALGO=1

379 2010-06-07 10:42:12 1 20235 RTE UPDSTATWANTED=1

Former Member
0 Kudos

380 2010-06-07 10:42:12 1 20235 RTE USED_MAX_LOG_QUEUE_COUNT=1

381 2010-06-07 10:42:12 1 20235 RTE USESELECTFETCH=YES

382 2010-06-07 10:42:12 1 20235 RTE USEUNICODECOLUMNCOMPRESSION=NO

383 2010-06-07 10:42:12 1 20235 RTE USEVARIABLEINPUT=NO

384 2010-06-07 10:42:12 1 20235 RTE USE_COROUTINES=YES

385 2010-06-07 10:42:12 1 20235 RTE USEIOPROCS_ONLY=NO

386 2010-06-07 10:42:12 1 20235 RTE USE_OPEN_DIRECT_FOR_BACKUP=NO

387 2010-06-07 10:42:12 1 20235 RTE USE_OPEN_DIRECT=NO

388 2010-06-07 10:42:12 1 20235 RTE USE_SYSTEM_PAGE_CACHE=YES

389 2010-06-07 10:42:12 1 20235 RTE UTILITYPROTFILE=dbm.utl

390 2010-06-07 10:42:12 1 20235 RTE UTILITY_PROTSIZE=100

391 2010-06-07 10:42:12 1 20235 RTE VOLUMENO_BIT_COUNT=8

392 2010-06-07 10:42:12 1 20235 RTE WORKDATASIZE=8192

393 2010-06-07 10:42:12 1 20235 RTE WORKSTACKSIZE=8192

394 2010-06-07 10:42:12 1 20235 RTE XP_CONVERTER_REGIONS=0

395 2010-06-07 10:42:12 1 20235 RTE XP_DATA_CACHE_RGNS=0

396 2010-06-07 10:42:12 1 20235 RTE XP_MAXPAGER=0

397 2010-06-07 10:42:12 1 20236 RTE Dump of all kernel parameters done

398 2010-06-07 10:42:12 1 WNG 11489 PARAM Open system console '/dev/console' reports (13) Permission denied

399 2010-06-07 10:42:12 1 WNG 11489 PARAM Modify parameter OPMSG1 or enable write access to prevent this message

400 2010-06-07 10:42:12 1 12770 INFO SERVERNODE: 'maxdb'

401 2010-06-07 10:42:12 1 12932 INFO maximum cpu time: unlimited

402 2010-06-07 10:42:12 1 12891 INFO maximum core size: unlimited

403 2010-06-07 10:42:12 1 12892 INFO maximum number of open files: 256

404 2010-06-07 10:42:12 1 12934 INFO maximum file size: unlimited

405 2010-06-07 10:42:12 1 12895 INFO maximum number of threads: -1

406 2010-06-07 10:42:12 1 12935 INFO maximum stack size: 10 MB

407 2010-06-07 10:42:12 1 12893 INFO maximum virtual memory size: unlimited

408 2010-06-07 10:42:12 1 12894 INFO maximum heap size: unlimited

409 2010-06-07 10:42:12 1 12898 ENVIRON Environment dump start

410 2010-06-07 10:42:12 1 12898 ENVIRON DBROOT=/opt/sdb/7605

411 2010-06-07 10:42:12 1 12898 ENVIRON IFS= \n

412 2010-06-07 10:42:12 1 12898 ENVIRON LD_LIBRARY_PATH=/opt/sdb/7605/lib/lib64:/opt/sdb/7605/sap

413 2010-06-07 10:42:12 1 12898 ENVIRON PATH=/opt/sdb/7605/bin:/opt/sdb/programs/bin:/usr/xpg4/bin:/usr/ccs/bin:/usr/bin:/opt/SUNWspro/bin

414 2010-06-07 10:42:12 1 12898 ENVIRON SERVERDB=WOD

415 2010-06-07 10:42:12 1 12898 ENVIRON TMP=/var/tmp

416 2010-06-07 10:42:12 1 12898 ENVIRON TMPDIR=/var/tmp

417 2010-06-07 10:42:12 1 12898 ENVIRON TZ=Europe/Berlin

418 2010-06-07 10:42:12 1 12898 ENVIRON Environment dump completed

419 2010-06-07 10:42:12 1 12883 DBSTATE Core dump suppressed

420 2010-06-07 10:42:12 1 20220 RTE Memory allocation not limited

421 2010-06-07 10:42:12 1 20221 RTE System page cache usage enabled

422 2010-06-07 10:42:12 1 12927 TASKING Using coroutines for tasks

423 2010-06-07 10:42:12 1 12927 TASKING Using ucontext_t for coroutine context

424 2010-06-07 10:42:12 1 12692 TCLUSTER tw;al;ut;2000sv,100bup;10ev,10gc;ti,100dw;30000us;compress

425 2010-06-07 10:42:12 1 12693 TCLUSTER number of 'BUP': 0

426 2010-06-07 10:42:12 1 12693 TCLUSTER number of ' DW': 64

427 2010-06-07 10:42:12 1 12693 TCLUSTER number of ' US': 100

428 2010-06-07 10:42:12 1 12693 TCLUSTER number of ' SV': 134

429 2010-06-07 10:42:12 1 12693 TCLUSTER number of ' EV': 2

430 2010-06-07 10:42:12 1 12693 TCLUSTER number of ' GC': 1

431 2010-06-07 10:42:12 1 12692 TCLUSTER Total Number of UKT 7

432 2010-06-07 10:42:12 1 12692 TCLUSTER Number of UKT with User Tasks 1

433 2010-06-07 10:42:12 1 12698 IPC Common RTE specific IPC key: 0x44010000

434 2010-06-07 10:42:12 1 11536 init_shm attached shared section at 0xFFFFFD7FFE400000

Edited by: Sebastian2 on Jun 25, 2010 10:34 AM

lbreddemann
Active Contributor
0 Kudos

Hi there,

the only thing that pop up for me right now is

> INFO maximum stack size: 10 MB

This should usually be set to unlimited.

Apart from that I've currently no idea what the issue might have been.

But a stack overwrite somewhat seems to fit in here.

regards,

Lars

Former Member
0 Kudos

Thank you for the hint.

Do you know the name of the configuration parameter which contains the maximum stack size...

Sebastian

lbreddemann
Active Contributor
0 Kudos

>

> Thank you for the hint.

> Do you know the name of the configuration parameter which contains the maximum stack size...

>

> Sebastian

This limit is a OS LIMIT for the current user session.

Please talk to your SOLARIS admin on how to set this limitation.

It's not a MaxDB setting.

regards,

Lars

lbreddemann
Active Contributor
0 Kudos

> this morning we ran into a database error with our maxdb which caused it to crash. After a manual restart it seems to run fine again. It is the first crash since we started the database about 2 years ago.

WOW ! 2 years uninterrupted uptime.

Not too bad for a no-cost DBMS, is it?

>The applications (perl) connecting against the database have not changed during the last days, so we have no idea what the possible error could be. The MaxDB is running on Solaris 10 Any help is appreciated.

> Below is the relevant part from the MaxDB error log

>

> 47: 2010-06-24 09:34:06 0 ERR 11330 COREHAND ABORTING due to signal 11

> <snip>

> 185: 2010-06-24 09:34:06 0 ERR 11330 COREHAND dump of siginfo content:

> 186: 2010-06-24 09:34:06 0 ERR 11330 COREHAND signal 11 (SIGSEGV)

> 187: 2010-06-24 09:34:06 0 ERR 11330 COREHAND code 2 (ILL_ILLOPN:illegal operand)

> 188: 2010-06-24 09:34:06 0 ERR 11330 COREHAND errno 0

> 189: 2010-06-24 09:34:06 0 ERR 11330 COREHAND value(int) 0

> 190: 2010-06-24 09:34:06 0 ERR 11330 COREHAND value(ptr) @0

> 191: 2010-06-24 09:34:06 0 ERR 11330 COREHAND pid 17712073

> 192: 2010-06-24 09:34:06 0 ERR 11330 COREHAND addr @10E43C9

> 193: 2010-06-24 09:34:06 0 ERR 11599 BTRACE analysing LVCMem_Allocator_001

Hmm.. no stack back trace?

Had a CORE file been written?

If so, it would be helpful to have the stack back trace extracted from it (thread 17712073 should be the one...).

Could you do that?

regards,

Lars

Former Member
0 Kudos

No I don't have a core file (see last lines of log), but maybe the information I sniped out can help (sorry about the awful format, but when copying the lines from the logfile into the message editor, the linebreak are screwed up...)

2010-06-24 09:34:06 0 ERR 11330 COREHAND ABORTING due to signal 11

2010-06-24 09:34:06 0 ERR 11599 BTRACE -


> Emergency Stack Back Trace <----

2010-06-24 09:34:06 0 ERR 11599 BTRACE (0):0xfbd0a9 [0x200121d2130]

2010-06-24 09:34:06 0 ERR 11599 BTRACE (1):0xfb9a2c [0x200121d2130]

2010-06-24 09:34:06 0 ERR 11599 BTRACE (2):0xfb87a3 [0x200121d25f0]

2010-06-24 09:34:06 0 ERR 11599 BTRACE (3):0x102814f [0x200121d3010]

2010-06-24 09:34:06 0 ERR 11599 BTRACE (4):0x102b2d3 [0x200121d3040]

2010-06-24 09:34:06 0 ERR 11599 BTRACE (5):0x102ab85 [0x200121d3170]

2010-06-24 09:34:06 0 ERR 11599 BTRACE (6):0x103ab58 [0x200121d34e0]

2010-06-24 09:34:06 0 ERR 11599 BTRACE (7):0xad5fd8 [0x200121d3780]

2010-06-24 09:34:06 0 ERR 11599 BTRACE (8):0xad7bbb [0x200121d39f0]

2010-06-24 09:34:06 0 ERR 11599 BTRACE (9):0xadeca6 [0x200121d3a60]

2010-06-24 09:34:06 0 ERR 11599 BTRACE (10):0xadc7f5 [0x200121d3b50]

2010-06-24 09:34:06 0 ERR 11599 BTRACE (11):0x10fd50e [0x200121d5de0]

2010-06-24 09:34:06 0 ERR 11599 BTRACE (12):0x10fdb5f [0x200121d6230]

2010-06-24 09:34:06 0 ERR 11599 BTRACE (13):0x1188d90 [0x200121d7f70]

2010-06-24 09:34:06 0 ERR 11599 BTRACE (14):0x125f553 [0x200121d7f90]

2010-06-24 09:34:06 0 ERR 11599 BTRACE (15):0xfffffd7ffecf0560 [0x200121d7ff0]

2010-06-24 09:34:06 0 ERR 11599 BTRACE (16):0x125f00e [0xfffffd7ffe337f30]

2010-06-24 09:34:06 0 ERR 11599 BTRACE (17):0x11ecf1e [0xfffffd7ffe337f60]

2010-06-24 09:34:06 0 ERR 11599 BTRACE (18):0xfffffd7ffed7704b [0xfffffd7ffe337fc0]

2010-06-24 09:34:06 0 ERR 11599 BTRACE (19):0xfffffd7ffed77280 [0xfffffd7ffe337fe0]

2010-06-24 09:34:06 0 ERR 11599 BTRACE -


> Register Dump <----

2010-06-24 09:34:06 0 ERR 11599 BTRACE -


2010-06-24 09:34:06 0 ERR 11599 BTRACE rax rbx 0x0000000000001925 0x000000000000086e

2010-06-24 09:34:06 0 ERR 11599 BTRACE rcx rdx 0x0000000000000001 0x00000200121d2110

2010-06-24 09:34:06 0 ERR 11599 BTRACE rsi rdi 0x000002001ef2f0e8 0x0000020014928010

2010-06-24 09:34:06 0 ERR 11599 BTRACE rbp rsp 0x00000200121d2130 0x00000200121d1f50

2010-06-24 09:34:06 0 ERR 11599 BTRACE r08 r09 0x00000000010e42c0 0x0000000000001fd8

2010-06-24 09:34:06 0 ERR 11599 BTRACE r10 r11 0x000002001ef2f0e8 0x0000020014928010

2010-06-24 09:34:06 0 ERR 11599 BTRACE r12 r13 0x000000000000086e 0x00000200121d2130

2010-06-24 09:34:06 0 ERR 11599 BTRACE r14 r15 0x0000000000000001 0x00000200121d2110

2010-06-24 09:34:06 0 ERR 11599 BTRACE

2010-06-24 09:34:06 0 ERR 11599 BTRACE rip rflags 0x0000000000fbd0a9 0x0000000000010202

2010-06-24 09:34:06 0 ERR 11599 BTRACE cs fs gs 0x000000000000004b 0x00000000000001bb

0x0000000000000000

2010-06-24 09:34:06 0 ERR 11599 BTRACE -


2010-06-24 09:34:06 0 ERR 11599 BTRACE cw swd 0x137f 0x

2010-06-24 09:34:06 0 ERR 11599 BTRACE fctw __fx_rsvd fop 0x00 0x00 0x

2010-06-24 09:34:06 0 ERR 11599 BTRACE rip rdp 0x0000000000000000 0x0000000000000000]

2010-06-24 09:34:06 0 ERR 11599 BTRACE mxcsr mask 0x000000000000001fa0 0x0000ffff]

2010-06-24 09:34:06 0 ERR 11599 BTRACE st0 [0x0000 0x0000 0x0000 0x0000 - 0x0000]

2010-06-24 09:34:06 0 ERR 11599 BTRACE st1 [0x0000 0x0000 0x0000 0x0000 - 0x0000]

2010-06-24 09:34:06 0 ERR 11599 BTRACE st2 [0x0000 0x0000 0x0000 0x0000 - 0x0000]

2010-06-24 09:34:06 0 ERR 11599 BTRACE st3 [0x0000 0x0000 0x0000 0x0000 - 0x0000]

2010-06-24 09:34:06 0 ERR 11599 BTRACE st4 [0x0000 0x0000 0x0000 0x0000 - 0x0000]

2010-06-24 09:34:06 0 ERR 11599 BTRACE st5 [0x0000 0x0000 0x0000 0x0000 - 0x0000]

2010-06-24 09:34:06 0 ERR 11599 BTRACE st6 [0x0000 0x0000 0x0000 0x0000 - 0x0000]

2010-06-24 09:34:06 0 ERR 11599 BTRACE st7 [0x0000 0x0000 0x0000 0x0000 - 0x0000]

2010-06-24 09:34:06 0 ERR 11599 BTRACE xmm00 [0x00720000 0x00000000 0x00010000 0x00000000]

2010-06-24 09:34:06 0 ERR 11599 BTRACE xmm01 [0x0000000c 0x00000000 0x00000000 0x00000000]

2010-06-24 09:34:06 0 ERR 11599 BTRACE xmm02 [0x00000000 0x00000000 0x00000000 0x00000000]

2010-06-24 09:34:06 0 ERR 11599 BTRACE xmm03 [0x00000000 0x00000000 0x0000000c 0x00000000]

2010-06-24 09:34:06 0 ERR 11599 BTRACE xmm04 [0x0000d903 0x00000000 0x00000001 0x00000001]

2010-06-24 09:34:06 0 ERR 11599 BTRACE xmm05 [0x00000000 0x00000000 0x00000000 0x00000000]

2010-06-24 09:34:06 0 ERR 11599 BTRACE xmm06 [0x00000000 0x40180000 0x00000000 0x00000000]

2010-06-24 09:34:06 0 ERR 11599 BTRACE xmm07 [0x00000000 0x40b7bb00 0x00000000 0x00000000]

2010-06-24 09:34:06 0 ERR 11599 BTRACE xmm08 [0x00000000 0x00000000 0x00000000 0x00000000]

2010-06-24 09:34:06 0 ERR 11599 BTRACE xmm09 [0x00000000 0x00000000 0x00000000 0x00000000]

2010-06-24 09:34:06 0 ERR 11599 BTRACE xmm10 [0x00000000 0x00000000 0x00000000 0x00000000]

2010-06-24 09:34:06 0 ERR 11599 BTRACE xmm11 [0x00000000 0x00000000 0x00000000 0x00000000]

2010-06-24 09:34:06 0 ERR 11599 BTRACE xmm12 [0x00000000 0x00000000 0x00000000 0x00000000]

2010-06-24 09:34:06 0 ERR 11599 BTRACE xmm13 [0x00000000 0x00000000 0x00000000 0x00000000]

2010-06-24 09:34:06 0 ERR 11599 BTRACE xmm14 [0x00000000 0x00000000 0x00000000 0x00000000]

2010-06-24 09:34:06 0 ERR 11599 BTRACE xmm15 [0x00000000 0x00000000 0x00000000 0x00000000]

2010-06-24 09:34:06 0 ERR 11599 BTRACE -


2010-06-24 09:34:06 0 ERR 11599 BTRACE -


> Module List <----

2010-06-24 09:34:06 0 ERR 11599 BTRACE |.text Start |.text End | Module File Name

2010-06-24 09:34:06 0 ERR 11599 BTRACE |0x0000000000400000|0x000000000152d000| kernel

2010-06-24 09:34:06 0 ERR 11599 BTRACE |0xfffffd7ffbc00000|0xfffffd7ffbf2d000| liboms.so

2010-06-24 09:34:06 0 ERR 11599 BTRACE |0xfffffd7ffeca0000|0xfffffd7ffedd9000| libc.so.1

2010-06-24 09:34:06 0 ERR 11599 BTRACE |0xfffffd7ffee00000|0xfffffd7ffef7a000| amd64-boot/libCstd.so.1

2010-06-24 09:34:06 0 ERR 11599 BTRACE |0xfffffd7fff070000|0xfffffd7fff07c000| libmd.so.1

2010-06-24 09:34:06 0 ERR 11599 BTRACE |0xfffffd7fff090000|0xfffffd7fff098000| libaio.so.1

2010-06-24 09:34:06 0 ERR 11599 BTRACE |0xfffffd7fff0b0000|0xfffffd7fff0be000| libCrun.so.1

2010-06-24 09:34:06 0 ERR 11599 BTRACE |0xfffffd7fff0e0000|0xfffffd7fff0e8000| librt.so.1

2010-06-24 09:34:06 0 ERR 11599 BTRACE |0xfffffd7fff100000|0xfffffd7fff1a6000| libnsl.so.1

2010-06-24 09:34:06 0 ERR 11599 BTRACE |0xfffffd7fff1d0000|0xfffffd7fff1df000| libsocket.so.1

2010-06-24 09:34:06 0 ERR 11599 BTRACE |0xfffffd7fff1e0000|0xfffffd7fff1e5000| libthread.so.1

2010-06-24 09:34:06 0 ERR 11599 BTRACE |0xfffffd7fff200000|0xfffffd7fff257000| ../libm.so.2

2010-06-24 09:34:06 0 ERR 11599 BTRACE |0xfffffd7fff270000|0xfffffd7fff2a8000| libcurses.so.1

2010-06-24 09:34:06 0 ERR 11599 BTRACE |0xfffffd7fff2d0000|0xfffffd7fff2ef000| libumem.so.1

2010-06-24 09:34:06 0 ERR 11599 BTRACE |0xfffffd7fff320000|0xfffffd7fff322000| libkstat.so.1

2010-06-24 09:34:06 0 ERR 11599 BTRACE |0xfffffd7fff340000|0xfffffd7fff361000| libdemangle.so.1

2010-06-24 09:34:06 0 ERR 11599 BTRACE |0xfffffd7fff380000|0xfffffd7fff381000| libdl.so.1

2010-06-24 09:34:06 0 ERR 11599 BTRACE |0xfffffd7fff3a0000|0xfffffd7fff3a4000| libpthread.so.1

2010-06-24 09:34:06 0 ERR 11599 BTRACE |0xfffffd7fff3b2000|0xfffffd7fff3eb000| ld.so.1

2010-06-24 09:34:06 0 ERR 11599 BTRACE

2010-06-24 09:34:06 0 ERR 11599 BTRACE -


> Symbolic Stack Back Trace <----

2010-06-24 09:34:06 0 ERR 11599 BTRACE 0: 0x0000000000fbd0a9

__1cWSharedSQdDL_CommandCacheULRUListDetachCommand6MpnXSharedSQdDL_CachedCommand__v_ +0x00

2010-06-24 09:34:06 0 ERR 11599 BTRACE 39

2010-06-24 09:34:06 0 ERR 11599 BTRACE kernel

2010-06-24 09:34:06 0 ERR 11599 BTRACE Frameinfo [0x200121d2130]

2010-06-24 09:34:06 0 ERR 11599 BTRACE 1: 0x0000000000fb9a2c

__1cWSharedSQdDL_CommandCacheOCleanUpCommand6MrnStgg00_TransContext_pnXSharedSQdDL_CachedC

2010-06-24 09:34:06 0 ERR 11599 BTRACE ommand_bI_b_ +0x01ec

2010-06-24 09:34:06 0 ERR 11599 BTRACE kernel

2010-06-24 09:34:06 0 ERR 11599 BTRACE Frameinfo [0x200121d2130]

2010-06-24 09:34:06 0 ERR 11599 BTRACE 2: 0x0000000000fb87a3

__1cWSharedSQdDL_CommandCacheIAllocate6ML_pv_ +0x0743

2010-06-24 09:34:06 0 ERR 11599 BTRACE kernel

2010-06-24 09:34:06 0 ERR 11599 BTRACE Frameinfo [0x200121d25f0]

2010-06-24 09:34:06 0 ERR 11599 BTRACE 3: 0x000000000102814f

__1cOCatalog_ObjectKCreateCopy6MrnWSAPDBMem_IRawAllocator_irI_pv_ +0x007f

2010-06-24 09:34:06 0 ERR 11599 BTRACE kernel

2010-06-24 09:34:06 0 ERR 11599 BTRACE Frameinfo [0x200121d3010]

2010-06-24 09:34:06 0 ERR 11599 BTRACE 4: 0x000000000102b2d3

__1cUCatalog_SessionCachePStorePlanObject6MrnOCatalog_Object_rnWSAPDBMem_IRawAllocator_rnR

2010-06-24 09:34:06 0 ERR 11599 BTRACE

SharedSQdDL_ParseID_pnXSharedSQdDL_PrepareHandle__b_ +0x0063

2010-06-24 09:34:06 0 ERR 11599 BTRACE kernel

2010-06-24 09:34:06 0 ERR 11599 BTRACE Frameinfo [0x200121d3040]

2010-06-24 09:34:06 0 ERR 11599 BTRACE 5: 0x000000000102ab85

__1cUCatalog_SessionCacheJStorePlan6MrnSSharedSQdDL_SQdDLCache_pnXSharedSQdDL_PrepareHandl

2010-06-24 09:34:06 0 ERR 11599 BTRACE e_rnOSQdDLMan_ParseId_b_b_ +0x0205

2010-06-24 09:34:06 0 ERR 11599 BTRACE kernel

2010-06-24 09:34:06 0 ERR 11599 BTRACE Frameinfo [0x200121d3170]

2010-06-24 09:34:06 0 ERR 11599 BTRACE 6: 0x000000000103ab58 a101_StorePlan +0x0128

2010-06-24 09:34:06 0 ERR 11599 BTRACE kernel

2010-06-24 09:34:06 0 ERR 11599 BTRACE Frameinfo [0x200121d34e0]

2010-06-24 09:34:06 0 ERR 11599 BTRACE 7: 0x0000000000ad5fd8 ak92analyze_messagetype +0x1078

2010-06-24 09:34:06 0 ERR 11599 BTRACE kernel

2010-06-24 09:34:06 0 ERR 11599 BTRACE Frameinfo [0x200121d3780]

2010-06-24 09:34:06 0 ERR 11599 BTRACE 8: 0x0000000000ad7bbb a92_mode_analyzer +0x009b

2010-06-24 09:34:06 0 ERR 11599 BTRACE kernel

2010-06-24 09:34:06 0 ERR 11599 BTRACE Frameinfo [0x200121d39f0]

2010-06-24 09:34:06 0 ERR 11599 BTRACE 9: 0x0000000000adeca6 ak93one_command +0x0786

2010-06-24 09:34:06 0 ERR 11599 BTRACE kernel

2010-06-24 09:34:06 0 ERR 11599 BTRACE Frameinfo [0x200121d3a60]

2010-06-24 09:34:06 0 ERR 11599 BTRACE 10: 0x0000000000adc7f5 a93_user_commands +0x07e5

2010-06-24 09:34:06 0 ERR 11599 BTRACE kernel

2010-06-24 09:34:06 0 ERR 11599 BTRACE Frameinfo [0x200121d3b50]

2010-06-24 09:34:06 0 ERR 11599 BTRACE 11: 0x00000000010fd50e

__1cHSQdDLTask6FrnUtak_all_command_glob_rCb_v_ +0x009e

2010-06-24 09:34:06 0 ERR 11599 BTRACE kernel

2010-06-24 09:34:06 0 ERR 11599 BTRACE Frameinfo [0x200121d5de0]

2010-06-24 09:34:06 0 ERR 11599 BTRACE 12: 0x00000000010fdb5f __1cLKernel_Main6FrnNRTETask_ITask__v_

+0x046f

2010-06-24 09:34:06 0 ERR 11599 BTRACE kernel

2010-06-24 09:34:06 0 ERR 11599 BTRACE Frameinfo [0x200121d6230]

2010-06-24 09:34:06 0 ERR 11599 BTRACE 13: 0x0000000001188d90 RTETask_TaskMain +0x0050

2010-06-24 09:34:06 0 ERR 11599 BTRACE kernel

2010-06-24 09:34:06 0 ERR 11599 BTRACE Frameinfo [0x200121d7f70]

2010-06-24 09:34:06 0 ERR 11599 BTRACE 14: 0x000000000125f553 en88_CallCoroutineKernelTaskMain +0x0133

2010-06-24 09:34:06 0 ERR 11599 BTRACE kernel

2010-06-24 09:34:06 0 ERR 11599 BTRACE Frameinfo [0x200121d7f90]

2010-06-24 09:34:06 0 ERR 11599 BTRACE -


> End of Stack Back Trace <----

2010-06-24 09:34:06 0 ERR 11330 COREHAND dump of siginfo content:

2010-06-24 09:34:06 0 ERR 11330 COREHAND signal 11 (SIGSEGV)

2010-06-24 09:34:06 0 ERR 11330 COREHAND code 2 (ILL_ILLOPN:illegal operand)

2010-06-24 09:34:06 0 ERR 11330 COREHAND errno 0

2010-06-24 09:34:06 0 ERR 11330 COREHAND value(int) 0

2010-06-24 09:34:06 0 ERR 11330 COREHAND value(ptr) @0

2010-06-24 09:34:06 0 ERR 11330 COREHAND pid 17712073

2010-06-24 09:34:06 0 ERR 11330 COREHAND addr @10E43C9

2010-06-24 09:34:06 0 ERR 11599 BTRACE analysing LVCMem_Allocator_001

2010-06-24 09:34:06 0 ERR 11599 BTRACE

2010-06-24 09:34:06 0 ERR 11599 BTRACE no problems detected in LVCMem_Allocator_001

2010-06-24 09:34:09 0 ERR 12006 DBCRASH Kernel exited without core and exit status 0x2f00

2010-06-24 09:34:09 0 ERR 12008 DBCRASH Kernel exited due to reentered signal handler

Edited by: Sebastian2 on Jun 24, 2010 4:21 PM

Edited by: Sebastian2 on Jun 24, 2010 4:22 PM:

Edited by: Sebastian2 on Jun 24, 2010 4:24 PM

lbreddemann
Active Contributor
0 Kudos

Ok, with some reformatting, the stack back trace looks like this:


 0: __1cWSharedSQdDL_CommandCacheULRUListDetachCommand6MpnXSharedSQdDL_CachedCommand__v_ +0x0039
 1: __1cWSharedSQdDL_CommandCacheOCleanUpCommand6MrnStgg00_TransContext_pnXSharedSQdDL_CachedCommand_bI_b_ +0x01ec
 2: __1cWSharedSQdDL_CommandCacheIAllocate6ML_pv_ +0x0743
 3: __1cOCatalog_ObjectKCreateCopy6MrnWSAPDBMem_IRawAllocator_irI_pv_ +0x007f
 4: __1cUCatalog_SessionCachePStorePlanObject6MrnOCatalog_Object_rnWSAPDBMem_IRawAllocator_rnRSharedSQdDL_ParseID_pnXSharedSQdDL_PrepareHandle__b_ +0x0063
 5: __1cUCatalog_SessionCacheJStorePlan6MrnSSharedSQdDL_SQdDLCache_pnXSharedSQdDL_PrepareHandle_rnOSQdDLMan_ParseId_b_b_ +0x0205
 6: a101_StorePlan +0x0128
 7: ak92analyze_messagetype +0x1078
 8: a92_mode_analyzer +0x009b
 9: ak93one_command +0x0786
10: a93_user_commands +0x07e5
11: __1cHSQdDLTask6FrnUtak_all_command_glob_rCb_v_ +0x009e
12: __1cLKernel_Main6FrnNRTETask_ITask__v_ +0x046f
13: RTETask_TaskMain +0x0050
14: en88_CallCoroutineKernelTaskMain +0x0133
---- Symbolic Stack Back Trace <----

So, without looking into the source code I would assume that there was some garbage in the session specific catalog cache memory management.

Would you mind to post the parameters used by this instance?

regards,

Lars

Former Member
0 Kudos

Thank you again for your time and the immidiate answer.

I don't really understand which information you need.

Is it the parameters we use to connect to the DB or is it some settings in the DB itself. We connect via perl-scripts to the DB (which only as few tables but large tables - in total about 6 GB of data).

BTW: The database wasn't online for 2 years in a row, but only shut down for short times for maintenance etc...)

All the best

Sebastian

lbreddemann
Active Contributor
0 Kudos

>

> Thank you again for your time and the immidiate answer.

You're welcome

> I don't really understand which information you need.

> Is it the parameters we use to connect to the DB or is it some settings in the DB itself. We connect via perl-scripts to the DB (which only as few tables but large tables - in total about 6 GB of data).

The database instance parameters.

run


dbmcli -d <sid> -u <dbm operator>,<pw> param_directgetall

and post the result or copy/paste the startup section of the KNLDIAG file.

regards,

Lars