4 Replies Latest reply on Mar 11, 2019 5:38 AM by JJ Salinas

    ORDS standalone keeps crashing

    JJ Salinas

      Does anyone have issues with ORDS in standalone mode? I have the latest version (18.3.0.270.1456,   October 3, 2018) , it keeps crashing randomly and had to start it manually.

      I've enabled debug logging, access logging, double checked parameters in ords_params.properties, standalone.properties, defaults.xml and did not find any clues. ords.war validate doesn't find any error either.

      Something worth mentioning is that when I run ords.war with help or validation commands, the process also crashes.

       

      Thank you

        • 1. Re: ORDS standalone keeps crashing
          thatJeffSmith-Oracle

          What errors do you see when it crashes?

          • 2. Re: ORDS standalone keeps crashing
            JJ Salinas

            No errors at the console, (I'm running in backround and redirecting console to a log file)

             

            Mar 06, 2019 5:26:30 PM

            INFO: Oracle REST Data Services initialized

            Oracle REST Data Services version : 18.4.0.r3541002

            Oracle REST Data Services server info: jetty/9.4.z-SNAPSHOT

             

             

            2019-03-06 17:26:30.212:INFO:oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@26be92ad{/ords,null,AVAILABLE}

            2019-03-06 17:26:30.213:INFO:oejsh.ContextHandler:main: Started o.e.j.s.h.ContextHandler@4c70fda8{/,null,AVAILABLE}

            2019-03-06 17:26:30.218:INFO:oejsh.ContextHandler:main: Started o.e.j.s.h.ContextHandler@224edc67{/i,null,AVAILABLE}

            2019-03-06 17:26:30.229:INFO:oejs.AbstractNCSARequestLog:main: Opened /opt/oracle/ords/logs/ords-access-2019_03_06.log

            2019-03-06 17:26:30.267:INFO:oejs.AbstractConnector:main: Started ServerConnector@4ded371c{HTTP/1.1,[http/1.1, h2c]}{0.0.0.0:8080}

            2019-03-06 17:26:30.268:INFO:oejs.Server:main: Started @8302ms

            2019-03-06 17:31:24.844:INFO::main: Logging initialized @2478ms to org.eclipse.jetty.util.log.StdErrLog

            Mar 06, 2019 5:31:24 PM

            INFO: HTTP and HTTP/2 cleartext listening on port: 8080

            Mar 06, 2019 5:31:25 PM

            INFO: The document root is serving static resources located in: /opt/oracle/ords/ords/standalone/doc_root

            2019-03-06 17:31:25.906:INFO:oejs.Server:main: jetty-9.4.z-SNAPSHOT; built: 2018-05-03T15:56:21.710Z; git: daa59876e6f384329b122929e70a80934569428c; jvm 1.8.0_201-b09

            2019-03-06 17:31:25.941:INFO:oejs.session:main: DefaultSessionIdManager workerName=node0

            2019-03-06 17:31:25.941:INFO:oejs.session:main: No SessionScavenger set, using defaults

            2019-03-06 17:31:25.942:INFO:oejs.session:main: node0 Scavenging every 600000ms

            Mar 06, 2019 5:31:27 PM

            INFO: Configuration properties for: |apex|rt|

            cache.caching=false

            cache.directory=/tmp/apex/cache

            cache.duration=days

            cache.expiration=7

            cache.maxEntries=500

            cache.monitorInterval=60

            cache.procedureNameList=

            cache.type=lru

            db.hostname=

            db.password=******

            db.port=1521

            db.servicename=XEPDB1

            db.username=APEX_REST_PUBLIC_USER

            debug.debugger=true

            debug.printDebugToScreen=true

            error.keepErrorMessages=true

            error.maxEntries=50

            jdbc.DriverType=thin

            jdbc.InactivityTimeout=1800

            jdbc.InitialLimit=6

            jdbc.MaxConnectionReuseCount=1000

            jdbc.MaxLimit=20

            jdbc.MaxStatementsLimit=10

            jdbc.MinLimit=1

            jdbc.statementTimeout=900

            log.logging=false

            log.maxEntries=50

            misc.compress=

            misc.defaultPage=apex

            resource.templates.enabled=true

            security.disableDefaultExclusionList=false

            security.maxEntries=2000

            security.requestValidationFunction=wwv_flow_epg_include_modules.authorize

            security.validationFunctionType=plsql

             

             

            Mar 06, 2019 5:31:28 PM

            INFO: Configuration properties for: |apex|pu|

            cache.caching=false

            cache.directory=/tmp/apex/cache

            cache.duration=days

            cache.expiration=7

            cache.maxEntries=500

            cache.monitorInterval=60

            cache.procedureNameList=

            cache.type=lru

            db.hostname=

            db.password=******

            db.port=1521

            db.servicename=XEPDB1

            db.username=ORDS_PUBLIC_USER

            debug.debugger=true

            debug.printDebugToScreen=true

            error.keepErrorMessages=true

            error.maxEntries=50

            jdbc.DriverType=thin

            jdbc.InactivityTimeout=1800

            jdbc.InitialLimit=6

            jdbc.MaxConnectionReuseCount=1000

            jdbc.MaxLimit=20

            jdbc.MaxStatementsLimit=10

            jdbc.MinLimit=1

            jdbc.statementTimeout=900

            log.logging=false

            log.maxEntries=50

            misc.compress=

            misc.defaultPage=apex

            resource.templates.enabled=true

            security.disableDefaultExclusionList=false

            security.maxEntries=2000

            security.requestValidationFunction=wwv_flow_epg_include_modules.authorize

            security.validationFunctionType=plsql

             

             

            Mar 06, 2019 5:31:28 PM

            INFO: Configuration properties for: |apex|al|

            cache.caching=false

            cache.directory=/tmp/apex/cache

            cache.duration=days

            cache.expiration=7

            cache.maxEntries=500

            cache.monitorInterval=60

            cache.procedureNameList=

            cache.type=lru

            db.hostname=

            db.password=******

            db.port=1521

            db.servicename=XEPDB1

            db.username=APEX_LISTENER

            debug.debugger=true

            debug.printDebugToScreen=true

            error.keepErrorMessages=true

            error.maxEntries=50

            jdbc.DriverType=thin

            jdbc.InactivityTimeout=1800

            jdbc.InitialLimit=6

            jdbc.MaxConnectionReuseCount=1000

            jdbc.MaxLimit=20

            jdbc.MaxStatementsLimit=10

            jdbc.MinLimit=1

            jdbc.statementTimeout=900

            log.logging=false

            log.maxEntries=50

            misc.compress=

            misc.defaultPage=apex

            resource.templates.enabled=true

            security.disableDefaultExclusionList=false

            security.maxEntries=2000

            security.requestValidationFunction=wwv_flow_epg_include_modules.authorize

            security.validationFunctionType=plsql

             

             

            Mar 06, 2019 5:31:30 PM

            INFO: Configuration properties for: |apex||

            cache.caching=false

            cache.directory=/tmp/apex/cache

            cache.duration=days

            cache.expiration=7

            cache.maxEntries=500

            cache.monitorInterval=60

            cache.procedureNameList=

            cache.type=lru

            db.hostname=

            db.password=******

            db.port=1521

            db.servicename=XEPDB1

            db.username=APEX_PUBLIC_USER

            debug.debugger=true

            debug.printDebugToScreen=true

            error.keepErrorMessages=true

            error.maxEntries=50

            jdbc.DriverType=thin

            jdbc.InactivityTimeout=1800

            jdbc.InitialLimit=6

            jdbc.MaxConnectionReuseCount=1000

            jdbc.MaxLimit=20

            jdbc.MaxStatementsLimit=10

            jdbc.MinLimit=1

            jdbc.statementTimeout=900

            log.logging=false

            log.maxEntries=50

            misc.compress=

            misc.defaultPage=apex

            resource.templates.enabled=true

            security.disableDefaultExclusionList=false

            security.maxEntries=2000

            security.requestValidationFunction=wwv_flow_epg_include_modules.authorize

            security.validationFunctionType=plsql

             

             

            And that's it, when it crashes it shows nothing at the log.

             

            Thank you

            • 3. Re: ORDS standalone keeps crashing
              thatJeffSmith-Oracle

              Then it's not crashing, the jvm is

               

              Otherwise there would be an error stack

              • 4. Re: ORDS standalone keeps crashing
                JJ Salinas

                Thank you, you are rigth,the jvm was crashing, the errors were in /var/log/messages due to low memory. Increased RAM from 2GB to 4GB and problem is solved.