Core Data SQLite share hang on 10.6.2
Core Data SQLite share hang on 10.6.2
- Subject: Core Data SQLite share hang on 10.6.2
- From: Steve Steinitz <email@hidden>
- Date: Thu, 21 Jan 2010 18:30:46 +1100
Hello,
For the past few years we've been running a Core Data SQLite
application on 5 machines, all accessing the database from a
Synology network drive via afp. However, after upgrading to
10.6.2, only one machine can access the database at a time. Any
number of machines still running 10.6.1 or earlier can always
access the database and do not impede other machines from
accessing it.
When a 10.6.2 machine has already connected to the database, any
10.6.2 machine application trying to connect (create a persisten
store coordinator) will hang (stack trace below), but will
happily continue once the other 10.6.2 machine application quits.
My questions are:
1. is there a component I can downgrade to get the
pre-10.6.2 sharing behavior?
2. can our application do some kind of unlock to
allow other machines to access the database?
I tried periodically calling [context unlock] but it didn't seem
to help.
A workaround is to downgrade some of the machines to 10.6.0 --
not nice.
I've submitted bug 7564345.
Any suggestions appreciated,
Steve
Note: building the app with 10.6 sdk (in Xcode 3.2.1) -
but the problem also occurs with 10.5 sdk when running on 10.6.2
Hangs, waiting, here:
pread$UNIX2003
proxyTakeConch
proxyLock
sqlite3PagerAcquire
sqlite3BtreeBeginTrans
btreeCursor
sqlite3InitOne
sqlite3Init
sqlite3Pragma
yy_reduce
sqlite3Parser
sqlite3RunParser
sqlite3LockAndPrepare
[NSSQLiteConnection _executeSQLString:]
[NSSQLiteConnection _configurePragmaOptions]
[NSSQLiteConnection connect]
[NSSQLCore _loadOrSetMetadata]
[NSSQLCore _ensureMetadataLoaded]
[NSSQLCore initWithPersistentStoreCoordinator:
configurationName:
URL:
options:]
[NSPersistentStoreCoordinator addPersistentStoreWithType:
configuration:
URL:
options:
error:]
_______________________________________________
Cocoa-dev mailing list (email@hidden)
Please do not post admin requests or moderator comments to the list.
Contact the moderators at cocoa-dev-admins(at)lists.apple.com
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden