Ticket #894 (assigned Issue)

Opened 3 years ago

Last modified 3 years ago

why are there missing indices in the PG database?

Reported by: charlotte Owned by: charlotte
Priority: minor Milestone: V1.2 Questionnaire release
Component: WP6 - CMIP5 Questionnaire Version:
Keywords: Cc: gerry
Requirement:

Description

There are about 1500 unused primary key indices in the postgres database. Why?

Change History

comment:1 Changed 3 years ago by charlotte

is it possible that an offset gets introduced when we redeploy the questionnaire? Would like to get to the bottom of this before we implement submit to CMIP5.

I have requested before and after backups for each redeployment of the questionnaire.

Before After
10th Oct11th Oct
12th Oct13th Oct
21st Oct22nd Oct
9th Nov10th Nov

comment:2 Changed 3 years ago by charlotte

  • Status changed from new to assigned

The missing indices did not appear when the questionnaire was redeployed. Instead they appeared sometime between the 13th and 21st of October. The number of missing indices remains constant - no further gaps have appeared in the protoq_component table.

DatePrimary keyprotoq_component iddifference
10th Oct1-1401-1400
11th Oct1-1401-1400
12th Oct1-8401-8400
13th Oct1-8401-8400
21st Oct1-8401-8400
841-12612043-24631202
22nd Oct1-8401-8400
841-16112043-28131202
9th Nov1-8401-8400
841-31552043-43571202
10th Nov1-8401-8400
841-32252043-44271202

comment:3 Changed 3 years ago by charlotte

Hi Charlotte,

the backup on the 12th appears to match yours (i.e. goes up to 840 with no missing blocks). I think this is therefore not a case where data got deleted, rather something strange happened in the incrementing of the id.

Gerry

The 17th November backup has missing indices - Gerry's local backup made on the 13th has missing indices too.  I thought the DB was redeployed on the 12th.  

10th October : Deployed official release version 1.0
12th October : Implemented validation fixes.
21st October : migrated to Python 2.6
9th November: small changes for Mark E
10th November : small changes made for Mark E

How come the missing indices appear on the 13th

comment:4 Changed 3 years ago by charlotte

DatePrimary Keyprotoq_component id difference
14th Oct1-8401-8400
841-9802043-21821202

So the missing indices occur when model "JustATest" is created in the "2. Test" centre (number 39)

comment:5 Changed 3 years ago by charlotte

  • Keywords subCMIP5 removed
  • Type changed from Task to Issue

I don't think this needs fixing before we add the submit to cmip5 button

comment:6 Changed 3 years ago by charlotte

  • Priority changed from blocker to minor
Note: See TracTickets for help on using tickets.