Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

无法同步视图 #1063

Open
linqh1 opened this issue Apr 24, 2022 · 0 comments
Open

无法同步视图 #1063

linqh1 opened this issue Apr 24, 2022 · 0 comments

Comments

@linqh1
Copy link

linqh1 commented Apr 24, 2022

经测试,4.2.17版本无法同步视图,但是在binlog中能看到视图相关的语句:

#220424  4:12:11 server id 1000  end_log_pos 219 CRC32 0xadba0f4f       Anonymous_GTID  last_committed=0        sequence_number=1       rbr_only=no
SET @@SESSION.GTID_NEXT= 'ANONYMOUS'/*!*/;
# at 219
#220424  4:12:11 server id 1000  end_log_pos 440 CRC32 0xce092339       Query   thread_id=2     exec_time=0     error_code=0
use `monitor`/*!*/;
SET TIMESTAMP=1650769931/*!*/;
SET @@session.pseudo_thread_id=2/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=1411383328/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C utf8 *//*!*/;
SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=33/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `alert_rule_view` AS select * from alert_rule
/*!*/;
# at 440
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant