2660
94%

Ran 27 Mar 2020 04:32PM UTC

Jobs 1

Files 565

Run time 1min

Badge

Embed ▾

pending completion

Build # 2660

Build Type

push

travis-ci

Committed by

tgianos

Commit Message

Set transaction isolation level to read committed for updating unused command statuses

The update with default transaction isolation level (repeatable read) was causing the db to become unresponsive while the update was happening due to how mysql deals with update queries with scans and locking.
See:
https://dev.mysql.com/doc/refman/5.7/en/innodb-locks-set.html

By lowering the transaction isolation level for the update command to read committed it will only lock rows that match the update where condition and unlock those that don't.
See:
https://dev.mysql.com/doc/refman/5.7/en/innodb-transaction-isolation-levels.html

This will slightly lower the consistency but given how this query is intended to update things that haven't been used in a long time it shouldn't pose any large risk in practice while providing the benefit that the system stays performant while this update is happening in the background.

Run Details

13571 of 14640 relevant lines covered (92.7%)

0.93 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	2660.1 (bintrayUser=[secure] bintrayKey=[secure] sonatypeUsername=[secure] sonatypePassword=[secure] DOCKER_USER=[secure] DOCKER_PASSWORD=[secure] GRGIT_USER=[secure])	27 Mar 2020 04:32PM UTC	0	92.7	Travis Job 2660.1

Source Files on build 2660

Detailed source file information is not available for this build.

Netflix / genie / 2660
94%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 2660

Netflix / genie / 2660 94%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 2660

Netflix / genie / 2660
94%

README BADGES
x