com.dotmarketing.exception.DotDataException: Unable to flush Hibernate Session


Solutions on the web1

Solution icon of googlegroups
via Google Groups by Billy Bacon, 9 months ago
Unable to flush Hibernate Session

Stack trace

com.dotmarketing.exception.DotDataException: Unable to flush Hibernate 
Session
	at com.dotmarketing.portlets.files.business.FileFactoryImpl.saveFile(FileFactoryImpl.java:175)
	at com.dotmarketing.portlets.files.business.FileAPIImpl.saveFile(FileAPIImpl.java:473)
	at com.dotmarketing.portlets.files.business.FileAPIImpl.saveFile(FileAPIImpl.java:437)
	at org.dotcms.plugins.XMLSitemap.thread.XMLSitemapThread.closeFileWriter(XMLSitemapThread.java:445)
	at org.dotcms.plugins.XMLSitemap.thread.XMLSitemapThread.generateSitemapPerHost(XMLSitemapThread.java:277)
	at org.dotcms.plugins.XMLSitemap.thread.XMLSitemapThread.<init>(XMLSitemapThread.java:92)
	at sun.reflect.GeneratedConstructorAccessor187.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:534)
	at java.lang.Class.newInstance(Class.java:379)
	at org.quartz.simpl.SimpleJobFactory.newJob(SimpleJobFactory.java:55)
	at org.quartz.core.JobRunShell.initialize(JobRunShell.java:140)
	at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:364)
Caused by: com.dotmarketing.exception.DotHibernateException: Unable to 
flush Hibernate Session
	at com.dotmarketing.db.HibernateUtil.saveWithPrimaryKey(HibernateUtil.java:869)
	at com.dotmarketing.business.IdentifierFactoryImpl.createNewIdentifier(IdentifierFactoryImpl.java:295)
	at com.dotmarketing.business.IdentifierFactoryImpl.createNewIdentifier(IdentifierFactoryImpl.java:232)
	at com.dotmarketing.business.IdentifierAPIImpl.createNew(IdentifierAPIImpl.java:136)
	at com.dotmarketing.business.IdentifierAPIImpl.createNew(IdentifierAPIImpl.java:129)
	at com.dotmarketing.portlets.files.business.FileFactoryImpl.saveFile(FileFactoryImpl.java:145)
	... 12 more
Caused by: net.sf.hibernate.exception.ConstraintViolationException: could 
not insert: 
[com.dotmarketing.beans.Identifier#f1453088-ae97-4de2-8f45-d6d56c607e1b]
	at net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:73)
	at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
	at net.sf.hibernate.persister.AbstractEntityPersister.convert(AbstractEntityPersister.java:1331)
	at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:472)
	at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:436)
	at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37)
	at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2449)
	at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2435)
	at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2392)
	at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2261)
	at com.dotmarketing.db.HibernateUtil.saveWithPrimaryKey(HibernateUtil.java:867)
	... 17 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 
'/XMLSitemaps/-XMLSitemapGenerated1.xml.gz-091f8e28-889a-409a-b45' for key 
'parent_path'
	at sun.reflect.GeneratedConstructorAccessor138.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:534)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1040)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2794)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359)
	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
	at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
	at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462)
	... 24 more

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 month ago
3 times, 2 months ago
2 times, 2 months ago
3 times, 2 months ago
22 times, 2 months ago
65 more bugmates