<div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr">Hi, I strongly recommend building your own 3.7-support mp on very latest branch. Dont forget new DB script on upgrade path (with indexes). Just today, there was another OOM fix released. We are still working with Evolveum on this and continually improving memory performance. I dont know about your particular SQL error, try purging audit log by smaller amounts by playing with auditRecords cleanuppolicy in systemconfig.<div><br></div><div>Also make sure your search-iterative tasks use aggregateOutput=false param to save memory.</div><div><div><scext:executeScript xmlns:scext="<a href="http://midpoint.evolveum.com/xml/ns/public/model/scripting/extension-3">http://midpoint.evolveum.com/xml/ns/public/model/scripting/extension-3</a>"></div><div><span style="white-space:pre"> </span><s:search></div></div><div>....</div><div>....</div><div><div><b><s:aggregateOutput>false</s:aggregateOutput></b></div><div><span style="white-space:pre"> </span></s:search><span style="white-space:pre"> </span></div><div><span style="white-space:pre"> </span></scext:executeScript></div><div><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><p style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px"><span style="font-family:Arial,sans-serif;font-size:11px"><strong><span style="font-size:13px">Martin Lízner</span></strong><br><span style="color:rgb(128,128,128)">chief solution architect</span></span></p><p style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px">gsm: [+420] 737 745 571<br>e‑mail: <a href="mailto:martin.lizner@ami.cz" target="_blank">martin.lizner@ami.cz</a></p><p style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px"><strong>AMI Praha a.s.</strong><br>Pláničkova 11, 162 00 Praha 6</p><p style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px">tel.: [+420] 274 783 239 | web: <a href="http://dtp.ami.cz/www.ami.cz" target="_blank">www.ami.cz</a></p><p style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px;margin-top:20px"><img src="http://www.ami.cz/images/podpis/ami_logo.gif" alt="AMI Praha a.s." style="border: 0px;"></p><p style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px"><span style="color:rgb(170,170,170)">Textem tohoto e‑mailu podepisující neslibuje uzavřít ani neuzavírá za společnost AMI Praha a.s.<br>jakoukoliv smlouvu. Každá smlouva, pokud bude uzavřena, musí mít výhradně písemnou formu.<br><span style="font-size:6px"> </span><br>Tento e‑mail je určen výhradně pro potřeby jeho adresáta/ů a může obsahovat důvěrné nebo osobní<br>informace. Nejste‑li zamýšleným příjemcem, je zakázáno jakékoliv zveřejňování, zprostředkování<br>nebo jiné použití těchto informací. Pokud jste obdrželi e‑mail neoprávněně, informujte o tom prosím<br>odesílatele a vymažte neprodleně všechny kopie tohoto e‑mailu včetně všech jeho příloh. Nakládáním<br>s neoprávněně získanými informacemi se vystavujete riziku právního postihu.</span></p></div></div></div></div></div></div></div></div></div><br></div></div></div></div></div></div><br><div class="gmail_quote"><div dir="ltr">čt 1. 11. 2018 v 22:24 odesílatel Nicolas Rossi <<a href="mailto:nrossi@identicum.com">nrossi@identicum.com</a>> napsal:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(7,55,99)">Hi Martin, One of our customers is running midPoint 3.7.1 and they started having several memory issues. It has 8GB RAM and is configured to use almost all of this (-Xms6144M -Xmx6144). Do you know if there is a known issue with the memory on this version ?</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(7,55,99)"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(7,55,99)">I also found this error each time I run the Cleanup task: </div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(7,55,99)"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(7,55,99)">
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures">2018-11-01 17:18:25,119 [] [midPointScheduler_Worker-3] ERROR (com.evolveum.midpoint.model.impl.cleanup.CleanUpTaskHandler): Audit cleanup: error executing work</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures">com.evolveum.midpoint.util.exception.SystemException: error executing work</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at com.evolveum.midpoint.repo.sql.helpers.BaseHelper.handleGeneralRuntimeException(BaseHelper.java:178)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at com.evolveum.midpoint.repo.sql.SqlAuditServiceImpl.batchDeletionAttempt(SqlAuditServiceImpl.java:544)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at com.evolveum.midpoint.repo.sql.SqlAuditServiceImpl.cleanupAuditMaxAge(SqlAuditServiceImpl.java:420)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at com.evolveum.midpoint.repo.sql.SqlAuditServiceImpl.cleanupAudit(SqlAuditServiceImpl.java:376)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at com.evolveum.midpoint.init.AuditServiceProxy.cleanupAudit(AuditServiceProxy.java:113)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at com.evolveum.midpoint.model.impl.cleanup.CleanUpTaskHandler.run(CleanUpTaskHandler.java:116)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at com.evolveum.midpoint.task.quartzimpl.execution.JobExecutor.executeHandler(JobExecutor.java:639)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at com.evolveum.midpoint.task.quartzimpl.execution.JobExecutor.executeRecurrentTask(JobExecutor.java:522)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at com.evolveum.midpoint.task.quartzimpl.execution.JobExecutor.execute(JobExecutor.java:180)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at org.quartz.core.JobRunShell.run(JobRunShell.java:202)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:588)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures">Caused by: org.hibernate.exception.GenericJDBCException: error executing work</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:318)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:2095)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:2080)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at com.evolveum.midpoint.repo.sql.SqlAuditServiceImpl.createTemporaryTable(SqlAuditServiceImpl.java:624)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at com.evolveum.midpoint.repo.sql.SqlAuditServiceImpl.batchDeletionAttempt(SqlAuditServiceImpl.java:507)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>... 9 common frames omitted</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures">Caused by: java.sql.SQLException: (conn:1256) Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context.<span class="m_5032778018883304484gmail-Apple-converted-space"> </span>These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions.</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures">Query is : create temporary table if not exists HT_m_audit_event (id bigint not null)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:145)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at org.mariadb.jdbc.internal.util.ExceptionMapper.getException(ExceptionMapper.java:101)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at org.mariadb.jdbc.internal.util.ExceptionMapper.throwAndLogException(ExceptionMapper.java:77)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at org.mariadb.jdbc.MariaDbStatement.executeQueryEpilog(MariaDbStatement.java:224)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:258)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:271)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:909)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at com.evolveum.midpoint.repo.sql.SqlAuditServiceImpl.lambda$createTemporaryTable$2(SqlAuditServiceImpl.java:643)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at org.hibernate.jdbc.WorkExecutor.executeWork(WorkExecutor.java:54)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at org.hibernate.internal.SessionImpl$2.accept(SessionImpl.java:2076)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at org.hibernate.internal.SessionImpl$2.accept(SessionImpl.java:2073)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:313)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>... 13 common frames omitted</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures">Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context.<span class="m_5032778018883304484gmail-Apple-converted-space"> </span>These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions.</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures">Query is : create temporary table if not exists HT_m_audit_event (id bigint not null)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1114)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:137)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:249)</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures"><span class="m_5032778018883304484gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>... 20 common frames omitted</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures">2018-11-01 17:18:25,359 [] [http-nio-8080-exec-8] ERROR (com.evolveum.midpoint.web.util.MidPointProfilingServletFilter): Encountered exception: javax.servlet.ServletException: Filter execution threw an exception</span></p>
<p class="m_5032778018883304484gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(46,204,113);background-color:rgb(43,62,80)"><span class="m_5032778018883304484gmail-s1" style="font-variant-ligatures:no-common-ligatures">javax.servlet.ServletException: Filter execution threw an exception</span></p></div><div><div dir="ltr" class="m_5032778018883304484gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><font face="arial, helvetica, sans-serif"><br><br><font color="#444444">Ing Nicolás Rossi</font><br><font color="#999999">Identicum S.A.</font><br><font color="#999999">Jorge Newbery 3226</font><br><font color="#999999">Oficina: +54 (11) 4552-3050</font></font></div><div dir="ltr"><font face="arial, helvetica, sans-serif"><font color="#999999">Móvil: +54 (911) 6041-3920<br><a href="http://www.identicum.com" target="_blank">www.identicum.com</a></font></font><br></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr">On Tue, Jan 2, 2018 at 11:50 AM Martin Lízner - AMI Praha a.s. <<a href="mailto:martin.lizner@ami.cz" target="_blank">martin.lizner@ami.cz</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi, Im having OOM problems on 3.7. Which version are you on? There is Jira for it already and I think it has high priority: <a href="https://jira.evolveum.com/browse/MID-4349" target="_blank">https://jira.evolveum.com/browse/MID-4349</a><div><br></div><div>M.</div></div><div class="gmail_extra"><br clear="all"><div><div class="m_5032778018883304484m_8970308265301319327gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><table style="font-family:Verdana,Arial,Helvetica,sans-serif;border-collapse:collapse;padding:0px;margin:0px;border-width:0px!important;border-style:solid!important;width:482px!important"><tbody><tr style="padding:0px;margin:0px;border:0px solid gray!important"><td colspan="2" style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:11px;vertical-align:bottom;padding:0px;border:0px solid gray!important"><p><span style="font-size:14px;font-weight:bold">Martin Lízner</span><br>solution architect<br><br>gsm: [+420] 737 745 571<br>e-mail: <a href="mailto:martin.lizner@ami.cz" target="_blank">martin.lizner@ami.cz</a></p></td><td style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px;border-right-width:1px;border-right-style:solid;border-right-color:rgb(204,204,204);padding:0px;border-top-width:0px!important;border-bottom-width:0px!important;border-left-width:0px!important;border-top-style:solid!important;border-bottom-style:solid!important;border-left-style:solid!important;border-top-color:gray!important;border-bottom-color:gray!important;border-left-color:gray!important"> </td><td style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px;padding:0px;border:0px solid gray!important"> </td><td style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:11px;vertical-align:bottom;padding:0px;border:0px solid gray!important"><p>AMI Praha a.s.<br>Pláničkova 11<br>162 00 Praha 6<br>tel.: [+420] 274 783 239<br>web: <a href="http://www.ami.cz/" target="_blank">www.ami.cz</a></p></td><td style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px;border-right-width:1px;border-right-style:solid;border-right-color:rgb(204,204,204);padding:0px;border-top-width:0px!important;border-bottom-width:0px!important;border-left-width:0px!important;border-top-style:solid!important;border-bottom-style:solid!important;border-left-style:solid!important;border-top-color:gray!important;border-bottom-color:gray!important;border-left-color:gray!important"> </td><td style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px;padding:0px;border:0px solid gray!important"> </td><td style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:11px;margin:8px;border:0px solid gray!important"><p><img src="http://www.ami.cz/images/podpis/ami_logo.gif" alt="" style="border:0px"></p></td></tr><tr style="padding:0px;margin:0px;border:0px solid gray!important"><td colspan="8" style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px;padding:0px;border:0px solid gray!important"></td></tr><tr style="padding:0px;margin:0px;border:0px solid gray!important"><td colspan="8" style="color:rgb(128,128,128);font-family:Arial,sans-serif;font-size:11px;padding:0px;border:0px solid gray!important"><table style="font-family:Verdana,Arial,Helvetica,sans-serif;border-collapse:collapse;padding:0px;margin:0px;border-width:0px!important;border-style:solid!important;width:482px!important"><tbody><tr style="padding:0px;margin:0px;border:0px solid gray!important"><td colspan="7" style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px;padding:0px;width:480px;border:0px solid gray!important"><br><a href="http://www.skyidentity.com/" target="_blank"><img src="http://www.ami.cz/images/podpis/AMI-podpis-Sky.png" alt="AMI Praha a.s." style="border:0px;width:480px!important;height:82px!important"></a></td></tr><tr style="padding:0px;margin:0px;border:0px solid gray!important"><td colspan="7" style="font-family:Arial,sans-serif;padding:0px;border:0px solid gray!important"><br></td></tr></tbody></table>Textem tohoto e-mailu podepisující neslibuje uzavřít ani neuzavírá za společnost AMI Praha a.s.<br>jakoukoliv smlouvu. Každá smlouva, pokud bude uzavřena, musí mít výhradně písemnou formu.</td></tr></tbody></table></div><br></div></div></div></div></div></div></div></div></div>
<br><div class="gmail_quote">2017-12-28 21:26 GMT+01:00 Juan Manuel Catá <span dir="ltr"><<a href="mailto:juan.cata@despegar.com" target="_blank">juan.cata@despegar.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Greetings<br><br>Im writing in reference to a memory leak issue with my instance of MidPoint.<br><br>When I try to run MidPoint on my VM (4 cpus, 8gb RAM, 40gb HD) I got alerts in relation to "critical memory usage". In relation to this, I found that memory is not managed correctly, and is never released until the kernel kill the MidPoint process; another problem that i found is that I'm running out of availables Inodes. ¿Could this be related to some missconfiguration on my MidPoint instance? Have you noticed these kind of issues before?<br><br>Any kind of help will be appreciated<br><br>Regards<span class="m_5032778018883304484m_8970308265301319327HOEnZb"><font color="#888888"><br clear="all"><div><div><div><br>-- <br><div class="m_5032778018883304484m_8970308265301319327m_1493812455044852356gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><b>Juan Manuel Catá</b></div><div>Application Security</div><div>Juana Manso 999 - piso 2° - C.A.B.A.</div><div><b></b></div><div dir="ltr"><img src="https://www.google.com/a/despegar.com/images/logo.gif?alpha=1&service=google_default" height="55" width="135"><br></div></div></div></div></div></div></div></div>
</div></div></div></font></span></div>
<br>_______________________________________________<br>
midPoint mailing list<br>
<a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a><br>
<a href="http://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">http://lists.evolveum.com/mailman/listinfo/midpoint</a><br>
<br></blockquote></div><br></div>
_______________________________________________<br>
midPoint mailing list<br>
<a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a><br>
<a href="http://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">http://lists.evolveum.com/mailman/listinfo/midpoint</a><br>
</blockquote></div>
_______________________________________________<br>
midPoint mailing list<br>
<a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a><br>
<a href="http://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">http://lists.evolveum.com/mailman/listinfo/midpoint</a><br>
</blockquote></div>