Po przywróceniu z backupu bazy supla-server wyrzuca błąd

Post Reply
cosmita
Posts: 94
Joined: Tue Sep 11, 2018 11:06 am

Tue Jul 02, 2019 2:21 pm

Witam,

Musiałem przywrócić z backupu suple na swoim raspberry zrobiłem wszystko z instrukcji:

viewtopic.php?t=3078

supla-cloud dziala i moge wejsc na strone lokalnie ale urzadzenia oraz aplikacja z telefonu nie moze sie polaczyc. Logi mowia to:

Code: Select all

docker logs --tail=50 supla-server
ERR[1562077244.785959] MySQL - execute error: PROCEDURE supla.supla_update_iodevice does not exist
ERR[1562077244.926643] MySQL - execute error: PROCEDURE supla.supla_update_iodevice does not exist
INFO[1562077245.493192] Connection accepted: 192.168.100.19:16677 ClientSD: 15 Secure: 1
INFO[1562077245.688808] Cipher: AES128-SHA, ClientSD: 15
ERR[1562077245.866146] MySQL - execute error: PROCEDURE supla.supla_update_iodevice does not exist
INFO[1562077246.799670] Connection accepted: 192.168.100.50:21425 ClientSD: 18 Secure: 1
INFO[1562077246.944581] Connection accepted: 192.168.100.98:22358 ClientSD: 19 Secure: 1
INFO[1562077246.981133] Cipher: AES128-SHA, ClientSD: 18
INFO[1562077247.103714] Cipher: AES128-SHA, ClientSD: 19
ERR[1562077247.140041] MySQL - execute error: PROCEDURE supla.supla_update_iodevice does not exist
ERR[1562077247.263788] MySQL - execute error: PROCEDURE supla.supla_update_iodevice does not exist
INFO[1562077247.914245] Connection accepted: 192.168.100.19:16517 ClientSD: 20 Secure: 1
INFO[1562077248.98425] Cipher: AES128-SHA, ClientSD: 20
ERR[1562077248.275716] MySQL - execute error: PROCEDURE supla.supla_update_iodevice does not exist
INFO[1562077249.153514] Connection accepted: 192.168.100.50:48578 ClientSD: 17 Secure: 1
INFO[1562077249.289849] Connection accepted: 192.168.100.98:10517 ClientSD: 18 Secure: 1
INFO[1562077249.308604] Cipher: AES128-SHA, ClientSD: 17
INFO[1562077249.479349] Cipher: AES128-SHA, ClientSD: 18
ERR[1562077249.514602] MySQL - execute error: PROCEDURE supla.supla_update_iodevice does not exist
ERR[1562077249.631513] MySQL - execute error: PROCEDURE supla.supla_update_iodevice does not exist
INFO[1562077250.368791] Connection accepted: 192.168.100.19:23470 ClientSD: 19 Secure: 1
INFO[1562077250.555101] Cipher: AES128-SHA, ClientSD: 19
ERR[1562077250.715193] MySQL - execute error: PROCEDURE supla.supla_update_iodevice does not exist
INFO[1562077251.529965] Connection accepted: 192.168.100.50:21989 ClientSD: 20 Secure: 1
INFO[1562077251.677565] Connection accepted: 192.168.100.98:14877 ClientSD: 17 Secure: 1
INFO[1562077251.710155] Cipher: AES128-SHA, ClientSD: 20
INFO[1562077251.832132] Cipher: AES128-SHA, ClientSD: 17
ERR[1562077251.862979] MySQL - execute error: PROCEDURE supla.supla_update_iodevice does not exist
ERR[1562077251.986161] MySQL - execute error: PROCEDURE supla.supla_update_iodevice does not exist
INFO[1562077252.752959] Connection accepted: 192.168.100.19:2330 ClientSD: 18 Secure: 1
INFO[1562077252.925241] Cipher: AES128-SHA, ClientSD: 18
ERR[1562077253.91044] MySQL - execute error: PROCEDURE supla.supla_update_iodevice does not exist
INFO[1562077253.878586] Connection accepted: 192.168.100.50:41968 ClientSD: 19 Secure: 1
INFO[1562077254.13566] Connection accepted: 192.168.100.98:5810 ClientSD: 20 Secure: 1
INFO[1562077254.49862] Cipher: AES128-SHA, ClientSD: 19
INFO[1562077254.172885] Cipher: AES128-SHA, ClientSD: 20
ERR[1562077254.214749] MySQL - execute error: PROCEDURE supla.supla_update_iodevice does not exist
ERR[1562077254.343574] MySQL - execute error: PROCEDURE supla.supla_update_iodevice does not exist
INFO[1562077255.130438] Connection accepted: 192.168.100.19:18174 ClientSD: 17 Secure: 1
INFO[1562077255.309337] Cipher: AES128-SHA, ClientSD: 17
ERR[1562077255.463600] MySQL - execute error: PROCEDURE supla.supla_update_iodevice does not exist
INFO[1562077256.231834] Connection accepted: 192.168.100.50:27657 ClientSD: 18 Secure: 1
INFO[1562077256.410715] Cipher: AES128-SHA, ClientSD: 18
INFO[1562077256.439094] Connection accepted: 192.168.100.98:45002 ClientSD: 19 Secure: 1
ERR[1562077256.563975] MySQL - execute error: PROCEDURE supla.supla_update_iodevice does not exist
INFO[1562077256.600507] Cipher: AES128-SHA, ClientSD: 19
ERR[1562077256.751534] MySQL - execute error: PROCEDURE supla.supla_update_iodevice does not exist
INFO[1562077257.485035] Connection accepted: 192.168.100.19:41751 ClientSD: 20 Secure: 1
INFO[1562077257.677715] Cipher: AES128-SHA, ClientSD: 20
ERR[1562077257.843080] MySQL - execute error: PROCEDURE supla.supla_update_iodevice does not exist
nie wiem co dalej, probowalem wyczyscic cache ale to nic nie pomoglo
User avatar
pzygmunt
Posts: 7065
Joined: Tue Jan 19, 2016 9:26 am
Location: Paczków
Contact:

Tue Jul 02, 2019 3:16 pm

Backup nie zawierał procedur
cosmita
Posts: 94
Joined: Tue Sep 11, 2018 11:06 am

Tue Jul 02, 2019 3:19 pm

ehh, to co powinienem zrobic aby backup zawieral procedury?
User avatar
pzygmunt
Posts: 7065
Joined: Tue Jan 19, 2016 9:26 am
Location: Paczków
Contact:

Tue Jul 02, 2019 3:37 pm

Musisz dodać przełącznik --routines przy robieniu backupu.
Same procedury możesz przywrócić z innej bazy o tej samej wersji.
cosmita
Posts: 94
Joined: Tue Sep 11, 2018 11:06 am

Tue Jul 02, 2019 3:43 pm

dziekuje, zrobilem, baza jest wieksza, pozostaje przywrocic i sprawdzic
cosmita
Posts: 94
Joined: Tue Sep 11, 2018 11:06 am

Tue Jul 02, 2019 4:35 pm

Wszystko smiga, dziekuje. Moze by dopisac to w tej instrukcji backupu i przywracania?
User avatar
pzygmunt
Posts: 7065
Joined: Tue Jan 19, 2016 9:26 am
Location: Paczków
Contact:

Tue Jul 02, 2019 4:37 pm

W której ?
User avatar
lesny8
Posts: 868
Joined: Mon Dec 11, 2017 9:43 pm

Tue Jul 02, 2019 5:49 pm

Hehe, też to wczoraj odkryłem, że mój backup nie zawiera procedur i miałem właśnie o tym pisać :)
User avatar
pzygmunt
Posts: 7065
Joined: Tue Jan 19, 2016 9:26 am
Location: Paczków
Contact:

Tue Jul 02, 2019 5:58 pm

Uzupełniłem
Post Reply