Maria DB instead of MySQL (3 Viewers)

[ajs]

its failing with the cast to NULL problem.

Maybe some plugin is interfering?

 

[vapourEyes]

Mmm... the plot thickens.

Are you able to report your MariaDB version too ?

It could be a plugin. I only have a few...
WorldWeather.
Sleep Timer.

 

[ajs]

@Pablik Do you have any ideas?
This is clearly related to the MySQL library. But we updated it. Or maybe it can be updated to a newer version. It seems to me that something similar was discussed in the MPSync thread.

 

[ajs]

MariaDB version too

MariaDB 11.3.2 But I hardly use the TV server, I only have it on my test machine. Therefore, I cannot say 100% that it works 60% in my config (without TV cards).

 

[vapourEyes]

There is a solution to this problem, highlighted on Stack Exchange for a different product.

Object cannot be cast from DBNull to other types

Object cannot be cast from DBNull to other types. I have a following function which throws the above error. I am handling all nulls in store procedure and in the C# code. So where is it getting t...

stackoverflow.com

Its to detect the null field / data and cast to a concrete type, as shown in the solution above.
I'll refrain from posting more, until @Pablik has had half a chance to answer and contribute.

 

[Pablik]

@Pablik Do you have any ideas?
This is clearly related to the MySQL library. But we updated it. Or maybe it can be updated to a newer version. It seems to me that something similar was discussed in the MPSync thread.

The problem lies in 'information_schema' table. MariaDB has the uca1400* records without ID(null). When the MySql.Data.dll(not part of the MediaPortal) library is executing "SHOW COLLATIONS" cmd and subsequently reads the records, then rises exception when converting ID(null) to int32.

 

[ajs]

The problem lies in 'information_schema' table. MariaDB has the uca1400* records without ID(null). When the MySql.Data.dll(not part of the MediaPortal) library is executing "SHOW COLLATIONS" cmd and subsequently reads the records, then rises exception when converting ID(null) to int32.

Can we somehow fix this on our side? We use the old Gentle library, but it uses the latest version of the MySQL library that I could find for our Framework.

 

[ajs]

When the MySql.Data.dll(not part of the MediaPortal) library is executing "SHOW COLLATIONS" cmd and subsequently reads the records, then rises exception when converting ID(null) to int32

I read about this problem, everyone writes that the easiest way is to switch from MySql.Data.MySqlClient to MySqlConnector.
I wonder how difficult this is for us at the moment. But if we switch, they promise an increase in speed and stability. Overall an interesting option.

MySqlConnector vs MySql.Data - MySqlConnector

MySqlConnector is a high-performance, asynchronous C# ADO.NET driver for MySQL Server, MariaDB, Amazon Aurora, Azure Database for MySQL, Google Cloud SQL for MySQL, Percona Server and more.

mysqlconnector.net

 

[ajs]

I found this information. @Pablik , can we use it somehow?

Permit connection to MariaDB 10.10 by rusher · Pull Request #51 · mysql/mysql-connector-net

Driver cannot even connect to MariaDB 10.10+, connection fails with error : [InvalidCastException: Object cannot be cast from DBNull to other types.] System.DBNull.System.IConvertible.ToInt32(IForm...

github.com

This is where it gets interesting:

GitHub - jeffraska/Jf.MySql.Data.Collations: Fixes connecting to newer MariaDB server (>=10.10.1) using MySql.Data connector. Enables support for utf8mb3 in older connector.

Fixes connecting to newer MariaDB server (>=10.10.1) using MySql.Data connector. Enables support for utf8mb3 in older connector. - jeffraska/Jf.MySql.Data.Collations

github.com

MySQL :: MySQL Connector/NET Developer Guide :: 5.9 Using the Connector/NET Interceptor Classes

dev.mysql.com

 

[ajs]

Looks like it worked for me. But I'm not sure yet... I'm testing.