[comment]: # translation:outdated [comment]: # ({3d773959-d272fe28}) # 2 Problemes d'actualització relacionats amb l'escapada [comment]: # ({/3d773959-d272fe28}) [comment]: # ({bf624b11-ed744508}) #### Superar el límit de caràcters per als paràmetres de funció després de l'actualització S'ha afegit l'escapament adequat de les barres invertides als paràmetres de la cadena de funció d'historial a Zabbix 7.0. A mesura que s'afegeixen barres invertides addicionals durant l'actualització de les versions Zabbix anteriors a la 7.0, això comporta paràmetres més llargs que poden provocar que no funcionin algunes funcions de trigger si la longitud del paràmetre supera la mida màxima de dades de 255 caràcters. Per il·lustrar quins problemes poden sorgir durant l'actualització de la base de dades, quin és el seu impacte, com reconèixer-los i solucionar-los, prenguem un exemple de configuració amb 3 elements i 2 triggers. [comment]: # ({/bf624b11-ed744508}) [comment]: # ({24e29cd1-574618a7}) ##### Configuració 1) Versió 6.0 de Zabbix. 2) Fitxer "/tmp/ONE" que conté 114 barres invertides amb "a" al final: ```bash \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ ``` 3) Un element `vfs.file.contents[/tmp/ONE]` per llegir /tmp/ONE. 4) Dos elements calculats: **Calc_228** - el seu paràmetre conté 228 barres invertides al seu paràmetre, que s'escapaven, de manera que **coincideixen** amb les 114 barres invertides del fitxer /tmp/ONE: ```bash find(/Zabbix server/vfs.file.contents[/tmp/ONE],1m:now,"regexp","\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ a") ``` **Calc_232** - el seu paràmetre conté 232 barres invertides en el seu paràmetre, que s'escapa, de manera que **no coincideixen** amb les 114 barres invertides del fitxer /tmp/ONE, ja que necessiten almenys 116 barres invertides reals: ```bash find(/Zabbix server/vfs.file.contents[/tmp/ONE],1m:now,"regexp","\\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ a") ``` 5) Dos triggers: **Trig_228** - de manera similar a Calc_228, el seu paràmetre conté 228 barres invertides per **coincidir** amb 114 barres invertides reals del fitxer /tmp/ONE: ```bash find(/Zabbix server/vfs.file.contents[/tmp/ONE],1m:now,"regexp","\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ a") ``` **Trig_232** - de manera similar a Calc_232, el seu paràmetre conté 232 barres invertides per fer coincidir 116 barres invertides reals, de manera que **no coincideix** amb les 114 barres invertides del fitxer /tmp/ONE: ```bash find(/Zabbix server/vfs.file.contents[/tmp/ONE],1h:now,"regexp","\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ a") ``` 6) Calc_228 retorna 1 i Trig_228 **es dispara**. 7) Calc_232 retorna 0 i Trig_232 **no es** dispara. [comment]: # ({/24e29cd1-574618a7}) [comment]: # ({62d7ed5a-8687eae0}) ##### Actualització 1) Executeu l'actualització a 7.4.0 (o posterior), revisant els registres per les alertes: ```bash 2485502:20250228:115442.236 DBpatch_6050165(): no es pot pas desar al paràmetre de la funció DB: la mida resultant 477 és superior al màxim 255. functionid:33792 función:'find' emprada a l'equip: 'Zabbix server' al trigger: 'TRIG_228'. Valor del paràmetre actual: '$,1m:now,"regexp","\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\a"' El valor resultant de l'escapada hauria d'ésser: '$,1m:now,"regexp","\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\a" L'actualització de la base de dades i el servidor Zabbix es poden continuar executant, però per assegurar-vos que aquesta funció funcioni correctament CAL INTERVENCIÓ MANUAL! Cal reduir manualment la mida d'aquest paràmetre amb una macro com a solució alternativa. 2485502:20250228:115442.237 DBpatch_6050165(): no es pot pas desar al paràmetre de la funció DB: la mida resultant 485 és superior al màxim 255. functionid:33795 funció:'find' emprada a l'equip: 'Zabbix server' al trigger: 'TRIG_232'. Valor del paràmetre actual: '$,1m:now,"regexp","\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\a"' El valor resultant de l'escapada hauria d'ésser: '$,1m:now,"regexp","\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\a" L'actualització de la base de dades i el servidor Zabbix es poden continuar executant, però per assegurar-vos que aquesta funció funcioni correctament CAL INTERVENCIÓ MANUAL! Cal reduir manualment la mida d'aquest paràmetre amb una macro com a solució alternativa. ``` 2) L'actualització de la base de dades **acaba** i el servidor Zabbix segueix engegat. 3) Calc_228 encara retorna 1 mentre Calc_232 retorna 0. 4) Els triggers s'actualitzen tal com aquí: **Trig_228**: ```bash find(/Zabbix server/vfs.file.contents[/tmp/ONE],1m:now,"regexp","\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\a") ``` **Trig_232**: ```bash find(/Zabbix server/vfs.file.contents[/tmp/ONE],1m:now,"regexp","\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\a") ``` Ambdós triggers - Trig_228 and Trig_232 **es disparen**! Això no era previst; per tant, cal fer una intervenció manual. [comment]: # ({/62d7ed5a-8687eae0}) [comment]: # ({66c3ceb9-0eda1446}) ##### Intervenció manual Les expressions trigger s'han d'actualitzar perquè les barres invertides s'escapin, però això no es pot fer, perquè els paràmetres resultants serien massa llargs. És per això que cal afegir macros: **{$228_BACKSLASHES_A}**: ```bash \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ ``` **{$232_BACKSLASHES_A}**: ```bash \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ a ``` i **actualitzar** expressions trigger per utilitzar-les: **Trig_228**: ```bash find(/Zabbix server/vfs.file.contents[/tmp/ONE],1m:now,"regexp",{$228_BACKSLASHES_A}) ``` **Trig_232**: ```bash find(/Zabbix server/vfs.file.contents[/tmp/ONE],1m:now,"regexp",{$232_BACKSLASHES_A}) ``` Ara tots dos triggers funcionen de la mateixa manera que abans: només Trig_228 s'**activa**. No hi ha problemes amb els elements calculats, però també es podrien actualitzar per coherència: **Calc_228**: ```bash find(/Zabbix server/vfs.file.contents[/tmp/ONE],1m:now,"regexp",{$228_BACKSLASHES_A}) ``` **Calc_232**: ```bash find(/Zabbix server/vfs.file.contents[/tmp/ONE],1m:now,"regexp",{$232_BACKSLASHES_A}) ``` [comment]: # ({/66c3ceb9-0eda1446})