using with mysql8.0,when hangfire works,it causes the mysql db crashed.

[gouhan]

Thread pointer: 0x190adfc0
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...
140b766f2 mysqld.exe!?my_errno@@yahxz()
7feeb738b68 ucrtbase.DLL!raise()
7feeb7398e1 ucrtbase.DLL!abort()
140dd1e08 mysqld.exe!??1?$lock_guard@Vmutex@std@@@std@@qeaa@XZ()
140d8f7cc mysqld.exe!??1?$lock_guard@Vmutex@std@@@std@@qeaa@XZ()
140e2180c mysqld.exe!??1?$lock_guard@Vmutex@std@@@std@@qeaa@XZ()
140e20136 mysqld.exe!??1?$lock_guard@Vmutex@std@@@std@@qeaa@XZ()
140cc84fa mysqld.exe!??1?$lock_guard@Vmutex@std@@@std@@qeaa@XZ()
13fdf44fa mysqld.exe!?ha_open@handler@@QEAAHPEAUTABLE@@PEBDHHPEBVTable@dd@@@z()
13fe569a0 mysqld.exe!?open_table_from_share@@YAHPEAVTHD@@PEAUTABLE_SHARE@@PEBDIIIPEAUTABLE@@_NPEBVTable@dd@@@z()
13ff6579e mysqld.exe!?open_table@@YA_NPEAVTHD@@PEAUTABLE_LIST@@PEAVOpen_table_context@@@z()
13ff644a0 mysqld.exe!?open_and_lock_tables@@YA_NPEAVTHD@@PEAUTABLE_LIST@@IPEAVPrelocking_strategy@@@z()
13ff66736 mysqld.exe!?open_tables@@YA_NPEAVTHD@@PEAPEAUTABLE_LIST@@PEAIIPEAVPrelocking_strategy@@@z()
13ff66c31 mysqld.exe!?open_tables_for_query@@YA_NPEAVTHD@@PEAUTABLE_LIST@@i@Z()
1400ae299 mysqld.exe!?prepare@Sql_cmd_dml@@UEAA_NPEAVTHD@@@z()
1400aacbd mysqld.exe!?execute@Sql_cmd_dml@@UEAA_NPEAVTHD@@@z()
13ff740a8 mysqld.exe!?mysql_execute_command@@YAHPEAVTHD@@_N@Z()
13ff74bc9 mysqld.exe!?mysql_parse@@YAXPEAVTHD@@PEAVParser_state@@_N@Z()
13ff6e8df mysqld.exe!?dispatch_command@@YA_NPEAVTHD@@PEBTCOM_DATA@@W4enum_server_command@@@z()
13ff6f845 mysqld.exe!?do_command@@YA_NPEAVTHD@@@z()
13fde8238 mysqld.exe!?pop_front@?$list@PEAVChannel_info@@v?$allocator@PEAVChannel_info@@@std@@@std@@QEAAXXZ()
140f68947 mysqld.exe!??1?$lock_guard@Vmutex@std@@@std@@qeaa@XZ()
140b7668c mysqld.exe!?my_thread_join@@YAHPEAUmy_thread_handle@@PEAPEAX@Z()
7feeb73be1d ucrtbase.DLL!_crt_at_quick_exit()
76b159cd kernel32.dll!BaseThreadInitThunk()
76d4a561 ntdll.dll!RtlUserThreadStart()

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (19156228): SELECT * FROM Hangfire.Job
LIMIT 0, 1000
Connection ID (thread ID): 11
Status: NOT_KILLED

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.
2019-01-29T11:31:03.423625Z 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.
2019-01-29T11:31:03.424601Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld (mysqld 8.0.13) starting as process 9132
2019-01-29T11:31:04.940285Z 0 [System] [MY-010229] [Server] Starting crash recovery...
2019-01-29T11:31:04.950051Z 0 [Warning] [MY-010225] [Server] Found 2 prepared XA transactions
2019-01-29T11:31:04.951027Z 0 [System] [MY-010232] [Server] Crash recovery finished.
2019-01-29T11:31:04.960793Z 0 [Warning] [MY-010225] [Server] Found 2 prepared XA transactions
2019-01-29T11:31:06.053609Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2019-01-29T11:31:06.106345Z 0 [System] [MY-010931] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld: ready for connections. Version: '8.0.13' socket: '' port: 3306 MySQL Community Server - GPL.
2019-01-29T11:31:06.153222Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060

[gouhan]

I don't know why it happens.
I just pull down the master version code ,and fixed some sql syntax support with mysql 8.0,eg rank to 'rank'.
Is there any solution? Or i need to use quartznet instead?

[ghd258]

I also have this problem.

[gouhan]

@ghd258 ，have you got any solution for the problem?