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 <unnamed> = 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...

1. What triggers the call?
2. Why is it being called?
3. What is JIRA trying to do?
4. What files is it trying to set?
5. 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.

[Darren Pegg · Accepted solution]

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.

[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.

[Darren Pegg]

If you can't access the stuff you need to fix it then we are definitely stuck... Seems a bit backwards to ask you to fix something! :-/

[Nic Brough -Adaptavist-]

You're in a bad place - just tell them that you cannot possibly support an application that you do not have *full* access to. Not write, but you need the logs, real time, you need the network traffic, you need to be able to look around ALL of it. One simple way out of this though - raise the request with IT for a FULL working clone of the current systems. If they refuse, then the answer back really is "then YOU need to fix the issues with YOUR system that I cannot touch"

[Elijah]

They finally gave our SA rights to view realtime logs and we were able to identify where in the code things had gone awry. A limit was set for the number of users allowed to be in cache for the User Browser. The number of users had been increased and exceeded that number which ended up in items being dropped from the cache and then required to put them back in but the cache could never hold all the users. PAINFUL situations. You guys have been helpful and appreciate that you took the time to try and assist. We are pushing hard for them to rebuild the system on a new version of JIRA but I keep telling them it's only worth doing if they require that the winning contractor provides the developers with the training to build it properly and not bastardize the source code. This item is CLOSED.

[Elijah]

item is closed

[Nic Brough -Adaptavist-]

Mark one of the answers correct to "close" it.

[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.