Troubleshooting ILIKE Query Error
TLDR Romario is having trouble using ILIKE with a variable in a query. Srikanth suggests checking the quotes, but the issue remains unresolved.
May 10, 2023 (7 months ago)
Romario
07:41 PM AND stringTagMap['service.name'] ilike '%{{.environment}}'
Romario
07:42 PM%production
the query worksMay 11, 2023 (7 months ago)
Srikanth
01:55 AMRomario
07:58 PMRomario
07:59 PMAND stringTagMap['service.name'] ilike %{{.environment}}
Error: API responded with 400 - encountered multiple errors: error in query-A: code: 62, message: Syntax error: failed at position 394 ('%') (line 8, col 46): %<no value> GROUP BY op_name, interval ORDER BY op_name ASC, interval. Expected one of: ANY, ALL, BETWEEN expression, string concatenation expression, list, delimited by operator of variable arity, additive expression, list, delimited by binary operators, INTERVAL operator expression, INTERVAL, TIMESTAMP operator expression, TIMESTAMP, DATE operator expression, DATE, multiplicative expression, unary expression, expression with prefix unary operator, NOT, CAST expression, tuple element expression, array element expression, element of expression, SELECT subquery, CAST operator, tuple, collection of literals, parenthesized expression, array, literal, NULL, number, Bool, true, false, string literal, case, CASE, COLUMNS matcher, COLUMNS, function, identifier, qualified asterisk, compound identifier, list of elements, asterisk, substitution, MySQL-style global variable
Romario
08:00 PMAND stringTagMap['service.name'] ilike '%{{.environment}}'
Error: API responded with 400 - encountered multiple errors: error in query-A: code: 62, message: Syntax error: failed at position 397 ('production') (line 8, col 49): production'' GROUP BY op_name, interval ORDER BY op_name ASC, interval. Expected one of: token, DoubleColon, MOD, DIV, NOT, BETWEEN, LIKE, ILIKE, NOT LIKE, NOT ILIKE, IN, NOT IN, GLOBAL IN, GLOBAL NOT IN, IS, AND, OR, QuestionMark, alias, AS, GROUP BY, WITH, HAVING, WINDOW, ORDER BY, LIMIT, OFFSET, SETTINGS, UNION, EXCEPT, INTERSECT, INTO OUTFILE, FORMAT, end of query
May 15, 2023 (7 months ago)
Romario
06:52 PMMay 16, 2023 (7 months ago)
Srikanth
07:37 AMSigNoz Community
Indexed 1023 threads (61% resolved)
Similar Threads
Customizing Signoz Error Alert Descriptions
Sumanth needed help with making Signoz error alert descriptions more descriptive. Amol suggested using {{.Labels.serviceName}} and discussed limitations of adding labels in queries.
Bug Identified in Exception Screen on Fresh Install
Romil found a bug on the exception screen during a fresh install. Pranay suggested creating an issue on GitHub and potentially sharing a fix.
Setting up Alerts Not Triggering in Signoz
Noor was struggling to set up alerts in Signoz. Srikanth guided them through the issue and suggested using the query builder and upgrading the Signoz version.
Parsing log entry and extracting fields with OTEL
Syed needed help parsing a log entry and extracting fields using OTEL. nitya-signoz provided guidance and the correct configurations, resolving the issue.
Incorrect Alert Firing Issue in Threshold Condition
Harshith.R.S is experiencing an issue with alerts firing when the value is above the threshold. The issue remains unresolved after trying different query modifications suggested by Amol.