Kibana version:
7.17.8
Elasticsearch version:
7.17.8
APM Server version:
7.17.8
APM Agent language and version:
java 1.35.0
What can I do to make them show?
I have at least used mysql in this java project, can I show the dependency of mysql as in this python project
This is not enough info.
When you look into your traces, do you see those MySQL queries?
For example, in the following trace, there is a H2 span:
If you see such MySQL spans within your traces, then click on the SQL span and it will open a flyout:
Then use the "View span in Discover" link to get the span document and share it.
If you don't see any DB span, verify that your are using supported technologies and if you are, look in your agent log and see if there's anything interesting there.
-
I used spring boot 2.3.2
-
Here's more information
{"_index":"apm-7.17.8-span-000001","_type":"_doc","_id":"7s7ze4UBKiGt3V2iwzz1","_version":1,"_score":1,"_source":{"parent":{"id":"1f4c9dab7e88ba6a"},"agent":{"name":"java","ephemeral_id":"7c2364d3-3e06-486b-85a0-46fe2fa17937","version":"1.35.0"},"destination":{"address":"125.124.53.188","port":3306,"ip":"125.124.53.188"},"processor":{"name":"transaction","event":"span"},"observer":{"hostname":"ojbsdkv8j9zc9tq9","id":"71d67c43-e453-4d00-a046-346ddd733593","type":"apm-server","ephemeral_id":"d03c5254-8f3a-4b88-a4ad-e01d86ab7bdc","version":"7.17.8","version_major":7},"trace":{"id":"0a5ebb0832a43877979e033af382dd62"},"@timestamp":"2023-01-04T08:44:22.620Z","ecs":{"version":"1.12.0"},"service":{"environment":"production","name":"wetech_admin_server"},"event":{"outcome":"success"},"transaction":{"id":"1f4c9dab7e88ba6a"},"span":{"duration":{"us":46307},"stacktrace":[{"library_frame":true,"exclude_from_grouping":false,"filename":"HikariProxyPreparedStatement.java","classname":"com.zaxxer.hikari.pool.HikariProxyPreparedStatement","line":{"number":-1},"module":"com.zaxxer.hikari.pool","function":"execute"},{"library_frame":true,"exclude_from_grouping":false,"filename":"PreparedStatementLogger.java","classname":"org.apache.ibatis.logging.jdbc.PreparedStatementLogger","line":{"number":59},"function":"invoke","module":"org.apache.ibatis.logging.jdbc"},{"library_frame":true,"exclude_from_grouping":false,"filename":"PreparedStatementHandler.java","classname":"org.apache.ibatis.executor.statement.PreparedStatementHandler","line":{"number":64},"module":"org.apache.ibatis.executor.statement","function":"query"},{"library_frame":true,"exclude_from_grouping":false,"filename":"RoutingStatementHandler.java","classname":"org.apache.ibatis.executor.statement.RoutingStatementHandler","line":{"number":79},"module":"org.apache.ibatis.executor.statement","function":"query"},{"exclude_from_grouping":false,"library_frame":true,"filename":"SimpleExecutor.java","classname":"org.apache.ibatis.executor.SimpleExecutor","line":{"number":63},"module":"org.apache.ibatis.executor","function":"doQuery"},{"library_frame":true,"exclude_from_grouping":false,"filename":"BaseExecutor.java","classname":"org.apache.ibatis.executor.BaseExecutor","line":{"number":325},"module":"org.apache.ibatis.executor","function":"queryFromDatabase"},{"exclude_from_grouping":false,"library_frame":true,"filename":"BaseExecutor.java","classname":"org.apache.ibatis.executor.BaseExecutor","line":{"number":156},"module":"org.apache.ibatis.executor","function":"query"},{"library_frame":true,"exclude_from_grouping":false,"filename":"CachingExecutor.java","classname":"org.apache.ibatis.executor.CachingExecutor","line":{"number":109},"module":"org.apache.ibatis.executor","function":"query"},{"library_frame":true,"exclude_from_grouping":false,"filename":"PagingExecutor.java","classname":"tech.wetech.mybatis.PagingExecutor","line":{"number":114},"module":"tech.wetech.mybatis","function":"query"},{"library_frame":true,"exclude_from_grouping":false,"filename":"PagingExecutor.java","classname":"tech.wetech.mybatis.PagingExecutor","line":{"number":125},"function":"query","module":"tech.wetech.mybatis"},{"library_frame":true,"exclude_from_grouping":false,"filename":"DefaultSqlSession.java","classname":"org.apache.ibatis.session.defaults.DefaultSqlSession","line":{"number":147},"function":"selectList","module":"org.apache.ibatis.session.defaults"},{"exclude_from_grouping":false,"library_frame":true,"filename":"DefaultSqlSession.java","classname":"org.apache.ibatis.session.defaults.DefaultSqlSession","line":{"number":140},"module":"org.apache.ibatis.session.defaults","function":"selectList"},{"library_frame":true,"exclude_from_grouping":false,"filename":"SqlSessionTemplate.java","classname":"org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor","line":{"number":426},"module":"org.mybatis.spring","function":"invoke"},{"exclude_from_grouping":false,"library_frame":true,"filename":"SqlSessionTemplate.java","classname":"org.mybatis.spring.SqlSessionTemplate","line":{"number":223},"module":"org.mybatis.spring","function":"selectList"},{"library_frame":true,"exclude_from_grouping":false,"filename":"MapperMethod.java","classname":"org.apache.ibatis.binding.MapperMethod","line":{"number":147},"module":"org.apache.ibatis.binding","function":"executeForMany"},{"library_frame":true,"exclude_from_grouping":false,"filename":"MapperMethod.java","classname":"org.apache.ibatis.binding.MapperMethod","line":{"number":80},"module":"org.apache.ibatis.binding","function":"execute"},{"library_frame":true,"exclude_from_grouping":false,"filename":"MapperProxy.java","classname":"org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker","line":{"number":152},"module":"org.apache.ibatis.binding","function":"invoke"},{"exclude_from_grouping":false,"library_frame":true,"filename":"MapperProxy.java","classname":"org.apache.ibatis.binding.MapperProxy","line":{"number":85},"module":"org.apache.ibatis.binding","function":"invoke"},{"exclude_from_grouping":false,"library_frame":true,"filename":"UserServiceImpl.java","classname":"tech.wetech.admin.service.impl.UserServiceImpl","line":{"number":109},"module":"tech.wetech.admin.service.impl","function":"lambda$queryUserPage$0"},{"library_frame":true,"exclude_from_grouping":false,"filename":"Page.java","classname":"tech.wetech.mybatis.domain.Page","line":{"number":79},"function":"list","module":"tech.wetech.mybatis.domain"},{"library_frame":true,"exclude_from_grouping":false,"filename":"UserServiceImpl.java","classname":"tech.wetech.admin.service.impl.UserServiceImpl","line":{"number":109},"module":"tech.wetech.admin.service.impl","function":"queryUserPage"},{"library_frame":true,"exclude_from_grouping":false,"filename":"UserController.java","classname":"tech.wetech.admin.controller.UserController","line":{"number":34},"module":"tech.wetech.admin.controller","function":"queryUserList"},{"exclude_from_grouping":false,"library_frame":true,"filename":"<generated>","classname":"tech.wetech.admin.controller.UserController$$FastClassBySpringCGLIB$$26210f68","line":{"number":-1},"module":"tech.wetech.admin.controller","function":"invoke"},{"library_frame":true,"exclude_from_grouping":false,"filename":"MethodProxy.java","classname":"org.springframework.cglib.proxy.MethodProxy","line":{"number":218},"module":"org.springframework.cglib.proxy","function":"invoke"},{"library_frame":true,"exclude_from_grouping":false,"filename":"CglibAopProxy.java","classname":"org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation","line":{"number":771},"module":"org.springframework.aop.framework","function":"invokeJoinpoint"},{"library_frame":true,"exclude_from_grouping":false,"filename":"ReflectiveMethodInvocation.java","classname":"org.springframework.aop.framework.ReflectiveMethodInvocation","line":{"number":163},"function":"proceed","module":"org.springframework.aop.framework"},{"library_frame":true,"exclude_from_grouping":false,"filename":"CglibAopProxy.java","classname":"org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation","line":{"number":749},"module":"org.springframework.aop.framework","function":"proceed"},{"library_frame":true,"exclude_from_grouping":false,"filename":"MethodInvocationProceedingJoinPoint.java","classname":"org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint","line":{"number":88},"module":"org.springframework.aop.aspectj","function":"proceed"},{"library_frame":true,"exclude_from_grouping":false,"filename":"ControllerLogAspect.java","classname":"tech.wetech.admin.aspect.ControllerLogAspect","line":{"number":32},"module":"tech.wetech.admin.aspect","function":"aroundMethod"},{"library_frame":true,"exclude_from_grouping":false,"filename":"AbstractAspectJAdvice.java","classname":"org.springframework.aop.aspectj.AbstractAspectJAdvice","line":{"number":644},"module":"org.springframework.aop.aspectj","function":"invokeAdviceMethodWithGivenArgs"},{"library_frame":true,"exclude_from_grouping":false,"filename":"AbstractAspectJAdvice.java","classname":"org.springframework.aop.aspectj.AbstractAspectJAdvice","line":{"number":633},"module":"org.springframework.aop.aspectj","function":"invokeAdviceMethod"},{"library_frame":true,"exclude_from_grouping":false,"filename":"AspectJAroundAdvice.java","classname":"org.springframework.aop.aspectj.AspectJAroundAdvice","line":{"number":70},"module":"org.springframework.aop.aspectj","function":"invoke"},{"library_frame":true,"exclude_from_grouping":false,"filename":"ReflectiveMethodInvocation.java","classname":"org.springframework.aop.framework.ReflectiveMethodInvocation","line":{"number":175},"function":"proceed","module":"org.springframework.aop.framework"},{"library_frame":true,"exclude_from_grouping":false,"filename":"CglibAopProxy.java","classname":"org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation","line":{"number":749},"module":"org.springframework.aop.framework","function":"proceed"},{"library_frame":true,"exclude_from_grouping":false,"filename":"AopAllianceAnnotationsAuthorizingMethodInterceptor.java","classname":"org.apache.shiro.spring.security.interceptor.AopAllianceAnnotationsAuthorizingMethodInterceptor$1","line":{"number":82},"module":"org.apache.shiro.spring.security.interceptor","function":"proceed"},{"library_frame":true,"exclude_from_grouping":false,"filename":"AuthorizingMethodInterceptor.java","classname":"org.apache.shiro.authz.aop.AuthorizingMethodInterceptor","line":{"number":39},"module":"org.apache.shiro.authz.aop","function":"invoke"},{"library_frame":true,"exclude_from_grouping":false,"filename":"AopAllianceAnnotationsAuthorizingMethodInterceptor.java","classname":"org.apache.shiro.spring.security.interceptor.AopAllianceAnnotationsAuthorizingMethodInterceptor","line":{"number":115},"module":"org.apache.shiro.spring.security.interceptor","function":"invoke"},{"library_frame":true,"exclude_from_grouping":false,"filename":"ReflectiveMethodInvocation.java","classname":"org.springframework.aop.framework.ReflectiveMethodInvocation","line":{"number":186},"function":"proceed","module":"org.springframework.aop.framework"},{"library_frame":true,"exclude_from_grouping":false,"filename":"CglibAopProxy.java","classname":"org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation","line":{"number":749},"module":"org.springframework.aop.framework","function":"proceed"},{"library_frame":true,"exclude_from_grouping":false,"filename":"ExposeInvocationInterceptor.java","classname":"org.springframework.aop.interceptor.ExposeInvocationInterceptor","line":{"number":95},"module":"org.springframework.aop.interceptor","function":"invoke"},{"library_frame":true,"exclude_from_grouping":false,"filename":"ReflectiveMethodInvocation.java","classname":"org.springframework.aop.framework.ReflectiveMethodInvocation","line":{"number":186},"module":"org.springframework.aop.framework","function":"proceed"},{"library_frame":true,"exclude_from_grouping":false,"filename":"CglibAopProxy.java","classname":"org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation","line":{"number":749},"module":"org.springframework.aop.framework","function":"proceed"},{"exclude_from_grouping":false,"library_frame":true,"filename":"CglibAopProxy.java","classname":"org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor","line":{"number":691},"module":"org.springframework.aop.framework","function":"intercept"},{"library_frame":true,"exclude_from_grouping":false,"filename":"<generated>","classname":"tech.wetech.admin.controller.UserController$$EnhancerBySpringCGLIB$$49dd1cdf","line":{"number":-1},"module":"tech.wetech.admin.controller","function":"queryUserList"},{"library_frame":true,"exclude_from_grouping":false,"filename":"<generated>","classname":"tech.wetech.admin.controller.UserController$$FastClassBySpringCGLIB$$26210f68","line":{"number":-1},"module":"tech.wetech.admin.controller","function":"invoke"},{"library_frame":true,"exclude_from_grouping":false,"filename":"MethodProxy.java","classname":"org.springframework.cglib.proxy.MethodProxy","line":{"number":218},"module":"org.springframework.cglib.proxy","function":"invoke"},{"library_frame":true,"exclude_from_grouping":false,"filename":"CglibAopProxy.java","classname":"org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation","line":{"number":771},"module":"org.springframework.aop.framework","function":"invokeJoinpoint"},{"library_frame":true,"exclude_from_grouping":false,"filename":"ReflectiveMethodInvocation.java","classname":"org.springframework.aop.framework.ReflectiveMethodInvocation","line":{"number":163},"module":"org.springframework.aop.framework","function":"proceed"},{"library_frame":true,"exclude_from_grouping":false,"filename":"CglibAopProxy.java","classname":"org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation","line":{"number":749},"module":"org.springframework.aop.framework","function":"proceed"},{"library_frame":true,"exclude_from_grouping":false,"filename":"MethodValidationInterceptor.java","classname":"org.springframework.validation.beanvalidation.MethodValidationInterceptor","line":{"number":119},"module":"org.springframework.validation.beanvalidation","function":"invoke"}],"subtype":"mysql","destination":{"service":{"resource":"mysql/wetech_admin"}},"name":"SELECT","action":"query","id":"c2dde0a30c20e2ea","type":"db","db":{"instance":"wetech_admin","statement":"SELECTCOUNT(*)FROM(selectid,username,password,salt,role_ids,lockedfromsys_userorderbyidDESC)tmp_count","type":"sql","user":{"name":"root@219.140.150.207"}}},"timestamp":{"us":1672821862620260}},"fields":{"span.stacktrace.line.number":[-1,59,64,79,63,325,156,109,114,125,147,140,426,223,147,80,152,85,109,79,109,34,-1,218,771,163,749,88,32,644,633,70,175,749,82,39,115,186,749,95,186,749,691,-1,-1,218,771,163,749,119],"span.name":["SELECT"],"span.action":["query"],"destination.port":[3306],"span.db.user.name":["root@219.140.150.207"],"transaction.id":["1f4c9dab7e88ba6a"],"trace.id":["0a5ebb0832a43877979e033af382dd62"],"span.duration.us":[46307],"span.stacktrace.classname":["com.zaxxer.hikari.pool.HikariProxyPreparedStatement","org.apache.ibatis.logging.jdbc.PreparedStatementLogger","org.apache.ibatis.executor.statement.PreparedStatementHandler","org.apache.ibatis.executor.statement.RoutingStatementHandler","org.apache.ibatis.executor.SimpleExecutor","org.apache.ibatis.executor.BaseExecutor","org.apache.ibatis.executor.BaseExecutor","org.apache.ibatis.executor.CachingExecutor","tech.wetech.mybatis.PagingExecutor","tech.wetech.mybatis.PagingExecutor","org.apache.ibatis.session.defaults.DefaultSqlSession","org.apache.ibatis.session.defaults.DefaultSqlSession","org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor","org.mybatis.spring.SqlSessionTemplate","org.apache.ibatis.binding.MapperMethod","org.apache.ibatis.binding.MapperMethod","org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker","org.apache.ibatis.binding.MapperProxy","tech.wetech.admin.service.impl.UserServiceImpl","tech.wetech.mybatis.domain.Page","tech.wetech.admin.service.impl.UserServiceImpl","tech.wetech.admin.controller.UserController","tech.wetech.admin.controller.UserController$$FastClassBySpringCGLIB$$26210f68","org.springframework.cglib.proxy.MethodProxy","org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation","org.springframework.aop.framework.ReflectiveMethodInvocation","org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation","org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint","tech.wetech.admin.aspect.ControllerLogAspect","org.springframework.aop.aspectj.AbstractAspectJAdvice","org.springframework.aop.aspectj.AbstractAspectJAdvice","org.springframework.aop.aspectj.AspectJAroundAdvice","org.springframework.aop.framework.ReflectiveMethodInvocation","org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation","org.apache.shiro.spring.security.interceptor.AopAllianceAnnotationsAuthorizingMethodInterceptor$1","org.apache.shiro.authz.aop.AuthorizingMethodInterceptor","org.apache.shiro.spring.security.interceptor.AopAllianceAnnotationsAuthorizingMethodInterceptor","org.springframework.aop.framework.ReflectiveMethodInvocation","org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation","org.springframework.aop.interceptor.ExposeInvocationInterceptor","org.springframework.aop.framework.ReflectiveMethodInvocation","org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation","org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor","tech.wetech.admin.controller.UserController$$EnhancerBySpringCGLIB$$49dd1cdf","tech.wetech.admin.controller.UserController$$FastClassBySpringCGLIB$$26210f68","org.springframework.cglib.proxy.MethodProxy","org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation","org.springframework.aop.framework.ReflectiveMethodInvocation","org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation","org.springframework.validation.beanvalidation.MethodValidationInterceptor"],"span.db.statement":["SELECTCOUNT(*)FROM(selectid,username,password,salt,role_ids,lockedfromsys_userorderbyidDESC)tmp_count"],"processor.event":["span"],"agent.name":["java"],"destination.address":["125.124.53.188"],"event.outcome":["success"],"service.environment":["production"],"span.stacktrace.exclude_from_grouping":[false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false],"service.name":["wetech_admin_server"],"span.stacktrace.filename":["HikariProxyPreparedStatement.java","PreparedStatementLogger.java","PreparedStatementHandler.java","RoutingStatementHandler.java","SimpleExecutor.java","BaseExecutor.java","BaseExecutor.java","CachingExecutor.java","PagingExecutor.java","PagingExecutor.java","DefaultSqlSession.java","DefaultSqlSession.java","SqlSessionTemplate.java","SqlSessionTemplate.java","MapperMethod.java","MapperMethod.java","MapperProxy.java","MapperProxy.java","UserServiceImpl.java","Page.java","UserServiceImpl.java","UserController.java","<generated>","MethodProxy.java","CglibAopProxy.java","ReflectiveMethodInvocation.java","CglibAopProxy.java","MethodInvocationProceedingJoinPoint.java","ControllerLogAspect.java","AbstractAspectJAdvice.java","AbstractAspectJAdvice.java","AspectJAroundAdvice.java","ReflectiveMethodInvocation.java","CglibAopProxy.java","AopAllianceAnnotationsAuthorizingMethodInterceptor.java","AuthorizingMethodInterceptor.java","AopAllianceAnnotationsAuthorizingMethodInterceptor.java","ReflectiveMethodInvocation.java","CglibAopProxy.java","ExposeInvocationInterceptor.java","ReflectiveMethodInvocation.java","CglibAopProxy.java","CglibAopProxy.java","<generated>","<generated>","MethodProxy.java","CglibAopProxy.java","ReflectiveMethodInvocation.java","CglibAopProxy.java","MethodValidationInterceptor.java"],"processor.name":["transaction"],"span.stacktrace.function":["execute","invoke","query","query","doQuery","queryFromDatabase","query","query","query","query","selectList","selectList","invoke","selectList","executeForMany","execute","invoke","invoke","lambda$queryUserPage$0","list","queryUserPage","queryUserList","invoke","invoke","invokeJoinpoint","proceed","proceed","proceed","aroundMethod","invokeAdviceMethodWithGivenArgs","invokeAdviceMethod","invoke","proceed","proceed","proceed","invoke","invoke","proceed","proceed","invoke","proceed","proceed","intercept","queryUserList","invoke","invoke","invokeJoinpoint","proceed","proceed","invoke"],"span.subtype":["mysql"],"span.id":["c2dde0a30c20e2ea"],"observer.version_major":[7],"span.stacktrace.library_frame":[true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true],"span.stacktrace.module":["com.zaxxer.hikari.pool","org.apache.ibatis.logging.jdbc","org.apache.ibatis.executor.statement","org.apache.ibatis.executor.statement","org.apache.ibatis.executor","org.apache.ibatis.executor","org.apache.ibatis.executor","org.apache.ibatis.executor","tech.wetech.mybatis","tech.wetech.mybatis","org.apache.ibatis.session.defaults","org.apache.ibatis.session.defaults","org.mybatis.spring","org.mybatis.spring","org.apache.ibatis.binding","org.apache.ibatis.binding","org.apache.ibatis.binding","org.apache.ibatis.binding","tech.wetech.admin.service.impl","tech.wetech.mybatis.domain","tech.wetech.admin.service.impl","tech.wetech.admin.controller","tech.wetech.admin.controller","org.springframework.cglib.proxy","org.springframework.aop.framework","org.springframework.aop.framework","org.springframework.aop.framework","org.springframework.aop.aspectj","tech.wetech.admin.aspect","org.springframework.aop.aspectj","org.springframework.aop.aspectj","org.springframework.aop.aspectj","org.springframework.aop.framework","org.springframework.aop.framework","org.apache.shiro.spring.security.interceptor","org.apache.shiro.authz.aop","org.apache.shiro.spring.security.interceptor","org.springframework.aop.framework","org.springframework.aop.framework","org.springframework.aop.interceptor","org.springframework.aop.framework","org.springframework.aop.framework","org.springframework.aop.framework","tech.wetech.admin.controller","tech.wetech.admin.controller","org.springframework.cglib.proxy","org.springframework.aop.framework","org.springframework.aop.framework","org.springframework.aop.framework","org.springframework.validation.beanvalidation"],"destination.ip":["125.124.53.188"],"observer.hostname":["ojbsdkv8j9zc9tq9"],"span.type":["db"],"observer.id":["71d67c43-e453-4d00-a046-346ddd733593"],"timestamp.us":[1672821862620260],"@timestamp":["2023-01-04T08:44:22.620Z"],"span.db.type":["sql"],"observer.ephemeral_id":["d03c5254-8f3a-4b88-a4ad-e01d86ab7bdc"],"observer.version":["7.17.8"],"ecs.version":["1.12.0"],"observer.type":["apm-server"],"agent.ephemeral_id":["7c2364d3-3e06-486b-85a0-46fe2fa17937"],"parent.id":["1f4c9dab7e88ba6a"],"agent.version":["1.35.0"],"span.destination.service.resource":["mysql/wetech_admin"],"span.db.instance":["wetech_admin"]}}
Thanks for providing those details.
From what I see in the provided document:
- the
observer.versionis7.17.8, thus it means that the apm-server that wrote this document is consistent with the stack. - there is no
span.service.target.*fields, which were added in7.16.0and should be inferred by apm-server when not sent by the agent - the
span.destination.service.resourcefield is set tomysql/wetech_admin, so the apm-server should have properly inferred the values ofspan.service.target.{type,name}, it should have been the same when using an older agent that did not send those new fields.
Are you using any custom ingest pipeline that could maybe interfere ?
As far as I know use custom ingest pipeline need register the pipeline, I haven't done that
I provided debug logs for apm-agent, Do you need more information?
apm-agent.log
This problem has been bothering me, and I am willing to provide more useful information to solve this problem @Sylvain_Juge
Hi,
After checking with the APM server team, I was wrong about the span.service.target.* fields that have been added only in 8.3.0 or 8.4.0, and not in 7.16.0 as I initially wrote, sorry for this wrong analysis.
So, going back to your issue description:
- you can see the dependency in the service dependencies and the map.
- the issue is that you have an "empty" view when opening this dependency.
I am not familiar with how this view is built in Kibana, but it very probably relies on metrics that are computed from the agent data.
The information captured by the agent (here a span) seems correct.
I don't read chinese, what time frame did you picked for the last screenshot ?
It may sound obvious but worth to check, do you have the same by using a large one like "the last 2 months" ?
The previous screenshots were from the last seven days
Below are screenshots from the last 15 minutes and the last 2 months
You can be sure that mysql services are visible throughout the span
I'm using an open source project that you can find on github
Hi @ntmxglrtayl03 ,
I tried to reproduce locally with the provided application, but I did not manage to reproduce it. When using latest agent version (very close to 1.35, I had to use this one to enable the agent with spring-boot:run maven goal) and the same 7.17.8 stack version.
Here is a screenshot of the service dependencies:
It initially took a bit of time (a few seconds) for the data to be available and properly displayed in Kibana.
Hi @Sylvain_Juge , Thank you very much for your help！
I from beginning to end not had dependency information ，But I'm running a different project from github， The dependency information arisened，It's probably related to some config, but I can't find it
The dependencies are created from the spans, thus here as you seem to be able to see the database spans in the Trace view, you should have the corresponding dependencies visible in the service dependencies and the map.
As I have checked with a different application (but that might be close to yours), it should work as expected. The only difference I could see here is your stack deployment.
Is there anything specific for your deployment ? is it on-premises or cloud ? Maybe there is something missing or broken in your deployment that prevents the APM product to work as expected.
This topic was automatically closed 20 days after the last reply. New replies are no longer allowed.