Uploaded image for project: 'Red Hat Fuse'
  1. Red Hat Fuse
  2. ENTESB-13431

(Fuse Online) SQL connector exceptions are visible only in DEBUG mode

    XMLWordPrintable

Details

    • Bug
    • Status: Done
    • Blocker
    • Resolution: Done
    • fuse-7.6-GA
    • fuse-7.7-GA
    • Fuse Online

    Description

      Some SQL connector exceptions are shown only in DEBUG mode like the following exceptions:

      • SQLErrorCodeSQLExceptionTranslator
      • com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException

      The integration pod shows a SUCCESS in the activity and the no ERROR in the log, we should turn the integration pods to DEBUG, to understand the root cause.

      e.g;

      2020-04-09 09:32:21.853 DEBUG 1 --- [  XNIO-3 task-1] s.j.s.SQLErrorCodeSQLExceptionTranslator : Translating SQLException with SQL state '23000', error code '1062', message [Duplicate entry '150' for key 'PRIMARY']; SQL was [] for task [PreparedStatementCallback]
      
      2020-04-09 09:01:03.062 DEBUG 1 --- [  XNIO-3 task-1] org.apache.camel.processor.Pipeline      : Message exchange has failed: so breaking out of pipeline for exchange: Exchange[i-M4T9wxMDE_2GTdPVnekz] Exception: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: INSERT command denied to user 'debezium'@'10.128.2.31' for table 'products' 
      

      Attachments

        Activity

          People

            kstam@redhat.com Kurt Stam
            rhn-support-aboucham Abel Bouchama
            Stefan Veres Stefan Veres
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: