on 09-29-2008 10:23 AM
Hi,
we installed a new MAXDB 7.6.5.9 (64-bits) database on Windows 2003 x64.
First , sql queries like select top 50 * from table started to fail with the message:
General error;-9400 POS(1) System error: AK Cachedirectory full
We looked into knldiag, which was filled with following errors
0x2A4 ERR 20011 MOVECODE -6 bytes to copy
0x2A4 ERR 51080 SYSERROR Move error
0x2A4 ERR 20011 MOVECODE Bad parameter: source size [32768] dest size [40280], source addr [0X7FFF08606B8]+3, dest addr [0X7FFF0903AA4]+17,
0xCB8 ERR 20011 MOVECODE -6 bytes to copy
0xCC ERR 20011 MOVECODE -6 bytes to copy
0xCC ERR 20013 MOVECODE + Module VAK67 call index 12
0xCB8 ERR 51080 SYSERROR Move error
0xCB8 ERR 20011 MOVECODE Bad parameter: source size [32768] dest size [40280], source addr [0X7FFEE3C06B8]+3, dest addr [0X7FFED70540C]+17,
0xCC ERR 20011 MOVECODE -6 bytes to copy
0xCC ERR 20013 MOVECODE + Module VAK67 call index 12
0xCC ERR 20011 MOVECODE Bad parameter: source size [32768] dest size [40280], source addr [0X7FFF06E06B8]+3, dest addr [0X7FFF0763A8C]+17,
After some time repeating the same errors, the kernel crashed with the following stack
0x910 ERR 19999 BTRACE ----> Stack Back Trace <----
0x910 ERR 19999 BTRACE kernel!ak10block_into_freelist + 484 bytes
0x910 ERR 19999 BTRACE SFrame: IP:000000000096ff84 RA:00000000009729b7 FP:0000000018e1d980 SP:0000000018e1d950
0x910 ERR 19999 BTRACE Params: 01:000007ffeceda3c0 02:0000000000000000 03:0000000018e1e738 04:0000000018e1e030
0x910 ERR 19999 BTRACE Source: vak10.c ( Line: 11443 )
0x910 ERR 19999 BTRACE kernel!a10key_del + 103 bytes
0x910 ERR 19999 BTRACE SFrame: IP:00000000009729b7 RA:0000000000b22564 FP:0000000018e1d9b0 SP:0000000018e1d990
0x910 ERR 19999 BTRACE Params: 01:0000000018e1e030 02:0000000000000000 03:0000000018e1e030 04:0000000018d00200
0x910 ERR 19999 BTRACE Source: vak10.c ( Line: 9885 )
0x910 ERR 19999 BTRACE kernel!a663_put_result_info + 980 bytes
0x910 ERR 19999 BTRACE SFrame: IP:0000000000b22564 RA:0000000000b30870 FP:0000000018e1dac0 SP:0000000018e1d9c0
0x910 ERR 19999 BTRACE Params: 01:0000000000000000 02:0000000018e1eaae 03:0000000018e1e030 04:0000000018d00200
0x910 ERR 19999 BTRACE Source: vak663.c ( Line: 6424 )
0x910 ERR 19999 BTRACE kernel!ak92analyze_messagetype + 2800 bytes
0x910 ERR 19999 BTRACE SFrame: IP:0000000000b30870 RA:0000000000b30bb9 FP:0000000018e1dcb0 SP:0000000018e1dad0
0x910 ERR 19999 BTRACE Params: 01:0000000018e1e000 02:0000000000000000 03:0000000000000000 04:0000000000000000
0x910 ERR 19999 BTRACE Source: vak92.c ( Line: 5905 )
0x910 ERR 19999 BTRACE kernel!a92_mode_analyzer + 233 bytes
0x910 ERR 19999 BTRACE SFrame: IP:0000000000b30bb9 RA:0000000000b2598a FP:0000000018e1dd00 SP:0000000018e1dcc0
0x910 ERR 19999 BTRACE Params: 01:0000000000cafb18 02:0000000018e1e135 03:0000000000000000 04:0000000018e1e030
0x910 ERR 19999 BTRACE Source: vak92.c ( Line: 6615 )
0x910 ERR 19999 BTRACE kernel!ak93one_command + 1642 bytes
0x910 ERR 19999 BTRACE SFrame: IP:0000000000b2598a RA:0000000000b273fe FP:0000000018e1de00 SP:0000000018e1dd10
0x910 ERR 19999 BTRACE Params: 01:0000000018e1df00 02:0000000000000000 03:000007fff0346538 04:0000000018e1e030
0x910 ERR 19999 BTRACE Source: vak93.c ( Line: 6664 )
0x910 ERR 19999 BTRACE kernel!a93_user_commands + 1758 bytes
0x910 ERR 19999 BTRACE SFrame: IP:0000000000b273fe RA:0000000000c62e37 FP:0000000018e1ded0 SP:0000000018e1de10
0x910 ERR 19999 BTRACE Params: 01:000007fffe944ff0 02:0000000000000000 03:000007fff0346538 04:000007fffe9d78d0
0x910 ERR 19999 BTRACE Source: vak93.c ( Line: 5720 )
0x910 ERR 19999 BTRACE kernel!Kernel_Main + 1719 bytes
0x910 ERR 19999 BTRACE SFrame: IP:0000000000c62e37 RA:00000000007f30c3 FP:0000000018e1ff70 SP:0000000018e1dee0
0x910 ERR 19999 BTRACE Params: 01:000007fffe944e90 02:0000000000000000 03:0000000000000000 04:00000000007f2f70
0x910 ERR 19999 BTRACE Source: kernel_main.cpp ( Line: 206 )
0x910 ERR 19999 BTRACE kernel!sql88k_kernel_fiber + 339 bytes
0x910 ERR 19999 BTRACE SFrame: IP:00000000007f30c3 RA:0000000077d6b6da FP:0000000018e1ffa0 SP:0000000018e1ff80
0x910 ERR 19999 BTRACE Params: 01:0000000000000000 02:0000000000000000 03:0000000000000000 04:000007ffffe84fb0
0x910 ERR 19999 BTRACE Source: vos88k.cpp ( Line: 484 )
0x910 ERR 19999 BTRACE kernel32!BaseThreadStart + 58 bytes
0x910 ERR 19999 BTRACE SFrame: IP:0000000077d6b6da RA:0000000000000000 FP:0000000018e1ffd0 SP:0000000018e1ffb0
0x910 ERR 19999 BTRACE Params: 01:0000000000000000 02:0000000000000000 03:0000000000000000 04:0000000000000000
I looked in the forum and on internet for insights.
We found an old reference to -9400 being an indication of a kernel bug.
We disabled SHARED_SQL, but the crash occured again with the same stack trace.
Can someone help us, or tell us where to start looking ?
Hi GuB,
can you provide the DDL for the tables and the exact syntax that leads to the error?
Also the parametersetup would be of interest.
Finally a vtrace would be necessary to have for this problem.
See [MaxDB database trace|https://wiki.sdn.sap.com/wiki/x/2yg] on how to create such a trace.
regards,
Lars
btw:
If this database is for a SAP product, please open a support message for it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Lars,
this is not for a SAP product. BTW, is it possible to buy a support contract for a community release ?
Here is the start of the knldiag, with the kernel parameters
--------------------------------------------------------------------------------
Date Time TID(hex) Typ MsgID Label Message-Text
--------------------------------------------------------------------------------
2008-09-17 15:02:15 0x750 20234 RTE Dump of all kernel parameters start
2008-09-17 15:02:15 0x750 20207 RTE Using mode NORMAL for data volume 1
2008-09-17 15:02:15 0x750 20235 RTE ADMIN=1
2008-09-17 15:02:15 0x750 20235 RTE _AK_DUMP_ALLOWED=YES
2008-09-17 15:02:15 0x750 20235 RTE ALLOW_MULTIPLE_SERVERTASK_UKTS=NO
2008-09-17 15:02:15 0x750 20235 RTE AUTHENTICATION_ALLOW=
2008-09-17 15:02:15 0x750 20235 RTE AUTHENTICATION_DENY=
2008-09-17 15:02:15 0x750 20235 RTE AUTOSAVE=1
2008-09-17 15:02:15 0x750 20235 RTE AUTO_RECREATE_BAD_INDEXES=NO
2008-09-17 15:02:15 0x750 20235 RTE BACKUPRESULT=1
2008-09-17 15:02:15 0x750 20235 RTE BACKUP_BLOCK_CNT=64
2008-09-17 15:02:15 0x750 20235 RTE _BACKUP_HISTFILE=dbm.knl
2008-09-17 15:02:15 0x750 20235 RTE _BACKUP_MED_DEF=dbm.mdf
2008-09-17 15:02:15 0x750 20235 RTE CACHE_SIZE=500000
2008-09-17 15:02:15 0x750 20235 RTE CALLSTACKLEVEL=0
2008-09-17 15:02:15 0x750 20235 RTE _CAT_CACHE_MINSIZE=262144
2008-09-17 15:02:15 0x750 20235 RTE CAT_CACHE_SUPPLY=12864
2008-09-17 15:02:15 0x750 20235 RTE CHECKDATA=1
2008-09-17 15:02:15 0x750 20235 RTE CHECK_BACKUP=NO
2008-09-17 15:02:15 0x750 20235 RTE CHECK_COMMON=0
2008-09-17 15:02:15 0x750 20235 RTE CHECK_CONVERTER=0
2008-09-17 15:02:15 0x750 20235 RTE CHECK_DATACACHE=NO
2008-09-17 15:02:15 0x750 20235 RTE CHECK_DATAINDEX=0
2008-09-17 15:02:15 0x750 20235 RTE CHECK_DATAPAGELOG=0
2008-09-17 15:02:15 0x750 20235 RTE CHECK_FBM=0
2008-09-17 15:02:15 0x750 20235 RTE CHECK_HASHED_RESULTSET=0
2008-09-17 15:02:15 0x750 20235 RTE CHECK_IOMAN=0
2008-09-17 15:02:15 0x750 20235 RTE CHECK_KB_REGIONS=NO
2008-09-17 15:02:15 0x750 20235 RTE CHECK_LOCK_SUPPLY=NO
2008-09-17 15:02:15 0x750 20235 RTE CHECK_LOCK=NO
2008-09-17 15:02:15 0x750 20235 RTE CHECK_LOGHISTORY=0
2008-09-17 15:02:15 0x750 20235 RTE CHECK_LOGPAGE=0
2008-09-17 15:02:15 0x750 20235 RTE CHECK_LOGTRANS=0
2008-09-17 15:02:15 0x750 20235 RTE CHECK_LOGVOLUME=0
2008-09-17 15:02:15 0x750 20235 RTE CHECK_QUERYREWRITE=0
2008-09-17 15:02:15 0x750 20235 RTE CHECK_REGIONS=NO
2008-09-17 15:02:15 0x750 20235 RTE CHECK_SRVTASKS=0
2008-09-17 15:02:15 0x750 20235 RTE CHECK_TABLE_WIDTH=NO
2008-09-17 15:02:15 0x750 20235 RTE CHECK_TASK_SPECIFIC_CATALOGCACHE=NO
2008-09-17 15:02:15 0x750 20235 RTE CHECK_TRANSLIST=NO
2008-09-17 15:02:15 0x750 20235 RTE CHECK_TREE_LOCKS=NO
2008-09-17 15:02:15 0x750 20235 RTE CHECK_TREE=NO
2008-09-17 15:02:15 0x750 20235 RTE CLUSTERCOMPRESSIONFILLTHRESHOLD=10
2008-09-17 15:02:15 0x750 20235 RTE CLUSTERCOMPRESSIONTHRESHOLD=1000
2008-09-17 15:02:15 0x750 20235 RTE CLUSTERED_LOBS=NO
2008-09-17 15:02:15 0x750 20235 RTE CLUSTER_WRITE_THRESHOLD=80
2008-09-17 15:02:15 0x750 20235 RTE COLUMNCOMPRESSION=YES
2008-09-17 15:02:15 0x750 20235 RTE _COMMENT=
2008-09-17 15:02:15 0x750 20235 RTE CONTROLPASSWORD=***
2008-09-17 15:02:15 0x750 20235 RTE CONTROLUSERID=DBOPE
2008-09-17 15:02:15 0x750 20235 RTE CONVERTER_REGIONS=8
2008-09-17 15:02:15 0x750 20235 RTE DATABASEFULL=1
2008-09-17 15:02:15 0x750 20235 RTE _DATA_CACHE_RGNS=64
2008-09-17 15:02:15 0x750 20235 RTE DATA_IO_BLOCK_COUNT=64
2008-09-17 15:02:15 0x750 20235 RTE DATA_VOLUME_GROUPS=1
2008-09-17 15:02:15 0x750 20235 RTE DATA_VOLUME_MODE_0001=NORMAL
2008-09-17 15:02:15 0x750 20235 RTE DATA_VOLUME_NAME_0001=E:\DATABASE_DATA\BASE_D0001
2008-09-17 15:02:15 0x750 20235 RTE DATA_VOLUME_SIZE_0001=3840000
2008-09-17 15:02:15 0x750 20235 RTE DATA_VOLUME_TYPE_0001=F
2008-09-17 15:02:15 0x750 20235 RTE DATE_TIME_FORMAT=INTERNAL
2008-09-17 15:02:15 0x750 20235 RTE DBFILLINGABOVELIMIT=70L80M85M90H95H96H97H98H99H
2008-09-17 15:02:15 0x750 20235 RTE DBFILLINGBELOWLIMIT=70L80L85L90L95L
2008-09-17 15:02:15 0x750 20235 RTE DDLTRIGGER=YES
2008-09-17 15:02:15 0x750 20235 RTE DEADLOCK_DETECTION=4
2008-09-17 15:02:15 0x750 20235 RTE DEADLOCK_DUMP_FILENAME=
2008-09-17 15:02:15 0x750 20235 RTE DEFAULT_CODE=ASCII
2008-09-17 15:02:15 0x750 20235 RTE _DELAY_COMMIT=NO
2008-09-17 15:02:15 0x750 20235 RTE _DELAY_LOGWRITER=0
2008-09-17 15:02:15 0x750 20235 RTE DIAG_HISTORY_NUM=2
2008-09-17 15:02:15 0x750 20235 RTE DIAG_HISTORY_PATH=C:\Documents and Settings\All Users\Application Data\sdb\data\wrk\BASE\DIAGHISTORY
2008-09-17 15:02:15 0x750 20235 RTE _DIAG_SEM=0
2008-09-17 15:02:15 0x750 20235 RTE _DW_IO_AREA_FLUSH=50
2008-09-17 15:02:15 0x750 20235 RTE _DW_IO_AREA_SIZE=50
2008-09-17 15:02:15 0x750 20235 RTE _DW_LRU_TAIL_FLUSH=25
2008-09-17 15:02:15 0x750 20235 RTE ENABLE_CHECK_INSTANCE=YES
2008-09-17 15:02:15 0x750 20235 RTE ENABLE_SYSTEM_TRIGGERS=YES
2008-09-17 15:02:15 0x750 20235 RTE ERROR=3
2008-09-17 15:02:15 0x750 20235 RTE _EVENTFILE=knldiag.evt
2008-09-17 15:02:15 0x750 20235 RTE _EVENTSIZE=0
2008-09-17 15:02:15 0x750 20235 RTE EVENT=1
2008-09-17 15:02:15 0x750 20235 RTE EXPAND_COM_TRACE=NO
2008-09-17 15:02:15 0x750 20235 RTE EXTERNAL_DUMP_REQUEST=NO
2008-09-17 15:02:15 0x750 20235 RTE FBM_CLUSTER_MODE=MIXED
2008-09-17 15:02:15 0x750 20235 RTE _FBM_LOW_IO_RATE=10
2008-09-17 15:02:15 0x750 20235 RTE FBM_VOLUME_BALANCE=10
2008-09-17 15:02:15 0x750 20235 RTE FBM_VOLUME_COMPRESSION=50
2008-09-17 15:02:15 0x750 20235 RTE FILEDIR_SPINLOCKPOOL_SIZE=10
2008-09-17 15:02:15 0x750 20235 RTE FORBID_LOAD_BALANCING=NO
2008-09-17 15:02:15 0x750 20235 RTE FORMATTING_MODE=PARALLEL
2008-09-17 15:02:15 0x750 20235 RTE FORMAT_DATAVOLUME=YES
2008-09-17 15:02:15 0x750 20235 RTE HASHED_RESULTSET_CACHESIZE=262144
2008-09-17 15:02:15 0x750 20235 RTE HASHED_RESULTSET=YES
2008-09-17 15:02:15 0x750 20235 RTE HEAP_CHECK_LEVEL=0
2008-09-17 15:02:15 0x750 20235 RTE HIRES_TIMER_TYPE=CPU
2008-09-17 15:02:15 0x750 20235 RTE HS_STORAGE_DLL=libhsscopy
2008-09-17 15:02:15 0x750 20235 RTE HS_SYNC_INTERVAL=50
2008-09-17 15:02:15 0x750 20235 RTE _IDXFILE_LIST_SIZE=2048
2008-09-17 15:02:15 0x750 20235 RTE INDEX_LEAF_CACHING=2
2008-09-17 15:02:15 0x750 20235 RTE INIT_ALLOCATORSIZE=262144
2008-09-17 15:02:15 0x750 20235 RTE INSTANCE_TYPE=OLTP
2008-09-17 15:02:15 0x750 20235 RTE _IOPROCS_FOR_PRIO=0
2008-09-17 15:02:15 0x750 20235 RTE _IOPROCS_FOR_READER=0
2008-09-17 15:02:15 0x750 20235 RTE _IOPROCS_PER_DEV=1
2008-09-17 15:02:15 0x750 20235 RTE _IOPROCS_SWITCH=2
2008-09-17 15:02:15 0x750 20235 RTE JOIN_MAXTAB_LEVEL4=16
2008-09-17 15:02:15 0x750 20235 RTE JOIN_MAXTAB_LEVEL9=5
2008-09-17 15:02:15 0x750 20235 RTE JOIN_SEARCH_LEVEL=0
2008-09-17 15:02:15 0x750 20235 RTE JOIN_TABLEBUFFER=128
2008-09-17 15:02:15 0x750 20235 RTE _KERNELDIAGFILE=knldiag
2008-09-17 15:02:15 0x750 20235 RTE KERNELDIAGSIZE=800
2008-09-17 15:02:15 0x750 20235 RTE _KERNELDUMPFILE=knldump
2008-09-17 15:02:15 0x750 20235 RTE _KERNELTRACEFILE=knltrace
2008-09-17 15:02:15 0x750 20235 RTE KERNELTRACESIZE=2899
2008-09-17 15:02:15 0x750 20235 RTE KERNELVERSION=KERNEL 7.6.05 BUILD 009-123-191-997
2008-09-17 15:02:15 0x750 20235 RTE _LM_LOCK_REGIONS=0
2008-09-17 15:02:15 0x750 20235 RTE _LM_REQUEST_REGIONS=0
2008-09-17 15:02:15 0x750 20235 RTE _LM_TRANS_REGIONS=0
2008-09-17 15:02:15 0x750 20235 RTE LOAD_BALANCING_CHK=15
2008-09-17 15:02:15 0x750 20235 RTE LOAD_BALANCING_DIF=10
2008-09-17 15:02:15 0x750 20235 RTE LOAD_BALANCING_EQ=5
2008-09-17 15:02:15 0x750 20235 RTE LOCAL_REDO_LOG_BUFFER_SIZE=0
2008-09-17 15:02:15 0x750 20235 RTE _LOCKMANAGER_ENABLED=NO
2008-09-17 15:02:15 0x750 20235 RTE _LOCK_SUPPLY_BLOCK=100
2008-09-17 15:02:15 0x750 20235 RTE LOGABOVELIMIT=50L75L90M95M96H97H98H99H
2008-09-17 15:02:15 0x750 20235 RTE LOGFULL=1
2008-09-17 15:02:15 0x750 20235 RTE LOGSEGMENTFULL=1
2008-09-17 15:02:15 0x750 20235 RTE LOG_BACKUP_TO_PIPE=NO
2008-09-17 15:02:15 0x750 20235 RTE LOG_IO_BLOCK_COUNT=4
2008-09-17 15:02:15 0x750 20235 RTE LOG_IO_QUEUE=50
2008-09-17 15:02:15 0x750 20235 RTE LOG_MIRRORED=NO
2008-09-17 15:02:15 0x750 20235 RTE LOG_QUEUE_COUNT=0
2008-09-17 15:02:15 0x750 20235 RTE LOG_SEGMENT_SIZE=256000
2008-09-17 15:02:15 0x750 20235 RTE LOG_VOLUME_NAME_001=D:\DATABASE_LOG\BASE_L0001
2008-09-17 15:02:15 0x750 20235 RTE LOG_VOLUME_SIZE_001=768000
2008-09-17 15:02:15 0x750 20235 RTE LOG_VOLUME_TYPE_001=F
2008-09-17 15:02:15 0x750 20235 RTE LRU_FOR_SCAN=NO
2008-09-17 15:02:15 0x750 20235 RTE MAXBACKUPDEVS=2
2008-09-17 15:02:15 0x750 20235 RTE MAXCPU=3
2008-09-17 15:02:15 0x750 20235 RTE MAXDATAVOLUMES=64
2008-09-17 15:02:15 0x750 20235 RTE _MAXEVENTS=100
2008-09-17 15:02:15 0x750 20235 RTE _MAXEVENTTASKS=2
2008-09-17 15:02:15 0x750 20235 RTE _MAXGARBAGE_COLL=1
2008-09-17 15:02:15 0x750 20235 RTE MAXLOCKS=50000
2008-09-17 15:02:15 0x750 20235 RTE MAXLOGVOLUMES=2
2008-09-17 15:02:15 0x750 20235 RTE MAXPAGER=64
2008-09-17 15:02:15 0x750 20235 RTE MAXRGN_REQUEST=-1
2008-09-17 15:02:15 0x750 20235 RTE MAXSERVERTASKS=134
2008-09-17 15:02:15 0x750 20235 RTE _MAXTASK_STACK=1024
2008-09-17 15:02:15 0x750 20235 RTE _MAXTRANS=1604
2008-09-17 15:02:15 0x750 20235 RTE MAXUSERTASKS=200
2008-09-17 15:02:15 0x750 20235 RTE MAXVOLUMES=67
2008-09-17 15:02:15 0x750 20235 RTE MAX_HASHTABLE_MEMORY=5120
2008-09-17 15:02:15 0x750 20235 RTE MAX_LOG_QUEUE_COUNT=0
2008-09-17 15:02:15 0x750 20235 RTE _MAX_MESSAGE_FILES=0
2008-09-17 15:02:15 0x750 20235 RTE MAX_MESSAGE_LIST_LENGTH=100
2008-09-17 15:02:15 0x750 20235 RTE MAX_RETENTION_TIME=480
2008-09-17 15:02:15 0x750 20235 RTE MAX_SERVERTASK_STACK=500
2008-09-17 15:02:15 0x750 20235 RTE MAX_SINGLE_HASHTABLE_SIZE=512
2008-09-17 15:02:15 0x750 20235 RTE MAX_SPECIALTASK_STACK=500
2008-09-17 15:02:15 0x750 20235 RTE _MBLOCK_DATA_SIZE=32768
2008-09-17 15:02:15 0x750 20235 RTE _MBLOCK_QUAL_SIZE=32768
2008-09-17 15:02:15 0x750 20235 RTE _MBLOCK_STACK_SIZE=32768
2008-09-17 15:02:15 0x750 20235 RTE _MBLOCK_STRAT_SIZE=16384
2008-09-17 15:02:15 0x750 20235 RTE MCOD=NO
2008-09-17 15:02:15 0x750 20235 RTE MEMORY_ALLOCATION_LIMIT=0
2008-09-17 15:02:15 0x750 20235 RTE MINI_DUMP=NORMAL
2008-09-17 15:02:15 0x750 20235 RTE _MINREPLY_SIZE=4096
2008-09-17 15:02:15 0x750 20235 RTE MINSERVERTASKS=134
2008-09-17 15:02:15 0x750 20235 RTE MIN_RETENTION_TIME=60
2008-09-17 15:02:15 0x750 20235 RTE MONITOR_READ=2147483647
2008-09-17 15:02:15 0x750 20235 RTE MONITOR_ROWNO=0
2008-09-17 15:02:15 0x750 20235 RTE MONITOR_SELECTIVITY=0
2008-09-17 15:02:15 0x750 20235 RTE MONITOR_TIME=2147483647
2008-09-17 15:02:15 0x750 20235 RTE _MP_DISP_LOOPS=1
2008-09-17 15:02:15 0x750 20235 RTE _MP_DISP_PRIO=DEFAULT
2008-09-17 15:02:15 0x750 20235 RTE _MP_RGN_BUSY_WAIT=DEFAULT
2008-09-17 15:02:15 0x750 20235 RTE _MP_RGN_DIRTY_READ=DEFAULT
2008-09-17 15:02:15 0x750 20235 RTE MP_RGN_LOOP=-1
2008-09-17 15:02:15 0x750 20235 RTE _MP_RGN_PRIO=DEFAULT
2008-09-17 15:02:15 0x750 20235 RTE _MP_RGN_QUEUE=YES
2008-09-17 15:02:15 0x750 20235 RTE OFFICIAL_NODE=
2008-09-17 15:02:15 0x750 20235 RTE OMS_HEAP_BLOCKSIZE=10000
2008-09-17 15:02:15 0x750 20235 RTE OMS_HEAP_COUNT=3
2008-09-17 15:02:15 0x750 20235 RTE OMS_HEAP_LIMIT=0
2008-09-17 15:02:15 0x750 20235 RTE OMS_HEAP_THRESHOLD=100
2008-09-17 15:02:15 0x750 20235 RTE _OMS_REGIONS=0
2008-09-17 15:02:15 0x750 20235 RTE _OMS_RGNS=7
2008-09-17 15:02:15 0x750 20235 RTE OMS_RUN_IN_UDE_SERVER=NO
2008-09-17 15:02:15 0x750 20235 RTE OMS_STREAM_TIMEOUT=30
2008-09-17 15:02:15 0x750 20235 RTE OMS_VERS_THRESHOLD=2097152
2008-09-17 15:02:15 0x750 20235 RTE ONLINE=1
2008-09-17 15:02:15 0x750 20235 RTE OPTIMIZE_AGGREGATION=YES
2008-09-17 15:02:15 0x750 20235 RTE OPTIMIZE_FETCH_REVERSE=YES
2008-09-17 15:02:15 0x750 20235 RTE OPTIMIZE_FIRST_ROWS=YES
2008-09-17 15:02:15 0x750 20235 RTE OPTIMIZE_JOIN_HASHTABLE=YES
2008-09-17 15:02:15 0x750 20235 RTE OPTIMIZE_JOIN_HASH_MINIMAL_RATIO=1
2008-09-17 15:02:15 0x750 20235 RTE OPTIMIZE_JOIN_ONEPHASE=YES
2008-09-17 15:02:15 0x750 20235 RTE OPTIMIZE_JOIN_OPERATOR_SORT=YES
2008-09-17 15:02:15 0x750 20235 RTE OPTIMIZE_JOIN_OUTER=YES
2008-09-17 15:02:15 0x750 20235 RTE OPTIMIZE_JOIN_PARALLEL_MINSIZE=1000000
2008-09-17 15:02:15 0x750 20235 RTE OPTIMIZE_JOIN_PARALLEL_SERVERS=0
2008-09-17 15:02:15 0x750 20235 RTE OPTIMIZE_MIN_MAX=YES
2008-09-17 15:02:15 0x750 20235 RTE OPTIMIZE_OPERATOR_JOIN_COSTFUNC=YES
2008-09-17 15:02:15 0x750 20235 RTE OPTIMIZE_OPERATOR_JOIN=YES
2008-09-17 15:02:15 0x750 20235 RTE OPTIMIZE_QUAL_ON_INDEX=YES
2008-09-17 15:02:15 0x750 20235 RTE OPTIMIZE_QUERYREWRITE=OPERATOR
2008-09-17 15:02:15 0x750 20235 RTE OPTIMIZE_STAR_JOIN=YES
2008-09-17 15:02:15 0x750 20235 RTE OPTIM_CACHE=NO
2008-09-17 15:02:15 0x750 20235 RTE OPTIM_INV_ONLY=YES
2008-09-17 15:02:15 0x750 20235 RTE OPTIM_JOIN_FETCH=0
2008-09-17 15:02:15 0x750 20235 RTE OPTIM_MAX_MERGE=500
2008-09-17 15:02:15 0x750 20235 RTE OUTOFSESSIONS=3
2008-09-17 15:02:15 0x750 20235 RTE _PACKET_SIZE=131072
2008-09-17 15:02:15 0x750 20235 RTE _PAGE_SIZE=8192
2008-09-17 15:02:15 0x750 20235 RTE PREALLOCATE_IOWORKER=NO
2008-09-17 15:02:15 0x750 20235 RTE _PRIO_BASE_COM=10
2008-09-17 15:02:15 0x750 20235 RTE _PRIO_BASE_IOC=80
2008-09-17 15:02:15 0x750 20235 RTE _PRIO_BASE_RAV=80
2008-09-17 15:02:15 0x750 20235 RTE _PRIO_BASE_REX=40
2008-09-17 15:02:15 0x750 20235 RTE _PRIO_BASE_U2U=100
2008-09-17 15:02:15 0x750 20235 RTE _PRIO_FACTOR=80
2008-09-17 15:02:15 0x750 20235 RTE PROTECT_DATACACHE_MEMORY=NO
2008-09-17 15:02:15 0x750 20235 RTE _READAHEAD_BLOBS=32
2008-09-17 15:02:15 0x750 20235 RTE READAHEAD_TABLE_THRESHOLD=0
2008-09-17 15:02:15 0x750 20235 RTE REQUEST_TIMEOUT=5000
2008-09-17 15:02:15 0x750 20235 RTE RESERVEDSERVERTASKS=69
2008-09-17 15:02:15 0x750 20235 RTE _RESTART_TIME=600
2008-09-17 15:02:15 0x750 20235 RTE ROW_LOCKS_PER_TRANSACTION=50
2008-09-17 15:02:15 0x750 20235 RTE _ROW_RGNS=8
2008-09-17 15:02:15 0x750 20235 RTE _RTEDUMPFILE=rtedump
2008-09-17 15:02:15 0x750 20235 RTE RTE_TEST_REGIONS=0
2008-09-17 15:02:15 0x750 20235 RTE RUNDIRECTORY=C:\Documents and Settings\All Users\Application Data\sdb\data\wrk\BASE
2008-09-17 15:02:15 0x750 20235 RTE SEQUENCE_CACHE=1
2008-09-17 15:02:15 0x750 20235 RTE _SERVERDB_FOR_SAP=YES
2008-09-17 15:02:15 0x750 20235 RTE SESSION_TIMEOUT=900
2008-09-17 15:02:15 0x750 20235 RTE SET_VOLUME_LOCK=YES
2008-09-17 15:02:15 0x750 20235 RTE SHAREDSQL_CLEANUPTHRESHOLD=25
2008-09-17 15:02:15 0x750 20235 RTE SHAREDSQL_COMMANDCACHESIZE=262144
2008-09-17 15:02:15 0x750 20235 RTE SHAREDSQL=YES
2008-09-17 15:02:15 0x750 20235 RTE SHOW_MAX_KB_STACK_USE=NO
2008-09-17 15:02:15 0x750 20235 RTE SHOW_MAX_STACK_USE=NO
2008-09-17 15:02:15 0x750 20235 RTE SPINLOCK_BACKOFF_BASE=1
2008-09-17 15:02:15 0x750 20235 RTE SPINLOCK_BACKOFF_FACTOR=2
2008-09-17 15:02:15 0x750 20235 RTE SPINLOCK_BACKOFF_MAXIMUM=64
2008-09-17 15:02:15 0x750 20235 RTE SPINLOCK_LOOP_COUNT=30000
2008-09-17 15:02:15 0x750 20235 RTE STANDBY=1
2008-09-17 15:02:15 0x750 20235 RTE SUBTREE_LOCKS=NO
2008-09-17 15:02:15 0x750 20235 RTE SYMBOL_DEMANGLING=NO
2008-09-17 15:02:15 0x750 20235 RTE SYMBOL_RESOLUTION=YES
2008-09-17 15:02:15 0x750 20235 RTE SYSTEMERROR=3
2008-09-17 15:02:15 0x750 20235 RTE _TAB_RGNS=8
2008-09-17 15:02:15 0x750 20235 RTE _TASKCLUSTER_01=tw;al;ut;2000*sv,100*bup;10*ev,10*gc;
2008-09-17 15:02:15 0x750 20235 RTE _TASKCLUSTER_02=ti,100*dw;67*us;
2008-09-17 15:02:15 0x750 20235 RTE _TASKCLUSTER_03=equalize
2008-09-17 15:02:15 0x750 20235 RTE TIME_MEASUREMENT=NO
2008-09-17 15:02:15 0x750 20235 RTE TRACE_AK=NO
2008-09-17 15:02:15 0x750 20235 RTE TRACE_ALLOCATOR=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_CATALOG=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_CLIENTKERNELCOM=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_COMMON=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_COMMUNICATION=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_CONVERTER=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_DATACACHE=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_DATACHAIN=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_DATAINDEX=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_DATAPAM=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_DATATREE=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_DBPROC=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_DEFAULT=NO
2008-09-17 15:02:15 0x750 20235 RTE TRACE_DELETE=NO
2008-09-17 15:02:15 0x750 20235 RTE TRACE_FBM=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_FILEDIR=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_FRAMECTRL=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_INDEX=NO
2008-09-17 15:02:15 0x750 20235 RTE TRACE_INSERT=NO
2008-09-17 15:02:15 0x750 20235 RTE TRACE_IOMAN=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_IPC=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_JOIN=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_KSQL=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_LOCKMANAGER=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_LOCK=NO
2008-09-17 15:02:15 0x750 20235 RTE TRACE_LOGACTION=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_LOGHISTORY=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_LOGPAGE=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_LOGTRANS=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_LOGVOLUME=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_LONG=NO
2008-09-17 15:02:15 0x750 20235 RTE TRACE_MEMORY=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_MESSAGES=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_OBJECTCONTAINER=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_OBJECT_ADD=NO
2008-09-17 15:02:15 0x750 20235 RTE TRACE_OBJECT_ALTER=NO
2008-09-17 15:02:15 0x750 20235 RTE TRACE_OBJECT_FREE=NO
2008-09-17 15:02:15 0x750 20235 RTE TRACE_OBJECT_GET=NO
2008-09-17 15:02:15 0x750 20235 RTE TRACE_OBJECT=NO
2008-09-17 15:02:15 0x750 20235 RTE TRACE_OMS_CONTAINERDIR=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_OMS_CONTEXT=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_OMS_ERROR=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_OMS_FLUSHCACHE=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_OMS_INTERFACE=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_OMS_KEYRANGE=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_OMS_KEY=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_OMS_LOCK=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_OMS_MEMORY=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_OMS_NEWOBJ=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_OMS_SESSION=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_OMS_STREAM=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_OMS_VAROBJECT=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_OMS_VERSION=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_OPTIMIZE=NO
2008-09-17 15:02:15 0x750 20235 RTE TRACE_ORDER_STANDARD=NO
2008-09-17 15:02:15 0x750 20235 RTE TRACE_ORDER=NO
2008-09-17 15:02:15 0x750 20235 RTE TRACE_PAGER=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_PAGES_BUP=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_PAGES_EV=2
2008-09-17 15:02:15 0x750 20235 RTE TRACE_PAGES_GC=20
2008-09-17 15:02:15 0x750 20235 RTE TRACE_PAGES_LW=5
2008-09-17 15:02:15 0x750 20235 RTE TRACE_PAGES_PG=3
2008-09-17 15:02:15 0x750 20235 RTE TRACE_PAGES_SV=5
2008-09-17 15:02:15 0x750 20235 RTE TRACE_PAGES_TI=2
2008-09-17 15:02:15 0x750 20235 RTE TRACE_PAGES_US=10
2008-09-17 15:02:15 0x750 20235 RTE TRACE_PAGES_UT=5
2008-09-17 15:02:15 0x750 20235 RTE TRACE_PAGES=NO
2008-09-17 15:02:15 0x750 20235 RTE TRACE_PRIMARY_TREE=NO
2008-09-17 15:02:15 0x750 20235 RTE TRACE_QUERYREWRITE=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_RUNTIME=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_SELECT=NO
2008-09-17 15:02:15 0x750 20235 RTE TRACE_SHAREDSQL=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_SQLMANAGER=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_SRVTASKS=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_STOP_ERRORCODE=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_SYNCHRONISATION=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_SYSVIEW=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_TABLE=0
2008-09-17 15:02:15 0x750 20235 RTE TRACE_TIME=NO
2008-09-17 15:02:15 0x750 20235 RTE TRACE_UPDATE=NO
2008-09-17 15:02:15 0x750 20235 RTE TRACE_VOLUME=0
2008-09-17 15:02:15 0x750 20235 RTE TRANS_HISTORY_SIZE=0
2008-09-17 15:02:15 0x750 20235 RTE _TRANS_RGNS=8
2008-09-17 15:02:15 0x750 20235 RTE TRANS_THRESHOLD_VALUE=60
2008-09-17 15:02:15 0x750 20235 RTE UKT_CPU_RELATIONSHIP=NONE
2008-09-17 15:02:15 0x750 20235 RTE _UNICODE=YES
2008-09-17 15:02:15 0x750 20235 RTE UPDATESTAT_PARALLEL_SERVERS=0
2008-09-17 15:02:15 0x750 20235 RTE UPDATESTAT_SAMPLE_ALGO=1
2008-09-17 15:02:15 0x750 20235 RTE UPDSTATWANTED=1
2008-09-17 15:02:15 0x750 20235 RTE USED_MAX_LOG_QUEUE_COUNT=3
2008-09-17 15:02:15 0x750 20235 RTE USESELECTFETCH=YES
2008-09-17 15:02:15 0x750 20235 RTE USEUNICODECOLUMNCOMPRESSION=NO
2008-09-17 15:02:15 0x750 20235 RTE USEVARIABLEINPUT=NO
2008-09-17 15:02:15 0x750 20235 RTE _USE_ASYNC_IO=YES
2008-09-17 15:02:15 0x750 20235 RTE USE_BACKUP_SECURITY_DESCRIPTOR=YES
2008-09-17 15:02:15 0x750 20235 RTE USE_COROUTINES=YES
2008-09-17 15:02:15 0x750 20235 RTE USE_FIBERS=YES
2008-09-17 15:02:15 0x750 20235 RTE _USE_IOPROCS_ONLY=NO
2008-09-17 15:02:15 0x750 20235 RTE USE_OPEN_DIRECT_FOR_BACKUP=NO
2008-09-17 15:02:15 0x750 20235 RTE USE_OPEN_DIRECT=NO
2008-09-17 15:02:15 0x750 20235 RTE USE_SYSTEM_PAGE_CACHE=YES
2008-09-17 15:02:15 0x750 20235 RTE _UTILITY_PROTFILE=dbm.utl
2008-09-17 15:02:15 0x750 20235 RTE UTILITY_PROTSIZE=100
2008-09-17 15:02:15 0x750 20235 RTE VOLUMENO_BIT_COUNT=8
2008-09-17 15:02:15 0x750 20235 RTE _WORKDATA_SIZE=8192
2008-09-17 15:02:15 0x750 20235 RTE _WORKSTACK_SIZE=8192
2008-09-17 15:02:15 0x750 20235 RTE XP_CONVERTER_REGIONS=0
2008-09-17 15:02:15 0x750 20235 RTE XP_DATA_CACHE_RGNS=0
2008-09-17 15:02:15 0x750 20235 RTE XP_MAXPAGER=0
2008-09-17 15:02:15 0x750 20236 RTE Dump of all kernel parameters done
2008-09-17 15:02:15 0x750 19600 VERSION 'Kernel 7.6.05 Build 009-123-191-997'
2008-09-17 15:02:15 0x750 19600 VERSION 'W64/AMD64 7.6.05 Build 009-123-191-997'
2008-09-17 15:02:15 0x750 19769 INFO Starting SERVERDB: 'BASE'
2008-09-17 15:02:15 0x750 19770 INFO SERVERNODE: ''
2008-09-17 15:02:15 0x750 19771 INFO Process ID: 3076
2008-09-17 15:02:15 0x750 19773 INFO Date: 2008-09-17
2008-09-17 15:02:15 0x750 19772 INFO Owner: 'SYSTEM'
2008-09-17 15:02:15 0x750 19774 INFO Product suite: 'Terminal Server'
2008-09-17 15:02:15 0x750 19806 INFO Machine: 'AMD64 level 6 revision 1706'
2008-09-17 15:02:15 0x750 19783 INFO Processors: 1 ( logical: 4 )
2008-09-17 15:02:15 0x750 19782 INFO Fiber: 'YES'
2008-09-17 15:02:15 0x750 19776 INFO Max virtual memory: 8388607 MB
2008-09-17 15:02:15 0x750 19777 INFO Total physical memory: 8186 MB
2008-09-17 15:02:15 0x750 19778 INFO Available physical memory: 7319 MB
2008-09-17 15:02:15 0x750 20220 RTE Memory allocation not limited
2008-09-17 15:02:15 0x750 20221 RTE System page cache usage enabled
2008-09-17 15:02:15 0x750 19692 TCLUSTER tw;al;ut;2000*sv,100*bup;10*ev,10*gc;ti,100*dw;67*us;equalize
2008-09-17 15:02:15 0x750 19693 TCLUSTER number of 'BUP': 0
2008-09-17 15:02:15 0x750 19693 TCLUSTER number of ' DW': 64
2008-09-17 15:02:15 0x750 19693 TCLUSTER number of ' US': 200
2008-09-17 15:02:15 0x750 19693 TCLUSTER number of ' SV': 134
2008-09-17 15:02:15 0x750 19693 TCLUSTER number of ' EV': 2
2008-09-17 15:02:15 0x750 19693 TCLUSTER number of ' GC': 1
2008-09-17 15:02:15 0x750 19692 TCLUSTER Total Number of UKT 9
2008-09-17 15:02:15 0x750 19692 TCLUSTER Number of UKT with User Tasks 3
2008-09-17 15:02:15 0x750 19860 MEMORY I/O buffer cache: 500000 Pages allocated
2008-09-17 15:02:15 0x750 19811 EVENTING Suppressing output to 'knldiag.evt' 0 pages
2008-09-17 15:02:15 0x750 19812 EVENTING Eventbuffer 100 events 2 tasks
2008-09-17 15:02:15 0x55C 19821 TASKING Thread 1372 starting
2008-09-17 15:02:15 0x750 19831 TRACE_IO Configured _MAX_MESSAGE_FILES:0
2008-09-17 15:02:15 0x750 19832 TRACE_IO Disabled: No TraceMessagefiles wanted
2008-09-17 15:02:15 0xE88 19688 THREAD CLOCK thread started
2008-09-17 15:02:15 0xFB8 19688 THREAD TIMER thread started
2008-09-17 15:02:15 0x918 19688 THREAD ASYNC0 thread started
2008-09-17 15:02:15 0x5C4 19688 THREAD REQUESTOR thread started
2008-09-17 15:02:15 0xB2C 19821 TASKING Thread 2860 starting
2008-09-17 15:02:15 0x5AC 20214 RTE CONSOLE thread started
2008-09-17 15:02:15 0xB74 19821 TASKING Thread 2932 starting
2008-09-17 15:02:15 0x650 19821 TASKING Thread 1616 starting
2008-09-17 15:02:16 0xED8 19821 TASKING Thread 3800 starting
2008-09-17 15:02:16 0xDF8 19821 TASKING Thread 3576 starting
2008-09-17 15:02:16 0xD80 19821 TASKING Thread 3456 starting
2008-09-17 15:02:16 0x640 19821 TASKING Thread 1600 starting
2008-09-17 15:02:16 0x4F8 19821 TASKING Thread 1272 starting
2008-09-17 15:02:16 0xCD4 19821 TASKING Thread 3284 starting
2008-09-17 15:02:16 0xFDC 19821 TASKING Thread 4060 starting
2008-09-17 15:02:16 0x7A4 19627 TASKING UKT started, TID:0x7A4
2008-09-17 15:02:16 0xA90 19627 TASKING UKT started, TID:0xA90
2008-09-17 15:02:16 0x3B4 19627 TASKING UKT started, TID:0x3B4
2008-09-17 15:02:16 0xA7C 19627 TASKING UKT started, TID:0xA7C
2008-09-17 15:02:16 0xB48 19627 TASKING UKT started, TID:0xB48
2008-09-17 15:02:16 0xAD0 19821 TASKING Thread 2768 starting
2008-09-17 15:02:16 0x988 19627 TASKING UKT started, TID:0x988
2008-09-17 15:02:16 0x8B4 19627 TASKING UKT started, TID:0x8B4
2008-09-17 15:02:16 0x228 19627 TASKING UKT started, TID:0x228
2008-09-17 15:02:16 0x1B4 19627 TASKING UKT started, TID:0x1B4
2008-09-17 15:02:16 0x1B4 19615 VOLUMEIO Attaching volume 'knltrace'
2008-09-17 15:02:16 0x5D0 19613 DBSTATE I/O thread for 'knltrace' started
2008-09-17 15:02:16 0x5C4 19628 CONNECT REQUESTOR is rejecting connect request
2008-09-17 15:02:16 0x5C4 19628 CONNECT REQUESTOR is rejecting connect request
2008-09-17 15:02:16 0x5C4 19628 CONNECT REQUESTOR is rejecting connect request
2008-09-17 15:02:16 0x5C4 19628 CONNECT REQUESTOR is rejecting connect request
2008-09-17 15:02:16 0x5C4 19628 CONNECT REQUESTOR is rejecting connect request
2008-09-17 15:02:16 0x5C4 19628 CONNECT REQUESTOR is rejecting connect request
2008-09-17 15:02:16 0x1B4 20040 Admin Kernel state: 'ADMIN' reached
2008-09-17 15:02:16 0x1B4 9 SrvTasks Available Servertasks: 134
2008-09-17 15:02:16 0x1B4 54003 dynpool HIST_DIR item size : 8
2008-09-17 15:02:16 0x1B4 54003 dynpool HIST_DIR num items : 200
2008-09-17 15:02:16 0x1B4 54003 dynpool DYNP_B930_HIST_DIR : 1600
2008-09-17 15:02:16 0x1B4 54003 dynDATA DYND_K57_KB_PAGES : 11
2008-09-17 15:02:16 0x1B4 54003 dynDATA BACKUP RESTART REC (8K): 1
2008-09-17 15:02:16 0x1B4 54003 dynpool BACKUP TASK LIST : 1056
2008-09-17 15:02:16 0x1B4 54003 dynpool BACKUP TAPE LIST : 672
2008-09-17 15:02:16 0x1B4 54003 dynpool BACKUP DEVSP LIST : 512
2008-09-17 15:02:16 0x1B4 54003 dynpool BACKUP VOL IDX LIST : 128
2008-09-17 15:02:16 0x1B4 54003 dynpool BACKUP SRR QUEUE : 3200
2008-09-17 15:02:16 0x1B4 54003 dynpool DYNP_K38_SAVE_GLOB : 5056
2008-09-17 15:02:16 0x1B4 54003 dynDATA DYND_K38_SAVE : 8513
2008-09-17 15:02:16 0x1B4 54003 dynDATA BACKUP RESTART REC (8K): 1
2008-09-17 15:02:16 0x1B4 54003 dynpool BACKUP TASK LIST : 32
2008-09-17 15:02:16 0x1B4 54003 dynpool BACKUP TAPE LIST : 672
2008-09-17 15:02:16 0x1B4 54003 dynpool BACKUP DEVSP LIST : 16
2008-09-17 15:02:16 0x1B4 54003 dynpool BACKUP VOL IDX LIST : 128
2008-09-17 15:02:16 0x1B4 54003 dynpool BACKUP SRR QUEUE : 128
2008-09-17 15:02:16 0x1B4 54003 dynpool DYNP_K38_AUTOSAVE : 960
2008-09-17 15:02:16 0x1B4 54003 dynDATA DYND_K38_AUTOSAVE : 321
2008-09-17 15:02:16 0x1B4 19930 TASKING Kernel initialization completed
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 5
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:0
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 68
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:1
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 67
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:2
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 66
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:3
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 65
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:4
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 64
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:5
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 63
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:6
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 62
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:7
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 61
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:8
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 60
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:9
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 59
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:10
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 58
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:11
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 57
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:12
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 56
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:13
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 55
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:14
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 54
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:15
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 53
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:16
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 52
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:17
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 51
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:18
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 50
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:19
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 49
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:20
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 48
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:21
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 47
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:22
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 46
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:23
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 45
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:24
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 44
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:25
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 43
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:26
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 42
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:27
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 41
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:28
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 40
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:29
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 39
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:30
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 38
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:31
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 37
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:32
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 36
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:33
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 35
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:34
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 34
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:35
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 33
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:36
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 32
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:37
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 31
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:38
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 30
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:39
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 29
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:40
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 28
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:41
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 27
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:42
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 26
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:43
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 25
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:44
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 24
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:45
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 23
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:46
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 22
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:47
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 21
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:48
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 20
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:49
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 19
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:50
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 18
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:51
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 17
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:52
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 16
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:53
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 15
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:54
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 14
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:55
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 13
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:56
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 12
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:57
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 11
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:58
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 10
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:59
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 9
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:60
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 8
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:61
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 7
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:62
2008-09-17 15:02:16 0x1B4 20018 Pager Start TaskId: 6
2008-09-17 15:02:16 0x1B4 20019 Pager First DataCacheSegment:63
2008-09-17 15:02:16 0x5C4 19628 CONNECT REQUESTOR is rejecting connect request
2008-09-17 15:02:16 0x5C4 19628 CONNECT REQUESTOR is rejecting connect request
2008-09-17 15:02:17 0x5C4 19628 CONNECT REQUESTOR is rejecting connect request
2008-09-17 15:02:17 0x1B4 31 SrvTasks Permanently reserved 66 servertasks for 'Backup / Restore'.
2008-09-17 15:02:17 0x1B4 31 SrvTasks Permanently reserved 2 servertasks for 'Backup / Restore'.
2008-09-17 15:02:17 0x1B4 31 SrvTasks Permanently reserved 1 servertasks for 'Savepoint'.
2008-09-17 15:02:17 0xFB8 3 RunTime State changed from STARTING to ADMIN
2008-09-17 15:02:17 0xFB8 19601 DBSTATE SERVERDB is ready
We had three crashes separated by several days.
The knltrace of the first one showed a bad index, which was repaired.
After the third crash, MAXCPU was set to 1 and the CACHESIZE was lowered. We had no crash since.
I will see if I can publish the DDL. As for the exact query that led to the crash, we do not know it. We had several dozen clients inserting, updating and querying records on the same table.
regards,
Guillaume
> this is not for a SAP product. BTW, is it possible to buy a support contract for a community release ?
On the [MaxDB Infoday 2008|http://maxdb.sap.com/events/] a support offering was presented for customers that are actual SAP customers and want to get support for their NON-SAP-system-MaxDBs as well.
But if you are not at all a SAP customer, there is no support offering. I guess it's very much about questions of support infrastructure (e.g. system access) and the relative high costs that each problem of a "non-standard" might cause.
> Here is the start of the knldiag, with the kernel parameters
Thanks - always a good thing to have!
>
DATA_VOLUME_MODE_0001=NORMAL
> 2008-09-17 15:02:15 0x750 20235 RTE DATA_VOLUME_NAME_0001=E:\DATABASE_DATA\BASE_D0001
> 2008-09-17 15:02:15 0x750 20235 RTE DATA_VOLUME_SIZE_0001=3840000
> 2008-09-17 15:02:15 0x750 20235 RTE DATA_VOLUME_TYPE_0001=F
> 2008-09-17 15:02:15 0x750 20235 RTE LOG_IO_QUEUE=50
> 2008-09-17 15:02:15 0x750 20235 RTE LOG_MIRRORED=NO
> 2008-09-17 15:02:15 0x750 20235 RTE LOG_QUEUE_COUNT=0
> 2008-09-17 15:02:15 0x750 20235 RTE LOG_SEGMENT_SIZE=256000
> 2008-09-17 15:02:15 0x750 20235 RTE LOG_VOLUME_NAME_001=D:\DATABASE_LOG\BASE_L0001
> 2008-09-17 15:02:15 0x750 20235 RTE LOG_VOLUME_SIZE_001=768000
> 2008-09-17 15:02:15 0x750 20235 RTE LOG_VOLUME_TYPE_001=F
Ok, this has nothing to do with the crashes, but configuring only one big datavolume is not such a bright idea for MaxDB.
The whole I/O concept is based on having multiple files to access as well as the major part of the I/O parallelity is gained from that. So performance wise this is really not a good choice!
> 2008-09-17 15:02:15 0x750 20235 RTE OPTIMIZE_OPERATOR_JOIN_COSTFUNC=YES
Please set this parameter to NO.
> 2008-09-17 15:02:15 0x750 20235 RTE USED_MAX_LOG_QUEUE_COUNT=3
Make sure to set LOG_QUEUE_COUNT to 1 to avoid running into a bug that might render your LOG Backups useless!
Just change the parameter online and perform a data backup. After that you can be sure that you can recover the log backups.
>
> After the third crash, MAXCPU was set to 1 and the CACHESIZE was lowered. We had no crash since.
I cannot see any relation between this change and the crashes.
So I propose you revert these parameters.
> I will see if I can publish the DDL. As for the exact query that led to the crash, we do not know it. We had several dozen clients inserting, updating and querying records on the same table.
Ok, in this case you may want to activate the kernel trace with trace setting "DEFAULT" and save it after the database had crashed the next time.
If you can provide this trace perhaps the developers can figure out what is going wrong here.
Best regards,
Lars
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.