eseutil recovery fails - database with same signature in use (Full Version)

All Forums >> [Microsoft Exchange 2003] >> Information Stores



Message


ccsjst -> eseutil recovery fails - database with same signature in use (28.Aug.2011 6:06:18 AM)

I am trying to fix exchange problems after running out of space on sbs-02 server C; drive.
Its a simple single server setup with about 20 users
Sadly they no longer have access to email
Exchange System manager shows mails stores all unmounted.
Mount command fails
Event 9175 reported in app log - The Microsoft Exchange Server computer is not available.

Ran eseutil
>eseutil.exe" /G innoteq.edb
>Checking database integrity.
>The database is not up-to-date. This operation may find that
>this database is corrupt because data from the log files has
>yet to be placed in the database.
>To ensure the database is up-to-date please use the 'Recovery' operation.
>Operation terminated with error -550 (JET_errDatabaseDirtyShutdown, Database was
>not shutdown cleanly. Recovery must first be run to properly complete database
>operations for the previous shutdown.) after 18.32 seconds.

Sounds easy so try to run recovery
>"C:\Program Files\Exchsrvr\bin\eseutil.exe" /r E00 /i
>-1222 JET_errDatabaseSignInUse, Database with same signature in use
>JET_errDatabaseSignInUse

>The database with the same signature is already in use.

Have googled for hours with no luck, results suggest unmounting database but they are apparently dismounted according to exchange system manager.
Rebooting makes no difference
eseutil /ml shows all log files are fine
All suggestions gratefully received.
John (newbie)




Gulab -> RE: eseutil recovery fails - database with same signature in use (28.Aug.2011 8:04:41 AM)

Run esetuil /mh on the database and check what are the log files are required. If you have the required log files than run eseutil /r

But before running /r make sure that you move all the log files to different location except those which are required by the database.

What is the available space you have on the database drive?

Post the update.




ccsjst -> RE: eseutil recovery fails - database with same signature in use (28.Aug.2011 8:34:50 AM)

Thanks Gulab, before I go further can you comment on 'dirty shutdown' diagnostic please
john


C:\Program Files\Exchsrvr\bin>eseutil /mh "c:\Program Files\Exchsrvr\MDBDATA\in
oteq.edb"

Microsoft(R) Exchange Server Database Utilities
Version 6.5
Copyright (C) Microsoft Corporation. All Rights Reserved.

Initiating FILE DUMP mode...
Database: c:\Program Files\Exchsrvr\MDBDATA\innoteq.edb

File Type: Database
Format ulMagic: 0x89abcdef
Engine ulMagic: 0x89abcdef
Format ulVersion: 0x620,11
Engine ulVersion: 0x620,11
Created ulVersion: 0x620,9
DB Signature: Create time:09/03/2007 15:19:37 Rand:8561476 Computer:
cbDbPage: 4096
dbtime: 33056411 (0x1f8669b)
State: Dirty Shutdown
Log Required: 16555-16555 (0x40ab-0x40ab)
Streaming File: Yes
Shadowed: Yes
Last Objid: 30916
Scrub Dbtime: 0 (0x0)
Scrub Date: 00/00/1900 00:00:00
Repair Count: 0
Repair Date: 00/00/1900 00:00:00
Old Repair Count: 0
Last Consistent: (0x409C,607,7C) 08/25/2011 07:40:04
Last Attach: (0x409C,607,AE) 08/25/2011 07:40:16
Last Detach: (0x0,0,0) 00/00/1900 00:00:00
Dbid: 2
Log Signature: Create time:09/03/2007 15:19:30 Rand:8576003 Computer:
OS Version: (5.2.3790 SP 2)

Previous Full Backup:
Log Gen: 16539-16539 (0x409b-0x409b)
Mark: (0x409B,F99,F0)
Mark: 08/25/2011 03:31:23

Previous Incremental Backup:
Log Gen: 0-0 (0x0-0x0)
Mark: (0x0,0,0)
Mark: 00/00/1900 00:00:00

Current Full Backup:
Log Gen: 0-0 (0x0-0x0)
Mark: (0x0,0,0)
Mark: 00/00/1900 00:00:00

Current Shadow copy backup:
Log Gen: 0-0 (0x0-0x0)
Mark: (0x0,0,0)
Mark: 00/00/1900 00:00:00

cpgUpgrade55Format: 0
cpgUpgradeFreePages: 0
cpgUpgradeSpaceMapPages: 0

ECC Fix Success Count: none
Old ECC Fix Success Count: none
ECC Fix Error Count: none
Old ECC Fix Error Count: none
Bad Checksum Error Count: none
Old bad Checksum Error Count: none

Operation completed successfully in 3.0 seconds.




Gulab -> RE: eseutil recovery fails - database with same signature in use (28.Aug.2011 8:44:51 AM)

As per the result, you need just one log file to mount the database.
Check if you see the file E00000040AB at the logfile location.
Post the update.




ccsjst -> RE: eseutil recovery fails - database with same signature in use (28.Aug.2011 8:54:52 AM)

No 40AB last one was 40AA
John




Gulab -> RE: eseutil recovery fails - database with same signature in use (28.Aug.2011 9:18:08 AM)

My Bad, i should have been asked for E00.log
Do you have E00.log file? If yes than run this command

Eseutil /r <Log Prefix> /l “Path of the log files” /d “Path of the database”

Post the update.




ccsjst -> RE: eseutil recovery fails - database with same signature in use (28.Aug.2011 9:40:30 AM)

This is where I got to earlier Gulab

C:\Program Files\Exchsrvr\MDBDATA>"C:\Program Files\Exchsrvr\bin\eseutil.exe" /r
E00

Microsoft(R) Exchange Server Database Utilities
Version 6.5
Copyright (C) Microsoft Corporation. All Rights Reserved.

Initiating RECOVERY mode...
Logfile base name: E00
Log files: <current directory>
System files: <current directory>

Performing soft recovery...

Operation terminated with error -1222 (JET_errDatabaseSignInUse, Database with s
ame signature in use) after 1.0 seconds.




Gulab -> RE: eseutil recovery fails - database with same signature in use (28.Aug.2011 10:20:43 AM)

Is the same database? Does this database belongs to this server?
Do you have backup?




ccsjst -> RE: eseutil recovery fails - database with same signature in use (28.Aug.2011 10:30:06 AM)

Well I'm not sure which database it means - there are 4 .edb's
innoteq itqweb priv1 pub1

There is only one server

Exchange System Manager shows red 'x' for each and says they are nor mounted

We have under program files\exchsrvr\MDBDATA a PF Backup folder with useful looking stuff
I also I have copies of all exchsrver files from the day before the 'incident'
John




Gulab -> RE: eseutil recovery fails - database with same signature in use (28.Aug.2011 11:14:17 AM)

There are two scenario only when we can signature mismatch.
1: The database belongs to some other server
2: Database is of some other exchange ORG

Note: Exchange 2003 doesn;t have Database portability feature like 2007 and 2010.

In your scenario, I am not sure what happened? Are you trying to mount PF Store or Mailbox Store?




ccsjst -> RE: eseutil recovery fails - database with same signature in use (28.Aug.2011 11:39:49 AM)

I'm looking at Exchange System Manager
Under Server
First Storage Group
has 4 um-nounted items - that map onto the edb files
The server has been stable for years and no attempts made to change organisation

I feel it's not a signature mismatch but that it thinks the unmounted database is in use
JET_errDatabaseSignInUse, Database with same signature in use

I haven't found out how to manually mount/dismount them yet.

Are we running out of ideas

John




Gulab -> RE: eseutil recovery fails - database with same signature in use (28.Aug.2011 1:16:57 PM)

This is the error you are getting.

Operation terminated with error -1222 (JET_errDatabaseSignInUse, Database with same signature in use) after 1.0 seconds.

As per this error message you have same database on the server and you are trying to run the softrecovery on another copy of the database.

Post the name of the databases.




ccsjst -> RE: eseutil recovery fails - database with same signature in use (28.Aug.2011 1:28:43 PM)

C:\Program Files\Exchsrvr\MDBDATA>"C:\Program Files\Exchsrvr\bin\eseutil.exe" /r E00
Microsoft(R) Exchange Server Database Utilities
Version 6.5
Copyright (C) Microsoft Corporation. All Rights Reserved.
Initiating RECOVERY mode...
Logfile base name: E00
Log files: <current directory>
System files: <current directory>
Performing soft recovery...
Operation terminated with error -1222 (JET_errDatabaseSignInUse, Database with s
ame signature in use) after 1.0 seconds.

++++++
How can I tel?
The E00.log and chk files are in Program Files\exchsrvr\MDBDATA

John




Gulab -> RE: eseutil recovery fails - database with same signature in use (28.Aug.2011 1:34:58 PM)

Database file will be in MDBData folder.
Did you got this .edb file from backup or ?




ccsjst -> RE: eseutil recovery fails - database with same signature in use (28.Aug.2011 5:44:24 PM)

All files/databases that eseutil has been working on are in MDBDATA folder
see listing at http://www.mgjohn.com/itq/mdbdata.jpg
John




ccsjst -> RE: eseutil recovery fails - database with same signature in use (29.Aug.2011 8:08:07 AM)

What it seems to boil down to is 4 mail databases in 'dirty closedown' and eseutil refusing to do soft repair 'cos of duplicate database signatures !!

If that's right - where do I go from here?

Summary output below

C:\Program Files\Exchsrvr\bin>eseutil /mh "c:\Program Files\Exchsrvr\MDBDATA\in
oteq.edb"
Database: c:\Program Files\Exchsrvr\MDBDATA\innoteq.edb
File Type: Database
Format ulMagic: 0x89abcdef
Engine ulMagic: 0x89abcdef
Format ulVersion: 0x620,11
Engine ulVersion: 0x620,11
Created ulVersion: 0x620,9
DB Signature: Create time:09/03/2007 15:19:37 Rand:8561476 Computer:
cbDbPage: 4096
dbtime: 33056411 (0x1f8669b)
State: Dirty Shutdown
Log Required: 16555-16555 (0x40ab-0x40ab)

Database: c:\Program Files\Exchsrvr\MDBDATA\priv1.edb
File Type: Database
Format ulMagic: 0x89abcdef
Engine ulMagic: 0x89abcdef
Format ulVersion: 0x620,11
Engine ulVersion: 0x620,11
Created ulVersion: 0x620,9
DB Signature: Create time:09/03/2007 15:19:39 Rand:8575879 Computer:

Database: c:\Program Files\Exchsrvr\MDBDATA\itqweb.edb
File Type: Database
Format ulMagic: 0x89abcdef
Engine ulMagic: 0x89abcdef
Format ulVersion: 0x620,11
Engine ulVersion: 0x620,11
Created ulVersion: 0x620,9
DB Signature: Create time:09/03/2007 15:19:37 Rand:8561476 Computer:
cbDbPage: 4096
dbtime: 33056411 (0x1f8669b)
State: Dirty Shutdown
Log Required: 16555-16555 (0x40ab-0x40ab)

Database: c:\Program Files\Exchsrvr\MDBDATA\pub1.edb
File Type: Database
Format ulMagic: 0x89abcdef
Engine ulMagic: 0x89abcdef
Format ulVersion: 0x620,11
Engine ulVersion: 0x620,11
Created ulVersion: 0x620,9
DB Signature: Create time:09/03/2007 15:19:37 Rand:8561476 Computer:
cbDbPage: 4096
dbtime: 33056411 (0x1f8669b)
State: Dirty Shutdown
Log Required: 16555-16555 (0x40ab-0x40ab)


Directory of C:\Program Files\Exchsrvr\MDBDATA

29/08/2011 11:39 <DIR> .
29/08/2011 11:39 <DIR> ..
26/08/2011 11:29 8,192 E00.chk
29/08/2011 11:40 5,242,880 E00.log
25/08/2011 04:01 5,242,880 E000409B.log
25/08/2011 09:12 5,242,880 E000409C.log
25/08/2011 11:27 5,242,880 E000409D.log
25/08/2011 12:53 5,242,880 E000409E.log
25/08/2011 13:07 5,242,880 E000409F.log
25/08/2011 13:14 5,242,880 E00040A0.log
25/08/2011 14:30 5,242,880 E00040A1.log
25/08/2011 15:03 5,242,880 E00040A2.log
25/08/2011 16:20 5,242,880 E00040A3.log
25/08/2011 18:45 5,242,880 E00040A4.log
26/08/2011 01:06 5,242,880 E00040A5.log
26/08/2011 01:15 5,242,880 E00040A6.log
26/08/2011 01:21 5,242,880 E00040A7.log
26/08/2011 07:55 5,242,880 E00040A8.log
26/08/2011 09:57 5,242,880 E00040A9.log
26/08/2011 11:09 5,242,880 E00040AA.log
26/08/2011 13:17 2,395,086,848 innoteq.edb
25/08/2011 07:40 12,591,104 innoteq.stm
26/08/2011 13:17 2,395,086,848 itqweb.edb
25/08/2011 07:40 12,591,104 itqweb.stm
26/08/2011 13:56 <DIR> PF Backup
26/08/2011 13:17 7,315,398,656 priv1.edb
26/08/2011 12:10 1,616,912,384 priv1.stm
26/08/2011 13:17 2,395,086,848 pub1.edb
25/08/2011 07:40 12,591,104 pub1.stm
03/09/2007 15:19 5,242,880 res1.log
03/09/2007 15:19 5,242,880 res2.log
30 File(s) 16,254,969,168 bytes
3 Dir(s) 9,055,481,856 bytes free




Gulab -> RE: eseutil recovery fails - database with same signature in use (29.Aug.2011 9:08:51 AM)

Hi John,

If soft recovery is not working, than the only option you have is to run the hard repair on the database o restore from the Backup.

Hard repair process:
eseutil /p (Once /p completes run the below command)
eseutil /d (once its done, run the below command)
But make sure you mount the and dismount the database before you run this command.

isinteg -s servername -fix -test alltests

Note: Make sure error, warning and fix are 0, if you see any warning, error or fix run the isinteg again.




ccsjst -> RE: eseutil recovery fails - database with same signature in use (29.Aug.2011 11:52:14 AM)

Ok, have started hard recovery and defrag - done first of four databases.

Do I run isinteg after each database gets fixed or wait til the end?

John




Gulab -> RE: eseutil recovery fails - database with same signature in use (29.Aug.2011 1:51:51 PM)

Yes, one database at a time.




ccsjst -> RE: eseutil recovery fails - database with same signature in use (29.Aug.2011 5:13:15 PM)

Gulab, I am pleased to report that all 4 stores have now been hard repaired, defragged and isinteg'd

Need to set allow restore switch to mount/ unmount in Exch Sys Mgr
Also ditched all old log files

All hunky dory now

Thanks for your help

John




Page: [1] 2   next >   >>