Quantcast

Re: Got a packet bigger than 'max_allowed_packet'

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Got a packet bigger than 'max_allowed_packet'

David Sitsky
Administrator
I would also set this parameter in your SQL server config:
http://dev.mysql.com/doc/refman/5.5/en/packet-too-large.html

On Wed, Feb 8, 2012 at 9:43 PM, ramana rao <[hidden email]> wrote:

>
> Hi,
>
> I am getting below error.
>
> <!-- Source was not sent compressed. --> <h1>Software error:</h1>
> <pre>DBD::mysql::st execute failed: Got a packet bigger than
> 'max_allowed_packet' bytes at
> /var/www/codestriker-1.9.9/lib/Codestriker/Model/Topic.pm line 171,
> &lt;fh00003O4OwmcFPBS&gt; line 102064.
>
> </pre>
>
>
>
> When i checked my file i see blow information at .line: 65:
> /var/www/codestriker-1.9.9/lib/Codestriker/DB/MySQL.pm
>
> $dbh->do("SET max_allowed_packet=128000000");
>
>
>
> Please suggest what to do now.
>
> --
> Thanks & Regards
> K.Ramanarao.
>

------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
Codestriker-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/codestriker-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Got a packet bigger than 'max_allowed_packet'

David Sitsky
Administrator
I think that config option is supported for MySQL 5 and above, so it
should be fine.  I'd use 128M.

On Thu, Feb 9, 2012 at 4:06 PM, ramana rao <[hidden email]> wrote:

> Hi David,
>
> Thanks for help.
>
> Can i refer those steps for all versions ?
>
> I am using below version.
> -bash-3.2$ mysql -V
> mysql  Ver 14.14 Distrib 5.1.35, for unknown-linux-gnu (x86_64) using
> readline 5.1
>
> Shall i edit below entry directoly with 32M instead of 128000000 ?
>
> /var/www/codestriker-1.9.9/lib/Codestriker/DB/MySQL.pm
>>
>> $dbh->do("SET max_allowed_packet=128000000");
>
>
> Thanks,
> ramana
>
> On Thu, Feb 9, 2012 at 3:26 AM, David Sitsky <[hidden email]> wrote:
>>
>> I would also set this parameter in your SQL server config:
>> http://dev.mysql.com/doc/refman/5.5/en/packet-too-large.html
>>
>> On Wed, Feb 8, 2012 at 9:43 PM, ramana rao <[hidden email]> wrote:
>> >
>> > Hi,
>> >
>> > I am getting below error.
>> >
>> > <!-- Source was not sent compressed. --> <h1>Software error:</h1>
>> > <pre>DBD::mysql::st execute failed: Got a packet bigger than
>> > 'max_allowed_packet' bytes at
>> > /var/www/codestriker-1.9.9/lib/Codestriker/Model/Topic.pm line 171,
>> > &lt;fh00003O4OwmcFPBS&gt; line 102064.
>> >
>> > </pre>
>> >
>> >
>> >
>> > When i checked my file i see blow information at .line: 65:
>> > /var/www/codestriker-1.9.9/lib/Codestriker/DB/MySQL.pm
>> >
>> > $dbh->do("SET max_allowed_packet=128000000");
>> >
>> >
>> >
>> > Please suggest what to do now.
>> >
>> > --
>> > Thanks & Regards
>> > K.Ramanarao.
>> >
>
>
>
>
> --
> Thanks & Regards
> K.Ramanarao.
>

------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
Codestriker-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/codestriker-user
Loading...