Hello there and thank you for your reply.
I can't see anything in the mariadb.log File that would reference to the behaviour I'm experiencing. I have also set debug_level to 1 and debug_verbosity to 2. I looked through the logfile (ndo2db.log) but I understand too little to see anything related to the problems I'm having. I don't see any strange characters like in the databse though.
Here's a snippet of the ndo2db.log file.
I have also attached the mariadb logfile.
I accidentally set debug_level to 1, not -1 as you suggested. Now it is on -1 and here's some of the output of ndo2db.log
Code: Select all
213:
1=1202
2=0
3=0
4=1544189928.512939
53=servername2
114=Memory Usage
95=Memory usage: total:7167.61 MB - used: 2977.62 MB (42%) - f
[1544189928.513850] [001.2] [pid=30772] Handling: 86=5.00000
[1544189928.513860] [001.2] [pid=30772] Handling: 109=1.00000
[1544189928.513871] [001.2] [pid=30772] Handling: 209=24x7
[1544189928.513885] [001.2] [pid=30772] Handling: 999
[1544189928.513929] [002.0] [pid=30772] INSERT INTO nagios_servicestatus SET instance_id='1', service_object_id='37818', status_update_time=FROM_UNIXTIME(1544189928), output='Memory usage: total:7167\.61 MB - used: 2977\.62 MB \(42%\) - free: 4189\.99 MB \(58%\)', long_output='', perfdata='\'Memory usage\'=2977\.62MB;6737\.56;6880\.91;0\.00;7167\.61', current_state='0', has_been_checked='1', should_be_scheduled='1', current_check_attempt='1', max_check_attempts='3', last_check=FROM_UNIXTIME(1544189928), next_check=FROM_UNIXTIME(1544190228), check_type='0', last_state_change=FROM_UNIXTIME(1543231283), last_hard_state_change=FROM_UNIXTIME(1542968726), last_hard_state='0', last_time_ok=FROM_UNIXTIME(1544189928), last_time_warning=FROM_UNIXTIME(0), last_time_unknown=FROM_UNIXTIME(0), last_time_critical=FROM_UNIXTIME(1543231283), state_type='1', last_notification=FROM_UNIXTIME(0), next_notification=FROM_UNIXTIME(0), no_more_notifications='0', notifications_enabled='1', problem_has_been_acknowledged='0', acknowledgement_type='0', current_notification_number='0', passive_checks_enabled='1', active_checks_enabled='1', event_handler_enabled='1', flap_detection_enabled='1', is_flapping='0', percent_state_change='0.000000', latency='0.000000', execution_time='0.004050', scheduled_downtime_depth='0', failure_prediction_enabled='0', process_performance_data='1', obsess_over_service='1', modified_service_attributes='0', event_handler='', check_command='check_nt!MEMUSE!-w 94 -c 96', normal_check_interval='5.000000', retry_check_interval='1.000000', check_timeperiod_object_id='2' ON DUPLICATE KEY UPDATE instance_id='1', service_object_id='37818', status_update_time=FROM_UNIXTIME(1544189928), output='Memory usage: total:7167\.61 MB - used: 2977\.62 MB \(42%\) - free: 4189\.99 MB \(58%\)', long_output='', perfdata='\'Memory usage\'=2977\.62MB;6737\.56;6880\.91;0\.00;7167\.61', current_state='0', has_been_checked='1', should_be_scheduled='1', current_check_attempt='1', max_check_attempts='3', last_check=FROM_UNIXTIME(1544189928), next_check=FROM_UNIXTIME(1544190228), check_type='0', last_state_change=FROM_UNIXTIME(1543231283), last_hard_state_change=FROM_UNIXTIME(1542968726), last_hard_state='0', last_time_ok=FROM_UNIXTIME(1544189928), last_time_warning=FROM_UNIXTIME(0), last_time_unknown=FROM_UNIXTIME(0), last_time_critical=FROM_UNIXTIME(1543231283), state_type='1', last_notification=FROM_UNIXTIME(0), next_notification=FROM_UNIXTIME(0), no_more_notifications='0', notifications_enabled='1', problem_has_been_acknowledged='0', acknowledgement_type='0', current_notification_number='0', passive_checks_enabled='1', active_checks_enabled='1', event_handler_enabled='1', flap_detection_enabled='1', is_flapping='0', percent_state_change='0.000000', latency='0.000000', execution_time='0.004050', scheduled_downtime_depth='0', failure_prediction_enabled='0', process_performance_data='1', obsess_over_service='1', modified_service_attributes='0', event_handler='', check_command='check_nt!MEMUSE!-w 94 -c 96', normal_check_interval='5.000000', retry_check_interval='1.000000', check_timeperiod_object_id='2'
[1544189928.514905] [001.2] [pid=30772] Handling:
[1544189928.514925] [001.2] [pid=30772] Handling:
[1544189928.514937] [001.2] [pid=30772] Handling: 206:
[1544189928.514949] [001.2] [pid=30772] Handling: 1=701
[1544189928.514960] [001.2] [pid=30772] Handling: 2=0
[1544189928.514972] [001.2] [pid=30772] Handling: 3=0
[1544189928.514983] [001.2] [pid=30772] Handling: 4=1544189928.512926
[1544189928.515016] [001.2] [pid=30772] Handling: 53=servername2
[1544189928.515031] [001.2] [pid=30772] Handling: 114=Memory Usage
[1544189928.515043] [001.2] [pid=30772] Handling: 12=0
[1544189928.515054] [001.2] [pid=30772] Handling: 25=1
[1544189928.515065] [001.2] [pid=30772] Handling: 76=3
[1544189928.515076] [001.2] [pid=30772] Handling: 121=1
[1544189928.515087] [001.2] [pid=30772] Handling: 118=0
[1544189928.515098] [001.2] [pid=30772] Handling: 123=360
[1544189928.515109] [001.2] [pid=30772] Handling: 127=
[1544189928.515120] [001.2] [pid=30772] Handling: 13=
[1544189928.515156] [001.2] [pid=30772] Handling: 14=
[1544189928.515168] [001.2] [pid=30772] Handling: 117=1544189928.508743
[1544189928.515180] [001.2] [pid=30772] Handling: 33=1544189928.512794
[1544189928.515191] [001.2] [pid=30772] Handling: 32=0
[1544189928.515207] [001.2] [pid=30772] Handling: 42=0.00405
[1544189928.515224] [001.2] [pid=30772] Handling: 71=0.00000
[1544189928.515235] [001.2] [pid=30772] Handling: 110=0
[1544189928.515246] [001.2] [pid=30772] Handling: 95=Memory usage: total:7167.61 MB - used: 2977.62 MB (42%) - free: 4189.99 MB (58%)
[1544189928.515258] [001.2] [pid=30772] Handling: 125=
[1544189928.515269] [001.2] [pid=30772] Handling: 99='Memory usage'=2977.62MB;6737.56;6880.91;0.00;7167.61
[1544189928.515280] [001.2] [pid=30772] Handling: 999
[1544189928.515305] [002.0] [pid=30772] INSERT INTO nagios_servicechecks SET instance_id='1', service_object_id='37818', check_type='0', current_check_attempt='1', max_check_attempts='3', state='0', state_type='1', start_time=FROM_UNIXTIME(1544189928), start_time_usec='508743', end_time=FROM_UNIXTIME(1544189928), end_time_usec='512794', timeout='360', early_timeout='0', execution_time='0.004050', latency='0.000000', return_code='0', output='Memory usage: total:7167\.61 MB - used: 2977\.62 MB \(42%\) - free: 4189\.99 MB \(58%\)', long_output='', perfdata='\'Memory usage\'=2977\.62MB;6737\.56;6880\.91;0\.00;7167\.61', command_object_id='0', command_args='', command_line='' ON DUPLICATE KEY UPDATE instance_id='1', service_object_id='37818', check_type='0', current_check_attempt='1', max_check_attempts='3', state='0', state_type='1', start_time=FROM_UNIXTIME(1544189928), start_time_usec='508743', end_time=FROM_UNIXTIME(1544189928), end_time_usec='512794', timeout='360', early_timeout='0', execution_time='0.004050', latency='0.000000', return_code='0', output='Memory usage: total:7167\.61 MB - used: 2977\.62 MB \(42%\) - free: 4189\.99 MB \(58%\)', long_output='', perfdata='\'Memory usage\'=2977\.62MB;6737\.56;6880\.91;0\.00;7167\.61'
[1544189928.515913] [001.2] [pid=30772] Handling:
[1544189928.515937] [001.2] [pid=30772] Handling:
[1544189928.515948] [001.2] [pid=30772] Handling: 213:
[1544189928.515961] [001.2] [pid=30772] Handling: 1=1202
[1544189928.515972] [001.2] [pid=30772] Handling: 2=0
[1544189928.515984] [001.2] [pid=30772] Handling: 3=0
[1544189928.515995] [001.2] [pid=30772] Handling: 4=1544189928.512939
[1544189928.516006] [001.2] [pid=30772] Handling: 53=servername2
[1544189928.516043] [001.2] [pid=30772] Handling: 114=Memory Usage
[1544189928.516060] [001.2] [pid=30772] Queue Message: ree: 4189.99 MB (58%)
125=
99='Memory usage'=2977.62MB;6737.56;6880.91;0.00;7167.61
27=0
51=1
115=1
25=1
76=3
61=1544189928
83=1544190228
12=0
63=1543231283
57=1542968726
56=0
66=1544189928
70=0
67=0
64=1543231283
121=1
62=0
84=0
85=0
88=1
101=0
7=0
26=0
97=1
38=1
9=1
47=1
54=0
98=0.00000
71=0.00000
42=0.00405
113=0
45=0
103=1
93=1
80=0
37=
11=check_nt!MEMUSE!-w 94 -c 96
86=5.00000
109=1.00000
209=24x7
999
[1544189928.516070] [001.2] [pid=30772] Handling: 95=Memory usage: total:7167.61 MB - used: 2977.62 MB (42%) - free: 4189.99 MB (58%)
[1544189928.516081] [001.2] [pid=30772] Handling: 125=
[1544189928.516092] [001.2] [pid=30772] Handling: 99='Memory usage'=2977.62MB;6737.56;6880.91;0.00;7167.61
[1544189928.516104] [001.2] [pid=30772] Handling: 27=0
[1544189928.516115] [001.2] [pid=30772] Handling: 51=1
[1544189928.516125] [001.2] [pid=30772] Handling: 115=1
[1544189928.516136] [001.2] [pid=30772] Handling: 25=1
[1544189928.516147] [001.2] [pid=30772] Handling: 76=3
[1544189928.516158] [001.2] [pid=30772] Handling: 61=1544189928
[1544189928.516169] [001.2] [pid=30772] Handling: 83=1544190228
[1544189928.516180] [001.2] [pid=30772] Handling: 12=0
[1544189928.516190] [001.2] [pid=30772] Handling: 63=1543231283
[1544189928.516201] [001.2] [pid=30772] Handling: 57=1542968726
[1544189928.516212] [001.2] [pid=30772] Handling: 56=0
[1544189928.516223] [001.2] [pid=30772] Handling: 66=1544189928
[1544189928.516256] [001.2] [pid=30772] Handling: 70=0
[1544189928.516269] [001.2] [pid=30772] Handling: 67=0
[1544189928.516280] [001.2] [pid=30772] Handling: 64=1543231283
[1544189928.516291] [001.2] [pid=30772] Handling: 121=1
[1544189928.516302] [001.2] [pid=30772] Handling: 62=0
[1544189928.516320] [001.2] [pid=30772] Handling: 84=0
[1544189928.516332] [001.2] [pid=30772] Handling: 85=0
[1544189928.516344] [001.2] [pid=30772] Handling: 88=1
[1544189928.516355] [001.2] [pid=30772] Handling: 101=0
[1544189928.516365] [001.2] [pid=30772] Handling: 7=0
[1544189928.516377] [001.2] [pid=30772] Handling: 26=0
[1544189928.516403] [001.2] [pid=30772] Handling: 97=1
[1544189928.516424] [001.2] [pid=30772] Handling: 38=1
[1544189928.516435] [001.2] [pid=30772] Handling: 9=1
[1544189928.516447] [001.2] [pid=30772] Handling: 47=1
[1544189928.516457] [001.2] [pid=30772] Handling: 54=0
[1544189928.516522] [001.2] [pid=30772] Handling: 98=0.00000
[1544189928.516536] [001.2] [pid=30772] Handling: 71=0.00000
[1544189928.516547] [001.2] [pid=30772] Handling: 42=0.00405
[1544189928.516558] [001.2] [pid=30772] Handling: 113=0
[1544189928.516568] [001.2] [pid=30772] Handling: 45=0
[1544189928.516579] [001.2] [pid=30772] Handling: 103=1
[1544189928.516590] [001.2] [pid=30772] Handling: 93=1
[1544189928.516601] [001.2] [pid=30772] Handling: 80=0
[1544189928.516611] [001.2] [pid=30772] Handling: 37=
[1544189928.516639] [001.2] [pid=30772] Handling: 11=check_nt!MEMUSE!-w 94 -c 96
[1544189928.516654] [001.2] [pid=30772] Handling: 86=5.00000
[1544189928.516673] [001.2] [pid=30772] Handling: 109=1.00000
[1544189928.516685] [001.2] [pid=30772] Handling: 209=24x7
[1544189928.516696] [001.2] [pid=30772] Handling: 999
[1544189928.516729] [002.0] [pid=30772] INSERT INTO nagios_servicestatus SET instance_id='1', service_object_id='37818', status_update_time=FROM_UNIXTIME(1544189928), output='Memory usage: total:7167\.61 MB - used: 2977\.62 MB \(42%\) - free: 4189\.99 MB \(58%\)', long_output='', perfdata='\'Memory usage\'=2977\.62MB;6737\.56;6880\.91;0\.00;7167\.61', current_state='0', has_been_checked='1', should_be_scheduled='1', current_check_attempt='1', max_check_attempts='3', last_check=FROM_UNIXTIME(1544189928), next_check=FROM_UNIXTIME(1544190228), check_type='0', last_state_change=FROM_UNIXTIME(1543231283), last_hard_state_change=FROM_UNIXTIME(1542968726), last_hard_state='0', last_time_ok=FROM_UNIXTIME(1544189928), last_time_warning=FROM_UNIXTIME(0), last_time_unknown=FROM_UNIXTIME(0), last_time_critical=FROM_UNIXTIME(1543231283), state_type='1', last_notification=FROM_UNIXTIME(0), next_notification=FROM_UNIXTIME(0), no_more_notifications='0', notifications_enabled='1', problem_has_been_acknowledged='0', acknowledgement_type='0', current_notification_number='0', passive_checks_enabled='1', active_checks_enabled='1', event_handler_enabled='1', flap_detection_enabled='1', is_flapping='0', percent_state_change='0.000000', latency='0.000000', execution_time='0.004050', scheduled_downtime_depth='0', failure_prediction_enabled='0', process_performance_data='1', obsess_over_service='1', modified_service_attributes='0', event_handler='', check_command='check_nt!MEMUSE!-w 94 -c 96', normal_check_interval='5.000000', retry_check_interval='1.000000', check_timeperiod_object_id='2' ON DUPLICATE KEY UPDATE instance_id='1', service_object_id='37818', status_update_time=FROM_UNIXTIME(1544189928), output='Memory usage: total:7167\.61 MB - used: 2977\.62 MB \(42%\) - free: 4189\.99 MB \(58%\)', long_output='', perfdata='\'Memory usage\'=2977\.62MB;6737\.56;6880\.91;0\.00;7167\.61', current_state='0', has_been_checked='1', should_be_scheduled='1', current_check_attempt='1', max_check_attempts='3', last_check=FROM_UNIXTIME(1544189928), next_check=FROM_UNIXTIME(1544190228), check_type='0', last_state_change=FROM_UNIXTIME(1543231283), last_hard_state_change=FROM_UNIXTIME(1542968726), last_hard_state='0', last_time_ok=FROM_UNIXTIME(1544189928), last_time_warning=FROM_UNIXTIME(0), last_time_unknown=FROM_UNIXTIME(0), last_time_critical=FROM_UNIXTIME(1543231283), state_type='1', last_notification=FROM_UNIXTIME(0), next_notification=FROM_UNIXTIME(0), no_more_notifications='0', notifications_enabled='1', problem_has_been_acknowledged='0', acknowledgement_type='0', current_notification_number='0', passive_checks_enabled='1', active_checks_enabled='1', event_handler_enabled='1', flap_detection_enabled='1', is_flapping='0', percent_state_change='0.000000', latency='0.000000', execution_time='0.004050', scheduled_downtime_depth='0', failure_prediction_enabled='0', process_performance_data='1', obsess_over_service='1', modified_service_attributes='0', event_handler='', check_command='check_nt!MEMUSE!-w 94 -c 96', normal_check_interval='5.000000', retry_check_interval='1.000000', check_timeperiod_object_id='2'
[1544189928.517366] [001.2] [pid=30772] Handling: