ERROR: value too long for type character varying(200)

[kannan84240]

I'm using skywalking with postgresql. and tomcat agent, java agent installed application side. while receiving data lot of character varying (200) errors coming, manually logged postgres db and increased one table column type value. problem resolved but monitoring tool have more than 100 tables in db, so we can manually increase the datatype value. kindly suggest alternate method

2022-08-26 15:41:19,483 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2BatchDAO - 75 [DataCarrier.H2_ASYNCHRONOUS_BATCH_PERSISTENT.Consumer.0.Thread] ERROR [] - Batch entry 0 INSERT INTO alarm_record VALUES

was aborted: ERROR: value too long for type character varying(200) Call getNextException to see other errors in the batch.

java.sql.BatchUpdateException: Batch entry 0 INSERT INTO alarm_record VALUES
('20220826154119_endpoint_relation_resp_time_rule_

was aborted: ERROR: value too long for type character varying(200) Call getNextException to see other errors in the batch.

[wu-sheng]

You at least should format the text format well. I don't think this is a good read.

[kannan84240]

while using elasticsearch database

Caused by: java.lang.RuntimeException: {"error":{"root_cause":[{"type":"index_not_found_exception","reason":"no such index [sw_profile_task]","resource.type":"index_or_alias","resource.id":"sw_profile_task","index_uuid":"na","index":"sw_profile_task"}],"type":"index_not_found_exception","reason":"no such index [sw_profile_task]","resource.type":"index_or_alias","resource.id":"sw_profile_task","index_uuid":"na","index":"sw_profile_task"},"status":404}
at org.apache.skywalking.library.elasticsearch.client.SearchClient.lambda$null$0(SearchClient.java:50) ~[library-elasticsearch-client-8.9.1.jar:8.9.1]
at java.util.concurrent.CompletableFuture.uniApply(CompletableFuture.java:616) ~[?:1.8.0_312]
at java.util.concurrent.CompletableFuture$UniApply.tryFire(CompletableFuture.java:591) ~[?:1.8.0_312]
at java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:488) ~[?:1.8.0_312]
at java.util.concurrent.CompletableFuture.complete(CompletableFuture.java:1975) ~[?:1.8.0_312]
at com.linecorp.armeria.common.util.UnmodifiableFuture.doComplete(UnmodifiableFuture.java:124) ~[armeria-1.12.0.jar:?]
at com.linecorp.armeria.common.util.UnmodifiableFuture.lambda$wrap$0(UnmodifiableFuture.java:100) ~[armeria-1.12.0.jar:?]
at java.util.concurrent.CompletableFuture.uniHandle(CompletableFuture.java:836) ~[?:1.8.0_312]
at java.util.concurrent.CompletableFuture$UniHandle.tryFire(CompletableFuture.java:811) ~[?:1.8.0_312]
at java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:488) ~[?:1.8.0_312]
at java.util.concurrent.CompletableFuture.complete(CompletableFuture.java:1975) ~[?:1.8.0_312]
at com.linecorp.armeria.common.stream.DeferredStreamMessage.lambda$delegate$0(DeferredStreamMessage.java:130) ~[armeria-1.12.0.jar:?]
at java.util.concurrent.CompletableFuture.uniHandle(CompletableFuture.java:836) ~[?:1.8.0_312]
at java.util.concurrent.CompletableFuture$UniHandle.tryFire(CompletableFuture.java:811) ~[?:1.8.0_312]
at java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:488) ~[?:1.8.0_312]
at java.util.concurrent.CompletableFuture.complete(CompletableFuture.java:1975) ~[?:1.8.0_312]

[wu-sheng]

All codes have been verified manually and automatically testing, including ElasticSearch.
That is project protocol.

So, you simply post an error stack, doesn't help.

If you want to ask something, make your question clear. Open source community do not provide customer support service.

[kannan84240]

yes wu-sheng. I understood.

while I'm using skywalking with postgresql - data not receiving from agent,

the log saying

Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(200)
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553) ~[postgresql-42.2.18.jar:42.2.18]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285) ~[postgresql-42.2.18.jar:42.2.18]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:521) ~[postgresql-42.2.18.jar:42.2.18]

I think database table column default size is 200. ( character varying(200) ). if it is more than 200 may be error will be fixed. but 150 tables column manually increasing practically not possible, so Kindly suggest the idea or solution.

[wu-sheng]

As I said, we have tested this case through e2e testing.

https://github.com/apache/skywalking/tree/master/test/e2e-v2/cases/storage/postgres

I personally don't use this in product env. But I can share it is tested.

Maybe others know more. In an open source project, I don't think the error stack is hard to locate, as you have the whole env. If you could know the root cause, you would know how to fix.

[kannan84240]

Okay wu-sheng, thanks for your valuable information.