BeelGroup / Docear-API

Web-based components (recommender, database, hibernate, ...)
0 stars 0 forks source link

'NaN' SQL error in recommendations generator #27

Open stlanger opened 11 years ago

stlanger commented 11 years ago

2013-08-09 09:25:14,171 [pool-16-thread-1] 233 WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: S1009 2013-08-09 09:25:14,171 [pool-16-thread-1] 234 ERROR org.hibernate.util.JDBCExceptionReporter - 'NaN' is not a valid numeric or approximate numeric value 2013-08-09 09:25:14,173 [pool-16-thread-1] 233 WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 1048, SQLState: 23000 2013-08-09 09:25:14,174 [pool-16-thread-1] 234 ERROR org.hibernate.util.JDBCExceptionReporter - Column 'user_model_id' cannot be null 2013-08-09 09:25:14,383 [pool-16-thread-1] 45 ERROR org.hibernate.AssertionFailure - an assertion failure occured (this may indicate a bug in Hibernate, but is more likely due to unsafe use of the session) org.hibernate.AssertionFailure: null id in org.sciplore.resources.UserModel entry (don't flush the Session after an exception occurs) at org.hibernate.event.def.DefaultFlushEntityEventListener.checkId(DefaultFlushEntityEventListener.java:82) at org.hibernate.event.def.DefaultFlushEntityEventListener.getValues(DefaultFlushEntityEventListener.java:190) at org.hibernate.event.def.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:147) at org.hibernate.event.def.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:219) at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:99) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) at util.RecommendationCommons.computeForSingleUser(RecommendationCommons.java:237) at util.RecommendationCommons.computeForSingleUser(RecommendationCommons.java:117) at util.RecommendationCommons.forceComputeForSingleUser(RecommendationCommons.java:106) at rest.UserRessource$4.run(UserRessource.java:610) at util.recommendations.AsynchronousRecommendationsGeneratorAfterNewMap$2.run(AsynchronousRecommendationsGeneratorAfterNewMap.java:31) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) org.hibernate.AssertionFailure: null id in org.sciplore.resources.UserModel entry (don't flush the Session after an exception occurs) at org.hibernate.event.def.DefaultFlushEntityEventListener.checkId(DefaultFlushEntityEventListener.java:82) at org.hibernate.event.def.DefaultFlushEntityEventListener.getValues(DefaultFlushEntityEventListener.java:190) at org.hibernate.event.def.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:147) at org.hibernate.event.def.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:219) at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:99) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) at util.RecommendationCommons.computeForSingleUser(RecommendationCommons.java:237) at util.RecommendationCommons.computeForSingleUser(RecommendationCommons.java:117) at util.RecommendationCommons.forceComputeForSingleUser(RecommendationCommons.java:106) at rest.UserRessource$4.run(UserRessource.java:610) at util.recommendations.AsynchronousRecommendationsGeneratorAfterNewMap$2.run(AsynchronousRecommendationsGeneratorAfterNewMap.java:31) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)

stlanger commented 10 years ago

from the log 2013-12-12 13:22:33: error when saving the model for user [1951] with algorithm[143389] having no_days_since_max: 480