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

Header Data

From: Tomas213 <to***3@gmail.com>
Message Hash: e463ef1b210d08d61e920df26eca57ceb983fda55a9379c2b488681079b6cd20
Message ID: <CAPz6xh6Har-298KsO8VcC+ucw7LxD04dS+6th3vJ9-qK9cdfUg@mail.gmail.com>
Reply To: <CAESLx0Ky=BvBeWj9pLAT2XRBpiCZBMsjkw7DikGaZN1uqwnhQg@mail.gmail.com>
UTC Datetime: 2015-11-07 04:08:53 UTC
Raw Date: Sat, 07 Nov 2015 13:08:53 +0200

Raw message 

Does anybody else have the same problem? We have to check that too
Στις 7 Νοε 2015 12:15 μ.μ., ο χρήστης "Timothy White" <ti***8@gmail.com>
έγραψε:

> 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>
>> .
>>
>
> --
> 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/CAESLx0Ky%3DBvBeWj9pLAT2XRBpiCZBMsjkw7DikGaZN1uqwnhQg%40mail.gmail.com
> <https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/CAESLx0Ky%3DBvBeWj9pLAT2XRBpiCZBMsjkw7DikGaZN1uqwnhQg%40mail.gmail.com?utm_medium=email&utm_source=footer>
> .
>

Thread