<div dir="ltr"><div><div><div>I was able to use KMM 4.8.1.1 for about 4hr before my box became unresponsive. I don't know if it was due to a memory leak or something else. Nothing showed in the output and I was not really paying attention to what top was reporting regarding memory usage, I was focusing on cpu usage. During the whole time KMM peaked at 30% when it was processing the update request I made.<br><br></div>I entered some transaction and noticed a discrepancy in speeds. When I entered a transaction from the scheduled section it took about 3 sec but when I entered a transaction via the ledger section it took about 6 sections per entry. When I imported a OFX file I downloaded from my bank it took a while to process the small file (did not time the process) but when I did an update from KMM against my bank account it took almost 2 hours to process the 124 entries it downloaded. When I use to do this with 4.6 it use to take 10 to 15 mins.<br><br></div>I uninstall KMM and re-install it using the package manager (which is 4.8.0-2) and see if I notice any difference in speed or if my system become unresponsive with this version but turns out I couldn't use it since it has the bug where the table kmmPayeesPayeeIdentifier has a field called <b>order</b>, but order is a MySQL keyword. I even tried renaming the field just to see if it would work but it did not. So I just reinstalled 4.8.1.1 and continued using it. This time I will send top's output to a file so I can see the memory and CPU usage if I my box becomes unresponsive again.<br><br></div>I also tried to build KMM 5.0 but but it doesn't seem to be able to find libalkimia5 (I have both the normal and dev installed). I did not have to set it anything for it when I build 4.8.1.1 from source. Do I just locate the lib file and set <b>LibAlkimia5_DIR</b> to it when I run cmake or do I need to do something else? (I'm still a noob when it comes to building from source)<br><br><b>CMake Error at CMakeLists.txt:58 (find_package):<br>By not providing "FindLibAlkimia5.cmake" in CMAKE_MODULE_PATH this project<br> has asked CMake to find a package configuration file provided by<br> "LibAlkimia5", but CMake did not find one.<br><br> Could not find a package configuration file provided by "LibAlkimia5"<br> (requested version 7.0.0) with any of the following names:<br><br> LibAlkimia5Config.cmake<br> libalkimia5-config.cmake<br><br> Add the installation prefix of "LibAlkimia5" to CMAKE_PREFIX_PATH or set<br> "LibAlkimia5_DIR" to a directory containing one of the above files. If<br> "LibAlkimia5" provides a separate development package or SDK, be sure it<br> has been installed.</b><br><br><br><br></div><div class="gmail_extra"><br><div class="gmail_quote">On Sun, Feb 25, 2018 at 4:37 PM, El Cas <span dir="ltr"><<a href="mailto:eaglexboy@gmail.com" target="_blank">eaglexboy@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div>It appears it finished processing my entries. I was able to start up the application and it logged in and loaded my database.<br><br></div>First off, thanks for adding the Tags feature as adding the tags in memo was not the best way to search and group transactions. The one thing I have noticed is that it's take a bit longer to switch between sections and accounts in the ledger compared to 4.6.6 (from ~2 sec to ~6sec). I have the filter set to only show the past two months. To see if it would make a difference I changed the filter to the start of month (so it only show the past 25 days) but the response time remained about the same. The only thing I saw in the terminal was <b>KMyMoneyPlugin::PluginLoader:: createInstanceFromService returned 0 for SEPA orders with error Could not find plugin 'SEPA orders' for application 'kmymoney' </b>when I updated the filter. I don't know if this delay is due to the way it communicates with DB now vs 4.6.6 or if something else is going on. I made sure to not have anything else running that would make it appear that KMM was running slow. At its peak KMM used 8% of my CPU and 137Mb of RAM.<br><br>System specs <br>Processor: AMD Fx-4350 Quad Core <br>Memory: 32Gb Ram, 64 Gb Swap<br></div><div>OS: Kubuntu 17.10 (Kernel 4.13.0-36)/64-Bit<br><br></div><div>Is there something I can do to speed up or check why it's taking longer then normal?<br><br></div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Sun, Feb 25, 2018 at 3:39 PM, El Cas <span dir="ltr"><<a href="mailto:eaglexboy@gmail.com" target="_blank">eaglexboy@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div>So after running for 11 hours my box became unresponsive. I could move the mouse and the cursor reflected the move but that was all I could do. I tried to SSH and I got a response to the connect attempt but never got prompted for password (which would make sense seeing how I could only use the mouse on it).<br><br></div>I have 32,248 rows in <b>kmmsplits</b> which is a good amount but I don't know how exactly the code cycles through them during 2 < 4. If it loads them in memory then this would explain why my box appeared to be unresponsive. I tried to build it with debug enabled but I can't seem to build i. I keep getting the following two errors.<br><br>/kmm/kmymoney/libkdchart/src/K<wbr>DChart/Cartesian/KDChartCartes<wbr>ianAxis.cpp: In member function ‘void KDChart::TickIterator::compute<wbr>MajorTickLabel(int)’:<br>/mnt/WorkingFolder/temp/kmm/km<wbr>ymoney/libkdchart/src/KDChart/<wbr>Cartesian/KDChartCartesianAxis<wbr>.cpp:276:46: <b>error</b>: conversion from ‘QMap<double, QString>::iterator’ to non-scalar type ‘QMap<double, QString>::ConstIterator {aka QMap<double, QString>::const_iterator}’ requested<br> <b>m_dataHeaderLabels.lowerBound( slightlyLessThan( m_position ) );<br> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^<wbr>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<wbr>~~~</b><br>/mnt/WorkingFolder/temp/kmm/km<wbr>ymoney/libkdchart/src/KDChart/<wbr>Cartesian/KDChartCartesianAxis<wbr>.cpp: In member function ‘void KDChart::TickIterator::operato<wbr>r++()’:<br>/mnt/WorkingFolder/temp/kmm/km<wbr>ymoney/libkdchart/src/KDChart/<wbr>Cartesian/KDChartCartesianAxis<wbr>.cpp:306:76: <b>error</b>: conversion from ‘QMap<double, QString>::iterator’ to non-scalar type ‘QMap<double, QString>::ConstIterator {aka QMap<double, QString>::const_iterator}’ requested<br> <b>QMap< qreal, QString >::ConstIterator it = m_annotations.upperBound( m_position );<br> <wbr> ~~~~~~~~~~~~~~~~~~~~~~~~^~~~~~<wbr>~~~~~~~~</b><br><br></div>I ran <b>cmake -D CMAKE_BUILD_TYPE=Debugfull ..</b> and <b>make</b> as the README.cmake said to do. Am I missing something?<br><br></div>Is there another way to monitor what is going on during the looping of records in 2 < 4?<br><div><div><div><br></div><div>While I await for a response I will try to run it again and direct all output to a file so that if it hangs again I can at least see what it spit out on the terminal.<br></div><div><br> </div></div></div></div><div class="m_1254213818902980866HOEnZb"><div class="m_1254213818902980866h5"><div class="gmail_extra"><br><div class="gmail_quote">On Sun, Feb 25, 2018 at 9:53 AM, Thomas Baumgart <span dir="ltr"><<a href="mailto:thb@net-bembel.de" target="_blank">thb@net-bembel.de</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span><br>
On Sonntag, 25. Februar 2018 04:51:18 CET El Cas wrote:<br>
<br>
> On Sun, Feb 25, 2018 at 2:31 AM, Thomas Baumgart <<a href="mailto:thb@net-bembel.de" target="_blank">thb@net-bembel.de</a>> wrote:<br>
> > Having the DB on a separate server should not make a difference. All<br>
> > communication (incl. structure updates etc) between KMyMoney and the SQL<br>
> > DB is<br>
> > via a communication link.<br>
> ><br>
> > I am not sure, if bringing in 5.0 at this point is a good alternative. You<br>
> > might have a trouble to go back to 4.8 unless you want to stick with 5.0.<br>
> > Since you're building from source also, use the 5.0 branch, not master. It<br>
> > already contains a couple of bug-fixes over the released 5.0 version.<br>
><br>
> The reason I was using Kubuntu 18.04/KMM 5.0 was because 18.04 is<br>
> scheduled to be released in April and if this fixed my problem I would just<br>
> going to completely upgrade my system to 18.04/5.0 ahead of scheduled.<br>
><br>
> So while using Kubuntu 18.04/KMM 5.0 I was getting a database user error so<br>
> I just temporarily granted the username I am using for KMM all privileges.<br>
> I created an empty test account and proceeded to save as DB. I put in the<br>
> required information and when I clicked on Ok. Got the error below.<br>
><br>
</span>> *Error in function int MyMoneyStorageSql::open(const QUrl&, int, bool) :<br>
> opening new database*<br>
><br>
> *Driver = QMYSQL, Host = X.X.X.X, User = kmymoney, Database = /newkmymoney*<br>
><br>
> *Driver Error: QMYSQL: Unable to connect*<br>
><br>
> *Database Error No 1049: Unknown database '/newkmymoney'*<br>
><br>
> *Text: Unknown database '/newkmymoney' QMYSQL: Unable to connect*<br>
><br>
> *Error type 1*<br>
><br>
> *Executed: *<br>
<span>><br>
> *Query error No -1: *<br>
><br>
> *Error type 0*<br>
><br>
</span><span>> I checked the DB server and the Database was created but it was empty.<br>
><br>
> So I went back to Kubuntu 17.10/KMM 4.8.1.1 (from source) and repeated the<br>
> same process. This time the test database was created and the tables were<br>
> created. I decided to attempt to open my original database and got the same<br>
> error I reported in my first email.<br>
><br>
> As for difference between 4.8.1.1 vs 4.6.6 I found the following<br>
><br>
</span>> 4.6 has 24 tables vs 23 tables on 4.8: *kmmtmpfileinfo*<br>
<br>
That's not a problem. This seems to be some leftover from a previous run<br>
(probably the creation of the new columns in kmmfileinfo). You should be able<br>
to drop that table.<br>
<span><br>
> And the following tables have extra columns<br>
> Version tablename field name<br>
> type Null? Default Value<br>
</span>> 4.8 *kmmfileinfo* hiOnlineJobId bigint(20) unsigned<br>
> YES NULL<br>
> 4.8 *kmmfileinfo* hiPayeeIdentifierId bigint(20) unsigned<br>
> YES NULL<br>
> 4.8 *kmmschedules* lastDayInMonth char(1)<br>
> NO NULL<br>
> 4.8 *kmmsplits* costCenterId varchar(32)<br>
> YES NULL<br>
<br>
Those are the new columns that were added in 4.8. So that looks about right<br>
and 4.8 cannot start w/o them.<br>
<span><br>
> I made a back up of my current DB and added the missing fields to the<br>
> corresponding tables and I was able to open the Database. It proceeded load<br>
</span>> and when it reached 97% it began to do *testing fileFixVersion*. During the<br>
> 0 < 4 run it performed several *Fixed interest action in XXXX* actions. It<br>
> then ran *testing fileFixVersion* *1 < 4 and 2 <4 *has been running for a<br>
<span>> long time (almost 2hr as of this email). I don't know how long the testing<br>
> normally takes but I will let it continue running and see how long it takes<br>
> to finish.<br>
><br>
> I am going to check on it when I wake up. I will report any progress, or<br>
> lack there off.<br>
<br>
</span>filefix 2 < 4 is doing the following according to the source code:<br>
<br>
// scan the transactions and modify transactions with two splits<br>
// which reference an account and a category to have the memo text<br>
// of the account.<br>
<br>
filefix 3 < 4 is doing the following:<br>
<br>
// make sure each storage object contains a (unique) id<br>
<br>
That is just a single operation and should not take long.<br>
<br>
<br>
I can't tell you anything about the speed. Usually I use KMyMoney with a GPG<br>
encrypted XML file and not a database backend.<br>
<span><br>
<br>
--<br>
<br>
Regards<br>
<br>
Thomas Baumgart<br>
<br>
<a href="https://www.telegram.org/" rel="noreferrer" target="_blank">https://www.telegram.org/</a> Telegram, the better WhatsApp<br>
------------------------------<wbr>------------------------------<wbr>-<br>
</span>You cannot strengthen the weak by weakening the strong.<br>
------------------------------<wbr>------------------------------<wbr>-<br>
</blockquote></div><br></div>
</div></div></blockquote></div><br></div>
</div></div></blockquote></div><br></div>