[#ZBX-23866] zabbix search not work ,search host name not found

Comment by Edgar Akhmetshin [ 2023 Dec 20 ]

Show out put from:

SELECT
    trigger_schema,
    trigger_name,
    event_manipulation,
    action_statement
FROM information_schema.triggers;

select * from changelog order by changelogid desc limit 10;

Also provide information about Zabbix version used.

Comment by xiaobin [ 2023 Dec 20 ]

mysql> SELECT
    ->     trigger_schema,
    ->     trigger_name,
    ->     event_manipulation,
    ->     action_statement
    -> FROM information_schema.triggers;
+----------------+----------------------------+--------------------+-----------------------------------------------------------------------------------------------------------------------------------+
| TRIGGER_SCHEMA | TRIGGER_NAME               | EVENT_MANIPULATION | ACTION_STATEMENT                                                                                                                  |
+----------------+----------------------------+--------------------+-----------------------------------------------------------------------------------------------------------------------------------+
| sys            | sys_config_insert_set_user | INSERT             | BEGIN
    IF @sys.ignore_sys_config_triggers != true AND NEW.set_by IS NULL THEN
        SET NEW.set_by = USER();
    END IF;
END |
| sys            | sys_config_update_set_user | UPDATE             | BEGIN
    IF @sys.ignore_sys_config_triggers != true AND NEW.set_by IS NULL THEN
        SET NEW.set_by = USER();
    END IF;
END |
+----------------+----------------------------+--------------------+-----------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

mysql> select * from changelog order by changelogid desc limit 10;
ERROR 1046 (3D000): No database selected
mysql>

Comment by Edgar Akhmetshin [ 2023 Dec 21 ]

You need to execute this SQL from the zabbix database.

Comment by xiaobin [ 2023 Dec 21 ]

mysql> use zabbix ;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> SELECT
    ->     trigger_schema,
    ->     trigger_name,
    ->     event_manipulation,
    ->     action_statement
    -> FROM information_schema.triggers;
+----------------+----------------------------+--------------------+-----------------------------------------------------------------------------------------------------------------------------------+
| TRIGGER_SCHEMA | TRIGGER_NAME               | EVENT_MANIPULATION | ACTION_STATEMENT                                                                                                                  |
+----------------+----------------------------+--------------------+-----------------------------------------------------------------------------------------------------------------------------------+
| sys            | sys_config_insert_set_user | INSERT             | BEGIN
    IF @sys.ignore_sys_config_triggers != true AND NEW.set_by IS NULL THEN
        SET NEW.set_by = USER();
    END IF;
END |
| sys            | sys_config_update_set_user | UPDATE             | BEGIN
    IF @sys.ignore_sys_config_triggers != true AND NEW.set_by IS NULL THEN
        SET NEW.set_by = USER();
    END IF;
END |
+----------------+----------------------------+--------------------+-----------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

mysql> select * from changelog order by changelogid desc limit 10;
Empty set (0.00 sec)

mysql>

Comment by Edgar Akhmetshin [ 2023 Dec 22 ]

Duplicate issue: https://support.zabbix.com/browse/ZBX-22948

You need to fix the database schema.

Please be advised that this section of the tracker is for bug reports only. The case you have submitted can not be qualified as one, so please reach out to [email protected] for commercial support (https://zabbix.com/support) or consultancy services. Alternatively, you can also use our community channels (https://www.zabbix.com/community) for assistance. With that said, we are closing this ticket. Thank you for understanding.

Comment by xiaobin [ 2023 Dec 25 ]

it's been solved。thanks。

[ZBX-23866] zabbix search not work ,search host name not found Created: 2023 Dec 19 Updated: 2023 Dec 25 Resolved: 2023 Dec 22
Status:	Closed
Project:	ZABBIX BUGS AND ISSUES
Component/s:	None
Affects Version/s:	None
Fix Version/s:	None

[ZBX-23866] zabbix search not work ,search host name not found Created: 2023 Dec 19 Updated: 2023 Dec 25 Resolved: 2023 Dec 22