2 answers
- 210
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.
Add your comment... - 10-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.
Add your comment...
Now when I deploy an instance of the demoVFW, there is an error as follows.![](/download/attachments/4719458/image2017-5-9_16-6-23.png?version=1&modificationDate=1494385980000&api=v2)
But It is OK in the past. It seems as a database problem. Any ideas about how to debug it?
you would need the logs from the mso docker container. Steve Smokowski Christophe Closset can help you with that.
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?