Archive for the 'GnuCash' Category

Trying Gnucash GDA / GNOME-DB Again

Distribution: Debian lenny/sid
Gnome Release: 2.22.0 2008-03-14 (Debian)
BugBuddy Version: 2.22.0
 
System: Linux 2.6.22-3-686 #1 SMP Sun Feb 10 20:20:49 UTC 2008 i686
X Vendor: The X.Org Foundation
X Vendor Release: 10300000
Selinux: No
Accessibility: Disabled
GTK+ Theme: Glossy
Icon Theme: gnome
 
Memory status: size: 81100800 vsize: 81100800 resident: 39096320 share: 16273408 rss: 39096320 rss_rlim: 4294967295
CPU usage: start_time: 1208997749 rtime: 780 utime: 766 stime: 14 cutime:16 cstime: 1 timeout: 0 it_real_value: 0 frequency: 100
 
Backtrace was generated from '/usr/local/bin/gnucash'
 
Using host libthread_db library "/lib/i686/cmov/libthread_db.so.1".
[Thread debugging using libthread_db enabled]
[New Thread 0xb6827a20 (LWP 10997)]
[New Thread 0xb500cb90 (LWP 10999)]
0xffffe410 in __kernel_vsyscall ()
#0  0xffffe410 in __kernel_vsyscall ()
#1  0xb738a8eb in waitpid () from /lib/i686/cmov/libpthread.so.0
#2  0xb76496b4 in g_spawn_sync () from /usr/lib/libglib-2.0.so.0
#3  0xb76499cc in g_spawn_command_line_sync () from /usr/lib/libglib-2.0.so.0
#4  0xb7f70198 in ?? () from /usr/lib/gtk-2.0/modules/libgnomebreakpad.so
#5  <signal handler called>
#6  0xb75c33a0 in qof_instance_set_guid (ptr=0x82e3360, guid=0x0) at qofinstance.c:490
#7  0xb75c3f8f in qof_instance_set_property (object=0x82e3360, prop_id=2, value=0xbfc494d4, pspec=0x8224a00) at qofinstance.c:421
#8  0xb76a1bc6 in g_object_set_valist () from /usr/lib/libgobject-2.0.so.0
#9  0xb76a2186 in g_object_set () from /usr/lib/libgobject-2.0.so.0
#10 0xb5fbae75 in load_guid (be=0x85b2cb8, pModel=0x85b7940, row=0, setter=0, pObject=0x82e3360, table_row=0xb5fc71e0) at gnc-backend-util-gda.c:694
#11 0xb5fb9f5e in gnc_gda_load_object (be=0x85b2cb8, pModel=0x85b7940, row=0, obj_name=0xb5fc4e81 "Book", pObject=0x82e3360, table_row=0xb5fc71e0)
    at gnc-backend-util-gda.c:1417
#12 0xb5fbe4aa in load_all_books (be=0x85b2cb8) at gnc-book-gda.c:147
#13 0xb5fcc23b in gnc_gda_load (be_start=0x85b2cb8, book=0x82e3360) at gnc-backend-gda.c:409
#14 0xb75cff8a in qof_session_load (session=0x858b008, percentage_func=0xb74729f0 <gnc_window_show_progress>) at qofsession.c:1139
#15 0xb7435120 in gnc_post_file_open (filename=<value optimized out>) at gnc-file.c:786
#16 0x0804ad1e in inner_main (closure=0x0, argc=1, argv=0xbfc499c4) at gnucash-bin.c:475
#17 0xb7efb5d2 in scm_boot_guile () from /usr/lib/libguile.so.12
#18 0x0804a9d3 in main (argc=) at gnucash-bin.c:624
 
Thread 2 (Thread 0xb500cb90 (LWP 10999)):
#0  0xffffe410 in __kernel_vsyscall ()
No symbol table info available.
#1  0xb738999b in read () from /lib/i686/cmov/libpthread.so.0
No symbol table info available.
#2  0xb76146bf in ?? () from /usr/lib/libglib-2.0.so.0
No symbol table info available.
#3  0x0000000f in ?? ()
No symbol table info available.
#4  0xb500c308 in ?? ()
No symbol table info available.
#5  0x00000014 in ?? ()
No symbol table info available.
#6  0x00002af7 in ?? ()
No symbol table info available.
#7  0xb76897e8 in ?? () from /usr/lib/libglib-2.0.so.0
No symbol table info available.
#8  0xb76897e4 in ?? () from /usr/lib/libglib-2.0.so.0
No symbol table info available.
#9  0xb500c308 in ?? ()
No symbol table info available.
#10 0xb7bc811c in ?? () from /usr/lib/libgthread-2.0.so.0
No symbol table info available.
#11 0x0858f250 in ?? ()
No symbol table info available.
#12 0xb7385a0c in __pthread_mutex_unlock_usercnt () from /lib/i686/cmov/libpthread.so.0
No symbol table info available.
#13 0xb763b30f in ?? () from /usr/lib/libglib-2.0.so.0
No symbol table info available.
#14 0x00000000 in ?? ()
No symbol table info available.
 
Thread 1 (Thread 0xb6827a20 (LWP 10997)):
#0  0xffffe410 in __kernel_vsyscall ()
No symbol table info available.
#1  0xb738a8eb in waitpid () from /lib/i686/cmov/libpthread.so.0
No symbol table info available.
#2  0xb76496b4 in g_spawn_sync () from /usr/lib/libglib-2.0.so.0
No symbol table info available.
#3  0xb76499cc in g_spawn_command_line_sync () from /usr/lib/libglib-2.0.so.0
No symbol table info available.
#4  0xb7f70198 in ?? () from /usr/lib/gtk-2.0/modules/libgnomebreakpad.so
No symbol table info available.
#5  <signal handler called>
No symbol table info available.
#6  0xb75c33a0 in qof_instance_set_guid (ptr=0x82e3360, guid=0x0) at qofinstance.c:490
	col = (QofCollection *) 0x85f73b0
	__PRETTY_FUNCTION__ = "qof_instance_set_guid"
#7  0xb75c3f8f in qof_instance_set_property (object=0x82e3360, prop_id=2, value=0xbfc494d4, pspec=0x8224a00) at qofinstance.c:421
	inst = (QofInstance *) 0x82e3360
	__PRETTY_FUNCTION__ = "qof_instance_set_property"
#8  0xb76a1bc6 in g_object_set_valist () from /usr/lib/libgobject-2.0.so.0
No symbol table info available.
#9  0xb76a2186 in g_object_set () from /usr/lib/libgobject-2.0.so.0
No symbol table info available.
#10 0xb5fbae75 in load_guid (be=0x85b2cb8, pModel=0x85b7940, row=0, setter=0, pObject=0x82e3360, table_row=0xb5fc71e0) at gnc-backend-util-gda.c:694
	val = (const GValue *) 0x82e3360
	guid = {data = \210ûµ(\n\"\b\fVüµ¸\206üµ", __align_me = -1241806600}
	pGuid = (const GUID *) 0x0
	__PRETTY_FUNCTION__ = "load_guid"
#11 0xb5fb9f5e in gnc_gda_load_object (be=0x85b2cb8, pModel=0x85b7940, row=0, obj_name=0xb5fc4e81 "Book", pObject=0x82e3360, table_row=0xb5fc71e0)
    at gnc-backend-util-gda.c:1417
	setter = (QofSetterFunc) 0
	pHandler = (col_type_handler_t *) 0x82e33a0
	__PRETTY_FUNCTION__ = "gnc_gda_load_object"
#12 0xb5fbe4aa in load_all_books (be=0x85b2cb8) at gnc-book-gda.c:147
	pModel = (GdaDataModel *) 0x85b7940
	numRows = <value optimized out>
	query = (GdaQuery *) 0x821edb0
	__PRETTY_FUNCTION__ = "load_all_books"
#13 0xb5fcc23b in gnc_gda_load (be_start=0x85b2cb8, book=0x82e3360) at gnc-backend-gda.c:409
	root = <value optimized out>
	__PRETTY_FUNCTION__ = "gnc_gda_load"
	__FUNCTION__ = "gnc_gda_load"
#14 0xb75cff8a in qof_session_load (session=0x858b008, percentage_func=0xb74729f0 <gnc_window_show_progress>) at qofsession.c:1139
	newbook = (QofBook *) 0x82e3360
	ob = <value optimized out>
	oldbooks = (QofBookList *) 0x8598c70
	node = <value optimized out>
	be = (QofBackend *) 0x85b2cb8
	err = <value optimized out>
	__FUNCTION__ = "qof_session_load"
#15 0xb7435120 in gnc_post_file_open (filename=<value optimized out>) at gnc-file.c:786
	new_root = <value optimized out>
	logpath = <value optimized out>
	current_session = <value optimized out>
	new_session = (QofSession *) 0x858b008
	uh_oh = <value optimized out>
	newfile = 0x858f5c0 "gda://@SalesTest"
	io_err = <value optimized out>
	__FUNCTION__ = "gnc_post_file_open"
#16 0x0804ad1e in inner_main (closure=0x0, argc=1, argv=0xbfc499c4) at gnucash-bin.c:475
	main_mod = <value optimized out>
	fn = 0x8592380 "gda://@SalesTest"
	error = (GError *) 0x0
#17 0xb7efb5d2 in scm_boot_guile () from /usr/lib/libguile.so.12
No symbol table info available.
#18 0x0804a9d3 in main (argc=) at gnucash-bin.c:624
No locals.
#0  0xffffe410 in __kernel_vsyscall ()
The program is running.  Quit anyway (and detach it)? (y or n) [answered Y; input not from terminal]
 
 
----------- .xsession-errors ---------------------
(gnome-panel:3700): Wnck-WARNING **: Unhandled action type _OB_WM_ACTION_UNDECORATE
(gnome-panel:3700): Wnck-WARNING **: Unhandled action type _OB_WM_ACTION_UNDECORATE
(gnome-panel:3700): Wnck-WARNING **: Unhandled action type _OB_WM_ACTION_UNDECORATE
(gnome-panel:3700): Wnck-WARNING **: Unhandled action type _OB_WM_ACTION_UNDECORATE
(gnome-panel:3700): Wnck-WARNING **: Unhandled action type _OB_WM_ACTION_UNDECORATE
(gnome-panel:3700): Wnck-WARNING **: Unhandled action type _OB_WM_ACTION_UNDECORATE
(gnome-panel:3700): Wnck-WARNING **: Unhandled action type _OB_WM_ACTION_UNDECORATE
(gnome-panel:3700): Wnck-WARNING **: Unhandled action type _OB_WM_ACTION_UNDECORATE
--------------------------------------------------

I had to remove .libgda/* and .gnucash/*

I was able to run it again, but I’m not sure exactly which step did it, I cleared out the following in no specific order:
~/.gnucash
~/.gconf/gnucash
~/libgda/
/etc/gnucash/
/etc/libgda-0.3

I can then open gnucash, create a new file, and quit. When I start it again, I get this error:

#14 0xb75daf8a in qof_session_load (session=0x84e81e8,
    percentage_func=0xb747d9f0 <gnc_window_show_progress>)
    at qofsession.c:1139
    newbook = (QofBook *) 0x80a9d20
    ob = <value optimized out>
    oldbooks = (QofBookList *) 0x84f3550
    node = <value optimized out>
    be = (QofBackend *) 0x8512b18
    err = <value optimized out>
    __FUNCTION__ = "qof_session_load"
#15 0xb7440120 in gnc_post_file_open (filename=<value optimized out>)
    at gnc-file.c:786
    new_root = <value optimized out>
    logpath = <value optimized out>
    current_session = <value optimized out>
    new_session = (QofSession *) 0x84e81e8
    uh_oh = <value optimized out>
    newfile = 0x84b4ee0 "/home/albertlash/.gnucash/data/barf.db"
    io_err = <value optimized out>
    __FUNCTION__ = "gnc_post_file_open"
#16 0x0804ad1e in inner_main (closure=0x0, argc=1, argv=0xbfd6b734)
    at gnucash-bin.c:475
    main_mod = <value optimized out>
    fn = 0x84f6c30 "/home/albertlash/.gnucash/data/barf.db"
    error = (GError *) 0x0
#17 0xb7f065d2 in scm_boot_guile () from /usr/lib/libguile.so.12
No symbol table info available.
#18 0x0804a9d3 in main (argc=) at gnucash-bin.c:624
No locals.

I feel like its almost there…. but I still have a few questions:
* What is this database connection for:

Gnucash Database Connection Dialogue Box

I just emailed the gnucash dev list, maybe someone will have a hint. I also looked into gda docs again, and found mergeant. Looks like a nice admin tool for gnome-db (aka gda).