[aerogear-dev] UPS Migrator error (1.1.0.Final)

classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

[aerogear-dev] UPS Migrator error (1.1.0.Final)

Oleh Mackiv
Hi,
can somebody who worked on UPS migrator recently, check if it deals with recent database changes (e.g. https://github.com/aerogear/aerogear-unifiedpush-server/commit/bbe1c0e80a4a5295a3c7cefe66f5e8cc07da66be#diff-23e531d12489411024ea5c379be1d178R70 ).

I have run into error when running integration test with migrator run (liquibase.exception.DatabaseException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Key column 'variantInformations_id' doesn't exist in table).

Thanks for any help.

--
Oleg Matskiv
Mobile QE Intern
[hidden email]

_______________________________________________
aerogear-dev mailing list
[hidden email]
https://lists.jboss.org/mailman/listinfo/aerogear-dev
Reply | Threaded
Open this post in threaded view
|

Re: [aerogear-dev] UPS Migrator error (1.1.0.Final)

danielbevenius
Hi, 

can you tell me what version of MySql you are using and also the steps to reproduce?

Thanks,

/Dan

On 12 August 2015 at 12:37, Oleg Matskiv <[hidden email]> wrote:
Hi,
can somebody who worked on UPS migrator recently, check if it deals with recent database changes (e.g. https://github.com/aerogear/aerogear-unifiedpush-server/commit/bbe1c0e80a4a5295a3c7cefe66f5e8cc07da66be#diff-23e531d12489411024ea5c379be1d178R70 ).

I have run into error when running integration test with migrator run (liquibase.exception.DatabaseException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Key column 'variantInformations_id' doesn't exist in table).

Thanks for any help.

--
Oleg Matskiv
Mobile QE Intern
[hidden email]

_______________________________________________
aerogear-dev mailing list
[hidden email]
https://lists.jboss.org/mailman/listinfo/aerogear-dev


_______________________________________________
aerogear-dev mailing list
[hidden email]
https://lists.jboss.org/mailman/listinfo/aerogear-dev
Reply | Threaded
Open this post in threaded view
|

Re: [aerogear-dev] UPS Migrator error (1.1.0.Final)

Matthias Wessendorf
In reply to this post by Oleh Mackiv
Oleg,

did you create a JIRA?

On Wed, Aug 12, 2015 at 12:37 PM, Oleg Matskiv <[hidden email]> wrote:
Hi,
can somebody who worked on UPS migrator recently, check if it deals with recent database changes (e.g. https://github.com/aerogear/aerogear-unifiedpush-server/commit/bbe1c0e80a4a5295a3c7cefe66f5e8cc07da66be#diff-23e531d12489411024ea5c379be1d178R70 ).

I have run into error when running integration test with migrator run (liquibase.exception.DatabaseException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Key column 'variantInformations_id' doesn't exist in table).

Thanks for any help.

--
Oleg Matskiv
Mobile QE Intern
[hidden email]

_______________________________________________
aerogear-dev mailing list
[hidden email]
https://lists.jboss.org/mailman/listinfo/aerogear-dev



--

_______________________________________________
aerogear-dev mailing list
[hidden email]
https://lists.jboss.org/mailman/listinfo/aerogear-dev
Reply | Threaded
Open this post in threaded view
|

Re: [aerogear-dev] UPS Migrator error (1.1.0.Final)

danielbevenius
In reply to this post by Oleh Mackiv
Hi Oleg, 

I was able to reproduce this using the following steps:

I'm looking into this now. 

Thanks,

/Dan

On 12 August 2015 at 12:37, Oleg Matskiv <[hidden email]> wrote:
Hi,
can somebody who worked on UPS migrator recently, check if it deals with recent database changes (e.g. https://github.com/aerogear/aerogear-unifiedpush-server/commit/bbe1c0e80a4a5295a3c7cefe66f5e8cc07da66be#diff-23e531d12489411024ea5c379be1d178R70 ).

I have run into error when running integration test with migrator run (liquibase.exception.DatabaseException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Key column 'variantInformations_id' doesn't exist in table).

Thanks for any help.

--
Oleg Matskiv
Mobile QE Intern
[hidden email]

_______________________________________________
aerogear-dev mailing list
[hidden email]
https://lists.jboss.org/mailman/listinfo/aerogear-dev


_______________________________________________
aerogear-dev mailing list
[hidden email]
https://lists.jboss.org/mailman/listinfo/aerogear-dev
Reply | Threaded
Open this post in threaded view
|

Re: [aerogear-dev] UPS Migrator error (1.1.0.Final)

Oleh Mackiv
In reply to this post by Oleh Mackiv
Dan:
I have read that you have already reproduce, but anyway: version: 5.5.45 MySQL Community Server. I just created empty DB and ran integration test with wildfly8UpsFromMavenRepository provider.
First it couldn't find "adm_variant" table (because of this i think: https://github.com/aerogear/aerogear-unifiedpush-server/commit/7d61152b1eddaf11e5a732d8b7499828e15a2756). So I tried to with runMigrator option and got that error about column 'variantInformations_id'..

Matthias:
I did not create JIRA because this is for me first time working with UPS and I thought that the mistake could simply be just on my side...

On Wed, Aug 12, 2015 at 12:37 PM, Oleg Matskiv <[hidden email]> wrote:
Hi,
can somebody who worked on UPS migrator recently, check if it deals with recent database changes (e.g. https://github.com/aerogear/aerogear-unifiedpush-server/commit/bbe1c0e80a4a5295a3c7cefe66f5e8cc07da66be#diff-23e531d12489411024ea5c379be1d178R70 ).

I have run into error when running integration test with migrator run (liquibase.exception.DatabaseException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Key column 'variantInformations_id' doesn't exist in table).

Thanks for any help.

--
Oleg Matskiv
Mobile QE Intern
[hidden email]



--
Oleg Matskiv
Mobile QE Intern
[hidden email]

_______________________________________________
aerogear-dev mailing list
[hidden email]
https://lists.jboss.org/mailman/listinfo/aerogear-dev
Reply | Threaded
Open this post in threaded view
|

Re: [aerogear-dev] UPS Migrator error (1.1.0.Final)

Sebastien Blanc


On Thu, Aug 13, 2015 at 9:45 AM, Oleg Matskiv <[hidden email]> wrote:
Dan:
I have read that you have already reproduce, but anyway: version: 5.5.45 MySQL Community Server. I just created empty DB and ran integration test with wildfly8UpsFromMavenRepository provider.
First it couldn't find "adm_variant" table (because of this i think: https://github.com/aerogear/aerogear-unifiedpush-server/commit/7d61152b1eddaf11e5a732d8b7499828e15a2756). So I tried to with runMigrator option and got that error about column 'variantInformations_id'..

Matthias:
I did not create JIRA because this is for me first time working with UPS and I thought that the mistake could simply be just on my side...
Jira tickets are cheap :) please create one :) 

On Wed, Aug 12, 2015 at 12:37 PM, Oleg Matskiv <[hidden email]> wrote:
Hi,
can somebody who worked on UPS migrator recently, check if it deals with recent database changes (e.g. https://github.com/aerogear/aerogear-unifiedpush-server/commit/bbe1c0e80a4a5295a3c7cefe66f5e8cc07da66be#diff-23e531d12489411024ea5c379be1d178R70 ).

I have run into error when running integration test with migrator run (liquibase.exception.DatabaseException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Key column 'variantInformations_id' doesn't exist in table).

Thanks for any help.

--
Oleg Matskiv
Mobile QE Intern
[hidden email]



--
Oleg Matskiv
Mobile QE Intern
[hidden email]

_______________________________________________
aerogear-dev mailing list
[hidden email]
https://lists.jboss.org/mailman/listinfo/aerogear-dev


_______________________________________________
aerogear-dev mailing list
[hidden email]
https://lists.jboss.org/mailman/listinfo/aerogear-dev
Reply | Threaded
Open this post in threaded view
|

Re: [aerogear-dev] UPS Migrator error (1.1.0.Final)

Oleh Mackiv

On Thu, Aug 13, 2015 at 9:47 AM, Sebastien Blanc <[hidden email]> wrote:


On Thu, Aug 13, 2015 at 9:45 AM, Oleg Matskiv <[hidden email]> wrote:
Dan:
I have read that you have already reproduce, but anyway: version: 5.5.45 MySQL Community Server. I just created empty DB and ran integration test with wildfly8UpsFromMavenRepository provider.
First it couldn't find "adm_variant" table (because of this i think: https://github.com/aerogear/aerogear-unifiedpush-server/commit/7d61152b1eddaf11e5a732d8b7499828e15a2756). So I tried to with runMigrator option and got that error about column 'variantInformations_id'..

Matthias:
I did not create JIRA because this is for me first time working with UPS and I thought that the mistake could simply be just on my side...
Jira tickets are cheap :) please create one :) 

On Wed, Aug 12, 2015 at 12:37 PM, Oleg Matskiv <[hidden email]> wrote:
Hi,
can somebody who worked on UPS migrator recently, check if it deals with recent database changes (e.g. https://github.com/aerogear/aerogear-unifiedpush-server/commit/bbe1c0e80a4a5295a3c7cefe66f5e8cc07da66be#diff-23e531d12489411024ea5c379be1d178R70 ).

I have run into error when running integration test with migrator run (liquibase.exception.DatabaseException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Key column 'variantInformations_id' doesn't exist in table).

Thanks for any help.

--
Oleg Matskiv
Mobile QE Intern
[hidden email]



--
Oleg Matskiv
Mobile QE Intern
[hidden email]

_______________________________________________
aerogear-dev mailing list
[hidden email]
https://lists.jboss.org/mailman/listinfo/aerogear-dev


_______________________________________________
aerogear-dev mailing list
[hidden email]
https://lists.jboss.org/mailman/listinfo/aerogear-dev



--
Oleg Matskiv
Mobile QE Intern
[hidden email]

_______________________________________________
aerogear-dev mailing list
[hidden email]
https://lists.jboss.org/mailman/listinfo/aerogear-dev
Reply | Threaded
Open this post in threaded view
|

Re: [aerogear-dev] UPS Migrator error (1.1.0.Final)

danielbevenius
Thanks for the info Oleg. I've added a comment to the JIRA. Could you guys take a look and see if this makes sense to you?

Thanks,

/Dan

On 13 August 2015 at 10:03, Oleg Matskiv <[hidden email]> wrote:

On Thu, Aug 13, 2015 at 9:47 AM, Sebastien Blanc <[hidden email]> wrote:


On Thu, Aug 13, 2015 at 9:45 AM, Oleg Matskiv <[hidden email]> wrote:
Dan:
I have read that you have already reproduce, but anyway: version: 5.5.45 MySQL Community Server. I just created empty DB and ran integration test with wildfly8UpsFromMavenRepository provider.
First it couldn't find "adm_variant" table (because of this i think: https://github.com/aerogear/aerogear-unifiedpush-server/commit/7d61152b1eddaf11e5a732d8b7499828e15a2756). So I tried to with runMigrator option and got that error about column 'variantInformations_id'..

Matthias:
I did not create JIRA because this is for me first time working with UPS and I thought that the mistake could simply be just on my side...
Jira tickets are cheap :) please create one :) 

On Wed, Aug 12, 2015 at 12:37 PM, Oleg Matskiv <[hidden email]> wrote:
Hi,
can somebody who worked on UPS migrator recently, check if it deals with recent database changes (e.g. https://github.com/aerogear/aerogear-unifiedpush-server/commit/bbe1c0e80a4a5295a3c7cefe66f5e8cc07da66be#diff-23e531d12489411024ea5c379be1d178R70 ).

I have run into error when running integration test with migrator run (liquibase.exception.DatabaseException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Key column 'variantInformations_id' doesn't exist in table).

Thanks for any help.

--
Oleg Matskiv
Mobile QE Intern
[hidden email]



--
Oleg Matskiv
Mobile QE Intern
[hidden email]

_______________________________________________
aerogear-dev mailing list
[hidden email]
https://lists.jboss.org/mailman/listinfo/aerogear-dev


_______________________________________________
aerogear-dev mailing list
[hidden email]
https://lists.jboss.org/mailman/listinfo/aerogear-dev



--
Oleg Matskiv
Mobile QE Intern
[hidden email]

_______________________________________________
aerogear-dev mailing list
[hidden email]
https://lists.jboss.org/mailman/listinfo/aerogear-dev


_______________________________________________
aerogear-dev mailing list
[hidden email]
https://lists.jboss.org/mailman/listinfo/aerogear-dev