Apple Mail quitting or crashing, can't pin down issue???

[creativeraul]

Mail has been crashing or quitting since updating to 10.13.5. The issue continues since updating to 10.13.6.

Mail is set up with three gmail accounts which worked fine until upgrading to 10.13.5. I have quit and rebuild index as instructed several times with no change in outcome. Gmail accounts are under IMAP protocol.

Below are the console error that come up when I open mail. No clue how to deal with this SQLite error.

 

[Funsize93]

You need to isolate:

1.
- disable all internet email accounts in system preferences.
- Try opening mail now. If it opens without crashing, one of the accounts are the cause. Turn each one on, one by one while opening mail between each one to find out which is the culprit. When you find the culprit it would be best to remove and re-add the affected account (in system prefs).
- if issues persists when you disable all accounts move onto step 2.

2.
- create a new user account
- does the mail app open on a new user, if yes then you know your issue is affecting the user library of your user account. Move onto step 3.
- if issues persists in a new user move onto step 4.

3.
- If you are positive all accounts are IMAP and emails are stored on the server (not locally to your device)
- Remove all email internet accounts from system preferences
- delete all contents from the ~/Library/Mail (contents, not the mail folder itself) to the trash and then restart your mac
- test to see if the issue is resolved after the restart, does mail open? If yes you can re-add your accounts

4.
- If issue is happening in both your user and a new user account
- Isolate to see if third-party plugins or extension kernels are causing the issue, Boot to safemode and test the issue.
- If issues persist whilst in safemode i would reinstall the OS.

 

[creativeraul]

I pinned the issue down to one of my three google accounts. It seems that having contacts, calendar and notes "on" was the cause. Currently testing to see if I can just have mail and calendar work.

Thanks for the 411.

 

[creativeraul]

You need to isolate:

1.
- disable all internet email accounts in system preferences.
- Try opening mail now. If it opens without crashing, one of the accounts are the cause. Turn each one on, one by one while opening mail between each one to find out which is the culprit. When you find the culprit it would be best to remove and re-add the affected account (in system prefs).
- if issues persists when you disable all accounts move onto step 2.

2.
- create a new user account
- does the mail app open on a new user, if yes then you know your issue is affecting the user library of your user account. Move onto step 3.
- if issues persists in a new user move onto step 4.

3.
- If you are positive all accounts are IMAP and emails are stored on the server (not locally to your device)
- Remove all email internet accounts from system preferences
- delete all contents from the ~/Library/Mail (contents, not the mail folder itself) to the trash and then restart your mac
- test to see if the issue is resolved after the restart, does mail open? If yes you can re-add your accounts

4.
- If issue is happening in both your user and a new user account
- Isolate to see if third-party plugins or extension kernels are causing the issue, Boot to safemode and test the issue.
- If issues persist whilst in safemode i would reinstall the OS.

Funsize,

I've narrowed it down to step 4 safe mode mail opens fine. I can't figure out what third-party plugin or extension maybe crashing Mail. I have looked over my anti-virus program Bitdefender and excluded mail from being scanned.

The console is giving me some errors when Mail crashes but I really can't make heads or tails on this and google search is come up dry. Thoughts

error 08:55:02.323001 -0700 Mail SQLite error 10 (extended: 6922) - disk I/O error: setting server-reported highest mod sequence for IMAP mailbox
error 08:55:02.323198 -0700 Mail SQLite error 1 (extended: 1) - SQL logic error or missing database: rolling back transaction
error 08:55:04.324723 -0700 Mail SQLite error 10 (extended: 6922) - disk I/O error: setting server-reported highest mod sequence for IMAP mailbox
error 08:55:04.324947 -0700 Mail SQLite error 1 (extended: 1) - SQL logic error or missing database: rolling back transaction
error 08:55:05.326710 -0700 Mail SQLite error 10 (extended: 6922) - disk I/O error: gathering message counts
error 08:55:05.326883 -0700 Mail SQLite error 1 (extended: 1) - SQL logic error or missing database: rolling back transaction
error 08:55:07.327572 -0700 Mail SQLite error 10 (extended: 6922) - disk I/O error: setting server-reported highest mod sequence for IMAP mailbox
error 08:55:07.327784 -0700 Mail SQLite error 1 (extended: 1) - SQL logic error or missing database: rolling back transaction
error 08:55:09.329293 -0700 Mail SQLite error 10 (extended: 6922) - disk I/O error: setting server-reported highest mod sequence for IMAP mailbox
error 08:55:09.329486 -0700 Mail [+[MFLibrary executeBlock:isWriter:useTransaction:isPrivileged:]] SQLite error 10: setting server-reported highest mod sequence for IMAP mailbox
default 08:55:49.803315 -0700 Mail multiple links to file: /Users/..../Library/Mail/V5/MailData/Envelope Index
error 08:55:49.804439 -0700 Mail BUG IN CLIENT OF libsqlite3.dylib: database integrity compromised by API violation: vnode unlinked while in use: <unresolvable path>
error 08:55:49.804444 -0700 Mail BUG IN CLIENT OF libsqlite3.dylib: database integrity compromised by API violation: vnode unlinked while in use: <unresolvable path>
error 08:55:49.804488 -0700 Mail BUG IN CLIENT OF libsqlite3.dylib: database integrity compromised by API violation: vnode unlinked while in use: <unresolvable path>
error 08:55:49.804501 -0700 Mail invalidated open fd: 31 (0x11)
error 08:55:49.804510 -0700 Mail invalidated open fd: 22 (0x11)
error 08:55:49.804546 -0700 Mail BUG IN CLIENT OF libsqlite3.dylib: database integrity compromised by API violation: vnode unlinked while in use: <unresolvable path>
error 08:55:49.804552 -0700 Mail invalidated open fd: 17 (0x11)
default 08:55:49.804566 -0700 Mail No temporary database file -journal found, skipping
error 08:55:49.804571 -0700 Mail BUG IN CLIENT OF libsqlite3.dylib: database integrity compromised by API violation: vnode unlinked while in use: <unresolvable path>
error 08:55:49.804627 -0700 Mail invalidated open fd: 11 (0x11)
error 08:55:49.804668 -0700 Mail invalidated open fd: 3 (0x11)
default 08:55:49.804757 -0700 Mail Removed temporary database file -wal
error 08:55:49.804775 -0700 Mail BUG IN CLIENT OF libsqlite3.dylib: database integrity compromised by API violation: vnode unlinked while in use: <unresolvable path>
error 08:55:49.804776 -0700 Mail BUG IN CLIENT OF libsqlite3.dylib: database integrity compromised by API violation: vnode unlinked while in use: <unresolvable path>
error 08:55:49.804805 -0700 Mail BUG IN CLIENT OF libsqlite3.dylib: database integrity compromised by API violation: vnode unlinked while in use: <unresolvable path>
error 08:55:49.804804 -0700 Mail BUG IN CLIENT OF libsqlite3.dylib: database integrity compromised by API violation: vnode unlinked while in use: <unresolvable path>
error 08:55:49.804828 -0700 Mail BUG IN CLIENT OF libsqlite3.dylib: database integrity compromised by API violation: vnode unlinked while in use: <unresolvable path>
error 08:55:49.804981 -0700 Mail invalidated open fd: 32 (0x11)
error 08:55:49.805034 -0700 Mail invalidated open fd: 23 (0x11)
default 08:55:49.805042 -0700 Mail Removed temporary database file -shm
error 08:55:49.805062 -0700 Mail BUG IN CLIENT OF libsqlite3.dylib: database integrity compromised by API violation: vnode unlinked while in use: <unresolvable path>
error 08:55:49.805093 -0700 Mail invalidated open fd: 9 (0x11)
error 08:55:49.805146 -0700 Mail invalidated open fd: 18 (0x11)
error 08:55:49.805198 -0700 Mail invalidated open fd: 12 (0x11)
error 08:55:49.805407 -0700 Mail invalidated open fd: 10 (0x11)
default 08:55:49.812022 -0700 useractivityd -- Demoting self.advertisingProcess to nil (was UserActivityClient(pid=1161/com.apple.mail uuids={}))
default 08:55:49.835499 -0700 UserEventAgent Unregistered XPC Activity: com.apple.mail.ApplicationRefresh
default 08:55:50.118811 -0700 dasd CANCELED: 501:com.apple.mail.ApplicationRefresh:106A8E <private>!

 

[BrianBaughn]

So…in safe mode...all of the three email accounts are usable and there are no crashes?

 

[creativeraul]

So…in safe mode...all of the three email accounts are usable and there are no crashes?

correct.

 

[Funsize93]

correct.

If an issue doesnt happen in safemode you can follow general troubleshooting.

Rule out startup items and login items. Go to Users & Groups preferences pane > Login items. Remove everything non-Apple and restart normally to see if the issue is resolved.

If that doesnt resolve the issue. I would create a backup and then delete the contents within these folders:
- ~/Library/Caches
- ~/Library/LaunchAgents
- /Library/LaunchAgents
- /Library/LaunchDaemons
- /Library/Startupitems

Restart the Mac and empty the trash AFTER the restart NOT before and test.

If your issue still persists I would recommend contacting AppleCare for more advanced troubleshooting.

 

[creativeraul]

I think I pinned the issue down to Little Snitch... testing results.

 

[HDFan]

I think I pinned the issue down to Little Snitch

A quick way to test Little Snitch is to change its Operation mode to "Silent Mode - Allow Connections". You can also open up the rules and see if there are any denied connections.

 

[creativeraul]

So I have narrowed down the issue to SQLite error due to syncing problems with iCloud items that sync across my Apple products. The SQLite errors are effecting items apart from Mail. I can't figure out a solution but mail is the only thing crashing at first run after rebooting.

I have reinstalled the OS "not a nuke and pave" the issue is somewhere in my user Library. I really don't know what to do at this point to resolve the SQLite errors.

Suggestions are welcomed.

 

[Funsize93]

So I have narrowed down the issue to SQLite error due to syncing problems with iCloud items that sync across my Apple products. The SQLite errors are effecting items apart from Mail. I can't figure out a solution but mail is the only thing crashing at first run after rebooting.

I have reinstalled the OS "not a nuke and pave" the issue is somewhere in my user Library. I really don't know what to do at this point to resolve the SQLite errors.

Suggestions are welcomed.

Can you please verify if the issue happened in a new user account? This will isolate if you need to troubleshoot the user library or the system library. If the issue did happen in another user account then you will need to troubleshoot the system library NOT the user library. Vice versa

 

[creativeraul]

I figured out the cause. So I have Gmail and Google calendar tie-in via Internet Accounts. It seems that for me on my MacPro only since upgrading to 10.13.5 the google calendar through internet access is what's crashing Apple Mail.

Once I uncheck calendar - mail works find. It would explain why when I restart mail after the first crash it than works and it works in safe boot. Something to do with how mail is communicating with google calendar via Apple calendar.

Whatever it is I lost the use of handling my google calendar through apple calendar.

It only took fourteen hours of uninstalling or reinstalling a bunch of stuff that now seems to have no affect to Apple Mail.

 

[creativeraul]

Can you please verify if the issue happened in a new user account? This will isolate if you need to troubleshoot the user library or the system library. If the issue did happen in another user account then you will need to troubleshoot the system library NOT the user library. Vice versa

What exactly do I need to do in the new user account after I create it?

 

[creativeraul]

Got some issues in my EtreCheck. Any thought on solutions are welcomed.


EtreCheck version: 4.3.6 (4D041)
Report generated: 2018-08-01 12:57:52
Runtime: 2:49
Performance: Excellent


Diagnostics Information (past 7 days):

2018-08-01 12:34:12 BDLDaemon CPU (3 times)

/Library/Bitdefender/*/antivirus.bundle/BDLDaemon



2018-08-01 09:15:22 installd CPU

/System/Library/PrivateFrameworks/PackageKit.framework/Versions/A/Resources/inst alld



2018-08-01 09:05:12 TextEdit.app Crash

/Applications/TextEdit.app

dyld3: launch started

Sandbox registration internal error: Incoming message euid:0 does not match secinitd uid:501.



2018-08-01 09:05:12 sudo Crash

/usr/bin/sudo



2018-08-01 08:01:01 secd Crash

/usr/libexec/secd

*** Terminating app due to uncaught exception 'NSInvalidArgumentException', reason: '-[__NSCFType length]: unrecognized selector sent to instance 0x7fda04e09200'

terminating with uncaught exception of type NSException

abort() called



2018-07-31 18:41:01 coreservicesd CPU (2 times)

/System/Library/Frameworks/CoreServices.framework/Versions/A/Frameworks/CarbonCo re.framework/Versions/A/Support/coreservicesd



2018-07-31 18:13:21 Dropbox.app Crash (2 times)

/Applications/Dropbox.app



2018-07-31 17:58:36 com.apple.WebKit.WebContent CPU (3 times)

/System/Library/Frameworks/WebKit.framework/Versions/A/XPCServices/com.apple.Web Kit.WebContent.xpc/Contents/MacOS/com.apple.WebKit.WebContent



2018-07-31 17:09:32 Contacts.app Crash

/Applications/Contacts.app

*** Terminating app due to uncaught exception 'NSInvalidArgumentException', reason: 'Invalid parameter not satisfying 'uniqueIDs != nil''

terminating with uncaught exception of type NSException

abort() called



2018-07-31 14:00:55 Mail.app Hang (15 times)

/Applications/Mail.app



2018-07-31 13:54:41 bird Crash (2 times)

/System/Library/PrivateFrameworks/CloudDocsDaemon.framework/Versions/A/Support/b ird

*** Terminating app due to uncaught exception 'NSInternalInconsistencyException', reason: '-flush is invalid when in a savepoint'

terminating with uncaught exception of type NSException

abort() called



2018-07-26 08:53:25 assistantd Crash (2 times)

/System/Library/PrivateFrameworks/AssistantServices.framework/Versions/A/Support /assistantd

objc_msgSend() selector name: retain



2018-07-26 08:53:20 cloudd Crash (3 times)

/System/Library/PrivateFrameworks/CloudKitDaemon.framework/Support/cloudd

*** Terminating app due to uncaught exception 'NSGenericException', reason: 'Error executing SQL: "delete from Record where expirationTime < 554313150" (6922) - errcode:1b0a, msg:"disk I/O error", size: 36864, path:/Users/***/Library/Containers/com.apple.Notes/*/Records.db, fs:69537701888/250790436864'

terminating with uncaught exception of type NSException

abort() called

 

[Funsize93]

What exactly do I need to do in the new user account after I create it?

I really need you to follow my steps. You are doing unnecessary troubleshooting steps. This should have only taken 30mins to isolate and then resolve.

- Have you followed the steps in my first response?
- Have you performed basic troubleshooting such as removing the email accounts entirely and re-adding them? (to refresh the syncing services)
- Creating a new user account is an isolation step. You try and create the issue in a new user account (add your emails in a new user and see if mail crashes still) if the issue does not happen in a new user account then you know there is a file in your original user library causing the crash. If the issue persists in a new user account then you know its not a user specific problem as a new user will have a fresh user library free of corruption, this would mean that the issue would be affecting the system library because it affects all users.
- If the issue is affecting multiple users and you have already isolated third-party extensions or kernels by booting into safemode then you should try my other troubleshooting steps:

If an issue doesnt happen in safemode you can follow general troubleshooting.

Rule out startup items and login items. Go to Users & Groups preferences pane > Login items. Remove everything non-Apple and restart normally to see if the issue is resolved.

If that doesnt resolve the issue. I would create a backup and then delete the contents within these folders:
- ~/Library/Caches
- ~/Library/LaunchAgents
- /Library/LaunchAgents
- /Library/LaunchDaemons
- /Library/Startupitems

Restart the Mac and empty the trash AFTER the restart NOT before and test.

If your issue still persists I would recommend contacting AppleCare for more advanced troubleshooting as they will need to filter through all the kernel files on your mac and compare them to what should be there.

 

[creativeraul]

1.
- disable all internet email accounts in system preferences. - Yes, Done that and also removed them and added them back.
- Try opening mail now. If it opens without crashing, one of the accounts are the cause. Turn each one on, one by one while opening mail between each one to find out which is the culprit. When you find the culprit it would be best to remove and re-add the affected account (in system prefs). Mail opens fine without e-mail accounts.
- if issues persists when you disable all accounts move onto step 2.

2.
- create a new user account - Just did that Mail works fine with all accounts added. I wan't logged into my iCloud acct.
- does the mail app open on a new user, if yes then you know your issue is affecting the user library of your user account. Move onto step 3.
- if issues persists in a new user move onto step 4.

3.
- If you are positive all accounts are IMAP and emails are stored on the server (not locally to your device) All accounts are IMAP
- Remove all email internet accounts from system preferences
- delete all contents from the ~/Library/Mail (contents, not the mail folder itself) to the trash and then restart your mac
- test to see if the issue is resolved after the restart, does mail open? If yes you can re-add your accounts
REMOVED ALL ACCOUNTS AND /MAIL CONTENT REBOOTED AND ADDED ACCOUNTS. SAME ISSUE CRASH

4.
- If issue is happening in both your user and a new user account
- Isolate to see if third-party plugins or extension kernels are causing the issue, Boot to safemode and test the issue.
- If issues persist whilst in safemode i would reinstall the OS.

DID THE SAFEMODE REBOOT AND MAIL WORKS. REINSTALLED THE OS STILL SAME ISSUE.

By the way I noticed that all three accounts work fine when logged out of iCloud. In both the primary and the temp account I created to test the Mail account. Once I log into iCloud the crashing happens.

I don't know how to get around the issue.

 

[Funsize93]

Thank you for the clarification.

So far we know the issue is user specific as it did not occur in the new user account.

We also know that a 3rd party kernel, extensions or login item is causing this. (possibly a login item for your user)

Do this next:
Rule out startup items and login items. Go to Users & Groups preferences pane > Login items. Remove everything non-Apple and restart normally to see if the issue is resolved.

If that doesnt resolve the issue. I would create a backup and then delete the contents within these folders (some folders may already be empty):
- ~/Library/Caches
- ~/Library/LaunchAgents
- ~/Library/Inputmethods
- ~/Library/SavedApplicationState
- /Library/Caches
- /Library/LaunchAgents
- /Library/LaunchDaemons
- /Library/Startupitems

Do not empty the trash until after you have restarted the Mac.

If issues persists I would contact AppleCare phone support so they gather logs and escalate to the Apple software engineers. As you may have stumbled across a legitimate bug or another file somewhere we have overlooked causing this to happen.

 

[creativeraul]

Ya, I'll just have to live with the crashing. What you're asking me to do is going to break the system. All those folders are in the new temp account and mail works fine. The only folder missing in the temp account is LaunchAgents and I removed everything inside the folder in the Primary account and rebooted. Same issue.

I put all the items back in the LaunchAgents folder. Im walking away from tinkering under the hood before I break my work system for good. Hopefully in the next OS upgrade it will fix the issue.

 

[Funsize93]

It will not break the OS. The system recreates these files fresh after the restart. This will eliminate any corruption.

As far as a user specific related issue. Future updates wont fix that as they do not change the user configuration, it only updates the system library. Not user files.

Last resort if you do not wish to contact AppleCare or follow the steps above, would be to: migrate all your user data into a new user account. Then delete the corrupted user.

 

[TheKnittingCircle]

You need to isolate:

1.
- disable all internet email accounts in system preferences.
- Try opening mail now. If it opens without crashing, one of the accounts are the cause. Turn each one on, one by one while opening mail between each one to find out which is the culprit. When you find the culprit it would be best to remove and re-add the affected account (in system prefs).
- if issues persists when you disable all accounts move onto step 2.

2.
- create a new user account
- does the mail app open on a new user, if yes then you know your issue is affecting the user library of your user account. Move onto step 3.
- if issues persists in a new user move onto step 4.

3.
- If you are positive all accounts are IMAP and emails are stored on the server (not locally to your device)
- Remove all email internet accounts from system preferences
- delete all contents from the ~/Library/Mail (contents, not the mail folder itself) to the trash and then restart your mac
- test to see if the issue is resolved after the restart, does mail open? If yes you can re-add your accounts

4.
- If issue is happening in both your user and a new user account
- Isolate to see if third-party plugins or extension kernels are causing the issue, Boot to safemode and test the issue.
- If issues persist whilst in safemode i would reinstall the OS.

In May 2022 this solution worked. Thank you!

I found this by googling:

===========
Application Specific Information:
*** Terminating app due to uncaught exception 'NSInternalInconsistencyException', reason: 'This method must be called in the NegotiatingAuthentication state'
terminating with uncaught exception of type NSException
abort() called
===========



It was a 'bad account'. Disabling accounts in prefs let Apple mail launch properly.

Turned account back on and it works fine. It must have needed to just clear out some files, cache etc. No changes made to accounts btw.

Steps: Accounts off, launch mail, quit mail, accounts on, launch mail.

Running 10.13.6