Ttdfjt

Why is a statement like 1 + n *= 3 allowed in Ruby?

50-move rule: only the last 50 or any consecutive 50?

Is the internet in Madagascar faster than in UK?

Why does Windows store Wi-Fi passwords in a reversible format?

Count the number of shortest paths to n

Unlock your Lock

Reusing studs to hang shoe bins

Why is sh (not bash) complaining about functions defined in my .bashrc?

Why is the UK so keen to remove the "backstop" when their leadership seems to think that no border will be needed in Northern Ireland?

1mth baby boy keeps peeing through diapers, sometimes diper seems practically unused

Can you help me identify this aircraft?

rationalizing sieges in a modern/near-future setting

Why is the winner of Pow different everytime?

What is the loud noise of a helicopter when the rotors are not yet moving?

Changing JPEG to RAW to use on Lightroom?

How is linear momentum conserved in case of a freely falling body?

What is this fighter jet at Weymouth NAS?

Talk interpreter

Weird corners with cline

What is the name of this plot that has rows with two connected dots?

How to actually concatenate two Strings?

Why is strlen so complex in C?

Thought experiment and possible contradiction between electromagnetism and special relativity

Does a Mace of Disruption's Frightened effect override undead immunity to the Frightened condition?

Magento 2 Migration: Communication link failure: 1153 Got a packet bigger than 'max_allowed_packet' bytes

Source fields are not mapped - migration errorMigration magento 1 to magento 2Magento migration SQL errorMagento 2 Migration Error (eav_attribute)Warning: Error while sending QUERY packet. - Magento MigrationMagento Migration errorMagento 2.3.2 Failed to load the “Magento_Checkout/js/view/billing-address/list” component

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

In Map Step some time after below type error showing

Communication link failure: 1153 Got a packet bigger than
'max_allowed_packet' bytes

Source Magento : 1.9.3.3

Destination Magento : 2.3.2

How can solve above error

Any help would be appreciated.

Thanks.

migration magento2.3.2 magento-1.9.3.3

share|improve this question

edited Aug 14 at 13:43

Sumit

51511 silver badge1414 bronze badges

asked Aug 14 at 11:26

Rakesh DongaRakesh Donga

3,05566 silver badges2525 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  reference link=> stackoverflow.com/questions/93128/…
  
  – Savan Patel
  Aug 14 at 11:28
  
  

  
  
  
  

add a comment | 

0

In Map Step some time after below type error showing

Communication link failure: 1153 Got a packet bigger than
'max_allowed_packet' bytes

Source Magento : 1.9.3.3

Destination Magento : 2.3.2

How can solve above error

Any help would be appreciated.

Thanks.

migration magento2.3.2 magento-1.9.3.3

share|improve this question

edited Aug 14 at 13:43

Sumit

51511 silver badge1414 bronze badges

asked Aug 14 at 11:26

Rakesh DongaRakesh Donga

3,05566 silver badges2525 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  reference link=> stackoverflow.com/questions/93128/…
  
  – Savan Patel
  Aug 14 at 11:28
  
  

  
  
  
  

add a comment | 

In Map Step some time after below type error showing

Communication link failure: 1153 Got a packet bigger than
'max_allowed_packet' bytes

Source Magento : 1.9.3.3

Destination Magento : 2.3.2

How can solve above error

Any help would be appreciated.

Thanks.

migration magento2.3.2 magento-1.9.3.3

share|improve this question

edited Aug 14 at 13:43

Sumit

51511 silver badge1414 bronze badges

asked Aug 14 at 11:26

Rakesh DongaRakesh Donga

3,05566 silver badges2525 bronze badges

share|improve this question

edited Aug 14 at 13:43

Sumit

51511 silver badge1414 bronze badges

asked Aug 14 at 11:26

Rakesh DongaRakesh Donga

3,05566 silver badges2525 bronze badges

share|improve this question

edited Aug 14 at 13:43

Sumit

51511 silver badge1414 bronze badges

asked Aug 14 at 11:26

Rakesh DongaRakesh Donga

3,05566 silver badges2525 bronze badges

edited Aug 14 at 13:43

Sumit

51511 silver badge1414 bronze badges

edited Aug 14 at 13:43

Sumit

51511 silver badge1414 bronze badges

asked Aug 14 at 11:26

Rakesh DongaRakesh Donga

3,05566 silver badges2525 bronze badges

asked Aug 14 at 11:26

Rakesh DongaRakesh Donga

3,05566 silver badges2525 bronze badges

1 Answer
1

active

oldest

votes

0

I've faced the same issue while migration.

You can fix this issue by following the below steps:

Change the MySQL max_pocket_size from the MySQL console to
1000000000.

run below query in MySQL console:

set global net_buffer_length=1000000;
set global max_allowed_packet=1000000000;

Hope it'll help!

share|improve this answer

edited Aug 14 at 11:34

Savan Patel

1,12044 silver badges2222 bronze badges

answered Aug 14 at 11:32

SumitSumit

51511 silver badge1414 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i have tried that not working for me
  
  – Rakesh Donga
  Aug 14 at 12:22
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Also, change my.cnf or my.ini file under the mysqld section and set: max_allowed_packet=100M
  
  – Sumit
  Aug 14 at 12:39
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i have changed that two time but still not working for me
  
  – Rakesh Donga
  Aug 14 at 12:42
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Restart the MySQL server and apache 2.
  
  – Sumit
  Aug 14 at 12:44
  

  
  
  
  

add a comment | 

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

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f285467%2fmagento-2-migration-communication-link-failure-1153-got-a-packet-bigger-than%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

I've faced the same issue while migration.

You can fix this issue by following the below steps:

Change the MySQL max_pocket_size from the MySQL console to
1000000000.

run below query in MySQL console:

set global net_buffer_length=1000000;
set global max_allowed_packet=1000000000;

Hope it'll help!

share|improve this answer

edited Aug 14 at 11:34

Savan Patel

1,12044 silver badges2222 bronze badges

answered Aug 14 at 11:32

SumitSumit

51511 silver badge1414 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i have tried that not working for me
  
  – Rakesh Donga
  Aug 14 at 12:22
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Also, change my.cnf or my.ini file under the mysqld section and set: max_allowed_packet=100M
  
  – Sumit
  Aug 14 at 12:39
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i have changed that two time but still not working for me
  
  – Rakesh Donga
  Aug 14 at 12:42
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Restart the MySQL server and apache 2.
  
  – Sumit
  Aug 14 at 12:44
  

  
  
  
  

add a comment | 

0

I've faced the same issue while migration.

You can fix this issue by following the below steps:

Change the MySQL max_pocket_size from the MySQL console to
1000000000.

run below query in MySQL console:

set global net_buffer_length=1000000;
set global max_allowed_packet=1000000000;

Hope it'll help!

share|improve this answer

edited Aug 14 at 11:34

Savan Patel

1,12044 silver badges2222 bronze badges

answered Aug 14 at 11:32

SumitSumit

51511 silver badge1414 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i have tried that not working for me
  
  – Rakesh Donga
  Aug 14 at 12:22
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Also, change my.cnf or my.ini file under the mysqld section and set: max_allowed_packet=100M
  
  – Sumit
  Aug 14 at 12:39
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i have changed that two time but still not working for me
  
  – Rakesh Donga
  Aug 14 at 12:42
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Restart the MySQL server and apache 2.
  
  – Sumit
  Aug 14 at 12:44
  

  
  
  
  

add a comment | 

I've faced the same issue while migration.

You can fix this issue by following the below steps:

Change the MySQL max_pocket_size from the MySQL console to
1000000000.

run below query in MySQL console:

set global net_buffer_length=1000000;
set global max_allowed_packet=1000000000;

Hope it'll help!

share|improve this answer

edited Aug 14 at 11:34

Savan Patel

1,12044 silver badges2222 bronze badges

answered Aug 14 at 11:32

SumitSumit

51511 silver badge1414 bronze badges

set global net_buffer_length=1000000;
set global max_allowed_packet=1000000000;

share|improve this answer

edited Aug 14 at 11:34

Savan Patel

1,12044 silver badges2222 bronze badges

answered Aug 14 at 11:32

SumitSumit

51511 silver badge1414 bronze badges

edited Aug 14 at 11:34

Savan Patel

1,12044 silver badges2222 bronze badges

edited Aug 14 at 11:34

Savan Patel

1,12044 silver badges2222 bronze badges

answered Aug 14 at 11:32

SumitSumit

51511 silver badge1414 bronze badges

answered Aug 14 at 11:32

SumitSumit

51511 silver badge1414 bronze badges