Bug 325100 – crash when trying to edit an account using postgres data

After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.

Bug 325100 - crash when trying to edit an account using postgres data


Summary:	crash when trying to edit an account using postgres data


Status:	VERIFIED DUPLICATE of bug 153183

Product:	GnuCash
Classification:	Other
Component:	Backend - SQL
Version:	1.8.x
Hardware:	Other All

Importance:	Normal critical
Target Milestone:	---
Assigned To:	Chris Shoemaker
QA Contact:	linas

URL:
Whiteboard:

Depends on:
Blocks:

Reported:	2005-12-28 05:09 UTC by jamie
Modified:	2018-06-29 20:54 UTC

See Also:
GNOME target:	---
GNOME version:	---

Description jamie 2005-12-28 05:09:43 UTC

Steps to reproduce:
1. open gnucash
2. create a new set of accounts using "Business Accounts"
3. save as postgres://localhost.localdomain/gntestdb
4. "yes" to create the database
5. click "assets"
6. click "current assets"
7. doubleclick "checking account"


Stack trace:

+ Trace 64840

#0 waitpid
from /lib/tls/libc.so.6
#1 gnome_init
from /usr/lib/libgnomeui.so.32
#2 <signal handler called>
#3 xaccTransGetSplitList
at Transaction.c line 2659
#4 gnc_split_register_add_transaction
at split-register-load.c line 106
#5 gnc_split_register_load
at split-register-load.c line 464
#6 gnc_ledger_display_refresh_internal
at gnc-ledger-display.c line 830
#7 gnc_ledger_display_refresh
at gnc-ledger-display.c line 842
#8 gsr_setup_table
at gnc-split-reg.c line 409
#9 gnc_split_reg_new
at gnc-split-reg.c line 339
#10 regWindowLedger
at window-register.c line 943
#11 regWindowSimple
at window-register.c line 220
#12 gnc_acct_tree_window_activate_cb
at window-acct-tree.c line 746
#13 gtk_marshal_NONE__POINTER
from /usr/lib/libgtk-1.2.so.0
#14 gtk_signal_connect_while_alive
from /usr/lib/libgtk-1.2.so.0
#15 gtk_signal_emit_stop_by_name
from /usr/lib/libgtk-1.2.so.0
#16 gtk_signal_emit
from /usr/lib/libgtk-1.2.so.0
#17 activate_account_callback
at mainwindow-account-tree.c line 57
#18 gtk_marshal_NONE__POINTER
from /usr/lib/libgtk-1.2.so.0
#19 gtk_signal_connect_while_alive
from /usr/lib/libgtk-1.2.so.0
#20 gtk_signal_emit_stop_by_name
from /usr/lib/libgtk-1.2.so.0
#21 gtk_signal_emit
from /usr/lib/libgtk-1.2.so.0
#22 gnc_account_tree_button_press
at gnc-account-tree.c line 1025
#23 gtk_marshal_BOOL__POINTER
from /usr/lib/libgtk-1.2.so.0
#24 gtk_signal_emit_stop_by_name
from /usr/lib/libgtk-1.2.so.0
#25 gtk_signal_emit
from /usr/lib/libgtk-1.2.so.0
#26 gtk_widget_event
from /usr/lib/libgtk-1.2.so.0
#27 gtk_propagate_event
from /usr/lib/libgtk-1.2.so.0
#28 gtk_main_do_event
from /usr/lib/libgtk-1.2.so.0
#29 gdk_event_get
from /usr/lib/libgdk-1.2.so.0
#30 g_get_current_time
from /usr/lib/libglib-1.2.so.0
#31 g_get_current_time
from /usr/lib/libglib-1.2.so.0
#32 g_main_run
from /usr/lib/libglib-1.2.so.0
#33 gtk_main
from /usr/lib/libgtk-1.2.so.0
#34 gnc_ui_start_event_loop
at top-level.c line 538
#35 gw__tmp1082_gnc_ui_start_event_loop_wrapper
at gw-gnc.c line 235
#36 scm_ceval
at eval.c line 2732
#37 scm_ceval
at eval.c line 2017
#38 scm_ceval
at eval.c line 2017
#39 scm_ceval
at eval.c line 1990
#40 scm_i_eval_x
at eval.c line 4063
#41 scm_primitive_eval_x
at eval.c line 4080
#42 inner_eval_x
at eval.c line 4127
#43 scm_internal_dynamic_wind
at dynwind.c line 168
#44 scm_eval_x
at eval.c line 4136
#45 scm_shell
at script.c line 680
#46 invoke_main_func
at init.c line 635
#47 scm_boot_guile_1
at init.c line 615
#48 scm_boot_guile
at init.c line 440
#49 main
at guile.c line 94



Other information:
information on the command line : 

Warning: pgend_session_begin: mode=multi-user is beta --
we've fixed all known bugs but that doesn't mean
there aren't any! If something seems weird, let us know.

Error: pgendGetResults: failed to get result to query:
        ERROR:  missing FROM-clause entry for table "gnctransaction"

Error: pgendGetResults: failed to get result to query:
        ERROR:  missing FROM-clause entry for table "gnctransaction"

Error: pgend_trans_commit_edit: send query failed:
        another command is already in progress

Error: pgendTransactionGetDeleted...(): send query failed:
        another command is already in progress

Error: pgendCopyTransactionToEngi...(): no such transaction in the database.
This is unexpected ...

Error: xaccTransRollbackEdit: Rollback Failed.  Ouch!
Error: pgendGetResults: failed to get result to query:
        ERROR:  missing FROM-clause entry for table "gnctransaction"

Error: pgend_trans_commit_edit: send query failed:
        another command is already in progress

Error: pgendTransactionGetDeleted...(): send query failed:
        another command is already in progress

Error: pgendCopyTransactionToEngi...(): no such transaction in the database.
This is unexpected ...

Error: xaccTransRollbackEdit: Rollback Failed.  Ouch!

Comment 1 jamie 2005-12-28 05:17:43 UTC

forgot to mention : specific version is 1.8.12

Also : a cursory examination of the code (src/backend/postgres/gncquery.c in the sqlQuery_build function) seems to indicate that if !need_account_commodity and !need_trans_commodity , then no FROM clause is generated, thus resulting in invalid SQL.  But I don't understand enough of the system to know if both conditions can ever be false.

Comment 2 Chris Shoemaker 2006-05-24 20:10:49 UTC

The stack trace is a dup of #153183.

The sql errors are probably just the consequence of passing bogus pointers to the backend.

*** This bug has been marked as a duplicate of 153183 ***

Comment 3 John Ralls 2018-06-29 20:54:45 UTC

GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=325100. Please update any external references or bookmarks.