Troubleshooting
Problem
PowerVC may report login errors
ERROR keystonemiddleware.auth_token [-] Bad response code while validating token: 500 Internal Server Error (HTTP 500): InternalServerError: Internal Server Error (HTTP 500)
This may trace to a mariadb error such as
-] (sqlite3.OperationalError) no such table: revocation_event [SQL: u'SELECT revocation_event.id AS revocation_event_id, revocation_event.domain_id AS revocation_event_domain_id, revocation_event.project_id AS revocation_event_project_id, revocation_event.user_id AS revocation_event_user_id, revocation_event.role_id AS revocation_event_role_id, revocation_event.trust_id AS revocation_event_trust_id, revocation_event.consumer_id AS revocation_event_consumer_id, revocation_event.access_token_id AS revocation_event_access_token_id, revocation_event.issued_before AS revocation_event_issued_before, revocation_event.expires_atrevocation_event.domain_id AS revocation_event_domain_id, revocation_event.project_id AS revocation_event_project_id, revocation_event.user_id AS revocation_event_user_id, revocation_event.role_id AS revocation_event_role_id, revocation_event.trust_id AS revocation_event_trust_id, revocation_event.consumer_id AS revocation_event_consumer_id, revocation_event.access_token_id AS revocation_event_access_token_id, revocation_event.issued_before AS revocation_event_issued_before, revocation_event.expires_at AS revocation_event_expires_at, revocation_event.revoked_at AS revocation_event_revoked_at, revocation_event.audit_id AS revocation_event_audit_id, revocation_event.audit_chain_id AS revocation_event_audit_chain_id \nFROM revocation_event \nWHERE revocation_event.issued_before >= ? AND (revocation_event.user_id IS NULL OR revocation_event.user_id = ?) AND (revocation_event.project_id IS NULL OR revocation_event.project_id = ?) AND (revocation_event.audit_id IS NULL OR revocation_event.audit_id = ?)'] [parameters: ] (Background on this error at: http://sqlalche.me/e/e3q8): DBNonExistentTable: (sqlite3.OperationalError) no such table: revocation_event [SQL: u'SELECT revocation_event.id AS revocation_event_id, revocation_event.domain_id AS revocation_event_domain_id, revocation_event.project_id AS revocation_event_project_id, revocation_event.user_id AS revocation_event_user_id, revocation_event.role_id AS revocation_event_role_id, revocation_event.trust_id AS revocation_event_trust_id, revocation_event.consumer_id AS revocation_event_consumer_id, revocation_event.access_token_id AS revocation_event_access_token_id, revocation_event.issued_before AS revocation_event_issued_before, revocation_event.expires_at AS revocation_event_expires_at, revocation_event.revoked_at AS
Symptom
No user can log in,
Cause
Mariadb only allows 8192 open files by default, if you have a VERY busy server , you may drive more need for more open files.
Environment
PowerVC 1.4.4 1.4.2 1.4.3
Diagnosing The Problem
Confirm you have sql errors in the keystone log as noted above.
Resolving The Problem
PowerVC sets up mariadb file limit in this file
/etc/systemd/system/mariadb.service.d/override_pvc.conf
change the value from 8192 to 65534
LimitNOFILE = 8192
change to
LimitNOFILE = 65534
Document Location
Worldwide
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGRZY","label":"IBM Cloud PowerVC Manager"},"ARM Category":[],"Platform":[{"code":"PF016","label":"Linux"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Was this topic helpful?
Document Information
More support for:
IBM Cloud PowerVC Manager
Software version:
All Versions
Operating system(s):
Linux
Document number:
6187251
Modified date:
14 April 2020
UID
ibm16187251