56,679
社区成员
发帖
与我相关
我的任务
分享Mysql，启动tomcat，登录项目都没问题，但是只要我一点击项目中的模块，需要从数据库拉数据，mysql服务就报错自动停止了
2018-05-07T02:04:11.663374Z 0 [Warning] option 'read_buffer_size': unsigned value 0 adjusted to 8192
2018-05-07T02:04:11.663374Z 0 [Warning] option 'read_rnd_buffer_size': unsigned value 0 adjusted to 1
2018-05-07T02:04:11.663374Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-05-07T02:04:11.663374Z 0 [Warning] '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.
2018-05-07T02:04:11.665374Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.20-log) starting as process 8964 ...
2018-05-07T02:04:11.677375Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-05-07T02:04:11.678375Z 0 [Note] InnoDB: Uses event mutexes
2018-05-07T02:04:11.678375Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2018-05-07T02:04:11.679375Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-05-07T02:04:11.680375Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
2018-05-07T02:04:11.681375Z 0 [Note] InnoDB: Number of pools: 1
2018-05-07T02:04:11.682375Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2018-05-07T02:04:11.685376Z 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
2018-05-07T02:04:11.687376Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-05-07T02:04:11.779381Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-05-07T02:04:11.795382Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 128552391
2018-05-07T02:04:11.797382Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 128552400
2018-05-07T02:04:11.799382Z 0 [Note] InnoDB: Database was not shutdown normally!
2018-05-07T02:04:11.801382Z 0 [Note] InnoDB: Starting crash recovery.
2018-05-07T02:04:15.205577Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-05-07T02:04:15.208577Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-05-07T02:04:15.213577Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-05-07T02:04:15.706606Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2018-05-07T02:04:15.713606Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-05-07T02:04:15.715606Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-05-07T02:04:15.718606Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4029ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-05-07T02:04:15.734607Z 0 [Note] InnoDB: 5.7.20 started; log sequence number 128552400
2018-05-07T02:04:15.737607Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-05-07T02:04:15.738607Z 0 [Note] InnoDB: Loading buffer pool(s) from C:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
2018-05-07T02:04:16.098628Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2018-05-07T02:04:16.102628Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2018-05-07T02:04:16.107629Z 0 [Note] IPv6 is available.
2018-05-07T02:04:16.108629Z 0 [Note] - '::' resolves to '::';
2018-05-07T02:04:16.110629Z 0 [Note] Server socket created on IP: '::'.
2018-05-07T02:04:16.259637Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180507 10:04:16
2018-05-07T02:04:16.384644Z 0 [Note] Event Scheduler: Loaded 0 events
2018-05-07T02:04:16.385644Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: ready for connections.
Version: '5.7.20-log' socket: '' port: 3306 MySQL Community Server (GPL)
2018-05-07T02:04:16.387645Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check.
2018-05-07T02:04:16.389645Z 0 [Note] Beginning of list of non-natively partitioned tables
2018-05-07T02:04:16.470649Z 0 [Note] End of list of non-natively partitioned tables
02:05:00 UTC - mysqld got exception 0xc000001d ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
Attempting to collect some information that could help diagnose the problem.
As this is a crash and something is definitely wrong, the information
collection process might fail.
key_buffer_size=8388608
read_buffer_size=8192
max_used_connections=1
max_threads=151
thread_count=1
connection_count=1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 49892 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0xe449f70
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...
7feea9b5c01 MSVCR120.dll!pow()
13fa962aa mysqld.exe!?get_sweep_read_cost@@YAXPEAUTABLE@@_K_NPEAVCost_estimate@@@Z()
140058107 mysqld.exe!?right@?$Priority_queue@PEAVQUICK_SELECT_I@@V?$vector@PEAVQUICK_SELECT_I@@V?$Malloc_allocator@PEAVQUICK_SELECT_I@@@@@std@@UQuick_ror_union_less@@@@CA_K_K@Z()
14004e059 mysqld.exe!?free_tree@SEL_ARG@@QEAAXXZ()
14005a3f5 mysqld.exe!?test_quick_select@@YAHPEAVTHD@@V?$Bitmap@$0EA@@@_K2_NW4enum_order@st_order@@PEBVQEP_shared_owner@@PEAVItem@@PEAV2@PEAPEAVQUICK_SELECT_I@@@Z()
13fc06e4e mysqld.exe!?get_op_type@Ft_hints@@QEAA?AW4ft_operation@@XZ()
13fc058ad mysqld.exe!?estimate_rowcount@JOIN@@AEAA_NXZ()
13fc08619 mysqld.exe!?make_join_plan@JOIN@@AEAA_NXZ()
13fc0a18b mysqld.exe!?optimize@JOIN@@QEAAHXZ()
13fc52559 mysqld.exe!?optimize@st_select_lex@@QEAA_NPEAVTHD@@@Z()
13fc5057d mysqld.exe!?handle_query@@YA_NPEAVTHD@@PEAULEX@@PEAVQuery_result@@_K3@Z()
13fac4267 mysqld.exe!?execute_init_command@@YAXPEAVTHD@@PEAUst_mysql_lex_string@@PEAUst_mysql_rwlock@@@Z()
13fac6196 mysqld.exe!?mysql_execute_command@@YAHPEAVTHD@@_N@Z()
13fac9bf3 mysqld.exe!?mysql_parse@@YAXPEAVTHD@@PEAVParser_state@@@Z()
13fac2c93 mysqld.exe!?dispatch_command@@YA_NPEAVTHD@@PEBTCOM_DATA@@W4enum_server_command@@@Z()
13fac3cda mysqld.exe!?do_command@@YA_NPEAVTHD@@@Z()
13fa6a80c mysqld.exe!handle_connection()
1404c5932 mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
1401d7e6c mysqld.exe!my_thread_once()
7feea944f7f MSVCR120.dll!_beginthreadex()
7feea945126 MSVCR120.dll!_endthreadex()
775df56d kernel32.dll!BaseThreadInitThunk()
77713281 ntdll.dll!RtlUserThreadStart()
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (a0dff90): select this_.ID as ID216_0_, this_.functionid as functionid216_0_, this_.roleid as roleid216_0_, this_.datarule as datarule216_0_, this_.operation as operation216_0_ from t_s_role_function this_ where this_.roleid='8a8ab0b246dc81120146dc8181870050' and this_.functionid='2c9157595c9bc76c015ca4a1cdb4000b'
Connection ID (thread ID): 3
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.
2018-05-07T02:04:11.663374Z 0 [Warning] option 'read_rnd_buffer_size': unsigned value 0 adjusted to 1
2018-05-07T02:04:11.663374Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-05-07T02:04:11.663374Z 0 [Warning] '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.
2018-05-07T02:04:11.665374Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.20-log) starting as process 8964 ...
2018-05-07T02:04:11.677375Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-05-07T02:04:11.678375Z 0 [Note] InnoDB: Uses event mutexes
2018-05-07T02:04:11.678375Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2018-05-07T02:04:11.679375Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-05-07T02:04:11.680375Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
2018-05-07T02:04:11.681375Z 0 [Note] InnoDB: Number of pools: 1
2018-05-07T02:04:11.682375Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2018-05-07T02:04:11.685376Z 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
2018-05-07T02:04:11.687376Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-05-07T02:04:11.779381Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-05-07T02:04:11.795382Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 128552391
2018-05-07T02:04:11.797382Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 128552400
2018-05-07T02:04:11.799382Z 0 [Note] InnoDB: Database was not shutdown normally!
2018-05-07T02:04:11.801382Z 0 [Note] InnoDB: Starting crash recovery.
2018-05-07T02:04:15.205577Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-05-07T02:04:15.208577Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-05-07T02:04:15.213577Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-05-07T02:04:15.706606Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2018-05-07T02:04:15.713606Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-05-07T02:04:15.715606Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-05-07T02:04:15.718606Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4029ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-05-07T02:04:15.734607Z 0 [Note] InnoDB: 5.7.20 started; log sequence number 128552400
2018-05-07T02:04:15.737607Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-05-07T02:04:15.738607Z 0 [Note] InnoDB: Loading buffer pool(s) from C:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
2018-05-07T02:04:16.098628Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2018-05-07T02:04:16.102628Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2018-05-07T02:04:16.107629Z 0 [Note] IPv6 is available.
2018-05-07T02:04:16.108629Z 0 [Note] - '::' resolves to '::';
2018-05-07T02:04:16.110629Z 0 [Note] Server socket created on IP: '::'.
2018-05-07T02:04:16.259637Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180507 10:04:16
2018-05-07T02:04:16.384644Z 0 [Note] Event Scheduler: Loaded 0 events
2018-05-07T02:04:16.385644Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: ready for connections.
Version: '5.7.20-log' socket: '' port: 3306 MySQL Community Server (GPL)
2018-05-07T02:04:16.387645Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check.
2018-05-07T02:04:16.389645Z 0 [Note] Beginning of list of non-natively partitioned tables
2018-05-07T02:04:16.470649Z 0 [Note] End of list of non-natively partitioned tables
02:05:00 UTC - mysqld got exception 0xc000001d ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
Attempting to collect some information that could help diagnose the problem.
As this is a crash and something is definitely wrong, the information
collection process might fail.
key_buffer_size=8388608
read_buffer_size=8192
max_used_connections=1
max_threads=151
thread_count=1
connection_count=1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 49892 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0xe449f70
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...
7feea9b5c01 MSVCR120.dll!pow()
13fa962aa mysqld.exe!?get_sweep_read_cost@@YAXPEAUTABLE@@_K_NPEAVCost_estimate@@@Z()
140058107 mysqld.exe!?right@?$Priority_queue@PEAVQUICK_SELECT_I@@V?$vector@PEAVQUICK_SELECT_I@@V?$Malloc_allocator@PEAVQUICK_SELECT_I@@@@@std@@UQuick_ror_union_less@@@@CA_K_K@Z()
14004e059 mysqld.exe!?free_tree@SEL_ARG@@QEAAXXZ()
14005a3f5 mysqld.exe!?test_quick_select@@YAHPEAVTHD@@V?$Bitmap@$0EA@@@_K2_NW4enum_order@st_order@@PEBVQEP_shared_owner@@PEAVItem@@PEAV2@PEAPEAVQUICK_SELECT_I@@@Z()
13fc06e4e mysqld.exe!?get_op_type@Ft_hints@@QEAA?AW4ft_operation@@XZ()
13fc058ad mysqld.exe!?estimate_rowcount@JOIN@@AEAA_NXZ()
13fc08619 mysqld.exe!?make_join_plan@JOIN@@AEAA_NXZ()
13fc0a18b mysqld.exe!?optimize@JOIN@@QEAAHXZ()
13fc52559 mysqld.exe!?optimize@st_select_lex@@QEAA_NPEAVTHD@@@Z()
13fc5057d mysqld.exe!?handle_query@@YA_NPEAVTHD@@PEAULEX@@PEAVQuery_result@@_K3@Z()
13fac4267 mysqld.exe!?execute_init_command@@YAXPEAVTHD@@PEAUst_mysql_lex_string@@PEAUst_mysql_rwlock@@@Z()
13fac6196 mysqld.exe!?mysql_execute_command@@YAHPEAVTHD@@_N@Z()
13fac9bf3 mysqld.exe!?mysql_parse@@YAXPEAVTHD@@PEAVParser_state@@@Z()
13fac2c93 mysqld.exe!?dispatch_command@@YA_NPEAVTHD@@PEBTCOM_DATA@@W4enum_server_command@@@Z()
13fac3cda mysqld.exe!?do_command@@YA_NPEAVTHD@@@Z()
13fa6a80c mysqld.exe!handle_connection()
1404c5932 mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
1401d7e6c mysqld.exe!my_thread_once()
7feea944f7f MSVCR120.dll!_beginthreadex()
7feea945126 MSVCR120.dll!_endthreadex()
775df56d kernel32.dll!BaseThreadInitThunk()
77713281 ntdll.dll!RtlUserThreadStart()
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (a0dff90): select this_.ID as ID216_0_, this_.functionid as functionid216_0_, this_.roleid as roleid216_0_, this_.datarule as datarule216_0_, this_.operation as operation216_0_ from t_s_role_function this_ where this_.roleid='8a8ab0b246dc81120146dc8181870050' and this_.functionid='2c9157595c9bc76c015ca4a1cdb4000b'
Connection ID (thread ID): 3
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.
...全文
请发表友善的回复…
发表回复
rucypli 2018-05-10
- 打赏
- 举报
导出数据备份 重装数据库
