Re: [SOGo] Problem after power failure - MySQL4Channel primaryFetchAttributes:withZone
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
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
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
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