After update confluence to 6.13.1 have many connection UPDATE AO_92296B_AORECENTLY_VIEWED

[Anton Patsev]

After update confluence to 6.13.1 have many connection UPDATE AO_92296B_AORECENTLY_VIEWED

➤ psql://postgres@postgres:5432/postgres

# :queries
runtime | pid | datname | usename | query
------------------+-------+------------+------------+--------------------------------------------------------------------------------------------
09:56:17.837023 | 29019 | confluence | confluence | UPDATE "AO_92296B_AORECENTLY_VIEWED" SET "LAST_VIEW_DATE" = $1 WHERE "ID" = $2
09:38:39.679915 | 7882 | confluence | confluence | UPDATE "AO_92296B_AORECENTLY_VIEWED" SET "LAST_VIEW_DATE" = $1 WHERE "ID" = $2
09:08:49.726505 | 7595 | confluence | confluence | UPDATE "AO_92296B_AORECENTLY_VIEWED" SET "LAST_VIEW_DATE" = $1 WHERE "ID" = $2
08:44:45.157807 | 9934 | confluence | confluence | UPDATE "AO_92296B_AORECENTLY_VIEWED" SET "LAST_VIEW_DATE" = $1 WHERE "ID" = $2
08:41:38.881429 | 15540 | confluence | confluence | UPDATE "AO_92296B_AORECENTLY_VIEWED" SET "LAST_VIEW_DATE" = $1 WHERE "ID" = $2
08:16:04.383338 | 7951 | confluence | confluence | UPDATE "AO_92296B_AORECENTLY_VIEWED" SET "LAST_VIEW_DATE" = $1 WHERE "ID" = $2
08:15:41.199733 | 13783 | confluence | confluence | UPDATE "AO_92296B_AORECENTLY_VIEWED" SET "LAST_VIEW_DATE" = $1 WHERE "ID" = $2

In logs confluence:

2019-03-13 18:02:15,925 ERROR [http-nio-8090-exec-12] [[Standalone].[localhost].[/].[noop]] log Servlet.service() for servlet [noop] in context with path [] threw exception
java.lang.RuntimeException: org.apache.catalina.connector.ClientAbortException: java.io.IOException: Broken pipe

How debug many connection?

How reduce connection?

[Anton Patsev]

Somebody please help me.

[Diego]

Hello there! Thanks for reaching out Anton.

The table named AO_92296B_AORECENTLY_VIEWED contains data about recent pages that have been viewed. This table has data for roughly the last two months. Other detail is that the data stored there is only for each user_key + content_id that is unique.

For example, if User A visits Page A 35 times, there will be only one entry in this table.

Having a more constant updates on this table is normal.

However, I would like to clarify some points with you:

1. Is your instance slower than before?
2. Are your users facing any kind of issue during normal usage?
3. Is there any issue that might stem from this database connection?

Looking forward to your reply Anton. Let us keep in touch!

[Anton Patsev]

Hello!

Is your instance slower than before?
No

Are your users facing any kind of issue during normal usage?

When use all connection in pool - confluence down work. After some time, thread pool of confluence got clogged with locked threads, trying to update AO_92296B...., whick locks all the external access to confluence entirely

Is there any issue that might stem from this database connection?

Everything works just fine exept those updates on AO_92....

[Diego]

Hello there Anton, thanks for replying!

We can try and check if this issue is being caused by some problematic data in your Confluence cache or even a plugin. We can first try and clear the plugin cache:

1. Schedule a downtime for your instance
2. Shutdown Confluence
3. Go to the <confluence-home> folder
4. Remove these folders:
   1. <confluence-home>/bundled-plugins
   2. <confluence-home>/plugins-cache
   3. <confluence-home>/plugins-osgi-cache
   4. <confluence-home>/plugins-temp
   5. <confluence-home>/bundled-plugins_language
5. Start Confluence
6. Check if the issue happens again

If the issue persists, we can try and disable all user installed plugins

1. Click the Cog Icon at the top right corner
2. Select Add-ons
3. Scroll down to the bottom
4. Click Enter Safe Mode
5. Proceed to enter safe mode
6. Check if the issue persists

Also, could you provide us with a little more information:

1. The value of the parameter <property name="hibernate.c3p0.max_size">60</property> under confluence.cfg.xml file
2. The maxThreads value under your server.xml
3. The connection pool size of your PostgreSQL database

If you have a DataSource connection, the pool size will be located under your server.xml file, there should be no need to look elsewhere under the application. But we still need the info from your database.

Looking forward to your reply!