Issue: DB2 ERRORCODE=4474, SQLSTATE=01000 after upgrading to Deploy 10.3.3

Issue

When I upgrade the XL Deploy from 9.7.4 to 10.3.3. The upgrade is a success but we found a lot of warning messages about DB2. Can you please help us confirm the reasons for these warnings?

2021-12-24 14:11:39.628 [qtp1904258057-87] {} WARN  o.h.e.jdbc.spi.SqlExceptionHelper -
[jcc][t4][10217][10310][4.27.25] Connection read-only mode is not enforceable after the connection
has been established. 
To enforce a read only connection, set the read-only data source or connection property. ERRORCODE=
4474, SQLSTATE=01000

Workaround/Resolution Action

After further review, it appears this error is specific to the DB2 message with no impact, which means the WARN message can be ignored. For more details, see: https://stackoverflow.com/questions/55265029/trying-to-get-one-topic-http-localhost8080-topicsid-1-in-postman-got-the-fo

Please update the logback.xml located in <Deploy_Home>/conf to remove the WARN message. Add the new line as below (highlighted end of the line) and restart the Deploy instance:

<root level="info">
  <appender-ref ref="STDOUT" />
  <appender-ref ref="FILE" />
</root>

<logger name="com.xebialabs" level="info" />
<logger name="com.xebialabs.deployit.metrics" level="off"/>
<logger name="com.xebialabs.deployit.core.api.resteasy.http" level="info" />
<logger name="com.xebialabs.deployit.jetty.HttpHeaderOverrideServletRequest" level="info" />
<logger name="com.xebialabs.deployit.jetty.FlexRestCompatibilityServletRequest" level="info" />
<logger name="com.xebialabs.deployit.migration" level="info" />
<logger name="com.xebialabs.overthere" level="info" />
<logger name="net.schmizz.sshj" level="error" />
<logger name="org.springframework" level="warn"/>
<logger name="org.apache.commons.httpclient" level="warn" />
<logger name="org.apache.jackrabbit.core.value.BLOBInDataStore" level="error" />
<logger name="org.eclipse.aether" level="info" />
<logger name="de.schlichtherle.truezip" level="warn" />
<logger name="com.google.inject.internal.util" level="error" />
<logger name="org.springframework.beans.factory.support.DefaultListableBeanFactory" level="error" />
<logger name="liquibase" level="warn" />
<logger name="org.springframework.web.socket.adapter.jetty.JettyWebSocketHandlerAdapter" level="off"/>
<logger name="org.apache.activemq.artemis" level="warn" />
<logger name="org.apache.activemq.audit" level="warn" />
<logger name="org.hibernate.engine.jdbc.spi.SqlExceptionHelper" level="error" />

 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.