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