gist plugin stopped working after gitbucket 4.2.1

[axb21]

The gist plugin v 4.0.0 worked with gitbucket 4.2.1 for me, in the sense that:

• I would see a "Snippets" link on the header
• Clicking the Snippets link, or viewing $URL/gist would take me to a list of my snippets

See screencap from gitbucket 4.2.1

If I upgrade either gist plugin to a newer version (4.2 or 4.3); or, if I upgrade gitbucket to a new version (4.3 onward), the Snippets link is gone and manually hitting $URL/gist produces a "Not Found" page. See screepcap from gitbucket 4.5

I do not see errors in my syslog. The Snippets simply are not there. Any idea what has happened?

[axb21]

In case it's helpful, I tried exporting data from gitbucket 4.5, and it correctly exports data about my gists. They are also located under $HOME/.gitbucket/gist/$USER, as they always have been. It seems something went awry with the communication between gitbucket and the plugin? And this may be at the gitbucket level?

[axb21]

Anyone have thoughts on this?

[takezoe]

@axb21 Could you check records in VERSION table?

[axb21]

Yes, this is what I see:

MODULE_ID	VERSION
asciidoctor	0.1
announce	1.1
gist	3.12
commitgraphs	3.12
emoji	4.3.0
gitbucket-core	4.5.0

It looks like that gist 3.12 is not right. I have been upgrading that plugin with each upgrade of gitbucket, so I'm not sure why it says 3.12. The current jar I ahve in $HOME/.gitbucket/plugins is gitbucket-gist-plugin_2.11-4.3.0.jar

[axb21]

@takezoe if it is helpful, I have two gitbucket installs, and both of them have this issue. The second one I do not upgrade often and gitbucket-core is 4.2.1 on that one. Yet the gist plugin is also 3.12 when I query the versions tables. I run both gitbucket installs in standalone mode, and have upgraded both in the following way:

• shutdown gitbucket
• download new war file
• download new gist (and other) plugin file(s)
• remove old plugin files
• place new plugin files in $HOME/.gitbucket/plugins
• start up gitbucket with the new war (basically java -jar it)

[takezoe]

@axb21 It seems to had failed to migrate from 3.12. Recent versions of GitBucket checks the database version and the plugin version strictly.

Could you attach a screenshot of schema of H2 console which shows schema of GIST table? I would be able to show how to repair your tables by looking that.

[axb21]

@takezoe ok, here is the GIST table schema from H2:

FIELD	TYPE	NULL	KEY	DEFAULT
USER_NAME	VARCHAR(100)	NO	PRI	NULL
REPOSITORY_NAME	VARCHAR(100)	NO	PRI	NULL
PRIVATE	BOOLEAN(1)	NO		NULL
TITLE	VARCHAR(100)	NO		NULL
DESCRIPTION	CLOB(2147483647)	YES		NULL
REGISTERED_DATE	TIMESTAMP(23)	NO		NULL
UPDATED_DATE	TIMESTAMP(23)	NO		NULL
ORIGIN_USER_NAME	VARCHAR(100)	YES		NULL
ORIGIN_REPOSITORY_NAME	VARCHAR(100)	YES		NULL

[takezoe]

@axb21 OK. Execute following SQL and restart GitBucket.

UPDATE VERSIONS SET VERSION='2.0.0' WHERE MODULE_ID='gist';

Gist plugin will be migrated to 4.2.1 and it should work.

[axb21]

That appears to have worked on both my instances. The Snippets link is back, and when I click it I see my snippets and can interact with them as usual.

Thank you!