awesome, you rock man, I appreciate the personal help!
Hopefully I will be able to help you in turn 🙂
________________________________
From: comixed-bounce@xxxxxxxxxxxxx <comixed-bounce@xxxxxxxxxxxxx> on behalf of
Darryl L. Pierce <mcpierce@xxxxxxxxx>
Sent: Monday, November 15, 2021 9:03 PM
To: comixed@xxxxxxxxxxxxx <comixed@xxxxxxxxxxxxx>
Subject: [comixed] Re: Help with stuck imported books that failed
Hehe, yeah I kinda noticed. :D
I'm emailing the prerelease build to you shortly.
On Mon, Nov 15, 2021 at 8:56 PM Doug Crowe <doug_crowe@xxxxxxxxxxx> wrote:
that would be fantastic, and I agree 100% to keep it to myself for testing
only
If you havent been able to notice I am also a programmer, so I get it...
________________________________
From: comixed-bounce@xxxxxxxxxxxxx <comixed-bounce@xxxxxxxxxxxxx> on behalf
of Darryl L. Pierce <mcpierce@xxxxxxxxx>
Sent: Monday, November 15, 2021 8:53 PM
To: comixed@xxxxxxxxxxxxx <comixed@xxxxxxxxxxxxx>
Subject: [comixed] Re: Help with stuck imported books that failed
Ugh, yeah, so the annotation still comes into play when the data is
being written. Damn, I was hoping it wouldn't but wasn't sure.
I could run a build for you of what's latest on master to use for
evaluation and testing on your end. It'll have everything developed to
date but I'd only ask that you not open bugs against any new features
in it.
On Mon, Nov 15, 2021 at 3:47 PM Doug Crowe <doug_crowe@xxxxxxxxxxx> wrote:
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 <comixed-bounce@xxxxxxxxxxxxx> on behalf
of Doug Crowe <doug_crowe@xxxxxxxxxxx>
Sent: Monday, November 15, 2021 3:40 PM
To: comixed@xxxxxxxxxxxxx <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
--
Darryl L. Pierce <mcpierce@xxxxxxxxx>
"Le centre du monde est partout." - Blaise Pascal
"Let's try and find some point of transcendence and leap together." -
Gord Downie