Brak odczytów w historii przez 7 godzin

Awatar użytkownika
lesny8
Posty: 2802
Rejestracja: pn gru 11, 2017 9:43 pm

Z bazy logów to za wiele nie ma :roll: a z przedwczoraj to nie ma tam nic :?

Kod: Zaznacz cały

docker logs supla-db
2021-07-08T20:50:18.669901Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-07-08T20:50:18.673021Z 0 [Note] mysqld (mysqld 5.7.20) starting as process 1 ...
2021-07-08T20:50:18.681449Z 0 [Note] InnoDB: PUNCH HOLE support available
2021-07-08T20:50:18.681513Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-07-08T20:50:18.681528Z 0 [Note] InnoDB: Uses event mutexes
2021-07-08T20:50:18.681541Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-07-08T20:50:18.681554Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2021-07-08T20:50:18.681567Z 0 [Note] InnoDB: Using Linux native AIO
2021-07-08T20:50:18.682202Z 0 [Note] InnoDB: Number of pools: 1
2021-07-08T20:50:18.682514Z 0 [Note] InnoDB: Using CPU crc32 instructions
2021-07-08T20:50:18.686095Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-07-08T20:50:18.710431Z 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-08T20:50:18.714175Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-07-08T20:50:18.727759Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2021-07-08T20:50:18.830855Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-08T20:50:18.831123Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-08T20:50:19.508270Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-07-08T20:50:19.510372Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2021-07-08T20:50:19.510417Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2021-07-08T20:50:19.511054Z 0 [Note] InnoDB: Waiting for purge to start
2021-07-08T20:50:19.561278Z 0 [Note] InnoDB: 5.7.20 started; log sequence number 41751359
2021-07-08T20:50:19.561760Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2021-07-08T20:50:19.561931Z 0 [Note] Plugin 'FEDERATED' is disabled.
2021-07-08T20:50:19.571124Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210708 20:50:19
2021-07-08T20:50:19.571171Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2021-07-08T20:50:19.571744Z 0 [Warning] CA certificate ca.pem is self signed.
2021-07-08T20:50:19.575595Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2021-07-08T20:50:19.575654Z 0 [Note] IPv6 is available.
2021-07-08T20:50:19.575675Z 0 [Note]   - '::' resolves to '::';
2021-07-08T20:50:19.575712Z 0 [Note] Server socket created on IP: '::'.
2021-07-08T20:50:19.842769Z 0 [Note] Event Scheduler: Loaded 0 events
2021-07-08T20:50:19.843090Z 0 [Note] mysqld: ready for connections.
Version: '5.7.20'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)
2021-07-08T20:50:19.843117Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check.
2021-07-08T20:50:19.843126Z 0 [Note] Beginning of list of non-natively partitioned tables
2021-07-08T20:50:19.874018Z 0 [Note] End of list of non-natively partitioned tables
2021-07-22T22:15:34.846370Z 0 [Note] Giving 0 client threads a chance to die gracefully
2021-07-22T22:15:34.868789Z 0 [Note] Shutting down slave threads
2021-07-22T22:15:34.868844Z 0 [Note] Forcefully disconnecting 0 remaining clients
2021-07-22T22:15:34.888945Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2021-07-22T22:15:35.426797Z 0 [Note] Binlog end
2021-07-23T08:27:15.420291Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-07-23T08:27:15.423203Z 0 [Note] mysqld (mysqld 5.7.20) starting as process 1 ...
2021-07-23T08:27:15.431144Z 0 [Note] InnoDB: PUNCH HOLE support available
2021-07-23T08:27:15.431200Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-07-23T08:27:15.431215Z 0 [Note] InnoDB: Uses event mutexes
2021-07-23T08:27:15.431228Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-07-23T08:27:15.431241Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2021-07-23T08:27:15.431253Z 0 [Note] InnoDB: Using Linux native AIO
2021-07-23T08:27:15.431992Z 0 [Note] InnoDB: Number of pools: 1
2021-07-23T08:27:15.432202Z 0 [Note] InnoDB: Using CPU crc32 instructions
2021-07-23T08:27:15.435695Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-07-23T08:27:15.460192Z 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-23T08:27:15.479098Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-07-23T08:27:15.554516Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2021-07-23T08:27:15.604770Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 45268182
2021-07-23T08:27:15.604816Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 45268191
2021-07-23T08:27:15.604833Z 0 [Note] InnoDB: Database was not shutdown normally!
2021-07-23T08:27:15.604848Z 0 [Note] InnoDB: Starting crash recovery.
2021-07-23T08:27:16.824248Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-07-23T08:27:16.824304Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-23T08:27:16.824458Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-23T08:27:17.081828Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-07-23T08:27:17.083844Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2021-07-23T08:27:17.083892Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2021-07-23T08:27:17.084492Z 0 [Note] InnoDB: Waiting for purge to start
2021-07-23T08:27:17.134683Z 0 [Note] InnoDB: 5.7.20 started; log sequence number 45268191
2021-07-23T08:27:17.135217Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2021-07-23T08:27:17.135272Z 0 [Note] Plugin 'FEDERATED' is disabled.
2021-07-23T08:27:17.189427Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2021-07-23T08:27:17.204456Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210723  8:27:17
2021-07-23T08:27:17.239465Z 0 [Warning] CA certificate ca.pem is self signed.
2021-07-23T08:27:17.243452Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2021-07-23T08:27:17.243521Z 0 [Note] IPv6 is available.
2021-07-23T08:27:17.243547Z 0 [Note]   - '::' resolves to '::';
2021-07-23T08:27:17.243586Z 0 [Note] Server socket created on IP: '::'.
2021-07-23T08:27:17.773246Z 0 [Note] Event Scheduler: Loaded 0 events
2021-07-23T08:27:17.773734Z 0 [Note] mysqld: ready for connections.
Version: '5.7.20'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)
2021-07-23T08:27:17.773771Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check.
2021-07-23T08:27:17.773781Z 0 [Note] Beginning of list of non-natively partitioned tables
2021-07-23T08:27:18.325759Z 0 [Note] End of list of non-natively partitioned tables
2021-07-26T09:53:09.515995Z 0 [Note] Giving 0 client threads a chance to die gracefully
2021-07-26T09:53:09.542175Z 0 [Note] Shutting down slave threads
2021-07-26T09:53:09.542202Z 0 [Note] Forcefully disconnecting 0 remaining clients
2021-07-26T09:53:09.588703Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2021-07-26T09:53:09.596276Z 0 [Note] Binlog end
2021-07-26T09:53:09.634251Z 0 [Note] Shutting down plugin 'ngram'
2021-07-26T09:53:09.678378Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2021-07-26T09:53:09.678431Z 0 [Note] Shutting down plugin 'partition'
2021-07-26T09:53:09.678609Z 0 [Note] Shutting down plugin 'ARCHIVE'
2021-07-26T09:53:09.678633Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2021-07-26T09:53:09.690086Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2021-07-26T09:53:09.690108Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2021-07-26T09:53:09.690248Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2021-07-26T09:53:09.751127Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2021-07-26T09:53:09.751165Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2021-07-26T09:53:09.751176Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2021-07-26T09:53:09.751185Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2021-07-26T09:53:09.751194Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2021-07-26T09:53:09.751202Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2021-07-26T09:53:09.751211Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2021-07-26T09:53:09.751219Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2021-07-26T09:53:09.751227Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2021-07-26T09:53:09.751235Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2021-07-26T09:53:09.751244Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2021-07-26T09:53:09.751252Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2021-07-26T09:53:09.751260Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2021-07-26T09:53:09.751268Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2021-07-26T09:53:09.751276Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2021-07-26T09:53:09.751284Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2021-07-26T09:53:09.751292Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2021-07-26T09:53:09.751300Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2021-07-26T09:53:09.751308Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2021-07-26T09:53:09.751317Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2021-07-26T09:53:09.751324Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2021-07-26T09:53:09.751332Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2021-07-26T09:53:09.751341Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2021-07-26T09:53:09.751349Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2021-07-26T09:53:09.751357Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2021-07-26T09:53:09.751365Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2021-07-26T09:53:09.751373Z 0 [Note] Shutting down plugin 'InnoDB'
2021-07-26T09:53:09.801346Z 0 [Note] InnoDB: FTS optimize thread exiting.
2021-07-26T09:53:09.801956Z 0 [Note] InnoDB: Starting shutdown...
2021-07-26T09:53:09.940411Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2021-07-26T09:53:09.940930Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210726  9:53:09
2021-07-26T09:53:12.386470Z 0 [Note] InnoDB: Shutdown completed; log sequence number 45991631
2021-07-26T09:53:12.413889Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-07-26T09:53:12.413931Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2021-07-26T09:53:12.414124Z 0 [Note] Shutting down plugin 'MyISAM'
2021-07-26T09:53:12.414170Z 0 [Note] Shutting down plugin 'CSV'
2021-07-26T09:53:12.414186Z 0 [Note] Shutting down plugin 'MEMORY'
2021-07-26T09:53:12.414204Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2021-07-26T09:53:12.414264Z 0 [Note] Shutting down plugin 'sha256_password'
2021-07-26T09:53:12.414286Z 0 [Note] Shutting down plugin 'mysql_native_password'
2021-07-26T09:53:12.493151Z 0 [Note] Shutting down plugin 'binlog'
2021-07-26T09:53:12.548980Z 0 [Note] mysqld: Shutdown complete

2021-07-26T10:06:53.323652Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-07-26T10:06:53.326740Z 0 [Note] mysqld (mysqld 5.7.20) starting as process 1 ...
2021-07-26T10:06:53.335563Z 0 [Note] InnoDB: PUNCH HOLE support available
2021-07-26T10:06:53.335620Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-07-26T10:06:53.335635Z 0 [Note] InnoDB: Uses event mutexes
2021-07-26T10:06:53.335648Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-07-26T10:06:53.335662Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2021-07-26T10:06:53.335675Z 0 [Note] InnoDB: Using Linux native AIO
2021-07-26T10:06:53.336269Z 0 [Note] InnoDB: Number of pools: 1
2021-07-26T10:06:53.336465Z 0 [Note] InnoDB: Using CPU crc32 instructions
2021-07-26T10:06:53.339507Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-07-26T10:06:53.362806Z 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-26T10:06:53.366289Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-07-26T10:06:53.448846Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2021-07-26T10:06:54.008626Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-26T10:06:54.008764Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-26T10:06:54.449209Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-07-26T10:06:54.451226Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2021-07-26T10:06:54.451268Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2021-07-26T10:06:54.451934Z 0 [Note] InnoDB: Waiting for purge to start
2021-07-26T10:06:54.504370Z 0 [Note] InnoDB: 5.7.20 started; log sequence number 45991631
2021-07-26T10:06:54.504781Z 0 [Note] Plugin 'FEDERATED' is disabled.
2021-07-26T10:06:54.504830Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2021-07-26T10:06:54.660311Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2021-07-26T10:06:54.685977Z 0 [Warning] CA certificate ca.pem is self signed.
2021-07-26T10:06:54.689875Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2021-07-26T10:06:54.689936Z 0 [Note] IPv6 is available.
2021-07-26T10:06:54.689952Z 0 [Note]   - '::' resolves to '::';
2021-07-26T10:06:54.689989Z 0 [Note] Server socket created on IP: '::'.
2021-07-26T10:06:54.990390Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210726 10:06:54
2021-07-26T10:06:55.750875Z 0 [Note] Event Scheduler: Loaded 0 events
2021-07-26T10:06:55.751286Z 0 [Note] mysqld: ready for connections.
Version: '5.7.20'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)
2021-07-26T10:06:55.751312Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check.
2021-07-26T10:06:55.751322Z 0 [Note] Beginning of list of non-natively partitioned tables
2021-07-26T10:06:57.324284Z 0 [Note] End of list of non-natively partitioned tables
2021-08-26T11:57:22.438264Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6002ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
Czekam na kolejne Supla Offline Party 👍
Awatar użytkownika
pzygmunt
Posty: 18207
Rejestracja: wt sty 19, 2016 9:26 am
Lokalizacja: Paczków
Kontakt:

Chodziło o dane z tabeli supla_em_logs
Awatar użytkownika
lesny8
Posty: 2802
Rejestracja: pn gru 11, 2017 9:43 pm

pzygmunt pisze: czw wrz 09, 2021 10:44 am Chodziło o dane z tabeli supla_em_logs
Proszę bardzo, wpisy z tabeli z tego dnia ;)
supla_em_log.zip
(25.06 KiB) Pobrany 49 razy
Czekam na kolejne Supla Offline Party 👍
Awatar użytkownika
lesny8
Posty: 2802
Rejestracja: pn gru 11, 2017 9:43 pm

@pzygmunt, czy te logi Ci coś pomogły w namierzeniu robaszka :?: ;)

Chciałem zaktualizować instancję i soft na MEW-ach, ale nie wiem czy już mogę :roll:
Czekam na kolejne Supla Offline Party 👍
Awatar użytkownika
pzygmunt
Posty: 18207
Rejestracja: wt sty 19, 2016 9:26 am
Lokalizacja: Paczków
Kontakt:

Zadanie "zweryfikować logi" jeszcze czeka....
Awatar użytkownika
pzygmunt
Posty: 18207
Rejestracja: wt sty 19, 2016 9:26 am
Lokalizacja: Paczków
Kontakt:

Z logów wynika, że serwer przestaje dostawać powiadomienia o zmianie danych pomiarowych...
(SUPLA_DS_CALL_DEVICE_CHANNEL_EXTENDEDVALUE_CHANGED)

Albo dane lecą do serwera ale coś z nimi jest nie tak, albo jakimś cudem w ogóle nie wychodzą z MEW-a.
Mam na myśli dane pomiarowe bo coś musi lecieć, inaczej serwer zerwałby połączenie.

Aby dalej to debugować musiałbym przesłać Ci supla-server, który loguje wszystko co dostaje z socket-a.
Mając dotychczasowe log-i mogę zawęzić logowanie do kanału id 1 bo zakładam, że tam nadal jest MEW. Chyba, że masz więcej MEW-ów.

Przydałoby się przygotować też dedykowany FW dla MEW-a aby np. w channel state przesyłać informację czy wystąpiła dłuższa przerwa w
wysyłaniu danych pomiarowych. Problem tylko jest taki, że zapytanie o stan kanału "naprawia" komunikację i muszę to uwzględnić.

Aby przejść dalej musiałbyś zaktualizować swoja instancję do najnowszej wersji.
Awatar użytkownika
lesny8
Posty: 2802
Rejestracja: pn gru 11, 2017 9:43 pm

MEWek mam tam 9 i wszystkie mają co robić. Dwie są wyłączane razem z maszynami, a reszta cały czas pod prądem. Jutro sprawdzę, czy na pozostałych, od chwili zamontowania występowały jakieś 'szpilki'.

Nie ma sprawy, podsyłaj co trzeba, ja już się biorę za aktualizację instancji ;)
Czekam na kolejne Supla Offline Party 👍
Patryk
Posty: 2674
Rejestracja: pn sty 07, 2019 7:51 pm
Lokalizacja: Rybnik

Nie mam lokalnego serwera oraz od czasu aktualizacji do v2.8.1 problem ( u mnie ) zniknął, ale jak by co, to również mogę udostępnić swoją MEW-kę do testów.
ODPOWIEDZ

Wróć do „ZAMEL MEW-01”