subversion-plus - Table "MERGES" not found

[kgbvax]

When adding a repo, I see this WARNING in the log:

/secure/AddSubversionRepository.jspa [kintosoft.svnwebclient.indexing.SVNLogEntryHandlerImpl] Table "MERGES" not found; SQL statement:insert into MERGES (TO_REVISION,TO_ITEMID,FROM_REVISION, FROM_ITEMID, REPOID, SUBTRACTIVE) VALUES(?,?,?,?,?,?)

JIRA 6.0.8 and Subversion ALM 5.4.2

UPDATE: Message repeasts when plugin tries to access SVN. Plugin also never scans the repos.
The problem does not occur with 5.4.0.

[Pablo Beltran · Accepted solution]

Fixed in the 5.4.3 version

[Norman Abramovitz]

Fixed my issue as well!

[Pablo Beltran]

I was working on an experimental feature to support Subversion merging: sadly, I was doing this in the trunk :(, Then I rolled it back to the wrong revision number in order to fix a bug in the trunk. As result, some experimental code was released in the 5.4.1 version.

What does this code do? When a merge is detetected all the merged paths are stored into a new table (MERGES) in the database. This new table is created for new instances only (5.4.1) and not for existing datababase schemas. In your case, you was working with the 5.4.0 version, thus the schema database was already created. Hence, if you installed the 5.4.1 version at some time (?), the experimental code tries to insert the merged paths in the missing table and the indexing process fails and stops. Fortunatelly, this happened inside a database transaction. Next times the indexing process started and it tried to get next pending commits (with merge info), so it failed and stopped scanning in a loop. This is the reason becuase you saw the indexing process did not upgrade and the warning in the logs.

The 5.4.2 version, simply removes the experimental code, so the indexing process does not fecth the merge info and everything should work as usual and continue to scan the repositories since the latest cached revision.

Anything else had not much sense...

[Kinto Soft]

This is a bug introduced in the 5.4.1 version and fixed in the 5.4.2 version. Other customers have confirmed that the 5.4.2 version resolves this problem. So, my guess is that your add-on has not properly upgraded. Please try by:

1. re-starting the add-on.

2. re-installing the add-on

or

3. re-starting JIRA.

[kgbvax]

Thank you for your answer. This is quite strange as I installed subversion alm for the very first time, 5.4.1 was never on the system. I will double check with the reinstall as you suggested.

[Kinto Soft]

Opps, another customer has reported the same issue!! An he also claims never installed the 5.4.1 version. I'm going to look at the binaries of the 5.4.2 version on the Markeplace and I'll come back later...

[Tom Rager]

Hi,

we are facing the same problem and have installed the plugin for the first time just yesterday (5.4.2).