[I] [BUG] After restarting, the monitoring effect is lost [hertzbeat]</span></a></span> </h1> <p class="darkgray font13"> <span class="sender pipe"><a href="/search?l=notifications@hertzbeat.apache.org&q=from:%22via+GitHub%22" rel="nofollow"><span itemprop="author" itemscope itemtype="http://schema.org/Person"><span itemprop="name">via GitHub</span></span></a></span> <span class="date"><a href="/search?l=notifications@hertzbeat.apache.org&q=date:20250808" rel="nofollow">Fri, 08 Aug 2025 03:03:03 -0700</a></span> </p> </div> <div itemprop="articleBody" class="msgBody"> <!--X-Body-of-Message--> <pre> QBH-insist opened a new issue, #3647: URL: <a rel="nofollow" href="https://github.com/apache/hertzbeat/issues/3647">https://github.com/apache/hertzbeat/issues/3647</a></pre><pre> ### Is there an existing issue for this? - [x] I have searched the existing issues ### Current Behavior I modified the slow SQL monitoring settings in the built-in PostgreSQL monitoring template. After restarting, the actual monitoring effect remained as it was before the modification. However, the modified content was not lost, and I had to save and apply it again for it to work properly. I am using an external PostgreSQL database, and the following is the mounting status. <img width="180" height="129" alt="Image" src="<a rel="nofollow" href="https://github.com/user-attachments/assets/2a859d60-f595-4a18-ab2a-90783c9f739d"">https://github.com/user-attachments/assets/2a859d60-f595-4a18-ab2a-90783c9f739d"</a>; /> Normal： > I restrict SQL to only query slow SQLs that take more than 5000ms. ![Image](<a rel="nofollow" href="https://github.com/user-attachments/assets/3b4143d0-b0da-4430-aba8-28312688cb18">https://github.com/user-attachments/assets/3b4143d0-b0da-4430-aba8-28312688cb18</a>) UnNormal: ![Image](<a rel="nofollow" href="https://github.com/user-attachments/assets/db54c485-7466-4c92-9c07-cc9e57ae00c2">https://github.com/user-attachments/assets/db54c485-7466-4c92-9c07-cc9e57ae00c2</a>) ### Expected Behavior After restarting, the monitoring remains normal. ### Steps To Reproduce Modify the slow SQL module of PostgreSQL, and change the SQL to: > select * from pg_stat_statements WHERE calls > 0 and mean_exec_time > 5000 and query NOT ILIKE '%pg_backup_start%' ORDER BY mean_exec_time DESC; ### Environment ```markdown HertzBeat version(s): 1.7.2 ``` ### Debug logs _No response_ ### Anything else? I see that there is a similar issue for this problem, and the associated task has been completed. Has this fix not been merged into the 1.7.2 branch? <a rel="nofollow" href="https://github.com/apache/hertzbeat/issues/3277">https://github.com/apache/hertzbeat/issues/3277</a> <a rel="nofollow" href="https://github.com/apache/hertzbeat/issues/3279">https://github.com/apache/hertzbeat/issues/3279</a> -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: notifications-unsubscr...@hertzbeat.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: notifications-unsubscr...@hertzbeat.apache.org For additional commands, e-mail: notifications-h...@hertzbeat.apache.org </pre> </div> <div class="msgButtons margintopdouble"> <ul class="overflow"> <li class="msgButtonItems"><a class="button buttonleft " accesskey="p" href="msg12188.html">Previous message</a></li> <li class="msgButtonItems textaligncenter"><a class="button" accesskey="c" href="thrd7.html#12189">View by thread</a></li> <li class="msgButtonItems textaligncenter"><a class="button" accesskey="i" href="mail8.html#12189">View by date</a></li> <li class="msgButtonItems textalignright"><a class="button buttonright " accesskey="n" href="msg12206.html">Next message</a></li> </ul> </div> <a name="tslice"></a> <div class="tSliceList margintopdouble"> <ul class="icons monospace"> <li class="icons-email tSliceCur"><span class="subject">[I] [BUG] <title>After restarting, the monitoring effect ...</span> <span class="sender italic">via GitHub</span></li> <li><ul> <li class="icons-email"><span class="subject"><a href="msg12206.html">Re: [I] [BUG] <title>After restarting, the monitorin...</a></span> <span class="sender italic">via GitHub</span></li> <li class="icons-email"><span class="subject"><a href="msg12242.html">Re: [I] [BUG] <title>After restarting, the monitorin...</a></span> <span class="sender italic">via GitHub</span></li> <li class="icons-email"><span class="subject"><a href="msg12265.html">Re: [I] [BUG] <title>After restarting, the monitorin...</a></span> <span class="sender italic">via GitHub</span></li> <li class="icons-email"><span class="subject"><a href="msg12267.html">Re: [I] [BUG] <title>After restarting, the monitorin...</a></span> <span class="sender italic">via GitHub</span></li> </ul> </ul> </div> <div class="overflow msgActions margintopdouble"> <div class="msgReply" > <h2> Reply via email to </h2> <form method="POST" action="/mailto.php"> <input type="hidden" name="subject" value="[I] [BUG] <title>After restarting, the monitoring effect is lost [hertzbeat]"> <input type="hidden" name="msgid" value="I_kwDOGyeqAs7E5ovN@gitbox.apache.org"> <input type="hidden" name="relpath" value="notifications@hertzbeat.apache.org/msg12189.html"> <input type="submit" value=" via GitHub "> </form> </div> </div> </div> <div class="aside" role="complementary"> <div class="logo"> <a href="/"><img src="/logo.png" width=247 height=88 alt="The Mail Archive"></a> </div> <form class="overflow" action="/search" method="get"> <input type="hidden" name="l" value="notifications@hertzbeat.apache.org"> <label class="hidden" for="q">Search the site</label> <input class="submittext" type="text" id="q" name="q" placeholder="Search notifications"> <input class="submitbutton" name="submit" type="image" src="/submit.png" alt="Submit"> </form> <div class="nav margintop" id="nav" role="navigation"> <ul class="icons font16"> <li class="icons-home"><a href="/">The Mail Archive home</a></li> <li class="icons-list"><a href="/notifications@hertzbeat.apache.org/">notifications - all messages</a></li> <li class="icons-about"><a href="/notifications@hertzbeat.apache.org/info.html">notifications - about the list</a></li> <li class="icons-expand"><a href="/search?l=notifications@hertzbeat.apache.org&q=subject:%22%5C%5BI%5C%5D+%5C%5BBUG%5C%5D+%3Ctitle%3EAfter+restarting%2C+the+monitoring+effect+is+lost+%5C%5Bhertzbeat%5C%5D%22&o=newest&f=1" title="e" id="e">Expand</a></li> <li class="icons-prev"><a href="msg12188.html" title="p">Previous message</a></li> <li class="icons-next"><a href="msg12206.html" title="n">Next message</a></li> </ul> </div> <div class="listlogo margintopdouble"> </div> <div class="margintopdouble"> </div> </div> </div> <div class="footer" role="contentinfo"> <ul> <li><a href="/">The Mail Archive home</a></li> <li><a href="/faq.html#newlist">Add your mailing list</a></li> <li><a href="/faq.html">FAQ</a></li> <li><a href="/faq.html#support">Support</a></li> <li><a href="/faq.html#privacy">Privacy</a></li> <li class="darkgray">I_kwDOGyeqAs7E5ovN@gitbox.apache.org</li> </ul> </div> </body> </html> <script>(function(){function c(){var b=a.contentDocument||a.contentWindow.document;if(b){var d=b.createElement('script');d.innerHTML="window.__CF$cv$params={r:'9ecae623ecc38a31',t:'MTc3NjI1NTU3MA=='};var a=document.createElement('script');a.src='/cdn-cgi/challenge-platform/scripts/jsd/main.js';document.getElementsByTagName('head')[0].appendChild(a);";b.getElementsByTagName('head')[0].appendChild(d)}}if(document.body){var a=document.createElement('iframe');a.height=1;a.width=1;a.style.position='absolute';a.style.top=0;a.style.left=0;a.style.border='none';a.style.visibility='hidden';document.body.appendChild(a);if('loading'!==document.readyState)c();else if(window.addEventListener)document.addEventListener('DOMContentLoaded',c);else{var e=document.onreadystatechange||function(){};document.onreadystatechange=function(b){e(b);'loading'!==document.readyState&&(document.onreadystatechange=e,c())}}}})();</script>