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

Oracle test starts failing (listener refused the connection) #106

Closed
javiertuya opened this issue Nov 30, 2023 · 1 comment
Closed

Oracle test starts failing (listener refused the connection) #106

javiertuya opened this issue Nov 30, 2023 · 1 comment
Assignees
Labels
regression Something stopped working

Comments

@javiertuya
Copy link
Contributor

javiertuya commented Nov 30, 2023

Latest Combined dependency updates (2023-11-25) #100 ran successfully on main: https://github.com/giis-uniovi/qacover/actions/runs/6987984114, Suddenly some unrelated udpates of other components started failing the oracle job. After rerunning the above update, it failed too. It seems to be a problem with the docker image, memory resources, etc...

Error:  Tests run: 7, Failures: 0, Errors: 7, Skipped: 0, Time elapsed: 0.054 s <<< FAILURE! -- in test4giis.qacover.oracle.TestOracleExecute
Error:  test4giis.qacover.oracle.TestOracleExecute.testExecuteUpdateNoParameters -- Time elapsed: 0.034 s <<< ERROR!
giis.qacover.portable.QaCoverException: Schema Exception
	at test4giis.qacoverapp.AppBase.executeUpdateNative(AppBase.java:59)
	at test4giis.qacover.TestExecute.setUpTestData(TestExecute.java:41)
	at test4giis.qacover.TestExecute.setUp(TestExecute.java:29)
...
Caused by: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
  (CONNECTION_ID=C/JtIjguQ8yLLqJwvPKz5g==)
	at oracle.jdbc.driver.T4CConnection.handleLogonNetException(T4CConnection.java:895)
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:700)
	at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:1048)
	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:90)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:733)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:649)
	at java.sql.DriverManager.getConnection(DriverManager.java:664)
	at java.sql.DriverManager.getConnection(DriverManager.java:247)
	at test4giis.qacoverapp.ConnectionFactory.getNativeConnection(ConnectionFactory.java:73)
	at test4giis.qacoverapp.AppBase.executeUpdateNative(AppBase.java:54)
	... 33 more
Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
  (CONNECTION_ID=C/JtIjguQ8yLLqJwvPKz5g==)
	at oracle.net.ns.NSProtocolNIO.createRefusePacketException(NSProtocolNIO.java:833)
	at oracle.net.ns.NSProtocolNIO.handleConnectPacketResponse(NSProtocolNIO.java:405)
	at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:[216](https://github.com/giis-uniovi/qacover/actions/runs/6987984114/job/19169156374#step:9:217))
	at oracle.net.ns.NSProtocol.connect(NSProtocol.java:355)
	at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:2467)
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:659)
	... 41 more
@javiertuya javiertuya added the regression Something stopped working label Nov 30, 2023
@javiertuya javiertuya changed the title Oracle test starts failing Oracle test starts failing (listener refused the connection) Nov 30, 2023
@javiertuya javiertuya self-assigned this Nov 30, 2023
@javiertuya
Copy link
Contributor Author

It seems to be fixed after migrating oracle to 21.3.0 cbec5fe

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

No branches or pull requests

1 participant