[Kmymoney-devel] [kmymoney4] [Bug 327494] New: SQL database creation crash when trying to connect to a remote Mysql (Percona) server

lp.allard.1 at gmail.com lp.allard.1 at gmail.com
Tue Nov 12 12:33:43 UTC 2013 

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

            Bug ID: 327494
           Summary: SQL database creation crash when trying to connect to
                    a remote Mysql (Percona) server
    Classification: Unclassified
           Product: kmymoney4
           Version: 4.6.4
          Platform: Compiled Sources
                OS: Linux
            Status: UNCONFIRMED
          Severity: grave
          Priority: NOR
         Component: general
          Assignee: kmymoney-devel at kde.org
          Reporter: lp.allard.1 at gmail.com

I believe I may have found a bug in the current 4.6.4 release in regards to SQL
database feature.

I am currently using a .kmy file and tried to migrate to a remote MySQL
database.  The application is crashing severely when I hit the OK button of the
database creation window.

I get an error popup saying:

Cannot open database
sql://remoteuser@serverip/kmymoney?driver=QMYSQL&secure=yes

Details:

Error in function int MyMoneyStorageSql::upgradeDb() : Error retrieving file
info(version)

Driver = QMYSQL, Host = serverip, User = remoteuser, Database = kmymoney
Driver Error:
Database Error No -1:
Text:
Error type 0
Executed: SELECT version FROM kmmFileInfo;
Query error No -1:
Error type 0

Then I click OK and it crashes.


Reproducible: Always

Steps to Reproduce:
1- Close current kmy file
2-File -> Open database
3-Database type: QMYSQL - MYSQL
4-DB name: kmymoney (identical to the DB on the remote server)
5-hostname: IP of the remote server
6-username:  username that has full rights on dtaabase kmymoney on the
remote SQL server
7-password: password of the user above
8-Click OK
Actual Results:  
KMM crashes, see above for actual results and "Additional info" for backtrace.

Expected Results:  
Connect to the remote MySQL server

Backtrace:

Application: KMyMoney (kmymoney), signal: Segmentation fault

[Current thread is 1 (Thread 0x7f2150ba2780 (LWP 15838))]

Thread 2 (Thread 0x7f214268e700 (LWP 15839)):

#0 0x00007f214b3968b3 in poll () from /lib64/libc.so.6

#1 0x00007f214540ce34 in ?? () from /usr/lib64/libglib-2.0.so.0

#2 0x00007f214540d742 in g_main_loop_run () from /usr/lib64/libglib-2.0.so.0

#3 0x00007f2142bb7e64 in ?? () from /usr/lib64/libgio-2.0.so.0

#4 0x00007f2145434126 in ?? () from /usr/lib64/libglib-2.0.so.0

#5 0x00007f214dfe3d6b in start_thread () from /lib64/libpthread.so.0

#6 0x00007f214b3a0abd in clone () from /lib64/libc.so.6

Thread 1 (Thread 0x7f2150ba2780 (LWP 15838)):

[KCrash Handler]

#6 0x0000000000809d6a in MyMoneyStorageSql::writeFileInfo
(this=0x1357b50) at
/home/louis-philippe/kmymoney-4.6.4/kmymoney/mymoney/storage/mymoneystoragesql.cpp:2356

#7 0x000000000080b8c7 in MyMoneyStorageSql::close (this=0x1357b50,
logoff=<value optimized out>) at
/home/louis-philippe/kmymoney-4.6.4/kmymoney/mymoney/storage/mymoneystoragesql.cpp:229

#8 0x000000000083da91 in ~MyMoneyStorageSql (this=<value optimized out>,
__in_chrg=<value optimized out>) at
/home/louis-philippe/kmymoney-4.6.4/kmymoney/mymoney/storage/mymoneystoragesql.h:141

#9 MyMoneyStorageSql::~MyMoneyStorageSql (this=<value optimized out>,
__in_chrg=<value optimized out>) at
/home/louis-philippe/kmymoney-4.6.4/kmymoney/mymoney/storage/mymoneystoragesql.h:142

#10 0x00000000004c798d in ~KSharedPtr (this=0xe26840, url=<value
optimized out>) at /usr/include/ksharedptr.h:90

#11 KMyMoneyView::openDatabase (this=0xe26840, url=<value optimized
out>) at
/home/louis-philippe/kmymoney-4.6.4/kmymoney/views/kmymoneyview.cpp:884

#12 0x00000000004c81df in KMyMoneyView::readFile (this=0xe26840,
url=<value optimized out>) at
/home/louis-philippe/kmymoney-4.6.4/kmymoney/views/kmymoneyview.cpp:643

#13 0x0000000000497b0e in KMyMoneyApp::slotFileOpenRecent
(this=0xc8a690, url=...) at
/home/louis-philippe/kmymoney-4.6.4/kmymoney/kmymoney.cpp:1529

#14 0x000000000049851f in KMyMoneyApp::slotOpenDatabase (this=0xc8a690)
at /home/louis-philippe/kmymoney-4.6.4/kmymoney/kmymoney.cpp:1444

#15 0x00000000004a1dff in KMyMoneyApp::qt_metacall (this=0xc8a690,
_c=QMetaObject::InvokeMetaMethod, _id=112, _a=0x7fffbe2f8d40) at
/home/louis-philippe/kmymoney-4.6.4/build/kmymoney/kmymoney.moc:515

#16 0x00007f214cecf60f in QMetaObject::activate(QObject*, QMetaObject
const*, int, void**) () from /usr/lib64/qt/lib/libQtCore.so.4

#17 0x00007f214bfe9092 in QAction::triggered(bool) () from
/usr/lib64/qt/lib/libQtGui.so.4

#18 0x00007f214bfe928a in QAction::activate(QAction::ActionEvent) ()
from /usr/lib64/qt/lib/libQtGui.so.4

#19 0x00007f214c41f423 in ?? () from /usr/lib64/qt/lib/libQtGui.so.4

#20 0x00007f214c4253ba in ?? () from /usr/lib64/qt/lib/libQtGui.so.4

#21 0x00007f214f2bb76d in KMenu::mouseReleaseEvent(QMouseEvent*) () from
/usr/lib64/libkdeui.so.5

#22 0x00007f214c040df8 in QWidget::event(QEvent*) () from
/usr/lib64/qt/lib/libQtGui.so.4

#23 0x00007f214c4265ab in QMenu::event(QEvent*) () from
/usr/lib64/qt/lib/libQtGui.so.4

#24 0x00007f214bfef724 in QApplicationPrivate::notify_helper(QObject*,
QEvent*) () from /usr/lib64/qt/lib/libQtGui.so.4

#25 0x00007f214bff4a3c in QApplication::notify(QObject*, QEvent*) ()
from /usr/lib64/qt/lib/libQtGui.so.4

#26 0x00007f214f1eabf6 in KApplication::notify(QObject*, QEvent*) ()
from /usr/lib64/libkdeui.so.5

#27 0x00007f214ceba1ac in QCoreApplication::notifyInternal(QObject*,
QEvent*) () from /usr/lib64/qt/lib/libQtCore.so.4

#28 0x00007f214bff0735 in QApplicationPrivate::sendMouseEvent(QWidget*,
QMouseEvent*, QWidget*, QWidget*, QWidget**, QPointer<QWidget>&, bool)
() from /usr/lib64/qt/lib/libQtGui.so.4

#29 0x00007f214c06e18c in ?? () from /usr/lib64/qt/lib/libQtGui.so.4

#30 0x00007f214c06c649 in QApplication::x11ProcessEvent(_XEvent*) ()
from /usr/lib64/qt/lib/libQtGui.so.4

#31 0x00007f214c093af2 in ?? () from /usr/lib64/qt/lib/libQtGui.so.4

#32 0x00007f214540c8f3 in g_main_context_dispatch () from
/usr/lib64/libglib-2.0.so.0

#33 0x00007f214540d0d0 in ?? () from /usr/lib64/libglib-2.0.so.0

#34 0x00007f214540d36d in g_main_context_iteration () from
/usr/lib64/libglib-2.0.so.0

#35 0x00007f214cee51ff in
QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>)
() from /usr/lib64/qt/lib/libQtCore.so.4

#36 0x00007f214c09379e in ?? () from /usr/lib64/qt/lib/libQtGui.so.4

#37 0x00007f214ceb9562 in
QEventLoop::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () from
/usr/lib64/qt/lib/libQtCore.so.4

#38 0x00007f214ceb97ac in
QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () from
/usr/lib64/qt/lib/libQtCore.so.4

#39 0x00007f214cebdc4b in QCoreApplication::exec() () from
/usr/lib64/qt/lib/libQtCore.so.4

#40 0x000000000045948a in runKMyMoney (splash=<value optimized out>,
a=<value optimized out>) at
/home/louis-philippe/kmymoney-4.6.4/kmymoney/main.cpp:282

#41 0x000000000045b353 in main (argc=1, argv=0x7fffbe2fb298) at
/home/louis-philippe/kmymoney-4.6.4/kmymoney/main.cpp:181

-- 
You are receiving this mail because:
You are the assignee for the bug.

More information about the KMyMoney-devel mailing list