Bug 124959

Summary: kexi freeze after adding unsuccessfully a new mysql connection
Product: [Applications] KEXI Reporter: Jaime Torres <jtamate>
Component: GeneralAssignee: Jarosław Staniek <staniek>
Status: CLOSED FIXED    
Severity: normal CC: mail, philipp.sternberg
Priority: NOR    
Version: 1.0 rc1 (KOffice 1.5 rc1)   
Target Milestone: ---   
Platform: unspecified   
OS: Linux   
Latest Commit: Version Fixed In:
Sentry Crash Report:

Description Jaime Torres 2006-04-05 10:41:34 UTC 
Version:           1.0 beta 2 (KOffice 1.5 rc1) (using KDE 3.5.2, compiled sources)
Compiler:          Target: i686-pc-linux-gnu
OS:                Linux (i686) release 2.6.16

I open a kexi instance, choose new empty database, new proyect stored on database server, button append, with mysql as motor, enter something in the username and the same information as password, and with the mysql stoped, test the connection. After the message saying:

No se pudo conectar con el servidor de base de datos «blabla@localhost».

kexi freezes, I can not do anything more with it.

It only happens to me when the username and password are the same.

And the last messages in the stdout are:

KexiDB (driver impl): MySqlConnectionInternal::connect()
KexiDB (driver impl): MySqlConnection::disconnect()
KexiDB: Object ERROR: 2002:
KexiDB: ConnectionTestDialog::error()

Best regards.
Comment 1 Jaime Torres 2006-07-18 12:50:42 UTC 
It is still there in koffice 1.5.2, and it is related to the multithread code of the test window. It happens sometimes after various unsuccessful tests.

 It is frozen in a wait for the test to finish.

Best regards.
Comment 2 Jarosław Staniek 2006-09-25 13:12:50 UTC 
*** Bug 134608 has been marked as a duplicate of this bug. ***
Comment 3 Jaime Torres 2006-10-05 10:27:46 UTC 
I've been investigating a little further,
and I think the problem is related to this method in utils.cpp:

void ConnectionTestDialog::error(KexiDB::Object *obj)
{ ......
m_wait.wait(); 
}

because the wait is never wakedup. At least, if I use a KexiDBDbg after the wait, never writes to the console.

I hope it helps to solve this bug.

Best regards.
Comment 4 Jens Dagerbo 2006-12-06 01:08:38 UTC 
I just ran into this one. Gentoo Koffice 1.6.1 ebuild on AMD64 system.

Reproduces exactly as said in bug #134608. Click "Test Connection" twice.

Backtrace, if it can help any:

0x00002aecb94b3706 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
(gdb) bt
#0  0x00002aecb94b3706 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
#1  0x00002aecb775b5f7 in QThread::wait () from /usr/qt/3/lib64/libqt-mt.so.3
#2  0x00002aecb4e09226 in ConnectionTestDialog::exec () from /usr/lib64/libkexidb.so.2
#3  0x00002aecb4e0cada in KexiDB::connectionTestDialog () from /usr/lib64/libkexidb.so.2
#4  0x00002aecb46d573c in KexiDBConnectionTabWidget::slotTestConnection () from /usr/lib64/libkexiextendedwidgets.so.2
#5  0x00002aecb46d57bd in KexiDBConnectionTabWidget::qt_invoke () from /usr/lib64/libkexiextendedwidgets.so.2
#6  0x00002aecb77b76ec in QObject::activate_signal () from /usr/qt/3/lib64/libqt-mt.so.3
#7  0x00002aecb77b8393 in QObject::activate_signal () from /usr/qt/3/lib64/libqt-mt.so.3
#8  0x00002aecb77ea156 in QWidget::event () from /usr/qt/3/lib64/libqt-mt.so.3
#9  0x00002aecb7761555 in QApplication::internalNotify () from /usr/qt/3/lib64/libqt-mt.so.3
#10 0x00002aecb7762341 in QApplication::notify () from /usr/qt/3/lib64/libqt-mt.so.3
#11 0x00002aecb6ae68fe in KApplication::notify () from /usr/kde/3.5/lib64/libkdecore.so.4
#12 0x00002aecb770abc4 in QETWidget::translateMouseEvent () from /usr/qt/3/lib64/libqt-mt.so.3
#13 0x00002aecb7709ce1 in QApplication::x11ProcessEvent () from /usr/qt/3/lib64/libqt-mt.so.3
#14 0x00002aecb771897f in QEventLoop::processEvents () from /usr/qt/3/lib64/libqt-mt.so.3
#15 0x00002aecb7775d32 in QEventLoop::enterLoop () from /usr/qt/3/lib64/libqt-mt.so.3
#16 0x00002aecb791266b in QDialog::exec () from /usr/qt/3/lib64/libqt-mt.so.3
#17 0x00002aecb3da2f40 in KexiConnSelectorWidget::slotRemoteAddBtnClicked () from /usr/lib64/libkeximain.so.2
#18 0x00002aecb3da391f in KexiConnSelectorWidget::qt_invoke () from /usr/lib64/libkeximain.so.2
#19 0x00002aecb77b76ec in QObject::activate_signal () from /usr/qt/3/lib64/libqt-mt.so.3
#20 0x00002aecb77b8393 in QObject::activate_signal () from /usr/qt/3/lib64/libqt-mt.so.3
#21 0x00002aecb77ea156 in QWidget::event () from /usr/qt/3/lib64/libqt-mt.so.3
#22 0x00002aecb7761555 in QApplication::internalNotify () from /usr/qt/3/lib64/libqt-mt.so.3
#23 0x00002aecb7762341 in QApplication::notify () from /usr/qt/3/lib64/libqt-mt.so.3
#24 0x00002aecb6ae68fe in KApplication::notify () from /usr/kde/3.5/lib64/libkdecore.so.4
#25 0x00002aecb770abc4 in QETWidget::translateMouseEvent () from /usr/qt/3/lib64/libqt-mt.so.3
#26 0x00002aecb7709ce1 in QApplication::x11ProcessEvent () from /usr/qt/3/lib64/libqt-mt.so.3
#27 0x00002aecb771897f in QEventLoop::processEvents () from /usr/qt/3/lib64/libqt-mt.so.3
#28 0x00002aecb7775d32 in QEventLoop::enterLoop () from /usr/qt/3/lib64/libqt-mt.so.3
#29 0x00002aecb791266b in QDialog::exec () from /usr/qt/3/lib64/libqt-mt.so.3
#30 0x00002aecb3d76ea5 in KexiMainWindowImpl::createBlankProjectData () from /usr/lib64/libkeximain.so.2
#31 0x00002aecb3d84c0d in KexiMainWindowImpl::createBlankProject () from /usr/lib64/libkeximain.so.2
#32 0x00002aecb3d8747a in KexiMainWindowImpl::startup () from /usr/lib64/libkeximain.so.2
#33 0x00002aecb3d877b6 in KexiMainWindowImpl::create () from /usr/lib64/libkeximain.so.2
#34 0x00002aecb3c09055 in kdemain () from /usr/lib64/libkdeinit_kexi.so
#35 0x00002aecb9b59374 in __libc_start_main () from /lib/libc.so.6
Comment 5 Joris Dedieu 2007-03-14 10:18:39 UTC 
I have the same crash with kexi 1.1.1 on debian (testing & unstable). When I test connexion with a postgresql server and wrong parameters, just after I answer the error dialog, kexi don't refresh anymore.
Comment 6 Elias Probst 2007-04-15 18:42:34 UTC 
Happens here too:

Gentoo
KOffice/Kexi 1.6.2
Connection to MySQL server on localhost

Strace output:
ioctl(3, FIONREAD, [0])                 = 0
ioctl(3, FIONREAD, [0])                 = 0
gettimeofday({1176655227, 841939}, NULL) = 0
gettimeofday({1176655227, 842145}, NULL) = 0
gettimeofday({1176655227, 842348}, NULL) = 0
gettimeofday({1176655227, 842539}, NULL) = 0
gettimeofday({1176655227, 842726}, NULL) = 0
futex(0x81c6db4, 0x4 /* FUTEX_??? */, 1) = 0
gettimeofday({1176655227, 843202}, NULL) = 0
futex(0xb6b77ea4, FUTEX_WAKE, 2147483647) = 0
futex(0x81c6dd4, FUTEX_WAIT, 2, NULL
Comment 7 Jarosław Staniek 2010-04-26 00:24:34 UTC 
SVN commit 1118804 by staniek:

KexiDB
*fix crash or freeze for testing database connection on error or timeout
BUG:124959
CCBUG:234536



 M  +55 -54    utils.cpp  
 M  +1 -1      utils.h  
 M  +24 -5     utils_p.h  


WebSVN link: http://websvn.kde.org/?view=rev&revision=1118804
Comment 8 Jarosław Staniek 2010-04-26 00:32:36 UTC 
SVN commit 1118810 by staniek:

meged with trunk fixes

KexiDB
*fix crash or freeze for testing database connection on error or timeout
CCBUG:124959
CCBUG:234536

KexiDB
*fixed crash in connection data handling
CCBUG:234536
*fix crash when testing database connection and debug gui is enabled (related to using gui in different thread)
CCBUG:234194

KexiDB
*fix possible crash when adding two or more new columns to a table at once
CCBUG:234194



 _M            . (directory)  
 M  +2 -1      connectiondata.cpp  
 M  +55 -54    utils.cpp  
 M  +1 -1      utils.h  
 M  +24 -5     utils_p.h  


WebSVN link: http://websvn.kde.org/?view=rev&revision=1118810
Comment 9 Jarosław Staniek 2010-04-26 23:29:39 UTC 
SVN commit 1119267 by staniek:

port KexiDB r1118804
*fix crash or freeze for testing database connection on error or timeout
CCBUG:124959
CCBUG:234536



 M  +53 -57    Utils.cpp  
 M  +1 -1      Utils.h  
 M  +29 -8     Utils_p.h  


WebSVN link: http://websvn.kde.org/?view=rev&revision=1119267