'Overwriting mode not activated' in the operational database during model deployment

NeelNeel Member Posts: 4 Contributor I
edited January 2020 in Help
Hi All,

I am trying to deploy a rapidminer auto-model into a remote rapidminer server (9.5). The rapidminer server uses a docker based postgres database in the backend. When I am trying to deploy an auto-model into the server it complains with "problem with logging initialization: Table with name 'rm_mdm_locations' already exists and overwriting mode is not activated. Please change table name or activate overwriting mode". I feel manually changing the table name in the operational database is not a solution. Has anyone faced this problem? 

Best Answer

  • Options
    IngoRMIngoRM Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, Community Manager, RMResearcher, Member, University Professor Posts: 1,751 RM Founder
    Solution Accepted
    Hmm, nope, never saw that one, sorry.  It looks like the deployments try to initialize the DB again.  This should (obviously) not happen - after it has been initialized the first time, the next time should just deploy and not recreate the tables.  I wonder if this could be connected to the fact that the DB is dockerized?  Did you try with a plain vanilla DB first?
    Another thought I had: we had some more trouble with Postgres for deployments in the early days, MySQL worked a bit better.  If it is possible to switch (for a test at least), this may be another thing worth trying.
    If you can share the log files of your Studio, there may be more information about the problem in there.


  • Options
    sgenzersgenzer Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM Moderator Posts: 2,959 Community Manager
    any thoughts @IngoRM ??
  • Options
    NeelNeel Member Posts: 4 Contributor I
    Thank you @IngoRM for the suggestion. Plugging in a vanilla MySQL solved the problem indeed.

Sign In or Register to comment.