Transcription issue

[ConnorBechler]

I tried to transcribe a single short English recording using the english_mfa acoustic model, english_mfa_lm, and english_mfa_dictionary. The following error occurred:

Traceback (most recent call last):
File "C:\Users\bechl\miniconda3\envs\anchor\Lib\site-packages\sqlalchemy\engine\base.py", line 1963, in _exec_single_context
self.dialect.do_execute(
File "C:\Users\bechl\miniconda3\envs\anchor\Lib\site-packages\sqlalchemy\engine\default.py", line 943, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.ForeignKeyViolation: insert or update on table "word" violates foreign key constraint "word_dictionary_id_fkey"
DETAIL: Key (dictionary_id)=(1) is not present in table "dictionary".

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "C:\Users\bechl\miniconda3\envs\anchor\Lib\site-packages\anchor\workers.py", line 4448, in run
transcriber.transcribe()
File "C:\Users\bechl\miniconda3\envs\anchor\Lib\site-packages\montreal_forced_aligner\transcription\transcriber.py", line 674, in transcribe
self.transcribe_utterances()
File "C:\Users\bechl\miniconda3\envs\anchor\Lib\site-packages\montreal_forced_aligner\transcription\transcriber.py", line 709, in transcribe_utterances
self.collect_alignments()
File "C:\Users\bechl\miniconda3\envs\anchor\Lib\site-packages\montreal_forced_aligner\alignment\base.py", line 1012, in collect_alignments
session.execute(sqlalchemy.insert(Word).values(new_words))
File "C:\Users\bechl\miniconda3\envs\anchor\Lib\site-packages\sqlalchemy\orm\session.py", line 2365, in execute
return self._execute_internal(
^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\bechl\miniconda3\envs\anchor\Lib\site-packages\sqlalchemy\orm\session.py", line 2251, in _execute_internal
result: Result[Any] = compile_state_cls.orm_execute_statement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\bechl\miniconda3\envs\anchor\Lib\site-packages\sqlalchemy\orm\bulk_persistence.py", line 1294, in orm_execute_statement
result = conn.execute(
^^^^^^^^^^^^^
File "C:\Users\bechl\miniconda3\envs\anchor\Lib\site-packages\sqlalchemy\engine\base.py", line 1415, in execute
return meth(
^^^^^
File "C:\Users\bechl\miniconda3\envs\anchor\Lib\site-packages\sqlalchemy\sql\elements.py", line 523, in _execute_on_connection
return connection._execute_clauseelement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\bechl\miniconda3\envs\anchor\Lib\site-packages\sqlalchemy\engine\base.py", line 1637, in _execute_clauseelement
ret = self._execute_context(
^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\bechl\miniconda3\envs\anchor\Lib\site-packages\sqlalchemy\engine\base.py", line 1842, in _execute_context
return self._exec_single_context(
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\bechl\miniconda3\envs\anchor\Lib\site-packages\sqlalchemy\engine\base.py", line 1982, in _exec_single_context
self._handle_dbapi_exception(
File "C:\Users\bechl\miniconda3\envs\anchor\Lib\site-packages\sqlalchemy\engine\base.py", line 2351, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "C:\Users\bechl\miniconda3\envs\anchor\Lib\site-packages\sqlalchemy\engine\base.py", line 1963, in _exec_single_context
self.dialect.do_execute(
File "C:\Users\bechl\miniconda3\envs\anchor\Lib\site-packages\sqlalchemy\engine\default.py", line 943, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.IntegrityError: (psycopg2.errors.ForeignKeyViolation) insert or update on table "word" violates foreign key constraint "word_dictionary_id_fkey"
DETAIL: Key (dictionary_id)=(1) is not present in table "dictionary".

[SQL: INSERT INTO word (id, mapping_id, word, count, word_type, included, dictionary_id) VALUES (%(id_m0)s, %(mapping_id_m0)s, %(word_m0)s, %(count)s, %(word_type_m0)s, %(included)s, %(dictionary_id_m0)s), (%(id_m1)s, %(mapping_id_m1)s, %(word_m1)s, %(count_m1)s, %(word_type_m1)s, %(included_m1)s, %(dictionary_id_m1)s), (%(id_m2)s, %(mapping_id_m2)s, %(word_m2)s, %(count_m2)s, %(word_type_m2)s, %(included_m2)s, %(dictionary_id_m2)s), (%(id_m3)s, %(mapping_id_m3)s, %(word_m3)s, %(count_m3)s, %(word_type_m3)s, %(included_m3)s, %(dictionary_id_m3)s), (%(id_m4)s, %(mapping_id_m4)s, %(word_m4)s, %(count_m4)s, %(word_type_m4)s, %(included_m4)s, %(dictionary_id_m4)s), (%(id_m5)s, %(mapping_id_m5)s, %(word_m5)s, %(count_m5)s, %(word_type_m5)s, %(included_m5)s, %(dictionary_id_m5)s), (%(id_m6)s, %(mapping_id_m6)s, %(word_m6)s, %(count_m6)s, %(word_type_m6)s, %(included_m6)s, %(dictionary_id_m6)s), (%(id_m7)s, %(mapping_id_m7)s, %(word_m7)s, %(count_m7)s, %(word_type_m7)s, %(included_m7)s, %(dictionary_id_m7)s), (%(id_m8)s, %(mapping_id_m8)s, %(word_m8)s, %(count_m8)s, %(word_type_m8)s, %(included_m8)s, %(dictionary_id_m8)s), (%(id_m9)s, %(mapping_id_m9)s, %(word_m9)s, %(count_m9)s, %(word_type_m9)s, %(included_m9)s, %(dictionary_id_m9)s), (%(id_m10)s, %(mapping_id_m10)s, %(word_m10)s, %(count_m10)s, %(word_type_m10)s, %(included_m10)s, %(dictionary_id_m10)s), (%(id_m11)s, %(mapping_id_m11)s, %(word_m11)s, %(count_m11)s, %(word_type_m11)s, %(included_m11)s, %(dictionary_id_m11)s), (%(id_m12)s, %(mapping_id_m12)s, %(word_m12)s, %(count_m12)s, %(word_type_m12)s, %(included_m12)s, %(dictionary_id_m12)s), (%(id_m13)s, %(mapping_id_m13)s, %(word_m13)s, %(count_m13)s, %(word_type_m13)s, %(included_m13)s, %(dictionary_id_m13)s), (%(id_m14)s, %(mapping_id_m14)s, %(word_m14)s, %(count_m14)s, %(word_type_m14)s, %(included_m14)s, %(dictionary_id_m14)s), (%(id_m15)s, %(mapping_id_m15)s, %(word_m15)s, %(count_m15)s, %(word_type_m15)s, %(included_m15)s, %(dictionary_id_m15)s), (%(id_m16)s, %(mapping_id_m16)s, %(word_m16)s, %(count_m16)s, %(word_type_m16)s, %(included_m16)s, %(dictionary_id_m16)s), (%(id_m17)s, %(mapping_id_m17)s, %(word_m17)s, %(count_m17)s, %(word_type_m17)s, %(included_m17)s, %(dictionary_id_m17)s), (%(id_m18)s, %(mapping_id_m18)s, %(word_m18)s, %(count_m18)s, %(word_type_m18)s, %(included_m18)s, %(dictionary_id_m18)s), (%(id_m19)s, %(mapping_id_m19)s, %(word_m19)s, %(count_m19)s, %(word_type_m19)s, %(included_m19)s, %(dictionary_id_m19)s), (%(id_m20)s, %(mapping_id_m20)s, %(word_m20)s, %(count_m20)s, %(word_type_m20)s, %(included_m20)s, %(dictionary_id_m20)s), (%(id_m21)s, %(mapping_id_m21)s, %(word_m21)s, %(count_m21)s, %(word_type_m21)s, %(included_m21)s, %(dictionary_id_m21)s), (%(id_m22)s, %(mapping_id_m22)s, %(word_m22)s, %(count_m22)s, %(word_type_m22)s, %(included_m22)s, %(dictionary_id_m22)s), (%(id_m23)s, %(mapping_id_m23)s, %(word_m23)s, %(count_m23)s, %(word_type_m23)s, %(included_m23)s, %(dictionary_id_m23)s), (%(id_m24)s, %(mapping_id_m24)s, %(word_m24)s, %(count_m24)s, %(word_type_m24)s, %(included_m24)s, %(dictionary_id_m24)s), (%(id_m25)s, %(mapping_id_m25)s, %(word_m25)s, %(count_m25)s, %(word_type_m25)s, %(included_m25)s, %(dictionary_id_m25)s), (%(id_m26)s, %(mapping_id_m26)s, %(word_m26)s, %(count_m26)s, %(word_type_m26)s, %(included_m26)s, %(dictionary_id_m26)s), (%(id_m27)s, %(mapping_id_m27)s, %(word_m27)s, %(count_m27)s, %(word_type_m27)s, %(included_m27)s, %(dictionary_id_m27)s), (%(id_m28)s, %(mapping_id_m28)s, %(word_m28)s, %(count_m28)s, %(word_type_m28)s, %(included_m28)s, %(dictionary_id_m28)s), (%(id_m29)s, %(mapping_id_m29)s, %(word_m29)s, %(count_m29)s, %(word_type_m29)s, %(included_m29)s, %(dictionary_id_m29)s), (%(id_m30)s, %(mapping_id_m30)s, %(word_m30)s, %(count_m30)s, %(word_type_m30)s, %(included_m30)s, %(dictionary_id_m30)s), (%(id_m31)s, %(mapping_id_m31)s, %(word_m31)s, %(count_m31)s, %(word_type_m31)s, %(included_m31)s, %(dictionary_id_m31)s), (%(id_m32)s, %(mapping_id_m32)s, %(word_m32)s, %(count_m32)s, %(word_type_m32)s, %(included_m32)s, %(dictionary_id_m32)s), (%(id_m33)s, %(mapping_id_m33)s, %(word_m33)s, %(count_m33)s, %(word_type_m33)s, %(included_m33)s, %(dictionary_id_m33)s), (%(id_m34)s, %(mapping_id_m34)s, %(word_m34)s, %(count_m34)s, %(word_type_m34)s, %(included_m34)s, %(dictionary_id_m34)s), (%(id_m35)s, %(mapping_id_m35)s, %(word_m35)s, %(count_m35)s, %(word_type_m35)s, %(included_m35)s, %(dictionary_id_m35)s), (%(id_m36)s, %(mapping_id_m36)s, %(word_m36)s, %(count_m36)s, %(word_type_m36)s, %(included_m36)s, %(dictionary_id_m36)s), (%(id_m37)s, %(mapping_id_m37)s, %(word_m37)s, %(count_m37)s, %(word_type_m37)s, %(included_m37)s, %(dictionary_id_m37)s), (%(id_m38)s, %(mapping_id_m38)s, %(word_m38)s, %(count_m38)s, %(word_type_m38)s, %(included_m38)s, %(dictionary_id_m38)s), (%(id_m39)s, %(mapping_id_m39)s, %(word_m39)s, %(count_m39)s, %(word_type_m39)s, %(included_m39)s, %(dictionary_id_m39)s), (%(id_m40)s, %(mapping_id_m40)s, %(word_m40)s, %(count_m40)s, %(word_type_m40)s, %(included_m40)s, %(dictionary_id_m40)s), (%(id_m41)s, %(mapping_id_m41)s, %(word_m41)s, %(count_m41)s, %(word_type_m41)s, %(included_m41)s, %(dictionary_id_m41)s), (%(id_m42)s, %(mapping_id_m42)s, %(word_m42)s, %(count_m42)s, %(word_type_m42)s, %(included_m42)s, %(dictionary_id_m42)s), (%(id_m43)s, %(mapping_id_m43)s, %(word_m43)s, %(count_m43)s, %(word_type_m43)s, %(included_m43)s, %(dictionary_id_m43)s), (%(id_m44)s, %(mapping_id_m44)s, %(word_m44)s, %(count_m44)s, %(word_type_m44)s, %(included_m44)s, %(dictionary_id_m44)s), (%(id_m45)s, %(mapping_id_m45)s, %(word_m45)s, %(count_m45)s, %(word_type_m45)s, %(included_m45)s, %(dictionary_id_m45)s), (%(id_m46)s, %(mapping_id_m46)s, %(word_m46)s, %(count_m46)s, %(word_type_m46)s, %(included_m46)s, %(dictionary_id_m46)s), (%(id_m47)s, %(mapping_id_m47)s, %(word_m47)s, %(count_m47)s, %(word_type_m47)s, %(included_m47)s, %(dictionary_id_m47)s), (%(id_m48)s, %(mapping_id_m48)s, %(word_m48)s, %(count_m48)s, %(word_type_m48)s, %(included_m48)s, %(dictionary_id_m48)s), (%(id_m49)s, %(mapping_id_m49)s, %(word_m49)s, %(count_m49)s, %(word_type_m49)s, %(included_m49)s, %(dictionary_id_m49)s), (%(id_m50)s, %(mapping_id_m50)s, %(word_m50)s, %(count_m50)s, %(word_type_m50)s, %(included_m50)s, %(dictionary_id_m50)s), (%(id_m51)s, %(mapping_id_m51)s, %(word_m51)s, %(count_m51)s, %(word_type_m51)s, %(included_m51)s, %(dictionary_id_m51)s), (%(id_m52)s, %(mapping_id_m52)s, %(word_m52)s, %(count_m52)s, %(word_type_m52)s, %(included_m52)s, %(dictionary_id_m52)s), (%(id_m53)s, %(mapping_id_m53)s, %(word_m53)s, %(count_m53)s, %(word_type_m53)s, %(included_m53)s, %(dictionary_id_m53)s), (%(id_m54)s, %(mapping_id_m54)s, %(word_m54)s, %(count_m54)s, %(word_type_m54)s, %(included_m54)s, %(dictionary_id_m54)s), (%(id_m55)s, %(mapping_id_m55)s, %(word_m55)s, %(count_m55)s, %(word_type_m55)s, %(included_m55)s, %(dictionary_id_m55)s), (%(id_m56)s, %(mapping_id_m56)s, %(word_m56)s, %(count_m56)s, %(word_type_m56)s, %(included_m56)s, %(dictionary_id_m56)s), (%(id_m57)s, %(mapping_id_m57)s, %(word_m57)s, %(count_m57)s, %(word_type_m57)s, %(included_m57)s, %(dictionary_id_m57)s), (%(id_m58)s, %(mapping_id_m58)s, %(word_m58)s, %(count_m58)s, %(word_type_m58)s, %(included_m58)s, %(dictionary_id_m58)s), (%(id_m59)s, %(mapping_id_m59)s, %(word_m59)s, %(count_m59)s, %(word_type_m59)s, %(included_m59)s, %(dictionary_id_m59)s), (%(id_m60)s, %(mapping_id_m60)s, %(word_m60)s, %(count_m60)s, %(word_type_m60)s, %(included_m60)s, %(dictionary_id_m60)s), (%(id_m61)s, %(mapping_id_m61)s, %(word_m61)s, %(count_m61)s, %(word_type_m61)s, %(included_m61)s, %(dictionary_id_m61)s), (%(id_m62)s, %(mapping_id_m62)s, %(word_m62)s, %(count_m62)s, %(word_type_m62)s, %(included_m62)s, %(dictionary_id_m62)s), (%(id_m63)s, %(mapping_id_m63)s, %(word_m63)s, %(count_m63)s, %(word_type_m63)s, %(included_m63)s, %(dictionary_id_m63)s), (%(id_m64)s, %(mapping_id_m64)s, %(word_m64)s, %(count_m64)s, %(word_type_m64)s, %(included_m64)s, %(dictionary_id_m64)s), (%(id_m65)s, %(mapping_id_m65)s, %(word_m65)s, %(count_m65)s, %(word_type_m65)s, %(included_m65)s, %(dictionary_id_m65)s), (%(id_m66)s, %(mapping_id_m66)s, %(word_m66)s, %(count_m66)s, %(word_type_m66)s, %(included_m66)s, %(dictionary_id_m66)s), (%(id_m67)s, %(mapping_id_m67)s, %(word_m67)s, %(count_m67)s, %(word_type_m67)s, %(included_m67)s, %(dictionary_id_m67)s), (%(id_m68)s, %(mapping_id_m68)s, %(word_m68)s, %(count_m68)s, %(word_type_m68)s, %(included_m68)s, %(dictionary_id_m68)s), (%(id_m69)s, %(mapping_id_m69)s, %(word_m69)s, %(count_m69)s, %(word_type_m69)s, %(included_m69)s, %(dictionary_id_m69)s), (%(id_m70)s, %(mapping_id_m70)s, %(word_m70)s, %(count_m70)s, %(word_type_m70)s, %(included_m70)s, %(dictionary_id_m70)s), (%(id_m71)s, %(mapping_id_m71)s, %(word_m71)s, %(count_m71)s, %(word_type_m71)s, %(included_m71)s, %(dictionary_id_m71)s), (%(id_m72)s, %(mapping_id_m72)s, %(word_m72)s, %(count_m72)s, %(word_type_m72)s, %(included_m72)s, %(dictionary_id_m72)s), (%(id_m73)s, %(mapping_id_m73)s, %(word_m73)s, %(count_m73)s, %(word_type_m73)s, %(included_m73)s, %(dictionary_id_m73)s), (%(id_m74)s, %(mapping_id_m74)s, %(word_m74)s, %(count_m74)s, %(word_type_m74)s, %(included_m74)s, %(dictionary_id_m74)s), (%(id_m75)s, %(mapping_id_m75)s, %(word_m75)s, %(count_m75)s, %(word_type_m75)s, %(included_m75)s, %(dictionary_id_m75)s), (%(id_m76)s, %(mapping_id_m76)s, %(word_m76)s, %(count_m76)s, %(word_type_m76)s, %(included_m76)s, %(dictionary_id_m76)s), (%(id_m77)s, %(mapping_id_m77)s, %(word_m77)s, %(count_m77)s, %(word_type_m77)s, %(included_m77)s, %(dictionary_id_m77)s)]
[parameters: {'id_m0': 42361, 'mapping_id_m0': 105, 'word_m0': 'when', 'count': 0, 'word_type_m0': 'oov', 'included': True, 'dictionary_id_m0': 1, 'id_m1': 42362, 'mapping_id_m1': 106, 'word_m1': 'we', 'count_m1': 0, 'word_type_m1': 'oov', 'included_m1': True, 'dictionary_id_m1': 1, 'id_m2': 42363, 'mapping_id_m2': 107, 'word_m2': 'speak', 'count_m2': 0, 'word_type_m2': 'oov', 'included_m2': True, 'dictionary_id_m2': 1, 'id_m3': 42364, 'mapping_id_m3': 108, 'word_m3': 'of', 'count_m3': 0, 'word_type_m3': 'oov', 'included_m3': True, 'dictionary_id_m3': 1, 'id_m4': 42365, 'mapping_id_m4': 109, 'word_m4': 'them', 'count_m4': 0, 'word_type_m4': 'oov', 'included_m4': True, 'dictionary_id_m4': 1, 'id_m5': 42366, 'mapping_id_m5': 110, 'word_m5': 'and', 'count_m5': 0, 'word_type_m5': 'oov', 'included_m5': True, 'dictionary_id_m5': 1, 'id_m6': 42367, 'mapping_id_m6': 111, 'word_m6': 'i', 'count_m6': 0, 'word_type_m6': 'oov', 'included_m6': True, 'dictionary_id_m6': 1, 'id_m7': 42368 ... 446 parameters truncated ... 'dictionary_id_m70': 1, 'id_m71': 42432, 'mapping_id_m71': 176, 'word_m71': 'am', 'count_m71': 0, 'word_type_m71': 'oov', 'included_m71': True, 'dictionary_id_m71': 1, 'id_m72': 42433, 'mapping_id_m72': 177, 'word_m72': 'doing', 'count_m72': 0, 'word_type_m72': 'oov', 'included_m72': True, 'dictionary_id_m72': 1, 'id_m73': 42434, 'mapping_id_m73': 178, 'word_m73': 'nina', 'count_m73': 0, 'word_type_m73': 'oov', 'included_m73': True, 'dictionary_id_m73': 1, 'id_m74': 42435, 'mapping_id_m74': 179, 'word_m74': 'bound', 'count_m74': 0, 'word_type_m74': 'oov', 'included_m74': True, 'dictionary_id_m74': 1, 'id_m75': 42436, 'mapping_id_m75': 180, 'word_m75': 'red', 'count_m75': 0, 'word_type_m75': 'oov', 'included_m75': True, 'dictionary_id_m75': 1, 'id_m76': 42437, 'mapping_id_m76': 181, 'word_m76': 'machine', 'count_m76': 0, 'word_type_m76': 'oov', 'included_m76': True, 'dictionary_id_m76': 1, 'id_m77': 42438, 'mapping_id_m77': 182, 'word_m77': 'at', 'count_m77': 0, 'word_type_m77': 'oov', 'included_m77': True, 'dictionary_id_m77': 1}]
(Background on this error at: https://sqlalche.me/e/20/gkpj)

Apologies for the trouble, and thanks much for your work on this! MFA is an incredible tool, and an intuitive and functioning GUI for it is an incredible addition!