Uploaded image for project: 'Apache Trafodion (Retired)'
  1. Apache Trafodion (Retired)
  2. TRAFODION-1173

LP Bug: 1444088 - Hybrid Query Cache: sqlci may err with JRE SIGSEGV.



    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • 2.4
    • sql-cmp
    • None


      In sqlci, with HQC on and HQC_LOG specified, a prepared statement was followed with:

      >>--interval 47, same selectivity as interval 51
      >>--interval 47 [jvFN3&789 - jyBT!]789)
      >>--expect = nothing in hqc log; SQC hit
      >>prepare XX from select * from f00 where colchar = 'jyBT!]789';

      1. A fatal error has been detected by the Java Runtime Environment:
      2. SIGSEGV (0xb) at pc=0x00007ffff5d80595, pid=2708, tid=140737353866272
      3. JRE version: Java(TM) SE Runtime Environment (7.0_75-b13) (build 1.7.0_75-b13)
      4. Java VM: Java HotSpot(TM) 64-Bit Server VM (24.75-b04 mixed mode linux-amd64 compressed oops)
      5. Problematic frame:
      6. C [libstdc++.so.6+0x91595] std::ostream::sentry::sentry(std::ostream&)+0x25
      7. Core dump written. Default location: /opt/home/trafodion/thaiju/HQC/equal_char/core or core.2708
      8. An error report file with more information is saved as:
      9. /opt/home/trafodion/thaiju/HQC/equal_char/hs_err_pid2708.log
      10. If you would like to submit a bug report, please visit:
      11. http://bugreport.sun.com/bugreport/crash.jsp
      12. The crash happened outside the Java Virtual Machine in native code.
      13. See problematic frame for where to report the bug.

      No core file found under /opt/home/trafodion/thaiju/HQC/equal_char. But a hs_err_pid2708.log file was generated (included in attached, to_repro.tar). Problem does not reproduce if I explicitly turn off HQC.

      To reproduce:
      1. download and untar attachment, to_repro.tar
      1. in a sqlci session, obey setup_char.sql (from tar file)
      2. in a new sqlci session, obey equal_char.sql (from tar file)




            suresh_subbiah Suresh Subbiah
            thaiju Julie Thai
            0 Vote for this issue
            1 Start watching this issue