<turbo-stream action="append" target="posts_list"><template>    <div class="postbit" id="337496" data-post-id="337496">
  <section>
    <div class="post-wrap">


					<div class="post-header">
		        <div class="user-avatar">
		          <img alt="towhans" src="https://forum.elixirforum.com/user_avatar/forum.elixirforum.com/towhans/120/17768_2.png" width="120" height="120" />
		        </div>
					
						<div class="user-details">
		          <div class="user-name">
		            <h3>
                  towhans
                  </h3>
		          </div>
						
						</div>
					
					</div>

	        <div class="thread-main">
	            <div class="post-body" data-turbo="false">
								<p>Thanks. I am trying to debug an issue when in random intervals under zero load all 16 Notifiers for 16 queues go down with:</p>
<pre data-code-wrap="elixir"><code class="lang-elixir">** (exit) %DBConnection.ConnectionError{message: "tcp async_recv: closed", severity: :error, reason: :error}
</code></pre>
<p>and DBConnection number spikes well beyond pool_size (50) + number of queues (16) to about a 100. Then after 10 minutes goes down to pool_size + number of queues.</p>
<p>Do workers require even more connections? Or will they use the pool ones? I am just trying to understand what is happening.</p>
<p>The weirdness is of course just a subjective feeling. I understand the reason for notifiers requiring their own connection. It’s just that one would expect that pool_size is the max that can happen.</p>
<p>Update: It’s deployed in Azure and the issue might be (missing) connection keepalive.</p> 
	            </div>

	            <div class="base-line">
	                <div class="thread-counters">
	                    <span class="thread-count count-likes js-likers-trigger" title="Likes" data-post-id="337496" data-batch-url="/posts/batch_likers">
                        0
                      </span>
                      <!-- <span class="thread-count js-solved-indicator" title="Marked as solution"></span> -->
	                </div>
	                <div class="go-to-post">
	                  <a title="Go to post" alt="Go to post" href="https://forum.elixirforum.com/t/ectojob-a-transactional-job-queue-built-with-ecto-postgresql-and-genstage/11771/22">Post #21</a>
	                </div>
	            </div>
              <div id="likers-container-337496" 
                   class="likers-container"
                   data-first-post="false"
                   data-batch-url="/posts/batch_likers">
                   <div class="likers-placeholder" 
                     data-likers-post-id="337496"
                     data-batch-url="/posts/batch_likers">
                  <div class="post-likers"></div>
                </div>
              </div>
	        </div>
			

    </div>

    <div class="triangle-top-right type-standard-post cat-standard-post" title="Post #21"></div>
  </section>
</div>
    <div class="postbit" id="337602" data-post-id="337602">
  <section>
    <div class="post-wrap">


					<div class="post-header">
		        <div class="user-avatar">
		          <img alt="towhans" src="https://forum.elixirforum.com/user_avatar/forum.elixirforum.com/towhans/120/17768_2.png" width="120" height="120" />
		        </div>
					
						<div class="user-details">
		          <div class="user-name">
		            <h3>
                  towhans
                  </h3>
		          </div>
						
						</div>
					
					</div>

	        <div class="thread-main">
	            <div class="post-body" data-turbo="false">
								<p>Adding this to Repo config helped. The param is documented here: <a href="https://hexdocs.pm/postgrex/Postgrex.Notifications.html" class="inline-onebox" rel="noopener nofollow ugc">Postgrex.Notifications — Postgrex v0.22.2</a></p>
<pre data-code-wrap="elixir"><code class="lang-elixir">      auto_reconnect: true
</code></pre>
<p>I believe the issue is somehow network related. Not a problem in code.</p> 
	            </div>

	            <div class="base-line">
	                <div class="thread-counters">
	                    <span class="thread-count count-likes js-likers-trigger" title="Likes" data-post-id="337602" data-batch-url="/posts/batch_likers">
                        1
                      </span>
                      <!-- <span class="thread-count js-solved-indicator" title="Marked as solution"></span> -->
	                </div>
	                <div class="go-to-post">
	                  <a title="Go to post" alt="Go to post" href="https://forum.elixirforum.com/t/ectojob-a-transactional-job-queue-built-with-ecto-postgresql-and-genstage/11771/23">Post #22</a>
	                </div>
	            </div>
              <div id="likers-container-337602" 
                   class="likers-container"
                   data-first-post="false"
                   data-batch-url="/posts/batch_likers">
                   <div class="likers-placeholder" 
                     data-likers-post-id="337602"
                     data-batch-url="/posts/batch_likers">
                  <div class="post-likers"></div>
                </div>
              </div>
	        </div>
			

    </div>

    <div class="triangle-top-right type-last-post cat-last-post" title="Last post!"></div>
  </section>
</div>
</template></turbo-stream><turbo-stream action="replace" target="load-more-container"><template><div id="load-more-container" class="load-more-container">
    <span class="all-loaded">— All posts loaded —</span>
</div></template></turbo-stream>