Exchange Server Forums

Database Error, Dismounts Store

Users viewing this topic: none

Logged in as: Guest

Printable Version

All Forums >> [Microsoft Exchange 2003] >> Information Stores >> Database Error, Dismounts Store

Page: [1] 2 next > >>

Message

<< Older Topic Newer Topic >>

Database Error, Dismounts Store - 10.Nov.2008 2:59:05 PM

NarayanM

Posts: 124
Joined: 30.Jul.2004
From: hollywood, CA
Status: offline

Database error 0xfffffd9a occurred in function JTAB_BASE::EcUpdate while accessing the database "First Storage Group\Mailbox Store (EXCHANGE)".

Looking at some results for this message it appears related to backup issues I've been having. Due to an issue with my autloader I didn't get a clean backup for a few days. When I ran a full backup the backup died about 10-15% from completion because the stores have unmounted. I remount the stores but still don't have a clean backup. I tried this again, same issue. I tried a third time, using MSBACKUP as opposed to my Bakcup Exec hoping it would get a clean backup and would flush the logs, but it ended with the same issue.

Looking at a MS KB article for the error, it appears related to the number of uncomitted transactions. How can I comit these transactions so I can move to clean operation on my DB?

Any help is appreciated as I desparately need it.

Post #: 1

Featured Links*

RE: Database Error, Dismounts Store - 10.Nov.2008 3:17:08 PM

Naddy

Posts: 139
Joined: 22.Oct.2008
Status: offline

Hi,

Can you paste the event id's which you are getting in the application logs?
Run the following command :-
eseutil /mh "path of the database file (priv1.edb)" and paste the result

(in reply to NarayanM)

Post #: 2

RE: Database Error, Dismounts Store - 10.Nov.2008 3:26:18 PM

NarayanM

Posts: 124
Joined: 30.Jul.2004
From: hollywood, CA
Status: offline

quote:

Event Type: Error
Event Source: MSExchangeIS
Event Category: General
Event ID: 1159
Date:  11/10/2008
Time:  11:39:18 AM
User:  N/A
Computer: EXCHANGE
Description:
Database error 0xfffffd9a occurred in function JTAB_BASE::EcUpdate while accessing the database "First Storage Group\Mailbox Store (EXCHANGE)".
For more information, click http://www.microsoft.com/contentredirect.asp.

quote:

Event Type: Warning
Event Source: MSExchangeIS Mailbox Store
Event Category: General
Event ID: 1025
Date:  11/10/2008
Time:  11:39:18 AM
User:  N/A
Computer: EXCHANGE
Description:
An error occurred on database "First Storage Group\Mailbox Store (EXCHANGE)".
Function name or description of problem: SLINK::EcUpdate
Error: 0xfffffd9a
For more information, click http://www.microsoft.com/contentredirect.asp.

I then get events saying the store has been shut down and that my backup has failed.

What is the /h in the eueutil? Can I run that while I'm up and active?

(in reply to Naddy)

Post #: 3

RE: Database Error, Dismounts Store - 10.Nov.2008 3:44:07 PM

Naddy

Posts: 139
Joined: 22.Oct.2008
Status: offline

The reason you are getting this events is because of the uncomintted Transaction logs have reached its maximun limit.
http://support.microsoft.com/kb/905801/en-us

thats the reason the Backup Job is failing.

quote:

What is the /h in the eueutil? Can I run that while I'm up and active?

It is eseutil /mh (it checks the consistency of your database and all the rest of the details about the last comitted log file, repair count ........etc).
You can only run this when the stores are dismounted or after production you can manually dismount the stores and then run this command.

(in reply to NarayanM)

Post #: 4

RE: Database Error, Dismounts Store - 10.Nov.2008 4:06:54 PM

NarayanM

Posts: 124
Joined: 30.Jul.2004
From: hollywood, CA
Status: offline

So, I have been vaguely aware that the uncomitted logs are my problem, but the question is, what can I do about that? How do I find out what log files are not committed or how can I force the data to commit? What is the implication of this? Is the data in the database or not currently? Is it just in the log?

Appreciate the help!

(in reply to Naddy)

Post #: 5

RE: Database Error, Dismounts Store - 10.Nov.2008 4:32:42 PM

Naddy

Posts: 139
Joined: 22.Oct.2008
Status: offline

When you will the eseuitl /mh command...you will get the detail about the last comitted log file to database..the you can verify the same log file in the log file location. once you verifyed that then it is safe to move( to a different location) the older log files which were generated before the last comitted log file.Finally mount the stores.

(in reply to NarayanM)

Post #: 6

RE: Database Error, Dismounts Store - 10.Nov.2008 4:43:30 PM

NarayanM

Posts: 124
Joined: 30.Jul.2004
From: hollywood, CA
Status: offline

So the /mh will commit the log files that are not commited? What if it cannot find a log file or one is damaged?

Is this a time intensive command, or will my downtime be fairly brief.

(in reply to Naddy)

Post #: 7

RE: Database Error, Dismounts Store - 10.Nov.2008 5:15:41 PM

NarayanM

Posts: 124
Joined: 30.Jul.2004
From: hollywood, CA
Status: offline

So I know the culprit of my sitution. Do to the not running backup the trans partition was getting full so some of the log files have been moved to a different partition and are not in my log file directory.

No files have been deleted or are lost, but they definitely cannot be put back into the MDBdata folder on the log file partition as there is not enough space.

Any suggestions on how to handle this situation would be greatly appreciated.

I need to ensure my log files get committed, that I get clean backups, and I don't have any more unexpected store dismounts!

(in reply to NarayanM)

Post #: 8

RE: Database Error, Dismounts Store - 10.Nov.2008 5:58:18 PM

Naddy

Posts: 139
Joined: 22.Oct.2008
Status: offline

No eseutil /mh will not comitt the log file,,it will just give you the details.
It will take only couple of seconds to run this command.
Once you verified the last comitted log file then...move the old log files to different location becuase they are already comitted.

(in reply to NarayanM)

Post #: 9

RE: Database Error, Dismounts Store - 10.Nov.2008 6:00:18 PM

NarayanM

Posts: 124
Joined: 30.Jul.2004
From: hollywood, CA
Status: offline

But, so once I find the committed logs, what needs to be done to have the uncomitted ones respond to the database?

How can I properly manage my situtation currently where the live log folder is on a partition that is too small for all of the non flushed logs?

(in reply to Naddy)

Post #: 10

RE: Database Error, Dismounts Store - 10.Nov.2008 6:11:16 PM

Naddy

Posts: 139
Joined: 22.Oct.2008
Status: offline

When ever we dismount the database it will go to clean shutdown state..means all the log files gets comitted. but...incase if it shows dirty shutdown or inconsistent state then after moving the old log files which are already comitted, you can leave the uncomitted log files to the same location and next time when you mount the database they will get comitted.

(in reply to NarayanM)

Post #: 11

RE: Database Error, Dismounts Store - 10.Nov.2008 6:16:32 PM

NarayanM

Posts: 124
Joined: 30.Jul.2004
From: hollywood, CA
Status: offline

Thanks so much for all of your help Naddy, this is begining to make a lot of sense to me.

So, basically, if I dismount the database it will be a clean dismount. That will cause the logs to become committed. I then need to run the eseutil /mh to find what logs are not committed, move those into my MDBData, I can mount / dismount the store again and it should commit those logs?

Looking at performance monitor Database - Instances / Log, I am seeing I think 4 logs that aren't committed. Am I reading that correctly? (it occasionally goes to 5 or 6, but I assume that is the current log file being written to the DB?)

(in reply to Naddy)

Post #: 12

RE: Database Error, Dismounts Store - 10.Nov.2008 6:32:55 PM

NarayanM

Posts: 124
Joined: 30.Jul.2004
From: hollywood, CA
Status: offline

I've found another issue. When the log files were moved, the E00.chk file was moved. So currently there are 2 E00.chk files.

How can I reconcile these two files? Can I just point all the logs in the same location? Would that create data duplication or loss?

(in reply to NarayanM)

Post #: 13

RE: Database Error, Dismounts Store - 10.Nov.2008 6:45:16 PM

Naddy

Posts: 139
Joined: 22.Oct.2008
Status: offline

There is no Need to worry about the .chk files,,,since we already moved those log files which are no longer required to comitt to database and not for Back up also.

(in reply to NarayanM)

Post #: 14

RE: Database Error, Dismounts Store - 10.Nov.2008 6:48:45 PM

NarayanM

Posts: 124
Joined: 30.Jul.2004
From: hollywood, CA
Status: offline

But, I guess I am at a loss then why my backup is erroring. I am seeing only 5 uncomitted logs and they all exist in the MDBdata folder. Shouldn't my backup complete properly then?

(in reply to Naddy)

Post #: 15

RE: Database Error, Dismounts Store - 10.Nov.2008 6:53:45 PM

Naddy

Posts: 139
Joined: 22.Oct.2008
Status: offline

1) Can You Paste the results After Running eseutil /mh Command.?
2) go the location of the log files and tell me how many log files do you see in that folder.?

(in reply to NarayanM)

Post #: 16

RE: Database Error, Dismounts Store - 10.Nov.2008 6:56:10 PM

NarayanM

Posts: 124
Joined: 30.Jul.2004
From: hollywood, CA
Status: offline

I'll need to run the /mh after hours, so I won't have that until later tonight. In my live MDBData I have 9GB of logs, 1800 files. Only 4 files out of that are showing as not committed, via a /mk

(in reply to Naddy)

Post #: 17

RE: Database Error, Dismounts Store - 10.Nov.2008 6:59:56 PM

Naddy

Posts: 139
Joined: 22.Oct.2008
Status: offline

Although you figured out that there are only Four Log files which are not comitted to the database but bro they still exist in the same directory of the log file folder and ESE will consider the log file folder to check the limit of the log files...consistency...etc.

(in reply to NarayanM)

Post #: 18

RE: Database Error, Dismounts Store - 10.Nov.2008 7:01:59 PM

NarayanM

Posts: 124
Joined: 30.Jul.2004
From: hollywood, CA
Status: offline

Sorry for being a bit dense here. But, this is an incrementing number. Meaning, it is the 'most recent 4' that are not committed. This isn't like an old file or anything, this I thought was normal operation?

I'll run the /mh and hopefully that will shed some light, but I'm generally fairly confused.

(in reply to Naddy)

Post #: 19

RE: Database Error, Dismounts Store - 10.Nov.2008 7:07:32 PM

Naddy

Posts: 139
Joined: 22.Oct.2008
Status: offline

Ok fine....lets do this...after running eseutil /mh if get the results as clean shutdown or database consistent, then just move all hte log files to different location so that the log file folder will empty..then mount the stores and try to Backup..i am sure you wont get the event id's.

Let me know the results.

(in reply to NarayanM)

Post #: 20