search

dativebase / dativebaseclj

DativeBase in Clojure: Linguistic Data Management
https://app.dative.ca
MIT License
0 stars 0 forks source link

Confirm that the migration transfers the data correctly #25

Closed jrwdunham closed 2 months ago

jrwdunham commented 2 months ago

A/C:

jrwdunham commented 2 months ago

I wrote a script that does the following on a target OLD, across both the INT and DO instances.

  1. Authenticate.
  2. Fetch first page of forms.
  3. Fetch last page of forms.
  4. Fetch first page of files.
  5. Fetch last page of files.
  6. Fetch a page of 100 users.

It then tests whether all values are the same and asserts that there are fewer than 100 users in each OLD.

This worked for 25/125 OLDs before failing, not because OLDs were non-identical, but because the API broke due to some kind of overload related to the known and persistent MySQL DB connection "too many connections" bug.

Despite the bug getting in the way, I am confident from this test that the replication is working.