Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

liquibase error with oracle after upgrading XL Deploy from 6.0.2 to 7.5.0 #5

Open
jsammataro opened this issue Apr 12, 2018 · 1 comment

Comments

@jsammataro
Copy link

Hello,
We have been experiencing the following error while using the xld-liquibase-plugin after upgrading XL Deploy from 6.0.2 to 7.5.0:
ERROR c.x.deployit.plugin.steps.JythonStep - Unexpected error running Liquibase: java.sql.SQLRecoverableException: IO Error: Connection reset

Prior to the upgrade we were not having this issue. We are using the following versions of the products and plugins:
rhel6
jdk1.8.0_66
liquibase-3.5.5
xld-liquibase-plugin-5.0.1.xldp
overtherepy-0.0.3.jar
ojdbc7.jar

We have also noticed there is a big difference in execution time for the same liquibase command when run using XL Deploy and xld-liquibase-plugin vs running on the command line from the same machine.

We reached out to Xebia Labs support and mentioned that the overtherepy-0.0.3.jar has not been updated in some time. The reply is as follows: In 6.0.2 we have jython-standalone-2.7.0.jar, while in 7.5.0 we have jython-standalone-2.7.1.patch2609.jar. Perhaps the behavioral change you are seeing ins related? The liquibase plugin is a community plugin and has likely not been tested with XLD 7.5. You might contact the creator of the plugin.

Otherwise, we have tried solutions as recommended by articles such as these and others:
https://community.oracle.com/thread/943911
http://www.usn-it.de/index.php/2009/02/20/oracle-11g-jdbc-driver-hangs-blocked-by-devrandom-entropy-pool-empty/
https://stackoverflow.com/questions/6110395/sqlrecoverableexception-i-o-exception-connection-reset

We can remove the /dev/urandom and /dev/random files and this seems to work, however this breaks ssh and will be restored after reboot. As recommended in the above articles, I have attempted to set the following JAVA_OPTS as a wrapper.java.additional entry in the xld-wrapper-linux.conf and also for the user environment variables. (There does not seem to be an entry for JAVA_OPTS in the xld-liquibase-plugin-5.0.1.xldp):
-Djava.security.egd=file:/dev/../dev/urandom
-Djava.security.egd=file:///dev/urandom
-Djava.security.egd=file:/dev/./urandom

We have also tried reverting to the previous liquibase and plugins versions with no luck. Running the same liquibase commands from the command line on the rhel6 linux box that hosts XL Deploy executes quickly with no errors.

Please let us know if any additional information is needed.

Thanks,
James

@jdewinne
Copy link
Contributor

Based on the error that you get, I think this is coming from the liquibase CLI.
So updating the xld-wrapper-linux.conf will not help, as it is a different process. Did you install the CLI on the same host as XLD?
You could change the liquibase script from the CLI to include the -Djava.security.egd settings. I would expect that to work.

This stackoverflow issue is probably related.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants