GenAI tile deployment fails with PostgreSQL instance provisioned by a9s Service Broker

Products

• VMware Tanzu Application Service

Issue/Introduction

Two options are available when configuring GenAI on Operations Manager

• Service Broker
• External 

With the configuration of a9s service broker, GenAI deployment fails at post-start phase, 

Updating deployment:
  Expected task '1345' to succeed but state is 'error'
Exit code 1
                       L Error: Action Failed get_task: Task b726b0f1-0230-43fb-803f-979474f75e42 result: 1 of 2 post-start scripts failed. Failed Jobs: ai-server. Successful Jobs: bosh-dns.
Task 666361 | 04:21:17 | Error: Action Failed get_task: Task b726b0f1-0230-43fb-803f-979474f75e42 result: 1 of 2 post-start scripts failed. Failed Jobs: ai-server. Successful Jobs: bosh-dns.

ai-server.stdout.log reports exception as

...
Caused by: java.lang.RuntimeException: Driver org.postgresql.Driver claims to not accept jdbcUrl, null
        at com.zaxxer.hikari.util.DriverDataSource.<init>(DriverDataSource.java:116)
        at com.zaxxer.hikari.pool.PoolBase.initializeDataSource(PoolBase.java:333)
        at com.zaxxer.hikari.pool.PoolBase.<init>(PoolBase.java:118)

 

Environment

• GenAI on Tanzu Platform

Cause

During GenAI deployment, the installation creates PostgreSQL service instance(if does not exist), and fetches jdbcUrl from the service key credential. However in credential provided by a9s service broker, there is no jdbcUrl but only url field. As the result, ai-server fails to start due to the datasource initialization failure. 

Resolution

When using a9s Service Broker, or other not officially supported service brokers by GenAI tile, please choose "External" at "Database Config" instead of "Service Broker", then input host, port, user, password, database separately.