nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Postgres - Schema check for table [EVENTS] encountered an error

Jiri Pik

How to troubleshoot this?

2018-02-26 18:06:42,072 WARN [AtlassianEvent::CustomizableThreadFactory-1] [persistence.schema.hibernate.HibernateSchemaComparator] lambda$compareTables$0 Schema check for table [EVENTS] encountered an error. Turn debug logging on for stacktrace.
2018-02-26 18:06:42,081 WARN [AtlassianEvent::CustomizableThreadFactory-1] [persistence.schema.hibernate.HibernateSchemaComparator] lambda$compareTables$0 Schema check for table [SECRETS] encountered an error. Turn debug logging on for stacktrace.
2018-02-26 18:06:42,082 WARN [AtlassianEvent::CustomizableThreadFactory-1] [persistence.schema.hibernate.HibernateSchemaComparator] lambda$compareTables$0 Schema check for table [SNAPSHOTS] encountered an error. Turn debug logging on for stacktrace.
2

Accepted answers

AnnWorley

Hi Jiri,

Are you using PostgreSQL? I found this in a support ticket that reported the same error:

...these warnings are not worrying at all and won't hinder the functionality or performance of any feature in the application. We have seen it appear on other instances running on PostgreSQL, but never got reports of any performance degradation.

Are you experiencing any unexpected/undesirable behavior from Confluence? If not, the warnings may be ignored. If so, please let me know what is not working as expected so we can take a closer look.

Cheers,

Ann

All comments

AnnWorley

Hi Jiri,

Are you using PostgreSQL? I found this in a support ticket that reported the same error:

...these warnings are not worrying at all and won't hinder the functionality or performance of any feature in the application. We have seen it appear on other instances running on PostgreSQL, but never got reports of any performance degradation.

Are you experiencing any unexpected/undesirable behavior from Confluence? If not, the warnings may be ignored. If so, please let me know what is not working as expected so we can take a closer look.

Cheers,

Ann

Jiri Pik

Yes, PostgreSql running on AWS RDS.

There was a Denial of Service attack on my confluence - which caused the PostgreSql to reject any connections - I think the attackers might have tried to insert some special values into username and password and it made PostgreSql reject all calls from Confluence. On the same server, I am running also JIRA which was unaffacted. The solution was to restart PostgreSQL

ZZZZZ is the server name.

The same thing happened today.

Also, sometimes when i restart the server, confluence is not starting up - again most likely database problem.

Are there any special PostgreSQL params in RDS i should have a look atr?

018-02-19 00:03:52,052 ERROR [C3POPooledConneccionPoolHanager[IdencicyToken->lbr8bmq9t1aicapcsimluk|55074Odf]-HelperThread-#1] [org.poscgresql.Driver] connect; Connection error:
rg.postgresql.util.PSQLException: Connection to ZZZZZ:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections, at org.postgresql.core.v3.ConnectionFactorylmpl.openConnectionlmpl(ConnectionFactorylmpl.java:265) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:4 9) at org.postgresql.j dbc.PgConnection.<init>(PgConnection.j ava:194) at org.postgresql.Driver.makeConnection(Driver.j ava:450) at org.postgresql.Driver.connect(Driver.java:252)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.j ava:220) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.j ava:206)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$lPooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.j ava:203) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125) at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870) at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoo1AsynchronousRunner.j ava:6 96) aused by: java.net.ConnectException: Network is unreachable (connect failed) at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPIainSocketImpl.doConnect(AbstractPlainSocketImpl.j ava:350)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.j ava:2 0 6)
at java.net.AbstractPIainSocketImpl.connect(AbstractPIainSocketImpl.j ava:188)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.j ava:3 92)
at java.net.Socket.connect(Socket.java:589)
at org.postgresql.core.PGStream.<init>(PGStream.j ava:68)
at org.postgresql.core.v3.ConnectionFactorylmpl.openConnectionlmpl(ConnectionFactorylmpl.j ava:14 4)
... 13 more

Jiri Pik

Could the problem be the max number of open connections? Or something along those lines - the restart of PostgreSql always solves the problem?

Jiri Pik

I have also found this

https://confluence.atlassian.com/confkb/confluence-postgresql-jdbc-direct-connection-refused-683543784.html?utm_medium=logScan&utm_source=STP

but have no idea how to action it on AWS PostgreSql RDS.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence