Comme annoncé, ce forum est passé en lecture seule au 1er janvier 2020. Désormais nous vous invitons à vous rendre sur notre nouvelle page communauté :
Image

A très bientôt !

Pb SQL - Jeedom instable dpuis 2 jours

De l'installation à l'utilisation venez discuter de JEEDOM au quotidien
mithandir
Timide
Messages : 20
Inscription : 09 févr. 2017, 09:50

Re: Pb SQL - Jeedom instable dpuis 2 jours

Message par mithandir » 06 juin 2017, 10:50

Même problème depuis environ une semaine. Reboots intempestifs, erreurs SQL, ... Alors que je n'ai touché à rien.

thanaus
Actif
Messages : 1106
Inscription : 20 nov. 2016, 13:06

Re: Pb SQL - Jeedom instable dpuis 2 jours

Message par thanaus » 06 juin 2017, 12:16

Fournir le log correspondant à la commande 'dmesg' permet de résoudre ce type de problème (mémoire, corruption, ...)
Par contre, il faut exécuter la commande avant reboot sinon on ne pourra pas découvrir le comment du pourquoi....
Netatmo Pro | CloudSync Pro
On gagne sa vie avec ce que l'on reçoit, mais on la bâtit avec ce que l'on donne.
Winston Churchill
Lien Paypal

Dujack
Timide
Messages : 32
Inscription : 13 janv. 2016, 22:36

Re: Pb SQL - Jeedom instable dpuis 2 jours

Message par Dujack » 06 juin 2017, 12:29

Ok, merci pour l'info.
Je posterai les logs au prochain plantage...

Dujack
Timide
Messages : 32
Inscription : 13 janv. 2016, 22:36

Re: Pb SQL - Jeedom instable dpuis 2 jours

Message par Dujack » 06 juin 2017, 22:16

Bon ben voilà, ça n'a pas duré longtemps....
Ci-dessous les log avec la commande dmesg (uniquement la fin qui contient les erreurs:

[198305.274623] [ 2522] 0 2522 494 15 6 0 0 0 xargs
[198305.274638] [ 2525] 0 2525 473 22 4 0 0 0 modprobe
[198305.274653] [ 2526] 0 2526 2959 71 6 0 114 0 systemd-udevd
[198305.274668] Out of memory: Kill process 27343 (mysqld) score 31 or sacrifice child
[198305.274692] Killed process 27343 (mysqld) total-vm:255856kB, anon-rss:32388kB, file-rss:0kB
[198966.199506] Bluetooth: HCI request failed to create LE connection: status 0x0c
[199293.220092] Bluetooth: HCI request failed to create LE connection: status 0x0c
[200374.230225] Bluetooth: HCI request failed to create LE connection: status 0x0c
[200831.214146] Bluetooth: HCI request failed to create LE connection: status 0x0c
[201071.213117] Bluetooth: HCI request failed to create LE connection: status 0x0c
[201171.214449] Bluetooth: HCI request failed to create LE connection: status 0x0c

Pour info, avec la commande df, il reste 8Go sur la carte...
Si vous avez une idée....
Jacques

thanaus
Actif
Messages : 1106
Inscription : 20 nov. 2016, 13:06

Re: Pb SQL - Jeedom instable dpuis 2 jours

Message par thanaus » 06 juin 2017, 22:21

Un ou plusieurs processus ont consommé toute la mémoire disponible.
Linux sacrifie alors un processus afin de rester "stable" ce qui est confirmé par le log suivant :

Code : Tout sélectionner

[198305.274668] Out of memory: Kill process 27343 (mysqld) score 31 or sacrifice child
[198305.274692] Killed process 27343 (mysqld) total-vm:255856kB, anon-rss:32388kB, file-rss:0kB
Si tu n'as pas encore effectué un reboot, peux-tu lancer la commande suivante :

Code : Tout sélectionner

ps -eo pmem,pcpu,pid,args | tail -n +2 | sort -rnk 1 | head
Netatmo Pro | CloudSync Pro
On gagne sa vie avec ce que l'on reçoit, mais on la bâtit avec ce que l'on donne.
Winston Churchill
Lien Paypal

Dujack
Timide
Messages : 32
Inscription : 13 janv. 2016, 22:36

Re: Pb SQL - Jeedom instable dpuis 2 jours

Message par Dujack » 06 juin 2017, 23:01

Voilà le resultat de la commande:

pi@raspberrypi_domo:~ $ ps -eo pmem,pcpu,pid,args | tail -n +2 | sort -rnk 1 | head
2.3 1.8 28656 /usr/bin/python /usr/share/nginx/www/jeedom/plugins/openzwave/core/class/../../resources/openzwaved/openzwaved.py --device /dev/ttyUSB1 --loglevel error --port 8083 --config_folder /usr/share/nginx/www/jeedom/plugins/openzwave/core/class/../../resources/openzwaved/config --data_folder /usr/share/nginx/www/jeedom/plugins/openzwave/core/class/../../data --callback http://127.0.0.1:80/jeedom/plugins/open ... eZwave.php --apikey xPDdjREY6tK9OmChvgh0KvvQ2ICke397u2uEOmh44CuZD5Fq --suppressRefresh 0 --cycle 0.3 --pidfile /tmp/openzwaved.pid
1.3 49.3 2164 /usr/bin/python /usr/share/nginx/www/jeedom/plugins/blea/resources/blead/blead.py --loglevel error --device hci0 --socketport 55008 --sockethost 127.0.0.1 --callback http://127.0.0.1:80/jeedom/plugins/blea ... eeBlea.php --apikey lR2Vhy1bDXqT5hnGC5UdDt2nnf2nCLUVmPmEZ52QUgAmSCBN --daemonname local
1.3 0.5 30507 php-fpm: pool www
1.2 0.4 1864 php-fpm: pool www
1.2 0.3 1873 php-fpm: pool www
1.0 2.1 2403 /usr/bin/python /usr/share/nginx/www/jeedom/plugins/rfxcom/resources/rfxcomd/rfxcomd.py --device /dev/ttyUSB0 --loglevel debug --socketport 55000 --serialrate 38400 --protocol 7,18 --callback http://127.0.0.1:80/jeedom/plugins/rfxc ... Rfxcom.php --apikey QiTMurs85UcCfcS00xbEvjVIZ0QIYRxhUPjSaFPgFAyuLZCH --cycle 0.3
0.6 0.3 1451 lxpanel --profile LXDE-pi
0.6 0.0 1039 php-fpm: master process (/etc/php5/fpm/php-fpm.conf)
0.4 0.0 7179 -bash
0.4 0.0 7071 sshd: pi [priv]

De toute façon, je ne reboote pas jusqu'a trouver...

thanaus
Actif
Messages : 1106
Inscription : 20 nov. 2016, 13:06

Re: Pb SQL - Jeedom instable dpuis 2 jours

Message par thanaus » 07 juin 2017, 10:04

Tu peux donner plus de détails sur ta configuration (matériel, OS, plugin) ?
Pour ma part, tu devrais faire un reboot puis vérifier qu'il y a de la mémoire disponible juste après un redémarrage par la commande 'free -h'

Sur mon RPI3, j'ai par exemple la sortie suivante :

Code : Tout sélectionner

root@raspberrypi:/home/pi# free -h
             total       used       free     shared    buffers     cached
Mem:          923M       652M       270M        20M        90M       302M
-/+ buffers/cache:       259M       663M
Swap:          99M         0B        99M
Il faudrait lancer régulièrement cette commande et dès que tu constates une dérive au niveau de l'utilisation de la mémoire, tu exécutes la commande suivante qui te permettra de voir quels sont les processus les plus gourmands :

Code : Tout sélectionner

ps -eo pmem,pcpu,pid,args | tail -n +2 | sort -rnk 1 | head
Ce n'est pas simple d'investiguer pourquoi il y a un problème mémoire à un instant T...
Bon courage
Netatmo Pro | CloudSync Pro
On gagne sa vie avec ce que l'on reçoit, mais on la bâtit avec ce que l'on donne.
Winston Churchill
Lien Paypal

Dujack
Timide
Messages : 32
Inscription : 13 janv. 2016, 22:36

Re: Pb SQL - Jeedom instable dpuis 2 jours

Message par Dujack » 07 juin 2017, 18:05

Alors, pour ma config c'est un RPI2 qui tourne sous Jessie.
Les plugins installés sont

Image

Niveau mémoire:

Code : Tout sélectionner

  
  	     Total       used       free     shared    buffers     cached
Mem:          925M       787M       138M        26M        98M       268M
-/+ buffers/cache:       420M       505M
Swap:          99M         0B        99M
Pour info, ce matin la memoire etait free à 400Mo

Et les logs, que je ne sais pas lire, si tu peux m'expliquer...

Code : Tout sélectionner

pi@raspberrypi_domo:~ $ ps -eo pmem,pcpu,pid,args | tail -n +2 | sort -rnk 1 | head
 9.3  5.5  1556 /usr/bin/python /usr/bin/blueman-applet
 5.0  0.8  1173 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/log/mysql/error.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
 3.3  0.9  2632 /usr/bin/python /usr/share/nginx/www/jeedom/plugins/openzwave/core/class/../../resources/openzwaved/openzwaved.py --device /dev/ttyUSB1 --loglevel error --port 8083 --config_folder /usr/share/nginx/www/jeedom/plugins/openzwave/core/class/../../resources/openzwaved/config --data_folder /usr/share/nginx/www/jeedom/plugins/openzwave/core/class/../../data --callback http://127.0.0.1:80/jeedom/plugins/openzwave/core/php/jeeZwave.php --apikey xPDdjREY6tK9OmChvgh0KvvQ2ICke397u2uEOmh44CuZD5Fq --suppressRefresh 0 --cycle 0.3 --pidfile /tmp/openzwaved.pid
 2.6  0.0   562 /usr/bin/mpd --no-daemon
 2.3  0.3  1542 lxpanel --profile LXDE-pi
 2.2  0.0  1189 php-fpm: master process (/etc/php5/fpm/php-fpm.conf)
 2.1 36.0 15116 php /usr/share/nginx/www/jeedom/core/class/../php/jeeCron.php cron_id=7
 1.9 70.7 15050 /usr/bin/php /usr/share/nginx/www/jeedom/core/php/jeeCron.php
 1.9  0.0   774 /usr/lib/xorg/Xorg :0 -seat seat0 -auth /var/run/lightdm/root/:0 -nolisten tcp vt7 -novtswitch
 1.8  0.0  1543 pcmanfm --desktop --profile LXDE-pi

mithandir
Timide
Messages : 20
Inscription : 09 févr. 2017, 09:50

Re: Pb SQL - Jeedom instable dpuis 2 jours

Message par mithandir » 08 juin 2017, 11:50

Bonjour à tous,

Je ne suis pas du tout expert mais j'ai l'impression que mes problèmes ont commencés avec une màj du plugin OpenZwave. Depuis mon Jeedom redémarre toutes les quelques minutes.
J'ai désactivé le plugin et depuis j'ai l'impression que le système est redevenu stable...
Je vais donc probablement réinstaller le plugin, voir si ça résoud le problème.
Donc si ça peut aider quelqu'un...

thanaus
Actif
Messages : 1106
Inscription : 20 nov. 2016, 13:06

Re: Pb SQL - Jeedom instable dpuis 2 jours

Message par thanaus » 08 juin 2017, 12:34

Code : Tout sélectionner

pi@raspberrypi_domo:~ $ ps -eo pmem,pcpu,pid,args | tail -n +2 | sort -rnk 1 | head
 9.3  5.5  1556 /usr/bin/python /usr/bin/blueman-applet
 5.0  0.8  1173 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/log/mysql/error.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
 3.3  0.9  2632 /usr/bin/python /usr/share/nginx/www/jeedom/plugins/openzwave/core/class/../../resources/openzwaved/openzwaved.py --device /dev/ttyUSB1 --loglevel error --port 8083 --config_folder /usr/share/nginx/www/jeedom/plugins/openzwave/core/class/../../resources/openzwaved/config --data_folder /usr/share/nginx/www/jeedom/plugins/openzwave/core/class/../../data --callback http://127.0.0.1:80/jeedom/plugins/openzwave/core/php/jeeZwave.php --apikey xPDdjREY6tK9OmChvgh0KvvQ2ICke397u2uEOmh44CuZD5Fq --suppressRefresh 0 --cycle 0.3 --pidfile /tmp/openzwaved.pid
 2.6  0.0   562 /usr/bin/mpd --no-daemon
 2.3  0.3  1542 lxpanel --profile LXDE-pi
 2.2  0.0  1189 php-fpm: master process (/etc/php5/fpm/php-fpm.conf)
 2.1 36.0 15116 php /usr/share/nginx/www/jeedom/core/class/../php/jeeCron.php cron_id=7
 1.9 70.7 15050 /usr/bin/php /usr/share/nginx/www/jeedom/core/php/jeeCron.php
 1.9  0.0   774 /usr/lib/xorg/Xorg :0 -seat seat0 -auth /var/run/lightdm/root/:0 -nolisten tcp vt7 -novtswitch
 1.8  0.0  1543 pcmanfm --desktop --profile LXDE-pi
Cette commande affiche les processus par ordre décroissant qui consomment le plus de mémoire sur ton OS.
Dans ton cas, le processus le plus gourmand (9.3% de ta mémoire allouée) est le processus blueman qui correspondrait à une application en GTK+ permettant de gérer le Bluetooth.
De part les processus qui sont affichés, j'ai l'impression que tu as une ancienne version de Jeedom car ton serveur web est nginx en place de apache.
De plus, il y a beaucoup de processus (consommateur de ta mémoire) correspondant à une version desktop de ton OS.

Pour ma part, je ferais une sauvegarde de Jeedom, installation from scratch de l'OS à minima (sans version graphique) + installation Jeedom + restauration de ta sauvegarde. Tu sera ainsi dans la toute dernière version avec un OS épuré de toutes les couches graphiques que tu n'as pas normalement besoin.
Netatmo Pro | CloudSync Pro
On gagne sa vie avec ce que l'on reçoit, mais on la bâtit avec ce que l'on donne.
Winston Churchill
Lien Paypal

Dujack
Timide
Messages : 32
Inscription : 13 janv. 2016, 22:36

Re: Pb SQL - Jeedom instable dpuis 2 jours

Message par Dujack » 08 juin 2017, 13:17

Bon je vais tester ce que tu me dis, de toute façon c'est pas gérable des plantage tous les 2-3 jours....
Je vais repartir sur une install de Jessie à minima...
Merci pour ton aide

G4seb
Timide
Messages : 406
Inscription : 20 juil. 2014, 22:07

Re: Pb SQL - Jeedom instable dpuis 2 jours

Message par G4seb » 09 nov. 2017, 22:40

Bonjour,

problème revenu, voici le dmesg :
jeedom@jeedom:~ $ dmesg
[ 0.000000] Booting Linux on physical CPU 0x0
[ 0.000000] Initializing cgroup subsys cpuset
[ 0.000000] Initializing cgroup subsys cpu
[ 0.000000] Initializing cgroup subsys cpuacct
[ 0.000000] Linux version 4.1.19-v7+ (dc4@dc4-XPS13-9333) (gcc version 4.9.3 (crosstool-NG crosstool-ng-1.22.0-88-g8460611) ) #858 SMP Tue Mar 15 15:56:00 GMT 2016
[ 0.000000] CPU: ARMv7 Processor [410fd034] revision 4 (ARMv7), cr=10c5383d
[ 0.000000] CPU: PIPT / VIPT nonaliasing data cache, VIPT aliasing instruction cache
[ 0.000000] Machine model: Raspberry Pi 3 Model B Rev 1.2
[ 0.000000] cma: Reserved 8 MiB at 0x3a400000
[ 0.000000] Memory policy: Data cache writealloc
[ 0.000000] On node 0 totalpages: 241664
[ 0.000000] free_area_init_node: node 0, pgdat 80880fc0, node_mem_map b9bb4000
[ 0.000000] Normal zone: 2124 pages used for memmap
[ 0.000000] Normal zone: 0 pages reserved
[ 0.000000] Normal zone: 241664 pages, LIFO batch:31
[ 0.000000] [bcm2709_smp_init_cpus] enter (9420->f3003010)
[ 0.000000] [bcm2709_smp_init_cpus] ncores=4
[ 0.000000] PERCPU: Embedded 12 pages/cpu @bafb0000 s20416 r8192 d20544 u49152
[ 0.000000] pcpu-alloc: s20416 r8192 d20544 u49152 alloc=12*4096
[ 0.000000] pcpu-alloc: [0] 0 [0] 1 [0] 2 [0] 3
[ 0.000000] Built 1 zonelists in Zone order, mobility grouping on. Total pages: 239540
[ 0.000000] Kernel command line: 8250.nr_uarts=1 dma.dmachans=0x7f35 bcm2708_fb.fbwidth=656 bcm2708_fb.fbheight=416 bcm2709.boardrev=0xa02082 bcm2709.serial=0x836efcbe smsc95xx.macaddr=B8:27:EB:6E:FC:BE bcm2708_fb.fbswap=1 bcm2709.uart_clock=48000000 vc_mem.mem_base=0x3dc00000 vc_mem.mem_size=0x3f000000 dwc_otg.lpm_enable=0 console=ttyAMA0,115200 console=tty1 root=/dev/sda1 rootfstype=ext4 elevator=deadline fsck.repair=yes rootwait
[ 0.000000] PID hash table entries: 4096 (order: 2, 16384 bytes)
[ 0.000000] Dentry cache hash table entries: 131072 (order: 7, 524288 bytes)
[ 0.000000] Inode-cache hash table entries: 65536 (order: 6, 262144 bytes)
[ 0.000000] Memory: 939376K/966656K available (6064K kernel code, 534K rwdata, 1664K rodata, 444K init, 757K bss, 19088K reserved, 8192K cma-reserved)
[ 0.000000] Virtual kernel memory layout:
vector : 0xffff0000 - 0xffff1000 ( 4 kB)
fixmap : 0xffc00000 - 0xfff00000 (3072 kB)
vmalloc : 0xbb800000 - 0xff000000 (1080 MB)
lowmem : 0x80000000 - 0xbb000000 ( 944 MB)
modules : 0x7f000000 - 0x80000000 ( 16 MB)
.text : 0x80008000 - 0x807945f0 (7730 kB)
.init : 0x80795000 - 0x80804000 ( 444 kB)
.data : 0x80804000 - 0x80889b10 ( 535 kB)
.bss : 0x8088c000 - 0x809497dc ( 758 kB)
[ 0.000000] SLUB: HWalign=64, Order=0-3, MinObjects=0, CPUs=4, Nodes=1
[ 0.000000] Hierarchical RCU implementation.
[ 0.000000] Additional per-CPU info printed with stalls.
[ 0.000000] NR_IRQS:608
[ 0.000000] Architected cp15 timer(s) running at 19.20MHz (phys).
[ 0.000000] clocksource arch_sys_counter: mask: 0xffffffffffffff max_cycles: 0x46d987e47, max_idle_ns: 440795202767 ns
[ 0.000008] sched_clock: 56 bits at 19MHz, resolution 52ns, wraps every 4398046511078ns
[ 0.000025] Switching to timer-based delay loop, resolution 52ns
[ 0.000241] Console: colour dummy device 80x30
[ 0.001286] console [tty1] enabled
[ 0.001338] Calibrating delay loop (skipped), value calculated using timer frequency.. 38.40 BogoMIPS (lpj=192000)
[ 0.001405] pid_max: default: 32768 minimum: 301
[ 0.001728] Mount-cache hash table entries: 2048 (order: 1, 8192 bytes)
[ 0.001770] Mountpoint-cache hash table entries: 2048 (order: 1, 8192 bytes)
[ 0.002755] Initializing cgroup subsys blkio
[ 0.002806] Initializing cgroup subsys memory
[ 0.002853] Initializing cgroup subsys devices
[ 0.002896] Initializing cgroup subsys freezer
[ 0.002946] Initializing cgroup subsys net_cls
[ 0.003017] CPU: Testing write buffer coherency: ok
[ 0.003105] ftrace: allocating 20313 entries in 60 pages
[ 0.048583] CPU0: update cpu_capacity 1024
[ 0.048647] CPU0: thread -1, cpu 0, socket 0, mpidr 80000000
[ 0.048680] [bcm2709_smp_prepare_cpus] enter
[ 0.048848] Setting up static identity map for 0x8240 - 0x8274
[ 0.050648] [bcm2709_boot_secondary] cpu:1 started (0) 17
[ 0.050848] [bcm2709_secondary_init] enter cpu:1
[ 0.050888] CPU1: update cpu_capacity 1024
[ 0.050895] CPU1: thread -1, cpu 1, socket 0, mpidr 80000001
[ 0.051281] [bcm2709_boot_secondary] cpu:2 started (0) 18
[ 0.051447] [bcm2709_secondary_init] enter cpu:2
[ 0.051469] CPU2: update cpu_capacity 1024
[ 0.051475] CPU2: thread -1, cpu 2, socket 0, mpidr 80000002
[ 0.051839] [bcm2709_boot_secondary] cpu:3 started (0) 18
[ 0.051970] [bcm2709_secondary_init] enter cpu:3
[ 0.051991] CPU3: update cpu_capacity 1024
[ 0.051997] CPU3: thread -1, cpu 3, socket 0, mpidr 80000003
[ 0.052059] Brought up 4 CPUs
[ 0.052157] SMP: Total of 4 processors activated (153.60 BogoMIPS).
[ 0.052187] CPU: All CPU(s) started in HYP mode.
[ 0.052213] CPU: Virtualization extensions available.
[ 0.052881] devtmpfs: initialized
[ 0.071596] VFP support v0.3: implementor 41 architecture 3 part 40 variant 3 rev 4
[ 0.071877] clocksource jiffies: mask: 0xffffffff max_cycles: 0xffffffff, max_idle_ns: 19112604462750000 ns
[ 0.072740] pinctrl core: initialized pinctrl subsystem
[ 0.073290] NET: Registered protocol family 16
[ 0.078416] DMA: preallocated 4096 KiB pool for atomic coherent allocations
[ 0.079396] bcm2709.uart_clock = 48000000
[ 0.083373] hw-breakpoint: found 5 (+1 reserved) breakpoint and 4 watchpoint registers.
[ 0.083422] hw-breakpoint: maximum watchpoint size is 8 bytes.
[ 0.083596] Serial: AMBA PL011 UART driver
[ 0.083660] uart-pl011 3f201000.uart: could not find pctldev for node /soc/gpio@7e200000/uart0_pins, deferring probe
[ 0.083857] bcm2835-mbox 3f00b880.mailbox: mailbox enabled
[ 0.149297] bcm2708-dmaengine 3f007000.dma: DMA legacy API manager at f3007000, dmachans=0xf35
[ 0.149368] bcm2708-dmaengine 3f007000.dma: Initialized 7 DMA channels (+ 1 legacy)
[ 0.149969] bcm2708-dmaengine 3f007000.dma: Load BCM2835 DMA engine driver
[ 0.150006] bcm2708-dmaengine 3f007000.dma: dma_debug:0
[ 0.150574] SCSI subsystem initialized
[ 0.150785] usbcore: registered new interface driver usbfs
[ 0.150893] usbcore: registered new interface driver hub
[ 0.151012] usbcore: registered new device driver usb
[ 0.151561] raspberrypi-firmware soc:firmware: Attached to firmware from 2016-03-15 14:47
[ 0.178661] Switched to clocksource arch_sys_counter
[ 0.220106] FS-Cache: Loaded
[ 0.220389] CacheFiles: Loaded
[ 0.229755] NET: Registered protocol family 2
[ 0.230722] TCP established hash table entries: 8192 (order: 3, 32768 bytes)
[ 0.230863] TCP bind hash table entries: 8192 (order: 4, 65536 bytes)
[ 0.231074] TCP: Hash tables configured (established 8192 bind 8192)
[ 0.231188] UDP hash table entries: 512 (order: 2, 16384 bytes)
[ 0.231256] UDP-Lite hash table entries: 512 (order: 2, 16384 bytes)
[ 0.231588] NET: Registered protocol family 1
[ 0.231910] RPC: Registered named UNIX socket transport module.
[ 0.231942] RPC: Registered udp transport module.
[ 0.231970] RPC: Registered tcp transport module.
[ 0.231997] RPC: Registered tcp NFSv4.1 backchannel transport module.
[ 0.232942] hw perfevents: enabled with armv7_cortex_a7 PMU driver, 7 counters available
[ 0.234017] futex hash table entries: 1024 (order: 4, 65536 bytes)
[ 0.247392] VFS: Disk quotas dquot_6.6.0
[ 0.247725] VFS: Dquot-cache hash table entries: 1024 (order 0, 4096 bytes)
[ 0.249864] FS-Cache: Netfs 'nfs' registered for caching
[ 0.250779] NFS: Registering the id_resolver key type
[ 0.250853] Key type id_resolver registered
[ 0.250882] Key type id_legacy registered
[ 0.252951] Block layer SCSI generic (bsg) driver version 0.4 loaded (major 252)
[ 0.253120] io scheduler noop registered
[ 0.253160] io scheduler deadline registered (default)
[ 0.253447] io scheduler cfq registered
[ 0.255709] BCM2708FB: allocated DMA memory fa800000
[ 0.255756] BCM2708FB: allocated DMA channel 0 @ f3007000
[ 0.260754] Console: switching to colour frame buffer device 82x26
[ 0.265113] Serial: 8250/16550 driver, 1 ports, IRQ sharing disabled
[ 0.267633] vc-cma: Videocore CMA driver
[ 0.269084] vc-cma: vc_cma_base = 0x00000000
[ 0.270501] vc-cma: vc_cma_size = 0x00000000 (0 MiB)
[ 0.271865] vc-cma: vc_cma_initial = 0x00000000 (0 MiB)
[ 0.273332] vc-mem: phys_addr:0x00000000 mem_base=0x3dc00000 mem_size:0x3f000000(1008 MiB)
[ 0.287367] brd: module loaded
[ 0.295682] loop: module loaded
[ 0.297703] vchiq: vchiq_init_state: slot_zero = 0xba880000, is_master = 0
[ 0.300525] Loading iSCSI transport class v2.0-870.
[ 0.302445] usbcore: registered new interface driver smsc95xx
[ 0.303801] dwc_otg: version 3.00a 10-AUG-2012 (platform bus)
[ 0.505370] Core Release: 2.80a
[ 0.506611] Setting default values for core params
[ 0.507888] Finished setting default values for core params
[ 0.709536] Using Buffer DMA mode
[ 0.710821] Periodic Transfer Interrupt Enhancement - disabled
[ 0.712147] Multiprocessor Interrupt Enhancement - disabled
[ 0.713503] OTG VER PARAM: 0, OTG VER FLAG: 0
[ 0.714838] Dedicated Tx FIFOs mode
[ 0.716409] WARN::dwc_otg_hcd_init:1047: FIQ DMA bounce buffers: virt = 0xba814000 dma = 0xfa814000 len=9024
[ 0.719151] FIQ FSM acceleration enabled for :
Non-periodic Split Transactions
Periodic Split Transactions
High-Speed Isochronous Endpoints
[ 0.724677] dwc_otg: Microframe scheduler enabled
[ 0.724724] WARN::hcd_init_fiq:412: FIQ on core 1 at 0x80417288
[ 0.726118] WARN::hcd_init_fiq:413: FIQ ASM at 0x804175f8 length 36
[ 0.727524] WARN::hcd_init_fiq:438: MPHI regs_base at 0xbb89c000
[ 0.728933] dwc_otg 3f980000.usb: DWC OTG Controller
[ 0.730299] dwc_otg 3f980000.usb: new USB bus registered, assigned bus number 1
[ 0.731690] dwc_otg 3f980000.usb: irq 32, io mem 0x00000000
[ 0.733074] Init: Port Power? op_state=1
[ 0.734388] Init: Power Port (0)
[ 0.735851] usb usb1: New USB device found, idVendor=1d6b, idProduct=0002
[ 0.737211] usb usb1: New USB device strings: Mfr=3, Product=2, SerialNumber=1
[ 0.738558] usb usb1: Product: DWC OTG Controller
[ 0.739894] usb usb1: Manufacturer: Linux 4.1.19-v7+ dwc_otg_hcd
[ 0.741225] usb usb1: SerialNumber: 3f980000.usb
[ 0.743170] hub 1-0:1.0: USB hub found
[ 0.744501] hub 1-0:1.0: 1 port detected
[ 0.746109] dwc_otg: FIQ enabled
[ 0.746118] dwc_otg: NAK holdoff enabled
[ 0.746126] dwc_otg: FIQ split-transaction FSM enabled
[ 0.746158] Module dwc_common_port init
[ 0.746426] usbcore: registered new interface driver usb-storage
[ 0.747838] mousedev: PS/2 mouse device common for all mice
[ 0.749757] bcm2835-cpufreq: min=600000 max=1200000
[ 0.751290] sdhci: Secure Digital Host Controller Interface driver
[ 0.752591] sdhci: Copyright(c) Pierre Ossman
[ 0.754157] sdhost: log_buf @ ba813000 (fa813000)
[ 0.828696] mmc0: sdhost-bcm2835 loaded - DMA enabled (>1)
[ 0.852458] mmc-bcm2835 3f300000.mmc: mmc_debug:0 mmc_debug2:0
[ 0.853802] mmc-bcm2835 3f300000.mmc: DMA channel allocated
[ 0.888765] sdhci-pltfm: SDHCI platform and OF driver helper
[ 0.890412] ledtrig-cpu: registered to indicate activity on CPUs
[ 0.891855] hidraw: raw HID events driver (C) Jiri Kosina
[ 0.893348] usbcore: registered new interface driver usbhid
[ 0.894688] usbhid: USB HID core driver
[ 0.896381] Initializing XFRM netlink socket
[ 0.897698] NET: Registered protocol family 17
[ 0.899106] Key type dns_resolver registered
[ 0.900790] Registering SWP/SWPB emulation handler
[ 0.902697] registered taskstats version 1
[ 0.904158] vc-sm: Videocore shared memory driver
[ 0.905451] [vc_sm_connected_init]: start
[ 0.907186] [vc_sm_connected_init]: end - returning 0
[ 0.909441] 3f201000.uart: ttyAMA0 at MMIO 0x3f201000 (irq = 83, base_baud = 0) is a PL011 rev2
[ 0.968748] Indeed it is in host mode hprt0 = 00021501
[ 0.991215] mmc0: host does not support reading read-only switch, assuming write-enable
[ 0.999510] mmc0: new high speed SDHC card at address aaaa
[ 1.028854] mmcblk0: mmc0:aaaa SL16G 14.8 GiB
[ 1.030449] mmcblk0: p1 p2
[ 1.049351] mmc1: queuing unknown CIS tuple 0x80 (2 bytes)
[ 1.050916] mmc1: queuing unknown CIS tuple 0x80 (3 bytes)
[ 1.052476] mmc1: queuing unknown CIS tuple 0x80 (3 bytes)
[ 1.055266] mmc1: queuing unknown CIS tuple 0x80 (7 bytes)
[ 1.146507] mmc1: new high speed SDIO card at address 0001
[ 1.168689] usb 1-1: new high-speed USB device number 2 using dwc_otg
[ 1.168815] Indeed it is in host mode hprt0 = 00001101
[ 1.368948] usb 1-1: New USB device found, idVendor=0424, idProduct=9514
[ 1.368958] usb 1-1: New USB device strings: Mfr=0, Product=0, SerialNumber=0
[ 1.369576] hub 1-1:1.0: USB hub found
[ 1.369673] hub 1-1:1.0: 5 ports detected
[ 1.648686] usb 1-1.1: new high-speed USB device number 3 using dwc_otg
[ 1.748932] usb 1-1.1: New USB device found, idVendor=0424, idProduct=ec00
[ 1.748941] usb 1-1.1: New USB device strings: Mfr=0, Product=0, SerialNumber=0
[ 1.751540] smsc95xx v1.0.4
[ 1.811913] smsc95xx 1-1.1:1.0 eth0: register 'smsc95xx' at usb-3f980000.usb-1.1, smsc95xx USB 2.0 Ethernet, b8:27:eb:6e:fc:be
[ 1.888690] usb 1-1.4: new full-speed USB device number 4 using dwc_otg
[ 2.018946] usb 1-1.4: New USB device found, idVendor=0403, idProduct=6001
[ 2.018955] usb 1-1.4: New USB device strings: Mfr=1, Product=2, SerialNumber=3
[ 2.018963] usb 1-1.4: Product: EnOcean USB 300 DB
[ 2.018969] usb 1-1.4: Manufacturer: EnOcean GmbH
[ 2.018976] usb 1-1.4: SerialNumber: FTXGRFYY
[ 2.108692] usb 1-1.5: new full-speed USB device number 5 using dwc_otg
[ 2.116225] console [ttyAMA0] enabled
[ 2.122425] Waiting for root device /dev/sda1...
[ 2.236229] usb 1-1.5: New USB device found, idVendor=0403, idProduct=6001
[ 2.244454] usb 1-1.5: New USB device strings: Mfr=1, Product=2, SerialNumber=3
[ 2.253092] usb 1-1.5: Product: FT232R USB UART
[ 2.258950] usb 1-1.5: Manufacturer: FTDI
[ 2.264236] usb 1-1.5: SerialNumber: A702Q5ZS
[ 2.568685] usb 1-1.3: new high-speed USB device number 6 using dwc_otg
[ 2.710017] usb 1-1.3: New USB device found, idVendor=174c, idProduct=5136
[ 2.718181] usb 1-1.3: New USB device strings: Mfr=2, Product=3, SerialNumber=1
[ 2.726797] usb 1-1.3: Product: AS2105
[ 2.731826] usb 1-1.3: Manufacturer: ASMedia
[ 2.737352] usb 1-1.3: SerialNumber: 00000000000000000000
[ 2.744691] usb-storage 1-1.3:1.0: USB Mass Storage device detected
[ 2.752711] scsi host0: usb-storage 1-1.3:1.0
[ 3.749350] scsi 0:0:0:0: Direct-Access ASMT 2105 0 PQ: 0 ANSI: 6
[ 3.761152] sd 0:0:0:0: [sda] 61500000 512-byte logical blocks: (31.5 GB/29.3 GiB)
[ 3.771987] sd 0:0:0:0: [sda] Write Protect is off
[ 3.778170] sd 0:0:0:0: [sda] Mode Sense: 43 00 00 00
[ 3.778618] sd 0:0:0:0: [sda] Write cache: enabled, read cache: enabled, doesn't support DPO or FUA
[ 3.792784] sda: sda1
[ 3.798528] sd 0:0:0:0: [sda] Attached SCSI disk
[ 3.881039] EXT4-fs (sda1): INFO: recovery required on readonly filesystem
[ 3.889364] EXT4-fs (sda1): write access will be enabled during recovery
[ 4.185191] EXT4-fs (sda1): orphan cleanup on readonly fs
[ 4.249899] EXT4-fs (sda1): 4 orphan inodes deleted
[ 4.256211] EXT4-fs (sda1): recovery complete
[ 4.271369] EXT4-fs (sda1): mounted filesystem with ordered data mode. Opts: (null)
[ 4.281904] VFS: Mounted root (ext4 filesystem) readonly on device 8:1.
[ 4.295954] devtmpfs: mounted
[ 4.301111] Freeing unused kernel memory: 444K (80795000 - 80804000)
[ 4.651695] random: systemd urandom read with 122 bits of entropy available
[ 4.663437] systemd[1]: systemd 215 running in system mode. (+PAM +AUDIT +SELINUX +IMA +SYSVINIT +LIBCRYPTSETUP +GCRYPT +ACL +XZ -SECCOMP -APPARMOR)
[ 4.680339] systemd[1]: Detected architecture 'arm'.
[ 4.758088] NET: Registered protocol family 10
[ 4.765526] systemd[1]: Inserted module 'ipv6'
[ 4.773687] systemd[1]: Set hostname to <jeedom>.
[ 4.820454] random: nonblocking pool is initialized
[ 4.827385] uart-pl011 3f201000.uart: no DMA platform data
[ 5.184513] systemd[1]: Cannot add dependency job for unit display-manager.service, ignoring: Unit display-manager.service failed to load: No such file or directory.
[ 5.206963] systemd[1]: Starting Forward Password Requests to Wall Directory Watch.
[ 5.218174] systemd[1]: Started Forward Password Requests to Wall Directory Watch.
[ 5.229050] systemd[1]: Starting Remote File Systems (Pre).
[ 5.238386] systemd[1]: Reached target Remote File Systems (Pre).
[ 5.246236] systemd[1]: Starting Encrypted Volumes.
[ 5.254621] systemd[1]: Reached target Encrypted Volumes.
[ 5.261742] systemd[1]: Starting Arbitrary Executable File Formats File System Automount Point.
[ 5.276090] systemd[1]: Set up automount Arbitrary Executable File Formats File System Automount Point.
[ 5.289071] systemd[1]: Starting Swap.
[ 5.296634] systemd[1]: Reached target Swap.
[ 5.302715] systemd[1]: Expecting device dev-mmcblk0p1.device...
[ 5.312397] systemd[1]: Starting Root Slice.
[ 5.320264] systemd[1]: Created slice Root Slice.
[ 5.326575] systemd[1]: Starting User and Session Slice.
[ 5.335381] systemd[1]: Created slice User and Session Slice.
[ 5.342718] systemd[1]: Starting /dev/initctl Compatibility Named Pipe.
[ 5.352838] systemd[1]: Listening on /dev/initctl Compatibility Named Pipe.
[ 5.361449] systemd[1]: Starting Delayed Shutdown Socket.
[ 5.370350] systemd[1]: Listening on Delayed Shutdown Socket.
[ 5.377685] systemd[1]: Starting Journal Socket (/dev/log).
[ 5.386641] systemd[1]: Listening on Journal Socket (/dev/log).
[ 5.394111] systemd[1]: Starting udev Control Socket.
[ 5.402460] systemd[1]: Listening on udev Control Socket.
[ 5.409424] systemd[1]: Starting udev Kernel Socket.
[ 5.417649] systemd[1]: Listening on udev Kernel Socket.
[ 5.424542] systemd[1]: Starting Journal Socket.
[ 5.432525] systemd[1]: Listening on Journal Socket.
[ 5.439126] systemd[1]: Starting System Slice.
[ 5.446898] systemd[1]: Created slice System Slice.
[ 5.453338] systemd[1]: Starting File System Check on Root Device...
[ 5.465069] systemd[1]: Starting system-systemd\x2dfsck.slice.
[ 5.474697] systemd[1]: Created slice system-systemd\x2dfsck.slice.
[ 5.482526] systemd[1]: Starting system-getty.slice.
[ 5.491140] systemd[1]: Created slice system-getty.slice.
[ 5.498314] systemd[1]: Starting Increase datagram queue length...
[ 5.510066] systemd[1]: Starting Restore / save the current clock...
[ 5.527530] systemd[1]: Mounting POSIX Message Queue File System...
[ 5.540369] systemd[1]: Starting Create list of required static device nodes for the current kernel...
[ 5.636343] systemd[1]: Started Set Up Additional Binary Formats.
[ 5.644469] systemd[1]: Mounted Huge Pages File System.
[ 5.651957] systemd[1]: Starting udev Coldplug all Devices...
[ 5.675163] systemd[1]: Starting Load Kernel Modules...
[ 5.689759] systemd[1]: Mounting Debug File System...
[ 5.701934] systemd[1]: Starting Slices.
[ 5.710742] systemd[1]: Reached target Slices.
[ 5.721497] systemd[1]: Mounted Debug File System.
[ 5.730473] systemd[1]: Mounted POSIX Message Queue File System.
[ 5.741733] systemd[1]: Started Increase datagram queue length.
[ 5.799727] systemd[1]: Started Create list of required static device nodes for the current kernel.
[ 5.819643] systemd[1]: Started Restore / save the current clock.
[ 5.830573] systemd[1]: Started Load Kernel Modules.
[ 5.847997] systemd[1]: Time has been changed
[ 5.865941] systemd[1]: Started udev Coldplug all Devices.
[ 5.937321] systemd[1]: Started File System Check on Root Device.
[ 6.013836] systemd[1]: Mounted FUSE Control File System.
[ 6.020986] systemd[1]: Starting Apply Kernel Variables...
[ 6.032784] systemd[1]: Mounting Configuration File System...
[ 6.045411] systemd[1]: Starting Create Static Device Nodes in /dev...
[ 6.059394] systemd[1]: Starting Syslog Socket.
[ 6.062040] systemd[1]: Listening on Syslog Socket.
[ 6.062278] systemd[1]: Starting Journal Service...
[ 6.069502] systemd[1]: Started Journal Service.
[ 6.183478] systemd-udevd[111]: starting version 215
[ 6.832727] usbcore: registered new interface driver usbserial
[ 6.832847] usbcore: registered new interface driver usbserial_generic
[ 6.832936] usbserial: USB Serial support registered for generic
[ 6.835756] sd 0:0:0:0: Attached scsi generic sg0 type 0
[ 6.851419] usbcore: registered new interface driver ftdi_sio
[ 6.851564] usbserial: USB Serial support registered for FTDI USB Serial Device
[ 6.851890] ftdi_sio 1-1.4:1.0: FTDI USB Serial Device converter detected
[ 6.852089] usb 1-1.4: Detected FT232RL
[ 6.860601] usb 1-1.4: FTDI USB Serial Device converter now attached to ttyUSB0
[ 6.860811] ftdi_sio 1-1.5:1.0: FTDI USB Serial Device converter detected
[ 6.860996] usb 1-1.5: Detected FT232RL
[ 6.862131] usb 1-1.5: FTDI USB Serial Device converter now attached to ttyUSB1
[ 6.871668] cfg80211: Calling CRDA to update world regulatory domain
[ 7.035632] brcmfmac: brcmf_sdio_drivestrengthinit: No SDIO Drive strength init done for chip 43430 rev 1 pmurev 24
[ 7.039781] usbcore: registered new interface driver brcmfmac
[ 7.114948] EXT4-fs (sda1): re-mounted. Opts: (null)
[ 7.203935] brcmfmac: brcmf_c_preinit_dcmds: Firmware version = wl0: Dec 15 2015 18:10:45 version 7.45.41.23 (r606571) FWID 01-cc4eda9c
[ 7.228246] brcmfmac: brcmf_cfg80211_reg_notifier: not a ISO3166 code
[ 7.289903] brcmfmac: brcmf_cfg80211_reg_notifier: not a ISO3166 code
[ 7.289979] cfg80211: World regulatory domain updated:
[ 7.289998] cfg80211: DFS Master region: unset
[ 7.290012] cfg80211: (start_freq - end_freq @ bandwidth), (max_antenna_gain, max_eirp), (dfs_cac_time)
[ 7.290028] cfg80211: (2402000 KHz - 2472000 KHz @ 40000 KHz), (N/A, 2000 mBm), (N/A)
[ 7.290041] cfg80211: (2457000 KHz - 2482000 KHz @ 40000 KHz), (N/A, 2000 mBm), (N/A)
[ 7.290053] cfg80211: (2474000 KHz - 2494000 KHz @ 20000 KHz), (N/A, 2000 mBm), (N/A)
[ 7.290070] cfg80211: (5170000 KHz - 5250000 KHz @ 80000 KHz, 160000 KHz AUTO), (N/A, 2000 mBm), (N/A)
[ 7.290084] cfg80211: (5250000 KHz - 5330000 KHz @ 80000 KHz, 160000 KHz AUTO), (N/A, 2000 mBm), (0 s)
[ 7.290098] cfg80211: (5490000 KHz - 5730000 KHz @ 160000 KHz), (N/A, 2000 mBm), (0 s)
[ 7.290110] cfg80211: (5735000 KHz - 5835000 KHz @ 80000 KHz), (N/A, 2000 mBm), (N/A)
[ 7.290122] cfg80211: (57240000 KHz - 63720000 KHz @ 2160000 KHz), (N/A, 0 mBm), (N/A)
[ 7.564907] bcm2835-rng 3f104000.rng: hwrng registered
[ 7.565990] gpiomem-bcm2835 3f200000.gpiomem: Initialised: Registers at 0x3f200000
[ 7.570053] systemd-journald[109]: Received request to flush runtime journal from PID 1
[ 7.925375] brcmfmac: brcmf_add_if: ERROR: netdev:wlan0 already exists
[ 7.925397] brcmfmac: brcmf_add_if: ignore IF event
[ 7.931808] brcmfmac: power management disabled
[ 8.313555] cfg80211: Calling CRDA for country: GB
[ 8.334997] cfg80211: Regulatory domain changed to country: GB
[ 8.335021] cfg80211: DFS Master region: ETSI
[ 8.335030] cfg80211: (start_freq - end_freq @ bandwidth), (max_antenna_gain, max_eirp), (dfs_cac_time)
[ 8.335046] cfg80211: (2402000 KHz - 2482000 KHz @ 40000 KHz), (N/A, 2000 mBm), (N/A)
[ 8.335061] cfg80211: (5170000 KHz - 5250000 KHz @ 80000 KHz, 160000 KHz AUTO), (N/A, 2000 mBm), (N/A)
[ 8.335075] cfg80211: (5250000 KHz - 5330000 KHz @ 80000 KHz, 160000 KHz AUTO), (N/A, 2000 mBm), (0 s)
[ 8.335088] cfg80211: (5490000 KHz - 5710000 KHz @ 160000 KHz), (N/A, 2700 mBm), (0 s)
[ 8.335101] cfg80211: (57000000 KHz - 66000000 KHz @ 2160000 KHz), (N/A, 4000 mBm), (N/A)
[ 29.718004] Adding 102396k swap on /var/swap. Priority:-1 extents:3 across:151548k FS
[ 30.070818] smsc95xx 1-1.1:1.0 eth0: hardware isn't capable of remote wakeup
[ 30.071355] IPv6: ADDRCONF(NETDEV_UP): eth0: link is not ready
[ 31.673437] IPv6: ADDRCONF(NETDEV_CHANGE): eth0: link becomes ready
[ 31.674222] smsc95xx 1-1.1:1.0 eth0: link up, 100Mbps, full-duplex, lpa 0xC5E1
[1245129.574315] apache2 invoked oom-killer: gfp_mask=0x200da, order=0, oom_score_adj=0
[1245129.574334] apache2 cpuset=/ mems_allowed=0
[1245129.574360] CPU: 0 PID: 17170 Comm: apache2 Not tainted 4.1.19-v7+ #858
[1245129.574369] Hardware name: BCM2709
[1245129.574408] [<800185e0>] (unwind_backtrace) from [<80013f48>] (show_stack+0x20/0x24)
[1245129.574433] [<80013f48>] (show_stack) from [<805730bc>] (dump_stack+0xd4/0x118)
[1245129.574455] [<805730bc>] (dump_stack) from [<805725d4>] (dump_header+0xc0/0x1ec)
[1245129.574477] [<805725d4>] (dump_header) from [<800fae60>] (oom_kill_process+0x23c/0x460)
[1245129.574497] [<800fae60>] (oom_kill_process) from [<800fb37c>] (__out_of_memory+0x278/0x3a8)
[1245129.574516] [<800fb37c>] (__out_of_memory) from [<800fb694>] (out_of_memory+0x68/0x80)
[1245129.574536] [<800fb694>] (out_of_memory) from [<8010019c>] (__alloc_pages_nodemask+0x884/0x91c)
[1245129.574560] [<8010019c>] (__alloc_pages_nodemask) from [<80123940>] (handle_mm_fault+0xda4/0x10c0)
[1245129.574581] [<80123940>] (handle_mm_fault) from [<80578eec>] (do_page_fault+0x2e4/0x398)
[1245129.574600] [<80578eec>] (do_page_fault) from [<800091e8>] (do_DataAbort+0x48/0xc4)
[1245129.574618] [<800091e8>] (do_DataAbort) from [<80578764>] (__dabt_usr+0x44/0x60)
[1245129.574629] Exception stack(0xb3361fb0 to 0xb3361ff8)
[1245129.574643] 1fa0: 57007d60 00000000 0000115c 57008000
[1245129.574659] 1fc0: 76e034d4 00000000 000062a8 00000320 00001400 00000500 758c9000 00000000
[1245129.574674] 1fe0: 00000000 7ef15c68 76d3ab60 76d403b0 20000010 ffffffff
[1245129.574736] Mem-Info:
[1245129.574763] active_anon:109187 inactive_anon:109225 isolated_anon:0
active_file:397 inactive_file:462 isolated_file:23
unevictable:0 dirty:0 writeback:0 unstable:0
slab_reclaimable:2823 slab_unreclaimable:4973
mapped:1128 shmem:39644 pagetables:4080 bounce:0
free:2046 free_pcp:263 free_cma:0
[1245129.574815] Normal free:8184kB min:8192kB low:10240kB high:12288kB active_anon:436748kB inactive_anon:436900kB active_file:1588kB inactive_file:1848kB unevictable:0kB isolated(anon):0kB isolated(file):92kB present:966656kB managed:948012kB mlocked:0kB dirty:0kB writeback:0kB mapped:4512kB shmem:158576kB slab_reclaimable:11292kB slab_unreclaimable:19892kB kernel_stack:2776kB pagetables:16320kB unstable:0kB bounce:0kB free_pcp:1052kB local_pcp:184kB free_cma:0kB writeback_tmp:0kB pages_scanned:21080 all_unreclaimable? yes
[1245129.574882] lowmem_reserve[]: 0 0
[1245129.574898] Normal: 89*4kB (UE) 19*8kB (UER) 16*16kB (UEMR) 6*32kB (ER) 2*64kB (R) 6*128kB (R) 3*256kB (R) 1*512kB (R) 1*1024kB (R) 0*2048kB 1*4096kB (R) = 8252kB
[1245129.575028] 40672 total pagecache pages
[1245129.575040] 87 pages in swap cache
[1245129.575051] Swap cache stats: add 25868, delete 25781, find 510/556
[1245129.575059] Free swap = 0kB
[1245129.575067] Total swap = 102396kB
[1245129.575075] 241664 pages RAM
[1245129.575082] 0 pages HighMem/MovableOnly
[1245129.575115] 2613 pages reserved
[1245129.575122] 2048 pages cma reserved
[1245129.575131] [ pid ] uid tgid total_vm rss nr_ptes nr_pmds swapents oom_score_adj name
[1245129.575167] [ 109] 0 109 2574 200 8 0 16 0 systemd-journal
[1245129.575184] [ 111] 0 111 2873 3 8 0 130 -1000 systemd-udevd
[1245129.575202] [ 377] 0 377 1789 14 7 0 91 0 wpa_supplicant
[1245129.575218] [ 430] 0 430 1276 17 7 0 42 0 cron
[1245129.575264] [ 432] 0 432 849 21 5 0 32 0 systemd-logind
[1245129.575281] [ 436] 104 436 1373 49 5 0 37 -900 dbus-daemon
[1245129.575297] [ 446] 65534 446 573 4 5 0 27 0 thd
[1245129.575313] [ 482] 0 482 8036 148 11 0 99 0 rsyslogd
[1245129.575330] [ 664] 0 664 641 23 5 0 49 0 dhcpcd
[1245129.575346] [ 665] 0 665 1966 4 9 0 112 -1000 sshd
[1245129.575386] [ 694] 0 694 1014 3 5 0 31 0 agetty
[1245129.575403] [ 699] 106 699 1444 36 7 0 72 0 ntpd
[1245129.575419] [ 733] 0 733 478 2 6 0 27 0 mysqld_safe
[1245129.575436] [ 962] 0 962 29204 1128 31 0 77 0 apache2
[1245129.575452] [ 1002] 0 1002 28835 37 26 0 761 0 php5-fpm
[1245129.575468] [ 1065] 33 1065 28835 20 23 0 778 0 php5-fpm
[1245129.575485] [ 1067] 33 1067 28835 20 23 0 778 0 php5-fpm
[1245129.575524] [ 1113] 109 1113 87277 28158 103 0 3791 0 mysqld
[1245129.575541] [ 1831] 33 1831 22280 4216 30 0 615 0 python
[1245129.575558] [ 2018] 33 2018 14868 411 17 0 676 0 python
[1245129.575573] [ 2262] 33 2262 22678 4349 29 0 134 0 python
[1245129.575590] [ 9278] 105 9278 997 84 5 0 0 0 avahi-daemon
[1245129.575607] [ 9280] 105 9280 969 57 5 0 0 0 avahi-daemon
[1245129.575647] [ 5256] 33 5256 12894 1448 24 0 0 0 php
[1245129.575663] [ 5520] 33 5520 17793 3557 23 0 0 0 python
[1245129.575679] [ 800] 33 800 30756 3185 35 0 53 0 apache2
[1245129.575695] [ 1016] 33 1016 30812 3298 35 0 51 0 apache2
[1245129.575711] [ 9742] 33 9742 30598 3182 35 0 53 0 apache2
[1245129.575727] [25031] 33 25031 30627 2567 35 0 51 0 apache2
[1245129.575742] [ 5521] 33 5521 30626 2924 35 0 54 0 apache2
[1245129.575782] [22281] 33 22281 30706 3214 35 0 54 0 apache2
[1245129.575798] [ 6271] 33 6271 30633 3101 35 0 54 0 apache2
[1245129.575815] [ 7146] 33 7146 40892 10290 77 0 0 0 homebridge
[1245129.575833] [ 9954] 33 9954 22969 4456 45 0 0 0 nodejs
[1245129.575849] [15115] 33 15115 30730 3034 35 0 54 0 apache2
[1245129.575865] [15530] 33 15530 30668 2957 35 0 54 0 apache2
[1245129.575881] [15610] 33 15610 30635 3135 35 0 53 0 apache2
[1245129.575921] [15622] 33 15622 30599 3013 35 0 54 0 apache2
[1245129.575936] [16872] 33 16872 30564 3078 35 0 54 0 apache2
[1245129.575952] [16900] 33 16900 30531 2959 35 0 54 0 apache2
[1245129.575977] [16901] 33 16901 30529 2960 35 0 54 0 apache2
[1245129.575993] [16927] 33 16927 30497 2809 35 0 54 0 apache2
[1245129.576009] [16928] 33 16928 30529 2976 35 0 54 0 apache2
[1245129.576048] [16930] 33 16930 30483 2766 35 0 54 0 apache2
[1245129.576065] [16931] 33 16931 30463 2618 35 0 54 0 apache2
[1245129.576080] [16959] 33 16959 30496 2927 35 0 54 0 apache2
[1245129.576109] [16960] 33 16960 30496 2992 35 0 54 0 apache2
[1245129.576125] [16962] 33 16962 30497 2993 35 0 54 0 apache2
[1245129.576141] [16963] 33 16963 30497 2856 35 0 54 0 apache2
[1245129.576181] [16965] 33 16965 30497 2989 35 0 54 0 apache2
[1245129.576197] [16966] 33 16966 30463 2975 35 0 54 0 apache2
[1245129.576222] [16968] 33 16968 30463 2725 35 0 54 0 apache2
[1245129.576238] [16969] 33 16969 30497 2985 35 0 54 0 apache2
[1245129.576253] [17005] 33 17005 30463 2942 35 0 54 0 apache2
[1245129.576319] [17006] 33 17006 30463 2958 35 0 54 0 apache2
[1245129.576348] [17007] 33 17007 30463 2958 35 0 54 0 apache2
[1245129.576364] [17010] 33 17010 30463 2762 35 0 54 0 apache2
[1245129.576380] [17011] 33 17011 30463 2882 35 0 54 0 apache2
[1245129.576409] [17012] 33 17012 30463 2937 35 0 54 0 apache2
[1245129.576448] [17015] 33 17015 30463 2882 35 0 54 0 apache2
[1245129.576464] [17016] 33 17016 30463 2895 35 0 54 0 apache2
[1245129.576480] [17020] 33 17020 30449 2816 35 0 54 0 apache2
[1245129.576496] [17023] 33 17023 30463 2934 35 0 54 0 apache2
[1245129.576541] [17028] 33 17028 30464 2951 35 0 54 0 apache2
[1245129.576557] [17029] 33 17029 30463 2921 35 0 54 0 apache2
[1245129.576598] [17034] 33 17034 30463 2883 35 0 54 0 apache2
[1245129.576643] [17035] 33 17035 30463 2862 35 0 54 0 apache2
[1245129.576659] [17040] 33 17040 30463 2958 35 0 54 0 apache2
[1245129.576674] [17042] 33 17042 30463 2883 35 0 54 0 apache2
[1245129.576690] [17063] 33 17063 30464 2879 35 0 54 0 apache2
[1245129.576743] [17064] 33 17064 29566 1925 32 0 55 0 apache2
[1245129.576760] [17065] 33 17065 30464 2958 35 0 54 0 apache2
[1245129.576776] [17066] 33 17066 30449 2879 35 0 54 0 apache2
[1245129.576791] [17067] 33 17067 30463 2819 35 0 54 0 apache2
[1245129.576807] [17070] 33 17070 30463 2942 35 0 54 0 apache2
[1245129.576847] [17071] 33 17071 30463 2880 35 0 54 0 apache2
[1245129.576863] [17072] 33 17072 30463 2897 35 0 54 0 apache2
[1245129.576879] [17073] 33 17073 29496 1619 31 0 55 0 apache2
[1245129.576894] [17074] 33 17074 30463 2874 35 0 54 0 apache2
[1245129.576910] [17075] 33 17075 30464 2942 35 0 54 0 apache2
[1245129.576926] [17078] 33 17078 30464 2854 35 0 54 0 apache2
[1245129.576965] [17079] 33 17079 30463 2878 35 0 54 0 apache2
[1245129.576981] [17085] 33 17085 30463 2865 35 0 54 0 apache2
[1245129.576997] [17086] 33 17086 30463 2878 35 0 54 0 apache2
[1245129.577013] [17093] 33 17093 30463 2972 35 0 54 0 apache2
[1245129.577028] [17094] 33 17094 30425 2773 34 0 54 0 apache2
[1245129.577043] [17099] 33 17099 30445 2772 34 0 54 0 apache2
[1245129.577059] [17100] 33 17100 30463 2846 35 0 54 0 apache2
[1245129.577098] [17104] 33 17104 30425 2681 34 0 54 0 apache2
[1245129.577114] [17105] 33 17105 30463 2865 35 0 54 0 apache2
[1245129.577130] [17108] 33 17108 30449 2878 35 0 54 0 apache2
[1245129.577145] [17114] 33 17114 30463 3006 35 0 54 0 apache2
[1245129.577161] [17115] 33 17115 30423 2713 34 0 55 0 apache2
[1245129.577177] [17118] 33 17118 30449 2975 35 0 54 0 apache2
[1245129.577216] [17124] 33 17124 30423 2694 34 0 55 0 apache2
[1245129.577232] [17125] 33 17125 30425 2726 34 0 54 0 apache2
[1245129.577248] [17126] 33 17126 30423 2713 34 0 55 0 apache2
[1245129.577263] [17130] 33 17130 29426 1948 32 0 55 0 apache2
[1245129.577279] [17136] 33 17136 30425 2727 34 0 54 0 apache2
[1245129.577294] [17138] 33 17138 30425 2703 34 0 54 0 apache2
[1245129.577310] [17142] 33 17142 30390 2797 34 0 55 0 apache2
[1245129.577356] [17157] 33 17157 29333 1842 32 0 55 0 apache2
[1245129.577372] [17158] 33 17158 29692 2116 33 0 55 0 apache2
[1245129.577388] [17165] 33 17165 29259 1243 29 0 75 0 apache2
[1245129.577404] [17167] 33 17167 29759 2212 33 0 55 0 apache2
[1245129.577419] [17169] 33 17169 29426 1805 32 0 55 0 apache2
[1245129.577434] [17170] 33 17170 29925 2359 34 0 55 0 apache2
[1245129.577485] [17171] 33 17171 29426 1805 32 0 55 0 apache2
[1245129.577500] [17172] 33 17172 29426 1802 33 0 55 0 apache2
[1245129.577516] [17173] 33 17173 29825 2263 33 0 55 0 apache2
[1245129.577532] [17174] 33 17174 29426 1829 32 0 55 0 apache2
[1245129.577547] [17266] 0 17266 1476 69 7 0 7 0 cron
[1245129.577562] [17267] 0 17267 1476 69 7 0 7 0 cron
[1245129.577631] [17268] 33 17268 29333 1625 30 0 56 0 apache2
[1245129.577648] [17269] 33 17269 29333 1906 32 0 55 0 apache2
[1245129.577663] [17270] 33 17270 29333 1625 30 0 56 0 apache2
[1245129.577679] [17271] 33 17271 29333 1812 32 0 55 0 apache2
[1245129.577738] [17272] 33 17272 29333 1782 32 0 55 0 apache2
[1245129.577754] [17273] 33 17273 29333 1907 32 0 55 0 apache2
[1245129.577770] [17274] 33 17274 29333 1852 32 0 55 0 apache2
[1245129.577786] [17275] 33 17275 29333 1625 30 0 56 0 apache2
[1245129.577801] [17276] 33 17276 29333 1565 30 0 56 0 apache2
[1245129.577852] [17277] 33 17277 29333 1625 30 0 56 0 apache2
[1245129.577868] [17278] 33 17278 29333 1625 30 0 56 0 apache2
[1245129.577883] [17282] 33 17282 29333 1610 30 0 56 0 apache2
[1245129.577899] [17289] 33 17289 29333 1606 30 0 56 0 apache2
[1245129.577914] [17290] 33 17290 29333 1610 30 0 56 0 apache2
[1245129.577930] [17299] 0 17299 478 15 5 0 0 0 sh
[1245129.577968] [17301] 0 17301 478 15 5 0 0 0 sh
[1245129.578014] [17303] 0 17303 6273 239 15 0 0 0 php
[1245129.578029] [17304] 0 17304 1515 81 7 0 0 0 su
[1245129.578045] [17322] 33 17322 4662 65 9 0 0 0 php
[1245129.578061] [17324] 33 17324 29259 1252 29 0 75 0 apache2
[1245129.578114] [17330] 33 17330 29216 1134 24 0 77 0 apache2
[1245129.578131] [17336] 33 17336 29216 1116 24 0 77 0 apache2
[1245129.578147] [17342] 33 17342 29208 1126 24 0 77 0 apache2
[1245129.578184] [17343] 33 17343 29224 1125 25 0 77 0 apache2
[1245129.578196] Out of memory: Kill process 1113 (mysqld) score 122 or sacrifice child
[1245129.578250] Killed process 1113 (mysqld) total-vm:349108kB, anon-rss:112632kB, file-rss:0kB
[1245129.661910] apache2 invoked oom-killer: gfp_mask=0x200da, order=0, oom_score_adj=0
[1245129.661931] apache2 cpuset=/ mems_allowed=0
[1245129.661958] CPU: 1 PID: 17158 Comm: apache2 Not tainted 4.1.19-v7+ #858
[1245129.661968] Hardware name: BCM2709
[1245129.662009] [<800185e0>] (unwind_backtrace) from [<80013f48>] (show_stack+0x20/0x24)
[1245129.662034] [<80013f48>] (show_stack) from [<805730bc>] (dump_stack+0xd4/0x118)
[1245129.662056] [<805730bc>] (dump_stack) from [<805725d4>] (dump_header+0xc0/0x1ec)
[1245129.662078] [<805725d4>] (dump_header) from [<800fae60>] (oom_kill_process+0x23c/0x460)
[1245129.662116] [<800fae60>] (oom_kill_process) from [<800fb37c>] (__out_of_memory+0x278/0x3a8)
[1245129.662154] [<800fb37c>] (__out_of_memory) from [<800fb694>] (out_of_memory+0x68/0x80)
[1245129.662184] [<800fb694>] (out_of_memory) from [<8010019c>] (__alloc_pages_nodemask+0x884/0x91c)
[1245129.662209] [<8010019c>] (__alloc_pages_nodemask) from [<80123940>] (handle_mm_fault+0xda4/0x10c0)
[1245129.662233] [<80123940>] (handle_mm_fault) from [<80578eec>] (do_page_fault+0x2e4/0x398)
[1245129.662252] [<80578eec>] (do_page_fault) from [<800091e8>] (do_DataAbort+0x48/0xc4)
[1245129.662270] [<800091e8>] (do_DataAbort) from [<80578764>] (__dabt_usr+0x44/0x60)
[1245129.662281] Exception stack(0xa9035fb0 to 0xa9035ff8)
[1245129.662296] 5fa0: 00001409 00000000 0001e441 56f057b8
[1245129.662313] 5fc0: 56f057c0 76e034d4 00000065 56f06bc0 76e03504 00001400 000001ff 00000000
[1245129.662327] 5fe0: 00001409 7ef15be8 76d3a99c 76d38074 60000010 ffffffff
[1245129.662338] Mem-Info:
[1245129.662364] active_anon:109182 inactive_anon:109214 isolated_anon:32
active_file:534 inactive_file:604 isolated_file:0
unevictable:0 dirty:0 writeback:0 unstable:0
slab_reclaimable:2823 slab_unreclaimable:4973
mapped:1336 shmem:39644 pagetables:4082 bounce:0
free:2029 free_pcp:196 free_cma:0
[1245129.662418] Normal free:8116kB min:8192kB low:10240kB high:12288kB active_anon:436728kB inactive_anon:436856kB active_file:2136kB inactive_file:2416kB unevictable:0kB isolated(anon):128kB isolated(file):0kB present:966656kB managed:948012kB mlocked:0kB dirty:0kB writeback:0kB mapped:5344kB shmem:158576kB slab_reclaimable:11292kB slab_unreclaimable:19892kB kernel_stack:2376kB pagetables:16328kB unstable:0kB bounce:0kB free_pcp:784kB local_pcp:352kB free_cma:0kB writeback_tmp:0kB pages_scanned:27828 all_unreclaimable? yes
[1245129.662429] lowmem_reserve[]: 0 0
[1245129.662445] Normal: 89*4kB (UEM) 41*8kB (UR) 5*16kB (R) 5*32kB (R) 2*64kB (R) 6*128kB (R) 3*256kB (R) 1*512kB (R) 1*1024kB (R) 0*2048kB 1*4096kB (R) = 8220kB
[1245129.662529] 40965 total pagecache pages
[1245129.662541] 103 pages in swap cache
[1245129.662551] Swap cache stats: add 25891, delete 25788, find 518/569
[1245129.662560] Free swap = 0kB
[1245129.662567] Total swap = 102396kB
[1245129.662575] 241664 pages RAM
[1245129.662583] 0 pages HighMem/MovableOnly
[1245129.662592] 2613 pages reserved
[1245129.662599] 2048 pages cma reserved
[1245129.662608] [ pid ] uid tgid total_vm rss nr_ptes nr_pmds swapents oom_score_adj name
[1245129.662639] [ 109] 0 109 2574 200 8 0 16 0 systemd-journal
[1245129.662656] [ 111] 0 111 2873 3 8 0 130 -1000 systemd-udevd
[1245129.662674] [ 377] 0 377 1789 14 7 0 91 0 wpa_supplicant
[1245129.662690] [ 430] 0 430 1276 17 7 0 42 0 cron
[1245129.662706] [ 432] 0 432 849 21 5 0 32 0 systemd-logind
[1245129.662724] [ 436] 104 436 1373 49 5 0 37 -900 dbus-daemon
[1245129.662742] [ 446] 65534 446 573 4 5 0 27 0 thd
[1245129.662758] [ 482] 0 482 8036 148 11 0 99 0 rsyslogd
[1245129.662775] [ 664] 0 664 641 23 5 0 49 0 dhcpcd
[1245129.662791] [ 665] 0 665 1966 4 9 0 112 -1000 sshd
[1245129.662806] [ 694] 0 694 1014 3 5 0 31 0 agetty
[1245129.662823] [ 699] 106 699 1444 36 7 0 72 0 ntpd
[1245129.662840] [ 733] 0 733 478 2 6 0 27 0 mysqld_safe
[1245129.662856] [ 962] 0 962 29204 1128 31 0 77 0 apache2
[1245129.662872] [ 1002] 0 1002 28835 37 26 0 761 0 php5-fpm
[1245129.662888] [ 1065] 33 1065 28835 20 23 0 778 0 php5-fpm
[1245129.662905] [ 1067] 33 1067 28835 20 23 0 778 0 php5-fpm
[1245129.662922] [ 1143] 109 1113 87277 28257 103 0 3787 0 mysqld
[1245129.662939] [ 1831] 33 1831 22280 4216 30 0 615 0 python
[1245129.662959] [ 2018] 33 2018 14868 411 17 0 676 0 python
[1245129.662977] [ 2262] 33 2262 22678 4349 29 0 134 0 python
[1245129.662994] [ 9278] 105 9278 997 84 5 0 0 0 avahi-daemon
[1245129.663011] [ 9280] 105 9280 969 57 5 0 0 0 avahi-daemon
[1245129.663030] [ 5256] 33 5256 12894 1448 24 0 0 0 php
[1245129.663047] [ 5520] 33 5520 17793 3557 23 0 0 0 python
[1245129.663063] [ 800] 33 800 30756 3182 35 0 53 0 apache2
[1245129.663141] [ 1016] 33 1016 30812 3294 35 0 51 0 apache2
[1245129.663168] [ 9742] 33 9742 30598 3178 35 0 53 0 apache2
[1245129.663185] [25031] 33 25031 30627 2567 35 0 51 0 apache2
[1245129.663201] [ 5521] 33 5521 30626 2923 35 0 54 0 apache2
[1245129.663221] [22281] 33 22281 30706 3210 35 0 54 0 apache2
[1245129.663238] [ 6271] 33 6271 30633 3098 35 0 54 0 apache2
[1245129.663254] [ 7146] 33 7146 40892 10290 77 0 0 0 homebridge
[1245129.663277] [ 9954] 33 9954 22969 4456 45 0 0 0 nodejs
[1245129.663294] [15115] 33 15115 30730 3033 35 0 54 0 apache2
[1245129.663310] [15530] 33 15530 30668 2956 35 0 54 0 apache2
[1245129.663326] [15610] 33 15610 30635 3131 35 0 53 0 apache2
[1245129.663344] [15622] 33 15622 30599 3009 35 0 54 0 apache2
[1245129.663360] [16872] 33 16872 30564 3074 35 0 54 0 apache2
[1245129.663376] [16900] 33 16900 30531 2955 35 0 54 0 apache2
[1245129.663396] [16901] 33 16901 30529 2956 35 0 54 0 apache2
[1245129.663413] [16927] 33 16927 30497 2808 35 0 54 0 apache2
[1245129.663430] [16928] 33 16928 30529 2972 35 0 54 0 apache2
[1245129.663446] [16930] 33 16930 30483 2762 35 0 54 0 apache2
[1245129.663464] [16931] 33 16931 30463 2617 35 0 54 0 apache2
[1245129.663481] [16959] 33 16959 30496 2923 35 0 54 0 apache2
[1245129.663497] [16960] 33 16960 30496 2988 35 0 54 0 apache2
[1245129.663513] [16962] 33 16962 30497 2990 35 0 54 0 apache2
[1245129.663531] [16963] 33 16963 30497 3008 35 0 54 0 apache2
[1245129.663548] [16965] 33 16965 30497 2985 35 0 54 0 apache2
[1245129.663564] [16966] 33 16966 30463 2971 35 0 54 0 apache2
[1245129.663581] [16968] 33 16968 30463 2724 35 0 54 0 apache2
[1245129.663598] [16969] 33 16969 30497 2981 35 0 54 0 apache2
[1245129.663615] [17005] 33 17005 30463 2939 35 0 54 0 apache2
[1245129.663632] [17006] 33 17006 30463 2954 35 0 54 0 apache2
[1245129.663648] [17007] 33 17007 30463 2954 35 0 54 0 apache2
[1245129.663665] [17010] 33 17010 30463 2761 35 0 54 0 apache2
[1245129.663681] [17011] 33 17011 30463 2878 35 0 54 0 apache2
[1245129.663697] [17012] 33 17012 30463 2933 35 0 54 0 apache2
[1245129.663714] [17015] 33 17015 30463 2878 35 0 54 0 apache2
[1245129.663730] [17016] 33 17016 30463 2891 35 0 54 0 apache2
[1245129.663747] [17020] 33 17020 30449 3001 35 0 54 0 apache2
[1245129.663765] [17023] 33 17023 30463 2930 35 0 54 0 apache2
[1245129.663781] [17028] 33 17028 30464 2947 35 0 54 0 apache2
[1245129.663797] [17029] 33 17029 30463 2917 35 0 54 0 apache2
[1245129.663814] [17034] 33 17034 30463 2879 35 0 54 0 apache2
[1245129.663831] [17035] 33 17035 30463 2993 35 0 54 0 apache2
[1245129.663848] [17040] 33 17040 30463 2954 35 0 54 0 apache2
[1245129.663864] [17042] 33 17042 30463 2879 35 0 54 0 apache2
[1245129.663880] [17063] 33 17063 30464 2875 35 0 54 0 apache2
[1245129.663898] [17064] 33 17064 29566 1924 32 0 55 0 apache2
[1245129.663915] [17065] 33 17065 30464 2954 35 0 54 0 apache2
[1245129.663931] [17066] 33 17066 30449 2875 35 0 54 0 apache2
[1245129.663950] [17067] 33 17067 30463 2984 35 0 54 0 apache2
[1245129.663968] [17070] 33 17070 30463 2938 35 0 54 0 apache2
[1245129.663985] [17071] 33 17071 30463 2876 35 0 54 0 apache2
[1245129.664002] [17072] 33 17072 30463 2893 35 0 54 0 apache2
[1245129.664018] [17073] 33 17073 29496 1618 31 0 55 0 apache2
[1245129.664035] [17074] 33 17074 30463 2870 35 0 54 0 apache2
[1245129.664051] [17075] 33 17075 30464 2938 35 0 54 0 apache2
[1245129.664068] [17078] 33 17078 30464 2984 35 0 54 0 apache2
[1245129.664088] [17079] 33 17079 30463 2874 35 0 54 0 apache2
[1245129.664105] [17085] 33 17085 30463 2861 35 0 54 0 apache2
[1245129.664122] [17086] 33 17086 30463 2874 35 0 54 0 apache2
[1245129.664138] [17093] 33 17093 30463 2968 35 0 54 0 apache2
[1245129.664155] [17094] 33 17094 30425 2761 34 0 54 0 apache2
[1245129.664171] [17099] 33 17099 30445 2759 34 0 54 0 apache2
[1245129.664188] [17100] 33 17100 30463 3013 35 0 54 0 apache2
[1245129.664205] [17104] 33 17104 30425 2668 34 0 54 0 apache2
[1245129.664223] [17105] 33 17105 30463 2979 35 0 61 0 apache2
[1245129.664239] [17108] 33 17108 30449 2874 35 0 54 0 apache2
[1245129.664256] [17114] 33 17114 30463 3002 35 0 54 0 apache2
[1245129.664272] [17115] 33 17115 30423 2712 34 0 55 0 apache2
[1245129.664288] [17118] 33 17118 30449 2971 35 0 54 0 apache2
[1245129.664304] [17124] 33 17124 30423 2693 34 0 55 0 apache2
[1245129.664321] [17125] 33 17125 30425 2713 34 0 54 0 apache2
[1245129.664339] [17126] 33 17126 30423 2712 34 0 55 0 apache2
[1245129.664355] [17130] 33 17130 29426 1935 32 0 55 0 apache2
[1245129.664374] [17136] 33 17136 30425 2714 34 0 54 0 apache2
[1245129.664391] [17138] 33 17138 30425 2690 34 0 54 0 apache2
[1245129.664407] [17142] 33 17142 30390 2796 34 0 55 0 apache2
[1245129.664423] [17157] 33 17157 29333 1838 32 0 55 0 apache2
[1245129.664439] [17158] 33 17158 29692 2115 33 0 55 0 apache2
[1245129.664455] [17165] 33 17165 29259 1242 29 0 75 0 apache2
[1245129.664474] [17167] 33 17167 29759 2211 33 0 55 0 apache2
[1245129.664493] [17169] 33 17169 29426 1804 32 0 55 0 apache2
[1245129.664509] [17170] 33 17170 29925 2358 34 0 55 0 apache2
[1245129.664526] [17171] 33 17171 29426 1804 32 0 55 0 apache2
[1245129.664542] [17172] 33 17172 29426 1801 33 0 55 0 apache2
[1245129.664558] [17173] 33 17173 29825 2262 33 0 55 0 apache2
[1245129.664575] [17174] 33 17174 29426 1828 32 0 55 0 apache2
[1245129.664592] [17266] 0 17266 1476 69 7 0 7 0 cron
[1245129.664608] [17267] 0 17267 1476 69 7 0 7 0 cron
[1245129.664628] [17268] 33 17268 29333 1624 30 0 56 0 apache2
[1245129.664647] [17269] 33 17269 29333 1905 32 0 55 0 apache2
[1245129.664663] [17270] 33 17270 29333 1624 30 0 56 0 apache2
[1245129.664680] [17271] 33 17271 29333 1808 32 0 55 0 apache2
[1245129.664696] [17272] 33 17272 29333 1778 32 0 55 0 apache2
[1245129.664715] [17273] 33 17273 29333 1906 32 0 55 0 apache2
[1245129.664732] [17274] 33 17274 29333 1836 32 0 55 0 apache2
[1245129.664748] [17275] 33 17275 29333 1624 30 0 56 0 apache2
[1245129.664770] [17276] 33 17276 29333 1564 30 0 56 0 apache2
[1245129.664786] [17277] 33 17277 29333 1624 30 0 56 0 apache2
[1245129.664803] [17278] 33 17278 29333 1624 30 0 56 0 apache2
[1245129.664819] [17282] 33 17282 29333 1609 30 0 56 0 apache2
[1245129.664835] [17289] 33 17289 29333 1605 30 0 56 0 apache2
[1245129.664854] [17290] 33 17290 29333 1609 30 0 56 0 apache2
[1245129.664870] [17299] 0 17299 478 15 5 0 0 0 sh
[1245129.664890] [17301] 0 17301 478 15 5 0 0 0 sh
[1245129.664907] [17303] 0 17303 6273 239 15 0 0 0 php
[1245129.664922] [17304] 0 17304 1515 81 7 0 0 0 su
[1245129.664939] [17322] 33 17322 4662 65 9 0 0 0 php
[1245129.664955] [17324] 33 17324 29259 1251 29 0 75 0 apache2
[1245129.664973] [17330] 33 17330 29216 1133 24 0 77 0 apache2
[1245129.664990] [17336] 33 17336 29216 1116 24 0 77 0 apache2
[1245129.665006] [17342] 33 17342 29208 1124 24 0 77 0 apache2
[1245129.665027] [17343] 33 17343 29224 1125 25 0 77 0 apache2
[1245129.665044] [17352] 0 17352 29204 1110 22 0 77 0 apache2
[1245129.665056] Out of memory: Kill process 1143 (mysqld) score 122 or sacrifice child
[1245129.665071] Killed process 1143 (mysqld) total-vm:349108kB, anon-rss:113028kB, file-rss:0kB
RPI3 - SSD
Aeotec Zwave - Enocean
Zibase en passerelle - Gateway Xiaomi
Modules Fibaro - Enocean - Aeon Labs - Chacon - Delta Dore - Visonic - Next - Xiaomi
Caméra Axis - Withings Home - Xiaomi 1080P

G4seb
Timide
Messages : 406
Inscription : 20 juil. 2014, 22:07

Re: Pb SQL - Jeedom instable dpuis 2 jours

Message par G4seb » 09 nov. 2017, 23:13

Après un reboot il redémarre mais je sais qu'il va replanter.
A l'époque j'avais supprimer des lignes dans Historyarch depuis jeedom, mais apparemment ce n'est plus possible.

Please Help....
RPI3 - SSD
Aeotec Zwave - Enocean
Zibase en passerelle - Gateway Xiaomi
Modules Fibaro - Enocean - Aeon Labs - Chacon - Delta Dore - Visonic - Next - Xiaomi
Caméra Axis - Withings Home - Xiaomi 1080P

beber49
Timide
Messages : 197
Inscription : 26 janv. 2017, 20:11

Re: Pb SQL - Jeedom instable dpuis 2 jours

Message par beber49 » 14 nov. 2017, 22:50

Salut,
Perso j'avais un souci de freeze que j'ai resolu en enlevant du matériel usb sur les 4 ports de ma smart.
Tu as installé le plugin monitoring pour voir la température CPU ?

olivier42
Timide
Messages : 145
Inscription : 26 janv. 2016, 07:47
Localisation : Montpellier
Contact :

Re: Pb SQL - Jeedom instable dpuis 2 jours

Message par olivier42 » 12 févr. 2018, 13:14

G4seb a écrit :
09 nov. 2017, 23:13
Après un reboot il redémarre mais je sais qu'il va replanter.
A l'époque j'avais supprimer des lignes dans Historyarch depuis jeedom, mais apparemment ce n'est plus possible.

Please Help....
Bonjour,

J'ai le même pb depuis 2 semaines, Jeedom inaccessible parceque mysql killé tous les 2 3 jours.
Même conf, RPI2 sous Jessie.

Dans dmesg :
[58820.778283] Out of memory: Kill process 30182 (mysqld) score 3 or sacrifice child
[58820.790769] Killed process 30182 (mysqld) total-vm:321524kB, anon-rss:34248kB, file-rss:8000kB, shmem-rss:0kB


En faisant /etc/init.d/mysql restart ca repart quelques heures/jours, puis rebelotte.

Avez-vous réussi à résoudre le pbs ?

Cordialement,

Avatar de l’utilisateur
loic
Administrateur
Messages : 14862
Inscription : 01 févr. 2014, 16:21

Re: Pb SQL - Jeedom instable dpuis 2 jours

Message par loic » 12 févr. 2018, 13:34

Ce genre de soucis c'est généralement un jeedom trop charger pour le hardware.
Aide nous à t'aider : mets des logs, détaille ton soucis... Vous n'aurez aucune réponse de ma part si votre demande n'est pas détaillée (log, capture d'écran lisible...) ou si vous ne postez pas dans la bonne section

krovit
Timide
Messages : 18
Inscription : 14 déc. 2016, 19:40

Re: Pb SQL - Jeedom instable dpuis 2 jours

Message par krovit » 12 févr. 2018, 13:39

Perso je suis passé sur un mini PC qui virtualise une debian avec jeedom dessus. Je n'ai plus jamais eu le soucis depuis. ;)

olivier42
Timide
Messages : 145
Inscription : 26 janv. 2016, 07:47
Localisation : Montpellier
Contact :

Re: Pb SQL - Jeedom instable dpuis 2 jours

Message par olivier42 » 12 févr. 2018, 15:26

Pour info, sqld vient de planter là. J'ai :

Code : Tout sélectionner

olivier@Jeedom:~$ ps -eo pmem,pcpu,pid,args | tail -n +2 | sort -rnk 1 | head
 3.9  8.1  4055 php-fpm: pool www                                                       
 3.9  8.1  3917 php-fpm: pool www                                                       
 3.9  7.8 12766 php-fpm: pool www                                                       
 0.7  3.7  1916 /usr/bin/python /usr/share/nginx/www/jeedom/plugins/blea/resources/blead/blead.py --loglevel error --device hci0 --socketport 55008 --sockethost 127.0.0.1 --callback http://127.0.0.1:80/plugins/blea/core/php/jeeBlea.php --apikey 3tiDfNi7EHE1lY1242I6gPsj32tZFCaUemjdX1XK5x7xDZSb --daemonname local
 0.7  2.4  1989 /usr/bin/python /usr/share/nginx/www/jeedom/plugins/broadlink/resources/broadlinkd/broadlinkd.py --loglevel debug --socketport 55013 --sockethost 127.0.0.1 --callback http://127.0.0.1:80/plugins/broadlink/core/php/jeeBroadlink.php --apikey 13UkMEpnSwmHNqGMRxbjcfn0lpljgAQx4gJTI3q74VYfMeGy --cycle 0.3 --pid /tmp/jeedom/broadlink/deamon.pid
 0.5  0.3 18287 sshd: olivier [priv]
 0.4  1.7 18300 -bash
 0.3  0.1   154 /lib/systemd/systemd-journald
 0.3  0.0   851 php-fpm: master process (/etc/php5/fpm/php-fpm.conf)                    
 0.3  0.0 18298 sshd: olivier@pts/1 

Code : Tout sélectionner

olivier@Jeedom:~$ free -h
             total       used       free     shared    buffers     cached
Mem:          970M       953M        17M       7,2M        44M        47M
-/+ buffers/cache:       860M       109M
Swap:         9,9G       352M       9,6G
et les dernières lignes de dmesg :

Code : Tout sélectionner

[63131.801851] python invoked oom-killer: gfp_mask=0x24000c0(GFP_KERNEL), nodemask=0, order=2, oom_score_adj=0
[63131.816543] python cpuset=/ mems_allowed=0
[63131.823114] CPU: 2 PID: 12755 Comm: python Not tainted 4.9.35-v7+ #1014
[63131.832351] Hardware name: BCM2835
[63131.838439] [<8010fb3c>] (unwind_backtrace) from [<8010c058>] (show_stack+0x20/0x24)
[63131.851552] [<8010c058>] (show_stack) from [<80455880>] (dump_stack+0xd4/0x118)
[63131.861505] [<80455880>] (dump_stack) from [<8026cd84>] (dump_header+0x9c/0x1f4)
[63131.874101] [<8026cd84>] (dump_header) from [<802106a0>] (oom_kill_process+0x3e0/0x4e4)
[63131.887964] [<802106a0>] (oom_kill_process) from [<80210b08>] (out_of_memory+0x124/0x334)
[63131.901911] [<80210b08>] (out_of_memory) from [<80215c34>] (__alloc_pages_nodemask+0xcf4/0xdd0)
[63131.916699] [<80215c34>] (__alloc_pages_nodemask) from [<80215d30>] (__get_free_pages+0x20/0x70)
[63131.932107] [<80215d30>] (__get_free_pages) from [<80116c48>] (pgd_alloc+0x28/0x118)
[63131.946423] [<80116c48>] (pgd_alloc) from [<80119e9c>] (mm_init+0xd4/0x16c)
[63131.956627] [<80119e9c>] (mm_init) from [<8011a558>] (mm_alloc+0x5c/0x68)
[63131.966558] [<8011a558>] (mm_alloc) from [<802782c8>] (do_execveat_common+0x250/0x6c0)
[63131.980981] [<802782c8>] (do_execveat_common) from [<80278770>] (do_execve+0x38/0x40)
[63131.995100] [<80278770>] (do_execve) from [<802789bc>] (SyS_execve+0x2c/0x30)
[63132.005499] [<802789bc>] (SyS_execve) from [<801080c0>] (ret_fast_syscall+0x0/0x1c)
[63132.020062] Mem-Info:
[63132.025989] active_anon:18546 inactive_anon:18568 isolated_anon:0
 active_file:16352 inactive_file:15863 isolated_file:0
 unevictable:0 dirty:12 writeback:14 unstable:0
 slab_reclaimable:170517 slab_unreclaimable:3312
 mapped:3194 shmem:1781 pagetables:801 bounce:0
 free:1649 free_pcp:205 free_cma:0
[63132.077405] Node 0 active_anon:74060kB inactive_anon:74356kB active_file:65412kB inactive_file:63456kB unevictable:0kB isolated(anon):0kB isolated(file):0kB mapped:12780kB dirty:48kB writeback:56kB shmem:7124kB writeback_tmp:0kB unstable:0kB pages_scanned:0 all_unreclaimable? no
[63132.113612] Normal free:5832kB min:3968kB low:4960kB high:5952kB active_anon:74080kB inactive_anon:74416kB active_file:65224kB inactive_file:63436kB unevictable:0kB writepending:104kB present:1015808kB managed:994236kB mlocked:0kB slab_reclaimable:682744kB slab_unreclaimable:13248kB kernel_stack:1504kB pagetables:3204kB bounce:0kB free_pcp:972kB local_pcp:0kB free_cma:0kB
[63132.161181] lowmem_reserve[]: 0 0
[63132.167533] Normal: 1247*4kB (UMEC) 158*8kB (UMEC) 0*16kB 0*32kB 0*64kB 0*128kB 0*256kB 0*512kB 0*1024kB 0*2048kB 0*4096kB = 6252kB
[63132.185020] 34588 total pagecache pages
[63132.190160] 709 pages in swap cache
[63132.196388] Swap cache stats: add 182697, delete 181988, find 1865370/1890415
[63132.206280] Free swap  = 10191200kB
[63132.212496] Total swap = 10402776kB
[63132.218834] 253952 pages RAM
[63132.224245] 0 pages HighMem/MovableOnly
[63132.230669] 5393 pages reserved
[63132.236321] 2048 pages cma reserved
[63132.242152] [ pid ]   uid  tgid total_vm      rss nr_ptes nr_pmds swapents oom_score_adj name
[63132.255420] [  154]     0   154     2537      557       9       0       38             0 systemd-journal
[63132.270216] [  158]     0   158     2981      344       8       0      194         -1000 systemd-udevd
[63132.284745] [  501]     0   501     2160      231       8       0     1180             0 dhclient
[63132.298160] [  543]     0   543     1230      504       8       0       43             0 bluetoothd
[63132.311652] [  546]     0   546     1253      363       7       0       40             0 cron
[63132.325097] [  553]   110   553      947      504       6       0       39             0 avahi-daemon
[63132.338835] [  554]     0   554     1222      377       8       0      123             0 smartd
[63132.351472] [  555]     0   555     8013      360      11       0      202             0 rsyslogd
[63132.364944] [  557]     0   557      518      247       6       0       21             0 inetd
[63132.378074] [  560]     0   560      959      501       7       0       32             0 systemd-logind
[63132.391361] [  561]   107   561     1351      499       7       0       48          -900 dbus-daemon
[63132.404454] [  568]   110   568      947        3       5       0       52             0 avahi-daemon
[63132.417942] [  596]     0   596      455      246       6       0        6             0 cameras_detecti
[63132.431325] [  604]     0   604      455       48       4       0       16             0 cameras_detecti
[63132.444518] [  610]     0   610      455      238       6       0        6             0 cameras_detecti
[63132.457839] [  642]     0   642     1944      361       8       0      114         -1000 sshd
[63132.470524] [  650]     0   650      990      307       6       0       28             0 agetty
[63132.483041] [  652]     0   652      502      242       5       0       73             0 inotifywait
[63132.496036] [  655] 65534   655      550      288       6       0       23             0 thd
[63132.508532] [  665]    33   665     1262      428       8       0      111             0 systemd
[63132.521219] [  677]    33   677     1776       26       8       0      323             0 (sd-pam)
[63132.534001] [  687]     0   687      435      307       5       0        9             0 minissdpd
[63132.546863] [  689]   101   689     1422      387       6       0       72             0 ntpd
[63132.559751] [  693]     0   693     3924      194      10       0      190             0 nginx
[63132.572365] [  694]    33   694     4089      572      11       0      223             0 nginx
[63132.585236] [  695]    33   695     4089      565      11       0      222             0 nginx
[63132.597974] [  696]    33   696     4089      563      11       0      223             0 nginx
[63132.611176] [  697]    33   697     4091      602      11       0      208             0 nginx
[63132.624332] [  698]     0   698     1217      358       7       0       57             0 upsmon
[63132.637382] [  699]   115   699     1578      375       8       0       69             0 upsmon
[63132.650958] [  851]     0   851    28919      805      27       0      733             0 php5-fpm
[63132.664626] [ 1211]     0  1211     5604      514      14       0      260             0 nmbd
[63132.677671] [ 1219]     0  1219     7174      361      18       0      314             0 winbindd
[63132.690898] [ 1230]     0  1230     7170      408      18       0      288             0 winbindd
[63132.705033] [ 1490]     0  1490     1559      201       6       0       62             0 pure-ftpd
[63132.718988] [ 1552]     0  1552     8897      517      21       0      382             0 smbd
[63132.731857] [ 1553]   109  1553     2442      312       8       0      114             0 exim4
[63132.744885] [ 1560]     0  1560     7174      331      18       0      335             0 winbindd
[63132.758231] [ 1562]     0  1562     7173      330      18       0      339             0 winbindd
[63132.771996] [ 1563]     0  1563     8897      294      19       0      377             0 smbd
[63132.785313] [ 1906]     0  1906     1692      352       8       0       86             0 sudo
[63132.798212] [ 1916]     0  1916    23321     1858      26       0     1238             0 python
[63132.811209] [ 1984]     0  1984     1692      352       8       0       86             0 sudo
[63132.824752] [ 1989]     0  1989    11625     1779      18       0     1122             0 python
[63132.838683] [ 2055]    33  2055    13043      695      26       0     1341             0 php
[63132.852061] [ 5819]  1002  5819     1743      322       7       0       64             0 pure-ftpd
[63132.865474] [ 5820]     0  5820     1743      239       7       0       81             0 pure-ftpd
[63132.879120] [11694]  1002 11694     1743      322       7       0       64             0 pure-ftpd
[63132.892760] [11698]     0 11698     1743      239       7       0       81             0 pure-ftpd
[63132.906092] [26332]     0 26332     3016      382      12       0      167             0 sshd
[63132.918941] [26403]  1001 26403     1262      442       6       0      104             0 systemd
[63132.932524] [26407]  1001 26407     6384       61      11       0      300             0 (sd-pam)
[63132.945568] [26413]  1001 26413     3050      280      10       0      177             0 sshd
[63132.958387] [26415]  1001 26415     1663      317       8       0      430             0 bash
[63132.971558] [ 3680]    33  3680    48775    11458      67       0    10277             0 php5-fpm
[63132.985237] [ 3917]    33  3917    48774    11395      67       0    10272             0 php5-fpm
[63132.998586] [ 4055]    33  4055    48776    11377      67       0    10291             0 php5-fpm
[63133.011863] [12181]     0 12181      471      320       5       0        0             0 inotifywait
[63133.025876] [12199]     0 12199      471      318       4       0        0             0 inotifywait
[63133.040257] [12755]     0 12755    23064     1643      24       0     1224             0 python
[63133.053787] Out of memory: Kill process 3680 (php5-fpm) score 7 or sacrifice child
[63133.066006] Killed process 3680 (php5-fpm) total-vm:195100kB, anon-rss:41608kB, file-rss:3232kB, shmem-rss:992kB

olivier42
Timide
Messages : 145
Inscription : 26 janv. 2016, 07:47
Localisation : Montpellier
Contact :

Re: Pb SQL - Jeedom instable dpuis 2 jours

Message par olivier42 » 12 févr. 2018, 15:32

(je précise c'est une RPI2 mais qui tourne sur SSD, par sur sdcard).

La tailles de mes tables, ca ne me parrait pas énorme :

Code : Tout sélectionner

Database	Table	Size in MB
jeedom	historyArch	38.08
jeedom	history	1.34
jeedom	cmd	0.64
jeedom	eqLogic	0.47
jeedom	scenario	0.11
jeedom	eqReal	0.09
jeedom	scenarioSubElement	0.08
jeedom	scenarioExpression	0.08
jeedom	cron	0.08
jeedom	viewData	0.06
jeedom	update	0.06
jeedom	object	0.06
jeedom	config	0.05
jeedom	plan	0.05
jeedom	viewZone	0.03
jeedom	view	0.03
jeedom	dataStore	0.03
jeedom	message	0.03
jeedom	listener	0.03
jeedom	cache	0.03
jeedom	interactDef	0.02
jeedom	user	0.02
jeedom	scenarioElement	0.02
jeedom	blea_remote	0.02
jeedom	planHeader	0.02
jeedom	calendar_event	0.02
jeedom	interactQuery	0.00
information_schema	EVENTS	0.00
information_schema	ROUTINES	0.00
information_schema	COLUMNS	0.00
information_schema	VIEWS	0.00
information_schema	TRIGGERS	0.00
information_schema	PROCESSLIST	0.00
information_schema	PLUGINS	0.00
information_schema	PARTITIONS	0.00
information_schema	PARAMETERS	0.00
information_schema	GLOBAL_STATUS	0.00
information_schema	SESSION_VARIABLES	0.00
information_schema	INNODB_CMPMEM	0.00
information_schema	FILES	0.00
information_schema	SESSION_STATUS	0.00
information_schema	INNODB_LOCK_WAITS	0.00
information_schema	SCHEMA_PRIVILEGES	0.00
information_schema	INNODB_BUFFER_POOL_STATS	0.00
information_schema	ENGINES	0.00
information_schema	SCHEMATA	0.00
information_schema	INNODB_TRX	0.00
information_schema	COLUMN_PRIVILEGES	0.00
information_schema	INNODB_BUFFER_PAGE	0.00
information_schema	REFERENTIAL_CONSTRAINTS	0.00
information_schema	COLLATION_CHARACTER_SET_APPLICABILITY	0.00
information_schema	PROFILING	0.00
information_schema	USER_PRIVILEGES	0.00
information_schema	COLLATIONS	0.00
information_schema	TABLE_PRIVILEGES	0.00
information_schema	CHARACTER_SETS	0.00
information_schema	INNODB_BUFFER_PAGE_LRU	0.00
information_schema	TABLE_CONSTRAINTS	0.00
information_schema	INNODB_CMP_RESET	0.00
information_schema	TABLESPACES	0.00
information_schema	INNODB_CMPMEM_RESET	0.00
information_schema	KEY_COLUMN_USAGE	0.00
information_schema	TABLES	0.00
information_schema	INNODB_LOCKS	0.00
information_schema	GLOBAL_VARIABLES	0.00
information_schema	STATISTICS	0.00

Avatar de l’utilisateur
loic
Administrateur
Messages : 14862
Inscription : 01 févr. 2014, 16:21

Re: Pb SQL - Jeedom instable dpuis 2 jours

Message par loic » 12 févr. 2018, 15:41

Comme ça je verrais déjà :
- passage a stretch pour php7
- passage de nginx à apache
- suppression de pure-ftpd pour alléger le system

Si toujours plantage :
- deport de BLEA qui consomme pas mal de ressourse
Aide nous à t'aider : mets des logs, détaille ton soucis... Vous n'aurez aucune réponse de ma part si votre demande n'est pas détaillée (log, capture d'écran lisible...) ou si vous ne postez pas dans la bonne section

Répondre

Revenir vers « Utilisation »

Qui est en ligne ?

Utilisateurs parcourant ce forum : Aucun utilisateur inscrit et 2 invités