Jump to content


sql log had 112GB and killed my sevrer


6 replies to this topic

#1 zabby

    Advanced Member

  • Members
  • PipPipPip
  • 54 posts

Posted 13 April 2018 - 12:20 PM

tons on entries like this - where can i disable this things....



Got a packet bigger than 'max_allowed_packet' bytes
SQL: REPLACE INTO `lz_neudata_cache` (`key`, `data`, `time`) VALUES ('113','lots of data here ...

#2 zabby

    Advanced Member

  • Members
  • PipPipPip
  • 54 posts

Posted 13 April 2018 - 01:00 PM

and where is this huge data coming from?

#3 zabby

    Advanced Member

  • Members
  • PipPipPip
  • 54 posts

Posted 13 April 2018 - 06:34 PM

i have set in mysql the
max_allowed_packet=4M (from 1M)

now the error has gone away...
but you should REALLY set a MAX size of logfiles... killed whole server ;)

what max_allowed_packet does livezilla needs?

#4 Patrick Keil

    Administrator

  • Administrators
  • 3616 posts
  • LocationSingen, Germany

Posted 17 April 2018 - 07:15 AM

Hi Zabby,

Thanks for bringing this to our attention.

Quote

but you should REALLY set a MAX size of logfiles
Agreed, we will check that asap.

The required packet size depends on your actual workloads (amount of operators, visitors, etc.). The query causing this problem saves the aggregated list of operators into the caching table. More operators will result into larger queries. I would like to check the SQL payload but the query posted was incomplete and I couldn't decrypt it.

Can you provide the whole SQL query via email or PM (it includes sensitive data so please don't post here)?

Thanks.

#5 Patrick Keil

    Administrator

  • Administrators
  • 3616 posts
  • LocationSingen, Germany

Posted 17 April 2018 - 07:34 AM

We tested this and the LiveZilla log files are already limited to 5MB.

You must be referring to your webservers MySQL logs. Please note that we don't have influence on your mysql configuration, we can't set a global file size limit from application level. You will have to set such a log file size limit in your servers mysql config.

#6 zabby

    Advanced Member

  • Members
  • PipPipPip
  • 54 posts

Posted 17 April 2018 - 12:46 PM

i saw that the your logfile was always jumping between 0 and 5mb...
but there has to be a bug because suddenly it was 120GB....
what if ONE entry has over 5mb? maybe there is a bug?
i set max_allowed_packet=4M and now i am not getting those errors anymore... i deleted also the logfile, so i cannot send it to you know :(

#7 Patrick Keil

    Administrator

  • Administrators
  • 3616 posts
  • LocationSingen, Germany

Posted 17 April 2018 - 12:55 PM

Thanks for the clarification, we will check again.





1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users