the character collection count thing is still a problem to, and I have
terminated and restarted, etc, and while I was in the db verified I only have
10 comics ini the table, didnt see anything duplicated in there, but the count
now says she appears in 21 issues, lol
________________________________
From: comixed-bounce@xxxxxxxxxxxxx <comixed-bounce@xxxxxxxxxxxxx> on behalf of
Darryl L. Pierce <mcpierce@xxxxxxxxx>
Sent: Monday, November 15, 2021 8:41 PM
To: comixed@xxxxxxxxxxxxx <comixed@xxxxxxxxxxxxx>
Subject: [comixed] Re: Help with stuck imported books that failed
My only ou oh moment right now is wondering if the length annotation on the
notes field will be an issue or not. I’m not sure if That gets evaluated at
runtime or if only comes into play when automatically generating a DDL (which
we don’t do).
On Mon, Nov 15, 2021 at 8:38 PM Doug Crowe
<doug_crowe@xxxxxxxxxxx<mailto:doug_crowe@xxxxxxxxxxx>> wrote:
got the column changed, does this list allow pics?
________________________________
From: comixed-bounce@xxxxxxxxxxxxx<mailto:comixed-bounce@xxxxxxxxxxxxx>
<comixed-bounce@xxxxxxxxxxxxx<mailto:comixed-bounce@xxxxxxxxxxxxx>> on behalf
of Doug Crowe <doug_crowe@xxxxxxxxxxx<mailto:doug_crowe@xxxxxxxxxxx>>
Sent: Monday, November 15, 2021 8:36 PM
To: comixed@xxxxxxxxxxxxx<mailto:comixed@xxxxxxxxxxxxx>
<comixed@xxxxxxxxxxxxx<mailto:comixed@xxxxxxxxxxxxx>>
Subject: [comixed] Re: Help with stuck imported books that failed
happy to help! always on the lookout for good new tools
________________________________
From: comixed-bounce@xxxxxxxxxxxxx<mailto:comixed-bounce@xxxxxxxxxxxxx>
<comixed-bounce@xxxxxxxxxxxxx<mailto:comixed-bounce@xxxxxxxxxxxxx>> on behalf
of Darryl L. Pierce <mcpierce@xxxxxxxxx<mailto:mcpierce@xxxxxxxxx>>
Sent: Monday, November 15, 2021 8:33 PM
To: comixed@xxxxxxxxxxxxx<mailto:comixed@xxxxxxxxxxxxx>
<comixed@xxxxxxxxxxxxx<mailto:comixed@xxxxxxxxxxxxx>>
Subject: [comixed] Re: Help with stuck imported books that failed
Awesome! I really appreciate your feedback on the project. I want this to be a
useful tool for people.
On Mon, Nov 15, 2021 at 8:32 PM Doug Crowe
<doug_crowe@xxxxxxxxxxx<mailto:doug_crowe@xxxxxxxxxxx>> wrote:
awesome, Thanks! now I wont have to wait after all then to at least get used to
it and learn some about using it
________________________________
From: comixed-bounce@xxxxxxxxxxxxx<mailto:comixed-bounce@xxxxxxxxxxxxx>
<comixed-bounce@xxxxxxxxxxxxx<mailto:comixed-bounce@xxxxxxxxxxxxx>> on behalf
of Darryl L. Pierce <mcpierce@xxxxxxxxx<mailto:mcpierce@xxxxxxxxx>>
Sent: Monday, November 15, 2021 8:31 PM
To: comixed@xxxxxxxxxxxxx<mailto:comixed@xxxxxxxxxxxxx>
<comixed@xxxxxxxxxxxxx<mailto:comixed@xxxxxxxxxxxxx>>
Subject: [comixed] Re: Help with stuck imported books that failed
Thé Comics table, Notes column.
On Mon, Nov 15, 2021 at 8:29 PM Doug Crowe
<doug_crowe@xxxxxxxxxxx<mailto:doug_crowe@xxxxxxxxxxx>> wrote:
cool, that did it, now which table/field do I upgrade?
________________________________
From: comixed-bounce@xxxxxxxxxxxxx<mailto:comixed-bounce@xxxxxxxxxxxxx>
<comixed-bounce@xxxxxxxxxxxxx<mailto:comixed-bounce@xxxxxxxxxxxxx>> on behalf
of Darryl L. Pierce <mcpierce@xxxxxxxxx<mailto:mcpierce@xxxxxxxxx>>
Sent: Monday, November 15, 2021 8:28 PM
To: comixed@xxxxxxxxxxxxx<mailto:comixed@xxxxxxxxxxxxx>
<comixed@xxxxxxxxxxxxx<mailto:comixed@xxxxxxxxxxxxx>>
Subject: [comixed] Re: Help with stuck imported books that failed
The default username is « sa » with no password for H2 embedded.
On Mon, Nov 15, 2021 at 8:26 PM Doug Crowe
<doug_crowe@xxxxxxxxxxx<mailto:doug_crowe@xxxxxxxxxxx>> wrote:
I need a username/pw to connect to it
________________________________
From: comixed-bounce@xxxxxxxxxxxxx<mailto:comixed-bounce@xxxxxxxxxxxxx>
<comixed-bounce@xxxxxxxxxxxxx<mailto:comixed-bounce@xxxxxxxxxxxxx>> on behalf
of Darryl L. Pierce <mcpierce@xxxxxxxxx<mailto:mcpierce@xxxxxxxxx>>
Sent: Monday, November 15, 2021 8:04 PM
To: comixed@xxxxxxxxxxxxx<mailto:comixed@xxxxxxxxxxxxx>
<comixed@xxxxxxxxxxxxx<mailto:comixed@xxxxxxxxxxxxx>>
Subject: [comixed] Re: Help with stuck imported books that failed
No, metadata process is a part of the import process. Our old import tool let
you import without metadata but that was removed a while ago. If you’re
comfortable with sql you could (for now) expand the column to make it a CLOB,
which is what the 0.11 release does.
On Mon, Nov 15, 2021 at 7:16 PM Doug Crowe
<doug_crowe@xxxxxxxxxxx<mailto:doug_crowe@xxxxxxxxxxx>> wrote:
so you said this is basically a sql field too small to use something in my
metadata, is there a way in the app to tell it to not use that?
like could I turn off using the comicinfo.xml and then it wouldnt run into that?
just brainstorming...
________________________________
From: comixed-bounce@xxxxxxxxxxxxx<mailto:comixed-bounce@xxxxxxxxxxxxx>
<comixed-bounce@xxxxxxxxxxxxx<mailto:comixed-bounce@xxxxxxxxxxxxx>> on behalf
of Doug Crowe <doug_crowe@xxxxxxxxxxx<mailto:doug_crowe@xxxxxxxxxxx>>
Sent: Monday, November 15, 2021 3:47 PM
To: comixed@xxxxxxxxxxxxx<mailto:comixed@xxxxxxxxxxxxx>
<comixed@xxxxxxxxxxxxx<mailto:comixed@xxxxxxxxxxxxx>>
Subject: [comixed] Re: Help with stuck imported books that failed
Here is an excerpt from the terminal window showing the error resulting in
these spinning circle of death issues that are stuck.....
2021-11-15 15:44:09.049 ERROR 52453 --- [ CX-Jarvis12]
o.s.batch.core.step.AbstractStep : Encountered an error executing step
loadFileContentsStep in job processComicsJob
org.springframework.dao.DataIntegrityViolationException: could not execute
statement; SQL [n/a]; nested exception is
org.hibernate.exception.DataException: could not execute statement
at
org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:302)
~[spring-orm-5.2.7.RELEASE.jar!/:5.2.7.RELEASE]
at
org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:255)
~[spring-orm-5.2.7.RELEASE.jar!/:5.2.7.RELEASE]
at
org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:538)
~[spring-orm-5.2.7.RELEASE.jar!/:5.2.7.RELEASE]
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:743)
~[spring-tx-5.2.7.RELEASE.jar!/:5.2.7.RELEASE]
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:711)
~[spring-tx-5.2.7.RELEASE.jar!/:5.2.7.RELEASE]
at jdk.internal.reflect.GeneratedMethodAccessor483.invoke(Unknown Source)
~[na:na]
at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:na]
at java.base/java.lang.reflect.Method.invoke(Method.java:568) ~[na:na]
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
~[spring-aop-5.2.7.RELEASE.jar!/:5.2.7.RELEASE]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
~[spring-aop-5.2.7.RELEASE.jar!/:5.2.7.RELEASE]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
~[spring-aop-5.2.7.RELEASE.jar!/:5.2.7.RELEASE]
at
org.springframework.batch.core.configuration.annotation.SimpleBatchConfiguration$PassthruAdvice.invoke(SimpleBatchConfiguration.java:127)
~[spring-batch-core-4.2.4.RELEASE.jar!/:4.2.4.RELEASE]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
~[spring-aop-5.2.7.RELEASE.jar!/:5.2.7.RELEASE]
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
~[spring-aop-5.2.7.RELEASE.jar!/:5.2.7.RELEASE]
at jdk.proxy2/jdk.proxy2.$Proxy162.commit(Unknown Source) ~[na:na]
at
org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:152)
~[spring-tx-5.2.7.RELEASE.jar!/:5.2.7.RELEASE]
at
org.springframework.batch.core.step.tasklet.TaskletStep$2.doInChunkContext(TaskletStep.java:273)
~[spring-batch-core-4.2.4.RELEASE.jar!/:4.2.4.RELEASE]
at
org.springframework.batch.core.scope.context.StepContextRepeatCallback.doInIteration(StepContextRepeatCallback.java:82)
~[spring-batch-core-4.2.4.RELEASE.jar!/:4.2.4.RELEASE]
at
org.springframework.batch.repeat.support.RepeatTemplate.getNextResult(RepeatTemplate.java:375)
~[spring-batch-infrastructure-4.2.4.RELEASE.jar!/:4.2.4.RELEASE]
at
org.springframework.batch.repeat.support.RepeatTemplate.executeInternal(RepeatTemplate.java:215)
~[spring-batch-infrastructure-4.2.4.RELEASE.jar!/:4.2.4.RELEASE]
at
org.springframework.batch.repeat.support.RepeatTemplate.iterate(RepeatTemplate.java:145)
~[spring-batch-infrastructure-4.2.4.RELEASE.jar!/:4.2.4.RELEASE]
at
org.springframework.batch.core.step.tasklet.TaskletStep.doExecute(TaskletStep.java:258)
~[spring-batch-core-4.2.4.RELEASE.jar!/:4.2.4.RELEASE]
at
org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:208)
~[spring-batch-core-4.2.4.RELEASE.jar!/:4.2.4.RELEASE]
at
org.springframework.batch.core.job.SimpleStepHandler.handleStep(SimpleStepHandler.java:148)
~[spring-batch-core-4.2.4.RELEASE.jar!/:4.2.4.RELEASE]
at
org.springframework.batch.core.job.AbstractJob.handleStep(AbstractJob.java:410)
~[spring-batch-core-4.2.4.RELEASE.jar!/:4.2.4.RELEASE]
at org.springframework.batch.core.job.SimpleJob.doExecute(SimpleJob.java:136)
~[spring-batch-core-4.2.4.RELEASE.jar!/:4.2.4.RELEASE]
at org.springframework.batch.core.job.AbstractJob.execute(AbstractJob.java:319)
~[spring-batch-core-4.2.4.RELEASE.jar!/:4.2.4.RELEASE]
at
org.springframework.batch.core.launch.support.SimpleJobLauncher$1.run(SimpleJobLauncher.java:147)
~[spring-batch-core-4.2.4.RELEASE.jar!/:4.2.4.RELEASE]
at java.base/java.lang.Thread.run(Thread.java:833) ~[na:na]
Caused by: org.hibernate.exception.DataException: could not execute statement
at
org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:52)
~[hibernate-core-5.4.17.Final.jar!/:5.4.17.Final]
at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
~[hibernate-core-5.4.17.Final.jar!/:5.4.17.Final]
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
~[hibernate-core-5.4.17.Final.jar!/:5.4.17.Final]
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
~[hibernate-core-5.4.17.Final.jar!/:5.4.17.Final]
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:200)
~[hibernate-core-5.4.17.Final.jar!/:5.4.17.Final]
at
org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3449)
~[hibernate-core-5.4.17.Final.jar!/:5.4.17.Final]
at
org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:3311)
~[hibernate-core-5.4.17.Final.jar!/:5.4.17.Final]
at
org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3723)
~[hibernate-core-5.4.17.Final.jar!/:5.4.17.Final]
at
org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:201)
~[hibernate-core-5.4.17.Final.jar!/:5.4.17.Final]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)
~[hibernate-core-5.4.17.Final.jar!/:5.4.17.Final]
at
org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478)
~[hibernate-core-5.4.17.Final.jar!/:5.4.17.Final]
at java.base/java.util.LinkedHashMap.forEach(LinkedHashMap.java:721) ~[na:na]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475)
~[hibernate-core-5.4.17.Final.jar!/:5.4.17.Final]
at
org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:348)
~[hibernate-core-5.4.17.Final.jar!/:5.4.17.Final]
at
org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:40)
~[hibernate-core-5.4.17.Final.jar!/:5.4.17.Final]
at
org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:102)
~[hibernate-core-5.4.17.Final.jar!/:5.4.17.Final]
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1360)
~[hibernate-core-5.4.17.Final.jar!/:5.4.17.Final]
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:451)
~[hibernate-core-5.4.17.Final.jar!/:5.4.17.Final]
at
org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3210)
~[hibernate-core-5.4.17.Final.jar!/:5.4.17.Final]
at
org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2378)
~[hibernate-core-5.4.17.Final.jar!/:5.4.17.Final]
at
org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:447)
~[hibernate-core-5.4.17.Final.jar!/:5.4.17.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:183)
~[hibernate-core-5.4.17.Final.jar!/:5.4.17.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40)
~[hibernate-core-5.4.17.Final.jar!/:5.4.17.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:281)
~[hibernate-core-5.4.17.Final.jar!/:5.4.17.Final]
at
org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101)
~[hibernate-core-5.4.17.Final.jar!/:5.4.17.Final]
at
org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:534)
~[spring-orm-5.2.7.RELEASE.jar!/:5.2.7.RELEASE]
... 26 common frames omitted
Caused by: org.h2.jdbc.JdbcSQLDataException: Value too long for column "NOTES
VARCHAR(128)": "'Tagged with the ninjas.walk.alone fork of ComicTagger 1.3.4
using info from Comic Vine on 2021-08-01 12:29:45. [Issue ID 87454... (129)";
SQL statement:
update Comics set ArchiveType=?, BlockedPagesMarked=?, ComicState=?,
ComicVineId=?, Consolidating=?, CoverDate=?, DeletedOn=?, Description=?,
FileContentsLoaded=?, Filename=?, Imprint=?, IssueNumber=?, LastModifiedOn=?,
Notes=?, Publisher=?, Recreating=?, Series=?, SortName=?, StoreDate=?, Title=?,
UpdateMetadata=?, Volume=? where id=? [22001-200]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:457)
~[h2-1.4.200.jar!/:na]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)
~[h2-1.4.200.jar!/:na]
at org.h2.message.DbException.get(DbException.java:205) ~[h2-1.4.200.jar!/:na]
at org.h2.value.TypeInfo.getValueTooLongException(TypeInfo.java:535)
~[h2-1.4.200.jar!/:na]
at org.h2.value.TypeInfo.cast(TypeInfo.java:520) ~[h2-1.4.200.jar!/:na]
at org.h2.table.Column.validateConvertUpdateSequence(Column.java:378)
~[h2-1.4.200.jar!/:na]
at org.h2.table.Table.validateConvertUpdateSequence(Table.java:845)
~[h2-1.4.200.jar!/:na]
at org.h2.command.dml.Update.update(Update.java:176) ~[h2-1.4.200.jar!/:na]
at org.h2.command.CommandContainer.update(CommandContainer.java:198)
~[h2-1.4.200.jar!/:na]
at org.h2.command.Command.executeUpdate(Command.java:251) ~[h2-1.4.200.jar!/:na]
at
org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:191)
~[h2-1.4.200.jar!/:na]
at
org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:152)
~[h2-1.4.200.jar!/:na]
at
com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
~[HikariCP-3.4.5.jar!/:na]
at
com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
~[HikariCP-3.4.5.jar!/:na]
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:197)
~[hibernate-core-5.4.17.Final.jar!/:5.4.17.Final]
... 47 common frames omitted
2021-11-15 15:44:09.050 INFO 52453 --- [ CX-Jarvis12]
o.s.batch.core.step.AbstractStep : Step: [loadFileContentsStep]
executed in 2m13s183ms
2021-11-15 15:44:09.052 INFO 52453 --- [ CX-Jarvis12]
o.s.b.c.l.support.SimpleJobLauncher : Job: [SimpleJob:
[name=processComicsJob]] completed with the following parameters:
[{job.add-comics.started=1637008915082}] and the following status: [FAILED] in
2m13s186ms
________________________________
From: comixed-bounce@xxxxxxxxxxxxx<mailto:comixed-bounce@xxxxxxxxxxxxx>
<comixed-bounce@xxxxxxxxxxxxx<mailto:comixed-bounce@xxxxxxxxxxxxx>> on behalf
of Doug Crowe <doug_crowe@xxxxxxxxxxx<mailto:doug_crowe@xxxxxxxxxxx>>
Sent: Monday, November 15, 2021 3:40 PM
To: comixed@xxxxxxxxxxxxx<mailto:comixed@xxxxxxxxxxxxx>
<comixed@xxxxxxxxxxxxx<mailto:comixed@xxxxxxxxxxxxx>>
Subject: [comixed] Help with stuck imported books that failed
Hello,
Just getting started with trying Comixed and have many questions
I finally got it running with JDK11 on my macbook, and my comic library is
stored on a UNRAID NAS. I am having trouble getting books imported, sometimes
it works and sometimes I end up with a book with a spinning circle of death,
and a FAILED in the terminal window.
I have tried marking them as deleted, thinking maybe I tried to add too many at
once (50), and then consolidate library, but they wont go away. So how do I get
these spinning circle of death books to either finish, or go away?
Any help is appreciated.
Thanks,
Doug
--
Sent from Gmail Mobile
--
Sent from Gmail Mobile
--
Sent from Gmail Mobile
--
Sent from Gmail Mobile
--
Sent from Gmail Mobile
