gouhan
commented
5 years ago 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
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