Can't select more 1000 row when update WHM to latest version

congloi

• August 29, 2016 22:55

Hi My server and website run all is ok, but when WHM automatic update to latest version WHM 58.0 (build 24) get error in mysql Mysql: 10.0.26-MariaDB I can't query to get more 30000 row in one query, in last I query get 50000 or more is ok. what's wrong in there. help me thank you

• 

  cPanelMichael

  • August 30, 2016 17:09

  My server and website run all is ok, but when WHM automatic update to latest version WHM 58.0 (build 24) get error in mysql

  
  Hello, Could you let us know the specific error message you are receiving, and the steps you are taking to reproduce it? Also, do you notice any output to /var/lib/mysql/$hostname.err when this happens? Thank you.

  0
• 

  congloi

  • August 31, 2016 02:45

  Hello, Could you let us know the specific error message you are receiving, and the steps you are taking to reproduce it? Also, do you notice any output to /var/lib/mysql/$hostname.err when this happens? Thank you.

  
  Hi, no output error, only get response errror 500 and now any error show. no any error show at /var/lig/mysq temperature fix: Change select * from table to select (id, few column) from table and it's work. Query ok if select few column (not include column "contents" with large text). I think problem is apache or mysql not accep return big size data. So, how can config allow them can return with big size of data return. (pre server working ok, but new sever after update is meet this problem) thank you

  0
• 

  ruzbehraja

  • August 31, 2016 11:04

  Where are you trying this query? Have you tried it in PHPMyAdmin? What OS are you using? CloudLinux?

  0

Please sign in to leave a comment.