Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-4963

ORA-04030: out of process memory when trying to allocate 65568 bytes (Logminer LCR c,krvxrib:buffer)

    XMLWordPrintable

Details

    Description

      There was an oom error occured when I monitored 100 tables by debezium.

      2022-03-20 07:39:04,699 ERROR io.debezium.pipeline.ErrorHandler                            [] - Producer failure
      java.sql.SQLException: ORA-04030: out of process memory when trying to allocate 65568 bytes (Logminer LCR c,krvxrib:buffer)
      
      	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) ~[blob_p-f8a0accd69e4a99f1eb2c970532020f0a4bfa8f9-238e6ddaabbe2f02674a1c2d4ce98b00:?]
      	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) ~[blob_p-f8a0accd69e4a99f1eb2c970532020f0a4bfa8f9-238e6ddaabbe2f02674a1c2d4ce98b00:?]
      	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) ~[blob_p-f8a0accd69e4a99f1eb2c970532020f0a4bfa8f9-238e6ddaabbe2f02674a1c2d4ce98b00:?]
      	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:553) ~[blob_p-f8a0accd69e4a99f1eb2c970532020f0a4bfa8f9-238e6ddaabbe2f02674a1c2d4ce98b00:?]
      	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269) ~[blob_p-f8a0accd69e4a99f1eb2c970532020f0a4bfa8f9-238e6ddaabbe2f02674a1c2d4ce98b00:?]
      	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) ~[blob_p-f8a0accd69e4a99f1eb2c970532020f0a4bfa8f9-238e6ddaabbe2f02674a1c2d4ce98b00:?]
      	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270) ~[blob_p-f8a0accd69e4a99f1eb2c970532020f0a4bfa8f9-238e6ddaabbe2f02674a1c2d4ce98b00:?]
      	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91) ~[blob_p-f8a0accd69e4a99f1eb2c970532020f0a4bfa8f9-238e6ddaabbe2f02674a1c2d4ce98b00:?]
      	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970) ~[blob_p-f8a0accd69e4a99f1eb2c970532020f0a4bfa8f9-238e6ddaabbe2f02674a1c2d4ce98b00:?]
      	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1012) ~[blob_p-f8a0accd69e4a99f1eb2c970532020f0a4bfa8f9-238e6ddaabbe2f02674a1c2d4ce98b00:?]
      	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) ~[blob_p-f8a0accd69e4a99f1eb2c970532020f0a4bfa8f9-238e6ddaabbe2f02674a1c2d4ce98b00:?]
      	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666) ~[blob_p-f8a0accd69e4a99f1eb2c970532020f0a4bfa8f9-238e6ddaabbe2f02674a1c2d4ce98b00:?]
      	at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426) ~[blob_p-f8a0accd69e4a99f1eb2c970532020f0a4bfa8f9-238e6ddaabbe2f02674a1c2d4ce98b00:?]
      	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3713) ~[blob_p-f8a0accd69e4a99f1eb2c970532020f0a4bfa8f9-238e6ddaabbe2f02674a1c2d4ce98b00:?]
      	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1167) ~[blob_p-f8a0accd69e4a99f1eb2c970532020f0a4bfa8f9-238e6ddaabbe2f02674a1c2d4ce98b00:?]
      	at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:184) ~[blob_p-f8a0accd69e4a99f1eb2c970532020f0a4bfa8f9-238e6ddaabbe2f02674a1c2d4ce98b00:?]
      	at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:152) ~[blob_p-f8a0accd69e4a99f1eb2c970532020f0a4bfa8f9-238e6ddaabbe2f02674a1c2d4ce98b00:?]
      	at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:119) ~[blob_p-f8a0accd69e4a99f1eb2c970532020f0a4bfa8f9-238e6ddaabbe2f02674a1c2d4ce98b00:?]
      	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_281]
      	at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_281]
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_281]
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_281]
      	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_281]
      Caused by: oracle.jdbc.OracleDatabaseException: ORA-04030: out of process memory when trying to allocate 65568 bytes (Logminer LCR c,krvxrib:buffer) 
      
      	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513) ~[blob_p-f8a0accd69e4a99f1eb2c970532020f0a4bfa8f9-238e6ddaabbe2f02674a1c2d4ce98b00:?]
      	... 22 more

      Attachments

        Activity

          People

            ccranfor@redhat.com Chris Cranford
            jian.zhu.86 jian zhu
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: