How debug `No suitable driver found for` in trino plugin? #22436

nikita-sheremet-java-developer · 2024-06-19T09:54:40Z

nikita-sheremet-java-developer
Jun 19, 2024

I have created postgresql-event-listener that is "copy and paste" implementation from trino-mysql-event-listener. Running mvn clean install with tests and posgtres from test-containers - works. I have also checked content from /usr/lib/trino/plugin/postgresql-event-listener/ and /usr/lib/trino/plugin/mysql-event-listener/ - everything the same except jdbc drivers (mysql-connector-j-8.1.0.jar and postgresql-42.6.0.jar).

But during startup in docker-compose I got exception:

StackTrace


2024-06-19T04:36:24.689343015Z 2024-06-19T04:36:24.689Z	INFO	main	Bootstrap	postgresql-event-listener.db.url  ----     jdbc:postgresql://querieslog:5432/querieslog?user=admin&password=admin&useSSL=false&allowPublicKeyRetrieval=true
2024-06-19T04:36:24.998621975Z 2024-06-19T04:36:24.996Z	ERROR	main	io.trino.server.Server	Unable to create injector, see the following errors:
2024-06-19T04:36:24.998681349Z
2024-06-19T04:36:24.998690136Z 1) Error notifying ProvisionListener LifeCycleModule$$Lambda$3322/0x00007fd429bd5f50 of PostgresqlEventListener.
2024-06-19T04:36:24.998693552Z  Reason: LifeCycleStartException: Exception in PostConstruct method PostgresqlEventListener::createTable()
2024-06-19T04:36:24.998696227Z   at PostgresqlEventListenerFactory.lambda$create$0(PostgresqlEventListenerFactory.java:65)
2024-06-19T04:36:24.998714793Z   while locating PostgresqlEventListener
2024-06-19T04:36:24.998717358Z
2024-06-19T04:36:24.998719632Z 1 error
2024-06-19T04:36:24.998721997Z
2024-06-19T04:36:24.998724441Z ======================
2024-06-19T04:36:24.998727207Z Full classname legend:
2024-06-19T04:36:24.998730142Z ======================
2024-06-19T04:36:24.998732477Z LifeCycleModule$$Lambda$3322:   "io.airlift.bootstrap.LifeCycleModule$$Lambda$3322"
2024-06-19T04:36:24.998735122Z LifeCycleStartException:        "io.airlift.bootstrap.LifeCycleStartException"
2024-06-19T04:36:24.998737556Z PostgresqlEventListener:        "io.trino.plugin.eventlistener.postgresql.PostgresqlEventListener"
2024-06-19T04:36:24.998740191Z PostgresqlEventListenerFactory: "io.trino.plugin.eventlistener.postgresql.PostgresqlEventListenerFactory"
2024-06-19T04:36:24.998742776Z ========================
2024-06-19T04:36:24.998745141Z End of classname legend:
2024-06-19T04:36:24.998747485Z ========================
2024-06-19T04:36:24.998749850Z
2024-06-19T04:36:24.998752164Z com.google.inject.CreationException: Unable to create injector, see the following errors:
2024-06-19T04:36:24.998754709Z
2024-06-19T04:36:24.998757054Z 1) Error notifying ProvisionListener LifeCycleModule$$Lambda$3322/0x00007fd429bd5f50 of PostgresqlEventListener.
2024-06-19T04:36:24.998760150Z  Reason: LifeCycleStartException: Exception in PostConstruct method PostgresqlEventListener::createTable()
2024-06-19T04:36:24.998762694Z   at PostgresqlEventListenerFactory.lambda$create$0(PostgresqlEventListenerFactory.java:65)
2024-06-19T04:36:24.998765360Z   while locating PostgresqlEventListener
2024-06-19T04:36:24.998767784Z
2024-06-19T04:36:24.998770109Z 1 error
2024-06-19T04:36:24.998772413Z
2024-06-19T04:36:24.998774768Z ======================
2024-06-19T04:36:24.998777142Z Full classname legend:
2024-06-19T04:36:24.998779477Z ======================
2024-06-19T04:36:24.998781811Z LifeCycleModule$$Lambda$3322:   "io.airlift.bootstrap.LifeCycleModule$$Lambda$3322"
2024-06-19T04:36:24.998784286Z LifeCycleStartException:        "io.airlift.bootstrap.LifeCycleStartException"
2024-06-19T04:36:24.998786811Z PostgresqlEventListener:        "io.trino.plugin.eventlistener.postgresql.PostgresqlEventListener"
2024-06-19T04:36:24.998789396Z PostgresqlEventListenerFactory: "io.trino.plugin.eventlistener.postgresql.PostgresqlEventListenerFactory"
2024-06-19T04:36:24.998791940Z ========================
2024-06-19T04:36:24.998794335Z End of classname legend:
2024-06-19T04:36:24.998796619Z ========================
2024-06-19T04:36:24.998798994Z
2024-06-19T04:36:24.998801278Z 	at com.google.inject.internal.Errors.throwCreationExceptionIfErrorsExist(Errors.java:589)
2024-06-19T04:36:24.998810255Z 	at com.google.inject.internal.InternalInjectorCreator.injectDynamically(InternalInjectorCreator.java:190)
2024-06-19T04:36:24.998813261Z 	at com.google.inject.internal.InternalInjectorCreator.build(InternalInjectorCreator.java:113)
2024-06-19T04:36:24.998816107Z 	at com.google.inject.Guice.createInjector(Guice.java:87)
2024-06-19T04:36:24.998818581Z 	at io.airlift.bootstrap.Bootstrap.initialize(Bootstrap.java:268)
2024-06-19T04:36:24.998821096Z 	at io.trino.plugin.eventlistener.postgresql.PostgresqlEventListenerFactory.create(PostgresqlEventListenerFactory.java:71)
2024-06-19T04:36:24.998823881Z 	at io.trino.eventlistener.EventListenerManager.createEventListener(EventListenerManager.java:118)
2024-06-19T04:36:24.998826436Z 	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
2024-06-19T04:36:24.998828901Z 	at java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:992)
2024-06-19T04:36:24.998831396Z 	at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509)
2024-06-19T04:36:24.998833991Z 	at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
2024-06-19T04:36:24.998836726Z 	at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:921)
2024-06-19T04:36:24.998839191Z 	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
2024-06-19T04:36:24.998841625Z 	at java.base/java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:682)
2024-06-19T04:36:24.998844140Z 	at io.trino.eventlistener.EventListenerManager.configuredEventListeners(EventListenerManager.java:101)
2024-06-19T04:36:24.998846635Z 	at io.trino.eventlistener.EventListenerManager.loadEventListeners(EventListenerManager.java:86)
2024-06-19T04:36:24.998849100Z 	at io.trino.server.Server.doStart(Server.java:165)
2024-06-19T04:36:24.998851574Z 	at io.trino.server.Server.lambda$start$0(Server.java:91)
2024-06-19T04:36:24.998853999Z 	at io.trino.$gen.Trino_427____20240619_043606_1.run(Unknown Source)
2024-06-19T04:36:24.998856414Z 	at io.trino.server.Server.start(Server.java:91)
2024-06-19T04:36:24.998858858Z 	at io.trino.server.TrinoServer.main(TrinoServer.java:38)
2024-06-19T04:36:24.998861383Z Caused by: io.airlift.bootstrap.LifeCycleStartException: Exception in PostConstruct method io.trino.plugin.eventlistener.postgresql.PostgresqlEventListener::createTable()
2024-06-19T04:36:24.998863958Z 	at io.airlift.bootstrap.LifeCycleManager.startInstance(LifeCycleManager.java:245)
2024-06-19T04:36:24.998866373Z 	at io.airlift.bootstrap.LifeCycleManager.addInstance(LifeCycleManager.java:211)
2024-06-19T04:36:24.998869088Z 	at io.airlift.bootstrap.LifeCycleModule.provision(LifeCycleModule.java:61)
2024-06-19T04:36:24.998871813Z 	at com.google.inject.internal.ProvisionListenerStackCallback$Provision.provision(ProvisionListenerStackCallback.java:117)
2024-06-19T04:36:24.998880870Z 	at com.google.inject.internal.ProvisionListenerStackCallback.provision(ProvisionListenerStackCallback.java:66)
2024-06-19T04:36:24.998883676Z 	at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:93)
2024-06-19T04:36:24.998886140Z 	at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:300)
2024-06-19T04:36:24.998888615Z 	at com.google.inject.internal.ProviderToInternalFactoryAdapter.get(ProviderToInternalFactoryAdapter.java:40)
2024-06-19T04:36:24.998891300Z 	at com.google.inject.internal.SingletonScope$1.get(SingletonScope.java:169)
2024-06-19T04:36:24.998893945Z 	at com.google.inject.internal.InternalFactoryToProviderAdapter.get(InternalFactoryToProviderAdapter.java:45)
2024-06-19T04:36:24.998896450Z 	at com.google.inject.internal.InternalInjectorCreator.loadEagerSingletons(InternalInjectorCreator.java:213)
2024-06-19T04:36:24.998899015Z 	at com.google.inject.internal.InternalInjectorCreator.injectDynamically(InternalInjectorCreator.java:186)
2024-06-19T04:36:24.998901720Z 	... 19 more
2024-06-19T04:36:24.998904215Z Caused by: org.jdbi.v3.core.ConnectionException: java.sql.SQLException: No suitable driver found for jdbc:postgresql://querieslog:5432/querieslog?user=admin&password=admin&useSSL=false&allowPublicKeyRetrieval=true
2024-06-19T04:36:24.998907351Z 	at org.jdbi.v3.core.Jdbi.open(Jdbi.java:377)
2024-06-19T04:36:24.998909886Z 	at org.jdbi.v3.core.LazyHandleSupplier.createHandle(LazyHandleSupplier.java:50)
2024-06-19T04:36:24.998912521Z 	at org.jdbi.v3.core.internal.MemoizingSupplier.init(MemoizingSupplier.java:68)
2024-06-19T04:36:24.998915286Z 	at org.jdbi.v3.core.internal.MemoizingSupplier.get(MemoizingSupplier.java:46)
2024-06-19T04:36:24.998917721Z 	at org.jdbi.v3.core.LazyHandleSupplier.getHandle(LazyHandleSupplier.java:45)
2024-06-19T04:36:24.998920226Z 	at org.jdbi.v3.sqlobject.statement.internal.CustomizingStatementHandler.invoke(CustomizingStatementHandler.java:180)
2024-06-19T04:36:24.998922871Z 	at org.jdbi.v3.sqlobject.statement.internal.SqlUpdateHandler.invoke(SqlUpdateHandler.java:34)
2024-06-19T04:36:24.998925536Z 	at org.jdbi.v3.core.extension.ExtensionMetadata$ExtensionHandlerInvoker.lambda$invoke$0(ExtensionMetadata.java:345)
2024-06-19T04:36:24.998928021Z 	at org.jdbi.v3.core.AbstractHandleSupplier.invokeInContext(AbstractHandleSupplier.java:36)
2024-06-19T04:36:24.998930956Z 	at org.jdbi.v3.core.extension.ExtensionMetadata$ExtensionHandlerInvoker.call(ExtensionMetadata.java:363)
2024-06-19T04:36:24.998933461Z 	at org.jdbi.v3.core.extension.ExtensionMetadata$ExtensionHandlerInvoker.invoke(ExtensionMetadata.java:346)
2024-06-19T04:36:24.998936016Z 	at org.jdbi.v3.core.extension.ExtensionFactoryDelegate.lambda$attach$0(ExtensionFactoryDelegate.java:118)
2024-06-19T04:36:24.998938621Z 	at org.jdbi.v3.core.internal.OnDemandExtensions.invoke(OnDemandExtensions.java:85)
2024-06-19T04:36:24.998941015Z 	at org.jdbi.v3.core.internal.OnDemandExtensions.lambda$createProxy$2(OnDemandExtensions.java:71)
2024-06-19T04:36:24.998946937Z 	at org.jdbi.v3.core.Jdbi.callWithExtension(Jdbi.java:544)
2024-06-19T04:36:24.998949582Z 	at org.jdbi.v3.core.Jdbi.withExtension(Jdbi.java:531)
2024-06-19T04:36:24.998952287Z 	at org.jdbi.v3.core.internal.OnDemandExtensions.lambda$createProxy$3(OnDemandExtensions.java:71)
2024-06-19T04:36:24.998954922Z 	at jdk.proxy11/jdk.proxy11.$Proxy514.createQueryCompletedTable(Unknown Source)
2024-06-19T04:36:24.998958148Z 	at io.trino.plugin.eventlistener.postgresql.PostgresqlEventListener.createTable(PostgresqlEventListener.java:83)
2024-06-19T04:36:24.998961384Z 	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2024-06-19T04:36:24.998963949Z 	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
2024-06-19T04:36:24.998966454Z 	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2024-06-19T04:36:24.998969179Z 	at java.base/java.lang.reflect.Method.invoke(Method.java:568)
2024-06-19T04:36:24.998971834Z 	at io.airlift.bootstrap.LifeCycleManager.startInstance(LifeCycleManager.java:240)
2024-06-19T04:36:24.998974339Z 	... 30 more
2024-06-19T04:36:24.998976714Z Caused by: java.sql.SQLException: No suitable driver found for jdbc:postgresql://querieslog:5432/querieslog?user=admin&password=admin&useSSL=false&allowPublicKeyRetrieval=true
2024-06-19T04:36:24.998979589Z 	at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:706)
2024-06-19T04:36:24.998982154Z 	at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:252)
2024-06-19T04:36:24.998984619Z 	at io.trino.plugin.eventlistener.postgresql.PostgresqlEventListenerFactory$PostgresqlDataSourceModule.lambda$createConnectionFactory$0(PostgresqlEventListenerFactory.java:89)
2024-06-19T04:36:24.998987284Z 	at org.jdbi.v3.core.Jdbi.open(Jdbi.java:348)
2024-06-19T04:36:24.998989749Z 	... 53 more

Any idea how debug this issue? I ahve also checked that jdbc for postgres is present in couple other plugins - so it is unclear why it missing :'(

ebyhr · 2024-06-20T01:15:01Z

ebyhr
Jun 20, 2024
Collaborator

I guess you're using DriverManager.getConnection() method. Can you try new org.postgresql.Driver().connect() instead?

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

How debug `No suitable driver found for` in trino plugin? #22436

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{editor}}'s edit

{{editor}}'s edit

Uh oh!

Replies: 1 comment

Uh oh!

{{title}}

Uh oh!

Select a reply

Uh oh!

How debug No suitable driver found for in trino plugin? #22436

Uh oh!

Uh oh!

nikita-sheremet-java-developer Jun 19, 2024

Replies: 1 comment

Uh oh!

ebyhr Jun 20, 2024 Collaborator

How debug `No suitable driver found for` in trino plugin? #22436

nikita-sheremet-java-developer
Jun 19, 2024

ebyhr
Jun 20, 2024
Collaborator