65725738 commented on issue #6347:
URL: https://github.com/apache/shardingsphere/issues/6347#issuecomment-658492886
2020-07-15 09:23:41,137 INFO http-bio-8080-exec-3 ShardingSphere-SQL -
SQLStatement:
InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@2a48199c,
tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@4a651eab),
tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@4a651eab,
columnNames=[principal, profile_id, soptype_cd, app_cd, usr_type_cd,
is_success], insertValueContexts=[InsertValueContext(parametersCount=6,
valueExpressions=[ParameterMarkerExpressionSegment(startIndex=228,
stopIndex=228, parameterMarkerIndex=0),
ParameterMarkerExpressionSegment(startIndex=253, stopIndex=253,
parameterMarkerIndex=1), ParameterMarkerExpressionSegment(startIndex=278,
stopIndex=278, parameterMarkerIndex=2),
ParameterMarkerExpressionSegment(startIndex=303, stopIndex=303,
parameterMarkerIndex=3), ParameterMarkerExpressionSegment(startIndex=328,
stopIndex=328, parameterMarkerIndex=4),
ParameterMarkerExpressionSegment(startIndex=353, stopIndex=353,
parameterMarkerIndex=5)], parameters=[admin, 1, LGN, CONOSLE, E, true])],
generatedKeyContext=Optional.empty)
2020-07-15 09:23:41,138 INFO http-bio-8080-exec-3 ShardingSphere-SQL -
Actual SQL: ds_master ::: insert into aa_subject_log
( principal,
profile_id,
soptype_cd,
app_cd,
usr_type_cd,
is_success )
values (?, ?, ?, ?, ?, ?) ::: [admin, 1, LGN, CONOSLE, E, true]
2020-07-15 09:23:41,178 DEBUG http-bio-8080-exec-3
com.badu.bdsaas.aa.dao.SubjectLogMapper.insertSelective - <== Updates: 1
2020-07-15 09:23:41,205 INFO http-bio-8080-exec-3
com.badu.bdsaas.aa.service.impl.AbstractAAService - strategy:2
2020-07-15 09:23:42,929 ERROR http-bio-8080-exec-3 fmp-runtime-exception
-
java.lang.NullPointerException
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at
org.apache.shardingsphere.sql.parser.mysql.visitor.MySQLVisitor.visitPredicate(MySQLVisitor.java:316)
at
org.apache.shardingsphere.sql.parser.mysql.visitor.MySQLVisitor.visitPredicate(MySQLVisitor.java:121)
at
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser$PredicateContext.accept(MySQLStatementParser.java:11690)
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at
org.apache.shardingsphere.sql.parser.mysql.visitor.MySQLVisitor.visitBooleanPrimary(MySQLVisitor.java:273)
at
org.apache.shardingsphere.sql.parser.mysql.visitor.MySQLVisitor.visitBooleanPrimary(MySQLVisitor.java:121)
at
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser$BooleanPrimaryContext.accept(MySQLStatementParser.java:11463)
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at
org.apache.shardingsphere.sql.parser.mysql.visitor.MySQLVisitor.visitExpr(MySQLVisitor.java:258)
at
org.apache.shardingsphere.sql.parser.mysql.visitor.MySQLVisitor.visitExpr(MySQLVisitor.java:121)
Data has been stored in mysql. and then error!
>
>
> It seems sql syntax error.
> So can you show your logic sql.
2020-07-15 09:23:41,137 INFO http-bio-8080-exec-3 ShardingSphere-SQL -
SQLStatement:
InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@2a48199c,
tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@4a651eab),
tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@4a651eab,
columnNames=[principal, profile_id, soptype_cd, app_cd, usr_type_cd,
is_success], insertValueContexts=[InsertValueContext(parametersCount=6,
valueExpressions=[ParameterMarkerExpressionSegment(startIndex=228,
stopIndex=228, parameterMarkerIndex=0),
ParameterMarkerExpressionSegment(startIndex=253, stopIndex=253,
parameterMarkerIndex=1), ParameterMarkerExpressionSegment(startIndex=278,
stopIndex=278, parameterMarkerIndex=2),
ParameterMarkerExpressionSegment(startIndex=303, stopIndex=303,
parameterMarkerIndex=3), ParameterMarkerExpressionSegment(startIndex=328,
stopIndex=328, parameterMarkerIndex=4),
ParameterMarkerExpressionSegment(startIndex=353, stopIndex=353,
parameterMarkerIndex=5)], parameters=[admin, 1, LGN, CONOSLE, E, true])],
generatedKeyContext=Optional.empty)
2020-07-15 09:23:41,138 INFO http-bio-8080-exec-3 ShardingSphere-SQL -
Actual SQL: ds_master ::: insert into aa_subject_log
( principal,
profile_id,
soptype_cd,
app_cd,
usr_type_cd,
is_success )
values (?, ?, ?, ?, ?, ?) ::: [admin, 1, LGN, CONOSLE, E, true]
2020-07-15 09:23:41,178 DEBUG http-bio-8080-exec-3
com.badu.bdsaas.aa.dao.SubjectLogMapper.insertSelective - <== Updates: 1
2020-07-15 09:23:41,205 INFO http-bio-8080-exec-3
com.badu.bdsaas.aa.service.impl.AbstractAAService - strategy:2
2020-07-15 09:23:42,929 ERROR http-bio-8080-exec-3 fmp-runtime-exception
-
java.lang.NullPointerException
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at
org.apache.shardingsphere.sql.parser.mysql.visitor.MySQLVisitor.visitPredicate(MySQLVisitor.java:316)
at
org.apache.shardingsphere.sql.parser.mysql.visitor.MySQLVisitor.visitPredicate(MySQLVisitor.java:121)
at
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser$PredicateContext.accept(MySQLStatementParser.java:11690)
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at
org.apache.shardingsphere.sql.parser.mysql.visitor.MySQLVisitor.visitBooleanPrimary(MySQLVisitor.java:273)
at
org.apache.shardingsphere.sql.parser.mysql.visitor.MySQLVisitor.visitBooleanPrimary(MySQLVisitor.java:121)
at
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser$BooleanPrimaryContext.accept(MySQLStatementParser.java:11463)
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at
org.apache.shardingsphere.sql.parser.mysql.visitor.MySQLVisitor.visitExpr(MySQLVisitor.java:258)
at
org.apache.shardingsphere.sql.parser.mysql.visitor.MySQLVisitor.visitExpr(MySQLVisitor.java:121)
Data has been stored in mysql. and then error!
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
[email protected]
