mahara-contributors team mailing list archive

[Kristina Hoeppner <1906723@xxxxxxxxxxxxxxxxxx>]

** Changed in: mahara
    Milestone: 21.10.0 => None

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: mahara-contributors
https://bugs.launchpad.net/bugs/1906723

Title:
  Artefacts are created before the author is created according to their
  ctime

Status in Mahara:
  Invalid

Bug description:
  Some how it is possible for a usr.ctime value to be newer than an
  artefact.ctime value when the artefact.owner = usr.id

  To check this out do the following:

  SELECT a.id AS artefact_id, a.ctime AS artefact_ctime, u.ctime AS
  user_ctime, u.id AS user_id FROM artefact a JOIN usr u ON u.id =
  a.owner WHERE a.ctime < u.ctime ORDER BY a.ctime DESC;

  There doesn't seem to be any obvious reason for this, what I've checked so far on a big database:
  1. Is it only an old problem? No. The problem exists for old artefacts / users (made in 2008) and new artefacts / people (made in 2020) 
  2) Are the artefacts of only one type? No. The offending artefacts are of many different artefact types.
  3) Are the users all using the same auth method? No. The people have different auth methods, both internal and external.
  4) Are they in the same institution? No. They are in a variety of institutions
  5) Are the difference between artefact.ctime and usr.ctime small (race condition)? No. The gap noticed varies from 1sec to almost 1 decade (3561 days)

  So my conclusion is that there is something updating the usr.ctime
  field after a user has been created. That shouldn't be happening

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1906723/+subscriptions