Project

General

Profile

Actions
Copy link

tickets #159471

closed

redmine queries with "tags" yield 500 error

Added by okurz 23 days ago. Updated about 22 hours ago.

Status:
Resolved
Priority:
Normal
Assignee:
crameleon
Category:
Redmine
Target version:
-
Start date:
2024-04-23
Due date:
% Done:

0%

Estimated time:

Description

Steps to reproduce

Actions
Copy link
 #1

Updated by okurz 23 days ago

  • Private changed from Yes to No
Actions
Copy link
 #2

Updated by szarate 23 days ago

I suggest to contact the developer of the plugin.

Actions
Copy link
 #3

Updated by crameleon 23 days ago

  • Status changed from New to Workable
  • Assignee set to crameleon

Hi,

thanks for reporting. The following error is logged:

ERROR -- : [d6e88531-ecd1-4dfc-889f-530a70caea2d] Query::StatementInvalid: Mysql2::Error: Unknown column 'issues.issue_tags' in 'where clause'

This is the same issue I already faced in the past and had been in contact with RedmineUP about. I thought it was resolved after I installed a patched version of the plugin which they provided for us, but it seems it still occurs on some queries.

Part of the issue is that RedmineUP internally changes their "redmine_crm" library - so the official release of the new "Tags" plugin has a dependency conflict on the official release of the "Checklists" plugin. Naturally, I want to keep both plugins enabled.
They requested us to test three more patched versions of the "Checklists" plugin, but I have not gotten to it -unfortunately there is currently no test instance, and I don't want to gamble with plugins causing database migrations on the production.

Will have to see if there's a better interim solution.

Best,
Georg

Actions
Copy link
 #4

Updated by crameleon 23 days ago

Actions
Copy link
 #5

Updated by crameleon 23 days ago

For reference, previous work on this issue was commented on here:
https://progress.opensuse.org/issues/133532#note-63

Actions
Copy link
 #6

Updated by okurz 22 days ago

ok, good. I can see that now https://progress.opensuse.org/issues?query_id=757 works fine again

Actions
Copy link
 #7

Updated by crameleon 20 days ago

  • Priority changed from High to Normal

I can't explain that, but good to hear.

Actions
Copy link
 #8

Updated by okurz 2 days ago

Same problem happened again. I have seen an outage of progress.opensuse.org yesterday evening. I assume that was due to an update being conducted. So likely related?

Actions
Copy link
 #9

Updated by crameleon about 22 hours ago

I don't know why it happens, and I think the issue is something other than the missing column. I inspected the database today, and compared it against backup dumps from the last few days, and no issue_tags column is anywhere to be found.

Actions
Copy link
 #10

Updated by crameleon about 22 hours ago

Interesting!

After

/usr/bin/bundle.ruby2.7 exec /usr/bin/rake.ruby2.7 -t redmine:plugins NAME=redmineup_tags RAILS_ENV=production

and then restarting the Gunicorn server, your link works again, without the obscure column error message in the logs!

Actions
Copy link
 #11

Updated by crameleon about 22 hours ago

  • Status changed from Workable to In Progress
Actions
Copy link
 #12

Updated by crameleon about 22 hours ago

Actions
Copy link
 #13

Updated by crameleon about 22 hours ago

  • Status changed from In Progress to Resolved

I don't know which of the additional migrations the needed one is, but since it seems harmless to always just run all and it happening relatively fast as well, I declare this as the solution:

https://build.opensuse.org/package/rdiff/openSUSE:infrastructure:redmine/redmine?linkrev=base&rev=36

If it happens again contrary to my expectations, do let me know.

Actions
Copy link

Also available in: Atom PDF