ERROR 502 - Crash during feed upload

ckoijun commented 6 years ago

Could be related to Issue #3

Site(cm) crashes after running a feed (banggood) upload.
Max Memory - 512M (Could it be increased?)
Probably cause: - Plugin Incompatiblity
- Duplicate products in Feed
- Duplicate products in Mysql DB (checked no issue) (deleted and re-run feed upload, it automatically gets duplicated again.)

ckoijun commented 6 years ago

For Reference comparemadness.com.au.error2.log

Generated after an import was halted, memory exhausted Note that MaxM is 512M. Max upload 128M

ckoijun commented 6 years ago

There is a problem with the mysqlDB. top log from March 18

top - 07:46:01 up 16 days, 2:36, 0 users, load average: 16.05, 15.33, 13.90 Tasks: 283 total, 17 running, 266 sleeping, 0 stopped, 0 zombie %Cpu(s): 1.1 us, 0.0 sy, 0.0 ni, 98.8 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st KiB Mem: 16460144 total, 9204152 used, 7255992 free, 212992 buffers KiB Swap: 11717628 total, 0 used, 11717628 free. 2791920 cached Mem

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 9991 furydea+ 20 0 639212 410352 12968 R 103.7 2.5 55:58.14 /usr/sbin/httpd -DFOREGROUND 18990 furydea+ 20 0 588008 358936 12856 R 103.7 2.2 46:44.58 /usr/sbin/httpd -DFOREGROUND 20359 furydea+ 20 0 484680 255644 12904 R 103.7 1.6 33:33.93 /usr/sbin/httpd -DFOREGROUND 20709 furydea+ 20 0 526408 296480 12100 R 103.7 1.8 39:10.54 /usr/sbin/httpd -DFOREGROUND 21103 furydea+ 20 0 440488 211008 12592 R 103.7 1.3 26:14.94 /usr/sbin/httpd -DFOREGROUND 21116 furydea+ 20 0 324276 95092 12844 R 103.7 0.6 7:37.20 /usr/sbin/httpd -DFOREGROUND 21620 furydea+ 20 0 303340 74212 12800 R 103.7 0.5 2:40.76 /usr/sbin/httpd -DFOREGROUND 4442 furydea+ 20 0 744880 515948 13004 R 98.0 3.1 130:18.43 /usr/sbin/httpd -DFOREGROUND 13459 furydea+ 20 0 549292 320796 13280 R 98.0 1.9 43:25.39 /usr/sbin/httpd -DFOREGROUND 17731 furydea+ 20 0 691912 462792 12964 R 98.0 2.8 58:16.07 /usr/sbin/httpd -DFOREGROUND 18994 furydea+ 20 0 505544 276272 12900 R 98.0 1.7 36:33.55 /usr/sbin/httpd -DFOREGROUND 18995 furydea+ 20 0 612408 383440 12900 R 98.0 2.3 49:38.52 /usr/sbin/httpd -DFOREGROUND 683 furydea+ 20 0 767952 539104 12964 R 92.2 3.3 252:30.54 /usr/sbin/httpd -DFOREGROUND 9984 furydea+ 20 0 665900 437372 13348 R 80.7 2.7 109:33.51 /usr/sbin/httpd -DFOREGROUND 9438 furydea+ 20 0 716748 487572 12968 R 69.2 3.0 137:46.56 /usr/sbin/httpd -DFOREGROUND 20175 compare 20 0 291784 63120 12856 S 51.9 0.4 0:34.82 /usr/sbin/httpd -DFOREGROUND 1159 mysql 20 0 913320 352848 12444 S 46.1 2.1 511:38.98 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --log-error=/usr/local/mysql/data/server.furysites.com.err --pid-file=/usr/local/mysql/data/mysqld.pid --socket=/usr/local/mysql/data/mysql.sock 20714 furydea+ 20 0 392560 235060 10760 R 46.1 1.4 30:40.68 /usr/sbin/httpd -DFOREGROUND

ckoijun commented 6 years ago

PC is using MYISAM whereas WP is using InnoDB Engine.

Will there be a conflict?

It seems that it will not conflict as they both operate differently.

ckoijun commented 6 years ago

Checked and optimized db through Phpmyadmin, (no issues). Removed all unused plugins in WP. Installed LoginLockdown.

ckoijun commented 6 years ago

https://likegeeks.com/linux-process-management/ To read and Do

Furysites / comparemadness

ERROR 502 - Crash during feed upload #2