2012-04-17 GnuCash IRC logs
00:44:34 *** ErKa has joined #gnucash
01:10:09 *** ErKa has quit IRC
01:10:09 *** benoitg has quit IRC
01:10:09 *** markjenkinsparit has quit IRC
01:10:09 *** warlord-afk has quit IRC
01:10:09 *** ironwolf1 has quit IRC
01:10:09 *** zxq9 has quit IRC
01:10:09 *** mishehu has quit IRC
01:10:09 *** wizkid238 has quit IRC
01:10:09 *** mikkom_ has quit IRC
01:10:09 *** mattp has quit IRC
01:10:09 *** blathijs has quit IRC
01:10:09 *** astro has quit IRC
01:10:09 *** puck has quit IRC
01:15:02 *** benoitg has joined #gnucash
01:15:02 *** ErKa has joined #gnucash
01:15:02 *** markjenkinsparit has joined #gnucash
01:15:02 *** warlord-afk has joined #gnucash
01:15:02 *** ironwolf1 has joined #gnucash
01:15:02 *** zxq9 has joined #gnucash
01:15:02 *** mishehu has joined #gnucash
01:15:02 *** wizkid238 has joined #gnucash
01:15:02 *** mikkom_ has joined #gnucash
01:15:02 *** mattp has joined #gnucash
01:15:02 *** blathijs has joined #gnucash
01:15:02 *** astro has joined #gnucash
01:15:02 *** puck has joined #gnucash
01:15:03 *** irc.gimp.ca sets mode: +oo benoitg warlord-afk
01:15:03 *** gncbot sets mode: +o benoitg
01:31:41 *** ErKa has quit IRC
01:37:30 *** wizkid239 has joined #gnucash
01:37:30 *** wizkid238 has quit IRC
02:27:01 *** john has quit IRC
02:34:53 *** GabrieleV has joined #gnucash
02:52:55 *** john has joined #gnucash
02:52:55 *** gncbot sets mode: +o john
03:00:22 *** GabrieleV has quit IRC
03:04:41 *** uXus has joined #gnucash
04:22:25 *** gour has joined #gnucash
07:36:03 *** uXuss has joined #gnucash
07:39:22 *** uXus has quit IRC
07:49:45 *** uXuss has quit IRC
07:59:33 *** GabrieleV has joined #gnucash
08:01:23 *** mikee has quit IRC
08:03:20 *** mikee has joined #gnucash
08:03:21 *** gncbot sets mode: +o mikee
08:15:01 *** GabrieleV has quit IRC
08:16:31 *** warlord-afk is now known as warlord
08:25:26 *** GabrieleV has joined #gnucash
08:36:29 *** benoitg has quit IRC
08:40:41 *** uXus has joined #gnucash
08:55:15 *** john3voltas has joined #gnucash
09:04:01 *** ErKa has joined #gnucash
09:07:22 *** GabrieleV has quit IRC
09:15:01 *** benoitg has joined #gnucash
09:48:17 *** benoitg has quit IRC
10:00:54 *** benoitg has joined #gnucash
10:51:55 *** GabrieleV has joined #gnucash
11:39:32 <GabrieleV> Hello, I'm having trouble opening my data stored in mysql. gnucash says: "GnuCash could not obtain the lock for mysql://gnucash:xxxxx@localhost/gnucash." "That database may be in use by another user, in which case you should not open the database. What would you like to do?"
11:40:15 <GabrieleV> If I Say "Open Anyway" i got "Segmentation fault"
11:49:38 <warlord> Cool!
11:50:06 <warlord> (that error means that you either have another gnucash running, or you somehow killed gnucash without properly exiting)
11:50:20 <warlord> er, not the SEGV, but the "could not obtain lock"
11:50:38 <warlord> As for the SEGV.. Can you get a StackTrace?
11:54:35 <GabrieleV> warlord, I run woth --debug, last line is:
11:54:43 <GabrieleV> * 17:42:16 WARN <gnc.backend.sql> [load_account_guid()] Account ref 'd9dfe368df7d7346aac10bf09023972f' not found
11:54:46 *** benoitg has quit IRC
11:55:28 <warlord> GabrieleV: if there is a SEGV you should get a real stack trace. c.f. http://wiki.gnucash.org/wiki/Stack_Trace
11:55:29 <GabrieleV> warlord, no other gnucash running (ps auxw | grep gnucash)
11:55:50 *** benoitg has joined #gnucash
12:02:24 <GabrieleV> warlord, here is the bt: http://pastebin.com/3JS23pFQ
12:05:29 <warlord> GabrieleV: I suggest you ask on gnucash-devel mailing list; send the backtrace.
12:05:37 <GabrieleV> warlord, here is the backtrace with debugging symbols: http://pastebin.com/3JS23pFQ
12:12:09 <warlord> GabrieleV: try that second link again?
12:12:46 <GabrieleV> warlord, sorry: http://pastebin.com/u17DeWym
12:13:44 <warlord> Do you use the budgeting features?
12:14:22 <GabrieleV> warlord, yes ... but I have only started playing around. I can delete all the budgets if it will solve this
12:14:41 <warlord> Yeah, it is crashing trying to load budgets. Not sure how you can delete it.
12:14:45 <warlord> ... if you can't load it
12:18:55 <GabrieleV> warlord, the tracefile says it can't find a guid account. This guid account is present in the budget table and in the slots table. What is the slots table ?
12:19:53 <warlord> Did you delete an account?
12:20:29 <warlord> the slots table is where the DB stores the KVP frame data. Why are you using MySQL anyways?
12:20:34 <GabrieleV> warlord, May be, I have changed some transations
12:20:50 <warlord> changing a txn wouldn't delete an account
12:21:21 <GabrieleV> warlord, i use mysql because xml storage make me lose my file, and mysql seems better to manage to me than an xml file
12:21:55 <GabrieleV> warlord, Yes, I remember, I deleted two accounts that were empty
12:22:21 <warlord> What do you mean "make[sic] youlose your file?"
12:22:44 <warlord> Ah, well, your budgets were referring to those accounts...
12:22:46 <warlord> (most likely)
12:24:30 <GabrieleV> warlord, maybe, they were insignificant to me, and I think the only budget I have created considered them
12:24:33 <warlord> In 10 years of gnucash usage I have never lost data on xml, let alone losing a whole file.
12:24:54 <warlord> they may have been insignificant to you, but not the budget. har har. ;)
12:25:39 <GabrieleV> warlord, under ubuntu 11.10 the standard version is 2.4.7. There is a bug that if you create a new file, and you don't save it when prompted from the wizard, you can close it without saving and without any warning.
12:28:00 <warlord> Oh, sure, you can lose scratch data. That doesn't count. It's like working in a word processor and not saving your work!
12:28:22 *** benoitg has quit IRC
12:30:46 <GabrieleV> warlord, but now, I can't access my saved data into mysql ;)
12:31:28 <warlord> Well, serves you right for using mysql when it's still in beta ;) --- there is a reason the SQL backend isn't the default!
12:31:29 <warlord> :-D
12:31:45 <GabrieleV> warlord, BETA ?!?!?!
12:31:47 <warlord> Honestly, I think nobody considered this case.
12:32:11 <warlord> You probably should file a bug report, especially if you can recreate the situation.
12:32:51 <GabrieleV> warlord, surely I'll do. I've done also for the first bug
12:33:08 <GabrieleV> but now I will be delighted to have my data back ;)
12:33:50 <GabrieleV> regarding the slots table, what about deleting all the records dealing with the guid of the missing account ?
12:33:56 <warlord> I dont know the mysql tables, so I dont know what to tell you.
12:34:09 <warlord> I also dont know the budget features.
12:35:24 <GabrieleV> I'm waiting for the confirmation message of gnucash-devel ...
12:36:49 *** benoitg has joined #gnucash
12:41:21 *** john3voltas has quit IRC
12:42:06 <GabrieleV> warlord, but the sqlite backend is in BETA too ? I didn't read anithyng about sql beta ...
12:42:07 <warlord> Did you subscribe via the web page?
12:42:22 <GabrieleV> warlord, yes, subscription concluded
12:42:32 <warlord> well, define "beta". As of 2.4.10 all known bugs have been fixed. (2.4.7 probably still has many)
12:42:45 <warlord> .... but it's not as thoroughly tested as the xml backend, which has been around a decade.
12:43:06 <warlord> ... and we don't have full integration tests, so there could easily still be unknown bugs in the sql backend.
12:43:49 <GabrieleV> imho beta is "not distribuited with an os that has a gui" ;)
12:45:17 <warlord> Uh, that makes no sense.
12:45:28 <warlord> again, why do you think it's not the default?
12:48:53 <GabrieleV> warlord, I think because it needs further setup. xml is suitable for single users, sql backend can serve multiple users.
12:56:40 <warlord> No, it cannot.
12:56:51 <warlord> GnuCash is a single-user app, even when using MySQL
12:56:53 <warlord> That is definitely clear in the docs!
12:59:15 <GabrieleV> warlord, so I got to reread the docs :D
13:00:39 <GabrieleV> I don't to be polemic in any way. I only seek support to let gnucash start again with my data :) If mysql is not stable, I'll export my data back to xml :)
13:03:23 <warlord> I would highly recommend you do that..
13:04:00 <warlord> I unfortunately don't know how to get your data back. I dont know enough about the budget features to know what to tell you.
13:04:09 <warlord> You can try asking on the mailing list.
13:04:18 <warlord> And I highly recommend you file a bug report.
13:08:43 <GabrieleV> warlord, Surely. thank you for your time :)
13:14:20 <warlord> You're welcome,and good luck. It's possibly you may be able to just delete the budget data. But I would back up your data before you try.
13:14:30 <warlord> (another benefit of XML -- data backups on every save!)
13:28:20 <GabrieleV> warlord, just tried now. For every run of gnucash I have a mysql dump stored into a git repository
13:28:43 <GabrieleV> Deleting the records with the guid is not enough
13:29:44 <GabrieleV> I had to switch back to my previous backup sessions (one hour back)
13:29:48 <GabrieleV> gott go now :)
13:40:00 *** GabrieleV has quit IRC
14:03:14 *** benoitg has quit IRC
14:06:39 *** benoitg has joined #gnucash
14:10:34 *** gour has quit IRC
14:16:16 *** benoitg has quit IRC
14:20:02 *** benoitg has joined #gnucash
14:22:24 *** benoitg1 has joined #gnucash
14:22:24 *** benoitg has quit IRC
14:33:21 *** benoitg has joined #gnucash
14:33:21 *** benoitg1 has quit IRC
15:13:29 *** jmd has joined #gnucash
15:18:19 *** GabrieleV has joined #gnucash
15:44:03 *** markjenkinsparit has quit IRC
15:46:23 *** Linuturk has quit IRC
15:47:03 *** Linuturk has joined #gnucash
15:54:13 *** nomeata has joined #gnucash
15:54:34 *** g38 has joined #gnucash
15:55:07 <g38> hello. first a remark: using gnucash 2.4.10, the summary bar is not updated when the type of an account is changed.
15:57:11 <g38> then a question: currently, the summary bar displays Net assets and Profits. Can I configure what it displays ? specifically, can I have "Total assets" displayed instead of "Net assets" ?
16:03:09 <warlord> I do not believe it is configurable
16:05:44 *** markjenkinsparit has joined #gnucash
16:07:14 <g38> ok
16:17:17 <GabrieleV> warlord, solved the trouble with mysql :)
16:17:32 <warlord> excellent. What did you have to do?
16:18:29 <GabrieleV> diffed the two mysql dumps, and I saw that there are two inserts into the accounts table correspondig to the missing accounts.
16:18:48 <GabrieleV> I added the two inserts, and the file now loads correctly
16:19:23 <GabrieleV> I've saved it to xml, tried to remove the two accounts, closed and reopened the file and everything works
16:19:25 <GabrieleV> Filed a bug
16:20:40 *** g38 has left #gnucash
16:23:35 <GabrieleV> warlord, xml format is backwards compatible from 2.4.10 (latest) with my 2.4.7 ? I wish to try the latest version from getdeb
16:24:08 <warlord> Yes
16:25:32 *** nomeata has quit IRC
16:26:22 <GabrieleV> Ok, one week testing with the xml file, and after start testing .10 (maybe 12.04 will be out with the latest gnucash ? ;) )
16:30:57 <GabrieleV> In the meantime, I've already setup the versioning of the xml file too. This saved my back with mysql too ;)
16:46:39 <warlord> Yeah, I think 12.04 will have 2.4.10
17:01:15 *** fell has joined #gnucash
17:01:15 *** gncbot sets mode: +o fell
17:09:56 *** jmd has quit IRC
17:46:38 *** benoitg has quit IRC
18:30:21 *** GabrieleV has quit IRC
18:34:51 *** benoitg has joined #gnucash
18:34:52 *** gncbot sets mode: +o benoitg
18:48:38 *** benoitg has quit IRC
20:55:28 *** john has quit IRC
22:49:45 *** warlord is now known as warlord-afk
23:56:40 *** fell has quit IRC