Wordpress Problem when add new site wordpress site

To troubleshoot, you need to check the the wp vhost log at /root/centminlogs and instructions under Sharing logs and errors heading for using Pastebin.com or Gists to share a sanitised version of the contents of the initial install log.

Also post output for the following

Code (Text):

php -v
php --ini
php --m

 

Code (Text):

PHP Warning:  Error while sending QUERY packet. PID=24133 in /home/nginx/domains/mysite.com/public/wp-includes/wp-db.php on line 1858

Actually line 1858 of wp-includes/wp-db.php is mysql query related at WordPress/wp-db.php at 4.6 · WordPress/WordPress · GitHub so probably your mysql server was slow and/or busy that's why

did it eventually install and setup wordpress for you though ?

 

I see. Do you have any automated wordpress database backup scripts or wp backup plugins scheduled around that time ? could be locking your mysql server during backups so the query needed to wait until backups completed

log and output for commands posted at Problem when add new site wordpress site | Centmin Mod Community ?

 

btw, do you have wordfence wp plugin installed ? Topic: Error message « WordPress.org Forums

 

Also what's output of this command (wrap in CODE tags)

Code (Text):

mysqladmin var | egrep "^\| max_allowed_packet|^\| wait_timeout" | tr -s ' '

 

looks okay to me for max_allowed_packet but depends on size of all your mysql databases

what do you get when you manually run these commands for wp-cli

Code (Text):

cd /home/nginx/domains/mysite.com/public
/usr/bin/wp --info --allow-root
/usr/bin/wp plugin status --allow-root
/usr/bin/wp db query "show tables;" --allow-root

for last query you can mask the table prefix_ if you want

 

added one more command to Wordpress - Problem when add new site wordpress site | Centmin Mod Community

 

have you tried updating to php 5.6.25 ?

 

ah so could of been php bug !

to list cronjobs and then invoke the nano text editor to edit the cronjobs.. exiting nano will save and update your cronjobs

Code (Text):

crontab -l
crontab -e

also there's a wp uninstall script generated in output of centmin.sh menu option 22 which should remove stuff too

from Wordpress Nginx Auto Installer (WP Super Cache)

Code (Text):

------------------------------------------------------------
Created uninstall script
/root/tools/wp_uninstall_newdomain2.com.sh
------------------------------------------------------------

where newdomain2.com is site domain name

running the script should remove all newdomain2.com related files including the cronjob and vhost config files except the database itself which you can do manually

you can check the contents of /root/tools/wp_uninstall_newdomain2.com.sh to see what gets removed to confirm

 

try editing /etc/my.cnf values to the following for these 2 items and restarting mysql server

Code (Text):

max_allowed_packet = 256M
wait_timeout = 3600

 

if it's still slow, you can re-run centmin.sh menu option 22 on new test domain, but before you do run open a 2nd ssh window connection to your server and double check what mysql processlist is listing via these commands

create directory, /home/mysqlproclist change into it and create file named mysqlproc.txt then run mysqladmin processlist command in a loop every 1s interval and save output to mysqlproc.txt file

Code (Text):

mkdir -p /home/mysqlproclist
cd /home/mysqlproclist
touch mysqlproc.txt
mysqladmin proc -i1 >> mysqlproc.txt

this will hang the last command while it saves mysql processlist every 1s interval to mysqlproc.txt file

then in the other ssh window run centmin.sh menu option 22 to completion.

then in mysqladmin ssh window hit CTRL+C to end that command

grab the contents of mysqlproc.txt and post contents of log to pastebin.com or gist.github.com (santised for db name(s) and username(s) as it lists all mysql queries being run for ALL databases on your server.

 

From your provided mysqlproc.txt and server load issues at the time, sounds like mysql query /load issues with your other wordpress and web app mysql using scripts at the same time. Centmin Mod is provided as is so optimisation of software related to web app usage is left to the end user.

Centmin Mod is provided as is, so troubleshooting load issues is left to end user to do. However, there's many linux tools and scripts that can help you figure out what was causing the load issues and when.

If you're providing info on this forum, more info might be helpful

1. What version of Centmin Mod ? .08 stable or .09 beta ? If .09 beta when was it installed and when was last time you updated ?
2. What's your VPS/Server hardware specifications ? cpu type ? memory available ? disk space ?
3. Who's your web host ? Different hosts have different limits for server resource usage and some are more restrictive that others so it could just be their resource usage policy you tripped which may or may not be restrictive. If restrictive, then real solution would be finding a better web host. If not restrictive, then it's finding out what caused high cpu load.

Tools and commands you will want to read up on and learn for basic system admin tasks and troubleshooting.

• 20 Command Line Tools to Monitor Linux Performance
• 13 Linux Performance Monitoring Tools - Part 2
• 80 Linux Monitoring Tools for SysAdmins - Server Density Blog
• Amazing ! 25 Linux Performance Monitoring Tools
• 20 Linux System Monitoring Tools Every SysAdmin Should Know
• My mysqlmymonlite.sh script can help with that mysqlmymonlite.sh Addon | Centmin Mod Community README text file has instructions for setting up a cronjob to email you reports i.e. every 10/15min or every hour.

Notes:

• Centmin Mod already installed Glances tool. It can be invoked from SSH command glances or top2. Official Glances site at nicolargo.github.io/glances/ and documentation here.