holger.apel

First of all a user in our mysql enviroment has no root rights so cannot create a schema. But i did a workaround, i gave the user the all rights on a non existing database rdm and then did a "create schema". Result is the same error as before. It looks like a lock is set in one transaction and this lock is not released before the next statement. Only the table connections was created, nothing more

MySqlException - Can't execute the given command because you have active locked tables or an active transaction

at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)

at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

at MySql.Data.MySqlClient.MySqlDataReader.NextResult()

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)

at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()

at MySql.Data.MySqlClient.MySqlScript.Execute()

at Devolutions.RemoteDesktopManager.Business.DataSources.MySQLConnectionDataSource.ExecuteScript(String script, IDbConnection connection)

at Devolutions.RemoteDesktopManager.Business.DatabaseUpgradeAction.Execute(DatabaseConnectionDataSource dataSource)

at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.Upgrade(Boolean silent, LogMessageDelegate logMessage)

Variable_nameValueprotocol_version10version5.1.73version_commentSource distributionversion_compile_machinex86_64version_compile_osredhat-linux-gnu

[/table]

now i get "already exists" when i try to create a schema. Before i got the same error Message as in the beginning...

Btw: Thanks for your Help: Much appreciated!

Not really much :(

We've seen the "Unknown Collumn 'Data_Type' in 'field list'" error before but can't reproduce it.

If you could run the following SQL script (one will fail with the same error but should help me diagnose it) and send me the results I should be able to diagnose both the issues. This is the exact same code that runs when you hit the "send schema to support" button.

select

(select DatabaseVersion from DatabaseInfo limit 1)

,database()

,@@hostname;

[font=Verdana] [/quote][/font][font=Verdana]

[/font](select DatabaseVersion from DatabaseInfo limit 1)database()@@hostnameNULLha_testpag-db01

[/table][font=Verdana][quote=Stefane Lavergne][/font][quote=]-- Tables & ColumnsSELECT table_name as 'Table', column_name as 'Name', COLUMN_DEFAULT as 'Default', IS_NULLABLE as 'Nullable', DATA_TYPE as 'Type', case when CHARACTER_MAXIMUM_LENGTH >= 65535 then null else CHARACTER_MAXIMUM_LENGTH END as 'Length'FROM information_schema.columnsWHERE table_schema = database()order by 1, 2;[/quote]

[code][font=Verdana][/quote][/font][font=Verdana]attached... columns1.sql[/font][font=Verdana][quote[/font][font=Verdana]=Stefane Lavergne[/font][font=Verdana]][/font]-- triggers

select EVENT_OBJECT_TABLE as 'Table', trigger_name as 'Name', ACTION_TIMING as 'Timing', EVENT_MANIPULATION as 'Event', ACTION_ORIENTATION as 'Orientation', action_statement as 'Code'

from information_schema.triggers

WHERE trigger_schema = database()

order by 1;

[code][font=Verdana][/quote][/font][font=Verdana]

[/font][font=Verdana][b]Result: Empty[/b][/font][font=Verdana]

[/font][font=Verdana][quote[/font][font=Verdana]=Stefane Lavergne[/font][font=Verdana]][/font][/code]-- procedures/functions

select ROUTINE_NAME as 'Name', ROUTINE_TYPE as 'Type', DATA_TYPE as 'DataType', ROUTINE_DEFINITION as 'Code'

from information_schema.routines

WHERE routine_schema = database()

order by 1;

[code][font=Verdana][/quote][/font][img]http://172.18.1.21/phpmyadmin/themes/dot.gif[/img][color=rgb(0, 0, 0)][font=sans-serif] #1054 - Unknown column 'DATA_TYPE' in 'field list'[/font][/color][color=rgb(0, 0, 0)][font=sans-serif]

[/font][/color][font=Verdana][quote[/font][font=Verdana]=Stefane Lavergne[/font][font=Verdana]][/font][/code]-- views

select table_NAME as 'Name', view_DEFINITION as 'Code'

from information_schema.views

WHERE table_schema = database()

order by 1;

[code][font=Verdana][/quote[/font][font=Verdana]][/font][font=Verdana]

[/font][font=Verdana][b]Result: Empty[/b][/font][font=Verdana][b]

[/b][/font][font=Verdana][quote][/font][/code]-- constraints

select constraint_name as 'Name', TABLE_NAME as 'Table', CONSTRAINT_TYPE as 'Type'

from information_schema.TABLE_CONSTRAINTS

WHERE CONSTRAINT_SCHEMA = database()

order by 2, 1;

[code][font=Verdana][/quote][/font][font=Verdana][b]Result: Empty[/b][/font][font=Verdana][quote[/font][font=Verdana]=Stefane Lavergne[/font][font=Verdana]][/font][/code]-- constraint columns

select Table_NAME as 'Table', CONSTRAINT_NAME as 'Name', COLUMN_NAME as 'Column', Ordinal_Position as 'Position', Referenced_table_name as 'ReferencedTable', Referenced_Column_Name as 'ReferencedColumn'

from information_schema.KEY_COLUMN_USAGE

WHERE CONSTRAINT_SCHEMA = database()

order by CONSTRAINT_NAME, ORDINAL_POSITION;[/code] [/quote]

Result: Empty

Would like to do so, but i get:

Schema Dump failed with error:

Unknown Collumn 'Data_Type' in 'field list'

Hi,

i am facing the issue that i am not able to complete a working configuration of a mysql data source connection.

Test host and test schema are working but the upgrade of the schema results in the error below.

Any Ideas?

MySql.Data.MySqlClient.MySqlException (0x80004005): Can't execute the given command because you have active locked tables or an active transaction

at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)

at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)

at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

at MySql.Data.MySqlClient.MySqlDataReader.NextResult()

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)

at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()

at MySql.Data.MySqlClient.MySqlScript.Execute()

at Devolutions.RemoteDesktopManager.Business.DataSources.MySQLConnectionDataSource.ExecuteScript(String script, IDbConnection connection)

at Devolutions.RemoteDesktopManager.Business.DataSources.MySQLConnectionDataSource.ExecuteScript(String script, IDbTransaction dbTransaction)

at Devolutions.RemoteDesktopManager.Business.DatabaseUpgradeAction.Execute(DatabaseConnectionDataSource dataSource)

at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.Upgrade(Boolean silent, LogMessageDelegate logMessage)