Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
Deep Blue 76 Posted March 19, 2013 Posted March 19, 2013 I have a problem while using the product Invision Power Board 3.3.4 purchased from your website,I noticed from the logs in the admin panel and in the cache folder, which, almost daily, in my dedicated serverwhich has installed MySQL 5.1 and PHP 5.2.18 occur crashes of MYSQL, I am attaching the logs produced by your software, asking whether it can be a problemdue to a lack of hardware resources or to another type of error in the script, I am attaching also the hardware specifications of the dedicated server where the script is allocated.Looking forward to your response,Sincerely, P.S: The Hosting has sent me these parameters mysql to know what i need to change to the proper functioning of Invision Power Board in my dedicated server. [mysqld] datadir=/var/lib/mysql skip-locking #skip-innodb #skip-networking safe-show-database query_cache_limit=1M query_cache_size=32M ## 32MB for every 1GB of RAM query_cache_type=1 max_user_connections=400 max_connections=400 interactive_timeout=20 wait_timeout=20 connect_timeout=20 thread_cache_size=128 key_buffer=128M ## 128MB for every 1GB of RAM join_buffer=1M max_connect_errors=20 max_allowed_packet=16M table_cache=1024 tmp_table_size=64M record_buffer=1M sort_buffer_size=1M ## 1MB for every 1GB of RAM read_buffer_size=1M ## 1MB for every 1GB of RAM read_rnd_buffer_size=1M ## 1MB for every 1GB of RAM thread_concurrency=4 ## Number of CPUs x 2 myisam_sort_buffer_size=64M server-id=1 log_slow_queries=/var/log/mysql-slow-queries.log # Don't Forget To Do # touch /var/log/mysql-slow-queries.log # chown mysql.mysql /var/log/mysql-slow-queries.log long_query_time=2 collation-server=latin1_general_ci #[mysql.server] #user=mysql #basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/lib/mysql/mysql.pid open_files_limit=8192 [mysqldump] quick max_allowed_packet=16M [mysql] no-auto-rehash #safe-updates [isamchk] key_buffer=64M sort_buffer=64M read_buffer=16M write_buffer=16M [myisamchk] key_buffer=64M sort_buffer=64M read_buffer=16M write_buffer=16M [myisamchk] key_buffer=64M sort_buffer=64M read_buffer=16M write_buffer=16M [mysqlhotcopy] interactive-timeout Sql_error_logs.zip
Grumpy Posted March 19, 2013 Posted March 19, 2013 login via ssh. type "top", copy & paste everything here. (i mean everything, don't skip out bottom half or top half... it's amazing how many people skip either half...)
Deep Blue 76 Posted March 19, 2013 Author Posted March 19, 2013 root@server1 [/home]# top top - 14:18:18 up 18 days, 16:23, 2 users, load average: 0.04, 0.18, 0.23 Tasks: 147 total, 1 running, 143 sleeping, 1 stopped, 2 zombie Cpu(s): 0.1%us, 0.4%sy, 0.7%ni, 98.5%id, 0.3%wa, 0.0%hi, 0.1%si, 0.0%st Mem: 1026788k total, 961920k used, 64868k free, 24572k buffers Swap: 4095992k total, 119064k used, 3976928k free, 341036k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 32024 root 24 8 400384 176m 6384 S 0.0 17.6 0:13.95 /usr/sbin/clamd 12973 mysql 21 6 360448 74m 4284 S 2.0 7.4 1:01.23 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/server1.wehostdns.com.err --open-files-limit=8192 --pid-file=/var/lib/mysql/server 4549 root 34 19 257024 3480 1572 S 0.0 0.3 14:22.80 /usr/bin/python -tt /usr/sbin/yum-updatesd 27773 nobody 20 4 254976 30m 14m S 0.0 3.1 0:00.87 /usr/local/apache/bin/httpd -k start -DSSL 27817 nobody 19 4 253952 30m 12m R 0.0 3.0 0:00.56 /usr/local/apache/bin/httpd -k start -DSSL 27860 nobody 19 4 252928 28m 13m S 0.0 2.8 0:00.41 /usr/local/apache/bin/httpd -k start -DSSL 27818 nobody 20 4 252928 29m 14m S 0.0 2.9 0:00.71 /usr/local/apache/bin/httpd -k start -DSSL 27777 nobody 20 4 252928 27m 10m R 11.8 2.7 0:00.62 /usr/local/apache/bin/httpd -k start -DSSL 27806 nobody 19 4 251904 27m 11m S 0.0 2.8 0:00.42 /usr/local/apache/bin/httpd -k start -DSSL 27778 nobody 19 4 250880 26m 11m S 0.0 2.7 0:00.30 /usr/local/apache/bin/httpd -k start -DSSL 27862 nobody 19 4 249856 21m 8044 S 0.0 2.2 0:00.07 /usr/local/apache/bin/httpd -k start -DSSL 600 root 19 4 191488 18m 8520 S 2.0 1.9 434:04.12 /usr/local/apache/bin/httpd -k start -DSSL 27976 nobody 21 4 191488 11m 900 S 0.0 1.1 0:00.00 /usr/local/apache/bin/httpd -k start -DSSL 27975 nobody 19 4 191488 11m 900 S 0.0 1.1 0:00.00 /usr/local/apache/bin/httpd -k start -DSSL 27968 nobody 19 4 191488 11m 900 S 0.0 1.1 0:00.00 /usr/local/apache/bin/httpd -k start -DSSL 27943 nobody 19 4 191488 13m 3076 S 0.0 1.3 0:00.01 /usr/local/apache/bin/httpd -k start -DSSL 27923 nobody 19 4 191488 12m 1808 S 0.0 1.2 0:00.01 /usr/local/apache/bin/httpd -k start -DSSL 4444 named 25 0 185344 2444 1180 S 0.0 0.2 0:09.90 /usr/sbin/named -u named -t /var/named/chroot 18951 root 21 4 155648 9m 236 S 0.0 1.0 0:00.00 /usr/local/apache/bin/httpd -k start -DSSL 5465 root 18 0 147456 41m 1488 S 0.0 4.1 2:46.02 lfd - sleeping 9218 root 24 8 136192 59m 2888 S 0.0 6.0 2:57.96 spamd child 9195 root 23 8 123904 47m 2452 S 0.0 4.8 0:01.66 /usr/local/bin/spamd -d --allowed-ips=127.0.0.1 --pidfile=/var/run/spamd.pid --max-children=3 --max-spare=1 27972 root 15 0 108544 680 604 S 0.0 0.1 0:00.00 sort -rn -k5 26005 root 16 0 106496 16m 3068 S 0.0 1.6 0:00.37 sshd: root@pts/0 30288 root 15 0 94292 2368 2212 S 0.0 0.2 0:43.18 sshd: root@pts/1 26536 root 15 0 94292 3464 2668 S 0.0 0.3 0:00.15 sshd: root@notty 4051 root 25 10 93376 592 516 S 0.0 0.1 1:08.71 pure-ftpd (SERVER) 4053 root 16 0 91004 824 780 S 0.0 0.1 1:43.49 /usr/sbin/pure-authd -s /var/run/ftpd.sock -r /usr/sbin/pureauth 4227 root 15 0 75088 4784 2052 S 0.0 0.5 16:26.41 cpsrvd (SSL) - waiting for c --llu=1362429233 --listen=3,4,5,6,7,8 4066 root 15 0 74820 1064 648 S 0.0 0.1 253:35.52 crond 30291 root 15 0 66444 1532 1196 S 0.0 0.1 6:20.79 -bash 26377 root 15 0 66068 1628 1204 S 0.0 0.2 0:01.80 -bash 27971 root 15 0 63908 896 768 S 0.0 0.1 0:00.00 awk { if ( $5 ~ /m/) {sub(/m/,"",$5);$5 = $5 * 1024} ; print } 12807 root 21 0 63844 1232 1008 S 0.0 0.1 0:00.55 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/server1.wehostdns.com.pid 26957 root 15 0 63560 848 712 T 0.0 0.1 0:00.01 less top-output.txt 3614 root 15 0 62672 652 552 S 0.0 0.1 10:01.40 /usr/sbin/sshd 31557 mailnull 23 8 59108 1072 620 S 0.0 0.1 0:55.94 /usr/sbin/exim -bd -q60m 27970 root 15 0 58920 516 444 S 0.0 0.1 0:00.00 tail -n+8 26552 root 16 0 54040 2128 1528 S 0.0 0.2 0:00.10 /usr/libexec/openssh/sftp-server 18944 root 25 8 49448 8912 2400 S 0.0 0.9 0:00.10 /usr/bin/perl /usr/local/cpanel/bin/leechprotect 3998 dovecot 15 0 39044 2292 1308 S 0.0 0.2 3:03.51 pop3-login 4001 dovecot 15 0 38904 2068 1308 S 0.0 0.2 0:29.24 pop3-login 3997 dovecot 15 0 38868 1860 1308 S 0.0 0.2 0:23.13 pop3-login 4000 dovecot 15 0 38648 1888 1328 S 0.0 0.2 0:12.62 pop3-login 3999 dovecot 15 0 38624 1876 1308 S 0.0 0.2 0:15.90 pop3-login 4002 dovecot 15 0 38336 1568 1352 S 0.0 0.2 0:01.77 imap-login 4006 dovecot 15 0 38332 1548 1340 S 0.0 0.2 0:00.61 imap-login 4003 dovecot 15 0 38332 1448 1320 S 0.0 0.1 0:00.39 imap-login 4004 dovecot 15 0 38324 1572 1320 S 0.0 0.2 0:03.47 imap-login 4005 dovecot 15 0 38240 1452 1320 S 0.0 0.1 0:00.97 imap-login 3516 dbus 15 0 31616 1044 832 S 0.0 0.1 0:01.77 dbus-daemon --system 3552 haldaemo 15 0 31008 1396 996 S 0.0 0.1 3:09.77 hald 8331 root 24 8 29540 1528 948 S 0.0 0.1 0:04.03 queueprocd - wait to process a task 1760 root 11 -10 28684 22m 1732 S 0.0 2.2 0:00.02 iscsiuio 2337 root 15 0 28436 416 320 S 0.0 0.0 0:01.13 /usr/sbin/restorecond 8348 root 23 8 27188 2852 1024 S 0.0 0.3 0:40.31 tailwatchd 8364 root 34 19 26096 1200 676 S 0.0 0.1 18:31.14 cpanellogd - sleeping for logs 4290 avahi 15 0 23292 940 844 S 0.0 0.1 0:00.34 avahi-daemon: running [server1.local] 4292 avahi 18 0 23164 136 132 S 0.0 0.0 0:00.00 avahi-daemon: chroot helper 3553 root 15 0 21708 692 688 S 0.0 0.1 0:00.13 hald-runner 4096 xfs 15 0 20264 588 552 S 0.0 0.1 0:00.00 xfs -droppriv -daemon 3982 root 15 0 19336 1044 808 S 0.0 0.1 31:29.65 dovecot-auth 4109 root 18 0 18740 400 352 S 0.0 0.0 1:26.70 /usr/sbin/atd 1889 root 15 0 14568 464 396 S 0.0 0.0 1:46.61 mcstransd 531 root 15 -4 13712 432 428 S 0.0 0.0 0:06.47 /sbin/udevd -d 4551 root 34 19 12928 960 800 S 0.0 0.1 0:01.79 /usr/libexec/gam_server 13070 root 16 0 12748 1160 832 S 0.0 0.1 0:18.10 top 27969 root 15 0 12744 1048 752 R 2.0 0.1 0:00.01 top -cSb n 1 3981 root 15 0 12420 608 428 S 0.0 0.1 10:03.44 /usr/sbin/dovecot 3567 haldaemo 18 0 12332 704 700 S 0.0 0.1 0:00.00 hald-addon-keyboard: listening on /dev/input/event0 3563 haldaemo 18 0 12332 692 688 S 0.0 0.1 0:00.00 hald-addon-acpi: listening on acpi kernel interface /proc/acpi/event 3467 root 15 0 10684 904 716 S 2.0 0.1 34:11.47 /usr/sbin/vmware-guestd --background /var/run/vmware-guestd.pid 1 root 15 0 10356 600 564 S 0.0 0.1 1867:58 init [3] 3575 root 16 0 10240 616 548 S 0.0 0.1 8:29.50 hald-addon-storage: polling /dev/hda 2350 root 16 0 5916 552 496 S 0.0 0.1 0:44.84 syslogd -m 0 1766 root 5 -10 5080 3032 1892 S 0.0 0.3 0:01.51 iscsid 1765 root 15 0 4580 384 360 S 0.0 0.0 0:00.56 iscsid 2353 root 15 0 3812 396 340 S 0.0 0.0 0:09.79 klogd -x 4311 root 20 0 3800 416 412 S 0.0 0.0 0:00.00 /sbin/mingetty tty6 4310 root 18 0 3800 416 412 S 0.0 0.0 0:00.00 /sbin/mingetty tty5 4309 root 18 0 3800 416 412 S 0.0 0.0 0:00.00 /sbin/mingetty tty4 4308 root 18 0 3800 416 412 S 0.0 0.0 0:00.00 /sbin/mingetty tty3 4307 root 18 0 3800 416 412 S 0.0 0.0 0:00.00 /sbin/mingetty tty2 4305 root 17 0 3800 416 412 S 0.0 0.0 0:00.00 /sbin/mingetty tty1 9 root 34 19 0 0 0 S 0.0 0.0 0:00.84 [ksoftirqd/3] 99 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 [kseriod] 97 root 16 -5 0 0 0 S 0.0 0.0 0:00.00 [khubd] 94 root 17 -5 0 0 0 S 0.0 0.0 0:00.00 [cqueue/3] 93 root 17 -5 0 0 0 S 0.0 0.0 0:00.00 [cqueue/2] 92 root 17 -5 0 0 0 S 0.0 0.0 0:00.00 [cqueue/1] 91 root 16 -5 0 0 0 S 0.0 0.0 0:00.00 [cqueue/0] 8 root RT -5 0 0 0 S 0.0 0.0 0:11.50 [migration/3] 8940 root 15 0 0 0 0 S 0.0 0.0 0:22.82 [pdflush] 7 root 34 19 0 0 0 S 0.0 0.0 0:00.73 [ksoftirqd/2] 6 root RT -5 0 0 0 S 0.0 0.0 0:12.01 [migration/2] 5 root 34 19 0 0 0 S 0.0 0.0 0:00.84 [ksoftirqd/1] 4 root RT -5 0 0 0 S 0.0 0.0 0:11.85 [migration/1] 498 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 [kauditd] 468 root 10 -5 0 0 0 S 0.0 0.0 19:08.88 [kjournald] 445 root 16 -5 0 0 0 S 0.0 0.0 0:00.00 [ksnapd] 424 root 14 -5 0 0 0 S 0.0 0.0 0:00.00 [kstriped] 413 root 14 -5 0 0 0 S 0.0 0.0 0:00.00 [ata_aux] 412 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 [ata/3] 411 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 [ata/2] 410 root 14 -5 0 0 0 S 0.0 0.0 0:00.00 [ata/1] 409 root 14 -5 0 0 0 S 0.0 0.0 0:00.00 [ata/0] 403 root 14 -5 0 0 0 S 0.0 0.0 0:00.00 [scsi_eh_0] 402 root 10 -5 0 0 0 S 0.0 0.0 0:00.20 [mpt_poll_0] 3 root 34 19 0 0 0 S 0.0 0.0 0:00.55 [ksoftirqd/0] 34 root 16 -5 0 0 0 S 0.0 0.0 0:00.00 [kacpid] 3436 root 15 0 0 0 0 S 0.0 0.0 0:00.32 [vmmemctl] 33 root 10 -5 0 0 0 S 0.0 0.0 0:01.64 [kblockd/3] 333 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 [kpsmoused] 32 root 10 -5 0 0 0 S 0.0 0.0 0:01.33 [kblockd/2] 31 root 10 -5 0 0 0 S 0.0 0.0 0:01.41 [kblockd/1] 30 root 10 -5 0 0 0 S 0.0 0.0 0:26.26 [kblockd/0] 2 root RT -5 0 0 0 S 0.0 0.0 0:11.56 [migration/0] 23 root 12 -5 0 0 0 S 0.0 0.0 0:00.01 [kthread] 191 root 16 -5 0 0 0 S 0.0 0.0 0:00.00 [aio/3] 190 root 16 -5 0 0 0 S 0.0 0.0 0:00.00 [aio/2] 189 root 16 -5 0 0 0 S 0.0 0.0 0:00.00 [aio/1] 188 root 16 -5 0 0 0 S 0.0 0.0 0:00.00 [aio/0] 187 root 10 -5 0 0 0 S 0.0 0.0 2:29.82 [kswapd0] 1747 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 [rdma_cm] 1741 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 [ib_cm/3] 1740 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 [ib_cm/2] 1739 root 18 -5 0 0 0 S 0.0 0.0 0:00.00 [ib_cm/1] 1738 root 17 -5 0 0 0 S 0.0 0.0 0:00.00 [ib_cm/0] 1732 root 16 -5 0 0 0 S 0.0 0.0 0:00.00 [iw_cm_wq] 1727 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 [local_sa] 1726 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 [ib_inform] 1724 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 [ib_mcast] 1708 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 [ib_addr] 1621 root 12 -5 0 0 0 S 0.0 0.0 0:00.00 [iscsi_eh] 1595 root 10 -5 0 0 0 S 0.0 0.0 0:10.79 [kjournald] 1594 root 0 -20 0 0 0 S 0.0 0.0 1:13.26 [loop0] 14 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 [khelper] 14826 root 15 0 0 0 0 S 0.0 0.0 0:28.41 [pdflush] 1424 root 10 -5 0 0 0 S 0.0 0.0 0:00.39 [kjournald] 1422 root 10 -5 0 0 0 S 0.0 0.0 0:10.03 [kjournald] 1420 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 [kjournald] 13 root 10 -5 0 0 0 S 0.0 0.0 0:01.56 [events/3] 1398 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 [kmpath_handlerd] 1397 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 [kmpathd/3] 1396 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 [kmpathd/2] 1394 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 [kmpathd/1] 1393 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 [kmpathd/0] 12 root 10 -5 0 0 0 S 0.0 0.0 0:01.64 [events/2] 11 root 10 -5 0 0 0 S 0.0 0.0 0:01.54 [events/1] 10 root 10 -5 0 0 0 S 0.0 0.0 23:39.02 [events/0]
Grumpy Posted March 19, 2013 Posted March 19, 2013 I don't see anything wrong. Some possibilities of causes are (no particular order) in my view: bug with mysql. You can try updating. Running a pretty old version. OS limit on connections. mysql limit on connections. You have it at 400. We can raise that or cut off bad connections faster by reducing timeouts. You can see if this is an issue by running mysql tuner. (https://raw.github.com/rackerhacker/MySQLTuner-perl/master/mysqltuner.pl) Might wanna look up tutorial online if confused. You can also check if you are getting any errors being reported in os logs. /var/log/messages (example if you have rhel/centos/fedora/scientific linux/cloudlinux) As stupid as it sounds, you might even want to try rebooting. lol
Deep Blue 76 Posted March 19, 2013 Author Posted March 19, 2013 I've just looked log you've mentioned but there's no trace about sql gone away or die error in messages file.
Grumpy Posted March 22, 2013 Posted March 22, 2013 I've just looked log you've mentioned but there's no trace about sql gone away or die error in messages file. That log isn't for php trace logs or anything php related. It's OS raised errors or issues OS wants you to know about.
p4guru Posted March 22, 2013 Posted March 22, 2013 99% of time, one my.cnf variable is responsible for such errors and a simple google search reveals which one http://lmgtfy.com/?q=%22MySQL+Error%3A+MySQL+server+has+gone+away%22+%2B+%22wait_timeout%22+%2B+%22my.cnf%22+%2B+%22Lost+connection%22 ;) yes it's wait_timeout - too low a value set ;)
p4guru Posted March 22, 2013 Posted March 22, 2013 I've just looked log you've mentioned but there's no trace about sql gone away or die error in messages file. I see them clearly in the logs attached in first post :smile: looks like attachments taking longer than >20 seconds timing out mysql before completion Date: Mon, 11 Mar 2013 13:45:25 +0000 Error: 2006 - MySQL server has gone away IP Address: 87.3.203.131 - /forum/index.php?app=core&module=attach§ion=attach&attach_id=469200 possible slow queries/table locking probably also eating your mysql and mysql per user connection limits as Grumpy stated Date: Mon, 11 Mar 2013 22:04:56 +0000 Error: 1203 - User root already has more than 'max_user_connections' active connections IP Address: 87.8.125.252 - /forum/index.php?app=core&module=search&do=viewNewContent&period=unread&userMode=&search_app=forums&sid=e32c4630cba7d6d8d5917f5e014b2a1d&search_app_filters[forums][searchInKey]=&st=25 But reducing timeouts will actually make things worse (for server gone away errors). You need to get to the root problems of what is causing queries to take longer than 20 seconds to complete. Tools for diagnosis http://community.invisionpower.com/topic/362126-tools-commands-to-diagnose-problems/
Recommended Posts
Archived
This topic is now archived and is closed to further replies.