<div dir="ltr">What is really, really odd is that I copied the existing database storage (a Docker volume) and started a completely new Keycloak + db on that copy. That worked just fine.<div><br></div><div>Starting a new keycloak pointing to the existing mysql server fails. I&#39;ve also tried redeploying both mysql and keycloak and that&#39;s still wrong. connectionsJpa is set to update.</div><div><br></div><div>I&#39;ll try a productiion deploy on the copy of the database and see if that helps</div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div><br></div><div><div style="color:rgb(0,0,0);font-size:12.8px"><div><font face="verdana, sans-serif"><b>Kevin Thorpe</b></font></div><div style="font-family:&#39;Times New Roman&#39;">VP Enterprise Platform</div><div style="font-family:&#39;Times New Roman&#39;"><img src="http://i.imgur.com/8UeC1YO.png" width="96" height="96"><br></div><div style="font-family:&#39;Times New Roman&#39;"><a href="http://www.p-i.net/" style="color:rgb(17,85,204);line-height:18.6311px" target="_blank">www.p-i.net</a> | <a href="https://twitter.com/@PI_150" style="color:rgb(17,85,204);line-height:18.6311px" target="_blank">@PI_150</a></div><br><b style="font-family:&#39;Times New Roman&#39;">T: <a href="tel:%2B44%20%280%2920%203005%206750" value="+442030056750" style="color:rgb(17,85,204)" target="_blank">+44 (0)20 3005 6750</a>  | F: <a href="tel:%2B44%280%2920%207730%202635" value="+442077302635" style="color:rgb(17,85,204)" target="_blank">+44(0)20 7730 2635</a>  | T: <a href="tel:%2B44%20%280%29808%20204%200344" value="+448082040344" style="color:rgb(17,85,204)" target="_blank">+44 (0)808 204 0344</a> </b><br><b style="font-family:&#39;Times New Roman&#39;"><font color="#515151">150 Buckingham Palace Road, London, SW1W 9TR, UK</font></b><font face="Times New Roman"> </font><br><br><div style="font-family:&#39;Times New Roman&#39;"><a><img src="https://clients.p-i.net/documents/11003/1116416/BSI-UKAS.logo_150.png" height="40px"></a>     <a><img src="https://clients.p-i.net/documents/11003/1116416/ISO27001.logo_150.png" height="40px"></a>     <a><img src="https://clients.p-i.net/documents/11003/1116416/QMS.logo_150.png" height="40px"></a>     <a><img src="https://clients.p-i.net/documents/11003/1116416/pci.logo_150.png" height="40px"></a></div></div><div style="color:rgb(0,0,0);font-family:&#39;Times New Roman&#39;;font-size:medium"><br><b><span style="color:rgb(106,168,79)">SAVE PAPER - THINK BEFORE YOU PRINT!</span></b><p><font size="1">____________________________________________________________________</font></p><p style="color:rgb(34,34,34)"><font size="1">This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.</font></p></div></div></div></div></div></div></div></div>
<br><div class="gmail_quote">On 8 August 2016 at 13:48, Marek Posolda <span dir="ltr">&lt;<a href="mailto:mposolda@redhat.com" target="_blank">mposolda@redhat.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
  
    
  
  <div bgcolor="#FFFFFF" text="#000000">
    <div>From your logs, it seems the problem is
      related to migration infinispan caches. It looks that you don&#39;t
      have defined some of those caches in standalone.xml. <br>
      <br>
      Generally it&#39;s recommended to use Keycloak with keycloak-server
      distribution and upgrade process is like this:<br>
      - You stop your Keycloak 1.7.0.Final server<br>
      - You download the Keycloak-server 2.0.0.Final distribution and
      you just configure the DB ( datasource ) to point to same DB like
      previously was Keycloak 1.7.0<br>
      - You start Keycloak and liquibase make sure to upgrade your DB. <br>
      <br>
      Note that with this approach, you don&#39;t need to care about any
      changes, which was done in standalone.xml or keycloak-server.json
      or other files between Keycloak 1.7 or 2.0.<br>
      <br>
      Marek<br>
      <br>
      <br>
      On 08/08/16 14:27, Shiva Saxena wrote:<br>
    </div>
    <blockquote type="cite">
      <div dir="ltr">
        <div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(19,79,92)">Hi,</div>
        <div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(19,79,92)"><br>
        </div>
        <div class="gmail_default"><span style="color:rgb(19,79,92);font-family:arial,helvetica,sans-serif;font-size:small">You
            can try setting the &quot;<span>databaseSchema</span>&quot;
            to &quot;</span><font color="#333333" face="Consolas, Liberation
            Mono, Menlo, Courier, monospace"><span style="font-size:13.6px;letter-spacing:0.2px;line-height:23.12px;background-color:rgb(247,247,247)">update</span></font><font color="#134f5c" face="arial, helvetica, sans-serif">&quot; in &quot;</font><span>connectionsJpa</span><span style="color:rgb(19,79,92);font-family:arial,helvetica,sans-serif">&quot;.</span></div>
        <div class="gmail_default"><span style="color:rgb(19,79,92);font-family:arial,helvetica,sans-serif"><br>
          </span></div>
        <div class="gmail_default"><font color="#134f5c" face="arial,
            helvetica, sans-serif">Here is the migration guide doc URL</font></div>
        <div class="gmail_default"><font color="#134f5c" face="arial,
            helvetica, sans-serif"><br>
          </font></div>
        <div class="gmail_default"><font color="#134f5c" face="arial,
            helvetica, sans-serif"><a href="https://keycloak.gitbooks.io/server-adminstration-guide/content/v/2.0/topics/MigrationFromOlderVersions.html" target="_blank">https://keycloak.gitbooks.io/<wbr>server-adminstration-guide/<wbr>content/v/2.0/topics/<wbr>MigrationFromOlderVersions.<wbr>html</a><br>
          </font></div>
        <div class="gmail_extra"><br>
          <div class="gmail_quote"><div><div class="h5">On Mon, Aug 8, 2016 at 4:47 PM, Kevin
            Thorpe <span dir="ltr">&lt;<a href="mailto:kevin.thorpe@p-i.net" target="_blank">kevin.thorpe@p-i.net</a>&gt;</span>
            wrote:<br>
            </div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5">
              <div dir="ltr">Hi, 
                <div>     I&#39;m having problems upgrading from 1.7.0.Final
                  to 2.0.0.Final. I&#39;m using the Docker images on which
                  we build our own images to add https with our certs,
                  our theme and a small patch to match our LDAP
                  configuration. The new image of 2.0.0 works fine with
                  a brand new database but doesn&#39;t start up with the
                  existing database. Do I need to upgrade via an earlier
                  release to modify the db?</div>
                <div><br>
                </div>
                <div>I&#39;ve attached the startup logs. I don&#39;t know enough
                  to  see what&#39;s wrong.<br clear="all">
                  <div>
                    <div data-smartmail="gmail_signature">
                      <div dir="ltr">
                        <div>
                          <div dir="ltr">
                            <div dir="ltr">
                              <div><br>
                              </div>
                              <div>
                                <div style="color:rgb(0,0,0);font-size:12.8px">
                                  <div><font face="verdana, sans-serif"><b>Kevin
                                        Thorpe</b></font></div>
                                  <div>VP Enterprise Platform</div>
                                  <div><img src="http://i.imgur.com/8UeC1YO.png" height="96" width="96"><br>
                                  </div>
                                  <div><a href="http://www.p-i.net/" style="color:rgb(17,85,204);line-height:18.6311px" target="_blank">www.p-i.net</a> | <a href="https://twitter.com/@PI_150" style="color:rgb(17,85,204);line-height:18.6311px" target="_blank">@PI_150</a></div>
                                  <br>
                                  <b>T: <a href="tel:%2B44%20%280%2920%203005%206750" value="+442030056750" style="color:rgb(17,85,204)" target="_blank">+44 (0)20 3005
                                      6750</a>  | F: <a href="tel:%2B44%280%2920%207730%202635" value="+442077302635" style="color:rgb(17,85,204)" target="_blank">+44(0)20 7730 2635</a>  |
                                    T: <a href="tel:%2B44%20%280%29808%20204%200344" value="+448082040344" style="color:rgb(17,85,204)" target="_blank">+44 (0)808 204
                                      0344</a> </b><br>
                                  <b><font color="#515151">150
                                      Buckingham Palace Road, London,
                                      SW1W 9TR, UK</font></b><font face="Times New Roman"> </font><br>
                                  <br>
                                  <div><a><img src="https://clients.p-i.net/documents/11003/1116416/BSI-UKAS.logo_150.png" height="40px"></a>     <a><img src="https://clients.p-i.net/documents/11003/1116416/ISO27001.logo_150.png" height="40px"></a>     <a><img src="https://clients.p-i.net/documents/11003/1116416/QMS.logo_150.png" height="40px"></a>     <a><img src="https://clients.p-i.net/documents/11003/1116416/pci.logo_150.png" height="40px"></a></div>
                                </div>
                                <div><br>
                                  <b><span style="color:rgb(106,168,79)">SAVE
                                      PAPER - THINK BEFORE YOU PRINT!</span></b>
                                  <p><font size="1">______________________________<wbr>______________________________<wbr>________</font></p>
                                  <p style="color:rgb(34,34,34)"><font size="1">This email and any files
                                      transmitted with it are
                                      confidential and intended solely
                                      for the use of the individual or
                                      entity to whom they are addressed.
                                      If you have received this email in
                                      error please notify the system
                                      manager. This message contains
                                      confidential information and is
                                      intended only for the individual
                                      named. If you are not the named
                                      addressee you should not
                                      disseminate, distribute or copy
                                      this e-mail. Please notify the
                                      sender immediately by e-mail if
                                      you have received this e-mail by
                                      mistake and delete this e-mail
                                      from your system. If you are not
                                      the intended recipient you are
                                      notified that disclosing, copying,
                                      distributing or taking any action
                                      in reliance on the contents of
                                      this information is strictly
                                      prohibited.</font></p>
                                </div>
                              </div>
                            </div>
                          </div>
                        </div>
                      </div>
                    </div>
                  </div>
                </div>
              </div>
              <br></div></div>
              ______________________________<wbr>_________________<br>
              keycloak-user mailing list<br>
              <a href="mailto:keycloak-user@lists.jboss.org" target="_blank">keycloak-user@lists.jboss.org</a><br>
              <a href="https://lists.jboss.org/mailman/listinfo/keycloak-user" rel="noreferrer" target="_blank">https://lists.jboss.org/mailma<wbr>n/listinfo/keycloak-user</a><br>
            </blockquote>
          </div>
          <br>
          <br clear="all"><span class="HOEnZb"><font color="#888888">
          <div><br>
          </div>
          -- <br>
          <div data-smartmail="gmail_signature">
            <div dir="ltr">
              <div>
                <div dir="ltr">
                  <div>
                    <div dir="ltr"><font style="font-family:Calibri,sans-serif" color="#000000" face="Calibri,sans-serif">
                        <div style="line-height:21.2999992370605px"><font size="2">Best Regards</font></div>
                      </font>
                      <div style="line-height:21.2999992370605px;color:rgb(68,68,68);font-family:Calibri,sans-serif"><font style="line-height:normal" color="#2672ec"><span style="line-height:21px"><font style="line-height:normal"><b style="line-height:22.7199993133545px"><font style="line-height:normal" face="Calibri" size="2">Shiva Saxena</font></b></font></span><font face="Calibri"><span style="line-height:21px"><font style="line-height:normal" size="2"><b style="line-height:18.4599990844727px"> 
                                                       </b></font></span></font></font>
                        <div style="line-height:21px"><font style="line-height:normal" size="2"><b style="line-height:18.4599990844727px"><font style="line-height:normal" color="#2672ec" face="Calibri"><a href="http://metalop.com/" style="line-height:18.4599990844727px;font-weight:inherit;color:blue" target="_blank">Blog</a></font><font style="line-height:normal" color="#444444"> | <a href="http://in.linkedin.com/in/shivasaxena/" style="line-height:18.4599990844727px;font-weight:inherit;color:blue" target="_blank">Linkedin</a> | <a href="http://stackoverflow.com/users/2490343/shiva" style="line-height:18.4599990844727px;font-weight:inherit;color:blue" target="_blank">StackOverflo<wbr>w</a></font></b></font></div>
                      </div>
                    </div>
                  </div>
                </div>
              </div>
            </div>
          </div>
        </font></span></div><span class="HOEnZb"><font color="#888888">
      </font></span></div><span class="HOEnZb"><font color="#888888">
      <br>
      <fieldset></fieldset>
      <br>
      <pre>______________________________<wbr>_________________
keycloak-user mailing list
<a href="mailto:keycloak-user@lists.jboss.org" target="_blank">keycloak-user@lists.jboss.org</a>
<a href="https://lists.jboss.org/mailman/listinfo/keycloak-user" target="_blank">https://lists.jboss.org/<wbr>mailman/listinfo/keycloak-user</a></pre>
    </font></span></blockquote>
    <br>
  </div>

</blockquote></div><br></div>