Hi! I am trying to datahub-gms component mysql err...
# troubleshoot
m
Hi! I am trying to datahub-gms component mysql error log. I’m set up datahub-component and using datahub. Most of the functions are working. However, the error log of datahub-gms is repeatedly output. Can you help me with this error log?
Copy code
16:36:52.931 [pool-7-thread-1] ERROR c.d.authorization.DataHubAuthorizer:229 - Failed to retrieve policy urns! Skipping updating policy cache until next refresh. start: 0, count: 30
javax.persistence.PersistenceException: Query threw SQLException:vtgate: ${my mysql address} : code = Aborted desc = transaction 1663147082760249589: ended at 2022-09-21 16:36:10.929 KST (exceeded timeout: 1m0s) (CallerID: datahub admin db) Bind values:[urn:li:dataHubPolicy:15b29d13-53ad-44d0-a006-a33a9550ee77, dataHubPolicyInfo, 0, urn:li:dataHubPolicy:15b29d13-53ad-44d0-a006-a33a9550ee77, dataHubPolicyKey, 0] Query was:select urn, aspect, version, metadata, systemMetadata, createdOn, createdBy, createdFor FROM metadata_aspect_v2 WHERE urn = ? AND aspect = ? AND version = ? UNION ALL SELECT urn, aspect, version, metadata, systemMetadata, createdOn, createdBy, createdFor FROM metadata_aspect_v2 WHERE urn = ? AND aspect = ? AND version = ?
	at io.ebean.config.dbplatform.SqlCodeTranslator.translate(SqlCodeTranslator.java:52)
	at io.ebean.config.dbplatform.DatabasePlatform.translate(DatabasePlatform.java:219)
	at io.ebeaninternal.server.query.CQueryEngine.translate(CQueryEngine.java:149)
	at io.ebeaninternal.server.query.DefaultOrmQueryEngine.translate(DefaultOrmQueryEngine.java:43)
	at io.ebeaninternal.server.core.OrmQueryRequest.translate(OrmQueryRequest.java:102)
	at io.ebeaninternal.server.query.CQuery.createPersistenceException(CQuery.java:702)
	at io.ebeaninternal.server.query.CQueryEngine.findMany(CQueryEngine.java:411)
	at io.ebeaninternal.server.query.DefaultOrmQueryEngine.findMany(DefaultOrmQueryEngine.java:133)
	at io.ebeaninternal.server.core.OrmQueryRequest.findList(OrmQueryRequest.java:459)
	at io.ebeaninternal.server.core.DefaultServer.findList(DefaultServer.java:1596)
	at io.ebeaninternal.server.core.DefaultServer.findList(DefaultServer.java:1574)
	at io.ebeaninternal.server.querydefn.DefaultOrmQuery.findList(DefaultOrmQuery.java:1481)
	at com.linkedin.metadata.entity.ebean.EbeanAspectDao.batchGetUnion(EbeanAspectDao.java:359)
	at com.linkedin.metadata.entity.ebean.EbeanAspectDao.batchGet(EbeanAspectDao.java:279)
	at com.linkedin.metadata.entity.ebean.EbeanAspectDao.batchGet(EbeanAspectDao.java:260)
	at com.linkedin.metadata.entity.EntityService.exists(EntityService.java:1309)
	at com.linkedin.metadata.resources.entity.ResourceUtils.lambda$validateSearchResult$0(ResourceUtils.java:52)
	at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:174)
	at java.util.Iterator.forEachRemaining(Iterator.java:116)
	at java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1801)
	at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:482)
	at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:472)
	at java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:708)
	at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:566)
	at com.linkedin.metadata.resources.entity.ResourceUtils.validateSearchResult(ResourceUtils.java:53)
	at com.linkedin.entity.client.JavaEntityClient.search(JavaEntityClient.java:297)
	at com.datahub.authorization.PolicyFetcher.fetchPolicies(PolicyFetcher.java:50)
	at com.datahub.authorization.PolicyFetcher.fetchPolicies(PolicyFetcher.java:42)
	at com.datahub.authorization.DataHubAuthorizer$PolicyRefreshRunnable.run(DataHubAuthorizer.java:222)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: com.mysql.cj.jdbc.exceptions.MySQLQueryInterruptedException: ${my mysql address} : rpc error: code = Aborted desc = transaction 1663147082760249589: ended at 2022-09-21 16:36:10.929 KST (exceeded timeout: 1m0s) (CallerID: datahub admin db)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:126)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003)
	at io.ebean.datasource.pool.ExtendedPreparedStatement.executeQuery(ExtendedPreparedStatement.java:136)
	at io.ebeaninternal.server.query.CQuery.prepareResultSet(CQuery.java:376)
	at io.ebeaninternal.server.query.CQuery.prepareBindExecuteQueryWithOption(CQuery.java:324)
	at io.ebeaninternal.server.query.CQuery.prepareBindExecuteQuery(CQuery.java:319)
	at io.ebeaninternal.server.query.CQueryEngine.findMany(CQueryEngine.java:384)
	... 30 common frames omitted
m
Is this still an issue @many-keyboard-47985?
Were you running quickstart?
m
Yes. Still having problems.
This is running datahub helm chart.https://github.com/acryldata/datahub-helm
Is Datahub using mysql’s transaction??