Recapping notes as @tim-eves was attempting to migrate our staging sites:
The current version of keyman-staging is running fine on the existing cluster, there has been no down time.
While migrating keyman-staging to the new cluster, we ran into this bug: microsoft/mssql-docker#881
The new cluster is running newer kernels that expose the bug in mssql.
versions 2022-CU13-ubuntu-22.04 and 2022-latest are reported to work, though you container is locked to an earlier commit of 2022-latest
We can try to revert #217 so they newer images get deployed to the staging images on the old and new clusters
Going to 2022-latest does run into a PDOException in
INSERT t_keyboard_language (
keyboard_id,
bcp47,
language_id,
region_id,
script_id,
description
) VALUES
(N'cantonese_telex',
N'yue-latn-001',
N'yue',
N'001',
N'latn',
N'Chinese, Yue');
Array
(
[0] => 42000
[1] => 2628
[2] => [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]String or binary data would be truncated in table 'keyboards.k0.t_keyboard_language', column 'region_id'. Truncated value: '00'.
[3] => 01000
[4] => 3621
[5] => [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]The statement has been terminated.
)
Failure: PDOException: SQLSTATE[42000]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]String or binary data would be truncated in table 'keyboards.k0.t_keyboard_language', column 'region_id'. Truncated value: '00'. in /var/www/html/tools/db/build/build.inc.php:153
Seems yue-latn-001 region is getting truncated to 00.
Recapping notes as @tim-eves was attempting to migrate our staging sites:
We can try to revert #217 so they newer images get deployed to the staging images on the old and new clusters
Going to 2022-latest does run into a PDOException in
Seems
yue-latn-001region is getting truncated to00.