Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.6.18
-
None
-
None
-
Ubuntu 22.04.4 LTS
Description
When the database contains tables with non-ascii characters such as "Friedhöfe" ('Friedh\xF6fe'), the script debian-start throws errors during the table checks:
|
|
ERROR 1300 (HY000) at line 1: Invalid utf8mb3 character string: 'Politische Beschl\xFCsse'
|
ERROR 1300 (HY000) at line 1: Invalid utf8mb3 character string: 'Sehensw\xFCrdigkeiten'
|
ERROR 1300 (HY000) at line 1: Invalid utf8mb3 character string: 'Haltestellen \xD6PNV'
|
ERROR 1300 (HY000) at line 1: Invalid utf8mb3 character string: 'Krankenh\xE4user'
|
ERROR 1300 (HY000) at line 1: Invalid utf8mb3 character string: 'Namensb\xE4ume in Darmstadt'
|
ERROR 1300 (HY000) at line 1: Invalid utf8mb3 character string: 'St\xE4dtische Dienststellen'
|
ERROR 1300 (HY000) at line 1: Invalid utf8mb3 character string: 'Behindertenparkpl\xE4tze'
|
ERROR 1300 (HY000) at line 1: Invalid utf8mb3 character string: 'Beh\xF6rden'
|
ERROR 1300 (HY000) at line 1: Invalid utf8mb3 character string: 'Bebauungspl\xE4ne'
|
ERROR 1300 (HY000) at line 1: Invalid utf8mb3 character string: 'Parkh\xE4user Innenstadt'
|
ERROR 1300 (HY000) at line 1: Invalid utf8mb3 character string: 'Spielpl\xE4tze'
|
ERROR 1300 (HY000) at line 1: Invalid utf8mb3 character string: 'Tagungsst\xE4tten'
|
ERROR 1300 (HY000) at line 1: Invalid utf8mb3 character string: 'Friedh\xF6fe'
|
ERROR 1300 (HY000) at line 1: Invalid utf8mb3 character string: 'Parks und Gr\xFCnanlagen'
|
ERROR 1300 (HY000) at line 1: Invalid utf8mb3 character string: 'Sportst\xE4tten'
|
ERROR 1300 (HY000) at line 1: Invalid utf8mb3 character string: '\xD6ffentliche Toiletten'
|
|
|
Improperly closed tables are also reported if clients are accessing
|
the tables *now*. A list of current connections is below.
|
|
|
+----+------+-----------+----+---------+------+----------+------------------+----------+
|
| Id | User | Host | db | Command | Time | State | Info | Progress |
|
+----+------+-----------+----+---------+------+----------+------------------+----------+
|
| 69 | root | localhost | | Query | 0 | starting | show processlist | 0.000 |
|
+----+------+-----------+----+---------+------+----------+------------------+----------+
|
Uptime: 1 Threads: 1 Questions: 135 Slow queries: 0 Opens: 55 Open tables: 48 Queries per second avg: 135.000
|
|
The errors are produced by these lines in /usr/share/mysql/debian-start.inc.sh:
set +e |
|
|
LC_ALL=C $MYSQL --skip-column-names --batch -e '
|
select concat('\''select count(*) into @discard from `'\'', |
TABLE_SCHEMA, '\''`.`'\'', TABLE_NAME, '\''`'\'') |
from information_schema.TABLES where TABLE_SCHEMA<>'\''INFORMATION_SCHEMA'\'' and TABLE_SCHEMA<>'\''PERFORMANCE_SCHEMA'\'' and ( ENGINE='\''MyISAM'\'' or ENGINE='\''Aria'\'' )' | \ |
xargs -i $MYSQL --skip-column-names --silent --batch \ |
--force -e "{}" &>$tempfile |
set -e |
|
The problem seems to be the selected locale `LC_ALL=C` while selecting the table names. If I change the locale to `LC_ALL=c.utf-8` the errors disappear. However, I have no idea if this works on any platform besides Ubuntu 22.04.