0
Fixed

Error Performing Query on Launch

joefrizzell 6 months ago updated 6 months ago 2

Hi I'm getting this error when I launch my server:

Last login: Sat Aug  8 18:31:01 on ttys007
joe@Darth-Pro ~ % cd ~/Desktop/Ubooquity; java -Xmx4096m -jar Ubooquity.jar
20200808 18:32:02 [main] INFO  com.ubooquity.Ubooquity - Running with the following parameters - headless: false, libraryport: -1, adminport: -1, remoteadmin: false, host: null, debug: false, execdir: /Users/joe/Desktop/Ubooquity
20200808 18:32:02 [main] INFO  com.ubooquity.Ubooquity - #############################
20200808 18:32:02 [main] INFO  com.ubooquity.Ubooquity - #     Starting Ubooquity    #
20200808 18:32:02 [main] INFO  com.ubooquity.Ubooquity - #############################
20200808 18:32:02 [main] INFO  com.ubooquity.Ubooquity - Java version: 1.8.0_65
20200808 18:32:02 [main] INFO  com.ubooquity.Ubooquity - Java vendor: Oracle Corporation
20200808 18:32:02 [main] INFO  com.ubooquity.Ubooquity - java vm name: Java HotSpot(TM) 64-Bit Server VM
20200808 18:32:02 [main] INFO  com.ubooquity.Ubooquity - java runtime name: Java(TM) SE Runtime Environment
20200808 18:32:02 [main] INFO  com.ubooquity.Ubooquity - Max heap size available: 3641 MB
20200808 18:32:02 [main] INFO  com.ubooquity.Ubooquity - OS name: Mac OS X
20200808 18:32:02 [main] INFO  com.ubooquity.Ubooquity - OS version: 10.15.6
20200808 18:32:02 [main] INFO  com.ubooquity.Ubooquity - OS architecture: x86_64
20200808 18:32:02 [main] INFO  com.ubooquity.Ubooquity - Loading local version info
20200808 18:32:02 [main] INFO  com.ubooquity.Ubooquity - Ubooquity 2.1.2 built on 2018-10-14 at 12:58
20200808 18:32:02 [main] INFO  com.ubooquity.Ubooquity - Creating application folders
20200808 18:32:02 [main] INFO  com.ubooquity.Ubooquity - Loading preferences
zsh: suspended (signal)  java -Xmx4096m -jar Ubooquity.jar
joe@Darth-Pro Ubooquity % 20200808 18:32:05 [main] INFO  org.eclipse.jetty.util.log - Logging initialized @3743ms to org.eclipse.jetty.util.log.Slf4jLog
20200808 18:32:05 [main] INFO  com.ubooquity.b - Starting internal server...
20200808 18:32:05 [main] INFO  com.ubooquity.b - Reverse proxy prefix is not activated
20200808 18:32:05 [Scanner thread] INFO  com.ubooquity.data.feeder.a - Scanning books directories
20200808 18:32:05 [main] INFO  org.eclipse.jetty.server.Server - jetty-9.4.0.v20161208
20200808 18:32:05 [main] INFO  o.e.j.server.handler.ContextHandler - Started o.e.j.s.h.ContextHandler@548a24a{/,null,AVAILABLE,@admin}
20200808 18:32:05 [main] INFO  o.e.j.server.handler.ContextHandler - Started o.e.j.s.h.ContextHandler@433defed{/,null,AVAILABLE,@library}
20200808 18:32:08 [main] INFO  o.e.jetty.server.AbstractConnector - Started library@239a307b{HTTP/1.1,[http/1.1]}{0.0.0.0:2202}
20200808 18:32:08 [main] INFO  o.e.jetty.server.AbstractConnector - Started admin@2a8448fa{HTTP/1.1,[http/1.1]}{0.0.0.0:2203}
20200808 18:32:08 [main] INFO  org.eclipse.jetty.server.Server - Started @6305ms
20200808 18:32:08 [main] INFO  com.ubooquity.b - Internal server started. Listening on port 2202 (library) and 2203 (admin)
20200808 18:32:09 [Timer-0] INFO  com.ubooquity.Ubooquity - Checking latest available Ubooquity version from website
20200808 18:32:10 [Timer-0] INFO  com.ubooquity.Ubooquity - Latest version available: 2.1.2Error performing query '<strong>': INSERT command denied to user 'gregre001'@'10.22.20.8' for table 'ubqt_startup'

 - Current version: 2.1.2

Exception: java.lang.IllegalStateException thrown from the UncaughtExceptionHandler in thread "Timer-0"
2020-08-08 18:32:40.429 java[8186:58296] unrecognized type is 4294967295
2020-08-08 18:32:40.429 java[8186:58296] *** Assertion failure in -[NSEvent _initWithCGEvent:eventRef:], /AppleInternal/BuildRoot/Library/Caches/com.apple.xbs/Sources/AppKit/AppKit-1894.60.100/AppKit.subproj/NSEvent.m:1960
2020-08-08 18:33:05.468 java[8186:58296] unrecognized type is 4294967295
2020-08-08 18:33:05.468 java[8186:58296] *** Assertion failure in -[NSEvent _initWithCGEvent:eventRef:], /AppleInternal/BuildRoot/Library/Caches/com.apple.xbs/Sources/AppKit/AppKit-1894.60.100/AppKit.subproj/NSEvent.m:1960
2020-08-08 18:33:10.553 java[8186:58296] unrecognized type is 4294967295
2020-08-08 18:33:10.553 java[8186:58296] *** Assertion failure in -[NSEvent _initWithCGEvent:eventRef:], /AppleInternal/BuildRoot/Library/Caches/com.apple.xbs/Sources/AppKit/AppKit-1894.60.100/AppKit.subproj/NSEvent.m:1960</strong>

It seems like its failing on trying to check for a new version. I realize this software isn't really being supported anymore since there hasn't been an updated version since 2018, just wanted to see if there was a work around for this, maybe editing the local code on my machine to skip the version check or something.

Thanks.

+1
Fixed

This is me forgetting to clean up the Ubooquity statistics database and being on holidays far from my computer when it becomes full.

In detail, Ubooquity regularly checks if a new version is available by calling my server. I count these calls and store the result in a database, so that I can have an approximate count of how many people use Ubooquity.

What you see is the server telling Ubooquity that it failed to use the database.

I made room in the table, you shouldn't see this error anymore.

My aplogies for the issue.

Thanks for the update. I just restarted my server and can confirm that I am no longer receiving this error.