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

2017-07-06 Thread Christian Mack 
Hello

Am 06.07.2017 um 09:01 schrieb Götz Reinicke - IT Koordinator
(goetz.reini...@filmakademie.de):
> Am 05.07.17 um 14:04 schrieb Christian Mack
> (christian.m...@uni-konstanz.de):
>> Am 05.07.2017 um 11:15 schrieb Götz Reinicke - IT Koordinator
>> (goetz.reini...@filmakademie.de):
>>> 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:]): >> 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 +
> (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 +" 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



smime.p7s
Description: S/MIME Cryptographic Signature

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

2017-07-06 Thread goetz.reini...@filmakademie.de 
Am 05.07.17 um 14:04 schrieb Christian Mack
(christian.m...@uni-konstanz.de):
> Am 05.07.2017 um 11:15 schrieb Götz Reinicke - IT Koordinator
> (goetz.reini...@filmakademie.de):
>> 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:]): > 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 +
(uid 1086db3a-0456-4c71-93a5-8b72d33d794c)


Strange ... Any ideas?

Regards . Götz





smime.p7s
Description: S/MIME Cryptographic Signature

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

2017-07-05 Thread Christian Mack 
Am 05.07.2017 um 11:15 schrieb Götz Reinicke - IT Koordinator
(goetz.reini...@filmakademie.de):
> 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:]):  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


Kind regards,
Christian Mack

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



smime.p7s
Description: S/MIME Cryptographic Signature

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

2017-07-05 Thread goetz.reini...@filmakademie.de 
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:]): : 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.

Regards . Götz





smime.p7s
Description: S/MIME Cryptographic Signature