Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

select AURORA_VERSION() as aurora_version SYNTAX error

I keep getting the error below every hour in postgresql alert log

function aurora_version() does not exist at character 8    ,  the error log is full of this error every our , Please have a look below

 

 

any ideas

thanks

2 answers

1 accepted

0 votes
Answer accepted

Something is reading your database looking for the version of the database, and assuming it is an AWS aurora database.

Confluence does not do this.

Thank you Nic, for your feedback, below is the full error

 

2019-10-10 09:42:11 CEST [32073-1] confluenceuser@confluence ERROR: function aurora_version() does not exist at character 8
2019-10-10 09:42:11 CEST [32073-2] confluenceuser@confluence HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2019-10-10 09:42:11 CEST [32073-3] confluenceuser@confluence STATEMENT: select AURORA_VERSION() as aurora_version
2019-10-10 09:42:11 CEST [32073-4] confluenceuser@confluence ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-10-10 09:42:11 CEST [32073-5] confluenceuser@confluence STATEMENT: select 1

Hi,

I'm sorry for necroing this, but I experienced a test Confluence crash few days ago, and it looked like the db just went away. After some troubleshooting I noticed something is bombarding our Confluence PostgreSQL db with similiar stuff, I have identical log entries as @safwan 

Maybe some plugin is doing this? Nothing else but Confluence is allowed to use that db. I'm getting a bit worried as I can't determine if the test server crash is related to this, I would very much like to rule this out if possible, I don't want this to happen in production.

I also get same error when I open Settings page in Jira:

 

2019-10-18 11:10:12 EEST PostgreSQL JDBC Driver jiradb jira_user 127.0.0.1 ERROR: function aurora_version() does not exist at character 8


2019-10-18 11:10:12 EEST PostgreSQL JDBC Driver jiradb jira_user 127.0.0.1 HINT: No function matches the given name and argument types. You might need to add explicit type casts.


2019-10-18 11:10:12 EEST PostgreSQL JDBC Driver jiradb jira_user 127.0.0.1 STATEMENT: select AURORA_VERSION() as aurora_version


2019-10-18 11:12:13 EEST PostgreSQL JDBC Driver jiradb jira_user 127.0.0.1 ERROR: function aurora_version() does not exist at character 8


2019-10-18 11:12:13 EEST PostgreSQL JDBC Driver jiradb jira_user 127.0.0.1 HINT: No function matches the given name and argument types. You might need to add explicit type casts.


2019-10-18 11:12:13 EEST PostgreSQL JDBC Driver jiradb jira_user 127.0.0.1 STATEMENT: select AURORA_VERSION() as aurora_version

 

I've noticed this after upgradig to the latest Jira 8.4.2 (from 8.3.x).

Is this some weird PostgreSQL version bug we are experiencing?

My Postgres version is 9.5.19
Confluence's psql driver version 42.1.1

... Is this because of licensing? Server products have line in Supported Platforms -page that says it's not supported to run them on top of Aurora database. Is this just Confluence (and Jira) checking constantly if the Postgres is Aurora or not?

If it is, wouldn't it suffice to check this on boot and not keep hammering the database with Aurora functions, it's really irritating and makes reading database logs more painful.

Greping shows this:

 

# fgrep -R -e"aurora_version"
Binary file atlassian-jira/WEB-INF/classes/com/atlassian/jira/util/system/probes/AwsAuroraPostgreSQLProbe.class matches

Looks like it's this new feature that introduced this error:

https://jira.atlassian.com/browse/JRASERVER-41985

Hi all,

Is there at least a workaround for this problem because we are in 8.5.1 (self-hosted) and our postGresql (9.5.19) logs still contain these errors ?

Like safwan likes this

Any update on this issue? We are facing exactly the same problem. And: License expired yesterday. Does a license renewal solve this issue?

Like George Mihailoff likes this

Just noting that this also happens with the latest version of BitBucket when running on an AWS instance.

@Tadas I have logged https://jira.atlassian.com/browse/JRASERVER-71055 over the Select AURORA_VERSION() issue. 

Like Sylvain Leduc likes this

Strike my remark. It was just my database being locked.

I stopped my bitbucket server instance and now it won't start again. I keep seeing that error in the postgresql logs...

It is not caused by another application, as there is no other application talking to my PostgreSQL 10.12 database server. My PostgreSQL server is dedicated to a single instance of Confluence 7.3.1.

To figure out if it is caused by a plugin i disabled all user-installed plugins where i get a "disable" button.

After disabling "Atlassian Troubleshooting and Support Tools" (1.23.3) i never saw above mentioned errors anymore.

I guess it is triggered on confluence launch or when navigating to admin area / "manage apps" / "user-installed apps". Maybe this is not happening on a fresh installation. My Confluence instance was updated alot of times in the last 9 years.

FYI: @Nic Brough _Adaptavist_
@safwanyou may want to file a bug report.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

What do you think is the most *delightful* Confluence feature? Comment for a prize!

- Create your own custom emoji 🔥 - "Shake for Feedback" on mobile 📱 - An endless supply of GIFs via GIPHY 🤩 Is there anything quite as nice as a pleasant surprise? Comment below with what...

342 views 23 8
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you