0
Answered

Ubooquity stopped displaying comics, books still work fine

Andreas Glancii 8 years ago updated by Tom 8 years ago 5

A week or two ago, Ubooquity stopped displaying comic thumbnails and links. The books section still works perfectly fine.


At first I thought it was the same problem others were having, perhaps related to user/security issues blocking the displaying of the comics, which still appeared in the database (2994 comics found).


But after experimenting with creating new users and disabling security altogether, this hasn't resolved the issue at all. It seems the database is being rebuilt each time I launch Ubooquity, but it is having errors writing to the database along the way, by the looks of the log:


20160412 09:59:38 [Scanner thread] INFO com.ubooquity.data.database.b - Inserting/updating comic entry in database : K:\Comics\Alphabetical\Bart Simpson (Bongo)\Bart Simpson v2000 007 (2002).cbz

20160412 09:59:40 [Scanner thread] ERROR com.ubooquity.data.database.b - Error while creating/updating comic in database
org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "COMIC"; SQL statement:
merge into comic(parentid, rootid, isdirectory, title, norm_title, filedate, filepath, lastupdatedate,filesize,description,language,norm_language,seriesname,norm_seriesname,seriesindex,volume,publicationdate,writers,norm_writers,pencillers,norm_pencillers,genre,norm_genre,pagecount) key(filepath)values(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [50200-187]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) ~[h2-1.4.187.jar.3011849094000993925.tmp:1.4.187]
at org.h2.message.DbException.get(DbException.java:179) ~[h2-1.4.187.jar.3011849094000993925.tmp:1.4.187]
at org.h2.message.DbException.get(DbException.java:155) ~[h2-1.4.187.jar.3011849094000993925.tmp:1.4.187]
at org.h2.table.RegularTable.doLock1(RegularTable.java:509) ~[h2-1.4.187.jar.3011849094000993925.tmp:1.4.187]
at org.h2.table.RegularTable.lock(RegularTable.java:472) ~[h2-1.4.187.jar.3011849094000993925.tmp:1.4.187]
at org.h2.command.dml.Update.update(Update.java:89) ~[h2-1.4.187.jar.3011849094000993925.tmp:1.4.187]
at org.h2.command.dml.Merge.merge(Merge.java:154) ~[h2-1.4.187.jar.3011849094000993925.tmp:1.4.187]
at org.h2.command.dml.Merge.update(Merge.java:106) ~[h2-1.4.187.jar.3011849094000993925.tmp:1.4.187]
at org.h2.command.CommandContainer.update(CommandContainer.java:78) ~[h2-1.4.187.jar.3011849094000993925.tmp:1.4.187]
at org.h2.command.Command.executeUpdate(Command.java:254) ~[h2-1.4.187.jar.3011849094000993925.tmp:1.4.187]
at org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:198) ~[h2-1.4.187.jar.3011849094000993925.tmp:1.4.187]
at com.ubooquity.data.database.b.a(SourceFile:549) [Ubooquity.jar:1.9.1]
at com.ubooquity.data.database.b.a(SourceFile:53) [Ubooquity.jar:1.9.1]
at com.ubooquity.data.feeder.a.b(SourceFile:525) [Ubooquity.jar:1.9.1]
at com.ubooquity.data.feeder.a.c(SourceFile:470) [Ubooquity.jar:1.9.1]
at com.ubooquity.data.feeder.a.b(SourceFile:35) [Ubooquity.jar:1.9.1]
at com.ubooquity.data.feeder.a$1.run(SourceFile:123) [Ubooquity.jar:1.9.1]
at java.lang.Thread.run(Unknown Source) [na:1.8.0_71]


I'm running Ubooquity on a Win10 machine, along with Mylar and Comic Rack which does the lion's share of the meta data work


Than ks!

Searching answer

Update: I updated Java.


I also watched a scan of the library complete. It reports that it added/updated 2990 comics, removed none and total comics = 0.


Change: When I load Ubooquity in my browser, I now get comics listed, but the thumbnails are either the generic folder icon, or the same cover repeated for all thumbnails.


While I can navigate through to the 'Read/Download' option, after I make a choice, the comic tries to load, the timer craps out and I get a Page Not Found error.

+1

Still trying to figure out what might be happening...

Did you try to completely delete the database and rescan everything ?


To do that:

  1. stop Ubooquity
  2. delete (or move somewhere else) the ubooquity-4.h2.db file in your Ubooquity working directory
  3. restart Ubooquity

Looks like that has done the trick Tom - thank you SO MUCH mate. I think I may have corrupted the database or something by changing the folder locations of the library (I moved them into folders by Publisher) whilst Ubooquity was scanning the library at the same time :/ by removing the old database, it has scanned the 3000 comics, but this time they show up in the total and thru the web interface - Thanks again Tom, you're a god among men I swear!

Answered

You're welcome. :)