Servers stopped replicaton after Ispconfig update

I understand now
There are two errors in mail
1/ WARNING - Falsche Anfrage - just warning, it cannot write to cliensts table,
have seen it before
xx.xxx.xxx - 27.11.2023-14:10 - WARNING - Falsche Anfrage / Wrong QuerySQL-Query = REPLACE INTO `client`

but the problem is
2/ ERROR - Replication of datalog_id:..
- 27.11.2023-14:10 - ERROR - Replication of datalog_id: 358101 failed. Error: (client) in MySQL server: (localhost) Data truncated for column 'locked' at row 1 # SQL: REPLACE INTO ?? (??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

 

Love you Till !

2000 chnanges written.
but i staill have 806 changes left.
https://mixx.org/foto/ispc/posun.png
i have been editing user database manually adding those locked missing values before, hope it didnt break anything

CAN WAITING CHANGES BE DELETED ?

Is there some more detailed log, why is DNS stucked for example ?
Master server is DNS server, which is weird....

Probably stucked on datalog_status_u_client, do not know what with those

Got los of warnings
Mon Nov 27 05:30:02 PM CET 2023 PHP Warning: Undefined variable $state_out in /usr/local/ispconfig/server/lib/classes/plugins.inc.php on line 173
Mon Nov 27 05:30:02 PM CET 2023 finished server.php.
Mon Nov 27 05:30:02 PM CET 2023 PHP Warning: Undefined array key "db_flags" in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 671
Mon Nov 27 05:30:04 PM CET 2023 PHP Warning: Undefined array key 1 in /usr/local/ispconfig/server/lib/classes/cron.d/100-monitor_mem_usage.inc.php on line 79
Mon Nov 27 05:30:04 PM CET 2023 PHP Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /usr/local/ispconfig/server/lib/classes/cron.d/100-monitor_mem_usage.inc.php on line 79
Mon Nov 27 05:31:01 PM CET 2023 PHP Warning: Undefined variable $state_out in /usr/local/ispconfig/server/lib/classes/plugins.inc.php on line 173
Mon Nov 27 05:31:01 PM CET 2023 finished server.php.
Mon Nov 27 05:32:01 PM CET 2023 PHP Warning: Undefined variable $state_out in /usr/local/ispconfig/server/lib/classes/plugins.inc.php on line 173
Mon Nov 27 05:32:01 PM CET 2023 finished server.php.
Mon Nov 27 05:33:01 PM CET 2023 PHP Warning: Undefined variable $state_out in /usr/local/ispconfig/server/lib/classes/plugins.inc.php on line 173
Mon Nov 27 05:33:01 PM CET 2023 finished server.php.
Mon Nov 27 05:34:01 PM CET 2023 PHP Warning: Undefined variable $state_out in /usr/local/ispconfig/server/lib/classes/plugins.inc.php on line 173
Mon Nov 27 05:34:01 PM CET 2023 finished server.php.
Mon Nov 27 05:35:01 PM CET 2023 PHP Warning: Undefined variable $state_out in /usr/local/ispconfig/server/lib/classes/plugins.inc.php on line 173
Mon Nov 27 05:35:01 PM CET 2023 finished server.php.
Mon Nov 27 05:35:01 PM CET 2023 PHP Warning: Undefined array key "db_flags" in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 671
Mon Nov 27 05:35:04 PM CET 2023 PHP Warning: Undefined array key 1 in /usr/local/ispconfig/server/lib/classes/cron.d/100-monitor_mem_usage.inc.php on line 79
Mon Nov 27 05:35:04 PM CET 2023 PHP Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /usr/local/ispconfig/server/lib/classes/cron.d/100-monitor_mem_usage.inc.php on line 79
Mon Nov 27 05:36:01 PM CET 2023 PHP Warning: Undefined variable $state_out in /usr/local/ispconfig/server/lib/classes/plugins.inc.php on line 173
Mon Nov 27 05:36:01 PM CET 2023 finished server.php.
Mon Nov 27 05:37:02 PM CET 2023 PHP Warning: Undefined variable $state_out in /usr/local/ispconfig/server/lib/classes/plugins.inc.php on line 173
Mon Nov 27 05:37:02 PM CET 2023 finished server.php.
Mon Nov 27 05:38:01 PM CET 2023 PHP Warning: Undefined variable $state_out in /usr/local/ispconfig/server/lib/classes/plugins.inc.php on line 173
Mon Nov 27 05:38:01 PM CET 2023 finished server.php.

 

There is fatal error on master

27.11.2023-18:03 - DEBUG [plugins.inc:118] - Calling function 'webdav' from plugin 'apache2_plugin' raised by event 'webdav_user_update'.
PHP Warning: Trying to access array offset on value of type null in /usr/local/ispconfig/server/plugins-available/apache2_plugin.inc.php on line 2805
PHP Warning: Trying to access array offset on value of type null in /usr/local/ispconfig/server/plugins-available/apache2_plugin.inc.php on line 2806
PHP Warning: Trying to access array offset on value of type null in /usr/local/ispconfig/server/plugins-available/apache2_plugin.inc.php on line 2807
PHP Warning: Trying to access array offset on value of type null in /usr/local/ispconfig/server/plugins-available/apache2_plugin.inc.php on line 2808
PHP Deprecated: strlen(): Passing null to parameter #1 ($string) of type string is deprecated in /usr/local/ispconfig/server/plugins-available/apache2_plugin.inc.php on line 2826
PHP Warning: fopen(/etc/apache2/sites-available/.vhost): Failed to open stream: No such file or directory in /usr/local/ispconfig/server/plugins-available/apache2_plugin.inc.php on line 2982
PHP Fatal error: Uncaught TypeError: fgets(): Argument #1 ($stream) must be of type resource, bool given in /usr/local/ispconfig/server/plugins-available/apache2_plugin.inc.php:2989
Stack trace:
#0 /usr/local/ispconfig/server/plugins-available/apache2_plugin.inc.php(2989): fgets()
#1 /usr/local/ispconfig/server/plugins-available/apache2_plugin.inc.php(2870): apache2_plugin->_patchVhostWebdav()
#2 /usr/local/ispconfig/server/lib/classes/plugins.inc.php(120): apache2_plugin->webdav()
#3 /usr/local/ispconfig/server/mods-available/web_module.inc.php(156): plugins->raiseEvent()
#4 /usr/local/ispconfig/server/lib/classes/modules.inc.php(302): web_module->process()
#5 /usr/local/ispconfig/server/lib/classes/modules.inc.php(235): modules->raiseTableHook()
#6 /usr/local/ispconfig/server/server.php(180): modules->processDatalog()

 

Skipped waiting chnanges on master server in datalog as in dbispconfig->server->updated, investigating further...
Till, can datalog table be trimmed a bit ? there is 20k lines...

It seems there is lot of garbage in the cluster after 14 or how much years of updating )

 

Everything works now, you saved my day !
Thank you once more !

 

weird, there is no web_domain where server_id = 1