Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Login fails with PG::ProgramLimitExceeded #52

Open
fujexo opened this issue Mar 15, 2021 · 1 comment
Open

Login fails with PG::ProgramLimitExceeded #52

fujexo opened this issue Mar 15, 2021 · 1 comment

Comments

@fujexo
Copy link

fujexo commented Mar 15, 2021

Completed 500 Internal Server Error in 1448ms (ActiveRecord: 12.7ms)

ActiveRecord::StatementInvalid (PG::ProgramLimitExceeded: ERROR:  index row size 2752 exceeds maximum 2712 for index "index_oic_sessions_on_access_token"
HINT:  Values larger than 1/3 of a buffer page cannot be indexed.
Consider a function index of an MD5 hash of the value, or use full text indexing.
: UPDATE "oic_sessions" SET "access_token" = $1, "refresh_token" = $2, "expires_at" = $3, "updated_at" = $4 WHERE "oic_sessions"."id" = $5):

plugins/redmine_openid_connect/app/models/oic_session.rb:82:in `get_access_token!'
plugins/redmine_openid_connect/lib/redmine_openid_connect/account_controller_patch.rb:82:in `oic_local_login'
lib/redmine/sudo_mode.rb:65:in `sudo_mode'

Any ideas how to fix this?

@winged
Copy link

winged commented Mar 15, 2021

I think the indexes on access_token, refresh_token and id_token are not needed, as all the lookups on oic_sessions seem to go via primary key.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants