From: Eduardo Tortosa (edtgwanadoo.es)
Date: Mon Mar 13 2006 - 09:39:17 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Thank you

You're right, the problem was that .

The error message were good enough but i didn't know how to manage it.

Thanks Again...

Eduardo Tortosa

Zabach, Elke escribió:
> Eduardo Tortosa :
>
>> Thanks again (completing information):
>>
>> - When i recover and i start i get:
>>
>> -24988 Sql erro [info STATE -d]; -4004; Unknown table name :
>> INFO_STATE
>>
>> - When i load system tables i get the following:
>>
>>
>> <Local>:BGESTA3> load_systab -u dba,supercau -ud supercau
>> ERR
>> -24964,ERR_EXECUTE: error in program execution
>> 3,""c:\sdb\7600\bin\x_python" "c:\sdb\7600\env\lsystab.py" -R
>> "c:\sdb\7600" -d BGESTA3 -u dba,*"
>> Removing obsolete objects
>> Installing Loader tables
>> Installing messages and help
>> Installing SYSDBA tables
>> Installing comments for SYSDBA tables
>> Installing precompiler tables
>> Installing system tables for R3 backup information
>> Installing ODBC tables
>> Installing system tables for ORACLE (V7) mode
>> Installing data dictionary tables and views
>> Installing synonyms for oracle system tables
>> Installing comments on oracle sytem tables
>> Installing tables for WebAgent
>> Installing tables for Repository
>> Installing DOMAIN tables
>> ---------Traceback---------------
>> File "c:\sdb\7600\env\installib.py", line 410, in connectAndInstall
>> installRoutine (session, options)
>> File "c:\sdb\7600\env\lsystab.py", line 198, in install
>> "TRIGGER"
>> File "c:\sdb\7600\env\installib.py", line 172, in include
>> install (session, options)
>> File "c:\sdb\7600\env\XDD.py", line 1216, in install
>> createPubSynonym (session, 'ROLES')
>> File "c:\sdb\7600\env\XDD.py", line 165, in createPubSynonym
>> stopIfSqlNotOK (session, 'create public synonym "%s" for domain."%s"'
>> ---------Command-----------------
>> create public synonym "ROLES" for domain."ROLES"
>> ---------Error-------------------
>> loader.LoaderError: [-25010] SQL [-6000] Duplicate table name (error
>> position: 1)
>>
>>
>>
>
> Before trying to load systemtables, please do a
> Select * from synonyms where sysnonymname = 'ROLES'
> I think there is one, perhaps created by a user who is neither your sysdba nor DOMAIN.
> Please drop this public synonym and retry the load_systab.
>
> Elke
> SAP Labs Berlin
>
>
>
>
>> - The knldiag file contains :
>>
>> --------------------------------------------------------------------------
>> ------
>> Date Time TID(hex) Typ MsgID Label Message-Text
>> --------------------------------------------------------------------------
>> ------
>> 2006-03-10 18:57:43 0x1268 3 RunTime State changed from
>> STARTING to ADMIN
>> 2006-03-10 18:57:43 0x1268 19601 DBSTATE SERVERDB is ready
>>
>> ============================================ begin of write cycle
>> ==================
>>
>>
>> 2006-03-10 19:02:27 0x1260 19633 CONNECT Connect req. (T15,
>> Node:'', PID:5104)
>> 2006-03-10 19:02:27 0x1260 19615 VOLUMEIO Attaching volume
>> 'DAT_0001'
>> 2006-03-10 19:02:27 0xFFC 19613 DBSTATE I/O thread for
>> 'DAT_0001' started
>> 2006-03-10 19:02:27 0x1260 19617 VOLUMEIO Single I/O attach,
>> 'DAT_0001', UKT:7
>> 2006-03-10 19:02:27 0x1260 19615 VOLUMEIO Attaching volume
>> 'DAT_0002'
>> 2006-03-10 19:02:27 0xD0C 19613 DBSTATE I/O thread for
>> 'DAT_0002' started
>> 2006-03-10 19:02:27 0x1260 19617 VOLUMEIO Single I/O attach,
>> 'DAT_0002', UKT:7
>> 2006-03-10 19:02:27 0x1260 19615 VOLUMEIO Attaching volume
>> 'LOG_001'
>> 2006-03-10 19:02:27 0x124C 19613 DBSTATE I/O thread for
>> 'LOG_001' started
>> 2006-03-10 19:02:27 0x1260 19617 VOLUMEIO Single I/O attach,
>> 'LOG_001', UKT:7
>> 2006-03-10 19:02:27 0x1260 20017 Pager Start Read Converter
>> 2006-03-10 19:02:27 0x1260 20018 Pager Stop Read Converter,
>> Pages: 8 IO: 8
>> 2006-03-10 19:02:27 0x1260 53000 DATACACH Begin data cache restart
>> 2006-03-10 19:02:27 0x1260 54003 dynpool DATA_CACHE_REGIONS
>> : 8
>> 2006-03-10 19:02:27 0x1260 54003 dynpool B20_DATACACHE_HEAD
>> : 79784
>> 2006-03-10 19:02:27 0x1260 54003 dynpool DATACACHE head num
>> item: 9973
>> 2006-03-10 19:02:27 0x1260 54003 dynpool DATACACHE head item
>> siz: 8
>> 2006-03-10 19:02:27 0x1260 54003 dynpool DATACACHE task queue
>> : 2272
>> 2006-03-10 19:02:27 0x1260 54003 dynpool US + SV + DW + 8
>> : 142
>> 2006-03-10 19:02:27 0x1260 54003 dynpool DATACACHE taskq elem
>> : 16
>> 2006-03-10 19:02:27 0x1260 54003 dynpool B20_DATACACHE_TASKQ
>> : 82056
>> 2006-03-10 19:02:27 0x1260 54003 dynDATA DATA_CACHE_PAGES
>> : 639
>> 2006-03-10 19:02:27 0x1260 54003 dynpool B20_DATACACHE_CB
>> : 46008
>> 2006-03-10 19:02:27 0x1260 54003 dynpool DATACACHE num cblocks
>> : 639
>> 2006-03-10 19:02:27 0x1260 54003 dynpool DATACACHE cblock size
>> : 72
>> 2006-03-10 19:02:27 0x1260 54003 dynpool DYNP_B20_DATACACHE
>> :1024512
>> 2006-03-10 19:02:27 0x1260 54003 dynDATA DYND_B20_DATACACHE
>> : 5112
>> 2006-03-10 19:02:27 0x1260 53000 DATACACH Finish data cache
>> restart
>> 2006-03-10 19:02:27 0x1260 53000 B*TREE Blob file directory
>> restart successful
>> 2006-03-10 19:02:27 0x1260 7 FileDir File directory
>> restarting
>> 2006-03-10 19:02:27 0x1260 8 FileDir File directory restart
>> completed
>> 2006-03-10 19:02:27 0x1260 20061 Log History: 50 (50) files
>> existing
>> 2006-03-10 19:02:27 0x1260 20064 Log History: all history
>> files registered, GC is ready
>> 2006-03-10 19:02:27 0x1260 54003 dynpool DYNP_K51_LOCK_LIST
>> : 943376
>> 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK maxlocks
>> : 3080
>> 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK items
>> : 11700
>> 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK Regions
>> : 24
>> 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK TransRegions
>> : 8
>> 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK RegionGlob+Space
>> : 3072
>> 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK TransGlob
>> : 640
>> 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK SupplyItemsPerRgn
>> : 100
>> 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK SupplySize
>> : 172800
>> 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK RowHash entries
>> : 3080
>> 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK TabHash entries
>> : 616
>> 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK Row+Tab hash size
>> : 14976
>> 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK Trans entries
>> : 312
>> 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK trans_list size
>> : 59904
>> 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK TransPtrList
>> : 1248
>> 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK TransHash entries
>> : 312
>> 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK TransHash size
>> : 1280
>> 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK
>> SupplyPoolSegments: 93
>> 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK SupplyPoolSize
>> : 671472
>> 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK ObjColl_list size
>> : 9984
>> 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK ObjReq_list size
>> : 6240
>> 2006-03-10 19:02:27 0x1260 20006 Log 1 queues, flushmode is
>> 'MaximizeSafety', devstate is 'HistoryLost'
>> 2006-03-10 19:02:27 0x1260 20007 Log Oldest not saved is
>> ioseq NIL off 1
>> 2006-03-10 19:02:27 0x1260 20008 Log First known on
>> LogVolume is ioseq 0 off 1
>> 2006-03-10 19:02:27 0x1260 20005 Log Restart from ioseq
>> 1191 off 535 to ioseq 1191 off 535
>> 2006-03-10 19:02:27 0x1260 20010 Log Result after checking
>> the log device: 'Ok'
>> 2006-03-10 19:02:27 0x184 9 Log The number of active
>> logging-queues has been increased to 1
>> 2006-03-10 19:02:27 0x1260 53000 OBJECT Restarted Garbage coll:
>> 0
>> 2006-03-10 19:02:27 0xE30 7 Restart recovering log from
>> log_volume from IOSeq: '1191'
>> 2006-03-10 19:02:28 0xE30 20044 Log normal end of log
>> found at off 535 lastseq 1191.
>> 2006-03-10 19:02:28 0xE30 20012 Log
>> last-redo-
>> read#1:TR4294967295(525)[1191]535.24'SavepointEntry':20060310:185725
>> 2006-03-10 19:02:28 0x1260 1 Savepoin Savepoint (Restart)
>> started by T15
>> 2006-03-10 19:02:28 0x1260 31 SrvTasks Permanently reserved 1
>> servertasks for 'Savepoint'.
>> 2006-03-10 19:02:28 0xE30 53000 OBJECT Stop active garbage
>> coll: 0
>> 2006-03-10 19:02:28 0xE30 53000 OBJECT Garbage coll stopped: 0
>> 2006-03-10 19:02:28 0xE30 20005 Pager SVP(1) Start Write Data
>> 2006-03-10 19:02:28 0xE30 20006 Pager SVP(1) Stop Data IO,
>> Pages: 50 IO: 22
>> 2006-03-10 19:02:28 0xE30 20007 Pager SVP(2) Wait for last
>> task: 82
>> 2006-03-10 19:02:28 0xE30 20008 Pager SVP(2) Stop Wait for
>> last task, Pages: 0 IO: 0
>> 2006-03-10 19:02:28 0xE30 53070 SAVPOINT B20PREPARE_SVP: 527
>> 2006-03-10 19:02:28 0xE30 53000 OBJECT Restarted Garbage coll:
>> 1
>> 2006-03-10 19:02:28 0xE30 20009 Pager SVP(3) Start Write Data
>> 2006-03-10 19:02:29 0xE30 20010 Pager SVP(3) Stop Data IO,
>> Pages: 2 IO: 1
>> 2006-03-10 19:02:29 0xE30 20011 Pager SVP(3) Start Write
>> Converter
>> 2006-03-10 19:02:29 0xE30 20012 Pager SVP(3) Stop Converter
>> IO, Pages: 8 IO: 8
>> 2006-03-10 19:02:29 0xE30 53071 SAVPOINT B20SVP_COMPLETED: 527
>> 2006-03-10 19:02:29 0x1260 20037 Admin Kernel state: 'REDO
>> LOG' finished
>> 2006-03-10 19:02:29 0x1260 54000 OBJECT c:\sdb\7600\pgm\liboms
>> 2006-03-10 19:02:29 0x1260 3 RunTime State changed from
>> ADMIN to ONLINE
>> 2006-03-10 19:02:29 0x1260 20217 RTE Used physical memory
>> 213 MByte
>> 2006-03-10 19:02:29 0x1260 20039 Admin Kernel state: 'ONLINE'
>> reached
>> 2006-03-10 19:02:29 0x1260 19651 CONNECT Connection released, T15
>> 2006-03-10 19:02:29 0x1260 19633 CONNECT Connect req. (T16,
>> Node:'', PID:5104)
>> 2006-03-10 19:02:29 0x1260 19633 CONNECT Connect req. (T17,
>> Node:'', PID:5104)
>> 2006-03-10 19:02:29 0x1260 19651 CONNECT Connection released, T17
>> 2006-03-10 19:02:29 0x1260 19651 CONNECT Connection released, T16
>> 2006-03-10 19:02:29 0x1260 19633 CONNECT Connect req. (T18,
>> Node:'', PID:5104)
>> 2006-03-10 19:02:29 0x1260 19651 CONNECT Connection released, T18
>> 2006-03-10 19:02:29 0x1260 19633 CONNECT Connect req. (T19,
>> Node:'', PID:5104)
>> 2006-03-10 19:02:29 0x1260 19651 CONNECT Connection released, T19
>> 2006-03-10 19:02:52 0x1260 19633 CONNECT Connect req. (T20,
>> Node:'', PID:5104)
>> 2006-03-10 19:02:52 0x1260 19633 CONNECT Connect req. (T21,
>> Node:'', PID:5104)
>> 2006-03-10 19:02:52 0x1260 19651 CONNECT Connection released, T21
>> 2006-03-10 19:02:52 0x1260 19651 CONNECT Connection released, T20
>> 2006-03-10 19:02:52 0x1260 19633 CONNECT Connect req. (T22,
>> Node:'', PID:5104)
>> 2006-03-10 19:02:52 0x1260 19651 CONNECT Connection released, T22
>> 2006-03-10 19:02:52 0x1260 19633 CONNECT Connect req. (T23,
>> Node:'', PID:5104)
>> 2006-03-10 19:02:52 0x1260 19651 CONNECT Connection released, T23
>> 2006-03-10 19:03:12 0x1260 19633 CONNECT Connect req. (T24,
>> Node:'', PID:5104)
>> 2006-03-10 19:03:12 0x1260 19633 CONNECT Connect req. (T25,
>> Node:'', PID:5104)
>> 2006-03-10 19:03:12 0x1260 19651 CONNECT Connection released, T25
>> 2006-03-10 19:03:12 0x1260 19651 CONNECT Connection released, T24
>> 2006-03-10 19:03:12 0x1260 19633 CONNECT Connect req. (T26,
>> Node:'', PID:5104)
>> 2006-03-10 19:03:12 0x1260 19651 CONNECT Connection released, T26
>> 2006-03-10 19:03:12 0x1260 19633 CONNECT Connect req. (T27,
>> Node:'', PID:5104)
>> 2006-03-10 19:03:12 0x1260 19651 CONNECT Connection released, T27
>> -------------------------------------------- current write position
>> ----------------
>>
>> But i always get the message saying " .. Unknown table name: INFO_STATE
>> .." in dbmgui, and from SQLSTUDIO cannot access anything.
>>
>>
>>
>>
>> Döhr, Markus ICC-H escribió:
>>
>>>> When i recover a 7.5.0.31 with initialization over a 7.6.0.16, the
>>>> database seems to be on-line but i always get an error
>>>> 'CANNOT FIND INFO_STATE' the database is unusable.
>>>>
>>>>
>>> Did you load the system tables after the recover finished (on 7.6)?
>>>
>>>
>>>
>>>> If i recover without initialization i get messages saying
>>>> that more tasks are needed, but cannot recover neither the
>>>> log getting more error messages.
>>>>
>>>>
>>> What'S the exact error message you're getting in knldiag?
>>>
>>>
>>>
>>> Greetz,
>>>
>>> SIEGENIA-AUBI KG
>>> Informationswesen
>>>
>>> i.A.
>>>
>>> Markus Döhr
>>> SAP-CC/BC, SAPDB-DBA
>>>
>>> Tel.: +49 6503 917-152
>>> Fax: +49 6503 917-7152
>>> E-Mail: markus.doehrsiegenia-aubi.com
>>> Internet: http://www.siegenia-aubi.com
>>>
>>>
>>>
>>
>> --
>> MaxDB Discussion Mailing List
>> For list archives: http://lists.mysql.com/maxdb
>> To unsubscribe: http://lists.mysql.com/maxdb?unsub=elke.zabachsap.com
>>
>>
>
>
>

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]