cancel
Showing results for 
Search instead for 
Did you mean: 

-24895 error after suddenly power down

Former Member
0 Kudos

Hi experts,

After suddenly power down - I can't start up my Db instance. All the time I receive the error -24895.

I able to create new instance and run it, but corrupted one - contains important data for me an I want back it to life.

I added successfully new data/log volumes to corrupted database but it didn't solve the problem. The database may be set to "Admin" mode, but I can't pass it to online mode.

Database properties:

Version - 7.5.0 Build 015-123-074-675

OS: Windows XP SP2

knldiag.err

-


Date Time TID(hex) Typ MsgID Label Message-Text

-


2010-01-20 10:09:41 --- Starting GMT 2010-01-20 10:09:41 7.5.0 Build 015-123-074-675

2010-01-21 15:21:49 0x818 ERR 18431 MESSAGES Could not write to event log, rc = 5

2010-01-21 15:26:58 --- Starting GMT 2010-01-21 15:26:58 7.5.0 Build 015-123-074-675

2010-01-22 10:17:06 0x2C4 ERR 18431 MESSAGES Could not write to event log, rc = 5

2010-01-22 10:19:01 --- Starting GMT 2010-01-22 10:19:01 7.5.0 Build 015-123-074-675

2010-01-22 14:32:57 0x2B4 ERR 18431 MESSAGES Could not write to event log, rc = 5

2010-01-22 14:38:33 --- Starting GMT 2010-01-22 14:38:33 7.5.0 Build 015-123-074-675

2010-01-22 16:01:58 0x1D8 ERR 18431 MESSAGES Could not write to event log, rc = 5

2010-01-22 16:06:52 --- Starting GMT 2010-01-22 16:06:52 7.5.0 Build 015-123-074-675

2010-01-25 07:28:16 0x128 ERR 18431 MESSAGES Could not write to event log, rc = 5

2010-01-25 07:32:21 --- Starting GMT 2010-01-25 07:32:21 7.5.0 Build 015-123-074-675

2010-03-26 13:37:40 --- Starting GMT 2010-03-26 13:37:40 7.5.0 Build 015-123-074-675

2010-04-07 08:28:13 --- Starting GMT 2010-04-07 08:28:13 7.5.0 Build 015-123-074-675

2010-04-07 09:35:18 --- Starting GMT 2010-04-07 09:35:18 7.5.0 Build 015-123-074-675

2010-04-07 09:35:32 0x568 ERR 45 Log read: offset 45295 expected queue sequence 1 found 12235

2010-04-07 10:55:20 --- Starting GMT 2010-04-07 10:55:20 7.5.0 Build 015-123-074-675

2010-04-07 10:55:40 0x570 ERR 45 Log read: offset 45295 expected queue sequence 1 found 12235

2010-04-07 11:59:23 --- Starting GMT 2010-04-07 11:59:23 7.5.0 Build 015-123-074-675

2010-04-07 11:59:34 0x718 ERR 45 Log read: offset 45295 expected queue sequence 1 found 12235

2010-04-07 12:07:00 --- Starting GMT 2010-04-07 12:07:00 7.5.0 Build 015-123-074-675

2010-04-07 12:07:12 0xC08 ERR 45 Log read: offset 45295 expected queue sequence 1 found 12235

2010-04-07 12:17:58 --- Starting GMT 2010-04-07 12:17:58 7.5.0 Build 015-123-074-675

2010-04-07 12:18:22 0x5F8 ERR 45 Log read: offset 45295 expected queue sequence 1 found 12235

2010-04-07 13:18:07 --- Starting GMT 2010-04-07 13:18:07 7.5.0 Build 015-123-074-675

2010-04-07 13:18:21 0x21C ERR 45 Log read: offset 45295 expected queue sequence 1 found 12235

2010-04-07 14:11:55 --- Starting GMT 2010-04-07 14:11:55 7.5.0 Build 015-123-074-675

2010-04-07 14:12:08 0xA50 ERR 45 Log read: offset 45295 expected queue sequence 1 found 12235

2010-04-07 14:43:31 --- Starting GMT 2010-04-07 14:43:31 7.5.0 Build 015-123-074-675

2010-04-07 14:43:59 0xCC0 ERR 45 Log read: offset 45295 expected queue sequence 1 found 12235

2010-04-07 15:22:34 --- Starting GMT 2010-04-07 15:22:34 7.5.0 Build 015-123-074-675

2010-04-07 15:22:47 0xE28 ERR 45 Log read: offset 45295 expected queue sequence 1 found 12235

2010-04-07 15:28:19 --- Starting GMT 2010-04-07 15:28:19 7.5.0 Build 015-123-074-675

2010-04-07 15:28:32 0xC20 ERR 45 Log read: offset 45295 expected queue sequence 1 found 12235

2010-04-07 15:42:35 --- Starting GMT 2010-04-07 15:42:35 7.5.0 Build 015-123-074-675

2010-04-07 15:42:48 0xABC ERR 45 Log read: offset 45295 expected queue sequence 1 found 12235

2010-04-07 15:47:03 --- Starting GMT 2010-04-07 15:47:03 7.5.0 Build 015-123-074-675

2010-04-07 15:47:17 0x6A4 ERR 45 Log read: offset 45295 expected queue sequence 1 found 12235

2010-04-07 15:59:45 --- Starting GMT 2010-04-07 15:59:45 SLOW 7.5.0 Build 015-123-074-675

2010-04-07 16:02:35 0xFAC ERR 45 Log Log_VolumeIterator.cpp:316

2010-04-07 16:02:35 0xFAC ERR 45 Log 2010-04-07 16:02:35.437 Log ERROR 45

2010-04-07 16:02:35 0xFAC ERR 45 Log read: offset 45295 expected queue sequence 1 found 12235

2010-04-07 16:05:36 --- Starting GMT 2010-04-07 16:05:36 7.5.0 Build 015-123-074-675

2010-04-07 16:05:48 0xDB0 ERR 45 Log read: offset 45295 expected queue sequence 1 found 12235

2010-04-07 16:16:03 --- Starting GMT 2010-04-07 16:16:03 7.5.0 Build 015-123-074-675

2010-04-07 16:16:16 0xE9C ERR 45 Log read: offset 45295 expected queue sequence 1 found 12235

2010-04-07 17:08:49 --- Starting GMT 2010-04-07 17:08:49 7.5.0 Build 015-123-074-675

2010-04-07 17:09:02 0xFC8 ERR 45 Log read: offset 45295 expected queue sequence 1 found 12235

2010-04-07 17:17:56 --- Starting GMT 2010-04-07 17:17:56 7.5.0 Build 015-123-074-675

2010-04-07 17:18:08 0x240 ERR 45 Log read: offset 45295 expected queue sequence 1 found 12235

2010-04-07 17:19:17 --- Starting GMT 2010-04-07 17:19:17 7.5.0 Build 015-123-074-675

2010-04-07 17:19:28 0xB30 ERR 45 Log read: offset 45295 expected queue sequence 1 found 12235

2010-04-08 09:10:57 --- Starting GMT 2010-04-08 09:10:57 7.5.0 Build 015-123-074-675

2010-04-08 09:15:21 --- Starting GMT 2010-04-08 09:15:21 7.5.0 Build 015-123-074-675

2010-04-08 09:15:34 0x36C ERR 45 Log read: offset 45295 expected queue sequence 1 found 12235

2010-04-08 09:39:04 --- Starting GMT 2010-04-08 09:39:04 7.5.0 Build 015-123-074-675

2010-04-08 09:39:23 0x688 ERR 45 Log read: offset 45295 expected queue sequence 1 found 12235

2010-04-08 10:04:29 --- Starting GMT 2010-04-08 10:04:29 7.5.0 Build 015-123-074-675

2010-04-08 10:04:43 0xB10 ERR 45 Log read: offset 45295 expected queue sequence 1 found 12235

dbm.prt:

-


Date Time TID(hex) Typ MsgID Label Message

-


2010-01-20 10:13:27 0x00000ce8 0 DBM command backup_save "CG81_Backup" DATA RECOVERY

2010-01-20 10:13:37 0x00000ce8 0 DBM command backup_save "CG81_LogBackup" LOG RECOVERY

2010-01-20 10:13:46 0x00000ce8 0 DBM command autosave_on

2010-01-20 10:14:22 0x00000b64 0 DBM command param_put PACKETSIZE 131072

2010-01-20 10:14:22 0x00000b64 0 DBM command param_checkall SUPPORT

2010-01-20 10:14:22 0x00000b64 0 DBM command param_commitsession NOCLOSE

2010-04-07 13:18:03 0x0000014c 0 DBM command db_online -f

2010-04-07 13:18:22 0x0000014c ERR -24895 DBM ERR_SHUTDOWN: shutdown of database occured

0x0000014c ERR -24895 DBM -71,connection broken

2010-04-07 14:11:51 0x0000014c 0 DBM command db_online -f -u 20100407 142047

2010-04-07 14:12:09 0x0000014c ERR -24895 DBM ERR_SHUTDOWN: shutdown of database occured

0x0000014c ERR -24895 DBM -71,connection broken

2010-04-07 14:43:27 0x0000014c 0 DBM command db_admin -f

2010-04-07 14:43:59 0x0000014c 0 DBM command db_online -f

2010-04-07 14:44:00 0x0000014c ERR -24895 DBM ERR_SHUTDOWN: shutdown of database occured

0x0000014c ERR -24895 DBM -71,connection broken

2010-04-07 15:22:29 0x00000294 0 DBM command db_online -f

2010-04-07 15:22:48 0x00000294 ERR -24895 DBM ERR_SHUTDOWN: shutdown of database occured

0x00000294 ERR -24895 DBM -71,connection broken

2010-04-07 15:28:15 0x00000294 0 DBM command db_online -f

2010-04-07 15:28:33 0x00000294 ERR -24895 DBM ERR_SHUTDOWN: shutdown of database occured

0x00000294 ERR -24895 DBM -71,connection broken

2010-04-07 15:42:31 0x00000294 0 DBM command db_online -f

2010-04-07 15:42:49 0x00000294 ERR -24895 DBM ERR_SHUTDOWN: shutdown of database occured

0x00000294 ERR -24895 DBM -71,connection broken

2010-04-07 15:46:59 0x00000294 0 DBM command db_online -f

2010-04-07 15:47:18 0x00000294 ERR -24895 DBM ERR_SHUTDOWN: shutdown of database occured

0x00000294 ERR -24895 DBM -71,connection broken

2010-04-07 15:53:20 0x00000294 0 DBM command trace_show

2010-04-07 15:59:40 0x00000294 0 DBM command db_start -s

2010-04-07 16:02:34 0x00000294 0 DBM command db_online -s

2010-04-07 16:02:36 0x00000294 ERR -24895 DBM ERR_SHUTDOWN: shutdown of database occured

0x00000294 ERR -24895 DBM -71,connection broken

2010-04-07 16:05:27 0x00000294 0 DBM command db_restart -f

2010-04-07 16:05:49 0x00000294 ERR -24895 DBM ERR_SHUTDOWN: shutdown of database occured

0x00000294 ERR -24895 DBM -71,connection broken

2010-04-07 16:12:52 0x00000294 0 DBM command db_stop

2010-04-07 16:14:21 0x00000294 0 DBM command dban_stop

2010-04-07 16:14:21 0x00000294 ERR -24936 DBM ERR_DBNORUN: database is not running

2010-04-07 16:15:54 0x00000294 0 DBM command db_restart -f

2010-04-07 16:16:17 0x00000294 ERR -24895 DBM ERR_SHUTDOWN: shutdown of database occured

0x00000294 ERR -24895 DBM -71,connection broken

2010-04-07 17:08:45 0x00000294 0 DBM command db_online -f

2010-04-07 17:09:03 0x00000294 ERR -24895 DBM ERR_SHUTDOWN: shutdown of database occured

0x00000294 ERR -24895 DBM -71,connection broken

2010-04-08 09:10:53 0x00000f30 0 DBM command db_admin

2010-04-08 09:14:27 0x00000f30 ERR -24977 DBM ERR_COMMAND: unknown command "util_activate"

2010-04-08 09:15:01 0x00000f30 0 DBM command db_offline

2010-04-08 09:15:17 0x00000f30 0 DBM command db_online

2010-04-08 09:15:35 0x00000f30 ERR -24895 DBM ERR_SHUTDOWN: shutdown of database occured

0x00000f30 ERR -24895 DBM -71,connection broken

2010-04-08 10:04:25 0x00000fc0 0 DBM command db_online -f

2010-04-08 10:04:44 0x00000fc0 ERR -24895 DBM ERR_SHUTDOWN: shutdown of database occured

0x00000fc0 ERR -24895 DBM -71,connection broken

I can supply you more info if you need.

Accepted Solutions (1)

Accepted Solutions (1)

lbreddemann
Active Contributor
0 Kudos

> After suddenly power down - I can't start up my Db instance. All the time I receive the error -24895.

> I able to create new instance and run it, but corrupted one - contains important data for me an I want back it to life.

> I added successfully new data/log volumes to corrupted database but it didn't solve the problem. The database may be set to "Admin" mode, but I can't pass it to online mode.

> Database properties:

> Version - 7.5.0 Build 015-123-074-675

> OS: Windows XP SP2

--> Outdated - so very much outdated!

> knldiag.err

> 2010-04-08 09:39:04 --- Starting GMT 2010-04-08 09:39:04 7.5.0 Build 015-123-074-675

> 2010-04-08 09:39:23 0x688 ERR 45 Log read: offset 45295 expected queue sequence 1 found 12235

No wonder adding volumes did not solve the issue.

Basically the error message says: "Hey, I expect the start of the log information at this very location in the log area, but when I read it I get a completely different log page!".

This looks like a "lost I/O" happened due to the shutdown.

An easy way out of this - if you can accept to loose all log-information that happened between the last savepoint and the crash (usually this is about 10 minutes max.) - is to:

a) take a full data backup in admin mode

b) perform a "recovery with initialization" with this newly created backup.

The log area will be re-initialized by this and your data will be available.

regards,

Lars

Former Member
0 Kudos

Thank you a lot.

Your answer solved the problem.

Answers (0)