tangshihui commented on issue #296:
URL: https://github.com/apache/pulsar-manager/issues/296#issuecomment-620333630
@tuteng I reviewed the pulsar-manager.log. There are so many error logs:
2020-04-28 02:05:00.537 ERROR 39 --- [pool-2-thread-1]
o.s.s.s.TaskUtils$LoggingErrorHandler : Unexpected error occurred in
scheduled task.
org.springframework.jdbc.BadSqlGrammarException:
### Error querying database. Cause: org.postgresql.util.PSQLException:
ERROR: LIMIT #,# syntax is not supported
Hint: Use separate LIMIT and OFFSET clauses.
Position: 38
### The error may exist in
org/apache/pulsar/manager/mapper/EnvironmentsMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT name,broker FROM environments LIMIT ?, ?
### Cause: org.postgresql.util.PSQLException: ERROR: LIMIT #,# syntax is not
supported
Hint: Use separate LIMIT and OFFSET clauses.
Position: 38
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException:
ERROR: LIMIT #,# syntax is not supported
Hint: Use separate LIMIT and OFFSET clauses.
Position: 38
at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:234)
~[spring-jdbc-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
~[spring-jdbc-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at
org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
~[mybatis-spring-1.3.2.jar:1.3.2]
at
org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
~[mybatis-spring-1.3.2.jar:1.3.2]
at com.sun.proxy.$Proxy132.selectList(Unknown Source) ~[na:na]
----------------------------------------------------------------
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]
