Yeah, that's the issue I've noticed as well. Did you at some point run the
move comics feature? I've found a bug where the filename wasn't being set
right in develop. I'm working on fixing that now.
On Sun, Jul 5, 2020 at 3:27 PM bareheiny <dmarc-noreply@xxxxxxxxxxxxx>
wrote:
I noticed I had two entries in the comic table for the comic in question
when I was deleting the records.
the name of one ended with “-1.cbz”...there was no so such file in my
comics directory...
On 6/07/2020, at 00:31, Darryl L. Pierce <mcpierce@xxxxxxxxx> wrote:
The underlying issue appears to be a bug in the query to get library
updates relating to having two comics with the same series, volume and
issue number in the database.
2020-07-05 07:41:08.422 ERROR 39615 --- [nio-7171-exec-9]
o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet
[dispatcherServlet] in context with path [] threw exception [Request
processing failed; nested exception is
org.springframework.dao.DataIntegrityViolationException: could not extract
ResultSet; SQL [n/a]; nested exception is
org.hibernate.exception.DataException: could not extract ResultSet] with
root cause
java.sql.SQLException: Subquery returns more than 1 row
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
~[mysql-connector-java-8.0.20.jar:8.0.20]
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
~[mysql-connector-java-8.0.20.jar:8.0.20]
at
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
~[mysql-connector-java-8.0.20.jar:8.0.20]
at
com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
~[mysql-connector-java-8.0.20.jar:8.0.20]
at
com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003)
~[mysql-connector-java-8.0.20.jar:8.0.20]
at
com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
~[HikariCP-3.4.5.jar:na]
at
com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
~[HikariCP-3.4.5.jar:na]
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]
at org.hibernate.loader.Loader.getResultSet(Loader.java:2285)
~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2038)
~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2000)
~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]
at org.hibernate.loader.Loader.doQuery(Loader.java:951)
~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:352)
~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]
at org.hibernate.loader.Loader.doList(Loader.java:2831)
~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]
at org.hibernate.loader.Loader.doList(Loader.java:2813)
~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2645)
~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]
at org.hibernate.loader.Loader.list(Loader.java:2640)
~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:506)
~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]
at
org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:400)
~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]
at
org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219)
~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1412)
~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]
at
org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1565)
~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]
at
org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1533)
~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]
at org.hibernate.query.Query.getResultList(Query.java:165)
~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]
at
org.springframework.data.jpa.repository.query.JpaQueryExecution$CollectionExecution.doExecute(JpaQueryExecution.java:126)
~[spring-data-jpa-2.3.1.RELEASE.jar:2.3.1.RELEASE]
at
org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:88)
~[spring-data-jpa-2.3.1.RELEASE.jar:2.3.1.RELEASE]
at
org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:154)
~[spring-data-jpa-2.3.1.RELEASE.jar:2.3.1.RELEASE]
at
org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:142)
~[spring-data-jpa-2.3.1.RELEASE.jar:2.3.1.RELEASE]
at
org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor$QueryMethodInvoker.invoke(QueryExecutorMethodInterceptor.java:195)
~[spring-data-commons-2.3.1.RELEASE.jar:2.3.1.RELEASE]
at
org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.doInvoke(QueryExecutorMethodInterceptor.java:152)
~[spring-data-commons-2.3.1.RELEASE.jar:2.3.1.RELEASE]
at
org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.invoke(QueryExecutorMethodInterceptor.java:130)
~[spring-data-commons-2.3.1.RELEASE.jar:2.3.1.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.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:80)
~[spring-data-commons-2.3.1.RELEASE.jar:2.3.1.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.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
~[spring-tx-5.2.7.RELEASE.jar:5.2.7.RELEASE]
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
~[spring-tx-5.2.7.RELEASE.jar:5.2.7.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.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
~[spring-tx-5.2.7.RELEASE.jar:5.2.7.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.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:149)
~[spring-data-jpa-2.3.1.RELEASE.jar:2.3.1.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.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95)
~[spring-aop-5.2.7.RELEASE.jar:5.2.7.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 com.sun.proxy.$Proxy163.findIssuesAfterComic(Unknown Source) ~[na:na]
at jdk.internal.reflect.GeneratedMethodAccessor476.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:567) ~[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.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:205)
~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
at com.sun.proxy.$Proxy88.findIssuesAfterComic(Unknown Source) ~[na:na]
at org.comixed.service.comic.ComicService.getComic(ComicService.java:241)
~[classes/:na]
...
On Sun, Jul 5, 2020 at 7:38 AM Darryl L. Pierce <mcpierce@xxxxxxxxx>
wrote:
I don't think you need to open a ticket on this: I'm experiencing the
same problem on develop while working on the delete blocked pages piece. I
can look into the bug while working on this.
On Sat, Jul 4, 2020 at 8:07 PM bareheiny <dmarc-noreply@xxxxxxxxxxxxx>
wrote:
Yeah, running 0.7.
I *think* I started with a fresh dB, but can’t say for sure.
Will back it up and attach it to a bug on GitHub tonight.
On 5/07/2020, at 11:36, Darryl L. Pierce <mcpierce@xxxxxxxxx> wrote:
Are you running the 0.7 development builds or the 0.6 release? If the
former, it could be the new changes I've added to the set of tasks
affecting things. Can you take a snapshot of your DB and we can try to
triage it?
On Sat, Jul 4, 2020 at 6:05 AM bareheiny <dmarc-noreply@xxxxxxxxxxxxx>
wrote:
For reasons unknown, this has popped up again...
https://www.freelists.org/post/comixed/Comic-stuck-processing,3
I’ll back up the dB, and work through manually deleting it via SQL
again (don’t think I kept the script I created last time).
--
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
--
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
--
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
