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; } } }

Attention JIRA SMEs Can you answer these 4.1.2 questions?

Elijah

Had to nest questions because I don't have enough points to post more on the forum in a day.

We are attempting to get access permissions to the Postgresql logs but for now we only have limited information.

EXECUTE &lt;unnamed&gt; = DELETE FROM PUBLIC.MEMBERSHIPBASE WHERE USER_NAME=$1 AND GROUP=$2

The above will execute in a days time 36 million times. We have only a few hundred users.

Part of the issue we have is that the following call is running all the time and we do not know...

What triggers the call?
Why is it being called?
What is JIRA trying to do?
What files is it trying to set?
What database tables is it trying to alter aside from what is in the call?

===============================================================

Attention JIRA SMEs Can you answer this 4.1.2 limited access question?

Users are able to post to the application via direct web service calls.

Users are not able to post to the application via the GUI. The GUI just hangs until it errors out and there is nothing in the logs to give us a clue as to why. Logging is set to FINE.

There have been no modifications to the application. The database provider informed us that they implemented a patch from 9.2.11 to 9.2.13 on Postgresql.

Are there any tools that JIRA has that can assist with tracking this down?

Due to restriction in posting I cannot add new comments only edit this one.

Will look into the Jelly thing to see what I can find in our codebase.

@Nic Brough [Adaptavist] Yes you are correct. We do have an external database. We have put in a request to obtain a full copy of the VM so we can duplicate in our test environment what is on production. They have given us only a dump of the db but that does us little good.

Accepted answers

Darren Pegg

Looks like it's trying to delete a user and a group though together which I'm sure you can only do one or the other. Unless there is a jelly script sat on a listener? Can you see if the user/group it's trying to remove exist? I'm guessing you have blanked them out from the ubove description. Maybe create them so it can delete them and maybe it will realise it's performed it's task and stop.. I'd check the release notes on the next version up and see if the fault was fixed.

All comments

Darren Pegg

Nic Brough -Adaptavist-

My guess is that you have an external user database (and there's something odd with the config of that)

My other guesses are what Darren said.

Elijah

I'm still looking into code but cannot find anything that is attempting to execute that statement.

Darren Pegg

Have you checked the list of services in JIRA? Is there any logs that have created at the time it tries to delete?

Elijah

Ready to throw in the towel on this. I have no access to production. I'm not allowed to: view the site. view logs in real time, see the network traffic but I'm suppose to ask for things that I don't know what to ask for. Stuck under a rock in a tar pit is what I am.

Welcome!

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

Quick Links

Find more posts tagged with

jira

jira-administration