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

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Moved dotCMS 2.5.6 to another AWS EC2 instance
    via by Billy Bacon,
  • Host / Folder failing to publish
    via GitHub by wezell
    ,
  • seeing this on mysql startup
    via GitHub by wezell
    ,
  • Ant "deploy" task is broken
    via GitHub by cppexpert
    ,
  • Bundle fails to publish
    via GitHub by wezell
    ,
    • 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#433d48bd-055b-47cf-9455-f48307aab000] 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-48190c8c-42c4-46af-8d1' 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

    Users with the same issue

    slash
    slash1 times, last one,
    ivanszkypeter
    ivanszkypeter8 times, last one,
    DoktorDoener666
    DoktorDoener6662 times, last one,
    mauritius
    mauritius1 times, last one,
    Unknown visitor1 times, last one,
    59 more bugmates