5998
45%
master: 45%

Ran 31 May 2019 03:51AM UTC

Jobs 5

Files 100

Run time 36min

Badge

Embed ▾

pending completion

Build # 5998

Build Type

push

travis-ci

Committed by

tomka

Commit Message

Make concept based table IDs 64 bit

While we still have some headroom for the datasets we work with at the
moment, keeping the IDs of concept table based tables (inheritance) at
32 bit would have been a limit at some point. Already we see large
segmentation datasets that make this headroom rather small. Therefore
this migration will rewrite all concept based tables as well as tables
that reference them through foreign keys so that 64 bit IDs are used.

This migration also updates the review table to use 64 bit IDs. It also
fixes the history views of the catmaid_sampler table, which haven't been
kept up to date with column changes.

In addition a lot of missing foreign key constraints have been added.
They shouldn't have a big import on performance and in fact no real
difference could be measured.

The column order of concept changed slightly to improve the column
alignment and reduce padding. So far we wasted 4 Bytes per row, because
project_id occupied 4 Bytes and required 4 Bytes of padding, because it
was followed by a bigint. This is changed now and no more padding is
needed. This should make this change to 64 bit IDs effectively free in
terms of needed storage.

Fixes catmaid/CATMAID#1848

Run Details

8153 of 18312 relevant lines covered (44.52%)

2.07 hits per line

Jobs

ID	Job ID	Ran	Coverage
1	5998.1	31 May 2019 03:51AM UTC	44.52	Travis Job 5998.1
2	5998.2	31 May 2019 03:52AM UTC	44.52	Travis Job 5998.2
3	5998.3	31 May 2019 03:55AM UTC	44.52	Travis Job 5998.3
4	5998.4	31 May 2019 04:27AM UTC	43.27	Travis Job 5998.4
5	5998.5	31 May 2019 04:27AM UTC	41.45	Travis Job 5998.5

Source Files on build 5998

Detailed source file information is not available for this build.

catmaid / CATMAID / 5998
45%
master: 45%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 5998

catmaid / CATMAID / 5998 45% master: 45%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 5998

catmaid / CATMAID / 5998
45%
master: 45%

README BADGES
x