Database corruption experience

[Benoit Schmid]

Hello,

In MM admin guide, they insist on running regular
mmrx to check and even fix database corruption.

As you have been using this products for years,
could you please tell me:

1. In which situation did you get corruption of MM db
(if you have an idea of the corruption source)?

2. How did you succeed to reload the database?

3. What did you loose after these reconstructs?

Thanks in advance for your answers.
--
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/

Benoit Schmid Tel: (++41-22) 379-7209
UNIGE Postmaster

University of Geneva - Information Technology Division

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/


* MMXP-TALK Web Page: http://WWW.LISTSERV.Emory.Edu/Archives/MMXP-TALK.HTML

[Jack Newton]

Running MMRx has never caused me to lose any data.

A totally corrupt database is usually caused by a hard drive or system crash.

MMRx is desined to fix problems with the database structure, not repair file corruption.

Sounds to me like you may need to go to a back up.

-Jack


> Hello,
>
> In MM admin guide, they insist on running regular
> mmrx to check and even fix database corruption.
>
> As you have been using this products for years,
> could you please tell me:
>
> 1. In which situation did you get corruption of MM db
> (if you have an idea of the corruption source)?
>
> 2. How did you succeed to reload the database?
>
> 3. What did you loose after these reconstructs?
>
> Thanks in advance for your answers.
> --
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
>
> Benoit Schmid Tel: (++41-22) 379-7209
> UNIGE Postmaster
>
> University of Geneva - Information Technology Division
>
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
>
>
> * MMXP-TALK Web Page: http://WWW.LISTSERV.Emory.Edu/Archives/MMXP-TALK.HTML


* MMXP-TALK Web Page: http://WWW.LISTSERV.Emory.Edu/Archives/MMXP-TALK.HTML

[Ian Eiloart]

--On 11 May 2005 12:59:33 +0000 Jack Newton <***@COMCAST.NET> wrote:

> Running MMRx has never caused me to lose any data.

MMRx does sometimes report that it is removing exceptions. I think these
are instances of recurring meetings that differ in some way from the rest
of the series. For example, if you have a weekly meeting and delete one
occurrence. That occurrence may reappear unexpectedly.

> A totally corrupt database is usually caused by a hard drive or system
> crash.

I've never seen that happen.

> MMRx is desined to fix problems with the database structure, not repair
> file corruption.

It's more complex than that. True, MMRx doesn't fix file corruption. It
also does fix inconsistent data in the database. However, it does also fix
bad entries in the database that suggest to me poor validation of data
entry.

For example, I've seen MMRx complain that a banner didn't start at
midnight! Well, it's an untimed event, what's it doing starting at any
particular time?

> Sounds to me like you may need to go to a back up.

No, I think this guy is evaluating Meeting Maker. He's trying to decide
whether to use it. His post is a follow up to previous enquiries.

> -Jack
>
>
>> Hello,
>>
>> In MM admin guide, they insist on running regular
>> mmrx to check and even fix database corruption.
>>
>> As you have been using this products for years,
>> could you please tell me:
>>
>> 1. In which situation did you get corruption of MM db
>> (if you have an idea of the corruption source)?

I find that people who sync with handheld devices often have lots of fixes
made to their data. That suggests that the synchronisation software is
pretty poor.

>> 2. How did you succeed to reload the database?

That's not necessary. MMRx repairs the database.

>> 3. What did you loose after these reconstructs?

Some exceptions to repeating events - possibly - I've never had any
complaints. Other 'repairs' include rounding a start time to the nearest
minute, or rebuilding a b-tree index, or moving a banner to start at
midnight - things that are not significant to a user.

>> Thanks in advance for your answers.
>> --
>> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
>>
>> Benoit Schmid Tel: (++41-22) 379-7209
>> UNIGE Postmaster
>>
>> University of Geneva - Information Technology Division
>>
>> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
>>
>>
>> * MMXP-TALK Web Page:
>> http://WWW.LISTSERV.Emory.Edu/Archives/MMXP-TALK.HTML
>
>
> * MMXP-TALK Web Page:
> http://WWW.LISTSERV.Emory.Edu/Archives/MMXP-TALK.HTML



--
Ian Eiloart
Servers Team
Sussex University ITS


* MMXP-TALK Web Page: http://WWW.LISTSERV.Emory.Edu/Archives/MMXP-TALK.HTML