search

utPLSQL / utPLSQL-maven-plugin

Maven plugin for running Unit Tests with utPLSQL v3
Apache License 2.0
13 stars 10 forks source link

Getting IO Error: Got minus one from a read call #65

Closed getshravan closed 2 years ago

getshravan commented 2 years ago

I am using utplsql-maven-plugin 3.1.4 with Oracle 19c Docker image and I am getting the following error while running the test goal. Initially, I thought it was due to an incorrect DB URL, but in the same project, just before running the UTPLSQL plugin we are also running Liquibase maven plugin to install the required stored procedures and DB packages working fine, which is using the same database URL. the UTPLSQL plugin runs successfully with oracle 11g docker image, I am only seeing this issue in the 19c Docker image. Any inputs on how to troubleshoot this issue is much appreciated.

ojdbc8: 18.15.0.0 utplsql-maven-plugin:3.1.4 utPLSQL.tar.gz: v3.1.10

[ERROR] Failed to execute goal org.utplsql:utplsql-maven-plugin:3.1.4:test (default) on project installation-schema-deployment-utplsql: IO Error: Got minus one from a read call -> [Help 1]

UTPLSQL maven configuration

       <dbUrl>jdbc:oracle:thin:@localhost:49153/ORCLPDB1</dbUrl>
        <dbUser>ceradm</dbUser>
        <dbPass>masked</dbPass>
    <plugin>
                <groupId>org.utplsql</groupId>
                <artifactId>utplsql-maven-plugin</artifactId>
                <version>3.1.4</version>
                <executions>
                    <execution>
                        <goals>
                            <goal>test</goal>
                        </goals>
                        <phase>pre-integration-test</phase>
                        <configuration>
                            <paths>
                                <path>ceradm</path>
                            </paths>
                            <dbmsOutput>true</dbmsOutput>
                            <reporters>
                                <reporter>
                                    <name>UT_COVERAGE_HTML_REPORTER</name>
                                    <fileOutput>utplsql-junit-reports/utplsql_coverage_report.html</fileOutput>
                                </reporter>
                                <reporter>
                                    <name>UT_JUNIT_REPORTER</name>
                                    <fileOutput>utplsql-junit-reports/utplsql_unit_test_report.xml</fileOutput>
                                </reporter>
                            </reporters>
                        </configuration>
                    </execution>
                </executions>
            </plugin>
simasch commented 2 years ago

Can you please run

mvn test -X -e

And upload the log?

Thank you

getshravan commented 2 years ago

@simasch thanks for the quick response, please find the maven output

09:23:29  [INFO] 
09:23:29  [INFO] --- utplsql-maven-plugin:3.1.4:test (default) @ installation-schema-deployment-utplsql ---
09:23:29  [DEBUG] Dependency collection stats: {ConflictMarker.analyzeTime=164326, ConflictMarker.markTime=56788, ConflictMarker.nodeCount=99, ConflictIdSorter.graphTime=61148, ConflictIdSorter.topsortTime=31472, ConflictIdSorter.conflictIdCount=44, ConflictIdSorter.conflictIdCycleCount=0, ConflictResolver.totalTime=700905, ConflictResolver.conflictItemCount=97, DefaultDependencyCollector.collectTime=86263369, DefaultDependencyCollector.transformTime=1059769}
09:23:29  [DEBUG] org.utplsql:utplsql-maven-plugin:jar:3.1.4
09:23:29  [DEBUG]    com.sun.xml.bind:jaxb-core:jar:2.3.0.1:compile
09:23:29  [DEBUG]    javax.xml.bind:jaxb-api:jar:2.3.1:compile
09:23:29  [DEBUG]       javax.activation:javax.activation-api:jar:1.2.0:compile
09:23:29  [DEBUG]    com.sun.xml.bind:jaxb-impl:jar:2.3.1:compile
09:23:29  [DEBUG]    com.oracle.ojdbc:ojdbc8:jar:19.3.0.0:compile
09:23:29  [DEBUG]       com.oracle.ojdbc:ucp:jar:19.3.0.0:compile
09:23:29  [DEBUG]       com.oracle.ojdbc:oraclepki:jar:19.3.0.0:compile
09:23:29  [DEBUG]       com.oracle.ojdbc:osdt_cert:jar:19.3.0.0:compile
09:23:29  [DEBUG]       com.oracle.ojdbc:osdt_core:jar:19.3.0.0:compile
09:23:29  [DEBUG]       com.oracle.ojdbc:simplefan:jar:19.3.0.0:compile
09:23:29  [DEBUG]       com.oracle.ojdbc:ons:jar:19.3.0.0:compile
09:23:29  [DEBUG]    com.oracle.ojdbc:orai18n:jar:19.3.0.0:compile
09:23:29  [DEBUG]    org.apache.maven:maven-core:jar:3.5.2:compile
09:23:29  [DEBUG]       org.apache.maven:maven-settings:jar:3.5.2:compile
09:23:29  [DEBUG]       org.apache.maven:maven-settings-builder:jar:3.5.2:compile
09:23:29  [DEBUG]          org.codehaus.plexus:plexus-interpolation:jar:1.24:compile
09:23:29  [DEBUG]          org.sonatype.plexus:plexus-sec-dispatcher:jar:1.4:compile
09:23:29  [DEBUG]             org.sonatype.plexus:plexus-cipher:jar:1.4:compile
09:23:29  [DEBUG]       org.apache.maven:maven-builder-support:jar:3.5.2:compile
09:23:29  [DEBUG]       org.apache.maven:maven-repository-metadata:jar:3.5.2:compile
09:23:29  [DEBUG]       org.apache.maven:maven-artifact:jar:3.5.2:compile
09:23:29  [DEBUG]       org.apache.maven:maven-model-builder:jar:3.5.2:compile
09:23:29  [DEBUG]       org.apache.maven:maven-resolver-provider:jar:3.5.2:compile
09:23:29  [DEBUG]       org.apache.maven.resolver:maven-resolver-impl:jar:1.1.0:compile
09:23:29  [DEBUG]       org.apache.maven.resolver:maven-resolver-api:jar:1.1.0:compile
09:23:29  [DEBUG]       org.apache.maven.resolver:maven-resolver-spi:jar:1.1.0:compile
09:23:29  [DEBUG]       org.apache.maven.resolver:maven-resolver-util:jar:1.1.0:compile
09:23:29  [DEBUG]       org.apache.maven.shared:maven-shared-utils:jar:3.1.0:compile
09:23:29  [DEBUG]          commons-io:commons-io:jar:2.5:compile
09:23:29  [DEBUG]       org.eclipse.sisu:org.eclipse.sisu.plexus:jar:0.3.3:compile
09:23:29  [DEBUG]          javax.enterprise:cdi-api:jar:1.0:compile
09:23:29  [DEBUG]             javax.annotation:jsr250-api:jar:1.0:compile
09:23:29  [DEBUG]       org.eclipse.sisu:org.eclipse.sisu.inject:jar:0.3.3:compile
09:23:29  [DEBUG]       com.google.inject:guice:jar:no_aop:4.0:compile
09:23:29  [DEBUG]          aopalliance:aopalliance:jar:1.0:compile
09:23:29  [DEBUG]       com.google.guava:guava:jar:20.0:compile
09:23:29  [DEBUG]       javax.inject:javax.inject:jar:1:compile
09:23:29  [DEBUG]       org.codehaus.plexus:plexus-classworlds:jar:2.5.2:compile
09:23:29  [DEBUG]       org.codehaus.plexus:plexus-component-annotations:jar:1.7.1:compile
09:23:29  [DEBUG]       org.apache.commons:commons-lang3:jar:3.5:compile
09:23:29  [DEBUG]    org.apache.maven:maven-model:jar:3.5.2:compile
09:23:29  [DEBUG]    org.apache.maven:maven-plugin-api:jar:3.5.2:compile
09:23:29  [DEBUG]    org.codehaus.plexus:plexus-utils:jar:3.3.0:compile
09:23:29  [DEBUG] Created new class realm plugin>org.utplsql:utplsql-maven-plugin:3.1.4
09:23:29  [DEBUG] Importing foreign packages into class realm plugin>org.utplsql:utplsql-maven-plugin:3.1.4
09:23:29  [DEBUG]   Imported:  < project>com.cerner.installation:schema-deploy-parent:0.11-SNAPSHOT
09:23:29  [DEBUG] Populating class realm plugin>org.utplsql:utplsql-maven-plugin:3.1.4
09:23:29  [DEBUG]   Included: org.utplsql:utplsql-maven-plugin:jar:3.1.4
09:23:29  [DEBUG]   Included: com.sun.xml.bind:jaxb-core:jar:2.3.0.1
09:23:29  [DEBUG]   Included: javax.xml.bind:jaxb-api:jar:2.3.1
09:23:29  [DEBUG]   Included: javax.activation:javax.activation-api:jar:1.2.0
09:23:29  [DEBUG]   Included: com.sun.xml.bind:jaxb-impl:jar:2.3.1
09:23:29  [DEBUG]   Included: com.oracle.ojdbc:ojdbc8:jar:19.3.0.0
09:23:29  [DEBUG]   Included: com.oracle.ojdbc:ucp:jar:19.3.0.0
09:23:29  [DEBUG]   Included: com.oracle.ojdbc:oraclepki:jar:19.3.0.0
09:23:29  [DEBUG]   Included: com.oracle.ojdbc:osdt_cert:jar:19.3.0.0
09:23:29  [DEBUG]   Included: com.oracle.ojdbc:osdt_core:jar:19.3.0.0
09:23:29  [DEBUG]   Included: com.oracle.ojdbc:simplefan:jar:19.3.0.0
09:23:29  [DEBUG]   Included: com.oracle.ojdbc:ons:jar:19.3.0.0
09:23:29  [DEBUG]   Included: com.oracle.ojdbc:orai18n:jar:19.3.0.0
09:23:29  [DEBUG]   Included: org.codehaus.plexus:plexus-interpolation:jar:1.24
09:23:29  [DEBUG]   Included: org.sonatype.plexus:plexus-sec-dispatcher:jar:1.4
09:23:29  [DEBUG]   Included: org.sonatype.plexus:plexus-cipher:jar:1.4
09:23:29  [DEBUG]   Included: org.apache.maven:maven-builder-support:jar:3.5.2
09:23:29  [DEBUG]   Included: org.apache.maven.resolver:maven-resolver-util:jar:1.1.0
09:23:29  [DEBUG]   Included: org.apache.maven.shared:maven-shared-utils:jar:3.1.0
09:23:29  [DEBUG]   Included: commons-io:commons-io:jar:2.5
09:23:29  [DEBUG]   Included: javax.enterprise:cdi-api:jar:1.0
09:23:29  [DEBUG]   Included: org.eclipse.sisu:org.eclipse.sisu.inject:jar:0.3.3
09:23:29  [DEBUG]   Included: com.google.inject:guice:jar:no_aop:4.0
09:23:29  [DEBUG]   Included: aopalliance:aopalliance:jar:1.0
09:23:29  [DEBUG]   Included: com.google.guava:guava:jar:20.0
09:23:29  [DEBUG]   Included: org.codehaus.plexus:plexus-component-annotations:jar:1.7.1
09:23:29  [DEBUG]   Included: org.apache.commons:commons-lang3:jar:3.5
09:23:29  [DEBUG]   Included: org.codehaus.plexus:plexus-utils:jar:3.3.0
09:23:29  [DEBUG] Configuring mojo org.utplsql:utplsql-maven-plugin:3.1.4:test from plugin realm ClassRealm[plugin>org.utplsql:utplsql-maven-plugin:3.1.4, parent: sun.misc.Launcher$AppClassLoader@7852e922]
09:23:29  [DEBUG] Configuring mojo 'org.utplsql:utplsql-maven-plugin:3.1.4:test' with basic configurator -->
09:23:29  [DEBUG]   (f) ignoreFailure = false
09:23:29  [DEBUG]   (f) password = MASKED
09:23:29  [DEBUG]   (f) paths = [ceradm]
09:23:29  [DEBUG]   (f) project = MavenProject: com.cerner.installation:installation-schema-deployment-utplsql:0.11-SNAPSHOT @ /home/jenkins/agent/workspace/_DBARCHDTL-24133_DBARCHDTL-24133/installation-schema-deployment-utplsql/pom.xml
09:23:29  [DEBUG]   (s) name = UT_COVERAGE_HTML_REPORTER
09:23:29  [DEBUG]   (s) fileOutput = utplsql-junit-reports/utplsql_coverage_report.html
09:23:29  [DEBUG]   (s) name = UT_JUNIT_REPORTER
09:23:29  [DEBUG]   (s) fileOutput = utplsql-junit-reports/utplsql_unit_test_report.xml
09:23:29  [DEBUG]   (f) reporters = [org.utplsql.maven.plugin.model.ReporterParameter@6d0c2990, org.utplsql.maven.plugin.model.ReporterParameter@338e98f8]
09:23:29  [DEBUG]   (f) skipCompatibilityCheck = false
09:23:29  [DEBUG]   (f) targetDir = /home/jenkins/agent/workspace/_DBARCHDTL-24133_DBARCHDTL-24133/installation-schema-deployment-utplsql/target
09:23:29  [DEBUG]   (f) url = jdbc:oracle:thin:@localhost:49153/ORCLPDB1
09:23:29  [DEBUG]   (f) user = ceradm
09:23:29  [DEBUG] -- end configuration --
09:23:29  [DEBUG] Java Api Version = 3.1.8.546
09:24:37  [INFO] ------------------------------------------------------------------------
09:24:37  [INFO] Reactor Summary for schema-deploy-parent 0.11-SNAPSHOT:
09:24:37  [INFO] 
09:24:37  [INFO] schema-deploy-parent ............................... SUCCESS [ 29.991 s]
09:24:37  [INFO] installation-schema-deployment-it-database ......... SUCCESS [01:57 min]
09:24:37  [INFO] installation-schema-deployment-utplsql ............. FAILURE [03:32 min]
09:24:37  [INFO] ------------------------------------------------------------------------
09:24:37  [INFO] BUILD FAILURE
09:24:37  [INFO] ------------------------------------------------------------------------
09:24:37  [INFO] Total time:  06:02 min
09:24:37  [INFO] Finished at: 2022-01-10T15:24:30Z
09:24:37  [INFO] ------------------------------------------------------------------------
09:24:37  [ERROR] Failed to execute goal org.utplsql:utplsql-maven-plugin:3.1.4:test (default) on project installation-schema-deployment-utplsql: IO Error: Got minus one from a read call -> [Help 1]
09:24:37  [ERROR] 
09:24:37  [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
09:24:37  [ERROR] 
09:24:37  [ERROR] For more information about the errors and possible solutions, please read the following articles:
09:24:37  [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException
09:24:37  [ERROR] 
09:24:37  [ERROR] After correcting the problems, you can resume the build with the command
09:24:37  [ERROR]   mvn <args> -rf :installation-schema-deployment-utplsql
simasch commented 2 years ago

Unfortunately, I don't see the stacktrace.

Can you please just execute:

mvn test -e

Thank you @getshravan

getshravan commented 2 years ago

@simasch since I am seeing the above error only on my Jenkin sbuild which internally uses Jenkinsfile, I do not have the option to change the maven command (mvn test -e). Similar to set the log level for liquibase plugin, Is there any way we can specify the log level for utplsql-maven-plugin in the plugin configuration, in the pom file?

simasch commented 2 years ago

@getshravan Unfortunately this is not plugin specific. Printing the StackTrace is a Maven configuration that you have to set with -e

Why can't you change the maven execution in the Jenkinsfile?

getshravan commented 2 years ago

@simasch I just figured out a way to set the flag, please find the stack trace I got.

09:52:23  [ERROR] Failed to execute goal org.utplsql:utplsql-maven-plugin:3.1.9:test (default) on project installation-schema-deployment-utplsql: IO Error: Got minus one from a read call (CONNECTION_ID=WkQGvRG7Sd6R9qLvU2J6zg==) -> [Help 1]
09:52:23  org.apache.maven.lifecycle.LifecycleExecutionException: Failed to execute goal org.utplsql:utplsql-maven-plugin:3.1.9:test (default) on project installation-schema-deployment-utplsql: IO Error: Got minus one from a read call (CONNECTION_ID=WkQGvRG7Sd6R9qLvU2J6zg==)
09:52:23      at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:215)
09:52:23      at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:156)
09:52:23      at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:148)
09:52:23      at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject (LifecycleModuleBuilder.java:117)
09:52:23      at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject (LifecycleModuleBuilder.java:81)
09:52:23      at org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build (SingleThreadedBuilder.java:56)
09:52:23      at org.apache.maven.lifecycle.internal.LifecycleStarter.execute (LifecycleStarter.java:128)
09:52:23      at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:305)
09:52:23      at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:192)
09:52:23      at org.apache.maven.DefaultMaven.execute (DefaultMaven.java:105)
09:52:23      at org.apache.maven.cli.MavenCli.execute (MavenCli.java:957)
09:52:23      at org.apache.maven.cli.MavenCli.doMain (MavenCli.java:289)
09:52:23      at org.apache.maven.cli.MavenCli.main (MavenCli.java:193)
09:52:23      at sun.reflect.NativeMethodAccessorImpl.invoke0 (Native Method)
09:52:23      at sun.reflect.NativeMethodAccessorImpl.invoke (Unknown Source)
09:52:23      at sun.reflect.DelegatingMethodAccessorImpl.invoke (Unknown Source)
09:52:23      at java.lang.reflect.Method.invoke (Unknown Source)
09:52:23      at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced (Launcher.java:282)
09:52:23      at org.codehaus.plexus.classworlds.launcher.Launcher.launch (Launcher.java:225)
09:52:23      at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode (Launcher.java:406)
09:52:23      at org.codehaus.plexus.classworlds.launcher.Launcher.main (Launcher.java:347)
09:52:23  Caused by: org.apache.maven.plugin.MojoExecutionException: IO Error: Got minus one from a read call (CONNECTION_ID=WkQGvRG7Sd6R9qLvU2J6zg==)
09:52:23      at org.utplsql.maven.plugin.UtPlsqlMojo.execute (UtPlsqlMojo.java:190)
09:52:23      at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo (DefaultBuildPluginManager.java:137)
09:52:23      at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:210)
09:52:23      at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:156)
09:52:23      at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:148)
09:52:23      at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject (LifecycleModuleBuilder.java:117)
09:52:23      at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject (LifecycleModuleBuilder.java:81)
09:52:23      at org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build (SingleThreadedBuilder.java:56)
09:52:23      at org.apache.maven.lifecycle.internal.LifecycleStarter.execute (LifecycleStarter.java:128)
09:52:23      at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:305)
09:52:23      at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:192)
09:52:23      at org.apache.maven.DefaultMaven.execute (DefaultMaven.java:105)
09:52:23      at org.apache.maven.cli.MavenCli.execute (MavenCli.java:957)
09:52:23      at org.apache.maven.cli.MavenCli.doMain (MavenCli.java:289)
09:52:23      at org.apache.maven.cli.MavenCli.main (MavenCli.java:193)
09:52:23      at sun.reflect.NativeMethodAccessorImpl.invoke0 (Native Method)
09:52:23      at sun.reflect.NativeMethodAccessorImpl.invoke (Unknown Source)
09:52:23      at sun.reflect.DelegatingMethodAccessorImpl.invoke (Unknown Source)
09:52:23      at java.lang.reflect.Method.invoke (Unknown Source)
09:52:23      at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced (Launcher.java:282)
09:52:23      at org.codehaus.plexus.classworlds.launcher.Launcher.launch (Launcher.java:225)
09:52:23      at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode (Launcher.java:406)
09:52:23      at org.codehaus.plexus.classworlds.launcher.Launcher.main (Launcher.java:347)
09:52:23  Caused by: java.sql.SQLRecoverableException: IO Error: Got minus one from a read call (CONNECTION_ID=WkQGvRG7Sd6R9qLvU2J6zg==)
09:52:23      at oracle.jdbc.driver.T4CConnection.handleLogonNetException (T4CConnection.java:872)
09:52:23      at oracle.jdbc.driver.T4CConnection.logon (T4CConnection.java:677)
09:52:23      at oracle.jdbc.driver.PhysicalConnection.connect (PhysicalConnection.java:1039)
09:52:23      at oracle.jdbc.driver.T4CDriverExtension.getConnection (T4CDriverExtension.java:90)
09:52:23      at oracle.jdbc.driver.OracleDriver.connect (OracleDriver.java:728)
09:52:23      at oracle.jdbc.datasource.impl.OracleDataSource.getPhysicalConnection (OracleDataSource.java:561)
09:52:23      at oracle.jdbc.datasource.impl.OracleDataSource.getConnection (OracleDataSource.java:347)
09:52:23      at oracle.jdbc.datasource.impl.OracleDataSource.getConnectionInternal (OracleDataSource.java:1996)
09:52:23      at oracle.jdbc.datasource.impl.OracleDataSource.getConnection (OracleDataSource.java:322)
09:52:23      at oracle.jdbc.datasource.impl.OracleDataSource.getConnection (OracleDataSource.java:283)
09:52:23      at org.utplsql.maven.plugin.UtPlsqlMojo.createConnection (UtPlsqlMojo.java:223)
09:52:23      at org.utplsql.maven.plugin.UtPlsqlMojo.execute (UtPlsqlMojo.java:140)
09:52:23      at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo (DefaultBuildPluginManager.java:137)
09:52:23      at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:210)
09:52:23      at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:156)
09:52:23      at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:148)
09:52:23      at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject (LifecycleModuleBuilder.java:117)
09:52:23      at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject (LifecycleModuleBuilder.java:81)
09:52:23      at org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build (SingleThreadedBuilder.java:56)
09:52:23      at org.apache.maven.lifecycle.internal.LifecycleStarter.execute (LifecycleStarter.java:128)
09:52:23      at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:305)
09:52:23      at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:192)
09:52:23      at org.apache.maven.DefaultMaven.execute (DefaultMaven.java:105)
09:52:23      at org.apache.maven.cli.MavenCli.execute (MavenCli.java:957)
09:52:23      at org.apache.maven.cli.MavenCli.doMain (MavenCli.java:289)
09:52:23      at org.apache.maven.cli.MavenCli.main (MavenCli.java:193)
09:52:23      at sun.reflect.NativeMethodAccessorImpl.invoke0 (Native Method)
09:52:23      at sun.reflect.NativeMethodAccessorImpl.invoke (Unknown Source)
09:52:23      at sun.reflect.DelegatingMethodAccessorImpl.invoke (Unknown Source)
09:52:23      at java.lang.reflect.Method.invoke (Unknown Source)
09:52:23      at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced (Launcher.java:282)
09:52:23      at org.codehaus.plexus.classworlds.launcher.Launcher.launch (Launcher.java:225)
09:52:23      at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode (Launcher.java:406)
09:52:23      at org.codehaus.plexus.classworlds.launcher.Launcher.main (Launcher.java:347)
09:52:23  Caused by: oracle.net.ns.NetException: Got minus one from a read call (CONNECTION_ID=WkQGvRG7Sd6R9qLvU2J6zg==)
09:52:23      at oracle.net.ns.NSProtocolNIO.doSocketRead (NSProtocolNIO.java:1121)
09:52:23      at oracle.net.ns.NIOPacket.readHeader (NIOPacket.java:267)
09:52:23      at oracle.net.ns.NIOPacket.readPacketFromSocketChannel (NIOPacket.java:199)
09:52:23      at oracle.net.ns.NIOPacket.readFromSocketChannel (NIOPacket.java:141)
09:52:23      at oracle.net.ns.NIOPacket.readFromSocketChannel (NIOPacket.java:114)
09:52:23      at oracle.net.ns.NIONSDataChannel.readDataFromSocketChannel (NIONSDataChannel.java:98)
09:52:23      at oracle.net.ano.AnoCommNIO.p (Unknown Source)
09:52:23      at oracle.net.ano.AnoCommNIO.e (Unknown Source)
09:52:23      at oracle.net.ano.AnoComm.readUB4 (Unknown Source)
09:52:23      at oracle.net.ano.Ano.c (Unknown Source)
09:52:23      at oracle.net.ano.Ano.negotiation (Unknown Source)
09:52:23      at oracle.net.ns.NSProtocol.initializeAno (NSProtocol.java:617)
09:52:23      at oracle.net.ns.NSProtocol.connect (NSProtocol.java:359)
09:52:23      at oracle.jdbc.driver.T4CConnection.connect (T4CConnection.java:1969)
09:52:23      at oracle.jdbc.driver.T4CConnection.logon (T4CConnection.java:642)
09:52:23      at oracle.jdbc.driver.PhysicalConnection.connect (PhysicalConnection.java:1039)
09:52:23      at oracle.jdbc.driver.T4CDriverExtension.getConnection (T4CDriverExtension.java:90)
09:52:23      at oracle.jdbc.driver.OracleDriver.connect (OracleDriver.java:728)
09:52:23      at oracle.jdbc.datasource.impl.OracleDataSource.getPhysicalConnection (OracleDataSource.java:561)
09:52:23      at oracle.jdbc.datasource.impl.OracleDataSource.getConnection (OracleDataSource.java:347)
09:52:23      at oracle.jdbc.datasource.impl.OracleDataSource.getConnectionInternal (OracleDataSource.java:1996)
09:52:23      at oracle.jdbc.datasource.impl.OracleDataSource.getConnection (OracleDataSource.java:322)
09:52:23      at oracle.jdbc.datasource.impl.OracleDataSource.getConnection (OracleDataSource.java:283)
09:52:23      at org.utplsql.maven.plugin.UtPlsqlMojo.createConnection (UtPlsqlMojo.java:223)
09:52:23      at org.utplsql.maven.plugin.UtPlsqlMojo.execute (UtPlsqlMojo.java:140)
09:52:23      at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo (DefaultBuildPluginManager.java:137)
09:52:23      at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:210)
09:52:23      at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:156)
09:52:23      at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:148)
09:52:23      at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject (LifecycleModuleBuilder.java:117)
09:52:23      at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject (LifecycleModuleBuilder.java:81)
09:52:23      at org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build (SingleThreadedBuilder.java:56)
09:52:23      at org.apache.maven.lifecycle.internal.LifecycleStarter.execute (LifecycleStarter.java:128)
09:52:23      at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:305)
09:52:23      at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:192)
09:52:23      at org.apache.maven.DefaultMaven.execute (DefaultMaven.java:105)
09:52:23      at org.apache.maven.cli.MavenCli.execute (MavenCli.java:957)
09:52:23      at org.apache.maven.cli.MavenCli.doMain (MavenCli.java:289)
09:52:23      at org.apache.maven.cli.MavenCli.main (MavenCli.java:193)
09:52:23      at sun.reflect.NativeMethodAccessorImpl.invoke0 (Native Method)
09:52:23      at sun.reflect.NativeMethodAccessorImpl.invoke (Unknown Source)
09:52:23      at sun.reflect.DelegatingMethodAccessorImpl.invoke (Unknown Source)
09:52:23      at java.lang.reflect.Method.invoke (Unknown Source)
09:52:23      at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced (Launcher.java:282)
09:52:23      at org.codehaus.plexus.classworlds.launcher.Launcher.launch (Launcher.java:225)
09:52:23      at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode (Launcher.java:406)
09:52:23      at org.codehaus.plexus.classworlds.launcher.Launcher.main (Launcher.java:347)
09:52:23  [ERROR] 
09:52:23  [ERROR] 
09:52:23  [ERROR] For more information about the errors and possible solutions, please read the following articles:
09:52:23  [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException
09:52:23  [ERROR] 
09:52:23  [ERROR] After correcting the problems, you can resume the build with the command
09:52:23  [ERROR]   mvn <args> -rf :installation-schema-deployment-utplsql
simasch commented 2 years ago

@getshravan And you are sure that you can connect to the database from the Jenkins server?

getshravan commented 2 years ago

@simasch yes, I am very sure I am able to connect to database from Jenkins server. Because just before utplsql runs, the liquibase maven plugin connects to the same database (with same db url) and installs all the required DB packages. It is only when UTPLSQL test starts running, I am getting this error.

getshravan commented 2 years ago

Could this error be related to https://github.com/oracle/docker-images/issues/1663? this post suggests setting oracle.net.disableOob=true in the JDBC connection parameter. PS: Though I tried using ojdbc8 v less than 19.3.0.0 and got the same error on the 19c container.

simasch commented 2 years ago

As i see from the stack trace the exception happens when trying to connect.

If you're using the same driver and the same URL the connection should also fail with Liquibase

getshravan commented 2 years ago

@simasch yes, agree with you, but that was not the case in this scenario, however, I was able to figure out the fix, as suggested in my previous comment setting the oracle.net.disableOob=true in SQLNET.ORA (inside 19c docker DB) resolved the issue.

simasch commented 2 years ago

Thanks for your update. I'm closing the issue see this nothing I can fix in the plugin