Magento 2.3 setup:upgrade error sql












0















I used magento 2.3 and meet problem when run command upgrade.
It shows:



Warning: PDOStatement::execute(): MySQL server has gone away in vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php on line 228


I try some solution about mysql variable as:




max_allowed_packet=4000M
and wait_timeout=6000




However, nothing solve it.
Just see the of sql:



key_buffer_size=8388608
read_buffer_size=131072
max_used_connections=5
max_threads=151
thread_count=6
connection_count=5
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 67870 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x7fb47d30cc00
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...
stack_bottom = 700002904e90 thread_stack 0x46000
0 mysqld 0x000000010f38a5ec my_print_stacktrace(unsigned char*, unsigned long) + 60
1 mysqld 0x000000010e7e7e76 handle_fatal_signal + 678
2 libsystem_platform.dylib 0x00007fff66a1cf5a _sigtramp + 26
3 ??? 0x00007000029011e8 0x0 + 123145345307112
4 libsystem_c.dylib 0x00007fff667ba1ae abort + 127
5 mysqld 0x000000010f71707c ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 252
6 mysqld 0x000000010f6b3542 row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) + 4002
7 mysqld 0x000000010f58ffd1 ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function) + 657
8 mysqld 0x000000010e3e8389 handler::ha_index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function) + 233
9 mysqld 0x000000010e65ec30 join_read_key(QEP_TAB*) + 464
10 mysqld 0x000000010e65aa28 sub_select(JOIN*, QEP_TAB*, bool) + 728
11 mysqld 0x000000010e65b0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602
12 mysqld 0x000000010e65aae1 sub_select(JOIN*, QEP_TAB*, bool) + 913
13 mysqld 0x000000010e65b0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602
14 mysqld 0x000000010e65aae1 sub_select(JOIN*, QEP_TAB*, bool) + 913
15 mysqld 0x000000010e65b0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602
16 mysqld 0x000000010e65aae1 sub_select(JOIN*, QEP_TAB*, bool) + 913
17 mysqld 0x000000010e65b0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602
18 mysqld 0x000000010e65aae1 sub_select(JOIN*, QEP_TAB*, bool) + 913
19 mysqld 0x000000010e65b0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602
20 mysqld 0x000000010e65aae1 sub_select(JOIN*, QEP_TAB*, bool) + 913
21 mysqld 0x000000010e65b0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602
22 mysqld 0x000000010e65aae1 sub_select(JOIN*, QEP_TAB*, bool) + 913
23 mysqld 0x000000010e6557da JOIN::exec() + 858
24 mysqld 0x000000010e6ee8c1 handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) + 545
25 mysqld 0x000000010e6b1420 execute_show(THD*, TABLE_LIST*) + 624
26 mysqld 0x000000010e61e55a Sql_cmd_show::execute(THD*) + 74
27 mysqld 0x000000010e6abc51 mysql_execute_command(THD*, bool) + 3473
28 mysqld 0x000000010e6a9af6 mysql_parse(THD*, Parser_state*) + 886
29 mysqld 0x000000010e6a8408 dispatch_command(THD*, COM_DATA const*, enum_server_command) + 7544
30 mysqld 0x000000010e6a9363 do_command(THD*) + 467
31 mysqld 0x000000010e7d10e4 handle_connection(void*) + 372
32 mysqld 0x000000010f77ebbc pfs_spawn_thread(void*) + 316
33 libsystem_pthread.dylib 0x00007fff66a26661 _pthread_body + 340
34 libsystem_pthread.dylib 0x00007fff66a2650d _pthread_body + 0
35 libsystem_pthread.dylib 0x00007fff66a25bf9 thread_start + 13

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7fb47d31a828): SHOW INDEXES FROM catalog_category_product_index_tmp WHERE `Non_unique` = 1
Connection ID (thread ID): 58
Status: NOT_KILLED


I am using Mac Os with mysql. Anyone can help me?









share



























    0















    I used magento 2.3 and meet problem when run command upgrade.
    It shows:



    Warning: PDOStatement::execute(): MySQL server has gone away in vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php on line 228


    I try some solution about mysql variable as:




    max_allowed_packet=4000M
    and wait_timeout=6000




    However, nothing solve it.
    Just see the of sql:



    key_buffer_size=8388608
    read_buffer_size=131072
    max_used_connections=5
    max_threads=151
    thread_count=6
    connection_count=5
    It is possible that mysqld could use up to
    key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 67870 K bytes of memory
    Hope that's ok; if not, decrease some variables in the equation.

    Thread pointer: 0x7fb47d30cc00
    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...
    stack_bottom = 700002904e90 thread_stack 0x46000
    0 mysqld 0x000000010f38a5ec my_print_stacktrace(unsigned char*, unsigned long) + 60
    1 mysqld 0x000000010e7e7e76 handle_fatal_signal + 678
    2 libsystem_platform.dylib 0x00007fff66a1cf5a _sigtramp + 26
    3 ??? 0x00007000029011e8 0x0 + 123145345307112
    4 libsystem_c.dylib 0x00007fff667ba1ae abort + 127
    5 mysqld 0x000000010f71707c ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 252
    6 mysqld 0x000000010f6b3542 row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) + 4002
    7 mysqld 0x000000010f58ffd1 ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function) + 657
    8 mysqld 0x000000010e3e8389 handler::ha_index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function) + 233
    9 mysqld 0x000000010e65ec30 join_read_key(QEP_TAB*) + 464
    10 mysqld 0x000000010e65aa28 sub_select(JOIN*, QEP_TAB*, bool) + 728
    11 mysqld 0x000000010e65b0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602
    12 mysqld 0x000000010e65aae1 sub_select(JOIN*, QEP_TAB*, bool) + 913
    13 mysqld 0x000000010e65b0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602
    14 mysqld 0x000000010e65aae1 sub_select(JOIN*, QEP_TAB*, bool) + 913
    15 mysqld 0x000000010e65b0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602
    16 mysqld 0x000000010e65aae1 sub_select(JOIN*, QEP_TAB*, bool) + 913
    17 mysqld 0x000000010e65b0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602
    18 mysqld 0x000000010e65aae1 sub_select(JOIN*, QEP_TAB*, bool) + 913
    19 mysqld 0x000000010e65b0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602
    20 mysqld 0x000000010e65aae1 sub_select(JOIN*, QEP_TAB*, bool) + 913
    21 mysqld 0x000000010e65b0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602
    22 mysqld 0x000000010e65aae1 sub_select(JOIN*, QEP_TAB*, bool) + 913
    23 mysqld 0x000000010e6557da JOIN::exec() + 858
    24 mysqld 0x000000010e6ee8c1 handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) + 545
    25 mysqld 0x000000010e6b1420 execute_show(THD*, TABLE_LIST*) + 624
    26 mysqld 0x000000010e61e55a Sql_cmd_show::execute(THD*) + 74
    27 mysqld 0x000000010e6abc51 mysql_execute_command(THD*, bool) + 3473
    28 mysqld 0x000000010e6a9af6 mysql_parse(THD*, Parser_state*) + 886
    29 mysqld 0x000000010e6a8408 dispatch_command(THD*, COM_DATA const*, enum_server_command) + 7544
    30 mysqld 0x000000010e6a9363 do_command(THD*) + 467
    31 mysqld 0x000000010e7d10e4 handle_connection(void*) + 372
    32 mysqld 0x000000010f77ebbc pfs_spawn_thread(void*) + 316
    33 libsystem_pthread.dylib 0x00007fff66a26661 _pthread_body + 340
    34 libsystem_pthread.dylib 0x00007fff66a2650d _pthread_body + 0
    35 libsystem_pthread.dylib 0x00007fff66a25bf9 thread_start + 13

    Trying to get some variables.
    Some pointers may be invalid and cause the dump to abort.
    Query (7fb47d31a828): SHOW INDEXES FROM catalog_category_product_index_tmp WHERE `Non_unique` = 1
    Connection ID (thread ID): 58
    Status: NOT_KILLED


    I am using Mac Os with mysql. Anyone can help me?









    share

























      0












      0








      0








      I used magento 2.3 and meet problem when run command upgrade.
      It shows:



      Warning: PDOStatement::execute(): MySQL server has gone away in vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php on line 228


      I try some solution about mysql variable as:




      max_allowed_packet=4000M
      and wait_timeout=6000




      However, nothing solve it.
      Just see the of sql:



      key_buffer_size=8388608
      read_buffer_size=131072
      max_used_connections=5
      max_threads=151
      thread_count=6
      connection_count=5
      It is possible that mysqld could use up to
      key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 67870 K bytes of memory
      Hope that's ok; if not, decrease some variables in the equation.

      Thread pointer: 0x7fb47d30cc00
      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...
      stack_bottom = 700002904e90 thread_stack 0x46000
      0 mysqld 0x000000010f38a5ec my_print_stacktrace(unsigned char*, unsigned long) + 60
      1 mysqld 0x000000010e7e7e76 handle_fatal_signal + 678
      2 libsystem_platform.dylib 0x00007fff66a1cf5a _sigtramp + 26
      3 ??? 0x00007000029011e8 0x0 + 123145345307112
      4 libsystem_c.dylib 0x00007fff667ba1ae abort + 127
      5 mysqld 0x000000010f71707c ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 252
      6 mysqld 0x000000010f6b3542 row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) + 4002
      7 mysqld 0x000000010f58ffd1 ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function) + 657
      8 mysqld 0x000000010e3e8389 handler::ha_index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function) + 233
      9 mysqld 0x000000010e65ec30 join_read_key(QEP_TAB*) + 464
      10 mysqld 0x000000010e65aa28 sub_select(JOIN*, QEP_TAB*, bool) + 728
      11 mysqld 0x000000010e65b0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602
      12 mysqld 0x000000010e65aae1 sub_select(JOIN*, QEP_TAB*, bool) + 913
      13 mysqld 0x000000010e65b0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602
      14 mysqld 0x000000010e65aae1 sub_select(JOIN*, QEP_TAB*, bool) + 913
      15 mysqld 0x000000010e65b0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602
      16 mysqld 0x000000010e65aae1 sub_select(JOIN*, QEP_TAB*, bool) + 913
      17 mysqld 0x000000010e65b0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602
      18 mysqld 0x000000010e65aae1 sub_select(JOIN*, QEP_TAB*, bool) + 913
      19 mysqld 0x000000010e65b0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602
      20 mysqld 0x000000010e65aae1 sub_select(JOIN*, QEP_TAB*, bool) + 913
      21 mysqld 0x000000010e65b0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602
      22 mysqld 0x000000010e65aae1 sub_select(JOIN*, QEP_TAB*, bool) + 913
      23 mysqld 0x000000010e6557da JOIN::exec() + 858
      24 mysqld 0x000000010e6ee8c1 handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) + 545
      25 mysqld 0x000000010e6b1420 execute_show(THD*, TABLE_LIST*) + 624
      26 mysqld 0x000000010e61e55a Sql_cmd_show::execute(THD*) + 74
      27 mysqld 0x000000010e6abc51 mysql_execute_command(THD*, bool) + 3473
      28 mysqld 0x000000010e6a9af6 mysql_parse(THD*, Parser_state*) + 886
      29 mysqld 0x000000010e6a8408 dispatch_command(THD*, COM_DATA const*, enum_server_command) + 7544
      30 mysqld 0x000000010e6a9363 do_command(THD*) + 467
      31 mysqld 0x000000010e7d10e4 handle_connection(void*) + 372
      32 mysqld 0x000000010f77ebbc pfs_spawn_thread(void*) + 316
      33 libsystem_pthread.dylib 0x00007fff66a26661 _pthread_body + 340
      34 libsystem_pthread.dylib 0x00007fff66a2650d _pthread_body + 0
      35 libsystem_pthread.dylib 0x00007fff66a25bf9 thread_start + 13

      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (7fb47d31a828): SHOW INDEXES FROM catalog_category_product_index_tmp WHERE `Non_unique` = 1
      Connection ID (thread ID): 58
      Status: NOT_KILLED


      I am using Mac Os with mysql. Anyone can help me?









      share














      I used magento 2.3 and meet problem when run command upgrade.
      It shows:



      Warning: PDOStatement::execute(): MySQL server has gone away in vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php on line 228


      I try some solution about mysql variable as:




      max_allowed_packet=4000M
      and wait_timeout=6000




      However, nothing solve it.
      Just see the of sql:



      key_buffer_size=8388608
      read_buffer_size=131072
      max_used_connections=5
      max_threads=151
      thread_count=6
      connection_count=5
      It is possible that mysqld could use up to
      key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 67870 K bytes of memory
      Hope that's ok; if not, decrease some variables in the equation.

      Thread pointer: 0x7fb47d30cc00
      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...
      stack_bottom = 700002904e90 thread_stack 0x46000
      0 mysqld 0x000000010f38a5ec my_print_stacktrace(unsigned char*, unsigned long) + 60
      1 mysqld 0x000000010e7e7e76 handle_fatal_signal + 678
      2 libsystem_platform.dylib 0x00007fff66a1cf5a _sigtramp + 26
      3 ??? 0x00007000029011e8 0x0 + 123145345307112
      4 libsystem_c.dylib 0x00007fff667ba1ae abort + 127
      5 mysqld 0x000000010f71707c ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 252
      6 mysqld 0x000000010f6b3542 row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) + 4002
      7 mysqld 0x000000010f58ffd1 ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function) + 657
      8 mysqld 0x000000010e3e8389 handler::ha_index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function) + 233
      9 mysqld 0x000000010e65ec30 join_read_key(QEP_TAB*) + 464
      10 mysqld 0x000000010e65aa28 sub_select(JOIN*, QEP_TAB*, bool) + 728
      11 mysqld 0x000000010e65b0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602
      12 mysqld 0x000000010e65aae1 sub_select(JOIN*, QEP_TAB*, bool) + 913
      13 mysqld 0x000000010e65b0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602
      14 mysqld 0x000000010e65aae1 sub_select(JOIN*, QEP_TAB*, bool) + 913
      15 mysqld 0x000000010e65b0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602
      16 mysqld 0x000000010e65aae1 sub_select(JOIN*, QEP_TAB*, bool) + 913
      17 mysqld 0x000000010e65b0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602
      18 mysqld 0x000000010e65aae1 sub_select(JOIN*, QEP_TAB*, bool) + 913
      19 mysqld 0x000000010e65b0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602
      20 mysqld 0x000000010e65aae1 sub_select(JOIN*, QEP_TAB*, bool) + 913
      21 mysqld 0x000000010e65b0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602
      22 mysqld 0x000000010e65aae1 sub_select(JOIN*, QEP_TAB*, bool) + 913
      23 mysqld 0x000000010e6557da JOIN::exec() + 858
      24 mysqld 0x000000010e6ee8c1 handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) + 545
      25 mysqld 0x000000010e6b1420 execute_show(THD*, TABLE_LIST*) + 624
      26 mysqld 0x000000010e61e55a Sql_cmd_show::execute(THD*) + 74
      27 mysqld 0x000000010e6abc51 mysql_execute_command(THD*, bool) + 3473
      28 mysqld 0x000000010e6a9af6 mysql_parse(THD*, Parser_state*) + 886
      29 mysqld 0x000000010e6a8408 dispatch_command(THD*, COM_DATA const*, enum_server_command) + 7544
      30 mysqld 0x000000010e6a9363 do_command(THD*) + 467
      31 mysqld 0x000000010e7d10e4 handle_connection(void*) + 372
      32 mysqld 0x000000010f77ebbc pfs_spawn_thread(void*) + 316
      33 libsystem_pthread.dylib 0x00007fff66a26661 _pthread_body + 340
      34 libsystem_pthread.dylib 0x00007fff66a2650d _pthread_body + 0
      35 libsystem_pthread.dylib 0x00007fff66a25bf9 thread_start + 13

      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (7fb47d31a828): SHOW INDEXES FROM catalog_category_product_index_tmp WHERE `Non_unique` = 1
      Connection ID (thread ID): 58
      Status: NOT_KILLED


      I am using Mac Os with mysql. Anyone can help me?







      database magento2.3 setup-upgrade





      share












      share










      share



      share










      asked 21 secs ago









      the lightthe light

      1




      1






















          0






          active

          oldest

          votes











          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "479"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f258235%2fmagento-2-3-setupupgrade-error-sql%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes
















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Magento Stack Exchange!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f258235%2fmagento-2-3-setupupgrade-error-sql%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Polycentropodidae

          Magento 2 Error message: Invalid state change requested

          Paulmy