Error upgrading SapDB 7.3 to 7.6

[Former Member]

Hi,

I have a problem upgrading a SapDB instance 7.3 to 7.6. I used both the SDBUPD and SDBINST procedure to upgrade but both times I get the error below. Has anyone seen this error before?

The OS is CentOS 4.8 with the env variable LD_ASSUME_KERNEL=2.2.5 to get 7.3 to run.

The error occurs during the last step after the upgrade when I bring the database online.

SapDB 7.3 is installed with SDBINST and all the default options.

Regards,

Jan van Nunen

checking unpacked archive... ok

installation of MaxDB Server finished successfully Mo, Aug 30, 2010 at 17:29:15

changing permissions of database files...

finding instance type...

checking mmap support...

starting release already known

migration strategy already known

running finalize check...

looking for domain user...

current database state is OFFLINE

checking parameters...

switch database state to ADMIN

switch database state to ONLINE

cannot finish instance update for "XXXXXX"

current database state is OFFLINE

checking parameters...

switch database state to ADMIN

switch database state to ONLINE

cannot switch database mode, error during dbm command:

db_online

ERR

-24988,ERR_SQL: SQL error

-9407,System error: unexpected error

3,Database state: OFFLINE

20000,Assertion of state Flush history-directory failed!

20044,PAM::GetPage: pno=59556(Dynamic/Recoverable (perm)) acc=ForUpdate rel=Changed root=59556

6,bd13GetNode, Error code 9160 "page_in_wrong_tree"

20045,PAM::GetPage: next=992 last=992.

20048,Chain: root 59556 last 992 addressing: dyn recovery: perm

20044,Data_Page: pno=59556(Dynamic/Recoverable (perm)) acc=ForUpdate rel=Unchanged root=59556

20045,Data_ChainPage: next=992 last=992.

20000,Assertion of state Data_ChainFixSizeSpace::ReserveSpace: Lock() failed!

20057,Data_BaseFile: filetype=HistoryDirectory root=59556 Dynamic Recoverable (perm)

20066,dirfile.AppendHistoryFile() failed: registered files 1024, max used are 1024

looking for error messages in knldiag

...

2010-08-30 17:30:04 24968 ERR 51080 SYSERROR -9407 unexpected error

2010-08-30 17:30:04 24968 ERR 3 Admin Database state: OFFLINE

2010-08-30 17:30:04 24968 ERR 20000 Log + Assertion of state Flush history-directory failed!

2010-08-30 17:30:04 24968 ERR 20044 Data + PAM::GetPage: pno=59556(Dynamic/Recoverable (perm)) acc=ForUpdate rel=Changed root=59556

2010-08-30 17:30:04 24968 ERR 6 KernelCo + bd13GetNode, Error code 9160 "page_in_wrong_tree"

...

[Former Member]

Hi,

Did you solve this problem ,I face the same error when i upgrade sapdb 7.3.00.42 to maxdb 7.6.03.09

?

[former_member184473]

Hello,

>2010-08-30 17:30:04 24968 ERR 51080 SYSERROR -9407 unexpected error

>2010-08-30 17:30:04 24968 ERR 3 Admin Database state: OFFLINE

>2010-08-30 17:30:04 24968 ERR 20000 Log + Assertion of state Flush history-directory failed!

>2010-08-30 17:30:04 24968 ERR 20044 Data + PAM::GetPage: pno=59556(Dynamic/Recoverable (perm)) acc=ForUpdate >rel=Changed root=59556

>2010-08-30 17:30:04 24968 ERR 6 KernelCo + bd13GetNode, Error code 9160 "page_in_wrong_tree"

You can check note [839333|http://service.sap.com/sap/support/notes/839333] about the error "page_in_wrong_tree".

Regards,

Eduardo

[Former Member]

Hi,

Thanks for the reply, but I don't have a login for SAP service.

Regards,

Jan van Nunen