How to link issue to epic in database?

[- -]

I need to link issues to epics in database.
I use IssueLinkType ("Epic-Story Link") with destination is epic.
But "Epic Link" is empty.

I linked issue to epic from web. but it did not create any issuelinks or customfieldvalues.

Ehat to do for link issue to epic?

[Nic Brough -Adaptavist-]

You do not do this in the database.  You must NEVER amend a JIRA database while it is running, and you need to be very careful even if you amend it when it is down - you must have a full understanding of the changes.

You must always use the API to change your data.  The API has several interface points - the web GUI front end, addons, the REST functions - they all talk to JIRA through the API.

So, let's look at "I linked issue to epic from web" - what exactly have you tried here?  And why don't you think it has worked?  (I'd expect you to have tried to use the "Epic link" field to do it - is that true?)

[- -]

Mistake is 'epic must be a source'.
and needed reindexing and jira restart.
damn. it is not logical =)

Rest is too slow for me. I migrate over 200`000 issues. Now i test it. 4000 per hour with database connection without transaction with flush after 1000 issues.
And i do not want to know how slow it will work with rest and every action in transaction. =)

(yes) 

[Nic Brough -Adaptavist-]

Argh. NEVER write to an active Jira database. It's not a case of "restart". It must be offline. I hope you have a good backup system. You may need it. Did you remember to update the sequence table too?

[- -]

Yes, i use NHibernate with hilo and sequences. it is easy and safe =) Issues created by rest for generating correct in-project-numbers. And every thing else directly in database.

[Nic Brough -Adaptavist-]

Er, and the sequence table for links?

[- -]

no, hilo with "IssueLink" seq_id.

[Nic Brough -Adaptavist-]

so you've missed a table and probably broken your system. Oops.

[- -]

In 6.3.12 all good. I think what your knowledge is outdated... Most of common jira entities use hilo on sequence_value_item table. And only AO_* tables (all or most) use seqences. There 213 tables, 100 keys in hilo table, 51 sequence (only for AO_*)

[- -]

other tables use composite or string pkey...

[Gregory Kneller]

Hi guys, I understand your conserns about database modifications, but I do it more than 5 years on running JIRA's, it is safe if you follow safety rules ))