Re: [pmacct-discussion] Error: 'sql_multi_values' is too small (100). Try with a larger value

[Edward van Kuik]

I set mine to 1000.
Edward
On Sep 3, 2013 12:06 AM, "Chris Wilson"  wrote:

> Hi all,
>
> I tried to enable the sql_multi_values option, but setting it to a
> reasonable number of rows to insert at once (100) to avoid hitting the
> MySQL packet size limit. But I get these errors in the logs:
>
> Sep  2 17:59:01 microserver pmacctd[17603]: ERROR ( summary/mysql ):
> 'sql_multi_values' is too small (100). Try with a larger value.
>
> Sep  2 16:57:46 microserver pmacctd[17608]: ERROR ( inbound/mysql ): You
> have an error in your SQL syntax; check the manual that corresponds to your
> MySQL server version for the right syntax to use near 'VALUES
> (FROM_UNIXTIME(1378141141), FROM_UNIXTIME(1378141080), '00:1b:21:92:98:17'
> at line 1
>
> This looks like a bug to me? Surely it should be reasonable to insert up
> to 100 rows at a time (per SQL statement) instead of just 1?
>
> Cheers, Chris.
> --
> Aptivate | http://www.aptivate.org | Phone: +44 1223 967 838
> Citylife House, Sturton Street, Cambridge, CB1 2QF, UK
>
> Aptivate is a not-for-profit company registered in England and Wales
> with company number 04980791.
>
>
> __**_
> pmacct-discussion mailing list
> http://www.pmacct.net/#**mailinglists
>
___
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists

[pmacct-discussion] Error: 'sql_multi_values' is too small (100). Try with a larger value

[Chris Wilson]

Hi all,

I tried to enable the sql_multi_values option, but setting it to a 
reasonable number of rows to insert at once (100) to avoid hitting the 
MySQL packet size limit. But I get these errors in the logs:


Sep  2 17:59:01 microserver pmacctd[17603]: ERROR ( summary/mysql ): 
'sql_multi_values' is too small (100). Try with a larger value.


Sep  2 16:57:46 microserver pmacctd[17608]: ERROR ( inbound/mysql ): You 
have an error in your SQL syntax; check the manual that corresponds to 
your MySQL server version for the right syntax to use near 'VALUES 
(FROM_UNIXTIME(1378141141), FROM_UNIXTIME(1378141080), '00:1b:21:92:98:17' 
at line 1


This looks like a bug to me? Surely it should be reasonable to insert 
up to 100 rows at a time (per SQL statement) instead of just 1?


Cheers, Chris.
--
Aptivate | http://www.aptivate.org | Phone: +44 1223 967 838
Citylife House, Sturton Street, Cambridge, CB1 2QF, UK

Aptivate is a not-for-profit company registered in England and Wales
with company number 04980791.


___
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists