3 Replies Latest reply on Apr 14, 2015 9:20 AM by rareddy

    TEIID11010 error stops vdb deployment and JBoss bootup is stalled

    masuman82

      In one of our customer environments a TEIID11010 error was thrown while loading the metadata due to which vdb deployment stopped and JBoss boot up was also halted.

       

      Our translator has a safety mechanism to catch such errors and continue loading the metadata of the next model.

      We overrided the getMetadata method to handle the exception.

       

      @Override    
      public void getMetadata(final MetadataFactory metadataFactory, final Object conn) throws TranslatorException
       {
              try {
                  super.getMetadata(metadataFactory, conn);       
             } catch (final Exception e)  {       
                      final Table dummyTable = metadataFactory.addTable("dummyTable");     
                      metadataFactory.addColumn("dummycolumn",  DataTypeManager.DefaultDataTypes.STRING,dummyTable); 
                      logger.warn("Error on getMetaData call", e);
              }  
        }  
      

       

      We observed that for certain errors like TEIID11018 (no active connection) this approach works. The metadata of the remaining models load and eventually vdb is set to active.

       

      But when a TEIID11010 error occurs (TEIID11010 java.sql.SQLException: ca.datacom.db.DBSQLException)  everything stops abruptly as if something is stuck,

      even JBoss bootup is also halted.

       

      Is there any fix or workaround to overcome this issue. We are using JBoss 7.1.1 and teiid  8.1.

       

      Thanks, M.A.Suman.

        • 1. Re: TEIID11010 error stops vdb deployment and JBoss bootup is stalled
          rareddy

          The metadata load does happen async in another thread, so getting struck seems like some kind of timing issue. Can you take thread dump in that case and provide us with that?

          • 2. Re: TEIID11010 error stops vdb deployment and JBoss bootup is stalled
            masuman82

            Unfortunately we do not have a thread dump, our customer only gave us the log files. We only know that some maintenance activity was being carried out on their database servers when this problem occurred.

            Later when JBoss was restarted it came up successfully.

             

            Assuming TEIID11010 occurs only when something is logically wrong and needs to be rectified manually,

            we are evaluating a solution to programatically terminate jboss in case TEIID11010 occurs during metadata loading.

             

            Is our approach recommended or is it a bad idea?

            • 3. Re: TEIID11010 error stops vdb deployment and JBoss bootup is stalled
              rareddy

              Terminating the EAP seems little harsh, but I do not know your case, how critical that. Ideally you want to figure out what the that ca.datacom.db.DBSQLException is why it is happening and why does it halt the EAP boot up? As I said, since it is async only that service needs to be in error state everything else *should* work. But apparently this is making whole VM suspended. So, I say  more debugging is needed.