happy to help! always on the lookout for good new tools
________________________________
From: comixed-bounce@xxxxxxxxxxxxx <comixed-bounce@xxxxxxxxxxxxx> on behalf of
Darryl L. Pierce <mcpierce@xxxxxxxxx>
Sent: Monday, November 15, 2021 8:33 PM
To: comixed@xxxxxxxxxxxxx <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
