Problem/Motivation

#2733675: Warning when mysql is not set to READ-COMMITTED added a warning when the isolation level is not READ-COMMITTED. The link is not accessible as the text is meaningless and the information appears and disappears. This information should always be present but the severity should change.

Proposed resolution

Update mysql_requirements() to always add the transaction isolation level and change the severity depending on the level.

Remaining tasks

User interface changes

API changes

Data model changes

Release notes snippet

Comments

alexpott created an issue. See original summary.

alexpott’s picture

Status: Active » Needs review
StatusFileSize
new4.54 KB
alexpott’s picture

Title: Change database transaction isolation level to a REQUIREMENT_OK when it is REPEATABLE-READ » Improve the MySQL transaction isolation warning
Issue summary: View changes
StatusFileSize
new3.36 KB
new3.88 KB

@catch wants to keep the warning. I think we still need to make some improvements.

The link is not accessible since the link text makes no sense and we should always display the requirement even if it is set to READ COMMITTED. Having this information here means people have a chance of learning about why it is important and the fact it is different in different environments.

I wonder if we should mention that REPEATABLE READ is supported. Not sure.

daffie’s picture

Status: Needs review » Reviewed & tested by the community

When the isolation level is set to "READ COMMITTED" a message that everything is OK.
Testing has been added for the message.
For me it is RTBC.

  • catch committed 45663e4 on 10.0.x
    Issue #3291949 by alexpott, daffie: Improve the MySQL transaction...
  • catch committed 90f0da7 on 10.1.x
    Issue #3291949 by alexpott, daffie: Improve the MySQL transaction...
  • catch committed 0e72178 on 9.5.x
    Issue #3291949 by alexpott, daffie: Improve the MySQL transaction...
catch’s picture

Status: Reviewed & tested by the community » Fixed

Committed/pushed to 10.1.x and cherry-picked back through to 9.5.x, thanks!

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.