Failed to Deploy an instance of the demoVFW

 
1
0
-1

Now when I deploy an instance of the demoVFW, there is an error as follows.

But It is OK in  the past. It  seems as a database problem. Any ideas about how to debug it?

  1. Daniel Rose

    you would need the logs from the mso docker container. Steve Smokowski Christophe Closset can help you with that.

  2. zhang ab

    MSO log:

    (2017-05-11 01:44:32,903 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-6) SQL Error: 1054, SQLState: 42S22

    2017-05-11 01:44:32,903 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-6) Unknown column 'this_.REQUESTOR_ID' in 'field list'

    Query is: select this_.REQUEST_ID as REQUEST_1_0_0_, this_.CLIENT_REQUEST_ID as ...)


    It seem like a sql question? 

CommentAdd your comment...

2 answers

  1.  
    2
    1
    0

    The db schema has been updated recently in the latest commit, and this field 'REQUESTOR_ID' is part of the new stuffs, therefore i think you should probably kill the mariadb container and create a new one (you will loose your data). Any mariadb restart won't help to update the new field. MSO does not have any update SQL files for now, the db should always be created from scratch.

    Another option is to create the missing fields manually, you could do a diff between the SQL files located in the repo docker-config.git.


      CommentAdd your comment...
    1.  
      1
      0
      -1

      MSO log:

      .

      It is unuseful to resolve this question when I restart msd DB docker.

      @Steve Smokowski   @Christophe Closset, Do you have any good solution? @ Daniel Rose, Thanks.

        CommentAdd your comment...