Hauptmenü

DBlog Error

Begonnen von wuast94, 27 November 2017, 17:59:56

Vorheriges Thema - Nächstes Thema

DS_Starter

Ja wenn dein autocommit ohnehin auf ON steht war die Version nicht hilfreich. Na gut, eine Versuch war es wert.
Hmm, da fällt mir nicht mehr viel ein. Was mich stört ist dass die DB/Tabelle gelockt wird -> Commit already running - resync at NextSync.
Das kann nicht sein und ist bei mir auch nicht der Fall.

Mach mal noch einen Verscuch mit serverSide Dump.
ESXi@NUC+Debian+MariaDB, PV: SMA, Victron MPII+Pylontech+CerboGX
Maintainer: SSCam, SSChatBot, SSCal, SSFile, DbLog/DbRep, Log2Syslog, SolarForecast,Watches, Dashboard, PylonLowVoltage
Kaffeekasse: https://www.paypal.me/HMaaz
Contrib: https://svn.fhem.de/trac/browser/trunk/fhem/contrib/DS_Starter

wuast94

beim server side dumb kommt in dbrep folgender error:
DBD::mysql::st execute failed: Access denied for user 'fhemuser'@'%' (using password: YES) at ./FHEM/93_DbRep.pm line 5469.

DbLog blockt aber genau so wie bei clients side danach
Zigbee  Temp+Luftdruck+Humi Bewegungsmeldern Tür Kontakte, Klingel, TV, Denon, Schaltbare Steckdosen mit leistungsmessung, und weiteres

Homeassistant mit Nodered

DS_Starter

Das kommt mir jetzt aber arg spanisch vor.

1. die Zeile 5469 gehört zur Routine clientSide !
2. der Session-Aufbau ist immer gleich. Wenn keine Rechte dann immer.

Ich würde zunächst einmal für den User fhemuser in MySQL den Zugriff von allen Hosts erlauben -> "%" im Userstammsatz setzen.

Gib mal bitte noch ein paar Angaben zu deiner Infrastruktur, was läuft worauf mit welcher Version, wie groß ist DB, wie lange läuft der Dump usw.

Die Version der installierten Perl DB-Interfacemodule kannst du dir z.B. so anzeigen lassen:

dpkg -l |grep -i 'libdb.*-perl'

Vielleicht fällt mir dann noch etwas ein.

ZitatDbLog blockt aber genau so wie bei clients side danach
Ganz wichtig für die Formulierung .... DbLog blockt NICHT, sondern deine DB/Tabelle wird gelockt bzw. gestattet keinen schreibenden Zugriff solange der Dump läuft (was nur einen lesenden Select-Zugriff beinhaltet). DbLog reagiert dann darauf mit entsprechenden Meldungen.
Würde DbLog blockieren, würde dein FHEM stehen.

Die Meldung

DBD::mysql::st execute_array failed: executing 4414 generated 2 errors at ./FHEM/93_DbLog.pm line 1859

kommt von dem Perl Datenbankinterface. Deswegen will ich mal deine Modulversionen mit meinen vergleichen.

Wenn dein fhem-Rechner genügend Ressourcen hat kannst du im DbRep für den clientSide Dump die Attribute setzen:


dumpMemlimit   1000000
dumpSpeed       100000


Mach nochmal einen Dump und setze vorher in DbLog die Attribute:


cacheLimit      auf einen sehr hohen Wert der während des dumps mit Sicherheit nicht erreicht wird.
syncInterval   auf eine lange Periode die länger ist als die Dauer des Dumps


Nachdem die Attribute gesetzt sind führe "set <dblog> commitCache" aus und starte dann den DUmp im DbRep.

Ich erstelle derweil eine weitere DbLog-Version mit der man explizit den Autocommit ausschalten kann damit wir das auch noch testen können.

ESXi@NUC+Debian+MariaDB, PV: SMA, Victron MPII+Pylontech+CerboGX
Maintainer: SSCam, SSChatBot, SSCal, SSFile, DbLog/DbRep, Log2Syslog, SolarForecast,Watches, Dashboard, PylonLowVoltage
Kaffeekasse: https://www.paypal.me/HMaaz
Contrib: https://svn.fhem.de/trac/browser/trunk/fhem/contrib/DS_Starter

wuast94

ich versuche dir mal alles zusammen zu stellen :) würde aber glaube so langsam sagen das es vlt sinnvoller wäre wenn du mal direkt auf meinem system guckst :)
Zigbee  Temp+Luftdruck+Humi Bewegungsmeldern Tür Kontakte, Klingel, TV, Denon, Schaltbare Steckdosen mit leistungsmessung, und weiteres

Homeassistant mit Nodered

wuast94

#19
zum system:
Auf nem laptop läuft n debian und darauf eine docker umgebung worüber auch fhem und mysql laufen. x64 system falls das relevant ist

im fhem container folgende ausgabe:
ii  libdbd-mysql-perl                 4.028-2+deb8u2           amd64        Perl5 database interface to the MySQL database
ii  libdbd-sqlite3-perl                1.44-1                          amd64        Perl DBI driver with a self-contained RDBMS
ii  libdbi-perl                           1.631-3+b1                   amd64        Perl Database Interface (DBI)
ii  libdbix-contextualfetch-perl  1.03-3                           all              module to add context aware fetches to DBI


Fhem auf aktuellen stand.
mysql v5.7.20

Mysql Variablen:
VAR_auto_generate_certs
ON

VAR_auto_increment_increment
1

VAR_auto_increment_offset
1

VAR_autocommit
ON

VAR_automatic_sp_privileges
ON

VAR_avoid_temporal_upgrade
OFF

VAR_back_log
80

VAR_basedir
/usr/

VAR_big_tables
OFF

VAR_bind_address
*

VAR_binlog_cache_size
32768

VAR_binlog_checksum
CRC32

VAR_binlog_direct_non_transactional_updates
OFF

VAR_binlog_error_action
ABORT_SERVER

VAR_binlog_format
ROW

VAR_binlog_group_commit_sync_delay
0

VAR_binlog_group_commit_sync_no_delay_count
0

VAR_binlog_gtid_simple_recovery
ON

VAR_binlog_max_flush_queue_time
0

VAR_binlog_order_commits
ON

VAR_binlog_row_image
FULL

VAR_binlog_rows_query_log_events
OFF

VAR_binlog_stmt_cache_size
32768

VAR_block_encryption_mode
aes-128-ecb

VAR_bulk_insert_buffer_size
8388608

VAR_character_set_client
latin1

VAR_character_set_connection
latin1

VAR_character_set_database
utf8

VAR_character_set_filesystem
binary

VAR_character_set_results
latin1

VAR_character_set_server
latin1

VAR_character_set_system
utf8

VAR_character_sets_dir
/usr/share/mysql/charsets/

VAR_check_proxy_users
OFF

VAR_collation_connection
latin1_swedish_ci

VAR_collation_database
utf8_general_ci

VAR_collation_server
latin1_swedish_ci

VAR_completion_type
NO_CHAIN

VAR_concurrent_insert
AUTO

VAR_connect_timeout
10

VAR_core_file
OFF

VAR_datadir
/var/lib/mysql/

VAR_date_format
%Y-%m-%d

VAR_datetime_format
%Y-%m-%d_%H:%i:%s

VAR_default_authentication_plugin
mysql_native_password

VAR_default_password_lifetime
0

VAR_default_storage_engine
InnoDB

VAR_default_tmp_storage_engine
InnoDB

VAR_default_week_format
0

VAR_delay_key_write
ON

VAR_delayed_insert_limit
100

VAR_delayed_insert_timeout
300

VAR_delayed_queue_size
1000

VAR_disabled_storage_engines

VAR_disconnect_on_expired_password
ON

VAR_div_precision_increment
4

VAR_end_markers_in_json
OFF

VAR_enforce_gtid_consistency
OFF

VAR_eq_range_index_dive_limit
200

VAR_error_count
0

VAR_event_scheduler
OFF

VAR_expire_logs_days
0

VAR_explicit_defaults_for_timestamp
OFF

VAR_external_user

VAR_flush
OFF

VAR_flush_time
0

VAR_foreign_key_checks
ON

VAR_ft_boolean_syntax
+_-><()~*:""&|

VAR_ft_max_word_len
84

VAR_ft_min_word_len
4

VAR_ft_query_expansion_limit
20

VAR_ft_stopword_file
(built-in)

VAR_general_log
OFF

VAR_general_log_file
/var/lib/mysql/91f0c6f9bc52.log

VAR_group_concat_max_len
1024

VAR_gtid_executed_compression_period
1000

VAR_gtid_mode
OFF

VAR_gtid_next
AUTOMATIC

VAR_gtid_owned

VAR_gtid_purged

VAR_have_compress
YES

VAR_have_crypt
YES

VAR_have_dynamic_loading
YES

VAR_have_geometry
YES

VAR_have_openssl
YES

VAR_have_profiling
YES

VAR_have_query_cache
YES

VAR_have_rtree_keys
YES

VAR_have_ssl
YES

VAR_have_statement_timeout
YES

VAR_have_symlink
DISABLED

VAR_host_cache_size
279

VAR_hostname
91f0c6f9bc52

VAR_identity
0

VAR_ignore_builtin_innodb
OFF

VAR_ignore_db_dirs

VAR_init_connect

VAR_init_file

VAR_init_slave

VAR_innodb_adaptive_flushing
ON

VAR_innodb_adaptive_flushing_lwm
10

VAR_innodb_adaptive_hash_index
ON

VAR_innodb_adaptive_hash_index_parts
8

VAR_innodb_adaptive_max_sleep_delay
150000

VAR_innodb_api_bk_commit_interval
5

VAR_innodb_api_disable_rowlock
OFF

VAR_innodb_api_enable_binlog
OFF

VAR_innodb_api_enable_mdl
OFF

VAR_innodb_api_trx_level
0

VAR_innodb_autoextend_increment
64

VAR_innodb_autoinc_lock_mode
1

VAR_innodb_buffer_pool_chunk_size
134217728

VAR_innodb_buffer_pool_dump_at_shutdown
ON

VAR_innodb_buffer_pool_dump_now
OFF

VAR_innodb_buffer_pool_dump_pct
25

VAR_innodb_buffer_pool_filename
ib_buffer_pool

VAR_innodb_buffer_pool_instances
1

VAR_innodb_buffer_pool_load_abort
OFF

VAR_innodb_buffer_pool_load_at_startup
ON

VAR_innodb_buffer_pool_load_now
OFF

VAR_innodb_buffer_pool_size
134217728

VAR_innodb_change_buffer_max_size
25

VAR_innodb_change_buffering
all

VAR_innodb_checksum_algorithm
crc32

VAR_innodb_checksums
ON

VAR_innodb_cmp_per_index_enabled
OFF

VAR_innodb_commit_concurrency
0

VAR_innodb_compression_failure_threshold_pct
5

VAR_innodb_compression_level
6

VAR_innodb_compression_pad_pct_max
50

VAR_innodb_concurrency_tickets
5000

VAR_innodb_data_file_path
ibdata1:12M:autoextend

VAR_innodb_data_home_dir

VAR_innodb_deadlock_detect
ON

VAR_innodb_default_row_format
dynamic

VAR_innodb_disable_sort_file_cache
OFF

VAR_innodb_doublewrite
ON

VAR_innodb_fast_shutdown
1

VAR_innodb_file_format
Barracuda

VAR_innodb_file_format_check
ON

VAR_innodb_file_format_max
Barracuda

VAR_innodb_file_per_table
ON

VAR_innodb_fill_factor
100

VAR_innodb_flush_log_at_timeout
1

VAR_innodb_flush_log_at_trx_commit
1

VAR_innodb_flush_method

VAR_innodb_flush_neighbors
1

VAR_innodb_flush_sync
ON

VAR_innodb_flushing_avg_loops
30

VAR_innodb_force_load_corrupted
OFF

VAR_innodb_force_recovery
0

VAR_innodb_ft_aux_table

VAR_innodb_ft_cache_size
8000000

VAR_innodb_ft_enable_diag_print
OFF

VAR_innodb_ft_enable_stopword
ON

VAR_innodb_ft_max_token_size
84

VAR_innodb_ft_min_token_size
3

VAR_innodb_ft_num_word_optimize
2000

VAR_innodb_ft_result_cache_limit
2000000000

VAR_innodb_ft_server_stopword_table

VAR_innodb_ft_sort_pll_degree
2

VAR_innodb_ft_total_cache_size
640000000

VAR_innodb_ft_user_stopword_table

VAR_innodb_io_capacity
200

VAR_innodb_io_capacity_max
2000

VAR_innodb_large_prefix
ON

VAR_innodb_lock_wait_timeout
50

VAR_innodb_locks_unsafe_for_binlog
OFF

VAR_innodb_log_buffer_size
16777216

VAR_innodb_log_checksums
ON

VAR_innodb_log_compressed_pages
ON

VAR_innodb_log_file_size
50331648

VAR_innodb_log_files_in_group
2

VAR_innodb_log_group_home_dir
./

VAR_innodb_log_write_ahead_size
8192

VAR_innodb_lru_scan_depth
1024

VAR_innodb_max_dirty_pages_pct
75.000000

VAR_innodb_max_dirty_pages_pct_lwm
0.000000

VAR_innodb_max_purge_lag
0

VAR_innodb_max_purge_lag_delay
0

VAR_innodb_max_undo_log_size
1073741824

VAR_innodb_monitor_disable

VAR_innodb_monitor_enable

VAR_innodb_monitor_reset

VAR_innodb_monitor_reset_all

VAR_innodb_numa_interleave
OFF

VAR_innodb_old_blocks_pct
37

VAR_innodb_old_blocks_time
1000

VAR_innodb_online_alter_log_max_size
134217728

VAR_innodb_open_files
2000

VAR_innodb_optimize_fulltext_only
OFF

VAR_innodb_page_cleaners
1

VAR_innodb_page_size
16384

VAR_innodb_print_all_deadlocks
OFF

VAR_innodb_purge_batch_size
300

VAR_innodb_purge_rseg_truncate_frequency
128

VAR_innodb_purge_threads
4

VAR_innodb_random_read_ahead
OFF

VAR_innodb_read_ahead_threshold
56

VAR_innodb_read_io_threads
4

VAR_innodb_read_only
OFF

VAR_innodb_replication_delay
0

VAR_innodb_rollback_on_timeout
OFF

VAR_innodb_rollback_segments
128

VAR_innodb_sort_buffer_size
1048576

VAR_innodb_spin_wait_delay
6

VAR_innodb_stats_auto_recalc
ON

VAR_innodb_stats_include_delete_marked
OFF

VAR_innodb_stats_method
nulls_equal

VAR_innodb_stats_on_metadata
OFF

VAR_innodb_stats_persistent
ON

VAR_innodb_stats_persistent_sample_pages
20

VAR_innodb_stats_sample_pages
8

VAR_innodb_stats_transient_sample_pages
8

VAR_innodb_status_output
OFF

VAR_innodb_status_output_locks
OFF

VAR_innodb_strict_mode
ON

VAR_innodb_support_xa
ON

VAR_innodb_sync_array_size
1

VAR_innodb_sync_spin_loops
30

VAR_innodb_table_locks
ON

VAR_innodb_temp_data_file_path
ibtmp1:12M:autoextend

VAR_innodb_thread_concurrency
0

VAR_innodb_thread_sleep_delay
10000

VAR_innodb_tmpdir

VAR_innodb_undo_directory
./

VAR_innodb_undo_log_truncate
OFF

VAR_innodb_undo_logs
128

VAR_innodb_undo_tablespaces
0

VAR_innodb_use_native_aio
ON

VAR_innodb_version
5.7.20

VAR_innodb_write_io_threads
4

VAR_insert_id
0

VAR_interactive_timeout
28800

VAR_internal_tmp_disk_storage_engine
InnoDB

VAR_join_buffer_size
262144

VAR_keep_files_on_create
OFF

VAR_key_buffer_size
8388608

VAR_key_cache_age_threshold
300

VAR_key_cache_block_size
1024

VAR_key_cache_division_limit
100

VAR_large_files_support
ON

VAR_large_page_size
0

VAR_large_pages
OFF

VAR_last_insert_id
0

VAR_lc_messages
en_US

VAR_lc_messages_dir
/usr/share/mysql/

VAR_lc_time_names
en_US

VAR_license
GPL

VAR_local_infile
ON

VAR_lock_wait_timeout
31536000

VAR_locked_in_memory
OFF

VAR_log_bin
OFF

VAR_log_bin_basename

VAR_log_bin_index

VAR_log_bin_trust_function_creators
OFF

VAR_log_bin_use_v1_row_events
OFF

VAR_log_builtin_as_identified_by_password
OFF

VAR_log_error
/var/log/mysqld.log

VAR_log_error_verbosity
3

VAR_log_output
FILE

VAR_log_queries_not_using_indexes
OFF

VAR_log_slave_updates
OFF

VAR_log_slow_admin_statements
OFF

VAR_log_slow_slave_statements
OFF

VAR_log_statements_unsafe_for_binlog
ON

VAR_log_syslog
OFF

VAR_log_syslog_facility
daemon

VAR_log_syslog_include_pid
ON

VAR_log_syslog_tag

VAR_log_throttle_queries_not_using_indexes
0

VAR_log_timestamps
UTC

VAR_log_warnings
2

VAR_long_query_time
10.000000

VAR_low_priority_updates
OFF

VAR_lower_case_file_system
OFF

VAR_lower_case_table_names
0

VAR_master_info_repository
FILE

VAR_master_verify_checksum
OFF

VAR_max_allowed_packet
4194304

VAR_max_binlog_cache_size
18446744073709547520

VAR_max_binlog_size
1073741824

VAR_max_binlog_stmt_cache_size
18446744073709547520

VAR_max_connect_errors
100

VAR_max_connections
151

VAR_max_delayed_threads
20

VAR_max_digest_length
1024

VAR_max_error_count
64

VAR_max_execution_time
0

VAR_max_heap_table_size
16777216

VAR_max_insert_delayed_threads
20

VAR_max_join_size
18446744073709551615

VAR_max_length_for_sort_data
1024

VAR_max_points_in_geometry
65536

VAR_max_prepared_stmt_count
16382

VAR_max_relay_log_size
0

VAR_max_seeks_for_key
18446744073709551615

VAR_max_sort_length
1024

VAR_max_sp_recursion_depth
0

VAR_max_tmp_tables
32

VAR_max_user_connections
0

VAR_max_write_lock_count
18446744073709551615

VAR_metadata_locks_cache_size
1024

VAR_metadata_locks_hash_instances
8

VAR_min_examined_row_limit
0

VAR_multi_range_count
256

VAR_myisam_data_pointer_size
6

VAR_myisam_max_sort_file_size
9223372036853727232

VAR_myisam_mmap_size
18446744073709551615

VAR_myisam_recover_options
OFF

VAR_myisam_repair_threads
1

VAR_myisam_sort_buffer_size
8388608

VAR_myisam_stats_method
nulls_unequal

VAR_myisam_use_mmap
OFF

VAR_mysql_native_password_proxy_users
OFF

VAR_net_buffer_length
16384

VAR_net_read_timeout
30

VAR_net_retry_count
10

VAR_net_write_timeout
60

VAR_new
OFF

VAR_ngram_token_size
2

VAR_offline_mode
OFF

VAR_old
OFF

VAR_old_alter_table
OFF

VAR_old_passwords
0

VAR_open_files_limit
1048576

VAR_optimizer_prune_level
1

VAR_optimizer_search_depth
62

VAR_optimizer_switch
index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=on

VAR_optimizer_trace
enabled=off,one_line=off

VAR_optimizer_trace_features
greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on

VAR_optimizer_trace_limit
1

VAR_optimizer_trace_max_mem_size
16384

VAR_optimizer_trace_offset
-1

VAR_parser_max_mem_size
18446744073709551615

VAR_performance_schema
ON

VAR_performance_schema_accounts_size
-1

VAR_performance_schema_digests_size
10000

VAR_performance_schema_events_stages_history_long_size
10000

VAR_performance_schema_events_stages_history_size
10

VAR_performance_schema_events_statements_history_long_size
10000

VAR_performance_schema_events_statements_history_size
10

VAR_performance_schema_events_transactions_history_long_size
10000

VAR_performance_schema_events_transactions_history_size
10

VAR_performance_schema_events_waits_history_long_size
10000

VAR_performance_schema_events_waits_history_size
10

VAR_performance_schema_hosts_size
-1

VAR_performance_schema_max_cond_classes
80

VAR_performance_schema_max_cond_instances
-1

VAR_performance_schema_max_digest_length
1024

VAR_performance_schema_max_file_classes
80

VAR_performance_schema_max_file_handles
32768

VAR_performance_schema_max_file_instances
-1

VAR_performance_schema_max_index_stat
-1

VAR_performance_schema_max_memory_classes
320

VAR_performance_schema_max_metadata_locks
-1

VAR_performance_schema_max_mutex_classes
210

VAR_performance_schema_max_mutex_instances
-1

VAR_performance_schema_max_prepared_statements_instances
-1

VAR_performance_schema_max_program_instances
-1

VAR_performance_schema_max_rwlock_classes
40

VAR_performance_schema_max_rwlock_instances
-1

VAR_performance_schema_max_socket_classes
10

VAR_performance_schema_max_socket_instances
-1

VAR_performance_schema_max_sql_text_length
1024

VAR_performance_schema_max_stage_classes
150

VAR_performance_schema_max_statement_classes
193

VAR_performance_schema_max_statement_stack
10

VAR_performance_schema_max_table_handles
-1

VAR_performance_schema_max_table_instances
-1

VAR_performance_schema_max_table_lock_stat
-1

VAR_performance_schema_max_thread_classes
50

VAR_performance_schema_max_thread_instances
-1

VAR_performance_schema_session_connect_attrs_size
512

VAR_performance_schema_setup_actors_size
-1

VAR_performance_schema_setup_objects_size
-1

VAR_performance_schema_users_size
-1

VAR_pid_file
/var/run/mysqld/mysqld.pid

VAR_plugin_dir
/usr/lib64/mysql/plugin/

VAR_port
3306

VAR_preload_buffer_size
32768

VAR_profiling
OFF

VAR_profiling_history_size
15

VAR_protocol_version
10

VAR_proxy_user

VAR_pseudo_slave_mode
OFF

VAR_pseudo_thread_id
32

VAR_query_alloc_block_size
8192

VAR_query_cache_limit
1048576

VAR_query_cache_min_res_unit
4096

VAR_query_cache_size
1048576

VAR_query_cache_type
OFF

VAR_query_cache_wlock_invalidate
OFF

VAR_query_prealloc_size
8192

VAR_rand_seed1
0

VAR_rand_seed2
0

VAR_range_alloc_block_size
4096

VAR_range_optimizer_max_mem_size
8388608

VAR_rbr_exec_mode
STRICT

VAR_read_buffer_size
131072

VAR_read_only
OFF

VAR_read_rnd_buffer_size
262144

VAR_relay_log

VAR_relay_log_basename
/var/lib/mysql/91f0c6f9bc52-relay-bin

VAR_relay_log_index
/var/lib/mysql/91f0c6f9bc52-relay-bin.index

VAR_relay_log_info_file
relay-log.info

VAR_relay_log_info_repository
FILE

VAR_relay_log_purge
ON

VAR_relay_log_recovery
OFF

VAR_relay_log_space_limit
0

VAR_report_host

VAR_report_password

VAR_report_port
3306

VAR_report_user

VAR_require_secure_transport
OFF

VAR_rpl_stop_slave_timeout
31536000

VAR_secure_auth
ON

VAR_secure_file_priv
/var/lib/mysql-files/

VAR_server_id
0

VAR_server_id_bits
32

VAR_server_uuid
7f257ca0-cae5-11e7-bf6a-0242ac130002

VAR_session_track_gtids
OFF

VAR_session_track_schema
ON

VAR_session_track_state_change
OFF

VAR_session_track_system_variables
time_zone,autocommit,character_set_client,character_set_results,character_set_connection

VAR_session_track_transaction_info
OFF

VAR_sha256_password_auto_generate_rsa_keys
ON

VAR_sha256_password_private_key_path
private_key.pem

VAR_sha256_password_proxy_users
OFF

VAR_sha256_password_public_key_path
public_key.pem

VAR_show_compatibility_56
OFF

VAR_show_old_temporals
OFF

VAR_skip_external_locking
ON

VAR_skip_name_resolve
ON

VAR_skip_networking
OFF

VAR_skip_show_database
OFF

VAR_slave_allow_batching
OFF

VAR_slave_checkpoint_group
512

VAR_slave_checkpoint_period
300

VAR_slave_compressed_protocol
OFF

VAR_slave_exec_mode
STRICT

VAR_slave_load_tmpdir
/tmp

VAR_slave_max_allowed_packet
1073741824

VAR_slave_net_timeout
60

VAR_slave_parallel_type
DATABASE

VAR_slave_parallel_workers
0

VAR_slave_pending_jobs_size_max
16777216

VAR_slave_preserve_commit_order
OFF

VAR_slave_rows_search_algorithms
TABLE_SCAN,INDEX_SCAN

VAR_slave_skip_errors
OFF

VAR_slave_sql_verify_checksum
ON

VAR_slave_transaction_retries
10

VAR_slave_type_conversions

VAR_slow_launch_time
2

VAR_slow_query_log
OFF

VAR_slow_query_log_file
/var/lib/mysql/91f0c6f9bc52-slow.log

VAR_socket
/var/lib/mysql/mysql.sock

VAR_sort_buffer_size
262144

VAR_sql_auto_is_null
OFF

VAR_sql_big_selects
ON

VAR_sql_buffer_result
OFF

VAR_sql_log_bin
ON

VAR_sql_log_off
OFF

VAR_sql_mode
STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

VAR_sql_notes
ON

VAR_sql_quote_show_create
ON

VAR_sql_safe_updates
OFF

VAR_sql_select_limit
18446744073709551615

VAR_sql_slave_skip_counter
0

VAR_sql_warnings
OFF

VAR_ssl_ca
ca.pem

VAR_ssl_capath

VAR_ssl_cert
server-cert.pem

VAR_ssl_cipher

VAR_ssl_crl

VAR_ssl_crlpath

VAR_ssl_key
server-key.pem

VAR_stored_program_cache
256

VAR_super_read_only
OFF

VAR_sync_binlog
1

VAR_sync_frm
ON

VAR_sync_master_info
10000

VAR_sync_relay_log
10000

VAR_sync_relay_log_info
10000

VAR_system_time_zone
UTC

VAR_table_definition_cache
1400

VAR_table_open_cache
2000

VAR_table_open_cache_instances
16

VAR_thread_cache_size
9

VAR_thread_handling
one-thread-per-connection

VAR_thread_stack
262144

VAR_time_format
%H:%i:%s

VAR_time_zone
SYSTEM

VAR_timestamp
1512122535.454752

VAR_tls_version
TLSv1,TLSv1.1,TLSv1.2

VAR_tmp_table_size
16777216

VAR_tmpdir
/tmp

VAR_transaction_alloc_block_size
8192

VAR_transaction_allow_batching
OFF

VAR_transaction_isolation
REPEATABLE-READ

VAR_transaction_prealloc_size
4096

VAR_transaction_read_only
OFF

VAR_transaction_write_set_extraction
OFF

VAR_tx_isolation
REPEATABLE-READ

VAR_tx_read_only
OFF

VAR_unique_checks
ON

VAR_updatable_views_with_limit
YES

VAR_version
5.7.20

VAR_version_comment
MySQL_Community_Server_(GPL)

VAR_version_compile_machine
x86_64

VAR_version_compile_os
Linux

VAR_wait_timeout
28800

VAR_warning_count
0

state
done

der dump ist ca39 sekunden am laufen was denke ich ok sein sollte :)
habe die cache werte erhöt was aber auch keinen erfolg gebracht hat (hab nach dem dump ein commitCache gemacht .. wollte jetzt nicht ne stunde warten :D)

habe zusätzlich mir mit HeidiSQL mal n bisschen was angeguckt und unteranderem kann man sich dort die laufenden prozesse ansehen. dort läuft unter id 21 der prozess vom programm selber und unter id 3 ein prozess von fehm mit dem kommando "Sleep" und dauer "485" was natürlich immer mehr wird mit der zeit. und mehr prozesse gibt es dort auch nicht.

EDIT: Im anhang noch meine modul versionen auf dem FHEM verzeichnis falls es dir was hilft .. aber sind ja eigendlich die standard module :D
Zigbee  Temp+Luftdruck+Humi Bewegungsmeldern Tür Kontakte, Klingel, TV, Denon, Schaltbare Steckdosen mit leistungsmessung, und weiteres

Homeassistant mit Nodered

DS_Starter

#20
Jetzt wirds wirklich langsam interessant. Ich verwende ebenfalls debian 8, allerdings auf VM's, und die lib-perl Module sind haargenau identisch.
Ich verwende allerdings MariaDB (auf Synology), das wäre ein Unterschied. Docker verwende ich nicht. Das hat auf Synology nicht gut funktioniert und ich habe statt dessen ESX6.5 mit den VM's separat aufgebaut.
Aber ich _vermute_  das ist für unseren Fall nebensächlich .

Die ganzen MySQL-Variablen habe ich mir jetzt nicht durchgelesen. Da hast du ja die ganz große Infokeule rausgeholt. :)

Habe dir die neue DbLog-Version angehängt.
Setze dir das Attribut autocommit auf "off". Und das Ganze nochmal.

Wenn das auch nicht klappt könnten wir nach dem Mittag irgendwann eine Session machen.

EDIT: und schau mal bitte in die MySQL-Logdatei  "  /var/log/mysqld.log" rein ob die DB zu der relevanten Zeit des Dumps irgendwelche Fehler aufgeschrieben hat.
ESXi@NUC+Debian+MariaDB, PV: SMA, Victron MPII+Pylontech+CerboGX
Maintainer: SSCam, SSChatBot, SSCal, SSFile, DbLog/DbRep, Log2Syslog, SolarForecast,Watches, Dashboard, PylonLowVoltage
Kaffeekasse: https://www.paypal.me/HMaaz
Contrib: https://svn.fhem.de/trac/browser/trunk/fhem/contrib/DS_Starter

wuast94

ich gehe auch mal davon aus das das nebensächlich ist. habe aber mal den mysqld.log nach außen gemapped und da steht nur der start drin und dann wird erst wieder geschrieben wenn man den server wieder runter fährt. aber hier tzd mal der log:

2017-12-01T17:33:55.303137Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-12-01T17:33:55.304002Z 0 [Note] mysqld (mysqld 5.7.20) starting as process 1 ...
2017-12-01T17:33:55.306720Z 0 [Note] InnoDB: PUNCH HOLE support available
2017-12-01T17:33:55.306744Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-12-01T17:33:55.306750Z 0 [Note] InnoDB: Uses event mutexes
2017-12-01T17:33:55.306755Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-12-01T17:33:55.306760Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-12-01T17:33:55.306764Z 0 [Note] InnoDB: Using Linux native AIO
2017-12-01T17:33:55.306938Z 0 [Note] InnoDB: Number of pools: 1
2017-12-01T17:33:55.307001Z 0 [Note] InnoDB: Using CPU crc32 instructions
2017-12-01T17:33:55.307973Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2017-12-01T17:33:55.313426Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-12-01T17:33:55.314633Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-12-01T17:33:55.326082Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2017-12-01T17:33:55.334835Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-12-01T17:33:55.334924Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-12-01T17:33:55.378834Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2017-12-01T17:33:55.380661Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2017-12-01T17:33:55.380706Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2017-12-01T17:33:55.381402Z 0 [Note] InnoDB: 5.7.20 started; log sequence number 137796435274
2017-12-01T17:33:55.381585Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2017-12-01T17:33:55.381750Z 0 [Note] Plugin 'FEDERATED' is disabled.
2017-12-01T17:33:55.387239Z 0 [Note] InnoDB: Buffer pool(s) load completed at 171201 17:33:55
2017-12-01T17:33:55.389877Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2017-12-01T17:33:55.389901Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2017-12-01T17:33:55.390657Z 0 [Warning] CA certificate ca.pem is self signed.
2017-12-01T17:33:55.390703Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2017-12-01T17:33:55.391057Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2017-12-01T17:33:55.391095Z 0 [Note] IPv6 is available.
2017-12-01T17:33:55.391112Z 0 [Note]   - '::' resolves to '::';
2017-12-01T17:33:55.391135Z 0 [Note] Server socket created on IP: '::'.
2017-12-01T17:33:55.394109Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
2017-12-01T17:33:55.394146Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
2017-12-01T17:33:55.394175Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2017-12-01T17:33:55.394189Z 0 [Warning] 'user' entry 'healthchecker@localhost' ignored in --skip-name-resolve mode.
2017-12-01T17:33:55.394221Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
2017-12-01T17:33:55.394230Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2017-12-01T17:33:55.394246Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2017-12-01T17:33:55.400897Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
2017-12-01T17:33:55.400929Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
2017-12-01T17:33:55.407859Z 0 [Note] Event Scheduler: Loaded 0 events
2017-12-01T17:33:55.408102Z 0 [Note] mysqld: ready for connections.
Version: '5.7.20'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
2017-12-01T17:33:55.408122Z 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.
2017-12-01T17:33:55.408133Z 0 [Note] Beginning of list of non-natively partitioned tables
2017-12-01T17:33:55.420522Z 0 [Note] End of list of non-natively partitioned tables
2017-12-01T17:39:07.008883Z 3 [Note] Aborted connection 3 to db: 'fhem' user: 'fhemuser' host: '172.18.0.3' (Got an error reading communication packets)
2017-12-01T17:39:07.386362Z 0 [Note] Giving 0 client threads a chance to die gracefully
2017-12-01T17:39:07.386400Z 0 [Note] Shutting down slave threads
2017-12-01T17:39:07.386409Z 0 [Note] Forcefully disconnecting 0 remaining clients
2017-12-01T17:39:07.386419Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2017-12-01T17:39:07.386465Z 0 [Note] Binlog end
2017-12-01T17:39:07.387407Z 0 [Note] Shutting down plugin 'ngram'
2017-12-01T17:39:07.387426Z 0 [Note] Shutting down plugin 'partition'
2017-12-01T17:39:07.387434Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2017-12-01T17:39:07.387442Z 0 [Note] Shutting down plugin 'ARCHIVE'
2017-12-01T17:39:07.387448Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2017-12-01T17:39:07.387481Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2017-12-01T17:39:07.387490Z 0 [Note] Shutting down plugin 'MyISAM'
2017-12-01T17:39:07.387503Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2017-12-01T17:39:07.387510Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2017-12-01T17:39:07.387517Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2017-12-01T17:39:07.387523Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2017-12-01T17:39:07.387530Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2017-12-01T17:39:07.387536Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2017-12-01T17:39:07.387542Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2017-12-01T17:39:07.387548Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2017-12-01T17:39:07.387555Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2017-12-01T17:39:07.387561Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2017-12-01T17:39:07.387567Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2017-12-01T17:39:07.387574Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2017-12-01T17:39:07.387580Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2017-12-01T17:39:07.387586Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2017-12-01T17:39:07.387593Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2017-12-01T17:39:07.387599Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2017-12-01T17:39:07.387605Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2017-12-01T17:39:07.387612Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2017-12-01T17:39:07.387618Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2017-12-01T17:39:07.387624Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2017-12-01T17:39:07.387639Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2017-12-01T17:39:07.387645Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2017-12-01T17:39:07.387651Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2017-12-01T17:39:07.387657Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2017-12-01T17:39:07.387663Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2017-12-01T17:39:07.387669Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2017-12-01T17:39:07.387675Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2017-12-01T17:39:07.387681Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2017-12-01T17:39:07.387686Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2017-12-01T17:39:07.387692Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2017-12-01T17:39:07.387698Z 0 [Note] Shutting down plugin 'InnoDB'
2017-12-01T17:39:07.387750Z 0 [Note] InnoDB: FTS optimize thread exiting.
2017-12-01T17:39:07.387862Z 0 [Note] InnoDB: Starting shutdown...
2017-12-01T17:39:07.488092Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2017-12-01T17:39:07.489358Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 171201 17:39:07
2017-12-01T17:39:08.611695Z 0 [Note] InnoDB: Shutdown completed; log sequence number 137801700909
2017-12-01T17:39:08.614901Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2017-12-01T17:39:08.614928Z 0 [Note] Shutting down plugin 'MEMORY'
2017-12-01T17:39:08.614940Z 0 [Note] Shutting down plugin 'CSV'
2017-12-01T17:39:08.614949Z 0 [Note] Shutting down plugin 'sha256_password'
2017-12-01T17:39:08.614957Z 0 [Note] Shutting down plugin 'mysql_native_password'
2017-12-01T17:39:08.615181Z 0 [Note] Shutting down plugin 'binlog'
2017-12-01T17:39:08.617522Z 0 [Note] mysqld: Shutdown complete


habe dann auch das bearbeitete modul geladen .. das attribut gesetzt .. dumb .. ergebnis leider unverändert. ich schreibe dir privat mal kontakt daten und dann sehen wir weiter :) war heute mittag mit arbeitskollegen beim lasertag von daher leider nicht da gewesen :/
Zigbee  Temp+Luftdruck+Humi Bewegungsmeldern Tür Kontakte, Klingel, TV, Denon, Schaltbare Steckdosen mit leistungsmessung, und weiteres

Homeassistant mit Nodered

DS_Starter

#22
Jetzt habe ich das Wichtigste auf die Schnelle vergessen zu machen. Es gibt doch so ein schönes Tool im DbLog.
Führe mal bitte aus:

set <name> configCheck

und poste mal was da kommt. Das ich das vergessen konnte ...  ;)

EDIT: habe mich nochmal versichert, die Feldlängen werden definitiv gekürzt und ich ahne bereits was der configCheck ausspucken wird ....

Grüße
Heiko
ESXi@NUC+Debian+MariaDB, PV: SMA, Victron MPII+Pylontech+CerboGX
Maintainer: SSCam, SSChatBot, SSCal, SSFile, DbLog/DbRep, Log2Syslog, SolarForecast,Watches, Dashboard, PylonLowVoltage
Kaffeekasse: https://www.paypal.me/HMaaz
Contrib: https://svn.fhem.de/trac/browser/trunk/fhem/contrib/DS_Starter

wuast94

Result of connection check

Connection to database fhem successfully done.
Recommendation: settings o.k.

Result of encoding check

Encoding used by Client (connection): LATIN1
Encoding used by DB fhem: UTF8
Recommendation: Both encodings should be identical. You can adjust the usage of UTF8 connection by setting the UTF8 parameter in file './contrib/dblog/db.conf' to the right value.

Result of logmode check

Logmode of DbLog-device logdb is: asynchronous
Recommendation: settings o.k.

Result of table 'history' check

Column width set in DB fhem.history: 'DEVICE' = 32, 'TYPE' = 32, 'EVENT' = 512, 'READING' = 32, 'VALUE' = 32, 'UNIT' = 32
Column width used by logdb: 'DEVICE' = 64, 'TYPE' = 64, 'EVENT' = 512, 'READING' = 64, 'VALUE' = 128, 'UNIT' = 32
Recommendation: The relation between column width in table history and the field width used in device logdb don't meet the requirements. Please make sure that the width of database field definition is equal or larger than the field width used by the module. Compare the given results.
Currently the default values for field width are:

DEVICE: 64
TYPE: 64
EVENT: 512
READING: 64
VALUE: 128
UNIT: 32

You can change the column width in database by a statement like 'alter table history modify VALUE varchar(128);' (example for changing field 'VALUE'). You can do it for example by executing 'sqlCMD' in DbRep or in a SQL-Editor of your choice. (switch logdb to asynchron mode for non-blocking).
The field width used by the module can be adjusted by attributes 'colEvent', 'colReading', 'colValue',

Result of table 'current' check

Column width set in DB fhem.current: 'DEVICE' = 32, 'TYPE' = 32, 'EVENT' = 512, 'READING' = 32, 'VALUE' = 32, 'UNIT' = 32
Column width used by logdb: 'DEVICE' = 64, 'TYPE' = 64, 'EVENT' = 512, 'READING' = 64, 'VALUE' = 128, 'UNIT' = 32
Recommendation: The relation between column width in table current and the field width used in device logdb don't meet the requirements. Please make sure that the width of database field definition is equal or larger than the field width used by the module. Compare the given results.
Currently the default values for field width are:

DEVICE: 64
TYPE: 64
EVENT: 512
READING: 64
VALUE: 128
UNIT: 32

You can change the column width in database by a statement like 'alter table current modify VALUE varchar(128);' (example for changing field 'VALUE'). You can do it for example by executing 'sqlCMD' in DbRep or in a SQL-Editor of your choice. (switch logdb to asynchron mode for non-blocking).
The field width used by the module can be adjusted by attributes 'colEvent', 'colReading', 'colValue',

Result of check 'Search_Idx' availability

The index 'Search_Idx' is missing.
Recommendation: You can create the index by executing statement 'CREATE INDEX Search_Idx ON `history` (DEVICE, READING, TIMESTAMP) USING BTREE;'
Depending on your database size this command may running a long time.
Please make sure the device 'logdb' is operating in asynchronous mode to avoid FHEM from blocking when creating the index.
Note: If you have just created another index which covers the same fields and order as suggested (e.g. a primary key) you don't need to create the 'Search_Idx' as well !


Result of check 'Report_Idx' availability for DbRep-devices

You use at least one DbRep-device assigned to logdb, but the recommended index 'Report_Idx' is missing.
Recommendation: You can create the index by executing statement 'CREATE INDEX Report_Idx ON `history` (TIMESTAMP, READING) USING BTREE;'
Depending on your database size this command may running a long time.
Please make sure the device 'logdb' is operating in asynchronous mode to avoid FHEM from blocking when creating the index.
Note: If you have just created another index which covers the same fields and order as suggested (e.g. a primary key) you don't need to create the 'Report_Idx' as well !
Zigbee  Temp+Luftdruck+Humi Bewegungsmeldern Tür Kontakte, Klingel, TV, Denon, Schaltbare Steckdosen mit leistungsmessung, und weiteres

Homeassistant mit Nodered

DS_Starter

Ja, da ist die Ursache für das Problem:

Result of table 'history' check

Column width set in DB fhem.history: 'DEVICE' = 32, 'TYPE' = 32, 'EVENT' = 512, 'READING' = 32, 'VALUE' = 32, 'UNIT' = 32
Column width used by logdb: 'DEVICE' = 64, 'TYPE' = 64, 'EVENT' = 512, 'READING' = 64, 'VALUE' = 128, 'UNIT' = 32
Recommendation: The relation between column width in table history and the field width used in device logdb don't meet the requirements. Please make sure that the width of database field definition is equal or larger than the field width used by the module. Compare the given results.
Currently the default values for field width are:

DEVICE: 64
TYPE: 64
EVENT: 512
READING: 64
VALUE: 128
UNIT: 32

You can change the column width in database by a statement like 'alter table history modify VALUE varchar(128);' (example for changing field 'VALUE'). You can do it for example by executing 'sqlCMD' in DbRep or in a SQL-Editor of your choice. (switch logdb to asynchron mode for non-blocking).
The field width used by the module can be adjusted by attributes 'colEvent', 'colReading', 'colValue',


Deine Datenbankfelder sind noch nach den alten Größen von vor 12 ? Monaten eingestellt. Das hat man irgendwann mal erweitert. Deswegen kam auch der Stringfehler weil DbLog davon ausgegangen ist: "Column width used by logdb" . Du musst also die Feldgrößen in der DB für history, current anpassen.
Alternativ kann eine Anpassung über die in der Auswertung angegebenen Attribute geschehen indem du darin deine tatsächlichen (kürzeren) Feldgrößen der DB angibst (schlechtere Lösung).

Dann fehlen noch die Standardindexe. Das hat Performanceauswirkungen.
Gehe alles Schritt für Schritt durch. Am Ende soll der Check überall o.k. zeigen.

Das ist des Rätsels Lösung !

Grüße
Heiko
ESXi@NUC+Debian+MariaDB, PV: SMA, Victron MPII+Pylontech+CerboGX
Maintainer: SSCam, SSChatBot, SSCal, SSFile, DbLog/DbRep, Log2Syslog, SolarForecast,Watches, Dashboard, PylonLowVoltage
Kaffeekasse: https://www.paypal.me/HMaaz
Contrib: https://svn.fhem.de/trac/browser/trunk/fhem/contrib/DS_Starter

Kai-Alfonso

#25
Moin,

ich habe das selbe Problem. Ich habe gestern auf async Modus umgestellt und es gab kein Problem. Über Nacht kamen dann die Fehlermeldungen und der mysql Daemon(Maria DB) nimmt sich alle CPU Zeit auf meinem Raspberry.  Da ich Nacht einen Dump clientside  mache, habe ich den in Verdacht. Den kann ich gerne mal ausschalten, um das gegen zu verifizieren.

configcheck sagt:



Historie löschen
Result of connection check

Connection to database fhem successfully done.
Recommendation: settings o.k.

Result of encoding check

Encoding used by Client (connection): LATIN1
Encoding used by DB fhem: LATIN1
Recommendation: settings o.k.

Result of logmode check

Logmode of DbLog-device DBLog is: asynchronous
Recommendation: settings o.k.

Result of table 'history' check

Column width set in DB fhem.history: 'DEVICE' = 64, 'TYPE' = 64, 'EVENT' = 512, 'READING' = 64, 'VALUE' = 128, 'UNIT' = 32
Column width used by DBLog: 'DEVICE' = 64, 'TYPE' = 64, 'EVENT' = 512, 'READING' = 64, 'VALUE' = 128, 'UNIT' = 32
Recommendation: settings o.k.

Result of table 'current' check

Column width set in DB fhem.current: 'DEVICE' = 64, 'TYPE' = 64, 'EVENT' = 512, 'READING' = 64, 'VALUE' = 128, 'UNIT' = 32
Column width used by DBLog: 'DEVICE' = 64, 'TYPE' = 64, 'EVENT' = 512, 'READING' = 64, 'VALUE' = 128, 'UNIT' = 32
Recommendation: settings o.k.

Result of check 'Search_Idx' availability

Index 'Search_Idx' exists and contains the recommended fields 'DEVICE', 'READING', 'TIMESTAMP'.
Recommendation: settings o.k.

Result of check 'Report_Idx' availability for DbRep-devices

You use at least one DbRep-device assigned to DBLog. Index 'Report_Idx' exists and contains the recommended fields 'TIMESTAMP', 'READING'.
Recommendation: settings o.k.


Feldlängen hatte ich vor dem Fehler schon angefasst - musste nur auf latin1 umstellen, da  'EVENT' = 512 bei mir mit utf8 nicht ging

Autocommit ist vermutlich auch auf on

2018.01.11 07:29:10 4: DbLog DBLog -> 9690 of 9690 events updated in table current
2018.01.11 07:29:10 4: DbLog DBLog -> insert / update table current committed by autocommit
2018.01.11 07:29:10 5: DbLog DBLog -> DbLog_PushAsync finished


Als Fehler kommt immer

DBD::mysql::st execute_array failed: executing 9690 generated 9641 errors at ./FHEM/93_DbLog.pm line 1938.

und

Commit already running - resync at NextSync

Der DB User Fhem hat alle Privilegien und kann sich von % einloggen.

Jetzt wo ich schreibe ich die cputime von mysqld runtergegangen - Fehler kommen aber weiterhin und phpmyadmin ist grottenlangsam beim Zugriff auf die DB - ein Select dauert ewig, Daten werden aber in die DB geschrieben.

Edit:
ein select * auf current brauchte ein bißchen

166 rows in set (3 min 28.78 sec)

Raspi2|nanoCul433|nanoCul868|CCU2
Energie-USBZähler|homebrew HM Devices
DBLog|DBRep|Homematic|Baumarktsteckdosen
Hue|Webcams mit DS-Station (Synology)|Bewegungsmelder|Rollladen|Schalter (IT|HM)

DS_Starter

#26
Guten Morgen,

so ganz kann ich mir noch kein Bild machen.

ZitatAutocommit ist vermutlich auch auf on
siehst du mit verbose 4

Läuft die MySQL lokal oder auf einem anderen Rechner (Synology ? )

Eine Idee hätte ich ins Blaue. Setze das Attribut useCharfilter=1 und mache dann ein "set ... purgeCache" um den jetzigen Cache zu löschen.
Ich vermute es gibt Datensätze die nicht in die DB wollen weil sie zum Beispiel Steuerzeichen/Umbrüche enthalten.

EDIT: wie ist cacheLimit und syncInterval gesetzt ?

Grüße
Heiko
ESXi@NUC+Debian+MariaDB, PV: SMA, Victron MPII+Pylontech+CerboGX
Maintainer: SSCam, SSChatBot, SSCal, SSFile, DbLog/DbRep, Log2Syslog, SolarForecast,Watches, Dashboard, PylonLowVoltage
Kaffeekasse: https://www.paypal.me/HMaaz
Contrib: https://svn.fhem.de/trac/browser/trunk/fhem/contrib/DS_Starter

Kai-Alfonso

die Datenbank läuft auf einen Raspberry2/Raspbian. phpmyadmin läuft auf einer Synology.

charset=1 und purgeCache habe ich gemacht, allerdings hat es keine Auswirkungen. Der Error kommt weiterhin

DBD::mysql::st execute_array failed: executing 10941 generated 10868 errors at ./FHEM/93_DbLog.pm line 1938.

Er scheint aber regelmäßig was in die DB zu schieben (?)

2018.01.11 08:34:29 5: DbLog DBLog -> processing event Timestamp: 2018-01-11 01:10:45, Device: Stromzaehler, Type: OBIS, Event: power: 153.31, Reading: power, Value: 153.31, Unit:


bzw

2018.01.11 08:35:33 4: DbLog DBLog -> 11033 of 11033 events updated in table current
2018.01.11 08:35:33 4: DbLog DBLog -> insert / update table current committed by autocommit
2018.01.11 08:35:33 5: DbLog DBLog -> DbLog_PushAsync finished


Achja, get dbvars lieferte folgende Readings:

READINGS:
     2018-01-11 08:35:33   VAR_aria_block_size 8192
     2018-01-11 08:35:33   VAR_aria_checkpoint_interval 30
     2018-01-11 08:35:33   VAR_aria_checkpoint_log_activity 1048576
     2018-01-11 08:35:33   VAR_aria_force_start_after_recovery_failures 0
     2018-01-11 08:35:33   VAR_aria_group_commit none
     2018-01-11 08:35:33   VAR_aria_group_commit_interval 0
     2018-01-11 08:35:33   VAR_aria_log_file_size 1073741824
     2018-01-11 08:35:33   VAR_aria_log_purge_type immediate
     2018-01-11 08:35:33   VAR_aria_max_sort_file_size 9223372036853727232
     2018-01-11 08:35:33   VAR_aria_page_checksum ON
     2018-01-11 08:35:33   VAR_aria_pagecache_age_threshold 300
     2018-01-11 08:35:33   VAR_aria_pagecache_buffer_size 134217728
     2018-01-11 08:35:33   VAR_aria_pagecache_division_limit 100
     2018-01-11 08:35:33   VAR_aria_pagecache_file_hash_size 512
     2018-01-11 08:35:33   VAR_aria_recover NORMAL
     2018-01-11 08:35:33   VAR_aria_repair_threads 1
     2018-01-11 08:35:33   VAR_aria_sort_buffer_size 268434432
     2018-01-11 08:35:33   VAR_aria_stats_method nulls_unequal
     2018-01-11 08:35:33   VAR_aria_sync_log_dir NEWFILE
     2018-01-11 08:35:33   VAR_aria_used_for_temp_tables ON
     2018-01-11 08:35:33   VAR_auto_increment_increment 1
     2018-01-11 08:35:33   VAR_auto_increment_offset 1
     2018-01-11 08:35:33   VAR_autocommit  ON
     2018-01-11 08:35:33   VAR_automatic_sp_privileges ON
     2018-01-11 08:35:33   VAR_back_log    150
     2018-01-11 08:35:33   VAR_basedir     /usr
     2018-01-11 08:35:33   VAR_big_tables  OFF
     2018-01-11 08:35:33   VAR_binlog_annotate_row_events OFF
     2018-01-11 08:35:33   VAR_binlog_cache_size 32768
     2018-01-11 08:35:33   VAR_binlog_checksum NONE
     2018-01-11 08:35:33   VAR_binlog_commit_wait_count 0
     2018-01-11 08:35:33   VAR_binlog_commit_wait_usec 100000
     2018-01-11 08:35:33   VAR_binlog_direct_non_transactional_updates OFF
     2018-01-11 08:35:33   VAR_binlog_format STATEMENT
     2018-01-11 08:35:33   VAR_binlog_optimize_thread_scheduling ON
     2018-01-11 08:35:33   VAR_binlog_stmt_cache_size 32768
     2018-01-11 08:35:33   VAR_bulk_insert_buffer_size 8388608
     2018-01-11 08:35:33   VAR_character_set_client latin1
     2018-01-11 08:35:33   VAR_character_set_connection latin1
     2018-01-11 08:35:33   VAR_character_set_database latin1
     2018-01-11 08:35:33   VAR_character_set_filesystem binary
     2018-01-11 08:35:33   VAR_character_set_results latin1
     2018-01-11 08:35:33   VAR_character_set_server latin1
     2018-01-11 08:35:33   VAR_character_set_system utf8
     2018-01-11 08:35:33   VAR_character_sets_dir /usr/share/mysql/charsets/
     2018-01-11 08:35:33   VAR_collation_connection latin1_swedish_ci
     2018-01-11 08:35:33   VAR_collation_database latin1_swedish_ci
     2018-01-11 08:35:33   VAR_collation_server latin1_swedish_ci
     2018-01-11 08:35:33   VAR_completion_type NO_CHAIN
     2018-01-11 08:35:33   VAR_concurrent_insert AUTO
     2018-01-11 08:35:33   VAR_connect_timeout 10
     2018-01-11 08:35:33   VAR_datadir     /var/lib/mysql/
     2018-01-11 08:35:33   VAR_date_format %Y-%m-%d
     2018-01-11 08:35:33   VAR_datetime_format %Y-%m-%d_%H:%i:%s
     2018-01-11 08:35:33   VAR_deadlock_search_depth_long 15
     2018-01-11 08:35:33   VAR_deadlock_search_depth_short 4
     2018-01-11 08:35:33   VAR_deadlock_timeout_long 50000000
     2018-01-11 08:35:33   VAR_deadlock_timeout_short 10000
     2018-01-11 08:35:33   VAR_debug_no_thread_alarm OFF
     2018-01-11 08:35:33   VAR_default_master_connection
     2018-01-11 08:35:33   VAR_default_regex_flags
     2018-01-11 08:35:33   VAR_default_storage_engine InnoDB
     2018-01-11 08:35:33   VAR_default_week_format 0
     2018-01-11 08:35:33   VAR_delay_key_write ON
     2018-01-11 08:35:33   VAR_delayed_insert_limit 100
     2018-01-11 08:35:33   VAR_delayed_insert_timeout 300
     2018-01-11 08:35:33   VAR_delayed_queue_size 1000
     2018-01-11 08:35:33   VAR_div_precision_increment 4
     2018-01-11 08:35:33   VAR_error_count 0
     2018-01-11 08:35:33   VAR_event_scheduler OFF
     2018-01-11 08:35:33   VAR_expensive_subquery_limit 100
     2018-01-11 08:35:33   VAR_expire_logs_days 10
     2018-01-11 08:35:33   VAR_external_user
     2018-01-11 08:35:33   VAR_extra_max_connections 1
     2018-01-11 08:35:33   VAR_extra_port  0
     2018-01-11 08:35:33   VAR_flush       OFF
     2018-01-11 08:35:33   VAR_flush_time  0
     2018-01-11 08:35:33   VAR_foreign_key_checks ON
     2018-01-11 08:35:33   VAR_ft_boolean_syntax +_-><()~*:""&|
     2018-01-11 08:35:33   VAR_ft_max_word_len 84
     2018-01-11 08:35:33   VAR_ft_min_word_len 4
     2018-01-11 08:35:33   VAR_ft_query_expansion_limit 20
     2018-01-11 08:35:33   VAR_ft_stopword_file (built-in)
     2018-01-11 08:35:33   VAR_general_log OFF
     2018-01-11 08:35:33   VAR_general_log_file fhem.log
     2018-01-11 08:35:33   VAR_group_concat_max_len 1024
     2018-01-11 08:35:33   VAR_gtid_binlog_pos
     2018-01-11 08:35:33   VAR_gtid_binlog_state
     2018-01-11 08:35:33   VAR_gtid_current_pos
     2018-01-11 08:35:33   VAR_gtid_domain_id 0
     2018-01-11 08:35:33   VAR_gtid_ignore_duplicates OFF
     2018-01-11 08:35:33   VAR_gtid_seq_no 0
     2018-01-11 08:35:33   VAR_gtid_slave_pos
     2018-01-11 08:35:33   VAR_gtid_strict_mode OFF
     2018-01-11 08:35:33   VAR_have_compress YES
     2018-01-11 08:35:33   VAR_have_crypt  YES
     2018-01-11 08:35:33   VAR_have_dynamic_loading YES
     2018-01-11 08:35:33   VAR_have_geometry YES
     2018-01-11 08:35:33   VAR_have_openssl NO
     2018-01-11 08:35:33   VAR_have_profiling YES
     2018-01-11 08:35:33   VAR_have_query_cache YES
     2018-01-11 08:35:33   VAR_have_rtree_keys YES
     2018-01-11 08:35:33   VAR_have_ssl    DISABLED
     2018-01-11 08:35:33   VAR_have_symlink YES
     2018-01-11 08:35:33   VAR_histogram_size 0
     2018-01-11 08:35:33   VAR_histogram_type SINGLE_PREC_HB
     2018-01-11 08:35:33   VAR_host_cache_size 128
     2018-01-11 08:35:33   VAR_hostname    fhem
     2018-01-11 08:35:33   VAR_identity    0
     2018-01-11 08:35:33   VAR_ignore_builtin_innodb OFF
     2018-01-11 08:35:33   VAR_ignore_db_dirs
     2018-01-11 08:35:33   VAR_in_transaction 0
     2018-01-11 08:35:33   VAR_init_connect
     2018-01-11 08:35:33   VAR_init_file   
     2018-01-11 08:35:33   VAR_init_slave 
     2018-01-11 08:35:33   VAR_innodb_adaptive_flushing ON
     2018-01-11 08:35:33   VAR_innodb_adaptive_flushing_lwm 10.000000
     2018-01-11 08:35:33   VAR_innodb_adaptive_hash_index ON
     2018-01-11 08:35:33   VAR_innodb_adaptive_hash_index_partitions 1
     2018-01-11 08:35:33   VAR_innodb_adaptive_max_sleep_delay 150000
     2018-01-11 08:35:33   VAR_innodb_additional_mem_pool_size 8388608
     2018-01-11 08:35:33   VAR_innodb_api_bk_commit_interval 5
     2018-01-11 08:35:33   VAR_innodb_api_disable_rowlock OFF
     2018-01-11 08:35:33   VAR_innodb_api_enable_binlog OFF
     2018-01-11 08:35:33   VAR_innodb_api_enable_mdl OFF
     2018-01-11 08:35:33   VAR_innodb_api_trx_level 0
     2018-01-11 08:35:33   VAR_innodb_autoextend_increment 64
     2018-01-11 08:35:33   VAR_innodb_autoinc_lock_mode 1
     2018-01-11 08:35:33   VAR_innodb_buffer_pool_dump_at_shutdown OFF
     2018-01-11 08:35:33   VAR_innodb_buffer_pool_dump_now OFF
     2018-01-11 08:35:33   VAR_innodb_buffer_pool_dump_pct 100
     2018-01-11 08:35:33   VAR_innodb_buffer_pool_filename ib_buffer_pool
     2018-01-11 08:35:33   VAR_innodb_buffer_pool_instances 8
     2018-01-11 08:35:33   VAR_innodb_buffer_pool_load_abort OFF
     2018-01-11 08:35:33   VAR_innodb_buffer_pool_load_at_startup OFF
     2018-01-11 08:35:33   VAR_innodb_buffer_pool_load_now OFF
     2018-01-11 08:35:33   VAR_innodb_buffer_pool_populate OFF
     2018-01-11 08:35:33   VAR_innodb_buffer_pool_size 134217728
     2018-01-11 08:35:33   VAR_innodb_change_buffer_max_size 25
     2018-01-11 08:35:33   VAR_innodb_change_buffering all
     2018-01-11 08:35:33   VAR_innodb_checksum_algorithm innodb
     2018-01-11 08:35:33   VAR_innodb_checksums ON
     2018-01-11 08:35:33   VAR_innodb_cleaner_lsn_age_factor high_checkpoint
     2018-01-11 08:35:33   VAR_innodb_cmp_per_index_enabled OFF
     2018-01-11 08:35:33   VAR_innodb_commit_concurrency 0
     2018-01-11 08:35:33   VAR_innodb_compression_failure_threshold_pct 5
     2018-01-11 08:35:33   VAR_innodb_compression_level 6
     2018-01-11 08:35:33   VAR_innodb_compression_pad_pct_max 50
     2018-01-11 08:35:33   VAR_innodb_concurrency_tickets 5000
     2018-01-11 08:35:33   VAR_innodb_corrupt_table_action assert
     2018-01-11 08:35:33   VAR_innodb_data_file_path ibdata1:12M:autoextend
     2018-01-11 08:35:33   VAR_innodb_data_home_dir
     2018-01-11 08:35:33   VAR_innodb_disable_sort_file_cache OFF
     2018-01-11 08:35:33   VAR_innodb_doublewrite ON
     2018-01-11 08:35:33   VAR_innodb_empty_free_list_algorithm legacy
     2018-01-11 08:35:33   VAR_innodb_fake_changes OFF
     2018-01-11 08:35:33   VAR_innodb_fast_shutdown 1
     2018-01-11 08:35:33   VAR_innodb_file_format Antelope
     2018-01-11 08:35:33   VAR_innodb_file_format_check ON
     2018-01-11 08:35:33   VAR_innodb_file_format_max Antelope
     2018-01-11 08:35:33   VAR_innodb_file_per_table ON
     2018-01-11 08:35:33   VAR_innodb_flush_log_at_timeout 1
     2018-01-11 08:35:33   VAR_innodb_flush_log_at_trx_commit 1
     2018-01-11 08:35:33   VAR_innodb_flush_method
     2018-01-11 08:35:33   VAR_innodb_flush_neighbors 1
     2018-01-11 08:35:33   VAR_innodb_flushing_avg_loops 30
     2018-01-11 08:35:33   VAR_innodb_force_load_corrupted OFF
     2018-01-11 08:35:33   VAR_innodb_force_recovery 0
     2018-01-11 08:35:33   VAR_innodb_foreground_preflush exponential_backoff
     2018-01-11 08:35:33   VAR_innodb_ft_aux_table
     2018-01-11 08:35:33   VAR_innodb_ft_cache_size 8000000
     2018-01-11 08:35:33   VAR_innodb_ft_enable_diag_print OFF
     2018-01-11 08:35:33   VAR_innodb_ft_enable_stopword ON
     2018-01-11 08:35:33   VAR_innodb_ft_max_token_size 84
     2018-01-11 08:35:33   VAR_innodb_ft_min_token_size 3
     2018-01-11 08:35:33   VAR_innodb_ft_num_word_optimize 2000
     2018-01-11 08:35:33   VAR_innodb_ft_result_cache_limit 2000000000
     2018-01-11 08:35:33   VAR_innodb_ft_server_stopword_table
     2018-01-11 08:35:33   VAR_innodb_ft_sort_pll_degree 2
     2018-01-11 08:35:33   VAR_innodb_ft_total_cache_size 640000000
     2018-01-11 08:35:33   VAR_innodb_ft_user_stopword_table
     2018-01-11 08:35:33   VAR_innodb_io_capacity 200
     2018-01-11 08:35:33   VAR_innodb_io_capacity_max 2000
     2018-01-11 08:35:33   VAR_innodb_kill_idle_transaction 0
     2018-01-11 08:35:33   VAR_innodb_large_prefix OFF
     2018-01-11 08:35:33   VAR_innodb_lock_wait_timeout 50
     2018-01-11 08:35:33   VAR_innodb_locking_fake_changes ON
     2018-01-11 08:35:33   VAR_innodb_locks_unsafe_for_binlog OFF
     2018-01-11 08:35:33   VAR_innodb_log_arch_dir ./
     2018-01-11 08:35:33   VAR_innodb_log_arch_expire_sec 0
     2018-01-11 08:35:33   VAR_innodb_log_archive OFF
     2018-01-11 08:35:33   VAR_innodb_log_block_size 512
     2018-01-11 08:35:33   VAR_innodb_log_buffer_size 8388608
     2018-01-11 08:35:33   VAR_innodb_log_checksum_algorithm innodb
     2018-01-11 08:35:33   VAR_innodb_log_compressed_pages ON
     2018-01-11 08:35:33   VAR_innodb_log_file_size 50331648
     2018-01-11 08:35:33   VAR_innodb_log_files_in_group 2
     2018-01-11 08:35:33   VAR_innodb_log_group_home_dir ./
     2018-01-11 08:35:33   VAR_innodb_lru_scan_depth 1024
     2018-01-11 08:35:33   VAR_innodb_max_bitmap_file_size 104857600
     2018-01-11 08:35:33   VAR_innodb_max_changed_pages 1000000
     2018-01-11 08:35:33   VAR_innodb_max_dirty_pages_pct 75.000000
     2018-01-11 08:35:33   VAR_innodb_max_dirty_pages_pct_lwm 0.001000
     2018-01-11 08:35:33   VAR_innodb_max_purge_lag 0
     2018-01-11 08:35:33   VAR_innodb_max_purge_lag_delay 0
     2018-01-11 08:35:33   VAR_innodb_mirrored_log_groups 1
     2018-01-11 08:35:33   VAR_innodb_monitor_disable
     2018-01-11 08:35:33   VAR_innodb_monitor_enable
     2018-01-11 08:35:33   VAR_innodb_monitor_reset
     2018-01-11 08:35:33   VAR_innodb_monitor_reset_all
     2018-01-11 08:35:33   VAR_innodb_old_blocks_pct 37
     2018-01-11 08:35:33   VAR_innodb_old_blocks_time 1000
     2018-01-11 08:35:33   VAR_innodb_online_alter_log_max_size 134217728
     2018-01-11 08:35:33   VAR_innodb_open_files 400
     2018-01-11 08:35:33   VAR_innodb_optimize_fulltext_only OFF
     2018-01-11 08:35:33   VAR_innodb_page_size 16384
     2018-01-11 08:35:33   VAR_innodb_print_all_deadlocks OFF
     2018-01-11 08:35:33   VAR_innodb_purge_batch_size 300
     2018-01-11 08:35:33   VAR_innodb_purge_threads 1
     2018-01-11 08:35:33   VAR_innodb_random_read_ahead OFF
     2018-01-11 08:35:33   VAR_innodb_read_ahead_threshold 56
     2018-01-11 08:35:33   VAR_innodb_read_io_threads 4
     2018-01-11 08:35:33   VAR_innodb_read_only OFF
     2018-01-11 08:35:33   VAR_innodb_replication_delay 0
     2018-01-11 08:35:33   VAR_innodb_rollback_on_timeout OFF
     2018-01-11 08:35:33   VAR_innodb_rollback_segments 128
     2018-01-11 08:35:33   VAR_innodb_sched_priority_cleaner 19
     2018-01-11 08:35:33   VAR_innodb_show_locks_held 10
     2018-01-11 08:35:33   VAR_innodb_show_verbose_locks 0
     2018-01-11 08:35:33   VAR_innodb_simulate_comp_failures 0
     2018-01-11 08:35:33   VAR_innodb_sort_buffer_size 1048576
     2018-01-11 08:35:33   VAR_innodb_spin_wait_delay 6
     2018-01-11 08:35:33   VAR_innodb_stats_auto_recalc ON
     2018-01-11 08:35:33   VAR_innodb_stats_include_delete_marked OFF
     2018-01-11 08:35:33   VAR_innodb_stats_method nulls_equal
     2018-01-11 08:35:33   VAR_innodb_stats_modified_counter 0
     2018-01-11 08:35:33   VAR_innodb_stats_on_metadata OFF
     2018-01-11 08:35:33   VAR_innodb_stats_persistent ON
     2018-01-11 08:35:33   VAR_innodb_stats_persistent_sample_pages 20
     2018-01-11 08:35:33   VAR_innodb_stats_sample_pages 8
     2018-01-11 08:35:33   VAR_innodb_stats_traditional ON
     2018-01-11 08:35:33   VAR_innodb_stats_transient_sample_pages 8
     2018-01-11 08:35:33   VAR_innodb_status_output OFF
     2018-01-11 08:35:33   VAR_innodb_status_output_locks OFF
     2018-01-11 08:35:33   VAR_innodb_strict_mode OFF
     2018-01-11 08:35:33   VAR_innodb_support_xa ON
     2018-01-11 08:35:33   VAR_innodb_sync_array_size 1
     2018-01-11 08:35:33   VAR_innodb_sync_spin_loops 30
     2018-01-11 08:35:33   VAR_innodb_table_locks ON
     2018-01-11 08:35:33   VAR_innodb_thread_concurrency 0
     2018-01-11 08:35:33   VAR_innodb_thread_sleep_delay 10000
     2018-01-11 08:35:33   VAR_innodb_tmpdir
     2018-01-11 08:35:33   VAR_innodb_track_changed_pages OFF
     2018-01-11 08:35:33   VAR_innodb_undo_directory .
     2018-01-11 08:35:33   VAR_innodb_undo_logs 128
     2018-01-11 08:35:33   VAR_innodb_undo_tablespaces 0
     2018-01-11 08:35:33   VAR_innodb_use_atomic_writes OFF
     2018-01-11 08:35:33   VAR_innodb_use_fallocate OFF
     2018-01-11 08:35:33   VAR_innodb_use_global_flush_log_at_trx_commit ON
     2018-01-11 08:35:33   VAR_innodb_use_native_aio ON
     2018-01-11 08:35:33   VAR_innodb_use_stacktrace OFF
     2018-01-11 08:35:33   VAR_innodb_use_sys_malloc ON
     2018-01-11 08:35:33   VAR_innodb_version 5.6.36-82.1
     2018-01-11 08:35:33   VAR_innodb_write_io_threads 4
     2018-01-11 08:35:33   VAR_insert_id   0
     2018-01-11 08:35:33   VAR_interactive_timeout 28800
     2018-01-11 08:35:33   VAR_join_buffer_size 131072
     2018-01-11 08:35:33   VAR_join_buffer_space_limit 2097152
     2018-01-11 08:35:33   VAR_join_cache_level 2
     2018-01-11 08:35:33   VAR_keep_files_on_create OFF
     2018-01-11 08:35:33   VAR_key_buffer_size 16777216
     2018-01-11 08:35:33   VAR_key_cache_age_threshold 300
     2018-01-11 08:35:33   VAR_key_cache_block_size 1024
     2018-01-11 08:35:33   VAR_key_cache_division_limit 100
     2018-01-11 08:35:33   VAR_key_cache_file_hash_size 512
     2018-01-11 08:35:33   VAR_key_cache_segments 0
     2018-01-11 08:35:33   VAR_large_files_support ON
     2018-01-11 08:35:33   VAR_large_page_size 0
     2018-01-11 08:35:33   VAR_large_pages OFF
     2018-01-11 08:35:33   VAR_last_gtid   
     2018-01-11 08:35:33   VAR_last_insert_id 0
     2018-01-11 08:35:33   VAR_lc_messages en_US
     2018-01-11 08:35:33   VAR_lc_messages_dir /usr/share/mysql
     2018-01-11 08:35:33   VAR_lc_time_names en_US
     2018-01-11 08:35:33   VAR_license     GPL
     2018-01-11 08:35:33   VAR_local_infile ON
     2018-01-11 08:35:33   VAR_lock_wait_timeout 31536000
     2018-01-11 08:35:33   VAR_locked_in_memory OFF
     2018-01-11 08:35:33   VAR_log_bin     OFF
     2018-01-11 08:35:33   VAR_log_bin_trust_function_creators OFF
     2018-01-11 08:35:33   VAR_log_error   
     2018-01-11 08:35:33   VAR_log_output  FILE
     2018-01-11 08:35:33   VAR_log_queries_not_using_indexes OFF
     2018-01-11 08:35:33   VAR_log_slave_updates OFF
     2018-01-11 08:35:33   VAR_log_slow_filter admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
     2018-01-11 08:35:33   VAR_log_slow_rate_limit 1
     2018-01-11 08:35:33   VAR_log_slow_verbosity
     2018-01-11 08:35:33   VAR_log_warnings 1
     2018-01-11 08:35:33   VAR_long_query_time 10.000000
     2018-01-11 08:35:33   VAR_low_priority_updates OFF
     2018-01-11 08:35:33   VAR_lower_case_file_system OFF
     2018-01-11 08:35:33   VAR_lower_case_table_names 0
     2018-01-11 08:35:33   VAR_master_verify_checksum OFF
     2018-01-11 08:35:33   VAR_max_allowed_packet 16777216
     2018-01-11 08:35:33   VAR_max_binlog_cache_size 4294963200
     2018-01-11 08:35:33   VAR_max_binlog_size 104857600
     2018-01-11 08:35:33   VAR_max_binlog_stmt_cache_size 4294963200
     2018-01-11 08:35:33   VAR_max_connect_errors 100
     2018-01-11 08:35:33   VAR_max_connections 151
     2018-01-11 08:35:33   VAR_max_delayed_threads 20
     2018-01-11 08:35:33   VAR_max_digest_length 1024
     2018-01-11 08:35:33   VAR_max_error_count 64
     2018-01-11 08:35:33   VAR_max_heap_table_size 16777216
     2018-01-11 08:35:33   VAR_max_insert_delayed_threads 20
     2018-01-11 08:35:33   VAR_max_join_size 18446744073709551615
     2018-01-11 08:35:33   VAR_max_length_for_sort_data 1024
     2018-01-11 08:35:33   VAR_max_long_data_size 16777216
     2018-01-11 08:35:33   VAR_max_prepared_stmt_count 16382
     2018-01-11 08:35:33   VAR_max_relay_log_size 104857600
     2018-01-11 08:35:33   VAR_max_seeks_for_key 4294967295
     2018-01-11 08:35:33   VAR_max_sort_length 1024
     2018-01-11 08:35:33   VAR_max_sp_recursion_depth 0
     2018-01-11 08:35:33   VAR_max_tmp_tables 32
     2018-01-11 08:35:33   VAR_max_user_connections 0
     2018-01-11 08:35:33   VAR_max_write_lock_count 4294967295
     2018-01-11 08:35:33   VAR_metadata_locks_cache_size 1024
     2018-01-11 08:35:33   VAR_metadata_locks_hash_instances 8
     2018-01-11 08:35:33   VAR_min_examined_row_limit 0
     2018-01-11 08:35:33   VAR_mrr_buffer_size 262144
     2018-01-11 08:35:33   VAR_multi_range_count 256
     2018-01-11 08:35:33   VAR_myisam_block_size 1024
     2018-01-11 08:35:33   VAR_myisam_data_pointer_size 6
     2018-01-11 08:35:33   VAR_myisam_max_sort_file_size 2146435072
     2018-01-11 08:35:33   VAR_myisam_mmap_size 4294967295
     2018-01-11 08:35:33   VAR_myisam_recover_options BACKUP
     2018-01-11 08:35:33   VAR_myisam_repair_threads 1
     2018-01-11 08:35:33   VAR_myisam_sort_buffer_size 134216704
     2018-01-11 08:35:33   VAR_myisam_stats_method nulls_unequal
     2018-01-11 08:35:33   VAR_myisam_use_mmap OFF
     2018-01-11 08:35:33   VAR_net_buffer_length 16384
     2018-01-11 08:35:33   VAR_net_read_timeout 30
     2018-01-11 08:35:33   VAR_net_retry_count 10
     2018-01-11 08:35:33   VAR_net_write_timeout 60
     2018-01-11 08:35:33   VAR_old         OFF
     2018-01-11 08:35:33   VAR_old_alter_table OFF
     2018-01-11 08:35:33   VAR_old_mode   
     2018-01-11 08:35:33   VAR_old_passwords OFF
     2018-01-11 08:35:33   VAR_open_files_limit 1024
     2018-01-11 08:35:33   VAR_optimizer_prune_level 1
     2018-01-11 08:35:33   VAR_optimizer_search_depth 62
     2018-01-11 08:35:33   VAR_optimizer_selectivity_sampling_limit 100
     2018-01-11 08:35:33   VAR_optimizer_switch index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on
     2018-01-11 08:35:33   VAR_optimizer_use_condition_selectivity 1
     2018-01-11 08:35:33   VAR_performance_schema OFF
     2018-01-11 08:35:33   VAR_performance_schema_accounts_size -1
     2018-01-11 08:35:33   VAR_performance_schema_digests_size -1
     2018-01-11 08:35:33   VAR_performance_schema_events_stages_history_long_size -1
     2018-01-11 08:35:33   VAR_performance_schema_events_stages_history_size -1
     2018-01-11 08:35:33   VAR_performance_schema_events_statements_history_long_size -1
     2018-01-11 08:35:33   VAR_performance_schema_events_statements_history_size -1
     2018-01-11 08:35:33   VAR_performance_schema_events_waits_history_long_size -1
     2018-01-11 08:35:33   VAR_performance_schema_events_waits_history_size -1
     2018-01-11 08:35:33   VAR_performance_schema_hosts_size -1
     2018-01-11 08:35:33   VAR_performance_schema_max_cond_classes 80
     2018-01-11 08:35:33   VAR_performance_schema_max_cond_instances -1
     2018-01-11 08:35:33   VAR_performance_schema_max_digest_length 1024
     2018-01-11 08:35:33   VAR_performance_schema_max_file_classes 50
     2018-01-11 08:35:33   VAR_performance_schema_max_file_handles 32768
     2018-01-11 08:35:33   VAR_performance_schema_max_file_instances -1
     2018-01-11 08:35:33   VAR_performance_schema_max_mutex_classes 200
     2018-01-11 08:35:33   VAR_performance_schema_max_mutex_instances -1
     2018-01-11 08:35:33   VAR_performance_schema_max_rwlock_classes 40
     2018-01-11 08:35:33   VAR_performance_schema_max_rwlock_instances -1
     2018-01-11 08:35:33   VAR_performance_schema_max_socket_classes 10
     2018-01-11 08:35:33   VAR_performance_schema_max_socket_instances -1
     2018-01-11 08:35:33   VAR_performance_schema_max_stage_classes 150
     2018-01-11 08:35:33   VAR_performance_schema_max_statement_classes 180
     2018-01-11 08:35:33   VAR_performance_schema_max_table_handles -1
     2018-01-11 08:35:33   VAR_performance_schema_max_table_instances -1
     2018-01-11 08:35:33   VAR_performance_schema_max_thread_classes 50
     2018-01-11 08:35:33   VAR_performance_schema_max_thread_instances -1
     2018-01-11 08:35:33   VAR_performance_schema_session_connect_attrs_size -1
     2018-01-11 08:35:33   VAR_performance_schema_setup_actors_size 100
     2018-01-11 08:35:33   VAR_performance_schema_setup_objects_size 100
     2018-01-11 08:35:33   VAR_performance_schema_users_size -1
     2018-01-11 08:35:33   VAR_pid_file    /var/run/mysqld/mysqld.pid
     2018-01-11 08:35:33   VAR_plugin_dir  /usr/lib/mysql/plugin/
     2018-01-11 08:35:33   VAR_plugin_maturity unknown
     2018-01-11 08:35:33   VAR_port        3306
     2018-01-11 08:35:33   VAR_preload_buffer_size 32768
     2018-01-11 08:35:33   VAR_profiling   OFF
     2018-01-11 08:35:33   VAR_profiling_history_size 15
     2018-01-11 08:35:33   VAR_progress_report_time 5
     2018-01-11 08:35:33   VAR_protocol_version 10
     2018-01-11 08:35:33   VAR_proxy_user 
     2018-01-11 08:35:33   VAR_pseudo_slave_mode OFF
     2018-01-11 08:35:33   VAR_pseudo_thread_id 77846
     2018-01-11 08:35:33   VAR_query_alloc_block_size 8192
     2018-01-11 08:35:33   VAR_query_cache_limit 1048576
     2018-01-11 08:35:33   VAR_query_cache_min_res_unit 4096
     2018-01-11 08:35:33   VAR_query_cache_size 16777216
     2018-01-11 08:35:33   VAR_query_cache_strip_comments OFF
     2018-01-11 08:35:33   VAR_query_cache_type ON
     2018-01-11 08:35:33   VAR_query_cache_wlock_invalidate OFF
     2018-01-11 08:35:33   VAR_query_prealloc_size 8192
     2018-01-11 08:35:33   VAR_rand_seed1  0
     2018-01-11 08:35:33   VAR_rand_seed2  0
     2018-01-11 08:35:33   VAR_range_alloc_block_size 4096
     2018-01-11 08:35:33   VAR_read_buffer_size 131072
     2018-01-11 08:35:33   VAR_read_only   OFF
     2018-01-11 08:35:33   VAR_read_rnd_buffer_size 262144
     2018-01-11 08:35:33   VAR_relay_log   
     2018-01-11 08:35:33   VAR_relay_log_index
     2018-01-11 08:35:33   VAR_relay_log_info_file relay-log.info
     2018-01-11 08:35:33   VAR_relay_log_purge ON
     2018-01-11 08:35:33   VAR_relay_log_recovery OFF
     2018-01-11 08:35:33   VAR_relay_log_space_limit 0
     2018-01-11 08:35:33   VAR_replicate_annotate_row_events OFF
     2018-01-11 08:35:33   VAR_replicate_do_db
     2018-01-11 08:35:33   VAR_replicate_do_table
     2018-01-11 08:35:33   VAR_replicate_events_marked_for_skip replicate
     2018-01-11 08:35:33   VAR_replicate_ignore_db
     2018-01-11 08:35:33   VAR_replicate_ignore_table
     2018-01-11 08:35:33   VAR_replicate_wild_do_table
     2018-01-11 08:35:33   VAR_replicate_wild_ignore_table
     2018-01-11 08:35:33   VAR_report_host
     2018-01-11 08:35:33   VAR_report_password
     2018-01-11 08:35:33   VAR_report_port 3306
     2018-01-11 08:35:33   VAR_report_user
     2018-01-11 08:35:33   VAR_rowid_merge_buff_size 8388608
     2018-01-11 08:35:33   VAR_rpl_recovery_rank 0
     2018-01-11 08:35:33   VAR_secure_auth OFF
     2018-01-11 08:35:33   VAR_secure_file_priv
     2018-01-11 08:35:33   VAR_server_id   0
     2018-01-11 08:35:33   VAR_skip_external_locking ON
     2018-01-11 08:35:33   VAR_skip_name_resolve OFF
     2018-01-11 08:35:33   VAR_skip_networking OFF
     2018-01-11 08:35:33   VAR_skip_replication OFF
     2018-01-11 08:35:33   VAR_skip_show_database OFF
     2018-01-11 08:35:33   VAR_slave_compressed_protocol OFF
     2018-01-11 08:35:33   VAR_slave_ddl_exec_mode IDEMPOTENT
     2018-01-11 08:35:33   VAR_slave_domain_parallel_threads 0
     2018-01-11 08:35:33   VAR_slave_exec_mode STRICT
     2018-01-11 08:35:33   VAR_slave_load_tmpdir /tmp
     2018-01-11 08:35:33   VAR_slave_max_allowed_packet 1073741824
     2018-01-11 08:35:33   VAR_slave_net_timeout 3600
     2018-01-11 08:35:33   VAR_slave_parallel_max_queued 131072
     2018-01-11 08:35:33   VAR_slave_parallel_threads 0
     2018-01-11 08:35:33   VAR_slave_skip_errors OFF
     2018-01-11 08:35:33   VAR_slave_sql_verify_checksum ON
     2018-01-11 08:35:33   VAR_slave_transaction_retries 10
     2018-01-11 08:35:33   VAR_slave_type_conversions
     2018-01-11 08:35:33   VAR_slow_launch_time 2
     2018-01-11 08:35:33   VAR_slow_query_log OFF
     2018-01-11 08:35:33   VAR_slow_query_log_file fhem-slow.log
     2018-01-11 08:35:33   VAR_socket      /var/run/mysqld/mysqld.sock
     2018-01-11 08:35:33   VAR_sort_buffer_size 2097152
     2018-01-11 08:35:33   VAR_sql_auto_is_null OFF
     2018-01-11 08:35:33   VAR_sql_big_selects ON
     2018-01-11 08:35:33   VAR_sql_buffer_result OFF
     2018-01-11 08:35:33   VAR_sql_log_bin ON
     2018-01-11 08:35:33   VAR_sql_log_off OFF
     2018-01-11 08:35:33   VAR_sql_mode   
     2018-01-11 08:35:33   VAR_sql_notes   ON
     2018-01-11 08:35:33   VAR_sql_quote_show_create ON
     2018-01-11 08:35:33   VAR_sql_safe_updates OFF
     2018-01-11 08:35:33   VAR_sql_select_limit 18446744073709551615
     2018-01-11 08:35:33   VAR_sql_slave_skip_counter 0
     2018-01-11 08:35:33   VAR_sql_warnings OFF
     2018-01-11 08:35:33   VAR_ssl_ca     
     2018-01-11 08:35:33   VAR_ssl_capath 
     2018-01-11 08:35:33   VAR_ssl_cert   
     2018-01-11 08:35:33   VAR_ssl_cipher 
     2018-01-11 08:35:33   VAR_ssl_crl     
     2018-01-11 08:35:33   VAR_ssl_crlpath
     2018-01-11 08:35:33   VAR_ssl_key     
     2018-01-11 08:35:33   VAR_storage_engine InnoDB
     2018-01-11 08:35:33   VAR_stored_program_cache 256
     2018-01-11 08:35:33   VAR_sync_binlog 0
     2018-01-11 08:35:33   VAR_sync_frm    ON
     2018-01-11 08:35:33   VAR_sync_master_info 0
     2018-01-11 08:35:33   VAR_sync_relay_log 0
     2018-01-11 08:35:33   VAR_sync_relay_log_info 0
     2018-01-11 08:35:33   VAR_system_time_zone CET
     2018-01-11 08:35:33   VAR_table_definition_cache 400
     2018-01-11 08:35:33   VAR_table_open_cache 400
     2018-01-11 08:35:33   VAR_thread_cache_size 8
     2018-01-11 08:35:33   VAR_thread_concurrency 10
     2018-01-11 08:35:33   VAR_thread_handling one-thread-per-connection
     2018-01-11 08:35:33   VAR_thread_pool_idle_timeout 60
     2018-01-11 08:35:33   VAR_thread_pool_max_threads 500
     2018-01-11 08:35:33   VAR_thread_pool_oversubscribe 3
     2018-01-11 08:35:33   VAR_thread_pool_size 4
     2018-01-11 08:35:33   VAR_thread_pool_stall_limit 500
     2018-01-11 08:35:33   VAR_thread_stack 196608
     2018-01-11 08:35:33   VAR_time_format %H:%i:%s
     2018-01-11 08:35:33   VAR_time_zone   SYSTEM
     2018-01-11 08:35:33   VAR_timed_mutexes OFF
     2018-01-11 08:35:33   VAR_timestamp   1515656133.397296
     2018-01-11 08:35:33   VAR_tmp_table_size 16777216
     2018-01-11 08:35:33   VAR_tmpdir      /tmp
     2018-01-11 08:35:33   VAR_transaction_alloc_block_size 8192
     2018-01-11 08:35:33   VAR_transaction_prealloc_size 4096
     2018-01-11 08:35:33   VAR_tx_isolation REPEATABLE-READ
     2018-01-11 08:35:33   VAR_tx_read_only OFF
     2018-01-11 08:35:33   VAR_unique_checks ON
     2018-01-11 08:35:33   VAR_updatable_views_with_limit YES
     2018-01-11 08:35:33   VAR_use_stat_tables NEVER
     2018-01-11 08:35:33   VAR_userstat    OFF
     2018-01-11 08:35:33   VAR_version     10.0.32-MariaDB-0+deb8u1
     2018-01-11 08:35:33   VAR_version_comment (Raspbian)
     2018-01-11 08:35:33   VAR_version_compile_machine armv8l
     2018-01-11 08:35:33   VAR_version_compile_os debian-linux-gnueabihf
     2018-01-11 08:35:33   VAR_version_malloc_library bundled_jemalloc
     2018-01-11 08:35:33   VAR_wait_timeout 28800
     2018-01-11 08:35:33   VAR_warning_count 0
Raspi2|nanoCul433|nanoCul868|CCU2
Energie-USBZähler|homebrew HM Devices
DBLog|DBRep|Homematic|Baumarktsteckdosen
Hue|Webcams mit DS-Station (Synology)|Bewegungsmelder|Rollladen|Schalter (IT|HM)

Kai-Alfonso

Nachtrag:

root@fhem:/opt/fhem#dpkg -l |grep -i 'libdb.*-perl'
ii  libdbd-mysql-perl                     4.028-2+deb8u2                            armhf        Perl5 database interface to the MySQL database
ii  libdbd-sqlite3-perl                   1.44-1                                    armhf        Perl DBI driver with a self-contained RDBMS
ii  libdbi-perl                           1.631-3+b1                                armhf        Perl Database Interface (DBI)
Raspi2|nanoCul433|nanoCul868|CCU2
Energie-USBZähler|homebrew HM Devices
DBLog|DBRep|Homematic|Baumarktsteckdosen
Hue|Webcams mit DS-Station (Synology)|Bewegungsmelder|Rollladen|Schalter (IT|HM)

Kai-Alfonso

Doppel-Nachtrag  8) 8) :o :o

Das taucht im Log immer auf, bevor die Daten commited werden:


2018.01.11 08:46:56 5: DbLog $name -> MemCache contains: $hash->{cache}{".memcache"}{$key}
2018.01.11 08:46:56 5: DbLog $name -> MemCache contains: $hash->{cache}{".memcache"}{$key}
2018.01.11 08:46:56 5: DbLog $name -> MemCache contains: $hash->{cache}{".memcache"}{$key}
2018.01.11 08:46:56 5: DbLog $name -> MemCache contains: $hash->{cache}{".memcache"}{$key}
2018.01.11 08:46:56 5: DbLog $name -> MemCache contains: $hash->{cache}{".memcache"}{$key}
2018.01.11 08:46:56 5: DbLog $name -> MemCache contains: $hash->{cache}{".memcache"}{$key}
2018.01.11 08:46:56 5: DbLog $name -> MemCache contains: $hash->{cache}{".memcache"}{$key}
2018.01.11 08:46:56 5: DbLog $name -> MemCache contains: $hash->{cache}{".memcache"}{$key}
2018.01.11 08:46:56 5: DbLog $name -> MemCache contains: $hash->{cache}{".memcache"}{$key}
2018.01.11 08:46:56 5: DbLog $name -> MemCache contains: $hash->{cache}{".memcache"}{$key}
2018.01.11 08:46:56 5: DbLog $name -> MemCache contains: $hash->{cache}{".memcache"}{$key}
2018.01.11 08:46:56 5: DbLog $name -> MemCache contains: $hash->{cache}{".memcache"}{$key}
2018.01.11 08:46:56 5: DbLog $name -> MemCache contains: $hash->{cache}{".memcache"}{$key}
2018.01.11 08:46:56 5: DbLog $name -> MemCache contains: $hash->{cache}{".memcache"}{$key}
2018.01.11 08:46:56 5: DbLog $name -> MemCache contains: $hash->{cache}{".memcache"}{$key}
2018.01.11 08:46:56 5: DbLog $name -> MemCache contains: $hash->{cache}{".memcache"}{$key}
2018.01.11 08:46:56 5: DbLog $name -> MemCache contains: $hash->{cache}{".memcache"}{$key}
2018.01.11 08:46:56 5: DbLog $name -> MemCache contains: $hash->{cache}{".memcache"}{$key}
2018.01.11 08:46:56 5: DbLog $name -> MemCache contains: $hash->{cache}{".memcache"}{$key}
2018.01.11 08:46:56 5: DbLog $name -> MemCache contains: $hash->{cache}{".memcache"}{$key}
2018.01.11 08:46:56 5: DbLog $name -> MemCache contains: $hash->{cache}{".memcache"}{$key}
2018.01.11 08:46:56 5: DbLog $name -> MemCache contains: $hash->{cache}{".memcache"}{$key}
2018.01.11 08:46:56 5: DbLog $name -> MemCache contains: $hash->{cache}{".memcache"}{$key}
2018.01.11 08:46:56 5: DbLog $name -> MemCache contains: $hash->{cache}{".memcache"}{$key}
2018.01.11 08:46:56 5: DbLog $name -> MemCache contains: $hash->{cache}{".memcache"}{$key}
2018.01.11 08:46:56 5: DbLog $name -> MemCache contains: $hash->{cache}{".memcache"}{$key}
Raspi2|nanoCul433|nanoCul868|CCU2
Energie-USBZähler|homebrew HM Devices
DBLog|DBRep|Homematic|Baumarktsteckdosen
Hue|Webcams mit DS-Station (Synology)|Bewegungsmelder|Rollladen|Schalter (IT|HM)