Safari is filling my system log

Question

Safari is filling my system log

Safari 8, OS 10.10.1 on a Retina MBP, with all Safari extensions disabled.

My system log is filled with literally thousands of nsurlstoraged errors like the ones below. The problem exists in system log files going back a week, (i.e., 3 days before I updated to 10.10.1). I have reset Safari (Clear History and website data), rebooted, etc, and the problem persists.

Watching the system log in real time, via tail, shows that a burst of these nsurlstoraged errors appear every time I visit a new page in Safari. The errors stop after a second or so, until I visit a new page.

I have checked for bogus launch daemons, launch agents, etc, in /Library and ~/Library, and there are no unexpected files present there. Running out of ideas.

Nov 20 15:47:59 Jays-rMBP.local nsurlstoraged[276]: writeDBwithCachedResponse-ERROR: task-mgr=com.apple.WebKit.Networking-write (_dbWriteConnection=0x7f8372322640) insert SQL stmnt. is nil for item: http://cdn.sstatic.net/img/share-sprite-new.svg?v=7966d6d82b78[stackexchange.com ]

Nov 20 15:47:59 Jays-rMBP.local nsurlstoraged[276]: Error: execSQLStatement:onConnection:toCompletionWithRetry - SQL=COMMIT;, error-code=1, error-message=cannot commit - no transaction is active

Nov 20 15:47:59 Jays-rMBP.local nsurlstoraged[276]: writeDBwithCachedResponse-ERROR: task-mgr=com.apple.WebKit.Networking-write (_dbWriteConnection=0x7f8372322640) insert SQL stmnt. is nil for item: http://cdn.sstatic.net/Img/mini-hero-bg.png?v=7f269bbbdb22[stackexchange.com]

Nov 20 15:47:59 Jays-rMBP.local nsurlstoraged[276]: Error: execSQLStatement:onConnection:toCompletionWithRetry - SQL=COMMIT;, error-code=1, error-message=cannot commit - no transaction is active

Nov 20 15:47:59 Jays-rMBP.local nsurlstoraged[276]: writeDBwithCachedResponse-ERROR: task-mgr=com.apple.WebKit.Networking-write (_dbWriteConnection=0x7f8372322640) insert SQL stmnt. is nil for item: https://discussions.apple.com/6.0.3.0/themes/apple_0.7.0/img/bg-body.png[apple.c om]

Nov 20 15:47:59 Jays-rMBP.local nsurlstoraged[276]: Error: execSQLStatement:onConnection:toCompletionWithRetry - SQL=COMMIT;, error-code=1, error-message=cannot commit - no transaction is active

Nov 20 15:47:59 Jays-rMBP.local nsurlstoraged[276]: writeDBwithCachedResponse-ERROR: task-mgr=com.apple.WebKit.Networking-write (_dbWriteConnection=0x7f8372322640) insert SQL stmnt. is nil for item: https://www.apple.com/ac/globalheader/1.0/images/lang/en-US/tab_store.svg[apple. com]

Nov 20 15:47:59 Jays-rMBP.local nsurlstoraged[276]: Error: execSQLStatement:onConnection:toCompletionWithRetry - SQL=COMMIT;, error-code=1, error-message=cannot commit - no transaction is active

...

Nov 20 15:48:02 Jays-rMBP.local nsurlstoraged[276]: writeDBwithCachedResponse-ERROR: task-mgr=Safari-write (_dbWriteConnection=0x7f8372016740) insert SQL stmnt. is nil for item: https://dalk4zrp4jp3q.cloudfront.net/images/mac_YFVkNF/ustv_g.png

Nov 20 15:48:02 Jays-rMBP.local nsurlstoraged[276]: Error: execSQLStatement:onConnection:toCompletionWithRetry - SQL=COMMIT;, error-code=1, error-message=cannot commit - no transaction is active

Nov 20 15:48:02 Jays-rMBP.local nsurlstoraged[276]: writeDBwithCachedResponse-ERROR: task-mgr=Safari-write (_dbWriteConnection=0x7f8372016740) insert SQL stmnt. is nil for item: https://dalk4zrp4jp3q.cloudfront.net/images/mac_YFVkNF/wiki_icon_2x.png

Nov 20 15:48:02 Jays-rMBP.local nsurlstoraged[276]: Error: execSQLStatement:onConnection:toCompletionWithRetry - SQL=COMMIT;, error-code=1, error-message=cannot commit - no transaction is active

MacBook Pro with Retina display, OS X Yosemite (10.10.1)

Posted on Nov 20, 2014 1:38 PM

Reply

Answer 1

Nov 20, 2014 2:10 PM in response to wildlife_photo

Thought of one more thing to try. I logged out of my user account and logged in to the admin account. The nsurlstoraged errors to not appear while I am using Safari from the admin account.

Thanks in advance for any suggestions,

Reply

Answer 2

Linc Davis

Level 10

209,667 points

Nov 20, 2014 4:17 PM in response to wildlife_photo

Restart the computer in safe mode. Certain caches maintained by the system will be rebuilt.

Safe mode is much slower to start up than normal. The next normal startup may also be somewhat slow.

When the login screen appears, restart as usual (not in safe mode) and test. There's no need to log in while in safe mode.

Note: If FileVault is enabled in OS X 10.9 or earlier, or if a firmware password is set, or if the startup volume is a software RAID, you can’t start in safe mode. In that case, ask for instructions.

Reply

Answer 3

Nov 20, 2014 7:08 PM in response to Linc Davis

Thanks very much for the suggestion. I did a safe boot, followed by regular boot. As soon as I launched Safari, the log filled up with 249 nsurlstoraged errors. Here are the first few:

Nov 20 22:01:04 Jays-rMBP.local nsurlstoraged[286]: Error: execSQLStatement:onConnection:toCompletionWithRetry - SQL=PRAGMA auto_vacuum = 2;, error-code=11, error-message=database disk image is malformed

Nov 20 22:01:04 Jays-rMBP.local nsurlstoraged[286]: ERROR: NSURLStorageURLCacheDB _setDBSchema: _dbWriteConnection=0x7f8fe843a720 DB=/Users/jaym/Library/Caches/com.apple.Safari/Cache.db pragma auto vacuum - database disk image is malformed. ErrCode: 11.

Nov 20 22:01:04 Jays-rMBP.local storeaccountd[295]: AccountServiceDelegate: Accepting new connection <NSXPCConnection: 0x7fe674972b20> connection from pid 561 with interface <AccountServiceInterface: 0x7fe674934b50> (PID 561)

Nov 20 22:01:04 Jays-rMBP com.apple.xpc.launchd[1] (com.apple.imfoundation.IMRemoteURLConnectionAgent): The _DirtyJetsamMemoryLimit key is not available on this platform.

Nov 20 22:01:05 --- last message repeated 1 time ---

Nov 20 22:01:05 Jays-rMBP.local nsurlstoraged[286]: Error: execSQLStatement:onConnection:toCompletionWithRetry - SQL=PRAGMA auto_vacuum = 2;, error-code=11, error-message=database disk image is malformed

Nov 20 22:01:05 --- last message repeated 1 time ---

Nov 20 22:01:05 Jays-rMBP.local nsurlstoraged[286]: ERROR: NSURLStorageURLCacheDB _setDBSchema: _dbWriteConnection=0x7f8fea205730 DB=/Users/jaym/Library/Caches/com.apple.Safari/Cache.db pragma auto vacuum - database disk image is malformed. ErrCode: 11.

Nov 20 22:01:05 Jays-rMBP.local nsurlstoraged[286]: ERROR: NSURLStorageURLCacheDB _setDBSchema: _dbWriteConnection=0x7f8fea111a30 DB=/Users/jaym/Library/Caches/com.apple.Safari/Cache.db pragma auto vacuum - database disk image is malformed. ErrCode: 11.

Nov 20 22:01:05 Jays-rMBP.local locationd[217]: Couldn't find a requirement string for masquerading client /System/Library/PrivateFrameworks/Parsec.framework

Nov 20 22:01:05 Jays-rMBP.local locationd[217]: could not get apple languages array, assuming english

Nov 20 22:01:05 Jays-rMBP com.apple.xpc.launchd[1] (com.apple.imfoundation.IMRemoteURLConnectionAgent): The _DirtyJetsamMemoryLimit key is not available on this platform.

Nov 20 22:01:07 Jays-rMBP.local nsurlstoraged[286]: INIT-FAIL: _sqlInsertStmtResponse=0x0, DB=/Users/jaym/Library/Caches/com.apple.Safari/Cache.db, error-code:11.

Nov 20 22:01:07 Jays-rMBP.local nsurlstoraged[286]: writeDBwithCachedResponse-ERROR: task-mgr=Safari-write (_dbWriteConnection=0x7f8fe860aa70) insert SQL stmnt. is nil for item: https://api.smoot.apple.com/bag?locale=en-US&key=andromeda

Nov 20 22:01:07 Jays-rMBP.local nsurlstoraged[286]: Error: execSQLStatement:onConnection:toCompletionWithRetry - SQL=COMMIT;, error-code=1, error-message=cannot commit - no transaction is active

Nov 20 22:01:07 Jays-rMBP.local nsurlstoraged[286]: writeDBwithCachedResponse-ERROR: task-mgr=Safari-write (_dbWriteConnection=0x7f8fe860aa70) insert SQL stmnt. is nil for item: https://dalk4zrp4jp3q.cloudfront.net/images/mac_YFVkNF/movie_placeholder_2x.png

Nov 20 22:01:07 Jays-rMBP.local nsurlstoraged[286]: Error: execSQLStatement:onConnection:toCompletionWithRetry - SQL=COMMIT;, error-code=1, error-message=cannot commit - no transaction is active

Nov 20 22:01:07 Jays-rMBP.local nsurlstoraged[286]: writeDBwithCachedResponse-ERROR: task-mgr=Safari-write (_dbWriteConnection=0x7f8fe860aa70) insert SQL stmnt. is nil for item: https://init.itunes.apple.com/WebObjects/MZInit.woa/wa/signSapSetupCert

Nov 20 22:01:07 Jays-rMBP.local nsurlstoraged[286]: Error: execSQLStatement:onConnection:toCompletionWithRetry - SQL=COMMIT;, error-code=1, error-message=cannot commit - no transaction is active

Nov 20 22:01:07 Jays-rMBP.local nsurlstoraged[286]: writeDBwithCachedResponse-ERROR: task-mgr=Safari-write (_dbWriteConnection=0x7f8fe860aa70) insert SQL stmnt. is nil for item: https://dalk4zrp4jp3q.cloudfront.net/images/mac_YFVkNF/appstore_icon_small_2x.pn g

Nov 20 22:01:07 Jays-rMBP.local nsurlstoraged[286]: Error: execSQLStatement:onConnection:toCompletionWithRetry - SQL=COMMIT;, error-code=1, error-message=cannot commit - no transaction is active

Reply

Answer 4

Linc Davis

Level 10

209,667 points

Nov 20, 2014 7:42 PM in response to wildlife_photo

Back up all data before proceeding.

Triple-click anywhere in the line below on this page to select it:

~/Library/Caches/com.apple.Safari

Right-click or control-click the line and select

Services ▹ Reveal in Finder (or just Reveal)

from the contextual menu.* A folder should open with an item selected. Quit the application if it's running. Move the selected item to the Trash. Relaunch the application and test.

*If you don't see the contextual menu item, copy the selected text to the Clipboard by pressing the key combination command-C. In the Finder, select

Go ▹ Go to Folder...

from the menu bar and paste into the box that opens by pressing command-V. You won't see what you pasted because a line break is included. Press return.

Reply

Answer 5

Nov 21, 2014 2:31 AM in response to Linc Davis

Deleting the folder ~/Library/Caches/com.apple.Safari did the trick. Thanks very much.

Reply

Answer 6

Dec 3, 2014 6:33 AM in response to Linc Davis

Helpful, and clearly described; thanks.

Reply