wuchase / logstash-output-analyticdb Goto Github PK

Oct 25 16:14:45 loan-nginx-prod-4 logstash[655]: [2022-10-25T16:14:45,966][WARN ][logstash.outputs.analyticdb][main][11aa8c42d5e09a9b8fc72ec8133089facbe1b375e6378c20f6b8c3ee34b23aa8] JDBC - Exception. Retrying {:exception=>#<Java::JavaSql::SQLSyntaxErrorException: [13000, 2022102516144519216818208803453844095] syntax error :syntax error => STAR is not value type, pos:342 row: 0 and ceil:4>, :statement=>"insert into data_appsflyer_event_full(appsflyer_id, app_id, customer_user_id, advertising_id, android_id, app_version, media_source, event_value, event_name, install_time, event_time, event_datetime) values(?,?,?,?,?,?,?,?,?,?,?,?)", :event=>"{"install_datetime":"2022-10-25T07:07:41.000Z","media_source":"organic","appsflyer_id":"1666681679375-5192929398245729707","app_id":"com.ktakilat.loan","@timestamp":"2022-10-25T08:05:53.071073923Z","app_version":"4.1.8","install_time":1666681661000,"log":{"file":{"path":"/var/log/nginx/appsflyer.pendanaan.com_access.log"}},"event_value":"{}","event_name":"log_in_page_click_pd_eye","event_time":1666681290406,"event":{"original":"/?app_version=4.1.8&install_time=2022-10-25 07:07:41.000&appsflyer_id=1666681679375-5192929398245729707&media_source=organic&event_value={}&event_time=2022-10-25 07:01:30.406&android_id=c00913d31966fd5a&app_id=com.ktakilat.loan&event_name=log_in_page_click_pd_eye&advertising_id=0fc8937b-2a2e-40ed-8f3c-e52f5a51818b&os_version=11"},"android_id":"c00913d31966fd5a","advertising_id":"0fc8937b-2a2e-40ed-8f3c-e52f5a51818b","event_datetime":"2022-10-25T07:01:30.406Z","os_version":"11"}"}

run the command : bin/logstash-plugin install logstash-output-analyticdb

Your Environment

in docker server; logstash-6.7.1
i can access the internet but give me the msg : invalid address
how can i do to deal with it?

Validating logstash-output-analyticdb
IPAddr::InvalidAddressError: invalid address
in6_addr at /data/pkg/logstash-6.7.1/vendor/jruby/lib/ruby/stdlib/ipaddr.rb:649
initialize at /data/pkg/logstash-6.7.1/vendor/jruby/lib/ruby/stdlib/ipaddr.rb:586
sender at /data/pkg/logstash-6.7.1/vendor/jruby/lib/ruby/stdlib/resolv.rb:785
fetch_resource at /data/pkg/logstash-6.7.1/vendor/jruby/lib/ruby/stdlib/resolv.rb:529
resolv at /data/pkg/logstash-6.7.1/vendor/jruby/lib/ruby/stdlib/resolv.rb:1137
each at org/jruby/RubyArray.java:1792
resolv at /data/pkg/logstash-6.7.1/vendor/jruby/lib/ruby/stdlib/resolv.rb:1135
each at org/jruby/RubyArray.java:1792
resolv at /data/pkg/logstash-6.7.1/vendor/jruby/lib/ruby/stdlib/resolv.rb:1134
each at org/jruby/RubyArray.java:1792
resolv at /data/pkg/logstash-6.7.1/vendor/jruby/lib/ruby/stdlib/resolv.rb:1132
fetch_resource at /data/pkg/logstash-6.7.1/vendor/jruby/lib/ruby/stdlib/resolv.rb:524
each_resource at /data/pkg/logstash-6.7.1/vendor/jruby/lib/ruby/stdlib/resolv.rb:514
getresource at /data/pkg/logstash-6.7.1/vendor/jruby/lib/ruby/stdlib/resolv.rb:495
api_endpoint at /data/pkg/logstash-6.7.1/lib/bootstrap/patches/remote_fetcher.rb:8
api_uri at /data/pkg/logstash-6.7.1/vendor/jruby/lib/ruby/stdlib/rubygems/source.rb:47
load_specs at /data/pkg/logstash-6.7.1/vendor/jruby/lib/ruby/stdlib/rubygems/source.rb:187
tuples_for at /data/pkg/logstash-6.7.1/vendor/jruby/lib/ruby/stdlib/rubygems/spec_fetcher.rb:267
available_specs at /data/pkg/logstash-6.7.1/vendor/jruby/lib/ruby/stdlib/rubygems/spec_fetcher.rb:231
each at org/jruby/RubyArray.java:1792
each_source at /data/pkg/logstash-6.7.1/vendor/jruby/lib/ruby/stdlib/rubygems/source_list.rb:98
available_specs at /data/pkg/logstash-6.7.1/vendor/jruby/lib/ruby/stdlib/rubygems/spec_fetcher.rb:227
search_for_dependency at /data/pkg/logstash-6.7.1/vendor/jruby/lib/ruby/stdlib/rubygems/spec_fetcher.rb:103
spec_for_dependency at /data/pkg/logstash-6.7.1/vendor/jruby/lib/ruby/stdlib/rubygems/spec_fetcher.rb:167
logstash_plugin? at /data/pkg/logstash-6.7.1/lib/pluginmanager/util.rb:29
validate_plugin at /data/pkg/logstash-6.7.1/lib/pluginmanager/install.rb:119
verify_remote! at /data/pkg/logstash-6.7.1/lib/pluginmanager/install.rb:113
each at org/jruby/RubyArray.java:1792
verify_remote! at /data/pkg/logstash-6.7.1/lib/pluginmanager/install.rb:111
execute at /data/pkg/logstash-6.7.1/lib/pluginmanager/install.rb:57
run at /data/pkg/logstash-6.7.1/vendor/bundle/jruby/2.5.0/gems/clamp-0.6.5/lib/clamp/command.rb:67
execute at /data/pkg/logstash-6.7.1/vendor/bundle/jruby/2.5.0/gems/clamp-0.6.5/lib/clamp/subcommand/execution.rb:11
run at /data/pkg/logstash-6.7.1/vendor/bundle/jruby/2.5.0/gems/clamp-0.6.5/lib/clamp/command.rb:67
run at /data/pkg/logstash-6.7.1/vendor/bundle/jruby/2.5.0/gems/clamp-0.6.5/lib/clamp/command.rb:132

Oct 25 16:14:45 loan-nginx-prod-4 logstash[655]: [2022-10-25T16:14:45,966][WARN ][logstash.outputs.analyticdb][main][11aa8c42d5e09a9b8fc72ec8133089facbe1b375e6378c20f6b8c3ee34b23aa8] JDBC - Exception. Retrying {:exception=>#<Java::JavaSql::SQLSyntaxErrorException: [13000, 2022102516144519216818208803453844095] syntax error :syntax error => STAR is not value type, pos:342 row: 0 and ceil:4>, :statement=>"insert into data_appsflyer_event_full(appsflyer_id, app_id, customer_user_id, advertising_id, android_id, app_version, media_source, event_value, event_name, install_time, event_time, event_datetime) values(?,?,?,?,?,?,?,?,?,?,?,?)", :event=>"{"install_datetime":"2022-10-25T07:07:41.000Z","media_source":"organic","appsflyer_id":"1666681679375-5192929398245729707","app_id":"com.ktakilat.loan","@timestamp":"2022-10-25T08:05:53.071073923Z","app_version":"4.1.8","install_time":1666681661000,"log":{"file":{"path":"/var/log/nginx/appsflyer.pendanaan.com_access.log"}},"event_value":"{}","event_name":"log_in_page_click_pd_eye","event_time":1666681290406,"event":{"original":"/?app_version=4.1.8&install_time=2022-10-25 07:07:41.000&appsflyer_id=1666681679375-5192929398245729707&media_source=organic&event_value={}&event_time=2022-10-25 07:01:30.406&android_id=c00913d31966fd5a&app_id=com.ktakilat.loan&event_name=log_in_page_click_pd_eye&advertising_id=0fc8937b-2a2e-40ed-8f3c-e52f5a51818b&os_version=11"},"android_id":"c00913d31966fd5a","advertising_id":"0fc8937b-2a2e-40ed-8f3c-e52f5a51818b","event_datetime":"2022-10-25T07:01:30.406Z","os_version":"11"}"}