Code Monkey home page Code Monkey logo

Comments (14)

theotherp avatar theotherp commented on May 23, 2024

Please try https://github.com/theotherp/nzbhydra2/releases/tag/v1.0.5 I think I fixed that.

from nzbhydra2.

pequalsmp avatar pequalsmp commented on May 23, 2024

It seems something is broken in 1.0.5 as it started crashing with:

Invalid maximum heap size: -Xmx128

Deleteing nzbhydra.yaml allows it to start the first time, but the next time it starts - it fails again with the same error.

from nzbhydra2.

theotherp avatar theotherp commented on May 23, 2024

What does it say in the console when you start it?

from nzbhydra2.

theotherp avatar theotherp commented on May 23, 2024

Can reproduce. Wait.

from nzbhydra2.

pequalsmp avatar pequalsmp commented on May 23, 2024

I think its an issue with the commandline generation as this is in my logs:

java -Xmx128 M -DfromWrapper -XX:TieredStopAtLevel=1 -noverify -Dspring.output.ansi.enabled=ALWAYS -jar /<path>/lib/core-1.0.5-exec.jar --nobrowser --datafolder /<data> in folder /<path>

I think with the removal of pyYAML doesn't trim the newline at the end of Xmx: 128 in nzbhydra.yml

from nzbhydra2.

theotherp avatar theotherp commented on May 23, 2024

Got it.

from nzbhydra2.

pequalsmp avatar pequalsmp commented on May 23, 2024

1.0.6 does not throw errors, but nothing Search and Download history tabs are empty. Some of indexers responded with 429: Too many requests (to be expected) and this may be cause of error.

from nzbhydra2.

theotherp avatar theotherp commented on May 23, 2024

Post your debug infos.

from nzbhydra2.

pequalsmp avatar pequalsmp commented on May 23, 2024

This is one of the big ones (i think the whole batch failed due to schema incompatibility):

 WARN --- [0.1-5076-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper   : [IP: XXX.XXX.XXX.XXX] SQL Error: 22001, SQLState: 22001
ERROR --- [0.1-5076-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper   : [IP: XXX.XXX.XXX.XXX] Value too long for column "ERROR VARCHAR(255)": "'HTTPConnectionPool(host=''xxx.xx'', port=80): Max retries exceeded with url: /getnzb/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.n... (359)"; SQL statement:
insert into indexernzbdownload (access_source, age, error, external_id, ip, nzb_access_type, search_result_id, status, time, user_agent, username, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [22001-195]
 WARN --- [0.1-5076-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper   : [IP: XXX.XXX.XXX.XXX] SQL Error: 22001, SQLState: 22001
ERROR --- [0.1-5076-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper   : [IP: XXX.XXX.XXX.XXX] Value too long for column "ERROR VARCHAR(255)": "'HTTPConnectionPool(host=''xxx.xx'', port=80): Max retries exceeded with url: /getnzb/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.n... (359)"; SQL statement:
insert into indexernzbdownload (access_source, age, error, external_id, ip, nzb_access_type, search_result_id, status, time, user_agent, username, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [22001-195]
 WARN --- [0.1-5076-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper   : [IP: XXX.XXX.XXX.XXX] SQL Error: 22001, SQLState: 22001
ERROR --- [0.1-5076-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper   : [IP: XXX.XXX.XXX.XXX] Value too long for column "ERROR VARCHAR(255)": "'HTTPConnectionPool(host=''xxx.xx'', port=80): Max retries exceeded with url: /getnzb/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.n... (359)"; SQL statement:
insert into indexernzbdownload (access_source, age, error, external_id, ip, nzb_access_type, search_result_id, status, time, user_agent, username, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [22001-195]
 WARN --- [0.1-5076-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper   : [IP: XXX.XXX.XXX.XXX] SQL Error: 22001, SQLState: 22001
ERROR --- [0.1-5076-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper   : [IP: XXX.XXX.XXX.XXX] Value too long for column "ERROR VARCHAR(255)": "'HTTPConnectionPool(host=''xxx.xx'', port=80): Max retries exceeded with url: /getnzb/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.n... (359)"; SQL statement:
insert into indexernzbdownload (access_source, age, error, external_id, ip, nzb_access_type, search_result_id, status, time, user_agent, username, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [22001-195]
 WARN --- [0.1-5076-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper   : [IP: XXX.XXX.XXX.XXX] SQL Error: 22001, SQLState: 22001
ERROR --- [0.1-5076-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper   : [IP: XXX.XXX.XXX.XXX] Value too long for column "ERROR VARCHAR(255)": "'HTTPConnectionPool(host=''xxx.xx'', port=80): Max retries exceeded with url: /getnzb/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.n... (359)"; SQL statement:
insert into indexernzbdownload (access_source, age, error, external_id, ip, nzb_access_type, search_result_id, status, time, user_agent, username, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [22001-195]
 WARN --- [0.1-5076-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper   : [IP: XXX.XXX.XXX.XXX] SQL Error: 22001, SQLState: 22001
ERROR --- [0.1-5076-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper   : [IP: XXX.XXX.XXX.XXX] Value too long for column "ERROR VARCHAR(255)": "'HTTPConnectionPool(host=''xxx.xx'', port=80): Max retries exceeded with url: /getnzb/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.n... (359)"; SQL statement:
insert into indexernzbdownload (access_source, age, error, external_id, ip, nzb_access_type, search_result_id, status, time, user_agent, username, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [22001-195]
 WARN --- [0.1-5076-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper   : [IP: XXX.XXX.XXX.XXX] SQL Error: 22001, SQLState: 22001
ERROR --- [0.1-5076-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper   : [IP: XXX.XXX.XXX.XXX] Value too long for column "ERROR VARCHAR(255)": "'HTTPConnectionPool(host=''xxx.xx'', port=80): Max retries exceeded with url: /getnzb/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.n... (359)"; SQL statement:
insert into indexernzbdownload (access_source, age, error, external_id, ip, nzb_access_type, search_result_id, status, time, user_agent, username, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [22001-195]
 WARN --- [0.1-5076-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper   : [IP: XXX.XXX.XXX.XXX] SQL Error: 22001, SQLState: 22001
ERROR --- [0.1-5076-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper   : [IP: XXX.XXX.XXX.XXX] Value too long for column "ERROR VARCHAR(255)": "'HTTPConnectionPool(host=''xxx.xx'', port=80): Max retries exceeded with url: /getnzb/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.n... (359)"; SQL statement:
insert into indexernzbdownload (access_source, age, error, external_id, ip, nzb_access_type, search_result_id, status, time, user_agent, username, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [22001-195]
 WARN --- [0.1-5076-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper   : [IP: XXX.XXX.XXX.XXX] SQL Error: 22001, SQLState: 22001
ERROR --- [0.1-5076-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper   : [IP: XXX.XXX.XXX.XXX] Value too long for column "ERROR VARCHAR(255)": "'HTTPConnectionPool(host=''xxx.xx'', port=80): Max retries exceeded with url: /getnzb/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.n... (359)"; SQL statement:
insert into indexernzbdownload (access_source, age, error, external_id, ip, nzb_access_type, search_result_id, status, time, user_agent, username, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [22001-195]
 WARN --- [0.1-5076-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper   : [IP: XXX.XXX.XXX.XXX] SQL Error: 22001, SQLState: 22001
ERROR --- [0.1-5076-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper   : [IP: XXX.XXX.XXX.XXX] Value too long for column "ERROR VARCHAR(255)": "'HTTPConnectionPool(host=''xxx.xx'', port=80): Max retries exceeded with url: /getnzb/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.n... (359)"; SQL statement:
insert into indexernzbdownload (access_source, age, error, external_id, ip, nzb_access_type, search_result_id, status, time, user_agent, username, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [22001-195]
 WARN --- [0.1-5076-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper   : [IP: XXX.XXX.XXX.XXX] SQL Error: 22001, SQLState: 22001
ERROR --- [0.1-5076-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper   : [IP: XXX.XXX.XXX.XXX] Value too long for column "ERROR VARCHAR(255)": "'HTTPConnectionPool(host=''xxx.xx'', port=80): Max retries exceeded with url: /getnzb/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.n... (359)"; SQL statement:
insert into indexernzbdownload (access_source, age, error, external_id, ip, nzb_access_type, search_result_id, status, time, user_agent, username, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [22001-195]
 WARN --- [0.1-5076-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper   : [IP: XXX.XXX.XXX.XXX] SQL Error: 22001, SQLState: 22001
ERROR --- [0.1-5076-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper   : [IP: XXX.XXX.XXX.XXX] Value too long for column "ERROR VARCHAR(255)": "'HTTPConnectionPool(host=''xxx.xx'', port=80): Max retries exceeded with url: /getnzb/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.n... (359)"; SQL statement:
insert into indexernzbdownload (access_source, age, error, external_id, ip, nzb_access_type, search_result_id, status, time, user_agent, username, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [22001-195]
 WARN --- [0.1-5076-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper   : [IP: XXX.XXX.XXX.XXX] SQL Error: 22001, SQLState: 22001
ERROR --- [0.1-5076-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper   : [IP: XXX.XXX.XXX.XXX] Value too long for column "ERROR VARCHAR(255)": "'HTTPConnectionPool(host=''xxx.xx'', port=80): Max retries exceeded with url: /getnzb/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.n... (359)"; SQL statement:
insert into indexernzbdownload (access_source, age, error, external_id, ip, nzb_access_type, search_result_id, status, time, user_agent, username, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [22001-195]
ERROR --- [0.1-5076-exec-5] o.h.e.jdbc.batch.internal.BatchingBatch  : [IP: XXX.XXX.XXX.XXX] HHH000315: Exception executing batch [could not execute batch]
ERROR --- [0.1-5076-exec-5] o.a.c.c.C.[.[.[/v2].[dispatcherServlet]  : [IP: XXX.XXX.XXX.XXX] Servlet.service() for servlet [dispatcherServlet] in context with path [/v2] threw exception [Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: could not execute batch; SQL [insert into indexernzbdownload (access_source, age, error, external_id, ip, nzb_access_type, search_result_id, status, time, user_agent, username, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.DataException: could not execute batch] with root cause

org.h2.jdbc.JdbcBatchUpdateException: Value too long for column "ERROR VARCHAR(255)": "'HTTPConnectionPool(host=''xxx.xx'', port=80): Max retries exceeded with url: /getnzb/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.x... (359)"; SQL statement:
insert into indexernzbdownload (access_source, age, error, external_id, ip, nzb_access_type, search_result_id, status, time, user_agent, username, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [22001-195]

and multiple (per-tracker):

ERROR --- [pool-3-thread-3] org.nzbhydra.indexers.NewznabChecker     : Error while communicating with indexer

java.util.concurrent.ExecutionException: org.nzbhydra.indexers.exceptions.IndexerUnreachableException: Error while communicating with indexer NZBFinder. Server returned: java.io.IOException: URL call to https://x.x/api?apikey=<APIKEY> returned 429:Too Many Requests
	at java.util.concurrent.FutureTask.report(FutureTask.java:122)
	at java.util.concurrent.FutureTask.get(FutureTask.java:206)
	at org.nzbhydra.indexers.NewznabChecker.checkCaps(NewznabChecker.java:126)
	at org.nzbhydra.migration.JsonConfigMigration.lambda$null$4(JsonConfigMigration.java:530)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: org.nzbhydra.indexers.exceptions.IndexerUnreachableException: Error while communicating with indexer NZBFinder. Server returned: java.io.IOException: URL call to https://x.x/api?apikey=<APIKEY> returned 429:Too Many Requests
	at org.nzbhydra.indexers.IndexerWebAccess.get(IndexerWebAccess.java:76)
	at org.nzbhydra.indexers.IndexerWebAccess.get(IndexerWebAccess.java:43)
	at org.nzbhydra.indexers.NewznabChecker.singleCheckCaps(NewznabChecker.java:250)
	at org.nzbhydra.indexers.NewznabChecker.lambda$checkCaps$0(NewznabChecker.java:113)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at org.nzbhydra.logging.MdcThreadPoolExecutor$1.run(MdcThreadPoolExecutor.java:93)
	... 3 common frames omitted
Caused by: java.io.IOException: URL call to https://x.x/api?apikey=<APIKEY> returned 429:Too Many Requests
	at org.nzbhydra.okhttp.WebAccess.callUrl(WebAccess.java:66)
	at org.nzbhydra.indexers.IndexerWebAccess.lambda$get$0(IndexerWebAccess.java:60)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	... 3 common frames omitted

from nzbhydra2.

theotherp avatar theotherp commented on May 23, 2024

Got the first one. Stupid mistake.

You didn't send the whole debug infos so I have no idea if the second one is caused by the first or an independent issue.

from nzbhydra2.

theotherp avatar theotherp commented on May 23, 2024

I increased the column width(s) in 1.0.8

from nzbhydra2.

pequalsmp avatar pequalsmp commented on May 23, 2024

While everything seems to be working, the migration dialog never finishes (even though it says Completed migration with x message) and Download History is not migrated (Search/Stats are). But it seems this is past the scope of this issue.

from nzbhydra2.

theotherp avatar theotherp commented on May 23, 2024

Ok, thanks for the feedback. Considering that migration is something you typically only do once that's a minor issue for me right now.

I'll keep this open for other issues with the migration.

from nzbhydra2.

theotherp avatar theotherp commented on May 23, 2024

Should work now.

from nzbhydra2.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.