5299
70%
develop: 74%

Ran 22 Feb 2019 04:44PM UTC

Jobs 4

Files 398

Run time 9min

Badge

Embed ▾

pending completion

Build # 5299

Build Type

push

travis-ci

Committed by

sphuber

Commit Message

Fixing bug related to deleted nodes in recent log migration (#2507)

In a recent database migration, `0024_dblog_update` for Django and `041a79fc615f`
for SqlAlchemy, the `DbLog` table was updated where the `objpk` was replaced by
a proper foreign key to the `DbNode` row to which the log belongs. This required
the deletion of logs that did not correspond to node entities, which were typically
legacy workflows. The migration accounted for this by detecting these logs, exporting
them to a file for safekeeping, before deleting them. However, the scenario did
not consider that for the logs that remained, the corresponding node may have
been deleted. Since the relationship was not formalized through a foreign key this
would not have cascaded onto the related log entries. The migration would then
fail as a result when trying to the set the `dbnode_id` foreign key to the `ojbpk`
in the case that the node row no longer existed.

In this commit, the migrations are updated to detect orphaned log messages and
write them to a file before deleting them, just as is done for logs that belong
to legacy workflows or unknown entities.

Run Details

23773 of 34203 relevant lines covered (69.51%)

2.54 hits per line

Jobs

ID	Job ID	Ran	Coverage
5	5299.5 (TEST_AIIDA_BACKEND=django TEST_TYPE="tests")	22 Feb 2019 04:44PM UTC	63.61	Travis Job 5299.5
6	5299.6 (TEST_AIIDA_BACKEND=django TEST_TYPE="tests")	22 Feb 2019 04:46PM UTC	63.54	Travis Job 5299.6
7	5299.7 (TEST_AIIDA_BACKEND=sqlalchemy TEST_TYPE="tests")	22 Feb 2019 04:45PM UTC	63.37	Travis Job 5299.7
8	5299.8 (TEST_AIIDA_BACKEND=sqlalchemy TEST_TYPE="tests")	22 Feb 2019 04:53PM UTC	63.3	Travis Job 5299.8

Source Files on build 5299

Detailed source file information is not available for this build.

aiidateam / aiida_core / 5299
70%
develop: 74%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 5299

aiidateam / aiida_core / 5299 70% develop: 74%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 5299

aiidateam / aiida_core / 5299
70%
develop: 74%

README BADGES
x