Error: missing ticket in JIRA

[xattab]

Hi. I'm admin in JIRA and have a problem like  "The issue you are trying to view does not exist."

I searched this ticket in mysql - no result.

I searched any information about deleting in logs (/var/atlassin/jira/logs/access_log) - no result.

Did re-index -no result

What else you can advise to me  ? 

JIRA version is (v6.2#6252) 

[Nic Brough -Adaptavist- · Accepted solution]

If you "searched this ticket in mysql", then there's two possibilities - either you didn't use the correct search, or it's been deleted.

What did you search for?

[xattab]

This is my select
 select SUMMARY,REPORTER from jiraissue where PROJECT=12702 AND ID >="156881" AND ID<= 156903;

I search between two ID's of issue. 
And yes, one user (who has admin rights) deleted this issue. Now my question is where i can find any logs about this operation ?  

[xattab]

And one more. If user  deleted issue from app JIRAConnectProEnterprise. What kind of logs i need search ?

I find this :

user [03/Nov/2016:13:13:17 +0100] "GET /rest/api/latest/issue/PAYM-9394/comment?expand=renderedBody HTTP/1.1" 200 52 172 "-" "JIRAConnectProEnterprise/190 CFNetwork/758.5.3 Darwin/15.6.$

user  [03/Nov/2016:13:13:18 +0100] "GET /rest/jiraconnect/1.0/screen/view/PAYM/15.json?locale=ru-UA HTTP/1.1" 200 1063 248 "-" "JIRAConnectProEnterprise/190 CFNetwork/758.5.3 Darwin/15.6$

user [03/Nov/2016:13:13:54 +0100] "GET /rest/api/latest/issue/PAYM-9394/transitions?expand=transitions.fields HTTP/1.1" 200 41 87 "-" "JIRAConnectProEnterprise/190 CFNetwork/758.5.3 Dar$

[Nic Brough -Adaptavist-]

The only log I know of that logs delete is the internal audit log.

If that was enabled at the time, there will be a line in there.  If not, then you are unlikely to be able to trace this via logs.

It's one of several reasons that the general recommendation is "do not allow delete issue"

[saravanan subramanian]

check the project roles - users - add your id there and check again