Unable to get anything about a partition: TypeError: Cannot read property 'status' of undefined

[rueian]

Hi, it seems that my pulsar-manger can't get anything about a topic partition:

logs of my pulsar-manager:

2020-05-15 16:41:49.564 UTC [2344] ERROR:  LIMIT #,# syntax is not supported at character 38
2020-05-15 16:41:49.564 UTC [2344] HINT:  Use separate LIMIT and OFFSET clauses.
2020-05-15 16:41:49.564 UTC [2344] STATEMENT:  SELECT name,broker FROM environments LIMIT $1, $2
2020-05-15 16:42:49.601 UTC [2344] ERROR:  LIMIT #,# syntax is not supported at character 38
2020-05-15 16:42:49.601 UTC [2344] HINT:  Use separate LIMIT and OFFSET clauses.
2020-05-15 16:42:49.601 UTC [2344] STATEMENT:  SELECT name,broker FROM environments LIMIT $1, $2
2020-05-15 16:43:49.645 UTC [2344] ERROR:  LIMIT #,# syntax is not supported at character 38
2020-05-15 16:43:49.645 UTC [2344] HINT:  Use separate LIMIT and OFFSET clauses.
2020-05-15 16:43:49.645 UTC [2344] STATEMENT:  SELECT name,broker FROM environments LIMIT $1, $2
2020-05-15 16:44:49.685 UTC [2344] ERROR:  LIMIT #,# syntax is not supported at character 38
2020-05-15 16:44:49.685 UTC [2344] HINT:  Use separate LIMIT and OFFSET clauses.
2020-05-15 16:44:49.685 UTC [2344] STATEMENT:  SELECT name,broker FROM environments LIMIT $1, $2
2020-05-15 16:45:49.716 UTC [2344] ERROR:  LIMIT #,# syntax is not supported at character 38
2020-05-15 16:45:49.716 UTC [2344] HINT:  Use separate LIMIT and OFFSET clauses.
2020-05-15 16:45:49.716 UTC [2344] STATEMENT:  SELECT name,broker FROM environments LIMIT $1, $2
2020-05-15 16:46:49.741 UTC [2344] ERROR:  LIMIT #,# syntax is not supported at character 38
2020-05-15 16:46:49.741 UTC [2344] HINT:  Use separate LIMIT and OFFSET clauses.
2020-05-15 16:46:49.741 UTC [2344] STATEMENT:  SELECT name,broker FROM environments LIMIT $1, $2
2020-05-15 16:47:49.776 UTC [2344] ERROR:  LIMIT #,# syntax is not supported at character 38
2020-05-15 16:47:49.776 UTC [2344] HINT:  Use separate LIMIT and OFFSET clauses.
2020-05-15 16:47:49.776 UTC [2344] STATEMENT:  SELECT name,broker FROM environments LIMIT $1, $2
2020-05-15 16:48:49.815 UTC [2344] ERROR:  LIMIT #,# syntax is not supported at character 38
2020-05-15 16:48:49.815 UTC [2344] HINT:  Use separate LIMIT and OFFSET clauses.
2020-05-15 16:48:49.815 UTC [2344] STATEMENT:  SELECT name,broker FROM environments LIMIT $1, $2
2020-05-15 16:49:49.856 UTC [2344] ERROR:  LIMIT #,# syntax is not supported at character 38
2020-05-15 16:49:49.856 UTC [2344] HINT:  Use separate LIMIT and OFFSET clauses.
2020-05-15 16:49:49.856 UTC [2344] STATEMENT:  SELECT name,broker FROM environments LIMIT $1, $2
2020-05-15 16:50:49.892 UTC [2351] ERROR:  LIMIT #,# syntax is not supported at character 38
2020-05-15 16:50:49.892 UTC [2351] HINT:  Use separate LIMIT and OFFSET clauses.
2020-05-15 16:50:49.892 UTC [2351] STATEMENT:  SELECT name,broker FROM environments LIMIT $1, $2
2020-05-15 16:51:49.924 UTC [2358] ERROR:  LIMIT #,# syntax is not supported at character 38
2020-05-15 16:51:49.924 UTC [2358] HINT:  Use separate LIMIT and OFFSET clauses.
2020-05-15 16:51:49.924 UTC [2358] STATEMENT:  SELECT name,broker FROM environments LIMIT $1, $2
2020-05-15 16:52:49.953 UTC [2378] ERROR:  LIMIT #,# syntax is not supported at character 38
2020-05-15 16:52:49.953 UTC [2378] HINT:  Use separate LIMIT and OFFSET clauses.
2020-05-15 16:52:49.953 UTC [2378] STATEMENT:  SELECT name,broker FROM environments LIMIT $1, $2

Please help me to find out the problem, thank you.

[jiazhai]

@rueian How is the topic created? And which version is running in broker side? Looks like topic is not auto created.

[rueian]

I am running pulsar 2.5.1, manager 0.1.0, and I am sure the topic is auto created. I can run pulsar-admin to get its info.

[sijie]

@rueian which database are you using? MySQL or Postgres?

[rueian]

Hi @sijie

I think it is PostgreSQL. I am using this configuration: https://github.com/apache/pulsar/blob/master/deployment/kubernetes/helm/pulsar/values.yaml#L887

I am also wondering why a MySQL or a PostgreSQL is required to run a pulsar-manager? I was expected that the pulsar-manager was just a http client to pulsar cluster.

[sijie]

@rueian it is using a JDBC database to collect and store stats. besides topic stats, it just forwards HTTP requests to pulsar cluster.

@tuteng can you help check this issue?

[tuteng]

I am very sorry for the late reply. I think this error is caused by using the wrong paging plug-in, I will look at this problem, but at present, you can try to use this YAML https://github.com/streamnative/charts/tree/master/charts/pulsar file to start the pulsar-manager service, and an updated version of 0.3.0 is used here. @rueian

[tuteng]

This option pagehelper.helperDialect=postgresql is specified in this file https://github.com/streamnative/charts/blob/master/charts/pulsar/templates/pulsar-manager/pulsar-manager-configmap.yaml

[lxkaka]

I have the similar problem. I use image apachepulsar/pulsar-manager:v0.1.0 to deploy in k8s. I can not get any data. I also change image streamnative/pulsar-manager errror log show below

2020-06-01 07:18:51.205 UTC [88] STATEMENT:  SELECT name,broker FROM environments LIMIT $1, $2
2020-06-01 07:19:51.266 UTC [88] ERROR:  LIMIT #,# syntax is not supported at character 38
2020-06-01 07:19:51.266 UTC [88] HINT:  Use separate LIMIT and OFFSET clauses.
2020-06-01 07:19:51.266 UTC [88] STATEMENT:  SELECT name,broker FROM environments LIMIT $1, $2
2020-06-01 07:20:51.301 UTC [88] ERROR:  LIMIT #,# syntax is not supported at character 38
2020-06-01 07:20:51.301 UTC [88] HINT:  Use separate LIMIT and OFFSET clauses.
2020-06-01 07:20:51.301 UTC [88] STATEMENT:  SELECT name,broker FROM environments LIMIT $1, $2
2020-06-01 07:21:51.327 UTC [88] ERROR:  LIMIT #,# syntax is not supported at character 38
2020-06-01 07:21:51.327 UTC [88] HINT:  Use separate LIMIT and OFFSET clauses.
2020-06-01 07:21:51.327 UTC [88] STATEMENT:  SELECT name,broker FROM environments LIMIT $1, $2