[Kmymoney-devel] [Bug 286503] New: MySQL error while importing large QIF file.

[Mac Michaels]

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

           Summary: MySQL error while importing large QIF file.
           Product: kmymoney4
           Version: 4.6.1
          Platform: Gentoo Packages
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: crash
          Priority: NOR
         Component: general
        AssignedTo: kmymoney-devel at kde.org
        ReportedBy: thebitpit at earthlink.net


Version:           4.6.1 (using KDE 4.6.5) 
OS:                Linux

  After running 2 days importing 15 years of Quicken data in QIF file I got a
error message that I failed to capture the text of. As I recall it was about a
missing security definition.

  I clicked OK and got the following error message:

Problem adding or matching imported transaction with id '2001-07-11-e26e2d3-1':
Error in function const QMap<QString, MyMoneyTransaction>
MyMoneyStorageSql::fetchTransactions(const QString&, const QString&, bool)
const : reading Transaction
Driver = QMYSQL, Host = drum, User = wmichaels1, Database = KMyMoney
Driver Error: QMYSQL: Unable to rollback transaction
Database Error No 2006: MySQL server has gone away
Text: MySQL server has gone away QMYSQL: Unable to rollback transaction
Error type 2
Executed: SELECT id, txType, postDate, memo, entryDate, currencyId, bankId FROM
kmmTransactions WHERE txType = 'N'  ORDER BY id;
Query error No 2006: MySQL server has gone away QMYSQL: Unable to execute query
Error type 2

  I clicked continue and got this message:

Problem adding or matching imported transaction with id '2001-07-25-60a04f1-1':
Error in \
function const QMap<QString, MyMoneyTransaction>
MyMoneyStorageSql::fetchTransactions(con\
st QString&, const QString&, bool) const : reading Transaction
Driver = QMYSQL, Host = drum, User = wmichaels1, Database = KMyMoney
Driver Error: QMYSQL: Unable to rollback transaction
Database Error No 2006: MySQL server has gone away
Text: MySQL server has gone away QMYSQL: Unable to rollback transaction
Error type 2
Executed: SELECT id, txType, postDate, memo, entryDate, currencyId, bankId FROM
kmmTransa\
ctions WHERE txType = 'N'  ORDER BY id;
Query error No 2006: MySQL server has gone away QMYSQL: Unable to execute query
Error type 2

  I clicked continue and got the above sequence of 3 error message boxes
several times.

  I clicked cancel and got the following error box:

Uncaught error. Please report the details to the developers
details:
Empty commit unit stack while trying to commit in file
/vault2/distfiles/tmp/portage/app-office/kmymoney-4.6.1/work/kmymoney-4.6.1/kmymoney/mymoney/storage/mymoneystoragesql.cpp
line 885

  The application closed and crash bug report screen came up.  Here is the
generated crash data:

Application: KMyMoney (kmymoney), signal: Aborted
[Current thread is 1 (Thread 0x7f26c7df0760 (LWP 7858))]

Thread 2 (Thread 0x7f26b08bb700 (LWP 7873)):
#0  0x00007f26c25c6a53 in poll () from /lib64/libc.so.6
#1  0x00007f26bd66d4bd in g_main_context_iterate.clone.6 () from
/usr/lib64/libglib-2.0.so.0
#2  0x00007f26bd66d9ed in g_main_context_iteration () from
/usr/lib64/libglib-2.0.so.0
#3  0x00007f26c4089046 in
QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) ()
from /usr/lib64/qt4/libQtCore.so.4
#4  0x00007f26c405d482 in
QEventLoop::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () from
/usr/lib64/qt4/libQtCore.so.4
#5  0x00007f26c405d6c4 in
QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () from
/usr/lib64/qt4/libQtCore.so.4
#6  0x00007f26c3f736b4 in QThread::exec() () from /usr/lib64/qt4/libQtCore.so.4
#7  0x00007f26c403f038 in QInotifyFileSystemWatcherEngine::run() () from
/usr/lib64/qt4/libQtCore.so.4
#8  0x00007f26c3f75f05 in QThreadPrivate::start(void*) () from
/usr/lib64/qt4/libQtCore.so.4
#9  0x00007f26c51b1c5c in start_thread () from /lib64/libpthread.so.0
#10 0x00007f26c25cf67d in clone () from /lib64/libc.so.6

Thread 1 (Thread 0x7f26c7df0760 (LWP 7858)):
[KCrash Handler]
#6  0x00007f26c2530835 in raise () from /lib64/libc.so.6
#7  0x00007f26c2531b35 in abort () from /lib64/libc.so.6
#8  0x00007f26c2dbbadd in __gnu_cxx::__verbose_terminate_handler() () from
/usr/lib/gcc/x86_64-pc-linux-gnu/4.5.3/libstdc++.so.6
#9  0x00007f26c2db9d16 in __cxxabiv1::__terminate(void (*)()) () from
/usr/lib/gcc/x86_64-pc-linux-gnu/4.5.3/libstdc++.so.6
#10 0x00007f26c2db9d43 in std::terminate() () from
/usr/lib/gcc/x86_64-pc-linux-gnu/4.5.3/libstdc++.so.6
#11 0x00007f26c2db9e4e in __cxa_throw () from
/usr/lib/gcc/x86_64-pc-linux-gnu/4.5.3/libstdc++.so.6
#12 0x000000000045c759 in main ()

  I canceled the bug reporting wizard.

  I restarted application manually and the KMyMoney database login reported
that the database was in use, restart anyway.  The application took much longer
to start than quicken with the same data on a much slower computer.  None of
the stock accounts had any shares of stock in them.  There were entries in the
checking accounts.  Response when switching accounts is very slow.

Reproducible: Didn't try

Steps to Reproduce:
Select MySQL as the database in KMyMoney.
Import a vary large QIF file (8,655,192 bytes)
Let it run 2 or 3 days on an Intel Core2 system.

Actual Results:  
Got error messages described above.

Expected Results:  
Complete with all QIF data properly imported.

OS: Linux (x86_64) release 3.0.6-gentoo
Compiler: x86_64-pc-linux-gnu-gcc

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.