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

soar 无法使用,日志如下,请帮忙看下是否是配置问题,谢谢 #313

Open
LeiyuanBlog opened this issue Jul 20, 2023 · 0 comments

Comments

@LeiyuanBlog
Copy link

2023/07/20 17:14:20.408 [D] [mysql.go:92] Execute SQL with DSN(10.8.0.4:3306/sorttest) : select @@Version
2023/07/20 17:14:20.410 [D] [mysql.go:92] Execute SQL with DSN(eu-monoprix-all-database.mysql.database.azure.com:3306/poc_storedb_monoprix) : select @@Version
2023/07/20 17:14:20.458 [E] [mysql.go:95] dial tcp: lookup eu-monoprix-all-database.mysql.database.azure.com on 127.0.0.11:53: no such host
2023/07/20 17:14:20.458 [W] [mysql.go:132] (db *Connector) Version() Error: dial tcp: lookup eu-monoprix-all-database.mysql.database.azure.com on 127.0.0.11:53: no such host
2023/07/20 17:14:20.458 [W] [env.go:88] BuildEnv OnlineDSN: azureuser:********@eu-monoprix-all-database.mysql.database.azure.com:3306/poc_storedb_monoprix not available , Error: dial tcp: lookup eu-monoprix-all-database.mysql.database.azure.com on 127.0.0.11:53: no such host
2023/07/20 17:14:20.458 [W] [env.go:104] TestDSN MySQL version older than OnlineDSN(99999), TestDSN(50724) will not be used
2023/07/20 17:14:20.458 [D] [soar.go:127] main loop SQL: select * from hs_esl limit 100
2023/07/20 17:14:20.459 [D] [soar.go:203] start of heuristic advisor Query: select * from hs_esl limit 100
2023/07/20 17:14:20.469 [D] [meta.go:201] Enter: FindColumn, Caller: github.com/XiaoMi/soar/advisor.(*Query4Audit).RuleNoDeterministicGroupby.func1
2023/07/20 17:14:20.469 [D] [meta.go:201] Enter: FindColumn, Caller: github.com/XiaoMi/soar/advisor.(*Query4Audit).RuleNoDeterministicGroupby.func1
2023/07/20 17:14:20.469 [D] [soar.go:214] end of heuristic advisor Query: select * from hs_esl limit 100
2023/07/20 17:14:20.469 [D] [soar.go:220] start of index advisor Query: select * from hs_esl limit 100
2023/07/20 17:14:20.469 [D] [env.go:364] createDatabase, mapping poc_storedb_monoprix :poc_storedb_monoprix-->optimizer_230720171420_ippk2of6yovk0l2e
2023/07/20 17:14:20.469 [W] [env.go:367] createDatabase, rEnv.ShowCreateDatabase Error : dsn is disable
2023/07/20 17:14:20.469 [W] [env.go:377] createDatabase, Error : dsn is disable
2023/07/20 17:14:20.469 [W] [logger.go:122] [env.go:207] dsn is disable
2023/07/20 17:14:20.469 [I] [env.go:211] BuildVirtualEnv TestDSN not config
2023/07/20 17:14:20.469 [D] [index.go:90] Enter: NewAdvisor(), Caller: main.main
2023/07/20 17:14:20.469 [D] [soar.go:228] idxAdvisor by pass Query: select * from hs_esl limit 100
2023/07/20 17:14:20.469 [D] [soar.go:266] end of index advisor Query: select * from hs_esl limit 100
2023/07/20 17:14:20.469 [D] [soar.go:271] start of explain Query: select * from hs_esl limit 100
2023/07/20 17:14:20.469 [D] [soar.go:299] end of explain Query: select * from hs_esl limit 100
2023/07/20 17:14:20.469 [D] [soar.go:303] start of profiling Query: select * from hs_esl limit 100
2023/07/20 17:14:20.469 [D] [soar.go:316] end of profiling Query: select * from hs_esl limit 100
2023/07/20 17:14:20.469 [D] [soar.go:320] start of trace Query: select * from hs_esl limit 100
2023/07/20 17:14:20.469 [D] [soar.go:333] end of trace Query: select * from hs_esl limit 100
2023/07/20 17:14:20.469 [D] [soar.go:337] start of rewrite Query: select * from hs_esl limit 100
2023/07/20 17:14:20.469 [D] [soar.go:371] end of rewrite Query: select * from hs_esl limit 100
2023/07/20 17:14:20.469 [D] [soar.go:375] start of print suggestions, Query: select * from hs_esl limit 100
2023/07/20 17:14:20.469 [D] [rules.go:1198] FormatSuggest, Query: select * from hs_esl limit 100
2023/07/20 17:14:20.469 [D] [rules.go:1244] FormatSuggest, format: markdown
2023/07/20 17:14:20.469 [D] [pretty.go:31] Pretty, Query: select * from hs_esl limit 100, method: markdown
2023/07/20 17:14:20.471 [D] [rules.go:1291] FormatSuggest, start of sortedMySQLSuggest
2023/07/20 17:14:20.471 [D] [rules.go:1313] FormatSuggest, start of sortedExplainSuggest
2023/07/20 17:14:20.471 [D] [rules.go:1334] FormatSuggest, start of sortedProfilingSuggest
2023/07/20 17:14:20.471 [D] [rules.go:1351] FormatSuggest, start of sortedTraceSuggest
2023/07/20 17:14:20.471 [D] [rules.go:1368] FormatSuggest, start of sortedIdxSuggest
2023/07/20 17:14:20.471 [D] [rules.go:1397] FormatSuggest, start of sortedHeuristicSuggest
2023/07/20 17:14:20.471 [D] [soar.go:405] end of print suggestions, Query: select * from hs_esl limit 100
2023/07/20 17:14:20.471 [D] [soar.go:109] Ending, buf: '', sql: ''

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