What happened?
On Mon, Nov 15, 2021 at 8:45 PM Doug Crowe <doug_crowe@xxxxxxxxxxx> wrote:
damn, now I see what you mean about your thought....I cant "sh run.sh"--
anymore, it died on startup
CRYINGGGGG
------------------------------
*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> wrote:
got the column changed, does this list allow pics?
------------------------------
*From:* comixed-bounce@xxxxxxxxxxxxx <comixed-bounce@xxxxxxxxxxxxx> on
behalf of Doug Crowe <doug_crowe@xxxxxxxxxxx>
*Sent:* Monday, November 15, 2021 8:36 PM
*To:* comixed@xxxxxxxxxxxxx <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 <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> 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 <comixed-bounce@xxxxxxxxxxxxx> on
behalf of Darryl L. Pierce <mcpierce@xxxxxxxxx>
*Sent:* Monday, November 15, 2021 8:31 PM
*To:* comixed@xxxxxxxxxxxxx <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> wrote:
cool, that did it, now which table/field do I upgrade?
------------------------------
*From:* comixed-bounce@xxxxxxxxxxxxx <comixed-bounce@xxxxxxxxxxxxx> on
behalf of Darryl L. Pierce <mcpierce@xxxxxxxxx>
*Sent:* Monday, November 15, 2021 8:28 PM
*To:* comixed@xxxxxxxxxxxxx <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> wrote:
I need a username/pw to connect to it
------------------------------
*From:* comixed-bounce@xxxxxxxxxxxxx <comixed-bounce@xxxxxxxxxxxxx> on
behalf of Darryl L. Pierce <mcpierce@xxxxxxxxx>
*Sent:* Monday, November 15, 2021 8:04 PM
*To:* comixed@xxxxxxxxxxxxx <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> 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 <comixed-bounce@xxxxxxxxxxxxx> on
behalf of Doug Crowe <doug_crowe@xxxxxxxxxxx>
*Sent:* Monday, November 15, 2021 3:47 PM
*To:* comixed@xxxxxxxxxxxxx <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 <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
--
Sent from Gmail Mobile
--
Sent from Gmail Mobile
--
Sent from Gmail Mobile
--
Sent from Gmail Mobile
--
Sent from Gmail Mobile
