GNOME Bugzilla – Bug 496730
crash in Tasks: DBD::mysql::st execute f...
Last modified: 2007-11-16 06:33:39 UTC
What were you doing when the application crashed? DBD::mysql::st execute failed: Unknown column 'bugs.bug_id' in 'on clause' [for Statement "SELECT bugs.bug_id, bugs.bug_severity, bugs.priority, bugs.bug_status, bugs.resolution, bugs.bug_severity, map_assigned_to.login_name, bugs.bug_status, bugs.resolution, bugs.short_desc, bugs.testing_type, bugs.defect_cause FROM bugs, profiles AS map_assigned_to LEFT JOIN bug_group_map ON bug_group_map.bug_id = bugs.bug_id AND bug_group_map.group_id NOT IN (60,75,61,29,32,78,15,2,70,27,7,37,49,22,8,77,51,64,4,67,52,40,73,36,68,46,20,25,54,39,53,35,45,65,79,41,6,42,13,43,76,26,69,28,72,55,38,74,34,48,59,30,21,58,62,14,63,71,44,3,31,50,33,1,66,5,56,57) LEFT JOIN cc ON cc.bug_id = bugs.bug_id AND cc.who = 3 WHERE bugs.assigned_to = map_assigned_to.userid AND (bugs.bug_status IN ('UNCONFIRMED','NEW','ASSIGNED','REOPENED')) AND bugs.creation_ts IS NOT NULL AND ((bug_group_map.group_id IS NULL) OR (bugs.reporter_accessible = 1 AND bugs.reporter = 3) OR (bugs.cclist_accessible = 1 AND cc.who IS NOT NULL) OR (bugs.assigned_to = 3) ) GROUP BY bugs.bug_id"] at Bugzilla/DB.pm line 65 Bugzilla::DB::SendSQL('SELECT bugs.bug_id, bugs.bug_severity, bugs.priority, bugs.bu...') called at /var/www/cgi-bin/newbugzilla/buglist.cgi line 782 Distribution: Fedora release 7 (Moonshine) Gnome Release: 2.18.0 2007-03-23 (Red Hat, Inc) BugBuddy Version: 2.18.0 System: Linux 2.6.21-1.3194.fc7 #1 SMP Wed May 23 22:35:01 EDT 2007 i686 X Vendor: The X.Org Foundation X Vendor Release: 10300000 Selinux: No Accessibility: Disabled GTK+ Theme: Clearlooks Icon Theme: Fedora Memory status: size: 151097344 vsize: 151097344 resident: 37761024 share: 22093824 rss: 37761024 rss_rlim: 4294967295 CPU usage: start_time: 1195043126 rtime: 1052 utime: 954 stime: 98 cutime:50 cstime: 36 timeout: 0 it_real_value: 0 frequency: 100 Backtrace was generated from '/usr/bin/evolution' (no debugging symbols found) Using host libthread_db library "/lib/libthread_db.so.1". (no debugging symbols found) [Thread debugging using libthread_db enabled] [New Thread -1208158496 (LWP 4799)] [New Thread -1259365488 (LWP 5505)] [New Thread -1290835056 (LWP 5503)] [New Thread -1324110960 (LWP 5071)] [New Thread -1238201456 (LWP 4877)] [New Thread -1313203312 (LWP 4872)] (no debugging symbols found) 0x00578402 in __kernel_vsyscall ()
+ Trace 177651
Thread 3 (Thread -1290835056 (LWP 5503))
----------- .xsession-errors (11 sec old) --------------------- (evolution:4799): e-data-server-ui-WARNING **: Key file does not have group 'Passwords-Mail' (evolution:4799): e-data-server-ui-DEBUG: ep_msg_send: in main thread? 0 libnm_glib_nm_state_cb: dbus returned an error. (org.freedesktop.DBus.Error.ServiceUnknown) The name org.freedesktop.NetworkManager was not provided by any .service files (evolution:4799): e-data-server-ui-DEBUG: ep_msg_send: in main thread? 0 (evolution:4799): e-utils-WARNING **: Cannot resolve symbol 'org_gnome_new_mail_config' in plugin '/usr/lib/evolution/2.10/plugins/liborg-gnome-new-mail-notify.so' (not exported?) BBDB spinning up... (evolution:4799): GLib-GObject-WARNING **: gsignal.c:1669: signal `source_selected' is invalid for instance `0x91bc130' (evolution:4799): GLib-GObject-WARNING **: gsignal.c:1669: signal `source_selected' is invalid for instance `0x91bc250' (evolution:4799): e-data-server-ui-DEBUG: ep_msg_send: in main thread? 0 error getting update info: Cannot open/read repomd.xml file for repository: fedora (evolution:4799): e-data-server-ui-DEBUG: ep_msg_send: in main thread? 0 --------------------------------------------------
Thanks for taking the time to report this bug. Unfortunately, the stack trace is missing some elements that will help a lot to solve the problem, so it will be hard for the developers to fix that crash. Could you please help fixing this by installing some debugging packages [1], start the application as normal, and try to reproduce the crash, if possible? Once bug-buddy pops up, you can find the stacktrace in the 'Details', now containing way more information. Please copy that stacktrace and paste it as a comment here. Thanks in advance! [1] Please install debug packages for evolution, evolution-data-server, gtkhtml, gtk, glib, gnome-vfs, pango, libgnome and libgnomeui (as far as those packages are provided by your distribution). More details can be found here: http://live.gnome.org/GettingTraces
I'd say, this is bug 441638. CCing Olav since it looks pretty weird. As if bugzilla is buggy...
Thanks for taking the time to report this bug. This particular bug has already been reported into our bug tracking system, but the maintainers need more information to fix the bug. Could you please answer the questions in the other report in order to help the developers? *** This bug has been marked as a duplicate of 441638 ***
The bugzilla which I was using was a customised one , where we added some modification in template to add new fields, The bugzilla-2.18.tar which i downloaded and installed didnot contains this new fields ,I tried to restore the db of the customised bugzilla and connect.and thus the error creeped up. ANYWAY I HAVE RESOLVED THIS bby making the the changes in bugzilla and restored my db dump and it stared working fine. Thanks for the effort u have put into this. (In reply to comment #0) > What were you doing when the application crashed? > DBD::mysql::st execute failed: Unknown column 'bugs.bug_id' in 'on clause' [for > Statement "SELECT bugs.bug_id, bugs.bug_severity, bugs.priority, > bugs.bug_status, bugs.resolution, bugs.bug_severity, > map_assigned_to.login_name, bugs.bug_status, bugs.resolution, bugs.short_desc, > bugs.testing_type, bugs.defect_cause FROM bugs, profiles AS map_assigned_to > LEFT JOIN bug_group_map ON bug_group_map.bug_id = bugs.bug_id AND > bug_group_map.group_id NOT IN > (60,75,61,29,32,78,15,2,70,27,7,37,49,22,8,77,51,64,4,67,52,40,73,36,68,46,20,25,54,39,53,35,45,65,79,41,6,42,13,43,76,26,69,28,72,55,38,74,34,48,59,30,21,58,62,14,63,71,44,3,31,50,33,1,66,5,56,57) > LEFT JOIN cc ON cc.bug_id = bugs.bug_id AND cc.who = 3 WHERE bugs.assigned_to > = map_assigned_to.userid AND (bugs.bug_status IN > ('UNCONFIRMED','NEW','ASSIGNED','REOPENED')) AND bugs.creation_ts IS NOT NULL > AND ((bug_group_map.group_id IS NULL) OR (bugs.reporter_accessible = 1 AND > bugs.reporter = 3) OR (bugs.cclist_accessible = 1 AND cc.who IS NOT NULL) > OR (bugs.assigned_to = 3) ) GROUP BY bugs.bug_id"] at Bugzilla/DB.pm line 65 > Bugzilla::DB::SendSQL('SELECT bugs.bug_id, bugs.bug_severity, > bugs.priority, bugs.bu...') called at /var/www/cgi-bin/newbugzilla/buglist.cgi > line 782 > > > Distribution: Fedora release 7 (Moonshine) > Gnome Release: 2.18.0 2007-03-23 (Red Hat, Inc) > BugBuddy Version: 2.18.0 > > System: Linux 2.6.21-1.3194.fc7 #1 SMP Wed May 23 22:35:01 EDT 2007 i686 > X Vendor: The X.Org Foundation > X Vendor Release: 10300000 > Selinux: No > Accessibility: Disabled > GTK+ Theme: Clearlooks > Icon Theme: Fedora > > Memory status: size: 151097344 vsize: 151097344 resident: 37761024 share: > 22093824 rss: 37761024 rss_rlim: 4294967295 > CPU usage: start_time: 1195043126 rtime: 1052 utime: 954 stime: 98 cutime:50 > cstime: 36 timeout: 0 it_real_value: 0 frequency: 100 > > Backtrace was generated from '/usr/bin/evolution' > > (no debugging symbols found) > Using host libthread_db library "/lib/libthread_db.so.1". > (no debugging symbols found) > [Thread debugging using libthread_db enabled] > [New Thread -1208158496 (LWP 4799)] > [New Thread -1259365488 (LWP 5505)] > [New Thread -1290835056 (LWP 5503)] > [New Thread -1324110960 (LWP 5071)] > [New Thread -1238201456 (LWP 4877)] > [New Thread -1313203312 (LWP 4872)] > (no debugging symbols found) > 0x00578402 in __kernel_vsyscall () > #0 0x00578402 in __kernel_vsyscall () > #1 0x00a7fc5b in waitpid () from /lib/libpthread.so.0 > #2 0x005cba46 in ?? () from /usr/lib/libgnomeui-2.so.0 > #3 0x0805ed39 in ?? () > #4 <signal handler called> > #5 0x00578402 in __kernel_vsyscall () > #6 0x0307bb73 in poll () from /lib/libc.so.6 > #7 0x02767633 in ?? () from /lib/libglib-2.0.so.0 > #8 0x027679a9 in g_main_loop_run () from /lib/libglib-2.0.so.0 > #9 0x0062d7e3 in bonobo_main () from /usr/lib/libbonobo-2.so.0 > #10 0x0805eb60 in main () > > Thread 6 (Thread -1313203312 (LWP 4872)): > #0 0x00578402 in __kernel_vsyscall () > No symbol table info available. > #1 0x0307bb73 in poll () from /lib/libc.so.6 > No symbol table info available. > #2 0x02767633 in ?? () from /lib/libglib-2.0.so.0 > No symbol table info available. > #3 0x027679a9 in g_main_loop_run () from /lib/libglib-2.0.so.0 > No symbol table info available. > #4 0x00b895b4 in ?? () from /usr/lib/libnm_glib.so.0 > No symbol table info available. > #5 0x0278249f in ?? () from /lib/libglib-2.0.so.0 > No symbol table info available. > #6 0x00a782fb in start_thread () from /lib/libpthread.so.0 > No symbol table info available. > #7 0x0308593e in clone () from /lib/libc.so.6 > No symbol table info available. > > Thread 5 (Thread -1238201456 (LWP 4877)): > #0 0x00578402 in __kernel_vsyscall () > No symbol table info available. > #1 0x0307bb73 in poll () from /lib/libc.so.6 > No symbol table info available. > #2 0x02767633 in ?? () from /lib/libglib-2.0.so.0 > No symbol table info available. > #3 0x027679a9 in g_main_loop_run () from /lib/libglib-2.0.so.0 > No symbol table info available. > #4 0x00749510 in ?? () from /usr/lib/libORBit-2.so.0 > No symbol table info available. > #5 0x0278249f in ?? () from /lib/libglib-2.0.so.0 > No symbol table info available. > #6 0x00a782fb in start_thread () from /lib/libpthread.so.0 > No symbol table info available. > #7 0x0308593e in clone () from /lib/libc.so.6 > No symbol table info available. > > Thread 4 (Thread -1324110960 (LWP 5071)): > #0 0x00578402 in __kernel_vsyscall () > No symbol table info available. > #1 0x0307bb73 in poll () from /lib/libc.so.6 > No symbol table info available. > #2 0x02767633 in ?? () from /lib/libglib-2.0.so.0 > No symbol table info available. > #3 0x027679a9 in g_main_loop_run () from /lib/libglib-2.0.so.0 > No symbol table info available. > #4 0x006ec712 in ?? () from /usr/lib/libebook-1.2.so.9 > No symbol table info available. > #5 0x0278249f in ?? () from /lib/libglib-2.0.so.0 > No symbol table info available. > #6 0x00a782fb in start_thread () from /lib/libpthread.so.0 > No symbol table info available. > #7 0x0308593e in clone () from /lib/libc.so.6 > No symbol table info available. > > Thread 3 (Thread -1290835056 (LWP 5503)): > #0 0x00578402 in __kernel_vsyscall () > No symbol table info available. > #1 0x00a7e92e in __lll_mutex_lock_wait () from /lib/libpthread.so.0 > No symbol table info available. > #2 0x00a7a7a3 in _L_mutex_lock_79 () from /lib/libpthread.so.0 > No symbol table info available. > #3 0x00a7a2cd in pthread_mutex_lock () from /lib/libpthread.so.0 > No symbol table info available. > #4 0x0805ed21 in ?? () > No symbol table info available. > #5 <signal handler called> > No symbol table info available. > #6 0x0277aa02 in ?? () from /lib/libglib-2.0.so.0 > No symbol table info available. > #7 0x0277ac77 in ?? () from /lib/libglib-2.0.so.0 > No symbol table info available. > #8 0x0277adc5 in ?? () from /lib/libglib-2.0.so.0 > No symbol table info available. > #9 0x0277be31 in g_slice_free_chain_with_offset () from /lib/libglib-2.0.so.0 > No symbol table info available. > #10 0x0277cb61 in g_slist_free () from /lib/libglib-2.0.so.0 > No symbol table info available. > #11 0x0277f2da in g_strsplit () from /lib/libglib-2.0.so.0 > No symbol table info available. > #12 0x001e2411 in camel_uid_cache_new () > from /usr/lib/libcamel-provider-1.2.so.10 > No symbol table info available. > #13 0x0164bcfe in ?? () > from /usr/lib/evolution/2.10/components/libevolution-mail.so > No symbol table info available. > #14 0x01647223 in ?? () > from /usr/lib/evolution/2.10/components/libevolution-mail.so > No symbol table info available. > #15 0x02783e68 in ?? () from /lib/libglib-2.0.so.0 > No symbol table info available. > #16 0x0278249f in ?? () from /lib/libglib-2.0.so.0 > No symbol table info available. > #17 0x00a782fb in start_thread () from /lib/libpthread.so.0 > No symbol table info available. > #18 0x0308593e in clone () from /lib/libc.so.6 > No symbol table info available. > > Thread 2 (Thread -1259365488 (LWP 5505)): > #0 0x00578402 in __kernel_vsyscall () > No symbol table info available. > #1 0x00a7e92e in __lll_mutex_lock_wait () from /lib/libpthread.so.0 > No symbol table info available. > #2 0x00a7a7a3 in _L_mutex_lock_79 () from /lib/libpthread.so.0 > No symbol table info available. > #3 0x00a7a2cd in pthread_mutex_lock () from /lib/libpthread.so.0 > No symbol table info available. > #4 0x0277aeed in ?? () from /lib/libglib-2.0.so.0 > No symbol table info available. > #5 0x00a77a1c in __nptl_deallocate_tsd () from /lib/libpthread.so.0 > No symbol table info available. > #6 0x00a78309 in start_thread () from /lib/libpthread.so.0 > No symbol table info available. > #7 0x0308593e in clone () from /lib/libc.so.6 > No symbol table info available. > > Thread 1 (Thread -1208158496 (LWP 4799)): > #0 0x00578402 in __kernel_vsyscall () > No symbol table info available. > #1 0x00a7fc5b in waitpid () from /lib/libpthread.so.0 > No symbol table info available. > #2 0x005cba46 in ?? () from /usr/lib/libgnomeui-2.so.0 > No symbol table info available. > #3 0x0805ed39 in ?? () > No symbol table info available. > #4 <signal handler called> > No symbol table info available. > #5 0x00578402 in __kernel_vsyscall () > No symbol table info available. > #6 0x0307bb73 in poll () from /lib/libc.so.6 > No symbol table info available. > #7 0x02767633 in ?? () from /lib/libglib-2.0.so.0 > No symbol table info available. > #8 0x027679a9 in g_main_loop_run () from /lib/libglib-2.0.so.0 > No symbol table info available. > #9 0x0062d7e3 in bonobo_main () from /usr/lib/libbonobo-2.so.0 > No symbol table info available. > #10 0x0805eb60 in main () > No symbol table info available. > #0 0x00578402 in __kernel_vsyscall () > The program is running. Quit anyway (and detach it)? (y or n) [answered Y; > input not from terminal] > > > ----------- .xsession-errors (11 sec old) --------------------- > (evolution:4799): e-data-server-ui-WARNING **: Key file does not have group > 'Passwords-Mail' > (evolution:4799): e-data-server-ui-DEBUG: ep_msg_send: in main thread? 0 > libnm_glib_nm_state_cb: dbus returned an error. > (org.freedesktop.DBus.Error.ServiceUnknown) The name > org.freedesktop.NetworkManager was not provided by any .service files > (evolution:4799): e-data-server-ui-DEBUG: ep_msg_send: in main thread? 0 > (evolution:4799): e-utils-WARNING **: Cannot resolve symbol > 'org_gnome_new_mail_config' in plugin > '/usr/lib/evolution/2.10/plugins/liborg-gnome-new-mail-notify.so' (not > exported?) > BBDB spinning up... > (evolution:4799): GLib-GObject-WARNING **: gsignal.c:1669: signal > `source_selected' is invalid for instance `0x91bc130' > (evolution:4799): GLib-GObject-WARNING **: gsignal.c:1669: signal > `source_selected' is invalid for instance `0x91bc250' > (evolution:4799): e-data-server-ui-DEBUG: ep_msg_send: in main thread? 0 > error getting update info: Cannot open/read repomd.xml file for repository: > fedora > (evolution:4799): e-data-server-ui-DEBUG: ep_msg_send: in main thread? 0 > -------------------------------------------------- >