Meshlium stopped syncing with external database

Development questions: create new plugins, add new features...
JeffreyArts
Posts: 35
Joined: Thu Sep 01, 2016 4:39 pm

Meshlium stopped syncing with external database

Post by JeffreyArts » Wed Mar 29, 2017 10:47 am

Hey Libelium team,

Our Meshlium is receiving various sensor data through Zigbee. This data is configured to be synced with an external database every 30 seconds. The syncing worked correctly for the past few weeks, but stopped working today. Nothing has changed in our configuration and the Meshlium is up to date.

This problem has occurred before, where the Meshlium stopped syncing without a reason. Sometimes restarting the Meshlium solved this problem.

I wonder if you guys have any know how on how to solve this issue.

libelium-dev
Posts: 27967
Joined: Mon Sep 28, 2009 1:06 pm

Re: Meshlium stopped syncing with external database

Post by libelium-dev » Wed Mar 29, 2017 12:09 pm

Hi JeffreyArts,

You can check the logs of the database:

1. set log = 3 in section Daemon of the file /mnt/lib/cfg/DBsync/setup.ini.

2. Check the file:

Code: Select all

/mnt/user/logs/db_sync.log
If you still has problems, please reply to this message with the above mentioned log.

Regards

JeffreyArts
Posts: 35
Joined: Thu Sep 01, 2016 4:39 pm

Re: Meshlium stopped syncing with external database

Post by JeffreyArts » Wed Mar 29, 2017 1:36 pm

Initially the file was empty. I then 'Synchronize now' button. Which resulted with the following inside the log:

Code: Select all

[2017-03-29 13:11:35.235] [DEBUG] wifi sync activated
[2017-03-29 13:11:35.406] [DEBUG] 100 wifiScan registers ready to be synchronized
I then decided to restart the Meshlium, to try to get more information in to the log. Which again resulted in the following info shown in the log:

Code: Select all

[2017-03-29 07:48:29.344] [DEBUG] wifi sync activated
[2017-03-29 07:48:30.008] [DEBUG] 100 wifiScan registers ready to be synchronized
Thank you for your support.

JeffreyArts
Posts: 35
Joined: Thu Sep 01, 2016 4:39 pm

Re: Meshlium stopped syncing with external database

Post by JeffreyArts » Wed Mar 29, 2017 1:45 pm

The log has just updated, this is the full log now:

Code: Select all

[2017-03-29 13:11:35.235] [DEBUG] wifi sync activated
[2017-03-29 13:11:35.406] [DEBUG] 100 wifiScan registers ready to be synchronized
[2017-03-29 07:48:29.344] [DEBUG] wifi sync activated
[2017-03-29 07:48:30.008] [DEBUG] 100 wifiScan registers ready to be synchronized
[2017-03-29 13:20:01.138] [ERROR] Failed to get DB handle: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '10.1.6.6' (110)
[2017-03-29 13:20:02.059] [DEBUG] wifi sync activated
[2017-03-29 13:20:02.170] [DEBUG] 100 wifiScan registers ready to be synchronized
[2017-03-29 13:23:06.729] [ERROR] Failed to get DB handle: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '10.1.6.6' (110)
[2017-03-29 13:23:07.507] [DEBUG] wifi sync activated
[2017-03-29 13:23:07.637] [DEBUG] 100 wifiScan registers ready to be synchronized
[2017-03-29 13:26:12.197] [ERROR] Failed to get DB handle: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '10.1.6.6' (110)
[2017-03-29 13:26:12.937] [DEBUG] wifi sync activated
[2017-03-29 13:26:13.052] [DEBUG] 100 wifiScan registers ready to be synchronized
[2017-03-29 13:29:17.611] [ERROR] Failed to get DB handle: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '10.1.6.6' (110)
[2017-03-29 13:29:18.316] [DEBUG] wifi sync activated
[2017-03-29 13:29:18.422] [DEBUG] 100 wifiScan registers ready to be synchronized

JeffreyArts
Posts: 35
Joined: Thu Sep 01, 2016 4:39 pm

Re: Meshlium stopped syncing with external database

Post by JeffreyArts » Wed Mar 29, 2017 2:12 pm

Apparently the MySQL error was caused by the wifiScanner being configured to the wrong IP for the external database. This is now fixed.
I'm still attempting to synchronise my sensor data with the external database.

libelium-dev
Posts: 27967
Joined: Mon Sep 28, 2009 1:06 pm

Re: Meshlium stopped syncing with external database

Post by libelium-dev » Fri Mar 31, 2017 8:42 am

Hi JeffreyArts,

Did you solve the problem?

Regards

JeffreyArts
Posts: 35
Joined: Thu Sep 01, 2016 4:39 pm

Re: Meshlium stopped syncing with external database

Post by JeffreyArts » Fri Mar 31, 2017 9:25 am

Unfortunately no. The log is not giving any more/additional information.

Any suggestions?

JeffreyArts
Posts: 35
Joined: Thu Sep 01, 2016 4:39 pm

Re: Meshlium stopped syncing with external database

Post by JeffreyArts » Fri Mar 31, 2017 10:24 am

Also the weird thing is, our WifiScan successfully synchronises all the data with our external database. The sensorParser however, does not, with the same external database.

I tried recreating the sensorParser table on the external database to ensure it's identical to the meshlium's internal database. This unfortunately did not fix it either.

libelium-dev
Posts: 27967
Joined: Mon Sep 28, 2009 1:06 pm

Re: Meshlium stopped syncing with external database

Post by libelium-dev » Mon Apr 03, 2017 9:20 am

Hi JeffreyArts,

Please, send us some technical information about your Meshlium. Connect vía ssh and send us the result of this commands:

Code: Select all

df -h

Code: Select all

ifconfig

Code: Select all

tail -n 100 /var/log/kern.log
Best regards!

JeffreyArts
Posts: 35
Joined: Thu Sep 01, 2016 4:39 pm

Re: Meshlium stopped syncing with external database

Post by JeffreyArts » Wed Apr 05, 2017 9:42 am

Hey libelium-dev, see the data below.

df -h

Code: Select all

Filesystem            Size  Used Avail Use% Mounted on
rootfs                1.5G  932M  469M  67% /
udev                   10M  2.6M  7.5M  26% /dev
/dev/disk/by-label/ROOT_FS
                      1.5G  932M  469M  67% /
tmpfs                 125M   12M  114M   9% /lib/init/rw
varrun                125M   76K  125M   1% /var/run
varlock               125M  4.0K  125M   1% /var/lock
tmpfs                 125M  4.0K  125M   1% /dev/shm
/dev/hda3             4.9G  2.9G  1.8G  62% /mnt/user
tmpfs                 125M  2.8M  123M   3% /tmp
tmpfs                 125M   12M  114M   9% /var/log
tmpfs                 125M   12M  114M   9% /var/tmp
/dev/mapper/lib       887M   43M  800M   6% /mnt/lib
ifconfig

Code: Select all

ath0      Link encap:Ethernet  HWaddr 00:1b:b1:b1:4e:01  
          inet addr:10.10.10.1  Bcast:10.10.10.255  Mask:255.255.255.0
          inet6 addr: fe80::21b:b1ff:feb1:4e01/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:2290  Metric:1
          RX packets:0 errors:0 dropped:0 overruns:0 frame:0
          TX packets:8 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0 
          RX bytes:0 (0.0 B)  TX bytes:636 (636.0 B)

ath1      Link encap:UNSPEC  HWaddr 00-1B-B1-B1-4E-4F-61-74-00-00-00-00-00-00-00-00  
          UP BROADCAST NOTRAILERS RUNNING PROMISC ALLMULTI  MTU:1500  Metric:1
          RX packets:10259019 errors:0 dropped:0 overruns:0 frame:0
          TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0 
          RX bytes:3306354921 (3.0 GiB)  TX bytes:0 (0.0 B)

eth0      Link encap:Ethernet  HWaddr 00:0d:b9:3e:2f:84  
          inet addr:192.168.1.211  Bcast:192.168.1.255  Mask:255.255.255.0
          inet6 addr: fe80::20d:b9ff:fe3e:2f84/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:6685226 errors:0 dropped:0 overruns:0 frame:0
          TX packets:6431805 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:1104012661 (1.0 GiB)  TX bytes:1262789356 (1.1 GiB)
          Interrupt:10 Base address:0xa000 

lo        Link encap:Local Loopback  
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:1283301 errors:0 dropped:0 overruns:0 frame:0
          TX packets:1283301 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0 
          RX bytes:605669455 (577.6 MiB)  TX bytes:605669455 (577.6 MiB)

wifi0     Link encap:UNSPEC  HWaddr 00-1B-B1-B1-4E-01-61-74-00-00-00-00-00-00-00-00  
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:235441 errors:0 dropped:0 overruns:0 frame:237593730
          TX packets:130843 errors:59308 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:199 
          RX bytes:25729625 (24.5 MiB)  TX bytes:22764914 (21.7 MiB)
          Interrupt:9 

wifi1     Link encap:UNSPEC  HWaddr 00-1B-B1-B1-4E-4F-61-74-00-00-00-00-00-00-00-00  
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:373676881 errors:0 dropped:0 overruns:0 frame:149713671
          TX packets:47 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:199 
          RX bytes:2840592455 (2.6 GiB)  TX bytes:4132 (4.0 KiB)
          Interrupt:11 
tail -n 100 /var/log/kern.log

Code: Select all

Apr  5 01:20:01 localhost vmunix: [379165.136240] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 01:25:01 localhost vmunix: [379465.444020] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 01:30:01 localhost vmunix: [379764.762609] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 01:35:01 localhost vmunix: [380065.126731] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 01:40:01 localhost vmunix: [380364.698633] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 01:45:01 localhost vmunix: [380665.004616] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 01:50:01 localhost vmunix: [380965.292825] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 01:55:02 localhost vmunix: [381265.602335] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 02:00:01 localhost vmunix: [381564.947536] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 02:05:01 localhost vmunix: [381865.281635] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 02:10:01 localhost vmunix: [382164.725441] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 02:15:01 localhost vmunix: [382465.080087] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 02:20:01 localhost vmunix: [382765.429682] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 02:25:01 localhost vmunix: [383064.769520] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 02:30:01 localhost vmunix: [383365.112265] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 02:35:01 localhost vmunix: [383665.416873] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 02:40:01 localhost vmunix: [383964.829334] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 02:41:13 localhost vmunix: [384036.953830] wifi0: stuck beacon; resetting (bmiss count 11)
Apr  5 02:45:01 localhost vmunix: [384265.140777] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 02:50:01 localhost vmunix: [384565.471508] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 02:55:01 localhost vmunix: [384864.903910] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 03:00:01 localhost vmunix: [385165.463397] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 03:05:01 localhost vmunix: [385464.919231] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 03:10:01 localhost vmunix: [385765.501183] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 03:15:01 localhost vmunix: [386064.964843] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 03:20:01 localhost vmunix: [386365.467023] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 03:25:01 localhost vmunix: [386664.969091] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 03:30:01 localhost vmunix: [386965.432259] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 03:35:01 localhost vmunix: [387264.866388] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 03:40:01 localhost vmunix: [387565.403849] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 03:45:01 localhost vmunix: [387864.711601] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 03:50:01 localhost vmunix: [388165.020303] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 03:55:01 localhost vmunix: [388465.331922] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 04:00:02 localhost vmunix: [388765.619392] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 04:05:01 localhost vmunix: [389064.935635] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 04:10:01 localhost vmunix: [389365.366795] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 04:15:01 localhost vmunix: [389664.725847] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 04:20:01 localhost vmunix: [389965.091097] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 04:25:01 localhost vmunix: [390265.421011] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 04:30:01 localhost vmunix: [390564.765440] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 04:35:01 localhost vmunix: [390865.250308] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 04:40:01 localhost vmunix: [391164.685802] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 04:45:01 localhost vmunix: [391465.014260] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 04:50:01 localhost vmunix: [391764.661679] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 04:55:01 localhost vmunix: [392064.976224] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 05:00:01 localhost vmunix: [392365.311159] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 05:05:02 localhost vmunix: [392665.695265] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 05:10:01 localhost vmunix: [392965.415438] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 05:15:01 localhost vmunix: [393264.830870] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 05:20:01 localhost vmunix: [393565.433433] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 05:25:01 localhost vmunix: [393864.876485] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 05:30:01 localhost vmunix: [394165.261680] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 05:35:01 localhost vmunix: [394465.582496] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 05:40:01 localhost vmunix: [394765.150987] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 05:45:01 localhost vmunix: [395065.457152] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 05:50:01 localhost vmunix: [395364.738117] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 05:55:01 localhost vmunix: [395665.026103] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 06:00:01 localhost vmunix: [395965.314505] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 06:05:02 localhost vmunix: [396265.594823] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 06:10:01 localhost vmunix: [396565.108763] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 06:15:01 localhost vmunix: [396865.427141] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 06:20:01 localhost vmunix: [397164.812945] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 06:25:01 localhost vmunix: [397465.433841] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 06:30:01 localhost vmunix: [397765.265777] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 06:35:02 localhost vmunix: [398065.640838] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 06:40:01 localhost vmunix: [398365.182892] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 06:45:01 localhost vmunix: [398665.521106] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 06:50:01 localhost vmunix: [398964.865485] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 06:55:01 localhost vmunix: [399265.232852] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 07:00:02 localhost vmunix: [399565.619949] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 07:05:01 localhost vmunix: [399865.073508] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 07:10:01 localhost vmunix: [400164.894796] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 07:15:01 localhost vmunix: [400465.440053] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 07:20:01 localhost vmunix: [400764.881765] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 07:25:01 localhost vmunix: [401065.287641] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 07:30:01 localhost vmunix: [401364.722680] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 07:35:01 localhost vmunix: [401665.390320] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 07:40:01 localhost vmunix: [401965.049649] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 07:45:01 localhost vmunix: [402265.384501] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 07:50:01 localhost vmunix: [402564.731815] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 07:55:01 localhost vmunix: [402865.076640] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 08:00:01 localhost vmunix: [403165.389093] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 08:05:01 localhost vmunix: [403464.678212] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 08:10:01 localhost vmunix: [403765.102794] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 08:15:01 localhost vmunix: [404065.579182] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 08:20:01 localhost vmunix: [404365.148008] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 08:25:01 localhost vmunix: [404665.476510] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 08:30:01 localhost vmunix: [404964.992384] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 08:35:01 localhost vmunix: [405265.361607] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 08:40:01 localhost vmunix: [405564.874513] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 08:45:01 localhost vmunix: [405865.449522] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 08:50:01 localhost vmunix: [406165.088377] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 08:55:01 localhost vmunix: [406465.448264] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 09:00:01 localhost vmunix: [406764.804054] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 09:05:01 localhost vmunix: [407065.126318] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 09:10:01 localhost vmunix: [407365.528559] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 09:15:01 localhost vmunix: [407664.863656] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 09:20:01 localhost vmunix: [407965.221125] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 09:20:57 localhost vmunix: [408021.259838] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Apr  5 09:25:01 localhost vmunix: [408264.687501] EXT2-fs warning: mounting unchecked fs, running e2fsck is recommended
Thanks for the help.

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest