536      iPhone_iPad_Mac_apple

Calendar agent

Hi,

So after spending quite a lot of time trying to fix my iCalendar app

from the Spinning beach ball lag every time I make a new event or edit an event,

I found this error in the console application:

error: sql cached statement NSSQLiteStatement <0x7f8eef31d7d0> on entity 'Attachment' with sql text 'SELECT 0, t0.Z_PK, t0.Z_OPT, t0.ZATTACHMENTID, t0.ZCONTENTTYPE, t0.ZFILENAMEINCACHE, t0.ZFILENAMESUGGESTEDBYSERVER, t0.ZISAUTOARCHIVED, t0.ZISCACHED, t0.ZOMITSYNCRECORD, t0.ZPATHONDISKSTRING, t0.ZURLSTRING, t0.ZUUID, t0.ZITEM, t0.Z4_ITEM FROM ZATTACHMENT t0 WHERE  t0.ZITEM IN (SELECT * FROM _Z_intarray0)  ORDER BY t0.ZITEM' failed due to missing variable binding for (null) with expecting bindings (

) but actual substitution variables {

    destinations = "{0x122c009eb <x-coredata://93547915-498F-4251-8E7E-23DD04782C04/Event/p1163>, 0x1230009eb <x-coredata://93547915-498F-4251-8E7E-23DD04782C04/Event/p1164>, 0x1234009eb <x-coredata://93547915-498F-4251-8E7E-23DD04782C04/Event/p1165>, 0x123c009eb <x-coredata://93547915-498F-4251-8E7E-23DD04782C04/Event/p1167>, 0x1258009eb <x-coredata://93547915-498F-4251-8E7E-23DD04782C04/Event/p1174>, 0x1264009eb <x-coredata://93547915-498F-4251-8E7E-23DD04782C04/Event/p1177>, 0x126c009eb <x-coredata://93547915-498F-4251-8E7E-23DD04782C04/Event/p1179>, 0x127c009eb <x-coredata://93547915-498F-4251-8E7E-23DD04782C04/Event/p1183>, 0x1280009eb <x-coredata://93547915-498F-4251-8E7E-23DD04782C04/Event/p1184>, 0x1284009eb <x-coredata://93547915-498F-4251-8E7E-23DD04782C04/Event/p1185>}";

}

error  11:40:50.320294 +0100  CalendarAgent  error: sql cached statement NSSQLiteStatement <0x7f8eef350360> on entity 'Group' with sql text 'SELECT t0.Z_ENT, t0.Z_PK, t0.Z_OPT, t0.ZCOLORSTRING, t0.ZISENABLED, t0.ZNOTES, t0.ZOMITSYNCRECORD, t0.ZORDER, t0.ZSYMBOLICCOLORNAME, t0.ZTITLE, t0.ZUID, t0.ZPUBLICATION, t0.ZALARMSDISABLED, t0.ZCHECKED, t0.ZHASSHAREES, t0.ZISEVENTCONTAINER, t0.ZISMARKEDIMMUTABLESHAREES, t0.ZISMARKEDUNDELETABLE, t0.ZISTASKCONTAINER, t0.ZNOTIFICATIONCOUNT, t0.ZSHAREDEFAULTALARMSETTINGS, t0.ZSUPPRESSEVENTSCHEDULINGNOTIFICATIONS, t0.ZDEFAULTALARMSET, t0.ZGROUP, t0.Z46_GROUP, t0.ZLOCALDEFAULTALARMSET, t0.ZSUBSCRIPTIONINFO, t0.ZACCOUNTIDFORHEADING, t0.ZGROUPHEADERTITLE, t0.ZISEDITABLE, t0.ZISSUGGESTEDEVENTCALENDAR, t0.ZISDELEGATE, t0.ZPERMISSION, t0.ZPREPUBLISHURLSTRING, t0.ZPUBLISHURLSTRING, t0.ZSERVERSUBSCRIPTIONURLSTRING, t0.ZSHARINGSTATUS, t0.ZCTAG, t0.ZCALENDARPATH, t0.ZCANBEPUBLISHED, t0.ZISAFFECTINGAVAILABILITY, t0.ZISCOLOREDITABLE, t0.ZISFAMILYCALENDAR, t0.ZISRENAMEABLE, t0.ZOWNERDISPLAYNAME, t0.ZOWNERPRINCIPALPATH, t0.ZPUSHKEY, t0.ZSYNCTOKEN, t0.ZTIMEZONESTRING, t0.ZETAG, t0.ZCHANGEKEY, t0.ZFOLDERID, t0.ZISDISTINGUISHED, t0.ZPARENTFOLDERID, t0.ZSYNCSTATE, t0.ZISEXPANDED, t0.ZDATAFLOWSTOWARDLOCALSTORE, t0.ZPRINCIPAL, t0.Z50_PRINCIPAL, t0.ZACCOUNTID, t0.ZISDELEGATE1, t0.ZISINSEPARATEWINDOW, t0.ZKEEPOFFLINE, t0.ZOVERRIDEBASEURLSTRING, t0.ZREFRESHDATE, t0.ZSHAREDEFAULTALARMSETTINGS1, t0.ZSUPPORTSDEFAULTALARMS, t0.ZDEFAULTALARMSET1, t0.ZLOCALDEFAULTALARMSET1, t0.ZMIGRATIONGROUP, t0.ZALLOWEDCALENDARCREATIONTYPES, t0.ZAVAILABILITYDATA, t0.ZCALENDARHOMEPATH, t0.ZCALENDARHOMEPUSHKEY, t0.ZDEFAULTCALENDARPATH, t0.ZDROPBOXPATH, t0.ZHOMECTAG, t0.ZHOMESYNCTOKEN, t0.ZINBOXCTAG, t0.ZINBOXPATH, t0.ZINBOXSYNCTOKEN, t0.ZISAUTOSCHEDULESUPPORTED, t0.ZISCALENDARPROXYSUPPORTED, t0.ZISCALENDARSERVERPRIVATEEVENTSSUPPORTED, t0.ZISCALENDARUSERSEARCHREPORTSUPPORTED, t0.ZISCHECKFORVALIDEMAILSUPPORTED, t0.ZISCHECKSUMMINGSUPPORTED, t0.ZISEXPANDPROPERTYREPORTSUPPORTED, t0.ZISINBOXAVAILABILITYSUPPORTED, t0.ZISLIKENESSPROPAGATIONSUPPORTED, t0.ZISMANAGEDATTACHMENTSUPPORTED, t0.ZISPRIVATECOMMENTSSUPPORTED, t0.ZISREQUESTCOMPRESSIONSUPPORTED, t0.ZISSHARINGSCHEDULINGSUPPORTED, t0.ZISSHARINGSUPPORTED, t0.ZLASTPUSHSUBSCRIPTION, t0.ZNEXTDEEPREFRESH, t0.ZNOTIFICATIONCOLLECTIONCTAG, t0.ZNOTIFICATIONCOLLECTIONPATH, t0.ZNOTIFICATIONCOLLECTIONSYNCTOKEN, t0.ZNOTIFICATIONURLSTRING, t0.ZOUTBOXPATH, t0.ZPRINCIPALPATH, t0.ZPUSHTRANSPORTS, t0.ZQUOTAFREEBYTES, t0.ZSUPPORTSCALENDARHOMESYNC, t0.ZSUPPORTSFREEBUSY, t0.ZSUPPORTSNOTSERIALIZINGTIMEZONES, t0.ZSUPPORTSRECURRENCESPLITONSERVER, t0.ZSUPPORTSSUBSCRIPTIONCALENDARS, t0.ZSUPPORTSUNBIND, t0.ZLASTERROR, t0.ZDELETEDITEMSFOLDERID, t0.ZDELETEDITEMSFOLDERSYNCSTATE, t0.ZEXCHANGESERVERMAJORBUILDNUMBER, t0.ZEXCHANGESERVERMAJORVERSION, t0.ZEXCHANGESERVERMINORBUILDNUMBER, t0.ZEXCHANGESERVERMINORVERSION, t0.ZEXCHANGESERVERVERSION, t0.ZMAILBOX, t0.ZROOTFOLDERID, t0.ZLASTERROR1 FROM ZNODE t0 WHERE ( t0.Z_PK IN (SELECT * FROM _Z_intarray0)  AND  t0.Z_ENT >= ? AND  t0.Z_ENT <= ?) ' failed due to missing variable binding for (null) with expecting bindings (

    "<NSSQLBindVariable: 0x7f8eecff3a70>",

    "<NSSQLBindVariable: 0x7f8eef373ee0>"

) but actual substitution variables {

    objects = "{<NSManagedObject: 0x7f8eef47a3e0> (entity: ExchangePrincipal; id: 0x2400b0b <x-coredata://93547915-498F-4251-8E7E-23DD04782C04/ExchangePrincipal/p9> ; data: <fault>)}";

}

There are around 8-10 of such errors each time I make a new event.

Can you please help me with this issue?

I already reinstalled mac os sierra few times,

but it made no difference.

Can you login in a guest account, then make some entries in calendar. Same issues?

Hi,

I have tried that but there was no difference.

So the issue is system wide and not only in your normal account.

I'll don't know much about Calendar, I'll ask for heöp.

I have a similar issue but without any effect on functionality. Would like to know what it's about.

this problem is very hard

I'm seeing this issue a lot. I've looked everywhere but cannot find a solution. I'm adding my error. Every time the calendar fetches data, i get theses errors.

error: sql cached statement NSSQLiteStatement <0x7fcedb940ae0> on entity 'Attachment' with sql text 'SELECT 0, t0.Z_PK, t0.Z_OPT, t0.ZATTACHMENTID, t0.ZCONTENTTYPE, t0.ZFILENAMEINCACHE, t0.ZFILENAMESUGGESTEDBYSERVER, t0.ZISAUTOARCHIVED, t0.ZISCACHED, t0.ZOMITSYNCRECORD, t0.ZPATHONDISKSTRING, t0.ZURLSTRING, t0.ZUUID, t0.ZITEM, t0.Z4_ITEM FROM ZATTACHMENT t0 WHERE  t0.ZITEM IN (SELECT * FROM _Z_intarray0)  ORDER BY t0.ZITEM' failed due to missing variable binding for (null) with expecting bindings (

) but actual substitution variables {

    destinations = "{0x1b80058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p110>, 0x1bc0058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p111>, 0x1c00058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p112>, 0x1c40058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p113>, 0x1c80058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p114>, 0x1d40058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p117>, 0x1e00058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p120>, 0x1e80058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p122>, 0x1f40058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p125>, 0x2000058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p128>, 0x2180058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p134>, 0x2280058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p138>, 0x22c0058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p139>, 0x2380058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p142>, 0x2440058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p145>, 0x2500058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p148>, 0x2600058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p152>, 0x2640058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p153>, 0x2680058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p154>, 0x2700058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p156>, 0x27c0058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p159>, 0x2800058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p160>, 0x2840058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p161>, 0x2880058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p162>, 0x28c0058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p163>, 0x2900058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p164>, 0x2940058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p165>, 0x2980058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p166>, 0x29c0058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p167>, 0x2a00058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p168>, 0x2a40058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p169>, 0x198c0058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p1635>, 0x1b980058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p1766>, 0x38140058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p3589>, 0x38200058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p3592>, 0x38240058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p3593>, 0x382c0058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p3595>, 0x38480058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p3602>, 0x38540058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p3605>, 0x385c0058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p3607>, 0x386c0058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p3611>, 0x38700058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p3612>, 0x38740058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p3613>, 0x463c0058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p4495>, 0x4ce00058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p4920>, 0x4d9c0058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p4967>, 0x4dc00058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p4976>}";

}

I have the same problem here:

error: sql cached statement NSSQLiteStatement <0x7fb7ba9ee7f0> on entity 'Alarm' with sql text 'SELECT 0, t0.Z_PK, t0.Z_OPT, t0.ZABSOLUTETRIGGER, t0.ZACKNOWLEDGED, t0.ZACTION, t0.ZBOOKMARK, t0.ZEMAILADDRESS, t0.ZISDEFAULTALARM, t0.ZISTIMETOLEAVEALARM, t0.ZMESSAGE, t0.ZNOTRELATIVETOTRAVEL, t0.ZOMITSYNCRECORD, t0.ZORDER, t0.ZPROXIMITY, t0.ZRELATEDTO, t0.ZRELATIVETRIGGER, t0.ZSOUND, t0.ZSUBJECT, t0.ZTIMETOLEAVEDATE, t0.ZTIMETOLEAVEESTIMATEDTRAVELTIME, t0.ZTIMETOLEAVETRAFFICDENSITYSTRING, t0.ZTIMETOLEAVETRANSPORTTYPE, t0.ZUID, t0.ZURLSTRING, t0.ZCALENDAR, t0.Z38_CALENDAR, t0.ZDEFAULTALARMBYREFERENCE, t0.ZDEFAULTALARMSETEVENTALLDAY, t0.ZDEFAULTALARMSETEVENTTIMED, t0.ZITEMCUSTOMALARM, t0.Z4_ITEMCUSTOMALARM, t0.ZITEMLOCALDEFAULTALARM, t0.Z4_ITEMLOCALDEFAULTALARM, t0.ZITEMSERVERDEFAULTALARM, t0.Z4_ITEMSERVERDEFAULTALARM, t0.ZLOCATION, t0.ZUNRECOGNIZEDICSPROPERTIES FROM ZALARM t0 WHERE  t0.ZCALENDAR IN (SELECT * FROM _Z_intarray0)  ORDER BY t0.ZCALENDAR' failed due to missing variable binding for (null) with expecting bindings (

) but actual substitution variables {

    destinations = "{0x8013ab <x-coredata://C6568071-60BE-4E89-BEAF-6929C9FFAB46/CalDAVCalendar/p2>, 0x14013ab <x-coredata://C6568071-60BE-4E89-BEAF-6929C9FFAB46/CalDAVCalendar/p5>, 0x1c013ab <x-coredata://C6568071-60BE-4E89-BEAF-6929C9FFAB46/CalDAVCalendar/p7>, 0x20013ab <x-coredata://C6568071-60BE-4E89-BEAF-6929C9FFAB46/CalDAVCalendar/p8>, 0x24013ab <x-coredata://C6568071-60BE-4E89-BEAF-6929C9FFAB46/CalDAVCalendar/p9>, 0x28013ab <x-coredata://C6568071-60BE-4E89-BEAF-6929C9FFAB46/CalDAVCalendar/p10>, 0x2c013ab <x-coredata://C6568071-60BE-4E89-BEAF-6929C9FFAB46/CalDAVCalendar/p11>, 0x30013ab <x-coredata://C6568071-60BE-4E89-BEAF-6929C9FFAB46/CalDAVCalendar/p12>, 0x34013ab <x-coredata://C6568071-60BE-4E89-BEAF-6929C9FFAB46/CalDAVCalendar/p13>, 0x38013ab <x-coredata://C6568071-60BE-4E89-BEAF-6929C9FFAB46/CalDAVCalendar/p14>, 0xc013cb <x-coredata://C6568071-60BE-4E89-BEAF-6929C9FFAB46/CalDAVSubscribedCalendar/p3> , 0x10013cb <x-coredata://C6568071-60BE-4E89-BEAF-6929C9FFAB46/CalDAVSubscribedCalendar/p4> , 0x18013cb <x-coredata://C6568071-60BE-4E89-BEAF-6929C9FFAB46/CalDAVSubscribedCalendar/p6> }";

}

I have this error to.

But here it causes iCal stopping from syncing with the Exchange Calendar from my work.

That's really bad because everything worked fine since yesterday...

And really nobody found out what ist going on?!

最後更新：2017-08-29 19:54:10

  上一篇： Revoke permission to load 3rd party kexts

  下一篇： Audio glitches with USB headset after upgrade t...