Problems using Mysql

Support - Assistance technique
1

I am getting the below error.

  • ERROR 14:11:12,988 could not get database metadata (SchemaUpdate.java [main])

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table ‘sequences’ in information_schema

···

–
Cheers,
Knut Staring

2

Well, this means that somewhere there is a query referincing a table with name 'sequences' and it does not exist on the database.

Start by checking that.

Caveman

Knut Staring wrote:

···

I am getting the below error.

* ERROR 14:11:12,988 could not get database metadata (SchemaUpdate.java [main])
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'sequences' in information_schema

--
Cheers,
Knut Staring

------------------------------------------------------------------------

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

3

Indeed. I wonder if someone knows what that query is, as it seems to want to access the information_schema database, and not the DHIS2 database.

I suppose DHIS2 needs for there to be a Sequences table in the MySql information_schema base - does anyone know the details? And has anyone encountered this problem before? Could it have to do with privileges for that db?

K

···

On Sun, Aug 30, 2009 at 6:04 AM, Orvalho Joaquim Augusto orvaquim@gmail.com wrote:

Well, this means that somewhere there is a query referincing a table with name ‘sequences’ and it does not exist on the database.

Start by checking that.

Caveman

Knut Staring wrote:

I am getting the below error.

  • ERROR 14:11:12,988 could not get database metadata (SchemaUpdate.java [main])

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table ‘sequences’ in information_schema

–

Cheers,

Knut Staring

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

–
Cheers,
Knut Staring

4

Hi Knut

Seems like something schizophrenic is happening. As far as I know MySQL does not support or use sequences. It uses auto-incrementing instead.

It looks almost like you’re trying to import something from postgres sql to mysql. What are you doing when you get this error? Any chance that you have a mixed up config -eg using postgresql dialect but loading mysql driver?

Bob

···

2009/8/30 Knut Staring knutst@gmail.com

Indeed. I wonder if someone knows what that query is, as it seems to want to access the information_schema database, and not the DHIS2 database.

I suppose DHIS2 needs for there to be a Sequences table in the MySql information_schema base - does anyone know the details? And has anyone encountered this problem before? Could it have to do with privileges for that db?

K

On Sun, Aug 30, 2009 at 6:04 AM, Orvalho Joaquim Augusto orvaquim@gmail.com wrote:

Well, this means that somewhere there is a query referincing a table with name ‘sequences’ and it does not exist on the database.

Start by checking that.

Caveman

Knut Staring wrote:

I am getting the below error.

  • ERROR 14:11:12,988 could not get database metadata (SchemaUpdate.java [main])

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table ‘sequences’ in information_schema

–

Cheers,

Knut Staring

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

–
Cheers,
Knut Staring

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp