❗ please do not add sensitive information in issues, you can provide extra information via email using issue number as reference ❗

Describe the issue
During a deployment of a new application version one of our Liquibase changes (add unique constraint to column) failed due to duplicate values in the target table causing a following Liquibase change to fail aswell, so our COMMENTS column which is configured as commentField="COMMENTS" never got added to the target table.

All adapters came up as green but the application was very slow, the scheduler was unable to start jobs and kept giving the following error: (ConnectionWaitTimeoutException): (ConnectionWaitTimeoutException) J2CA1010E: Connection not available; timed out waiting for 30 seconds.

Our DBA investigated and said that on the database side he saw 40 active sessions, 20 coming from each node we have on our acceptance environment, which is exactly the maximum size of our configured connection pool.\

After some digging around in the log files we saw the following log line:

2022-12-14 15:28:00,592 ERROR [ListenTask[Receiver [ProcessMail]]-20621] null receivers.Receiver - Receiver [ProcessMail] error occured nl.nn.adapterframework.core.ListenerException: [nl.nn.adapterframework.jdbc.JdbcTableListener] [ProcessMail] exception executing statement [UPDATE EXCHANGE_MAILID_TO_GUID SET STATUS='0',COMMENTS=? WHERE STATUS!='0' AND GUID=?]: (SQLSyntaxErrorException) SQLState [42000], errorCode [904]: (OracleDatabaseException) ORA-00904: "COMMENTS": ongeldige ID ~[ibis-adapterframework-core-7.7.jar:7.7]

which made us check the presence of the COMMENTS column, once this column has been added to the target table, the amount of active sessions dropped to a normal amount of active sessions and everything was running as expected again.

In this situation I'd expect that the JdbcTableListener would check the presence of configured columns and give a configuration warning if absent before starting up.

Reporter
Laurens

To Reproduce
Steps to reproduce the behavior:

1. JdbcTableListener with commentField="UNKNOWN_COLUMN"
2. Start IBIS
3. See that all connections are consumed

Environment

FF! 7.7: XXXX
Running on XXXX.insim.biz using IBM WebSphere Application Server/9.0.5.13
Java Version: Java(TM) SE Runtime Environment (8.0.7.15 - pxa6480sr7fp15-20220818_01(SR7 FP15))
Heap size: 2529M, total JVM memory: 4096M
Free disk space: 11GB, total disk space: 12GB
Up since: 2022-12-13 15:55:15 (1d)

Additional Environment

• DBMS: [e.g. Oracle, MSSQL, MariaDB, MySql, PostgreSQL] Oracle
• Browser: [e.g. Chrome, Safari, Edge, Firefox]

Additional Context
Add any other context about the problem here. (f.e. ladybug report / test adapter with larva test)