Bug #5230 Data Dump/Update Failure
Submitted: 26 Aug 2004 15:09 Modified: 27 Sep 2004 13:22
Reporter: Aaron Palmer Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:1.0 OS:Windows (Win 2000)
Assigned to: CPU Architecture:Any

[26 Aug 2004 15:09] Aaron Palmer
Description:
eNrlWdty4kgSffdXZBCzOy9GXEy73QywgW0aHINtBvA4+mmjkAqpGiFpq0rG/Mbsfsd+42RmCQxt
bHfE3hw7DwYJlepy8uSpk+XeeHw7bsJFDS7qMOzdNKHxsXFCHw04/XhWPZpM8fFvR0cXv06a8MNV
0ATztzgT2kjtxWrmZVF2/AA177QO9Wr1pFKtV2qnUKs1q6fNxinEcvkJeo8Z/HB0vZ78MsT+vapX
r5bjNDy6m4zhdnIM3X7vZnoMv/ZwqHuVwFUPTr3q0ei624S616DLwYgeH99OqIMT7wyGKskfj4bd
m34TZFJWJi2fnX34VK4d8Sh5FggrQczS3P41N2CkBT9NrExs+8fWYHo97LQGve5l56h13Zt2t89K
1xN6SOPjNM/wo9b4cFaCRCxlG6fZG3ent+NOa3h18zNEWs7bpRLYdSbbVj7aim8MaBm3jV3H0kRS
2k6rUoxzfnv5Bb9G4MfCmHaULmUkRdD5czIz2U+DNF3IAO4y+KxMpJIQRjoNct/SSmWrMtp51Ujf
qjSJAi2DTgsjdHvT79xHa5jjq7BSNoJpJOGpy2maa1pBYuEyN1bqv7QqxWv7PYfY5NFu+xyqMMLW
cC/ponU+7gxxxvBZS0k3jUZ5YkUSGEjnOEYGv+QiVnYNExUrRFS6uZyrFD7H8vGf9A6tTsxiCdNV
CvdibbYzAXq8GXmSzi0MaLBuHKcrA1/SHIfAEZS/iNdwEYkklHCRxqk23y4G/6bd82EPfBnHk0z4
CGe7yncjEQR0V8epBTZql04//KkEOOswafu4eFzsLNWB1O0q9VLEbDoumixVEMSSfrnstK6u+xAx
Mu3a2QkY7bdLkbVZs1KJGPo8m7tYen66rKilCKWp2G0sygHHwpRr3tcsLBUzqjWquI7p5aFBGv/C
IPWDg+DH+IUFHqbEMypBbQf+Ytrf+2p9/1WeDH4w6vhNMewQKw7Fs74Xz5NNPD+dfVc83TQfutzQ
InXd6/XqPuLV7wU8xJRIZnkcS2u8UM23QNfgweCMZbv+JjyX55PB3ckWkiacxzlKWBJQPj3gSp4B
6HHOUK77lAiwVI8wx28bKQMu8IBXNsUEneP1HMeNXAuhQ2lRHUwmfSXNMY8z0yQ8lLgz4S+wG2Hp
/VWqMY1XhAkte5843yL5vwTwy+Du0w5+KBLaapkb+RJ0Oy0cgrhaAUtsAZF42PxIgIk4ZmWWeimS
HdyfOiAAjQsU4rwg8cN3QoXdrFG87DZK1NBFIpEywBikCSGPeEGAguj1tUTcaVCTIGAuJNgbsXkN
CTU0HkxilYGykNKAAr6qEGg74d6te8TqayKtlhlgb35uMa7KvuMAYgJ83AngfaTsGxmwCcRLDTgA
hiMQOlwZeQTURilGbQd4WEUycXuo0BIvEtxr1pQ9FHyOHQZ+M1dKsa9EFJWUy3AtH3HHg4lQsQFf
5NQnj4GtXNQRqlnqwdWc58LskswVIlVA9MDZrARpNbdYJOmKSRPmOLUghSS1QDwzC6WJAPcof27K
1GpGSK0EOp0IwxykqwSGEnmPNiMzOJMA05y4hqsJNOod4vQcXs565TqcZHpDp5lYIsNobQwOkQAN
lrezc79nQp0dJFQ/jYNDqnDvAN3TT5RVRE4lLqHWBB3RzjBCx5Rp2AidZsLw+sSWH+USIYK5TpeM
ZiAzG3lsy0Ia2bEQXalxg3FQSaXfcXL2bwd3teoOmn3qldG81WzHXlDZp3apa0fpxVlhSECXGZpZ
w9xG+OIcHxYcNIglUts5GA/OeXuiZ0/jhFoEcsf4csZ8O57Js+3ud0BC3i3i56PB3Yc9Q0AJSgsb
5TqL5WuO4O22bA2wJWIzx4piQ3jaeJDYMbrsXXGknrZqwzpF7/uxFJp4jdfkG4ouZxKFcYGcR4r7
mmuvwp+8Z7RRLBoH0R7L4DugdoUKLV87oTWWOYh6LEKhEoSEsXGgzsjcISaOrAyoM2GbDtDZkhnB
WkmSxUUkEyOo7qP9xdAvIU7HUZ8H02oh3zO894O7+iF360T5AL7THRl+Mrhs0aymn4PiZzaqbLdY
fBkSVF+mK26bXE7L2BSWDO3s4j3LLNLw9KDKvl0GvN12Q1PyHu7AgB0tMYg9iSBFTny5UdONf3l3
gFGdv+P8+7g3HQTt7SJgur/b7/p/J3g6jWOiEFtyVy85ykXkvzFftcs+boOLLFwEGoXfHmi/t4Qu
l0+4eR2zu3saYs9rJM5dOGfhbY4znpY5whyq1ZqwXelIJYvXkujA+lY0cw4/CXaEllEYOieaF6UJ
+U5VpNMMCfGAvo9PbFxlyc6QVsosy5dL7DWdQ7XhQdcs3PxR8fElfIDrdjUleaTEe+185t9bz7/G
x9Vq5f03OPl/EKw3kp4ODgOl27GlDFjHsl267o77Vzfl8VV/MG1CNXss/cdDMXolHN8zvaeAnWPA
6ocCxnvVcy1dobUUqvBFeDMvdNg4i7st+Z0rmEsnvYW5/Vmiq8JEnzvoUaBwx0NNRvTZa0lXApJa
cHhj3N7xITJgpviUlUs5sXKS88eL1gVF62QnWhf7ZzHOlb2cZM46kBkwxdEAlclCL5zfzXT6oJzx
ikTgnB22EVmGjpdzRfJpCpbDMTfD8s9tBLlvsYb5I+YPliu1xqH8eakEoWD8/R5Zzjondo9K/uHs
Hx1pOEcs+J8elBda+lI9kApSeU0aFkiDmHL9/tSZc8Z0zec0tFnzHUdto63PUlhJLM+tZHe5Z39G
rx1SFxsb/y/nd1xPLBg=

---------------------End of Data Chunk---------------------

ERROR: C1 C2 LEN: 4743 4744 6780
STR: ’

CVS: $Id: sqlparser.lib.php,v 1.62 2003/02/16 11:06:46 lem9 Exp $
MySQL: 4.0.20-log
USR OS, AGENT, VER: Win IE 6.0
PMA: 2.4.0
PHP VER,OS: 4.3.8 Linux
LANG: en-iso-8859-1
SQL: update about_us set content='

How to repeat:
Submit HUGE data into a field defined as "TEXT".

Suggested fix:
Increase allowable character limit??
[26 Aug 2004 15:10] Aaron Palmer
Typo fix :)
[27 Aug 2004 13:22] Hartmut Holzgraefe
I'm sorry but i do not really understand this report.
Could you please add the output of mysql_errno()
and mysql_error()?

It is most likely a matter of increasing max_allowed_packet,
see e.g.:

  http://dev.mysql.com/doc/mysql/en/Packet_too_large.html
[14 Feb 2005 22:54] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".