Anyone using MySQL latest version?

  Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
AbRASiON Offline
Fan
Posts: 689
Joined: Jan 2004
Reputation: 1
Post: #1
I've had several issues with Kodi 17.3, at least one of these was definitely my own fault, but unfortunately I'm suffering some other inconsistencies which I think might even be a faulty version of MySQL.

I've got Server version: 5.7.18-log MySQL Community Server (GPL) on Windows 10, 64bit. I believe I have ALL patches installed from Microsoft up to date.

Kodi has been hard freezing on me, several times while trying to test 17.3, which is pretty frustrating.
Upon further investigation, it feels like MySQL is 'locking up'

When attempting to just do a clean Kodi install to try more testing, I go into MySQL, with Kodi closed and I type.
drop database mymusic60 ;
and
drop database myvideos107 ;

These commands will clean out Kodi fresh.
What happens (inconsistently) is that MySQL locks up, entirely and simply does nothing. It's on a PC with 2 cores, 2 threads, 8GB memory and an SSD, the machine is otherwise perfectly fine.

So long story short, are any MySQL (latest) users seeing either Kodi issues or MySQL weirdness?
(NOTE: Yes, I know, if I'm right, this isn't a Kodi fault)
(This post was last modified: 2017-06-19 00:37 by AbRASiON.)
find quote
AbRASiON Offline
Fan
Posts: 689
Joined: Jan 2004
Reputation: 1
Post: #2
I did just find this one report of a memory leak but not under Windows.
https://bugs.mysql.com/bug.php?id=86082
find quote
AbRASiON Offline
Fan
Posts: 689
Joined: Jan 2004
Reputation: 1
Post: #3
First night testing, it looks like there's a genuine fault with 5.7.18 - I'll update the thread but it's not good.
find quote
nickr Online
Team-Kodi Member
Posts: 18,685
Joined: May 2009
Reputation: 387
Location: Christchurch NZ
Post: #4
MySQL should generate logs.

If I have helped you or increased your knowledge, click the 'thank user' button to give thanks :) (People with less than 20 posts won't see the "Thank you" button.)
find quote
flhthemi Offline
Fan
Posts: 704
Joined: Mar 2014
Reputation: 20
Location: Troutman North Carolina
Post: #5
The WIKI clearly states "there are issues with newer versions" and that V5.5.42. should be used. I am using this version and MySql Workbench 6.3 hosted on a Toshiba laptop with 8GB RAM, dual core Celeron, WD Blue SSD (256GB), Windows 10 CU and Kodi 17.3. No problems at all.

The Wiki: http://kodi.wiki/view/MySQL/Setting_up_M...ab=Windows

[Image: H4uJIxv.jpg]
(This post was last modified: 2017-06-21 21:12 by flhthemi.)
find quote
AbRASiON Offline
Fan
Posts: 689
Joined: Jan 2004
Reputation: 1
Post: #6
That is old information and has been bandied about or years, I used 5.6 for over a year without issues for example.
find quote
Klojum Offline
Team-Kodi Member
Posts: 568
Joined: Nov 2009
Reputation: 6
Location: In a house
Post: #7
Using MySQL 5.5.55 here (Ubuntu 14.04) and no hiccups. *knocks on wood*
find quote
nickr Online
Team-Kodi Member
Posts: 18,685
Joined: May 2009
Reputation: 387
Location: Christchurch NZ
Post: #8
Still not seen any logs

If I have helped you or increased your knowledge, click the 'thank user' button to give thanks :) (People with less than 20 posts won't see the "Thank you" button.)
find quote
flhthemi Offline
Fan
Posts: 704
Joined: Mar 2014
Reputation: 20
Location: Troutman North Carolina
Post: #9
(2017-06-20 15:40)AbRASiON Wrote:  That is old information and has been bandied about or years, I used 5.6 for over a year without issues for example.

I'm sorry but I see it this way, if the Kodi devs know that newer versions of MySql work fine, then they would update the Wiki. I was just informing you what I know works in an effort to help you with your situation. If you want to poo-poo it, that is your prerogative.

[Image: H4uJIxv.jpg]
find quote
Fail$tyle420 Offline
Posting Freak
Posts: 1,188
Joined: Jul 2014
Reputation: 43
Post: #10
(2017-06-21 21:11)flhthemi Wrote:  If you want to poo-poo it, that is your prerogative.

Calm down, you took his answer a little personal and the wrong way. He was simply correcting you.
find quote
AbRASiON Offline
Fan
Posts: 689
Joined: Jan 2004
Reputation: 1
Post: #11
(2017-06-21 21:11)flhthemi Wrote:  
(2017-06-20 15:40)AbRASiON Wrote:  That is old information and has been bandied about or years, I used 5.6 for over a year without issues for example.

I'm sorry but I see it this way, if the Kodi devs know that newer versions of MySql work fine, then they would update the Wiki. I was just informing you what I know works in an effort to help you with your situation. If you want to poo-poo it, that is your prerogative.

I appreciate the response but the fact is the Kodi devs can't update the wiki ever 15 minutes, the wiki is incorrect / out of date. If I've used 5.6 for over 12 months with V15 of Kodi without issue, maybe the wiki is no good, hence my reply.
Infact version 5.6, 5.7, 5.8 might work FINE without Kodi, the wiki might simply be stating "we've had time to test 5.5 only, we can be sure that works"
find quote
AbRASiON Offline
Fan
Posts: 689
Joined: Jan 2004
Reputation: 1
Post: #12
(2017-06-20 23:29)nickr Wrote:  Still not seen any logs

Kodi or SQL ones?
find quote
nickr Online
Team-Kodi Member
Posts: 18,685
Joined: May 2009
Reputation: 387
Location: Christchurch NZ
Post: #13
Whichever ones show the error.

If I have helped you or increased your knowledge, click the 'thank user' button to give thanks :) (People with less than 20 posts won't see the "Thank you" button.)
find quote