Ubuntu
maxdb-7.5.00 package

Database instance restart error

Bug #53333 reported by Martin Perina on 2006-07-18

Affects		Status	Importance	Assigned to	Milestone
	maxdb-7.5.00 (Ubuntu)	Invalid	Undecided	Unassigned

Bug Description

Hello,

I've a problem with MaxDB 7.5.00.34-2build1. After creation of an MaxDB instance, this instance cannot be started into ONLINE state, but it stops in ADMIN state.

This message appears In the knldiag.err:

2006-07-18 10:34:20 17849 ERR 20134 RTE Database automatic restart failed

The database instance is created with this script:

DBNAME="HYPROD"
DBSIZE=524288
LOGSIZE=65536
DBMUSR=dbm
DBMPWD=XXX
DBAUSR=dba
DBAPWD=XXX

dbmcli db_create ${DBNAME} ${DBMUSR},${DBMPWD}
dbmcli -d ${DBNAME} -u ${DBMUSR},${DBMPWD} <<EOF
param_startsession
param_init
param_put MAXUSERTASKS 50
param_put _UNICODE YES
param_put DEFAULT_CODE UNICODE
param_checkall
param_commitsession
param_addvolume 1 LOG /opt/maxdb-volumes/${DBNAME}/LOG_001 F ${LOGSIZE}
param_addvolume 1 DATA /opt/maxdb-volumes/${DBNAME}/DAT_001 F ${DBSIZE}
db_admin
db_activate ${DBAUSR},${DBAPWD}
load_systab -ud ${DBAPWD}
EOF

This database instance works fine in Breezy 7.5.00.30-3 version.

Contents of knldiag file:

---------------------=======-------------------------------------------------------------------------
TID Typ MsgID Label Message-Text
/>------------------------------------------------------------------
12781 INFO Version: 'Linux thread implementation is Linuxthreads'
12781 INFO Version: 'Linux thread implementation cannot set individual thread stack size'
12769 INFO Starting SERVERDB: 'HYPROD'
12773 INFO Date: 2006-07-18
12771 INFO Process ID: 17824
12772 INFO Owner: 'sdb'
12772 INFO Group: 'sdba'
12781 INFO Version: '32BIT Kernel'
12781 INFO Version: 'X32/LINUX 7.5.0 Build 034-000-DEB-000'
12781 INFO Version: 'FAST'
12806 INFO Machine: 'i686'
12775 INFO Processors: 4
12780 INFO DBROOT: '/var/lib/maxdb/data/wrk/HYPROD'
12780 INFO LD_LIBRARY_PATH: '/usr/lib/maxdb/7.5.00/lib:/usr/lib/maxdb/7.5.00/sap'
20227 RTE Dump of all kernel parameters start
20197 RTE Using mode NORMAL for data volume 1
20228 RTE _AK_DUMP_ALLOWED=YES
20228 RTE ALLOW_MULTIPLE_SERVERTASK_UKTS=NO
20228 RTE AUTO_RECREATE_BAD_INDEXES=NO
20228 RTE BACKUP_BLOCK_CNT=8
20228 RTE _BACKUP_HISTFILE=dbm.knl
20228 RTE _BACKUP_MED_DEF=dbm.mdf
20228 RTE CACHE_IN_SHARED_MEMORY=NO
20228 RTE CACHE_SIZE=10000
20228 RTE _CAT_CACHE_MINSIZE=262144
20228 RTE CAT_CACHE_SUPPLY=3264
20228 RTE CHECK_TABLE_WIDTH=NO
20228 RTE CONTROLPASSWORD=***
20228 RTE CONTROLUSERID=DBM
20228 RTE CONVERTER_REGIONS=8
20228 RTE _DATA_CACHE_RGNS=8
20228 RTE DATA_VOLUME_GROUPS=1
20228 RTE DATA_VOLUME_MODE_0001=NORMAL
20228 RTE DATA_VOLUME_NAME_0001=/opt/maxdb-volumes/HYPROD/DAT_001
20228 RTE DATA_VOLUME_SIZE_0001=524288
20228 RTE DATA_VOLUME_TYPE_0001=F
20228 RTE DATE_TIME_FORMAT=INTERNAL
20228 RTE DEADLOCK_DETECTION=4
20228 RTE DEFAULT_CODE=UNICODE
20228 RTE _DELAY_COMMIT=NO
20228 RTE _DELAY_LOGWRITER=0
20228 RTE DIAG_HISTORY_NUM=2
20228 RTE DIAG_HISTORY_PATH=/var/lib/maxdb/data/wrk/HYPROD/DIAGHISTORY
20228 RTE _DIAG_SEM=0
20228 RTE _DW_IO_AREA_FLUSH=50
20228 RTE _DW_IO_AREA_SIZE=50
20228 RTE _DW_LRU_TAIL_FLUSH=25
20228 RTE _DYN_TASK_STACK=NO
20228 RTE _EVENTFILE=knldiag.evt
20228 RTE _EVENTSIZE=0
20228 RTE _EVENT_ALIVE_CYCLE=0
20228 RTE EXPAND_COM_TRACE=NO
20228 RTE EXTERNAL_DUMP_REQUEST=NO
20228 RTE _FBM_LOW_IO_RATE=10
20228 RTE FBM_VOLUME_BALANCE=10
20228 RTE FBM_VOLUME_COMPRESSION=50
20228 RTE FORBID_LOAD_BALANCING=YES
20228 RTE FORMATTING_MODE=PARALLEL
20228 RTE FORMAT_DATAVOLUME=YES
20228 RTE HASHED_RESULTSET_CACHESIZE=262144
20228 RTE HASHED_RESULTSET=NO
20228 RTE HEAP_CHECK_LEVEL=0
20228 RTE HS_STORAGE_DLL=libhsscopy
20228 RTE HS_SYNC_INTERVAL=50
20228 RTE _IDXFILE_LIST_SIZE=2048
20228 RTE INIT_ALLOCATORSIZE=221184
20228 RTE INSTANCE_TYPE=OLTP
20228 RTE _IOPROCS_FOR_PRIO=0
20228 RTE _IOPROCS_PER_DEV=2
20228 RTE _IOPROCS_SWITCH=2
20228 RTE JOIN_MAXTAB_LEVEL4=16
20228 RTE JOIN_MAXTAB_LEVEL9=5
20228 RTE JOIN_OPERATOR_IMPLEMENTATION=YES
20228 RTE JOIN_SEARCH_LEVEL=0
20228 RTE JOIN_TABLEBUFFER=128
20228 RTE _KERNELDIAGFILE=knldiag
20228 RTE KERNELDIAGSIZE=800
20228 RTE _KERNELDUMPFILE=knldump
20228 RTE _KERNELTRACEFILE=knltrace
20228 RTE KERNELTRACESIZE=653
20228 RTE KERNELVERSION=KERNEL 7.5.0 BUILD 034-000-DEB-000
20228 RTE LOAD_BALANCING_CHK=0
20228 RTE LOAD_BALANCING_DIF=10
20228 RTE LOAD_BALANCING_EQ=5
20228 RTE LOCAL_REDO_LOG_BUFFER_SIZE=0
20228 RTE _LOCK_SUPPLY_BLOCK=100
20228 RTE LOG_BACKUP_TO_PIPE=NO
20228 RTE LOG_IO_QUEUE=50
20228 RTE LOG_MIRRORED=NO
20228 RTE LOG_SEGMENT_SIZE=21845
20228 RTE LOG_VOLUME_NAME_001=/opt/maxdb-volumes/HYPROD/LOG_001
20228 RTE LOG_VOLUME_SIZE_001=65536
20228 RTE LOG_VOLUME_TYPE_001=F
20228 RTE LRU_FOR_SCAN=NO
20228 RTE MAXBACKUPDEVS=2
20228 RTE MAXCPU=1
20228 RTE MAXDATAVOLUMES=11
20228 RTE _MAXEVENTS=100
20228 RTE _MAXEVENTTASKS=1
20228 RTE _MAXGARBAGE_COLL=0
20228 RTE MAXLOCKS=2920
20228 RTE MAXLOGVOLUMES=2
20228 RTE MAXPAGER=11
20228 RTE MAXRGN_REQUEST=300
20228 RTE MAXSERVERTASKS=21
20228 RTE _MAXTASK_STACK=400
20228 RTE _MAXTRANS=292
20228 RTE MAXUSERTASKS=50
20228 RTE MAXVOLUMES=14
20228 RTE MAX_HASHTABLE_MEMORY=5120
20228 RTE _MAX_MESSAGE_FILES=0
20228 RTE MAX_RETENTION_TIME=480
20228 RTE MAX_SERVERTASK_STACK=100
20228 RTE MAX_SINGLE_HASHTABLE_SIZE=512
20228 RTE MAX_SPECIALTASK_STACK=100
20228 RTE _MBLOCK_DATA_SIZE=32768
20228 RTE _MBLOCK_QUAL_SIZE=16384
20228 RTE _MBLOCK_STACK_SIZE=16384
20228 RTE _MBLOCK_STRAT_SIZE=8192
20228 RTE MCOD=NO
20228 RTE MEMORY_ALLOCATION_LIMIT=0
20228 RTE _MINREPLY_SIZE=4096
20228 RTE MIN_RETENTION_TIME=60
20228 RTE _MIN_SERVER_DESC=16
20228 RTE _MP_DISP_LOOPS=2
20228 RTE _MP_DISP_PRIO=NO
20228 RTE _MP_RGN_BUSY_WAIT=NO
20228 RTE _MP_RGN_DIRTY_READ=NO
20228 RTE MP_RGN_LOOP=0
20228 RTE _MP_RGN_PRIO=NO
20228 RTE _MP_RGN_QUEUE=YES
20228 RTE _MULT_IO_BLOCK_CNT=8
20228 RTE OMS_HEAP_BLOCKSIZE=10000
20228 RTE OMS_HEAP_COUNT=1
20228 RTE OMS_HEAP_LIMIT=0
20228 RTE OMS_HEAP_THRESHOLD=100
20228 RTE _OMS_REGIONS=0
20228 RTE _OMS_RGNS=25
20228 RTE OMS_STREAM_TIMEOUT=30
20228 RTE OMS_VERS_THRESHOLD=2097152
20228 RTE OPMSG1=/dev/console
20228 RTE OPMSG2=/dev/null
20228 RTE OPTIMIZE_FETCH_REVERSE=YES
20228 RTE OPTIMIZE_JOIN_OPERATOR_SORT=YES
20228 RTE OPTIMIZE_JOIN_OUTER=YES
20228 RTE OPTIMIZE_JOIN_PARALLEL_SERVERS=0
20228 RTE OPTIMIZE_OPERATOR_JOIN_COSTFUNC=YES
20228 RTE OPTIM_CACHE=NO
20228 RTE OPTIM_FIRST_ROWS=NO
20228 RTE OPTIM_INV_ONLY=YES
20228 RTE OPTIM_JOIN_FETCH=0
20228 RTE OPTIM_MAX_MERGE=500
20228 RTE _PACKET_SIZE=36864
20228 RTE _PAGE_SIZE=8192
20228 RTE PREALLOCATE_IOWORKER=NO
20228 RTE _PRIO_BASE_COM=10
20228 RTE _PRIO_BASE_IOC=80
20228 RTE _PRIO_BASE_RAV=80
20228 RTE _PRIO_BASE_REX=40
20228 RTE _PRIO_BASE_U2U=100
20228 RTE _PRIO_FACTOR=80
20228 RTE _READAHEAD_BLOBS=25
20228 RTE REQUEST_TIMEOUT=5000
20228 RTE _RESTART_TIME=600
20228 RTE _ROW_RGNS=8
20228 RTE _RTEDUMPFILE=rtedump
20228 RTE RUNDIRECTORY=/var/lib/maxdb/data/wrk/HYPROD
20228 RTE SEQUENCE_CACHE=1
20228 RTE _SERVERDB_FOR_SAP=YES
20228 RTE _SERVER_CMD_CACHE=22
20228 RTE _SERVER_DESC_CACHE=74
20228 RTE SESSION_TIMEOUT=900
20228 RTE SET_VOLUME_LOCK=YES
20228 RTE _SHAREDDYNDATA=10280
20228 RTE _SHAREDDYNPOOL=3658
20228 RTE SHAREDSQL_COMMANDCACHESIZE=32768
20228 RTE SHAREDSQL_EXPECTEDSTATEMENTCOUNT=1500
20228 RTE SHAREDSQL=NO
20228 RTE _SHMKERNEL=91663
20228 RTE SHOW_MAX_STACK_USE=NO
20228 RTE SIMULATE_VECTORIO=IF_OPEN_DIRECT_OR_RAW_DEVICE
20228 RTE SUPPRESS_CORE=YES
20228 RTE _SVP_1_CONV_FLUSH=NO
20228 RTE SYMBOL_DEMANGLING=NO
20228 RTE SYMBOL_RESOLUTION=YES
20228 RTE _TAB_RGNS=8
20228 RTE _TASKCLUSTER_01=tw;al;ut;2000*sv,100*bup;10*ev,10*gc;
20228 RTE _TASKCLUSTER_02=ti,100*dw;30000*us;
20228 RTE _TASKCLUSTER_03=compress
20228 RTE TRACE_PAGES_BUP=0
20228 RTE TRACE_PAGES_EV=2
20228 RTE TRACE_PAGES_GC=0
20228 RTE TRACE_PAGES_LW=5
20228 RTE TRACE_PAGES_PG=3
20228 RTE TRACE_PAGES_SV=5
20228 RTE TRACE_PAGES_TI=2
20228 RTE TRACE_PAGES_US=10
20228 RTE TRACE_PAGES_UT=5
20228 RTE _TRANS_RGNS=8
20228 RTE _UNICODE=YES
20228 RTE UPDATESTAT_SAMPLE_ALGO=0
20228 RTE USE_COROUTINES=YES
20228 RTE _USE_IOPROCS_ONLY=NO
20228 RTE USE_OPEN_DIRECT=NO
20228 RTE USE_STACK_ON_STACK=YES
20228 RTE USE_SYSTEM_PAGE_CACHE=YES
20228 RTE USE_UCONTEXT=YES
20228 RTE _UTILITY_PROTFILE=dbm.utl
20228 RTE UTILITY_PROTSIZE=100
20228 RTE VOLUMENO_BIT_COUNT=8
20228 RTE _WORKDATA_SIZE=8192
20228 RTE _WORKSTACK_SIZE=8192
20228 RTE XP_CONVERTER_REGIONS=0
20228 RTE XP_DATA_CACHE_RGNS=0
20228 RTE XP_MAXPAGER=0
20228 RTE XP_MP_RGN_LOOP=0
20229 RTE Dump of all kernel parameters done
17824 WNG 11489 PARAM Open system console '/dev/console' reports (13) Permission denied
17824 WNG 11489 PARAM Modify parameter OPMSG1 or enable write access to prevent this message
12770 INFO SERVERNODE: 'hyperion'
12932 INFO maximum cpu time: unlimited
12933 INFO maximum number of processes: unlimited
12891 INFO maximum core size: 0 MB
12892 INFO maximum number of open files: 1024
12934 INFO maximum file size: unlimited
12895 INFO maximum number of threads: 16384
12935 INFO maximum stack size: 1 MB
12936 INFO lockable memory size: unlimited
12893 INFO maximum virtual memory size: unlimited
12937 INFO resident set size size: unlimited
12894 INFO maximum heap size: unlimited
12898 ENVIRON Environment dump start
12898 ENVIRON DBROOT=/usr/lib/maxdb/7.5.00
12898 ENVIRON HOME=/root
12898 ENVIRON JAVA_HOME=/opt/j2sdk1.4.2
12898 ENVIRON LANG=cs_CZ.UTF-8
12898 ENVIRON LANGUAGE=cs_CZ:cs:en_US:en
12898 ENVIRON LD_ASSUME_KERNEL=2.4.1
12898 ENVIRON LD_LIBRARY_PATH=/usr/lib/maxdb/7.5.00/lib:/usr/lib/maxdb/7.5.00/sap
12898 ENVIRON LESSCLOSE=/usr/bin/lesspipe %s %s
12898 ENVIRON LESSOPEN=| /usr/bin/lesspipe %s
12898 ENVIRON LOGNAME=perina
12898 ENVIRON LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:su=37;41:sg
12898 ENVIRON =30;43:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;3
12898 ENVIRON 1:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=0
12898 ENVIRON 1;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35
12898 ENVIRON :*.png=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.avi=01;35:*.fli=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd
12898 ENVIRON =01;35:*.flac=01;35:*.mp3=01;35:*.mpc=01;35:*.ogg=01;35:*.wav=01;35:
12898 ENVIRON MAIL=/var/mail/root
12898 ENVIRON PATH=/sbin:/bin:/usr/sbin:/usr/bin
12898 ENVIRON PWD=/var/lib/maxdb/data/wrk/HYPROD
12898 ENVIRON SERVERDB=HYPROD
12898 ENVIRON SHELL=/bin/bash
12898 ENVIRON SHLVL=3
12898 ENVIRON SSH_CLIENT=192.168.1.176 37849 22
12898 ENVIRON SSH_CONNECTION=192.168.1.176 37849 192.168.1.2 22
12898 ENVIRON SSH_TTY=/dev/pts/0
12898 ENVIRON TERM=xterm
12898 ENVIRON USER=root
12898 ENVIRON _=/usr/lib/maxdb/programs/bin/x_start
12898 ENVIRON Environment dump completed
12883 DBSTATE Core dump suppressed
20210 RTE Memory allocation not limited
20211 RTE System page cache usage enabled
12927 TASKING Using coroutines for tasks
12927 TASKING Using UKT stack for coroutine stack
12927 TASKING Using ucontext_t for coroutine context
12692 TCLUSTER tw;al;ut;2000*sv,100*bup;10*ev,10*gc;ti,100*dw;30000*us;compress
12693 TCLUSTER number of 'BUP': 0
12693 TCLUSTER number of ' DW': 11
12693 TCLUSTER number of ' US': 50
12693 TCLUSTER number of ' SV': 21
12693 TCLUSTER number of ' EV': 1
12693 TCLUSTER number of ' GC': 0
12692 TCLUSTER Total Number of UKT 7
12692 TCLUSTER Number of UKT with User Tasks 1
12698 IPC Common RTE specific IPC key: 0x44010000
11536 init_shm attached shared section at 0x50000000
11537 init_shm shared section ends at 0x50068000
11521 PIPE_IO Operating system does not support fstat for input check of pipes
11522 PIPE_IO Input check for pipe with poll supported
11000 INITIAL Verified that open of needed 165 file descriptors is possible
12811 EVENTING Suppressing output to 'knldiag.evt' 0 pages
12812 EVENTING Eventbuffer 1 events 100 tasks
12815 EVENTING No AliveEvent generation
12769 INFO Starting SERVERDB: '+++++++++++++++++++++++++++++++++++++++++++++++++'
12769 INFO Starting SERVERDB: '+++++++++++++++++++ Kernel Forked +++++++++++++++'
12769 INFO Starting SERVERDB: 'HYPROD'
12771 INFO Process ID: 17828
12769 INFO Starting SERVERDB: '+++++++++++++++++++++++++++++++++++++++++++++++++'
12885 MEMORY 10000 Pages allocated for I/O buffer cache
12831 TRACE_IO Configured _MAX_MESSAGE_FILES:0
12832 TRACE_IO Disabled: No TraceMessagefiles wanted
12821 TASKING Thread 17830 starting
12821 TASKING Thread 17831 starting
12821 TASKING Thread 17832 starting
12821 TASKING Thread 17833 starting
12821 TASKING Thread 17834 starting
12821 TASKING Thread 17835 starting
12821 TASKING Thread 17836 starting
20204 RTE CONSOLE thread started
12821 TASKING Thread 17837 starting
11565 startup TIMER started
12821 TASKING Thread 17838 starting
11565 startup REQUESTOR started
12821 TASKING Thread 17839 starting
11565 startup DEV0 started
12821 TASKING Thread 17840 starting
12821 TASKING Thread 17841 starting
12627 TASKING UKT1 started
12821 TASKING Thread 17842 starting
12627 TASKING UKT2 started
12821 TASKING Thread 17843 starting
12627 TASKING UKT3 started
11554 COMMUNIC UKT3 attached big comseg at 0x45E4E000
11555 COMMUNIC UKT3 big comseg ends at 0x45E57088
12821 TASKING Thread 17844 starting
12627 TASKING UKT4 started
12821 TASKING Thread 17845 starting
12627 TASKING UKT5 started
11554 COMMUNIC UKT5 attached big comseg at 0x4606A000
11555 COMMUNIC UKT5 big comseg ends at 0x46073088
12821 TASKING Thread 17846 starting
12627 TASKING UKT6 started
12929 TASKING Task T1 started
12821 TASKING Thread 17847 starting
12627 TASKING UKT7 started
11554 COMMUNIC UKT7 attached big comseg at 0x4748E000
11555 COMMUNIC UKT7 big comseg ends at 0x47650FD8
11525 vdevsize Start formatting 0 pages
11527 vdevsize Finished formatting 654 pages
11000 vdevsize 'knltrace', 653 succeeded
12821 TASKING Thread 17848 starting
11597 IO Open 'knltrace' successfull, fd: 11
11565 startup DEVi started
11000 vattach 'knltrace' devno 0 T1 succeeded
20038 Admin Kernel state: 'ADMIN' reached
54003 dynpool DYNP_A51_CACHE : 1428
54003 dynpool AK51SIZES user + 1 : 51
54003 dynpool AK51SIZES headlist all : 204
54003 dynpool AK51SIZES headlist elem: 4
54003 dynpool AK51SIZES list all : 1224
54003 dynpool AK51SIZES list element : 24
54003 dynpool INDEX FileListItemSize : 8
54003 dynpool INDEX NumFileListItems : 2048
54003 dynpool INDEX FileListSizeAll : 16384
54003 dynpool INDEX FunnelItemSize : 8
54003 dynpool INDEX QueueItemPtrSize : 4
54003 dynpool INDEX QueueItemSize : 36
54003 dynpool INDEX SortItemSize : 16
54003 dynpool INDEX NumFunnelItems : 2048
54003 dynpool INDEX FunnelSizeAll : 131072
54003 dynpool DYNP_B49_IDXSIZE : 147456
12600 VERSION 'Kernel 7.5.0 Build 034-000-DEB-000'
71 Log Size of LocalRedoEntryBuffer/transactions: 0
54003 dynDATA DYND_K57_KB_PAGES : 11
54003 dynDATA BACKUP RESTART REC (8K): 1
54003 dynpool BACKUP TASK LIST : 208
54003 dynpool BACKUP TAPE LIST : 672
54003 dynpool BACKUP DEVSP LIST : 176
54003 dynpool BACKUP SRR QUEUE : 656
54003 dynpool DYNP_K38_SAVE_GLOB : 1712
54003 dynDATA DYND_K38_SAVE : 217
54003 dynDATA BACKUP RESTART REC (8K): 1
54003 dynpool BACKUP TASK LIST : 32
54003 dynpool BACKUP TAPE LIST : 672
54003 dynpool BACKUP DEVSP LIST : 16
54003 dynpool BACKUP SRR QUEUE : 128
54003 dynpool DYNP_K38_AUTOSAVE : 848
54003 dynDATA DYND_K38_AUTOSAVE : 41
54003 dynpool KB50 mdesc item size : 232
54003 dynpool KB90 mdesc items : 74
54003 dynpool KB90 mdesc list size : 17168
54003 dynpool KB90 mdesc list aligned: 17168
54003 dynpool KB90 packet items : 22
54003 dynpool KB90 packet desc size : 16
54003 dynpool KB90 packet desc list : 352
54003 dynpool KB90 packet size : 36656
54003 dynpool KB90 packetsize aligned: 36656
54003 dynpool KB90 packet list : 806432
54003 dynpool KB90 parent list : 1680
54003 dynpool KB90 kbfunction_task : 73
54003 dynpool KB90 parent items / 0.7: 104
54003 dynpool KB90 parent desc size : 16
54003 dynpool KB90 parentdesc aligned: 1664
54003 dynpool KB90 parent hash list : 416
54003 dynpool KB90 parenthash aligned: 416
54003 dynpool KB90 maxservertasks : 21
54003 dynpool KB90 server desc size : 24
54003 dynpool KB90 server list : 504
54003 dynpool KB90 serverlist aligned: 512
54003 dynpool DYNP_K90_DISTRIB : 826544
12929 TASKING Task T3 started
12929 TASKING Task T4 started
12929 TASKING Task T16 started
12929 TASKING Task T2 started
12929 TASKING Task T36 started
12929 TASKING Task T15 started
12929 TASKING Task T35 started
12929 TASKING Task T34 started
12929 TASKING Task T33 started
12929 TASKING Task T32 started
12929 TASKING Task T31 started
12929 TASKING Task T30 started
12929 TASKING Task T29 started
12929 TASKING Task T28 started
12929 TASKING Task T27 started
12929 TASKING Task T26 started
12929 TASKING Task T25 started
12929 TASKING Task T24 started
12929 TASKING Task T23 started
12929 TASKING Task T22 started
12929 TASKING Task T21 started
12929 TASKING Task T20 started
12929 TASKING Task T19 started
12929 TASKING Task T18 started
12929 TASKING Task T17 started
14 Pager Start TaskId: 4
15 Pager First DataCacheSegment:0
12929 TASKING Task T14 started
14 Pager Start TaskId: 14
15 Pager First DataCacheSegment:1
12929 TASKING Task T13 started
14 Pager Start TaskId: 13
15 Pager First DataCacheSegment:2
12929 TASKING Task T12 started
14 Pager Start TaskId: 12
15 Pager First DataCacheSegment:3
12929 TASKING Task T11 started
14 Pager Start TaskId: 11
15 Pager First DataCacheSegment:4
12929 TASKING Task T10 started
14 Pager Start TaskId: 10
15 Pager First DataCacheSegment:5
12929 TASKING Task T9 started
14 Pager Start TaskId: 9
15 Pager First DataCacheSegment:6
12929 TASKING Task T8 started
14 Pager Start TaskId: 8
15 Pager First DataCacheSegment:7
12929 TASKING Task T7 started
14 Pager Start TaskId: 7
15 Pager First DataCacheSegment:0
12929 TASKING Task T6 started
14 Pager Start TaskId: 6
15 Pager First DataCacheSegment:1
12929 TASKING Task T5 started
14 Pager Start TaskId: 5
15 Pager First DataCacheSegment:2
20207 RTE Kernel state changed from STARTING to ADMIN
/>========================= end of startup part ====================
11570 startup complete
12821 TASKING Thread 17849 starting
20214 RTE Database tries automatic restart
17849 ERR 20134 RTE Database automatic restart failed
11561 COMMUNIC Connecting T38 localhost.localdomain 0
12929 TASKING Task T38 started
11561 COMMUNIC Connected T38 localhost.localdomain 0
11560 COMMUNIC Releasing T38
12827 COMMUNIC wait for connection T38
11561 COMMUNIC Connecting T38 localhost.localdomain 0
12929 TASKING Task T38 started
11561 COMMUNIC Connected T38 localhost.localdomain 0
11560 COMMUNIC Releasing T38
12827 COMMUNIC wait for connection T38
/>------------------------- current write position -----------------

Contents of knldiag.err file:

--------------------------------------------------------------------------------
Date Time TID Typ MsgID Label Message-Text
--------------------------------------------------------------------------------
2006-07-18 10:32:19 --- Starting GMT 2006-07-18 08:32:19 7.5.0 Build 034-000-DEB-000
2006-07-18 10:34:07 ___ Stopping GMT 2006-07-18 08:34:07 7.5.0 Build 034-000-DEB-000
2006-07-18 10:34:16 --- Starting GMT 2006-07-18 08:34:16 7.5.0 Build 034-000-DEB-000
2006-07-18 10:34:20 17849 ERR 20134 RTE Database automatic restart failed

Revision history for this message

Kristian Rink (kawazu) wrote on 2006-12-08:

For what I have found out so far, MaxDB 7.5.00.* (same as 7.6.00.*) do per default rely upon LD_ASSUME_KERNEL in order to avoid some threading related issues (feel free to use the MaxDB mailing list archive or read here - http://www.mysqltalk.org/sap-db-not-working-on-redhat-phoebe-the-solution-vt71534.html - to see a few hints on that).

Basically, it boils down to the following, comparing Dapper (where it works) and Edgy (where it doesn't work). Used stock installations in both cases, and the error is the same no matter whether using MaxDB 7.5.00 or 7.6.00:

- box #1 (Ubuntu 6.06):

#> LD_ASSUME_KERNEL=2.4.1 x_server update

12916 XSERVER Found other running x_server with version 'X32/LINUX
7.5.0 Build 038-121-133-420'
12926 XSERVER Version after update 'X32/LINUX 7.5.0 Build
038-121-133-420'

- box #2 (Ubuntu 6.10):

#> LD_ASSUME_KERNEL=2.4.1 x_server status

x_server: error while loading shared libraries: libdl.so.2: cannot open
shared object file: No such file or directory

LD_ASSUME_KERNEL=2.4.something seems to be used by default in pre-built MaxDB packages found at the MaxDB download site, so it is not working so far. Unfortunately, with MaxDB in Ubuntu-universe being broken because of unmet dependencies, there is no MaxDB on Edgy at the moment. :/

Cheers,
Kristian

Revision history for this message

Martin Perina (martin-perina) wrote on 2006-12-08:

Sorry, but I don't think that the problem is in LD_ASSUME_KERNEL setting:

1) LD_ASSUME_KERNEL is set correctly in /etc/init.d/maxdb-server script

2) If LD_ASSUME_KERNEL is not set correctly, the database is unable to get even to admin state

3) The database works fine for me on breezy and dapper correctly. But the database is not starting correctly on dapper (as described earlier). But if i push the database from admin state to online state (using dbmcli command), everything seems to be ok and database works fine on dapper.

But you may be right, that there may be some problems with shared libraries and/or their versions.

Thanks

Martin

Jim Qode (jimqode) on 2007-07-05

Changed in maxdb-7.5.00:
status:	New → Confirmed

Revision history for this message

dino99 (9d9) wrote on 2016-01-29:

outdated version; no more support expected

Changed in maxdb-7.5.00 (Ubuntu):
status:	Confirmed → Invalid

Report a bug

This report contains Public information

Everyone can see this information.

You are

Subscribing...

Edit bug mail

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.

Ubuntumaxdb-7.5.00 package

Database instance restart error

Bug Description

Other bug subscribers

Remote bug watches

Ubuntu
maxdb-7.5.00 package