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 <ramanaraoeee@...> 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 <david.sitsky@...> 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 <ramanaraoeee@...> 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,
>> > <fh00003O4OwmcFPBS> 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.
>
|