Siduction Forum

Siduction Forum => Upgrade Warnings => Topic started by: orinoco on 2015/07/25, 11:25:41

Title: [solved] Amarok error after d-u
Post by: orinoco on 2015/07/25, 11:25:41

Hello,

I did an d-u this morning and now Amarok starts with an error message

GREPME MySQLe query failed! (200) on init

It looks a problem with the embedded database?!?!

Can anybody verify this? How can I fix this? Switching to external database?

Title: Re: Amarok error after d-u
Post by: orinoco on 2015/07/25, 13:25:33

More info

All my playlists are lost?

Code: [Select]

  orinoco@womble:~$ amarok -d
QDBusConnection: session D-Bus connection created before QCoreApplication. Application may misbehave.
QDBusConnection: session D-Bus connection created before QCoreApplication. Application may misbehave.
amarok: BEGIN: App::App() 
amarok:   BEGIN: void App::continueInit() 
amarok:     BEGIN: EngineController::EngineController() 
amarok:     END__: EngineController::EngineController() [Took: 0.004s] 
amarok:     BEGIN: void EngineController::initializePhonon() 
[0000000001cd8628] pulse audio output error: PulseAudio server connection failure: Connection refused
WARNING: Phonon::createPath: Cannot connect  Phonon::MediaObject ( no objectName ) to  Phonon::AudioData
Output ( no objectName ). 
Object::connect: No such signal Phonon::VLC::MediaObject::angleChanged(int) in ../../phonon/mediacontrol
ler.cpp:65
Object::connect: No such signal Phonon::VLC::MediaObject::availableAnglesChanged(int) in ../../phonon/me
diacontroller.cpp:66
amarok:       [EngineController] Established Phonon equalizer effect with 11 parameters. 
amarok:       [EngineController] Tick Interval (actual):  100 
amarok:     END__: void EngineController::initializePhonon() [Took: 0.12s] 
amarok:     BEGIN: CollectionManager::CollectionManager() 
amarok:     END__: CollectionManager::CollectionManager() [Took: 0s] 
amarok:     BEGIN: MainWindow::MainWindow() 
amarok:       BEGIN: Plugins::PluginManager::PluginManager(QObject*) 
amarok:         BEGIN: void Plugins::PluginManager::findAllPlugins() 
amarok:           [PluginManager] found plugin: "amarok_collection-audiocdcollection" enabled: true 
amarok:           [PluginManager] found plugin: "amarok_collection-daapcollection" enabled: false 
amarok:           [PluginManager] found plugin: "amarok_collection-mtpcollection" enabled: false 
amarok:           [PluginManager] found plugin: "amarok_collection-mysqlservercollection" enabled: true 
amarok:           [PluginManager] found plugin: "amarok_collection-mysqlecollection" enabled: true 
amarok:           [PluginManager] found plugin: "amarok_collection-nepomukcollection" enabled: false 
amarok:           [PluginManager] found plugin: "amarok_collection-ipodcollection" enabled: false 
amarok:           [PluginManager] found plugin: "amarok_collection-upnpcollection" enabled: false 
amarok:           [PluginManager] found plugin: "amarok_collection-umscollection" enabled: false 
amarok:           [PluginManager] found plugin: "amarok_service_ampache" enabled: false 
amarok:           [PluginManager] found plugin: "amarok_service_jamendo" enabled: false 
amarok:           [PluginManager] found plugin: "amarok_service_lastfm" enabled: false 
amarok:           [PluginManager] found plugin: "amarok_service_amazonstore" enabled: false 
amarok:           [PluginManager] found plugin: "amarok_service_mp3tunes" enabled: false 
amarok:           [PluginManager] found plugin: "amarok_service_magnatunestore" enabled: false 
amarok:           [PluginManager] found plugin: "amarok_service_opmldirectory" enabled: false 
amarok:           [PluginManager] 16 plugins in total 
amarok:         END__: void Plugins::PluginManager::findAllPlugins() [Took: 0s] 
amarok:         [PluginManager] created factory for plugin "amarok_collection-audiocdcollection" type: "
Collection" 
amarok:         [PluginManager] created factory for plugin "amarok_collection-mysqlecollection" type: "C
ollection" 
amarok:         BEGIN: void CollectionManager::loadPlugins(const QList<Collections::CollectionFactory*>&
) 
amarok:           [CollectionManager] initializing "amarok_collection-mysqlecollection" 
amarok:           [ERROR__] MySQL library initialization failed. 
amarok:           [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! (2000)  on init" 
amarok:           [MySqlStorage] Initialized thread, count== 1 
amarok:           [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:           [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:           BEGIN: bool DatabaseUpdater::update() 
amarok:             [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:             Database version:  0 
amarok:             BEGIN: void DatabaseUpdater::createTables() const 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:             END__: void DatabaseUpdater::createTables() const [Took: 0.001s] 
amarok:             [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:           END__: bool DatabaseUpdater::update() [Took: 0.001s] 
amarok:           BEGIN: SqlRegistry::SqlRegistry(Collections::SqlCollection*) 
amarok:             [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:             [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:             [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:             [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:             [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:             [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:             [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:             [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:             [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:             [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:             [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:           END__: SqlRegistry::SqlRegistry(Collections::SqlCollection*) [Took: 0s] 
amarok:           BEGIN: virtual int App::newInstance() 
amarok:             BEGIN: static void App::handleCliArgs() 
amarok:             END__: static void App::handleCliArgs() [Took: 0s] 
amarok:           END__: virtual int App::newInstance() [Took: 0s]
 


Title: Re: Amarok error after d-u
Post by: devil on 2015/07/25, 20:52:20

Amarok behaves normal here after the upgrade. Could you please post the output of

Code: [Select]

dpkg -l | grep mysql

greetz
devil

Title: Re: Amarok error after d-u
Post by: ghstryder on 2015/07/25, 21:09:23

FYI Devil, I am also crashing, but with another error. I don't mean to jump in the middle of orinoco's problem, I just post it as info. Amarok worked fine prior to the du.

Code: [Select]

lb@p690:~$ amarok -d
QDBusConnection: session D-Bus connection created before QCoreApplication. Application may misbehave.
QDBusConnection: session D-Bus connection created before QCoreApplication. Application may misbehave.
amarok: BEGIN: App::App()
amarok:   BEGIN: void App::continueInit()
amarok:     BEGIN: EngineController::EngineController()
amarok:     END__: EngineController::EngineController() [Took: 0.002s]
amarok:     BEGIN: void EngineController::initializePhonon()
unnamed app(28944): Communication problem with  "amarok" , it probably crashed.
Error message was:  "org.freedesktop.DBus.Error.NoReply" : " "Message did not receive a reply (timeout by message bus)" "

KCrash: Application 'amarok' crashing...
KCrash: Attempting to start /usr/lib/kde4/libexec/drkonqi from kdeinit
KCrash: Connect sock_file=/home/lb/.kde/socket-p690/kdeinit4__0

Title: Re: Amarok error after d-u
Post by: piper on 2015/07/26, 00:41:25

https://bugs.kde.org/show_bug.cgi?id=323802

Title: Re: Amarok error after d-u
Post by: ghstryder on 2015/07/26, 01:04:15

New version - didn't cure my problem, but it might fix the problem orinoco had.

Code: [Select]

apt-cache policy show amarok
amarok:
  Installed: 2.8.0-2.1+b2
  Candidate: 2.8.0-3


Title: Re: Amarok error after d-u
Post by: piper on 2015/07/26, 03:50:48

It should fix orinoco's problem, tested here, works fine

Title: Re: Amarok error after d-u
Post by: paxmark2 on 2015/07/26, 03:56:16

On an atom netbook  running debian testing with a newly installed amarok  2.8.0-2.1+b1 (SparkyLinux4.0 KDE) gave the standard KDE bug # 323802 warning of  "GREPME MySQLe query failed! (2000) on init" which might have been due to amarok never being used before.  I did import some music and got amarok to play music (first tries were quite garbled) successfully. 

However after a shut down and restart - the same GREPME ... message came up in amarok and amarok-dbg.  Music will play in amarok  --debug. 

apt-cache tells me my sources are coming from debian testing.

Debian bug# 793451 concludes with the belief that  2.8.0-3 should fix things

Title: Re: Amarok error after d-u
Post by: piper on 2015/07/26, 05:22:34

Quote from: paxmark2

On an atom netbook  running debian testing with a newly installed amarok  2.8.0-2.1+b1 (SparkyLinux4.0 KDE) gave the standard KDE bug # 323802 warning of  "GREPME MySQLe query failed! (2000) on init" which might have been due to amarok never being used before.  I did import some music and got amarok to play music (first tries were quite garbled) successfully. 

However after a shut down and restart - the same GREPME ... message came up in amarok and amarok-dbg.  Music will play in amarok  --debug. 

apt-cache tells me my sources are coming from debian testing.

Debian bug# 793451 concludes with the belief that  2.8.0-3 should fix things

Your testing version of amarok is older than what is in sid

Code: [Select]

apt-cache policy amarok
amarok:
  Installed: 2.8.0-3
  Candidate: 2.8.0-3
  Version table:
 *** 2.8.0-3 0
        500 http://httpredir.debian.org/debian/ unstable/main amd64 Packages
        100 /var/lib/dpkg/status
Testing would not be a wise choice to run in debian right now, especially with kf5

Title: Re: Amarok error after d-u
Post by: paxmark2 on 2015/07/26, 15:32:51

Atom netbook in testing probably not a wise choice.  But it's my 3rd machine.  And the transition to kf5 although furious has been quiet, only one apt-mark so far.  And I can wait for DB#793451 to clear to testing.  I'm not complaining, I am having fun. 

Title: Re: Amarok error after d-u
Post by: orinoco on 2015/07/27, 02:44:42

Just run a d-u and I can confirm that amarok works fine again for me. All playlists are back. Puh...


Thanks for feedback and tips.