General discussion on installation and configuration of SOGo

Text archives Help


Re: [SOGo] Problem after power failure - MySQL4Channel primaryFetchAttributes:withZone


Chronological Thread 
  • From: "Christian Mack" ( ) < >
  • To:
  • Subject: Re: [SOGo] Problem after power failure - MySQL4Channel primaryFetchAttributes:withZone
  • Date: Thu, 6 Jul 2017 14:49:41 +0200
  • Dmarc-filter: OpenDMARC Filter v1.2.0 mail.inverse.ca 1063A1240465

Hello

Am 06.07.2017 um 09:01 schrieb Götz Reinicke - IT Koordinator
( ):
> Am 05.07.17 um 14:04 schrieb Christian Mack
> ( ):
>> Am 05.07.2017 um 11:15 schrieb Götz Reinicke - IT Koordinator
>> ( ):
>>> Hi,
>>>
>>> some time ago we had a server crash because of a power failure. Today I
>>> noticed, that there are some error messages in the SOGo-Log like:
>>>
>>> 2017-07-05 11:09:07.458 sogod[3690] ERROR(-[MySQL4Channel
>>> primaryFetchAttributes:withZone:]): <MySQL4Channel[0x0x7f2baa443a98]
>>> connection=0x0x7f2baa4441a0>: got no value for column:
>>> attribute=c_foldername
>>> valueClass=NSString
>>> type=VARCHAR
>>>
>>>
>>>
>>> BTW I noticed, that one of my test-calendars hast changed his name to an
>>> ID number from a given name.
>>>
>>>
>>> Any hints ?? I bet there are some more problems users did not report yet.
>>>
>> You should check your data with sogo-tool:
>> /usr/sbin/sogo-tool checkup ALL
>>
>> This will show you, which users have defect data.
>> Then you can then restore their data from backups
>
> Hi Christian, thanks for your feedback.
>
> The Tool only shows one user with problems, and I do see a lot of this
> message. Also some other errors too:
>
> Jul 06 08:58:58 sogod [24401]: [ERROR]
> <0x42E80498[SOGoAppointmentFolder]:snicke_55E-52EA2480-D-48140300>
> missing exception record for recurrence-id 2016-09-26 11:00:00 +0000
> (uid 1086db3a-0456-4c71-93a5-8b72d33d794c)
>
>
> Strange ... Any ideas?
>

Those error message says:
In calendar with UID "55E-52EA2480-D-48140300" from user "snicke" is a
recurring event (uid 1086db3a-0456-4c71-93a5-8b72d33d794c) with
exeptions, where exeption at "2016-09-26 11:00:00 +0000" is missing.

So those are broken recurring events.

As it is only one user, you should delete him and restore from backup.


Kind regrds,
Christian Mack

--
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung Basisdienste
78457 Konstanz
+49 7531 88-4416

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature




Archive powered by MHonArc 2.6.18.

Top of page