on 06-24-2010 10:11 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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
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
> 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
>
> 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
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.