@cloudcanal-万少 在 "远程执行SQL失败,请联系管理员。错误信息为:invoke rcontroller method failed.Request id:987bd641-b944-11ec-a34f-b1c790930547msg:SQLSyntaxErrorException: Unknown database 'default_cluster:lbs' 中说:
如果你对端没创建lbs库,应该会走结构迁移的,你这边没进行结构迁移么?表结构文本麻烦给下,我们这边可以试下。总结你的问题是PG->SR有库映射的时候无法正常映射 是么?
对的,问题是这个问题,表结构如下,库名lbs
CREATE TABLE public.th_task_business (
id varchar(32) NOT NULL,
vin varchar(17) NULL,
business_no varchar(32) NULL,
task_type varchar(5) NULL,
task_start_time timestamp NULL,
task_end_time timestamp NULL,
create_time timestamp NULL,
task_start_point varchar(500) NULL,
task_start_altitude float8 NULL,
task_end_point varchar(500) NULL,
task_end_altitude float8 NULL,
destination_position_id varchar(32) NULL,
destination_area_id varchar(32) NULL,
origin_position_id varchar(32) NULL,
origin_area_id varchar(32) NULL,
material_type varchar(5) NULL,
material_properties varchar(5) NULL,
receving_vin varchar(17) NULL,
task_state varchar(5) NULL,
CONSTRAINT th_task_business_pk PRIMARY KEY (id)
);
CREATE INDEX th_task_business_business_no_idx ON public.th_task_business USING btree (business_no, vin);