Bug 273390 - Tried to perform query on uninitialized MySQL [@ ScanManager::addDirToList]
Summary: Tried to perform query on uninitialized MySQL [@ ScanManager::addDirToList]
Status: RESOLVED NOT A BUG
Alias: None
Product: amarok
Classification: Applications
Component: Collections/Local (show other bugs)
Version: 2.4.1
Platform: Ubuntu Linux
: NOR crash
Target Milestone: 2.4.1
Assignee: Amarok Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-05-16 08:41 UTC by pordonez31
Modified: 2011-09-10 20:24 UTC (History)
3 users (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments
New crash information added by DrKonqi (9.71 KB, text/plain)
2011-07-31 09:01 UTC, Christoph Obexer
Details

Note You need to log in before you can comment on or make changes to this bug.
Description pordonez31 2011-05-16 08:41:01 UTC
Application: amarok (2.4.1)
KDE Platform Version: 4.6.2 (4.6.2)
Qt Version: 4.7.2
Operating System: Linux 2.6.38-8-generic x86_64
Distribution: Ubuntu 11.04

-- Information about the crash:
Using MariaDB, Ubuntu Natty,

The crash can be reproduced every time.

-- Backtrace:
Application: Amarok (amarok), signal: Segmentation fault
[Current thread is 1 (Thread 0x7f4625c5f7c0 (LWP 28088))]

Thread 8 (Thread 0x7f461018e700 (LWP 28089)):
#0  0x00007f4622337f03 in __poll (fds=<value optimized out>, nfds=<value optimized out>, timeout=<value optimized out>) at ../sysdeps/unix/sysv/linux/poll.c:87
#1  0x00007f461cb34104 in ?? () from /lib/x86_64-linux-gnu/libglib-2.0.so.0
#2  0x00007f461cb349f2 in g_main_loop_run () from /lib/x86_64-linux-gnu/libglib-2.0.so.0
#3  0x00007f4610aedc44 in ?? () from /usr/lib/x86_64-linux-gnu/libgio-2.0.so.0
#4  0x00007f461cb5b3e4 in ?? () from /lib/x86_64-linux-gnu/libglib-2.0.so.0
#5  0x00007f4614d2c853 in ?? () from /usr/lib/nvidia-current/libGL.so.1
#6  0x00007f461e13cd8c in start_thread (arg=0x7f461018e700) at pthread_create.c:304
#7  0x00007f462234504d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#8  0x0000000000000000 in ?? ()

Thread 7 (Thread 0x7f45f3c38700 (LWP 28101)):
#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:216
#1  0x00007f45fcc53f41 in ?? () from /usr/lib/libxine.so.1
#2  0x00007f4614d2c853 in ?? () from /usr/lib/nvidia-current/libGL.so.1
#3  0x00007f461e13cd8c in start_thread (arg=0x7f45f3c38700) at pthread_create.c:304
#4  0x00007f462234504d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#5  0x0000000000000000 in ?? ()

Thread 6 (Thread 0x7f45f3437700 (LWP 28102)):
#0  0x00007f4622bd42b8 in QElapsedTimer::isMonotonic () at tools/qelapsedtimer_unix.cpp:109
#1  0x00007f4622c9615d in QTimerInfoList::repairTimersIfNeeded (this=0x205cb50) at kernel/qeventdispatcher_unix.cpp:395
#2  0x00007f4622c961c6 in QTimerInfoList::timerWait (this=0x205cb50, tm=...) at kernel/qeventdispatcher_unix.cpp:443
#3  0x00007f4622c94c2c in timerSourcePrepareHelper (src=<value optimized out>, timeout=0x7f45f3436b2c) at kernel/qeventdispatcher_glib.cpp:136
#4  0x00007f4622c94cd5 in timerSourcePrepare (source=<value optimized out>, timeout=<value optimized out>) at kernel/qeventdispatcher_glib.cpp:169
#5  0x00007f461cb330a2 in g_main_context_prepare () from /lib/x86_64-linux-gnu/libglib-2.0.so.0
#6  0x00007f461cb33f9d in ?? () from /lib/x86_64-linux-gnu/libglib-2.0.so.0
#7  0x00007f461cb34639 in g_main_context_iteration () from /lib/x86_64-linux-gnu/libglib-2.0.so.0
#8  0x00007f4622c95446 in QEventDispatcherGlib::processEvents (this=0x20fb1c0, flags=<value optimized out>) at kernel/qeventdispatcher_glib.cpp:424
#9  0x00007f4622c69882 in QEventLoop::processEvents (this=<value optimized out>, flags=...) at kernel/qeventloop.cpp:149
#10 0x00007f4622c69abc in QEventLoop::exec (this=0x7f45f3436cb0, flags=...) at kernel/qeventloop.cpp:201
#11 0x00007f4622b80924 in QThread::exec (this=<value optimized out>) at thread/qthread.cpp:492
#12 0x00007f45fceb239e in ?? () from /usr/lib/qt4/plugins/phonon_backend/phonon_xine.so
#13 0x00007f4622b83175 in QThreadPrivate::start (arg=0x2057f20) at thread/qthread_unix.cpp:320
#14 0x00007f4614d2c853 in ?? () from /usr/lib/nvidia-current/libGL.so.1
#15 0x00007f461e13cd8c in start_thread (arg=0x7f45f3437700) at pthread_create.c:304
#16 0x00007f462234504d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#17 0x0000000000000000 in ?? ()

Thread 5 (Thread 0x7f45f2a31700 (LWP 28103)):
#0  0x00007f4622337f03 in __poll (fds=<value optimized out>, nfds=<value optimized out>, timeout=<value optimized out>) at ../sysdeps/unix/sysv/linux/poll.c:87
#1  0x00007f461a16332f in ?? () from /usr/lib/libpulse.so.0
#2  0x00007f461a155116 in pa_mainloop_poll () from /usr/lib/libpulse.so.0
#3  0x00007f461a155749 in pa_mainloop_iterate () from /usr/lib/libpulse.so.0
#4  0x00007f461a155800 in pa_mainloop_run () from /usr/lib/libpulse.so.0
#5  0x00007f461a1632df in ?? () from /usr/lib/libpulse.so.0
#6  0x00007f4615b28a88 in ?? () from /usr/lib/libpulsecommon-0.9.22.so
#7  0x00007f4614d2c853 in ?? () from /usr/lib/nvidia-current/libGL.so.1
#8  0x00007f461e13cd8c in start_thread (arg=0x7f45f2a31700) at pthread_create.c:304
#9  0x00007f462234504d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#10 0x0000000000000000 in ?? ()

Thread 4 (Thread 0x7f45ee22f700 (LWP 28104)):
#0  pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162
#1  0x00007f45fcc65d63 in ?? () from /usr/lib/libxine.so.1
#2  0x00007f4614d2c853 in ?? () from /usr/lib/nvidia-current/libGL.so.1
#3  0x00007f461e13cd8c in start_thread (arg=0x7f45ee22f700) at pthread_create.c:304
#4  0x00007f462234504d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#5  0x0000000000000000 in ?? ()

Thread 3 (Thread 0x7f45ed421700 (LWP 28105)):
#0  pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162
#1  0x00007f45fcc65d63 in ?? () from /usr/lib/libxine.so.1
#2  0x00007f4614d2c853 in ?? () from /usr/lib/nvidia-current/libGL.so.1
#3  0x00007f461e13cd8c in start_thread (arg=0x7f45ed421700) at pthread_create.c:304
#4  0x00007f462234504d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#5  0x0000000000000000 in ?? ()

Thread 2 (Thread 0x7f45ecc20700 (LWP 28106)):
#0  pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162
#1  0x00007f45fcc65d63 in ?? () from /usr/lib/libxine.so.1
#2  0x00007f4614d2c853 in ?? () from /usr/lib/nvidia-current/libGL.so.1
#3  0x00007f461e13cd8c in start_thread (arg=0x7f45ecc20700) at pthread_create.c:304
#4  0x00007f462234504d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#5  0x0000000000000000 in ?? ()

Thread 1 (Thread 0x7f4625c5f7c0 (LWP 28088)):
[KCrash Handler]
#6  0x00007f45ea46f783 in ScanManager::addDirToList (this=0x238d890, directory=...) at ../../../../../../src/core-impl/collections/db/ScanManager.cpp:179
#7  0x00007f45ea47001e in ScanManager::requestIncrementalScan (this=0x238d890, directory=...) at ../../../../../../src/core-impl/collections/db/ScanManager.cpp:149
#8  0x00007f45ea469bae in ScanManager::checkForDirectoryChanges (this=0x238d890) at ../../../../../../src/core-impl/collections/db/ScanManager.cpp:304
#9  0x00007f45ea46fbdc in ScanManager::qt_metacall (this=0x238d890, _c=QMetaObject::InvokeMetaMethod, _id=<value optimized out>, _a=0x7fff6e01c380) at ./ScanManager.moc:119
#10 0x00007f4622c7f5f8 in QMetaObject::activate (sender=0x2396160, m=<value optimized out>, local_signal_index=<value optimized out>, argv=0x0) at kernel/qobject.cpp:3287
#11 0x00007f4622c7e1c9 in QObject::event (this=0x2396160, e=<value optimized out>) at kernel/qobject.cpp:1190
#12 0x00007f46236299e4 in QApplicationPrivate::notify_helper (this=0x1d98c60, receiver=0x2396160, e=0x7fff6e01ca80) at kernel/qapplication.cpp:4462
#13 0x00007f462362e3aa in QApplication::notify (this=<value optimized out>, receiver=0x2396160, e=0x7fff6e01ca80) at kernel/qapplication.cpp:4341
#14 0x00007f462567d866 in KApplication::notify (this=0x7fff6e01e280, receiver=0x2396160, event=0x7fff6e01ca80) at ../../kdeui/kernel/kapplication.cpp:311
#15 0x00007f4622c6a49c in QCoreApplication::notifyInternal (this=0x7fff6e01e280, receiver=0x2396160, event=0x7fff6e01ca80) at kernel/qcoreapplication.cpp:731
#16 0x00007f4622c97f12 in sendEvent (this=0x1d97bd0) at ../../include/QtCore/../../src/corelib/kernel/qcoreapplication.h:215
#17 QTimerInfoList::activateTimers (this=0x1d97bd0) at kernel/qeventdispatcher_unix.cpp:604
#18 0x00007f4622c94d18 in timerSourceDispatch (source=<value optimized out>) at kernel/qeventdispatcher_glib.cpp:184
#19 idleTimerSourceDispatch (source=<value optimized out>) at kernel/qeventdispatcher_glib.cpp:231
#20 0x00007f461cb33bcd in g_main_context_dispatch () from /lib/x86_64-linux-gnu/libglib-2.0.so.0
#21 0x00007f461cb343a8 in ?? () from /lib/x86_64-linux-gnu/libglib-2.0.so.0
#22 0x00007f461cb34639 in g_main_context_iteration () from /lib/x86_64-linux-gnu/libglib-2.0.so.0
#23 0x00007f4622c953ef in QEventDispatcherGlib::processEvents (this=0x1beb6f0, flags=<value optimized out>) at kernel/qeventdispatcher_glib.cpp:422
#24 0x00007f46236d0dfe in QGuiEventDispatcherGlib::processEvents (this=<value optimized out>, flags=<value optimized out>) at kernel/qguieventdispatcher_glib.cpp:204
#25 0x00007f4622c69882 in QEventLoop::processEvents (this=<value optimized out>, flags=...) at kernel/qeventloop.cpp:149
#26 0x00007f4622c69abc in QEventLoop::exec (this=0x7fff6e01ccf0, flags=...) at kernel/qeventloop.cpp:201
#27 0x00007f4623ae88e6 in QDialog::exec (this=0x23a86d0) at dialogs/qdialog.cpp:552
#28 0x00007f46255ec66a in KMessageBox::createKMessageBox (dialog=0x23a86d0, icon=<value optimized out>, text=..., strlist=<value optimized out>, ask=..., checkboxReturn=0x0, options=..., details=..., notifyType=QMessageBox::Critical) at ../../kdeui/dialogs/kmessagebox.cpp:337
#29 0x00007f46255ece7b in KMessageBox::createKMessageBox (dialog=0x23a86d0, icon=QMessageBox::Critical, text=..., strlist=..., ask=..., checkboxReturn=0x0, options=..., details=...) at ../../kdeui/dialogs/kmessagebox.cpp:152
#30 0x00007f46255edab2 in KMessageBox::errorListWId (parent_id=0, text=..., strlist=..., caption=..., options=...) at ../../kdeui/dialogs/kmessagebox.cpp:847
#31 0x00007f46255edc8b in KMessageBox::error (parent=<value optimized out>, text=<value optimized out>, caption=..., options=<value optimized out>) at ../../kdeui/dialogs/kmessagebox.cpp:814
#32 0x00007f45ea476e2e in Collections::SqlCollection::SqlCollection (this=<value optimized out>, id=..., prettyName=<value optimized out>, storage=0x23c8210) at ../../../../../../src/core-impl/collections/db/sql/SqlCollection.cpp:175
#33 0x00007f45ea47950f in Collections::SqlCollectionFactory::createSqlCollection (this=<value optimized out>, id=..., prettyName=..., storage=0x23c8210) at ../../../../../../src/core-impl/collections/db/sql/SqlCollectionFactory.cpp:31
#34 0x00007f45ea93d599 in Collections::MySqlEmbeddedCollectionFactory::init (this=0x23bc6e0) at ../../../../../../../src/core-impl/collections/db/sql/mysqlecollection/MySqlEmbeddedCollection.cpp:35
#35 0x00007f46249e0f85 in CollectionManager::loadPlugins (this=0x1bbba50, factories=<value optimized out>) at ../../src/core-impl/collections/support/CollectionManager.cpp:202
#36 0x00007f46249e16b9 in CollectionManager::init (this=0x1bbba50, factories=<value optimized out>) at ../../src/core-impl/collections/support/CollectionManager.cpp:170
#37 0x00007f4624c2cc35 in Plugins::PluginManager::init (this=0x2385350) at ../../src/PluginManager.cpp:80
#38 0x00007f4624c2d959 in Plugins::PluginManager::PluginManager (this=0x2385350, parent=<value optimized out>) at ../../src/PluginManager.cpp:62
#39 0x00007f4624c2db1a in Plugins::PluginManager::instance () at ../../src/PluginManager.cpp:41
#40 0x00007f4624c0fd58 in pluginManager (this=0x1bd4930) at ../../src/PluginManager.h:76
#41 MainWindow::MainWindow (this=0x1bd4930) at ../../src/MainWindow.cpp:149
#42 0x00007f4624bc8371 in App::continueInit (this=0x7fff6e01e280) at ../../src/App.cpp:625
#43 0x00007f4624bc9d77 in App::App (this=0x7fff6e01e280) at ../../src/App.cpp:209
#44 0x000000000040a0ed in main (argc=2, argv=0x7fff6e020888) at ../../src/main.cpp:286

Reported using DrKonqi
Comment 1 Ralf Engels 2011-05-16 09:46:01 UTC
Hi,
where does the "Tried to perform query on uninitialized MySQL" come from? 
Does the crash happen directly after starting Amarok?
Does Amarok crash when using the internal database?
Comment 2 pordonez31 2011-05-16 21:00:36 UTC
Hi there

where does the "Tried to perform query on uninitialized MySQL" come from? 

The name is the title of the message error window.

Does the crash happen directly after starting Amarok?

Yes, either using cli to launch the app or using a launcher desktop.

Does Amarok crash when using the internal database?

The first debug report was using the internal db, and for the second report I 
created a user for Amarok and I check the box in Amarok  settings.

Be aware that I'm using MariaDB.


Any other information that you need please do not hesitate to contact me.


Pablo



----- Original Message ----
From: Ralf Engels <ralf.engels@nokia.com>
To: pordonez31@yahoo.com
Sent: Mon, May 16, 2011 3:46:02 AM
Subject: [Bug 273390] Tried to perform query on uninitialized MySQL [@ 
ScanManager::addDirToList]

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





--- Comment #1 from Ralf Engels <ralf engels nokia com>  2011-05-16 09:46:01 ---
Hi,
where does the "Tried to perform query on uninitialized MySQL" come from? 
Does the crash happen directly after starting Amarok?
Does Amarok crash when using the internal database?
Comment 3 Myriam Schweingruber 2011-06-20 10:22:39 UTC
Any news on this?
Comment 4 Christoph Obexer 2011-07-31 09:01:23 UTC
Created attachment 62372 [details]
New crash information added by DrKonqi

amarok (2.4.1) on KDE Platform 4.7.00 (4.7.0) using Qt 4.7.3

- What I was doing when the application crashed:

amarok:         BEGIN: void CollectionManager::init(const QList<Plugins::PluginFactory*>&) 
amarok:           BEGIN: void CollectionManager::loadPlugins(const QList<Collections::CollectionFactory*>&) 
amarok:             [CollectionManager] initializing "amarok_collection-mysqlecollection" 
110731 10:50:06 InnoDB: The InnoDB memory heap is disabled
110731 10:50:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins
110731 10:50:06 InnoDB: Compressed tables use zlib 1.2.5
110731 10:50:06 InnoDB: Initializing buffer pool, size = 128,0M
110731 10:50:06 InnoDB: Completed initialization of buffer pool
110731 10:50:06 InnoDB: highest supported file format is Barracuda.
110731 10:50:06  InnoDB: Waiting for the background threads to start
amarok:             [ERROR__] MySQL library initialization failed. 
amarok:             [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! (2000)  on init" 
amarok:             BEGIN: bool DatabaseUpdater::update() 
amarok:               [MySqlStorage] Initialized thread, count== 1 
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 


then after a few seconds amarok crashed like this.

since this is the first time i use amarok since the KDE 4.7 update that might be the problem.

as far as i know I'm using the internal mysql db.

christoph-game:~ # rpm -qa|grep sql|sort
libmysqlclient-devel-5.5.14-1.2.x86_64
libmysqlclient16-5.1.42-69.10.x86_64
libmysqlclient18-32bit-5.5.14-1.2.x86_64
libmysqlclient18-5.5.14-1.2.x86_64
libmysqlclient_r16-32bit-5.1.42-69.10.x86_64
libmysqlclient_r16-5.1.42-69.10.x86_64
libmysqlclient_r18-5.5.14-1.2.x86_64
libmysqlcppconn1-1.0.5-11.4.x86_64
libmysqld-devel-5.5.14-1.2.x86_64
libmysqld18-5.5.14-1.2.x86_64
libqt4-sql-32bit-4.7.3-8.1.x86_64
libqt4-sql-4.7.3-8.1.x86_64
libqt4-sql-mysql-32bit-4.7.3-8.1.x86_64
libqt4-sql-mysql-4.7.3-8.1.x86_64
libqt4-sql-sqlite-32bit-4.7.3-8.1.x86_64
libqt4-sql-sqlite-4.7.3-8.1.x86_64
libreoffice-base-drivers-mysql-3.3.3.1-1.1.x86_64
libsqlite3-0-3.7.7-45.6.x86_64
libsqlite3-0-32bit-3.7.7-45.6.x86_64
mono-data-sqlite-2.10.2-2.2.x86_64
mysql-community-server-5.5.14-1.2.x86_64
mysql-community-server-bench-5.5.14-1.2.x86_64
mysql-community-server-client-5.5.14-1.2.x86_64
mysql-community-server-tools-5.5.14-1.2.x86_64
mysql-proxy-0.6.1-3.75.x86_64
mysql-workbench-5.2.31-33.7.x86_64
perl-DBD-mysql-4.019-2.5.x86_64
php5-mysql-5.3.6.201105291701-1.1.x86_64
php5-pear-MDB2_Driver_mysqli-1.4.1-5.2.noarch
php5-sqlite-5.3.6.201105291701-1.1.x86_64
sqlite2-2.8.17-185.14.x86_64
sqlite3-3.7.7-45.6.x86_64
sqlite3-devel-3.7.7-45.6.x86_64

there is a newer version of amarok available in my repositories, in case that fixes this bug I'll add this here after updating
amarok                                 2.4.1-114.6 -> 2.4.1-114.8

-- Backtrace (Reduced):
#6  0x00007f98ab866871 in ScanManager::addDirToList (this=0xf15170, directory=...) at /usr/src/debug/amarok-2.4.1/src/core-impl/collections/db/ScanManager.cpp:179
#7  0x00007f98ab86714e in ScanManager::requestIncrementalScan (this=0xf15170, directory=...) at /usr/src/debug/amarok-2.4.1/src/core-impl/collections/db/ScanManager.cpp:149
#8  0x00007f98ab860cd6 in ScanManager::checkForDirectoryChanges (this=0xf15170) at /usr/src/debug/amarok-2.4.1/src/core-impl/collections/db/ScanManager.cpp:304
#9  0x00007f98ab866d0c in ScanManager::qt_metacall (this=0xf15170, _c=QMetaObject::InvokeMetaMethod, _id=<optimized out>, _a=0x7fff31686c00) at /usr/src/debug/amarok-2.4.1/build/src/core-impl/collections/db/sql/ScanManager.moc:119
[...]
#11 0x00007f98cd0fd7b9 in QObject::event (this=0xf1bca0, e=<optimized out>) at kernel/qobject.cpp:1181
Comment 5 Ralf Engels 2011-08-02 11:14:13 UTC
2.4.2 should not longer crash.
The reason for the crash is probably some problem with the external database.
Maybe updating the database packages would help.
Comment 6 Myriam Schweingruber 2011-09-10 20:24:23 UTC
Closing for lack of feedback. Feel free to reopen this report if you can still reproduce this with Amarok 2.4.3 or later.