2015-11-07 - Re: [GRASE-Hotspot] Problem with db table mtotaccttmp

Header Data

From: Timothy White <ti***8@gmail.com>
Message Hash: bda5d6152c04863b258cd5e00f693327fcfe44623fb9fad6cca69e7fa64c9478
Message ID: <CAESLx0Ky=BvBeWj9pLAT2XRBpiCZBMsjkw7DikGaZN1uqwnhQg@mail.gmail.com>
Reply To: <CAPz6xh5u34Rb_GjbSYVYSjnfJwUOp-NNm3vqPRwOfqM4OuM4ew@mail.gmail.com>
UTC Datetime: 2015-11-07 03:15:39 UTC
Raw Date: Sat, 07 Nov 2015 20:15:39 +1000

Raw message 

Hi Tomas

I'm a little stumped. On my dev machine, the database is 'corrupt'. Other
machines I've checked are fine.
The fact it happened to 2 of our machines makes me wonder what we have in
common to them.

I'm wondering if it has anything to do with the mysql version, as so far
the machines I've checked that have been fine are running 5.1 while you are
running 5.5 (and I'm running MariaDB 10).

It's also ok for that database to be empty, it should be empty most of the
time, except when running certain monthly cronjobs.

I might just make an upgrade that drops it and recreates it as innodb or
something to fix this issue for us. I think a MySQL upgrade broke on empty
tables, so it's only that table effected.

Regards

On Mon, Nov 2, 2015 at 10:06 PM, Tomas213 <to***3@gmail.com> wrote:

> I checked and old backup i had and the table exists, but with no data.
>
> On Mon, Nov 2, 2015 at 1:29 PM, Timothy White <ti***8@gmail.com>
> wrote:
>
>> How odd.
>> I checked one of my installs here, and the same issue. It's a temp table,
>> so no data is lost. But it would be good to work out what's happened, and
>> how to fix it.
>>
>> What version OS are you running. What version of Grase are you running?
>> (apt-cache policy grase\*)
>> Mysql version? (apt-cache policy mysql-server)
>>
>> It's odd that it's happened on more than just your machine.
>>
>> Regards
>>
>> Tim
>>
>> On Mon, Nov 2, 2015 at 8:45 PM, Tomas213 <to***3@gmail.com> wrote:
>>
>>> Hello Tim.
>>> Today i checked my db and i get this error
>>> Can't find file: 'mtotaccttmp' (errno: 2)
>>> Grace is working though just fine.
>>>
>>> Any ideas what is wrong or what to check?
>>>
>>> Thomas
>>>
>>> --
>>> This mailing list is for the Grase Hotspot Project
>>> http://grasehotspot.org
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "Grase Hotspot" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to gr***e@grasehotspot.org.
>>> To post to this group, send email to gr***t@grasehotspot.org.
>>> Visit this group at
>>> http://groups.google.com/a/grasehotspot.org/group/grase-hotspot/.
>>> To view this discussion on the web visit
>>> https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/CAPz6xh7bcXGmJaFWUvNuE-s8qKoBHDUGeRJQka2ySj-Y8t_cTw%40mail.gmail.com
>>> <https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/CAPz6xh7bcXGmJaFWUvNuE-s8qKoBHDUGeRJQka2ySj-Y8t_cTw%40mail.gmail.com?utm_medium=email&utm_source=footer>
>>> .
>>>
>>
>> --
>> This mailing list is for the Grase Hotspot Project
>> http://grasehotspot.org
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "Grase Hotspot" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to gr***e@grasehotspot.org.
>> To post to this group, send email to gr***t@grasehotspot.org.
>> Visit this group at
>> http://groups.google.com/a/grasehotspot.org/group/grase-hotspot/.
>> To view this discussion on the web visit
>> https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/CAESLx0LjQRZiVuL0sVdEUc5cp78eTBUemLpcQfL8zYYVb6_U-g%40mail.gmail.com
>> <https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/CAESLx0LjQRZiVuL0sVdEUc5cp78eTBUemLpcQfL8zYYVb6_U-g%40mail.gmail.com?utm_medium=email&utm_source=footer>
>> .
>>
>
> --
> This mailing list is for the Grase Hotspot Project http://grasehotspot.org
> ---
> You received this message because you are subscribed to the Google Groups
> "Grase Hotspot" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to gr***e@grasehotspot.org.
> To post to this group, send email to gr***t@grasehotspot.org.
> Visit this group at
> http://groups.google.com/a/grasehotspot.org/group/grase-hotspot/.
> To view this discussion on the web visit
> https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/CAPz6xh5u34Rb_GjbSYVYSjnfJwUOp-NNm3vqPRwOfqM4OuM4ew%40mail.gmail.com
> <https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/CAPz6xh5u34Rb_GjbSYVYSjnfJwUOp-NNm3vqPRwOfqM4OuM4ew%40mail.gmail.com?utm_medium=email&utm_source=footer>
> .
>

Thread