I hoped that by paying for the upgrade, I would be able to avoid the slow lookups, but this is still much too slow. Like below. Five minutes for each lookup.
Nov 12, 2011 1:54:43 PM: INFO: Task 9:Successfully matched 41 songs to the MusicBrainz Release ae879bee-67f8-4036-9a36-ce81ad4ba661 with title Goodbye, Babylon (Compilation)
Nov 12, 2011 1:59:34 PM: INFO: Task 9:Successfully matched 42 songs to the MusicBrainz Release ae879bee-67f8-4036-9a36-ce81ad4ba661 with title Goodbye, Babylon (Compilation)
N
I’m getting a lot of these exceptions in the debug log:
java.sql.SQLException: Connections could not be acquired from the underlying database!
\tat com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
\tat com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
\tat com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
\tat com.jthink.jaikoz.db.Db.createConnection(Db.java:421)
\tat com.jthink.jaikoz.db.Db.runQuery(Db.java:486)
\tat com.jthink.jaikoz.manipulate.matchinghelper.ArtistCache.getArtistFromDatabase(ArtistCache.java:95)
\tat com.jthink.jaikoz.manipulate.matchinghelper.ArtistCache.get(ArtistCache.java:71)
\tat com.jthink.jaikoz.manipulate.matchinghelper.ArtistCache.addFromWeb(ArtistCache.java:215)
\tat com.jthink.jaikoz.manipulate.matchinghelper.ArtistCache.getOrAdd(ArtistCache.java:253)
\tat com.jthink.jaikoz.manipulate.musicbrainzhelper.ArtistCreditHelper.getTrackArtistCredit(ArtistCreditHelper.java:322)
\tat com.jthink.jaikoz.manipulate.musicbrainzhelper.MusicBrainzUpdateSong.updateTagFromMusicBrainz(MusicBrainzUpdateSong.java:1652)
\tat com.jthink.jaikoz.manipulate.musicbrainzhelper.UpdateTrackFromMusicbrainzRelease.updateTagsFromReleaseScore(UpdateTrackFromMusicbrainzRelease.java:41)
\tat com.jthink.jaikoz.manipulate.CorrectFromMusicBrainzWorker.call(CorrectFromMusicBrainzWorker.java:352)
\tat com.jthink.jaikoz.manipulate.CorrectFromMusicBrainzWorker.call(CorrectFromMusicBrainzWorker.java:36)
\tat java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
\tat java.util.concurrent.FutureTask.run(FutureTask.java:138)
\tat java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
\tat java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
\tat java.util.concurrent.FutureTask.run(FutureTask.java:138)
\tat java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
\tat java.lang.Thread.run(Thread.java:680)
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
\tat com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)
\tat com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
\tat com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
\tat com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
\t... 20 more
13/11/2011 01.45.24:com.jthink.jaikoz.manipulate.musicbrainzhelper.MusicBrainzServerQuery:doQuery:SEVERE: 01:45:24:294:URL Decoded:http://musicbrainz.org/ws/2/artist/b09ae88f-4156-4caa-b129-1cacb5e1632e?inc=aliases tags
13/11/2011 01.45.24:com.jthink.jaikoz.db.Db:printSQLException:SEVERE: Err:Connections could not be acquired from the underlying database!:ErrCode:0:State:null
13/11/2011 01.45.24:com.jthink.jaikoz.manipulate.matchinghelper.ArtistCache:addArtistToDatabase:WARNING: Failed addArtistToDatabase:Connections could not be acquired from the underlying database!
java.sql.SQLException: Connections could not be acquired from the underlying database!
\tat com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
\tat com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
\tat com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
\tat com.jthink.jaikoz.db.Db.createConnection(Db.java:421)
\tat com.jthink.jaikoz.manipulate.matchinghelper.ArtistCache.addArtistToDatabase(ArtistCache.java:169)
\tat com.jthink.jaikoz.manipulate.matchinghelper.ArtistCache.addFromWeb(ArtistCache.java:218)
\tat com.jthink.jaikoz.manipulate.matchinghelper.ArtistCache.getOrAdd(ArtistCache.java:253)
\tat com.jthink.jaikoz.manipulate.musicbrainzhelper.ArtistCreditHelper.getTrackArtistCredit(ArtistCreditHelper.java:322)
\tat com.jthink.jaikoz.manipulate.musicbrainzhelper.MusicBrainzUpdateSong.updateTagFromMusicBrainz(MusicBrainzUpdateSong.java:1652)
\tat com.jthink.jaikoz.manipulate.musicbrainzhelper.UpdateTrackFromMusicbrainzRelease.updateTagsFromReleaseScore(UpdateTrackFromMusicbrainzRelease.java:41)
\tat com.jthink.jaikoz.manipulate.CorrectFromMusicBrainzWorker.call(CorrectFromMusicBrainzWorker.java:352)
\tat com.jthink.jaikoz.manipulate.CorrectFromMusicBrainzWorker.call(CorrectFromMusicBrainzWorker.java:36)
\tat java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
\tat java.util.concurrent.FutureTask.run(FutureTask.java:138)
\tat java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
\tat java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
\tat java.util.concurrent.FutureTask.run(FutureTask.java:138)
\tat java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
\tat java.lang.Thread.run(Thread.java:680)
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
\tat com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)
\tat com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
\tat com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
\tat com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
\t... 18 more
13/11/2011 01.45.24:com.jthink.jaikoz.db.Db:printSQLException:SEVERE: Err:Connections could not be acquired from the underlying database!:ErrCode:0:State:null
13/11/2011 01.45.24:com.jthink.jaikoz.db.Db:printSQLException:SEVERE: Err:Connections could not be acquired from the underlying database!:ErrCode:0:State:null:Sql:select xmldata from artist where guid='b09ae88f-4156-4caa-b129-1cacb5e1632e'
13/11/2011 01.45.24:com.jthink.jaikoz.manipulate.matchinghelper.ArtistCache:getArtistFromDatabase:WARNING: Failed getArtistFromDatabase:Connections could not be acquired from the underlying database!
java.sql.SQLException: Connections could not be acquired from the underlying database!
\tat com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
\tat com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
\tat com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
\tat com.jthink.jaikoz.db.Db.createConnection(Db.java:421)
\tat com.jthink.jaikoz.db.Db.runQuery(Db.java:486)
\tat com.jthink.jaikoz.manipulate.matchinghelper.ArtistCache.getArtistFromDatabase(ArtistCache.java:95)
\tat com.jthink.jaikoz.manipulate.matchinghelper.ArtistCache.get(ArtistCache.java:71)
\tat com.jthink.jaikoz.manipulate.matchinghelper.ArtistCache.getOrAdd(ArtistCache.java:251)
\tat com.jthink.jaikoz.manipulate.musicbrainzhelper.MusicBrainzUpdateSong.getReleaseArtistCredit(MusicBrainzUpdateSong.java:1609)
\tat com.jthink.jaikoz.manipulate.musicbrainzhelper.MusicBrainzUpdateSong.updateTagFromMusicBrainz(MusicBrainzUpdateSong.java:1659)
\tat com.jthink.jaikoz.manipulate.musicbrainzhelper.UpdateTrackFromMusicbrainzRelease.updateTagsFromReleaseScore(UpdateTrackFromMusicbrainzRelease.java:41)
\tat com.jthink.jaikoz.manipulate.CorrectFromMusicBrainzWorker.call(CorrectFromMusicBrainzWorker.java:352)
\tat com.jthink.jaikoz.manipulate.CorrectFromMusicBrainzWorker.call(CorrectFromMusicBrainzWorker.java:36)
\tat java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
Any thoughts on how to make the matching run faster than geologic speeds?