pq: duplicate key value violates unique constraint

[kwk]

It is about my 3rd time or more that I ran into this kind of error with Jenkins:

--- FAIL: TestConvertGithubIssue (0.03s)
    assertions.go:241: 
                        
    Error Trace:    trackeritem_repository_test.go:302
        
    Error:        Expected nil, but got: failed to create work item: pq: duplicate key value violates unique constraint "work_item_number_sequences_pkey"

It is not always this test in particular but the message is almost always the same.

I have to trigger a build with a [test] comment and then the error disappears.

It is hard to reproduce what causes this test error.

[kwk]

New occurrence:

--- FAIL: TestConvertNewWorkItemWithUnknownIdentities (0.03s)
	assertions.go:241: 
                        
	Error Trace:	trackeritem_repository_test.go:147
		
	Error:		Expected nil, but got: failed to create work item: pq: duplicate key value violates unique constraint "work_item_number_sequences_pkey"

See here https://ci.centos.org/job/devtools-fabric8-wit/877/consoleFull

[aslakknutsen]

most likely there is yet another test that doesn't clean up the db after it self

[kwk]

most likely there is yet another test that doesn't clean up the db after it self

I hope to find that during a refactoring.

[xcoulon]

Closing this issue for now, since #1677 was merged (f150285).
Please reopen if the error occurs again.