| Bug #100755 | Special collation prevent server from startup | ||
|---|---|---|---|
| Submitted: | 6 Sep 2020 15:21 | Modified: | 10 Sep 2020 19:19 |
| Reporter: | ahmed taha | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Charsets | Severity: | S3 (Non-critical) |
| Version: | 8.0.21 | OS: | Windows |
| Assigned to: | CPU Architecture: | Any | |
[6 Sep 2020 15:50]
MySQL Verification Team
Thank you for the bug report. I couldn't repeat just get the below warnings: c:\dbs>c:\dbs\8.0\bin\mysqld --defaults-file=c:\dbs\my80.ini --standalone --console 2020-09-06T15:48:20.959396Z 0 [System] [MY-010116] [Server] c:\dbs\8.0\bin\mysqld (mysqld 8.0.22) starting as process 27380 2020-09-06T15:48:20.972092Z 0 [Warning] [MY-000090] [Server] Unknown LDML tag: 'charsets/collation'. 2020-09-06T15:48:20.972106Z 0 [Warning] [MY-000090] [Server] Unknown LDML tag: 'charsets/collation/name'. 2020-09-06T15:48:20.972113Z 0 [Warning] [MY-000090] [Server] Unknown LDML tag: 'charsets/collation/id'. 2020-09-06T15:48:20.972120Z 0 [Warning] [MY-000090] [Server] Unknown LDML tag: 'charsets/collation/rules'. 2020-09-06T15:48:20.972126Z 0 [Warning] [MY-000090] [Server] Unknown LDML tag: 'charsets/collation/rules/reset'. 2020-09-06T15:48:20.972132Z 0 [Warning] [MY-000090] [Server] Unknown LDML tag: 'charsets/collation/rules/i'. 2020-09-06T15:48:20.972139Z 0 [Warning] [MY-000090] [Server] Unknown LDML tag: 'charsets/collation/rules/i'. 2020-09-06T15:48:20.972144Z 0 [Warning] [MY-000090] [Server] Unknown LDML tag: 'charsets/collation/rules/i'. 2020-09-06T15:48:20.972151Z 0 [Warning] [MY-000090] [Server] Unknown LDML tag: 'charsets/collation/rules'. 2020-09-06T15:48:20.972157Z 0 [Warning] [MY-000090] [Server] Unknown LDML tag: 'charsets/collation/rules/reset'. 2020-09-06T15:48:20.972162Z 0 [Warning] [MY-000090] [Server] Unknown LDML tag: 'charsets/collation/rules/i'. 2020-09-06T15:48:20.972169Z 0 [Warning] [MY-000090] [Server] Unknown LDML tag: 'charsets/collation/rules'. 2020-09-06T15:48:20.972175Z 0 [Warning] [MY-000090] [Server] Unknown LDML tag: 'charsets/collation/rules/reset'. 2020-09-06T15:48:20.972181Z 0 [Warning] [MY-000090] [Server] Unknown LDML tag: 'charsets/collation/rules/i'. 2020-09-06T15:48:20.972198Z 0 [Warning] [MY-000090] [Server] Unknown LDML tag: 'charsets/collation/rules'. 2020-09-06T15:48:20.972202Z 0 [Warning] [MY-000090] [Server] Unknown LDML tag: 'charsets/collation/rules/reset'. 2020-09-06T15:48:20.972207Z 0 [Warning] [MY-000090] [Server] Unknown LDML tag: 'charsets/collation/rules/i'. 2020-09-06T15:48:20.972212Z 0 [Warning] [MY-000090] [Server] Unknown LDML tag: 'charsets/collation/rules/i'. 2020-09-06T15:48:20.972217Z 0 [Warning] [MY-000090] [Server] Unknown LDML tag: 'charsets/collation/rules/i'. 2020-09-06T15:48:20.972221Z 0 [Warning] [MY-000090] [Server] Unknown LDML tag: 'charsets/collation/rules/i'. 2020-09-06T15:48:20.972226Z 0 [Warning] [MY-000090] [Server] Unknown LDML tag: 'charsets/collation/rules/i'. 2020-09-06T15:48:20.972231Z 0 [Warning] [MY-000090] [Server] Unknown LDML tag: 'charsets/collation/rules/i'. 2020-09-06T15:48:20.972236Z 0 [Warning] [MY-000090] [Server] Unknown LDML tag: 'charsets/collation/rules/i'. 2020-09-06T15:48:20.972240Z 0 [Warning] [MY-000090] [Server] Unknown LDML tag: 'charsets/collation/rules/i'. 2020-09-06T15:48:21.060534Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2020-09-06T15:48:21.499794Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2020-09-06T15:48:21.688478Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060 2020-09-06T15:48:21.770090Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2020-09-06T15:48:21.771838Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2020-09-06T15:48:21.865145Z 0 [System] [MY-010931] [Server] c:\dbs\8.0\bin\mysqld: ready for connections. Version: '8.0.22' socket: '' port: 3580 Source distribution BUILT: 2020-AUG-24.
[10 Sep 2020 18:40]
ahmed taha
Try repeating with this ... it works on 19 not 21
<charset name="utf8">
<family>Unicode</family>
<description>UTF-8 Unicode</description>
<alias>utf-8</alias>
<collation name="utf8_general_ci" id="33">
<flag>primary</flag>
<flag>compiled</flag>
</collation>
<collation name="utf8_tolower_ci" id="76">
<flag>compiled</flag>
</collation>
<collation name="utf8_bin" id="83">
<flag>binary</flag>
<flag>compiled</flag>
</collation>
<collation name="utf8_arabic_ci_v1" id="1029">
<rules>
<reset>\u0627</reset>
<!-- Alef 'ا' -->
<i>\u0623</i>
<!-- Alef With Hamza Above 'أ' -->
<i>\u0625</i>
<!-- Alef With Hamza Below 'إ' -->
<i>\u0622</i>
<!-- Alef With Madda Above 'آ' -->
</rules>
<rules>
<reset>\u0649</reset>
<!-- ALEF MAKSURA 'ى' -->
<i>\u064A</i>
<!-- YEH 'ي' -->
</rules>
<rules>
<reset>\u0629</reset>
<!-- Teh Marbuta 'ة' -->
<i>\u0647</i>
<!-- Heh 'ه' -->
</rules>
<rules>
<reset>\u0000</reset>
<!-- Ignore Tashkil -->
<i>\u064E</i>
<!-- Fatha 'َ' -->
<i>\u064F</i>
<!-- Damma 'ُ' -->
<i>\u0650</i>
<!-- Kasra 'ِ' -->
<i>\u0651</i>
<!-- Shadda 'ّ' -->
<i>\u064F</i>
<!-- Sukun 'ْ' -->
<i>\u064B</i>
<!-- Fathatan 'ً' -->
<i>\u064C</i>
<!-- Dammatan 'ٌ' -->
<i>\u064D</i>
<!-- Kasratan 'ٍ' -->
</rules>
</collation>
</charset>
[10 Sep 2020 19:16]
MySQL Verification Team
Not repeatable with most recent source server built:
c:\dbs>tail -n 60 8.0\share\charsets\index.xml
<alias>utf-8</alias>
<collation name="utf8_general_ci" id="33">
<flag>primary</flag>
<flag>compiled</flag>
</collation>
<collation name="utf8_tolower_ci" id="76">
<flag>compiled</flag>
</collation>
<collation name="utf8_bin" id="83">
<flag>binary</flag>
<flag>compiled</flag>
</collation>
<collation name="utf8_arabic_ci_v1" id="1029">
<rules>
<reset>\u0627</reset>
<!-- Alef 'ا' -->
<i>\u0623</i>
<!-- Alef With Hamza Above 'Ø£' -->
<i>\u0625</i>
<!-- Alef With Hamza Below 'Ø¥' -->
<i>\u0622</i>
<!-- Alef With Madda Above 'Ø¢' -->
</rules>
<rules>
<reset>\u0649</reset>
<!-- ALEF MAKSURA 'Ù%' -->
<i>\u064A</i>
<!-- YEH 'ÙS' -->
</rules>
<rules>
<reset>\u0629</reset>
<!-- Teh Marbuta 'Ø©' -->
<i>\u0647</i>
<!-- Heh 'Ù╬' -->
</rules>
<rules>
<reset>\u0000</reset>
<!-- Ignore Tashkil -->
<i>\u064E</i>
<!-- Fatha 'ÙZ' -->
<i>\u064F</i>
<!-- Damma 'Ù?' -->
<i>\u0650</i>
<!-- Kasra 'Ù?' -->
<i>\u0651</i>
<!-- Shadda 'Ù'' -->
<i>\u064F</i>
<!-- Sukun 'Ù'' -->
<i>\u064B</i>
<!-- Fathatan 'Ù<' -->
<i>\u064C</i>
<!-- Dammatan 'ÙO' -->
<i>\u064D</i>
<!-- Kasratan 'Ù?' -->
</rules>
</collation>
</charset>
</charsets>
c:\dbs>80s
c:\dbs>c:\dbs\8.0\bin\mysqld --defaults-file=c:\dbs\my80.ini --standalone --console
2020-09-10T19:14:55.990395Z 0 [System] [MY-010116] [Server] c:\dbs\8.0\bin\mysqld (mysqld 8.0.22) starting as process 8860
2020-09-10T19:14:56.005990Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-09-10T19:14:56.401999Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-09-10T19:14:56.562560Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060
2020-09-10T19:14:56.625256Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-09-10T19:14:56.627714Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2020-09-10T19:14:56.675916Z 0 [System] [MY-010931] [Server] c:\dbs\8.0\bin\mysqld: ready for connections. Version: '8.0.22' socket: '' port: 3580 Source distribution BUILT: 2020-SEP-06.
Description: MySql server failed to startup after updating mysql server community from 8.0.19 to 8.0.21 using special collation How to repeat: open \share\charsets\index.xml edit with notepad add this collation to utf8 <collation name="utf8_arabic_ci_v1" id="1029"> <rules> <reset>\u0627</reset> <!-- Alef 'ا' --> <i>\u0623</i> <!-- Alef With Hamza Above 'أ' --> <i>\u0625</i> <!-- Alef With Hamza Below 'إ' --> <i>\u0622</i> <!-- Alef With Madda Above 'آ' --> </rules> <rules> <reset>\u0649</reset> <!-- ALEF MAKSURA 'ى' --> <i>\u064A</i> <!-- YEH 'ي' --> </rules> <rules> <reset>\u0629</reset> <!-- Teh Marbuta 'ة' --> <i>\u0647</i> <!-- Heh 'ه' --> </rules> <rules> <reset>\u0000</reset> <!-- Ignore Tashkil --> <i>\u064E</i> <!-- Fatha 'َ' --> <i>\u064F</i> <!-- Damma 'ُ' --> <i>\u0650</i> <!-- Kasra 'ِ' --> <i>\u0651</i> <!-- Shadda 'ّ' --> <i>\u064F</i> <!-- Sukun 'ْ' --> <i>\u064B</i> <!-- Fathatan 'ً' --> <i>\u064C</i> <!-- Dammatan 'ٌ' --> <i>\u064D</i> <!-- Kasratan 'ٍ' --> </rules> </collation> this is what i got 2020-09-06T15:18:33.743986Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2020-09-06T15:18:33.744081Z 0 [System] [MY-010116] [Server] C:\Users\ahmed\OneDrive\Desktop\New folder (2)\bin\mysqld (mysqld 8.0.21) starting as process 21888 2020-09-06T15:18:33.753613Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2020-09-06T15:18:34.183779Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2020-09-06T15:18:34.416214Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060 2020-09-06T15:18:34.531552Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2020-09-06T15:18:34.532071Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2020-09-06T15:18:34.534357Z 0 [Warning] [MY-000000] [Server] Setting named_pipe_full_access_group='*everyone*' is insecure. Consider using a Windows group with fewer members. 2020-09-06T15:18:34.564908Z 0 [System] [MY-010931] [Server] C:\Users\ahmed\OneDrive\Desktop\New folder (2)\bin\mysqld: ready for connections. Version: '8.0.21' socket: '' port: 3308 MySQL Community Server - GPL. 2020-09-06T15:18:42.295095Z 0 [System] [MY-013105] [Server] C:\Users\ahmed\OneDrive\Desktop\New folder (2)\bin\mysqld: Normal shutdown. 2020-09-06T15:18:43.652445Z 0 [System] [MY-010910] [Server] C:\Users\ahmed\OneDrive\Desktop\New folder (2)\bin\mysqld: Shutdown complete (mysqld 8.0.21) MySQL Community Server - GPL. 2020-09-06T15:19:11.821904Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2020-09-06T15:19:11.821973Z 0 [System] [MY-010116] [Server] C:\Users\ahmed\OneDrive\Desktop\New folder (2)\bin\mysqld (mysqld 8.0.21) starting as process 17484 2020-09-06T15:19:11.832013Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2020-09-06T15:19:12.261821Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2020-09-06T15:19:12.263699Z 1 [ERROR] [MY-013178] [Server] Execution of server-side SQL statement 'CREATE TABLE dd_properties( properties MEDIUMBLOB ) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC STATS_PERSISTENT=0 TABLESPACE=mysql' failed with error code = 1115, error message = 'Unknown character set: 'utf8''. 2020-09-06T15:19:12.265127Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2020-09-06T15:19:12.265637Z 0 [ERROR] [MY-010119] [Server] Aborting 2020-09-06T15:19:12.452177Z 0 [System] [MY-010910] [Server] C:\Users\ahmed\OneDrive\Desktop\New folder (2)\bin\mysqld: Shutdown complete (mysqld 8.0.21) MySQL Community Server - GPL. 15:19:12 UTC - mysqld got exception 0xc0000005 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... 7ff65cda21bf mysqld.exe!?charset_uninit@@YAXXZ() 7ff65cd9d120 mysqld.exe!?my_end@@YAXH@Z() 7ff65bed57bf mysqld.exe!?mysql_service@@YAHPEAX@Z() 7ff65bed92fe mysqld.exe!?type@LogEvent@@QEAAAEAV1@W4enum_log_type@@@Z() 7ff65bed2a8f mysqld.exe!?init_common_variables@@YAHXZ() 7ff65bed9d3c mysqld.exe!?win_main@@YAHHPEAPEAD@Z() 7ff65bed5775 mysqld.exe!?mysql_service@@YAHPEAX@Z() 7ff65bed5db1 mysqld.exe!?mysqld_main@@YAHHPEAPEAD@Z() 7ff65d3a9e08 mysqld.exe!?set_timespec_nsec@@YAXPEAUtimespec@@_K@Z() 7ffaa66d6fd4 KERNEL32.DLL!BaseThreadInitThunk() 7ffaa6d1cec1 ntdll.dll!RtlUserThreadStart() The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash.