Skip to content

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

@LeiyuanBlog

Description

@LeiyuanBlog

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: ''

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions