V17.0.1 infinispan: Error updating JDBC_PING table

Hi All:

This is bugging me. Could anyone provide guidance on what I may have missed or any tips for debugging?

2022-05-02 10:33:36,631 ERROR [org.jgroups.protocols.JDBC_PING] (keycloak-cache-init) JGRP000145: Error updating JDBC_PING table: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into (“KEYCLOAK”.“JGROUPSPING”.“CREATED”)

Caused by: Error : 1400, Position : 0, Sql = INSERT INTO JGROUPSPING (own_addr, cluster_name, ping_data) values (:1 , :2 , :3 ), OriginalSql = INSERT INTO JGROUPSPING (own_addr, cluster_name, ping_data) values (?, ?, ?), Error Msg = ORA-01400: cannot insert NULL into (“KEYCLOAK”.“JGROUPSPING”.“CREATED”)

CONFIGURATION:


<JDBC_PING connection_driver=“oracle.jdbc.driver.OracleDriver”
connection_username=“keycloak”
connection_password=“keycloak”
connection_url=“jdbc:oracle:thin:@dburl/keycloak”
initialize_sql=“CREATE TABLE IF NOT EXISTS JGROUPSPING (own_addr varchar(200) NOT NULL, cluster_name varchar(200) NOT NULL, ping_data BYTEA, constraint PK_JGROUPSPING PRIMARY KEY (own_addr, cluster_name));”
info_writer_sleep_time=“500”
remove_all_data_on_view_change=“true”
stack.combine=“REPLACE”
stack.position=“MPING” />

For my case, the flags bolded below were not in the ‘build’. Once added, issue resolved.

./kc.sh build --db=oracle –cache=ispn --cache-stack=tcp