Bug 569883 – Evolution reports "no such column: uid" on some SQL operations

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 569883 - Evolution reports "no such column: uid" on some SQL operations


Summary:	Evolution reports "no such column: uid" on some SQL operations


Status:	RESOLVED FIXED

Product:	evolution-data-server
Classification:	Platform
Component:	Mailer
Version:	2.26.x (obsolete)
Hardware:	Other Linux

Importance:	Normal critical
Target Milestone:	---
Assigned To:	evolution-mail-maintainers
QA Contact:	Evolution QA team

URL:
Whiteboard:

Depends on:
Blocks:	543389

Reported:	2009-01-30 19:29 UTC by C de-Avillez
Modified:	2013-09-14 16:52 UTC

See Also:
GNOME target:	---
GNOME version:	2.25/2.26

Attachments
Don't insert to Deletes entries for vfolders (2.21 KB, patch) 2009-02-02 03:26 UTC, Srinivasa Ragavan	committed	Details \| Review

Description C de-Avillez 2009-01-30 19:29:46 UTC

I added a divide-by-zero in camel-db.c if we got hit by such a message, and ran with it for some days.

Today I got it. Revision levels:

Path: gtkhtml
Revision: 9118
Path: evolution-data-server
Revision: 10007
Path: evolution
Revision: 37195
Path: evolution-exchange
Revision: 1863
Path: evolution-webcal
Revision: 460
hggdh@xango2:/usr/src/buildd/evolution/evo-svn $

+ Trace 212043

Thread 3 (process 21531)

#0 select
from /lib/libc.so.6
#1 ??
from /usr/lib/libxcb.so.1
#2 ??
from /usr/lib/libxcb.so.1
#3 xcb_writev
from /usr/lib/libxcb.so.1
#4 _XSend
from /usr/lib/libX11.so.6
#5 ??
from /usr/lib/libX11.so.6
#6 XPutImage
from /usr/lib/libX11.so.6
#7 _draw_image_surface
at /build/buildd/cairo-1.8.6/src/cairo-xlib-surface.c line 1072
#8 _cairo_xlib_surface_clone_similar
at /build/buildd/cairo-1.8.6/src/cairo-xlib-surface.c line 1211
#9 _cairo_surface_clone_similar
at /build/buildd/cairo-1.8.6/src/cairo-surface.c line 1147
#10 _cairo_pattern_acquire_surface
at /build/buildd/cairo-1.8.6/src/cairo-pattern.c line 1435
#11 _cairo_pattern_acquire_surfaces
at /build/buildd/cairo-1.8.6/src/cairo-pattern.c line 2168
#12 _cairo_xlib_surface_composite
at /build/buildd/cairo-1.8.6/src/cairo-xlib-surface.c line 1711
#13 _cairo_surface_composite
at /build/buildd/cairo-1.8.6/src/cairo-surface.c line 1288
#14 _clip_and_composite_trapezoids
at /build/buildd/cairo-1.8.6/src/cairo-surface-fallback.c line 449
#15 _cairo_surface_fallback_fill
at /build/buildd/cairo-1.8.6/src/cairo-surface-fallback.c line 902
#16 _cairo_surface_fill
at /build/buildd/cairo-1.8.6/src/cairo-surface.c line 1685
#17 _cairo_gstate_fill
at /build/buildd/cairo-1.8.6/src/cairo-gstate.c line 1021
#18 *INT_cairo_fill_preserve
at /build/buildd/cairo-1.8.6/src/cairo.c line 2158
#19 eti_draw
at ../../../../evolution/widgets/table/e-table-item.c line 1998
#20 gnome_canvas_group_draw
at gnome-canvas.c line 1676
#21 gnome_canvas_expose
at gnome-canvas.c line 2994
#22 ??
from /usr/lib/libgtk-x11-2.0.so.0
#23 IA__g_closure_invoke
at /build/buildd/glib2.0-2.19.5/gobject/gclosure.c line 767
#24 signal_emit_unlocked_R
at /build/buildd/glib2.0-2.19.5/gobject/gsignal.c line 3282
#25 IA__g_signal_emit_valist
at /build/buildd/glib2.0-2.19.5/gobject/gsignal.c line 2987
#26 IA__g_signal_emit
at /build/buildd/glib2.0-2.19.5/gobject/gsignal.c line 3034
#27 ??
from /usr/lib/libgtk-x11-2.0.so.0
#28 do_update
at gnome-canvas.c line 3125
#29 idle_handler
at gnome-canvas.c line 3203
#30 IA__g_main_context_dispatch
at /build/buildd/glib2.0-2.19.5/glib/gmain.c line 1814
#31 g_main_context_iterate
at /build/buildd/glib2.0-2.19.5/glib/gmain.c line 2448
#32 IA__g_main_loop_run
at /build/buildd/glib2.0-2.19.5/glib/gmain.c line 2656
#33 bonobo_main
at bonobo-main.c line 311
#34 main
at ../../../evolution/shell/main.c line 704

Comment 1 C de-Avillez 2009-01-30 20:05:03 UTC

No sure about that, but it seems that if I position myself on the unread vfolder, and then I move to another (real) folder, I get the crash.

While I move around on real folders I di not get it.

Comment 2 Srinivasa Ragavan 2009-01-31 15:54:25 UTC

With 2.25.90 you would face this often. Its a bug in the tracker-meta data code. I would gtry to fix it before 2.25.90

Comment 3 C de-Avillez 2009-01-31 16:01:30 UTC

Yes, I am running trunk... so I am hit with it every time I leave the unread vfolder. 

If you have enough data, I will go ahead and take out the divide-by-zero.

Comment 4 Srinivasa Ragavan 2009-02-02 03:26:54 UTC

Created attachment 127745 [details] [review]
Don't insert to Deletes entries for vfolders

This must fix it

Comment 5 C de-Avillez 2009-02-02 13:02:49 UTC

This patch seems to do the trick. No "no such column: uid" is being reported anymore. Also, no new errors are being reported.

I guess it is a go.

Comment 6 Srinivasa Ragavan 2009-02-09 03:39:07 UTC

Pushed in 2.25.90