2 Replies Latest reply: Sep 3, 2012 10:14 AM by 598001 RSS

    TT7013

    Pratheej
      Hi,

      For the sample table below,

           create table DG.temp (
           SRCID CHAR(30 BYTE) NOT NULL,
           TXNID INTEGER NOT NULL,
           TARGETSUBSYSTEMID TINYINT,
           PAYLOAD VARBINARY(32768) NOT INLINE NOT NULL,
           INSERTIONTIMESTAMP BIGINT NOT NULL,
           FEATUREID SMALLINT NOT NULL,
           RESPONSE_ADDR VARCHAR(64 BYTE) INLINE,
           TTL INTEGER,
           primary key (SRCID, TXNID, INSERTIONTIMESTAMP));
           
           create index DG.APPLICATIONINTERFACE_STT_IDX on DG.temp
           (SRCID, TXNID, TARGETSUBSYSTEMID);
      1325244948, 3003 );


      When Im inserting a record, it is failing with following error.


      =======================================================================================================================
      7013: Error while scanning SQL statement: input buffer overflow - string literals and tokens are limited to 16384 bytes on this platform - before or at: "0xaced000573720037636f6d2e6b6f6469616b2e6672616d65776f726b732e6d6573736167696e672e636f6d6d6f6e2e64746f2e4b6e4a4d534d657373616765", character position: 125
      ..., FEATUREID ) VALUES ('192.168.5.131', 26428, 0xaced000573720037636...
      ^^^^^^^^^^^^^^^^^^^^^
      The command failed.
      =======================================================================================================================


      The number of characters for the input sql of PAYLOAD column was around 24K.
      For the testing purpose , when I reduced it to around 16K, the insert was succesful.



      The TT documentation says as follows:

           On a Windows or Linux system, the scanner detected an error in the SQL statement. The text of the error found is included in the message. An "input buffer overflow" error text indicates that the length of a string literal has exceeded a platform-dependent internal buffer limit. Any other error text indicates an unexpected internal error condition.
           
           

      Following is my system information:

      [root@MC_1_183 kodiak]# uname -a
      Linux MC_1_183 2.6.32-71.7.1.el6.x86_64 #1 SMP Wed Oct 27 03:44:59 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux
      [root@MC_1_183 kodiak]# free -m
      total used free shared buffers cached
      Mem: 2333 2250 82 0 155 1453
      -/+ buffers/cache: 641 1691
      Swap: 4094 179 3915
      [root@MC_1_183 kodiak]#


      Can you please let me know how to increase the "platform-dependent internal buffer limit" so that I can insert the actual value ?

      Regards
      Pratheej