MySQL服务器在PHP中使用PDO连接已经消失
问题描述:
So basically my webpage is trying to connect to the database, but when I try to open the webpage, the error is printed and my database stops working.
Warning: PDOStatement::execute(): MySQL server has gone away
And this is printed in MySQL Workbench
FROM KORNELPC.err:
00:18:29 UTC - mysqld got exception 0xc0000005 ;
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=65536
max_used_connections=4
max_threads=151
thread_count=4
connection_count=4
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 58341 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x28a9c04f8e0
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...
7ff7329bd542 mysqld.exe!?exec@Item_subselect@@UEAA_NXZ()
7ff7329c32ab mysqld.exe!?val_int@Item_singlerow_subselect@@UEAA_JXZ()
7ff7328853dc mysqld.exe!?val_int@Item_direct_ref@@UEAA_JXZ()
7ff73282f62c mysqld.exe!?compare_int_signed@Arg_comparator@@QEAAHXZ()
7ff73283d4b1 mysqld.exe!?val_int@Item_func_gt@@UEAA_JXZ()
7ff732883a41 mysqld.exe!?val_bool@Item@@UEAA_NXZ()
7ff732831ce6 mysqld.exe!?find_item@Item_func_case@@QEAAPEAVItem@@PEAVString@@@Z()
7ff73283d3f6 mysqld.exe!?val_int@Item_func_case@@UEAA_JXZ()
7ff7328853dc mysqld.exe!?val_int@Item_direct_ref@@UEAA_JXZ()
7ff73282f62c mysqld.exe!?compare_int_signed@Arg_comparator@@QEAAHXZ()
7ff73283d451 mysqld.exe!?val_int@Item_func_eq@@UEAA_JXZ()
7ff732883a41 mysqld.exe!?val_bool@Item@@UEAA_NXZ()
7ff73283cb9c mysqld.exe!?val_int@Item_cond_and@@UEAA_JXZ()
7ff732dd682e mysqld.exe!?end_write_group@@YA?AW4enum_nested_loop_state@@PEAVJOIN@@PEAVQEP_TAB@@_N@Z()
7ff732dda437 mysqld.exe!?sub_select@@YA?AW4enum_nested_loop_state@@PEAVJOIN@@PEAVQEP_TAB@@_N@Z()
7ff732dd56c1 mysqld.exe!?create_intermediate_table@JOIN@@AEAA_NPEAVQEP_TAB@@PEAV?$List@VItem@@@@AEAVORDER_with_src@1@_N@Z()
7ff732dd703b mysqld.exe!?exec@JOIN@@QEAAXXZ()
7ff7329bdd7d mysqld.exe!?exec@subselect_single_select_engine@@UEAA_NXZ()
7ff7329bd5ee mysqld.exe!?exec@Item_subselect@@UEAA_NXZ()
7ff7329c32ab mysqld.exe!?val_int@Item_singlerow_subselect@@UEAA_JXZ()
7ff7328b72e0 mysqld.exe!?int_op@Item_func_plus@@UEAA_JXZ()
7ff7328be2c3 mysqld.exe!?val_int@Item_func_numhybrid@@UEAA_JXZ()
7ff73287fb0a mysqld.exe!?save_in_field_inner@Item@@MEAA?AW4type_conversion_status@@PEAVField@@_N@Z()
7ff73287f8ef mysqld.exe!?save_in_field@Item@@QEAA?AW4type_conversion_status@@PEAVField@@_N@Z()
7ff732dd4de3 mysqld.exe!?copy_funcs@@YA_NPEAV?$Mem_root_array@PEAVItem@@$00@@PEBVTHD@@@Z()
7ff732dd6485 mysqld.exe!?end_send_group@@YA?AW4enum_nested_loop_state@@PEAVJOIN@@PEAVQEP_TAB@@_N@Z()
7ff732dda540 mysqld.exe!?sub_select_op@@YA?AW4enum_nested_loop_state@@PEAVJOIN@@PEAVQEP_TAB@@_N@Z()
7ff732dd69b5 mysqld.exe!?end_write_group@@YA?AW4enum_nested_loop_state@@PEAVJOIN@@PEAVQEP_TAB@@_N@Z()
7ff732dda437 mysqld.exe!?sub_select@@YA?AW4enum_nested_loop_state@@PEAVJOIN@@PEAVQEP_TAB@@_N@Z()
7ff732dd69b5 mysqld.exe!?end_write_group@@YA?AW4enum_nested_loop_state@@PEAVJOIN@@PEAVQEP_TAB@@_N@Z()
7ff732dda437 mysqld.exe!?sub_select@@YA?AW4enum_nested_loop_state@@PEAVJOIN@@PEAVQEP_TAB@@_N@Z()
7ff732dd56c1 mysqld.exe!?create_intermediate_table@JOIN@@AEAA_NPEAVQEP_TAB@@PEAV?$List@VItem@@@@AEAVORDER_with_src@1@_N@Z()
7ff732dd703b mysqld.exe!?exec@JOIN@@QEAAXXZ()
7ff732a7ceba mysqld.exe!?materialize_derived@TABLE_LIST@@QEAA_NPEAVTHD@@@Z()
7ff732dd780d mysqld.exe!?join_materialize_derived@@YAHPEAVQEP_TAB@@@Z()
7ff732dd882a mysqld.exe!?prepare_scan@QEP_TAB@@QEAA_NXZ()
7ff732dda2e7 mysqld.exe!?sub_select@@YA?AW4enum_nested_loop_state@@PEAVJOIN@@PEAVQEP_TAB@@_N@Z()
7ff732dd56c1 mysqld.exe!?create_intermediate_table@JOIN@@AEAA_NPEAVQEP_TAB@@PEAV?$List@VItem@@@@AEAVORDER_with_src@1@_N@Z()
7ff732dd703b mysqld.exe!?exec@JOIN@@QEAAXXZ()
7ff7329a8571 mysqld.exe!?handle_query@@YA_NPEAVTHD@@PEAULEX@@PEAVQuery_result@@_K3@Z()
7ff7328627f6 mysqld.exe!?execute_init_command@@YAXPEAVTHD@@PEAUst_mysql_lex_string@@PEAUst_mysql_rwlock@@@Z()
7ff7328646de mysqld.exe!?mysql_execute_command@@YAHPEAVTHD@@_N@Z()
7ff732867faa mysqld.exe!?mysql_parse@@YAXPEAVTHD@@PEAVParser_state@@@Z()
7ff7328612c9 mysqld.exe!?dispatch_command@@YA_NPEAVTHD@@PEBTCOM_DATA@@W4enum_server_command@@@Z()
7ff73286226a mysqld.exe!?do_command@@YA_NPEAVTHD@@@Z()
7ff732809634 mysqld.exe!handle_connection()
7ff73321ad82 mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
7ff732f446fb mysqld.exe!my_thread_once()
7ff7332db39f mysqld.exe!my_wildcmp_mb()
7ff7332db5ea mysqld.exe!my_wildcmp_mb()
7ffbba278102 KERNEL32.DLL!BaseThreadInitThunk()
7ffbbc39c2e4 ntdll.dll!RtlUserThreadStart()
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (28a9c013738): SELECT * FROM fulltable
Connection ID (thread ID): 7
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.
2015-12-27 01:19:31 - Checking server status...
2015-12-27 01:19:31 - Trying to connect to MySQL...
2015-12-27 01:19:31 - Can't connect to MySQL server on '127.0.0.1' (10061) (2003)
2015-12-27 01:19:31 - Assuming server is not running
The project I'm working on is just cloned from here https://github.com/StretchProjects/stretch-league, so you can look at this code. I'm new in PHP so I can't really debug this and track down this errors.
答
I had to upgrade MySQL to version 5.7.10 and now everything is working correctly.