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

[Bug] java.sql.SQLSyntaxErrorException: Table 'streamx.t_setting' doesn't exist #569

Closed
edwardhuanghz opened this issue Dec 30, 2021 · 2 comments
Labels
bug Something isn't working

Comments

@edwardhuanghz
Copy link

请在提交你的 issue 前,请回答以下问题,这有助于社区快速定位问题,谢谢! 🙏

Environment Description(运行环境描述)

Bug Description(Bug 描述)

请简要、清晰地对您遇到的 Bug 进行描述。
执行/opt/streamx/streamx-console-service-1.2.1/bin/startup.sh 初始化安装报错
报错如下
Caused by: org.springframework.jdbc.BadSqlGrammarException:

Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table 'streamx.t_setting' doesn't exist

The error may exist in com/streamxhub/streamx/console/core/dao/SettingMapper.java (best guess)

The error may involve defaultParameterMap

The error occurred while setting parameters

SQL: SELECT NUM,TITLE,key,value,type,description FROM t_setting

Cause: java.sql.SQLSyntaxErrorException: Table 'streamx.t_setting' doesn't exist

How to Reproduce(如何重现这个 Bug)

1.更改/conf/application.yml配置文件
2.修改hadoop env参数
export HADOOP_HOME=/opt/cloudera/parcels/CDH-6.3.2-1.cdh6.3.2.p0.1605554/lib/hadoop
export HADOOP_CONF_DIR=/etc/hadoop/conf
export HIVE_CONF_DIR=/etc/hive/conf

3.执行startup.sh报错

Additional context(额外的上下文信息)

添加额外有助于描述该问题的上下文信息,如 JVM 堆栈日志等

Requirement or improvement(诉求 & 改进建议)

版本的文档希望更新下,谢谢~

@edwardhuanghz edwardhuanghz added the bug Something isn't working label Dec 30, 2021
@xinzhuxiansheng
Copy link
Contributor

@edwardhuanghz Please refer to FAQ doc #507

@edwardhuanghz
Copy link
Author

thankyou verymuch

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants