yokonsan opened a new issue, #30892:
URL: https://github.com/apache/superset/issues/30892
### Bug description
I use `Superset meta database` to query PostgreSQL and MySQL at the same
time. When querying MySQL data, some tables can be queried normally, but some
tables query errors:
```
superset.exceptions.SupersetErrorsException:
[SupersetError(message='superset error: ',
error_type=<SupersetErrorType.GENERIC_DB_ENGINE_ERROR:
'GENERIC_DB_ENGINE_ERROR'>, level=<ErrorLevel.ERROR: 'error'>,
extra={'engine_name': 'Superset meta database', 'issue_codes': [{'code': 1002,
'message': 'Issue 1002 - The database returned an unexpected error.'}]})]
```
Query the table structure of the error:
```sql
create table member
(
id bigint auto_increment
primary key,
create_time datetime(6) null,
deleted tinyint default 0 null,
update_time datetime(6) null,
tenant_id bigint null,
appeal_success_times int null,
appeal_times int null,
application_time datetime(6) null,
avatar varchar(255) null,
certified_business_apply_time datetime(6) null,
certified_business_check_time datetime(6) null,
certified_business_status int null,
email varchar(255) null,
first_level int null,
google_date datetime(6) null,
google_key varchar(255) null,
google_state int null,
id_number varchar(255) null,
internal bit null,
inviter_id bigint null,
jy_password varchar(255) null,
last_login_time datetime(6) null,
local_currency varchar(255) null,
city varchar(255) null,
country varchar(255) null,
district varchar(255) null,
province varchar(255) null,
login_count int null,
margin varchar(255) null,
member_level int null,
mobile_phone varchar(255) null,
password varchar(255) null,
phone varchar(255) null,
phone_code int null,
promotion_code varchar(255) null,
publish_advertise int null,
first_name varchar(255) null,
last_name varchar(255) null,
real_name varchar(255) null,
real_name_status int null,
registration_time datetime(6) null,
salt varchar(255) null,
second_level int null,
sign_in_ability bit default b'1' null,
status int null,
super_partner varchar(255) null,
third_level int null,
token varchar(255) null,
token_expire_time datetime(6) null,
transaction_status int null,
transactions int null,
type int null,
username varchar(255) null,
google_authenticator_bound bit null,
language varchar(255) null',
register_ip varchar(255) null,
register_mode int null,
secret_key varchar(255) null,
timezone varchar(255) null,
unique_id varchar(255) null,
local varchar(255) null,
org_auth bit null,
bio varchar(500) null,
profile_banner varchar(255) null,
constraint UK5bscr8akoo83tvje9p7t188e7
unique (phone, tenant_id),
constraint UKb2lhprc78p74cd0byelf85gy2
unique (email, tenant_id),
constraint UKlf9h6mqwq16eiqntcmv0g4n7t
unique (username, tenant_id),
constraint UKo7vrewpy8cnap6i872t5nrtwi
unique (unique_id, tenant_id),
constraint FKbt72vgf5myy3uhygc90xna65j
foreign key (local) references country (en_name)
)
comment 'xxx' charset = utf8mb3;
```
### Screenshots/recordings
_No response_
### Superset version
4.0.2
### Python version
I don't know
### Node version
16
### Browser
Chrome
### Additional context
_No response_
### Checklist
- [X] I have searched Superset docs and Slack and didn't find a solution to
my problem.
- [X] I have searched the GitHub issue tracker and didn't find a similar bug
report.
- [X] I have checked Superset's logs for errors and if I found a relevant
Python stacktrace, I included it here as text in the "additional context"
section.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
