1
94%
master: 94%

Ran 27 Mar 2020 04:32PM UTC

Files 565

Run time 1min

Badge

Committed 27 Mar 2020 04:15PM UTC coverage: 92.698% (+0.06%) from 92.643%

Job # bintrayUser=[secure] bintrayKey=[secure] sonatypeUsername=[secure] sonatypePassword=[secure] DOCKER_USER=[secure] DOCKER_PASSWORD=[secure] GRGIT_USER=[secure]

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

Source Files on job 2660.1 (bintrayUser=[secure] bintrayKey=[secure] sonatypeUsername=[secure] sonatypePassword=[secure] DOCKER_USER=[secure] DOCKER_PASSWORD=[secure] GRGIT_USER=[secure])

Netflix / genie / 2660 / 1
94%
master: 94%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 2660.1 (bintrayUser=[secure] bintrayKey=[secure] sonatypeUsername=[secure] sonatypePassword=[secure] DOCKER_USER=[secure] DOCKER_PASSWORD=[secure] GRGIT_USER=[secure])

Netflix / genie / 2660 / 1 94% master: 94%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 2660.1 (bintrayUser=[secure] bintrayKey=[secure] sonatypeUsername=[secure] sonatypePassword=[secure] DOCKER_USER=[secure] DOCKER_PASSWORD=[secure] GRGIT_USER=[secure])

Netflix / genie / 2660 / 1
94%
master: 94%

README BADGES
x