Level 1

35 points

Database.sqlite3 keeps showing up in my Trash

Ever since I upgraded to Leopard, a file named Database.sqlite3 keeps showing up in my Trash. I empty the trash and the file shows up again after a hour or so passes. Does anyone know what this file is and why it keeps getting trashed?

MacBook Pro 17" Core 2 Duo, Mac OS X (10.4.10)

Posted on Oct 28, 2007 7:25 AM

45 replies

Nov 21, 2007 8:14 PM in response to jkwuc89

I'm not sure I'd call this thread "answered". The answer is to disable bookmark syncing, which is a feature of .Mac that many pay extra for. Clearly this is a bug that needs to be fixed in Leopard.

cocoon.4

Level 1

0 points

Nov 30, 2007 7:53 AM in response to atbmacpro

and syncing with .Mac isn't working properly... not even with Mail...! Worked better with Tiger...!
I wouldn't call the thread 'answered' at all...! And Apple should think about an extra month for .Mac-Users...!

Mr_Ghost

Level 1

5 points

Nov 30, 2007 8:04 AM in response to atbmacpro

Agreed. Problem is not closed. I've found just what the problem comes from. Apple should investivate this situation more closely.

Dec 18, 2007 7:31 AM in response to Mr_Ghost

This problem is definitely not solved, especially for those of us who do not use .Mac, but are having the same problem.

Dec 19, 2007 6:39 AM in response to Blue Ninja

I turned off the Mail's RSS feed services--deleted all feeds, switched back to Safari RSS as default, and turned of updating, and have had no further problems with the sqlite files showing up in trash so far, and it usually happens about once a day in the mornings for me...

So, either mail RSS is messed up, or the conflict between having both Mail and Safari update RSSs was generating the file.

I suggest going back to Safari RSS and killing all Mail RSS functions.

Turkchgo

Level 1

0 points

Dec 20, 2007 5:20 AM in response to jkwuc89

It would appear, for now, that the latest security update 2007-009 has fixed the problem on my G5.

No more database folders in the trash.

gglenng

Level 1

10 points

Mar 2, 2008 11:58 AM in response to jkwuc89

I'm wondering if this issue has been resolved for others because it still is a problem for me.
I've already updated to Leopard 10.5.2 and the issue still exists. I tried other suggested fixes like deleting ~/Library/PubSub/Database/Database.sqlite3 after quitting Safari & Mail and killing pubsub agent process. It never worked. The only solution that works is still disabling bookmark syncing in .Mac, which is so lame considering that it is one of the more useful features of .Mac syncing.

Mar 2, 2008 6:31 PM in response to gglenng

I am still getting them myself.

Mar 3, 2008 12:38 AM in response to gglenng

It could be related to the iTunes Database not saving correctly, I'm not totally sure but just today my disk became full, iTunes was open at the time and gave me a warning saying the iTunes database couldn't be saved. (not sure why? if someone knows please tell me). I empty some trash and the Database.sqlite3 file appears in there, This was the first time for me so I just thought I'd say how I first came across the file.

gglenng

Level 1

10 points

Mar 3, 2008 6:19 AM in response to Josh Kunze

Do you have a .Mac account, and if so, is bookmark syncing turned on?

Mar 3, 2008 1:10 PM in response to gglenng

yea i do, and i did have it on. I have turned that off, and it still showed. then i turned syncing to manually and now it doesn't show anymore

gglenng

Level 1

10 points

Mar 4, 2008 2:53 PM in response to skcomp123

Hhm, having it not happen only if you turn on manual syncing is certainly different from my experience. Well, the bug is definitely still unresolved which is what I wanted to find out. It's not a serious bug but it is certainly annoying. Hope Apple resolves it soon.

Mar 12, 2008 1:40 PM in response to gglenng

I'm still getting them on 2/3 of my macs (I believe the first upgraded to leopard is the one w/o the behavior, but I am not certain.) It is accompanied by frequent crashes of the PubSub agent. this is happening even on fresh installs updated to the latest (yesterday).

jez777

Level 1

0 points

Apr 7, 2008 12:38 PM in response to Ian Parkinson

quitting mail works for me

gglenng

Level 1

10 points

Apr 7, 2008 12:44 PM in response to jez777

The Safari 3.1 update has resolved this issue. No more Database.sqlite3 files in the Trash even with bookmark syncing turned on in .Mac preferences.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Database.sqlite3 keeps showing up in my Trash