SAP Knowledge Base Article - Preview

2943652 - Signal 11 in s_execclearvar() when Java client executes INSERT using PreparedStatement - SAP ASE

Symptom

  • A Java client executes an INSERT statement using PreparedStatement as:

PreparedStatement pstmt = conn.prepareStatement("insert my_table (data_id,batch_id,router_id,create_time) values (?,?,?,getdate()) 354!");
connecting to jdbc:sybase:Tds:localhost:5000/tempdb?DYNAMIC_PREPARE=FALSE

  • And hits an exception:

com.sybase.jdbc4.jdbc.SybSQLException: Incorrect syntax near '354'.

at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4119)
at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3235)
at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78)
at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:294)
at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:276)
at com.sybase.jdbc4.jdbc.SybStatement.updateLoop(SybStatement.java:2750)
at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:2734)
at com.sybase.jdbc4.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:330)
at br_insert.main(br_insert.java:32)

  • ASE errorlog reports an "infected with signal 11" error in the module s_execclearvar() together with a stack trace:

Current process (0x6f6d0f40) infected with signal 11 (SIGSEGV)
Address 0x0x00000000011dac27 (s_execclearvar+0x27), siginfo (code, address) = (1, 0x0x0000000000000004)

  • The stack trace includes the functions:

s_execclearvar
sequencer
tdsrecv_language

  Note: A complete stack trace is available under Attachments.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 SP137-SP139
  • SAP Adaptive Server Enterprise (ASE) 16.0 SP02 pre-PL06
  • SAP Adaptive Server Enterprise (ASE) 16.0 SP03 pre-PL02
  • Java client

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

CR805654, CR#805654, 805654, CR809395, CR#809395 809395, SEGV, segmentation, storage, access, violation, fault, segfault, kisignal, stacktrace, registers, prepared, statement

      , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , Bug Filed

      About this page

      This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

      Search for additional results

      Visit SAP Support Portal's SAP Notes and KBA Search.