A NOTE has been added to this issue. ====================================================================== http://www.dbmail.org/mantis/view.php?id=496 ====================================================================== Reported By: Anne Assigned To: ====================================================================== Project: DBMail Issue ID: 496 Category: Command-Line programs (dbmail-users, dbmail-util) Reproducibility: always Severity: crash Priority: normal Status: new target: ====================================================================== Date Submitted: 22-Jan-07 11:50 CET Last Modified: 22-Jan-07 19:07 CET ====================================================================== Summary: crash dbmail-util, table dbmail_headervalue gone!!, can't refill Description: dbmail-util crashed which caused Mysql (5.0.27) to crash. Result: dbmail_headervalue table was gone!!
I re-created the table. dbmail-util -by segfaults while filling the cache tables this is on a production server :-( ====================================================================== Relationships ID Summary ---------------------------------------------------------------------- duplicate of 0000461 dbmail-smtp dies with segmentation faul... ====================================================================== ---------------------------------------------------------------------- Anne - 22-Jan-07 12:01 ---------------------------------------------------------------------- stacktrace was too big to upload. 50k limit ?! Here it is: http://cfserver.nl/stacktrace.tar.gz ---------------------------------------------------------------------- Anne - 22-Jan-07 12:24 ---------------------------------------------------------------------- This is what killed the table: Error [Lost connection to MySQL server during query] [OPTIMIZE TABLE dbmail_headervalue] ---------------------------------------------------------------------- Anne - 22-Jan-07 13:21 ---------------------------------------------------------------------- POP3 is working fine (old and new mail). IMAP misses headers of old mail. Need a fix asap! ---------------------------------------------------------------------- paul - 22-Jan-07 15:49 ---------------------------------------------------------------------- Anne, strace logs tell me little more than nothing. Please build with debugging symbols (-g) and run server:/usr/src/dbmail-2.2.1 #> gdb ./dbmail-util gdb> run -by <SEGFAULT> gdb> bt ---------------------------------------------------------------------- paul - 22-Jan-07 16:10 ---------------------------------------------------------------------- Anne, Please use the dbmail_2_2_branch version if you can. The OPTIMIZE TABLE call was replaced by the much lighter ANALYZE TABLE. That mysql crashed (and the tables disappeared) indicate a mysql bug. ---------------------------------------------------------------------- Anne - 22-Jan-07 16:24 ---------------------------------------------------------------------- FreeBSD dbmail 2.2.1 port with CFLAGS=-g line in /etc/make.conf GNU gdb 6.1.1 [FreeBSD] Copyright 2004 Free Software Foundation, Inc. GDB is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. Type "show copying" to see the conditions. There is absolutely no warranty for GDB. Type "show warranty" for details. This GDB was configured as "i386-marcel-freebsd"... (gdb) run -by Starting program: /usr/local/sbin/dbmail-util -by warning: Unable to get location for thread creation breakpoint: generic error [New LWP 100334] Opening connection to database... [New Thread 0x805a000 (LWP 100334)] Opening connection to authentication... Ok. Connected. Repairing DBMAIL for rfcsize field... Ok. Found [0] missing rfcsize values. Repairing DBMAIL for incorrect is_header flags... Ok. Found [0] incorrect is_header flags. Repairing DBMAIL for cached envelopes... Ok. Found [273602] missing envelope values. Program received signal SIGSEGV, Segmentation fault. [Switching to Thread 0x805a000 (LWP 100224)] 0x280a16ef in imap_cleanup_address (a=0x9597910 "") at misc.c:2136 2136 next=inptr[i+1]; (gdb) bt http://www.dbmail.org/mantis/view.php?id=0 0x280a16ef in imap_cleanup_address (a=0x9597910 "") at misc.c:2136 http://www.dbmail.org/mantis/view.php?id=1 0x280a0e74 in envelope_address_part (list=0x808a2f0, message=0x8095020, header=0x280bd28c "Cc") at misc.c:1951 http://www.dbmail.org/mantis/view.php?id=2 0x280a1152 in imap_get_envelope (message=0x8095020) at misc.c:2015 http://www.dbmail.org/mantis/view.php?id=3 0x2808969d in dbmail_message_cache_envelope (self=0x806bd80) at dbmail-message.c:1261 http://www.dbmail.org/mantis/view.php?id=4 0x28093861 in db_set_envelope (lost=0x9595480) at db.c:1708 http://www.dbmail.org/mantis/view.php?id=5 0x0804b0f0 in do_envelope () at maintenance.c:701 http://www.dbmail.org/mantis/view.php?id=6 0x0804b1d5 in do_header_cache () at maintenance.c:729 http://www.dbmail.org/mantis/view.php?id=7 0x08049abe in main (argc=2, argv=0xbfbfec80) at maintenance.c:250 (gdb) ---------------------------------------------------------------------- Anne - 22-Jan-07 16:31 ---------------------------------------------------------------------- A "How to debug" would be nice for the Wiki. This prevents people from sending strace crap which doesn't help. ;-) ---------------------------------------------------------------------- paul - 22-Jan-07 16:35 ---------------------------------------------------------------------- Anne, This was fixed in SVN sometime ago already (bug http://www.dbmail.org/mantis/view.php?id=461). Please use dbmail_2_2_branch. ---------------------------------------------------------------------- Anne - 22-Jan-07 17:42 ---------------------------------------------------------------------- gmake all-recursive gmake[1]: Entering directory `/usr/dbmail_2_2_branch' Making all in modules gmake[2]: Entering directory `/usr/dbmail_2_2_branch/modules' if /usr/local/bin/bash ../libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I.. -I.. -I /usr/local/include/mysql -fno-strict-aliasing -pipe -g -O2 -I/usr/local/include/glib-2.0 -I/usr/ local/lib/glib-2.0/include -D_REENTRANT -I/usr/local/include/gmime-2.0 -I/usr/local/include/glib-2 .0 -I/usr/local/lib/glib-2.0/include -W -Wall -Wpointer-arith -Wstrict-prototypes -MT sortnull.lo -MD -MP -MF ".deps/sortnull.Tpo" -c -o sortnull.lo sortnull.c; \ then mv -f ".deps/sortnull.Tpo" ".deps/sortnull.Plo"; else rm -f ".deps/sortnull.Tpo"; exit 1; fi mkdir .libs gcc -DHAVE_CONFIG_H -I. -I. -I.. -I.. -I/usr/local/include/mysql -fno-strict-aliasing -pipe -g -O2 -I/usr/local/include/glib-2.0 -I/usr/local/lib/glib-2.0/include -D_REENTRANT -I/usr/local/include/gm ime-2.0 -I/usr/local/include/glib-2.0 -I/usr/local/lib/glib-2.0/include -W -Wall -Wpointer-arith -Ws trict-prototypes -MT sortnull.lo -MD -MP -MF .deps/sortnull.Tpo -c sortnull.c -fPIC -DPIC -o .libs/ sortnull.o In file included from /usr/local/include/gmime-2.0/gmime/gmime.h:27, from ../dbmail.h:45, from sortnull.c:28: /usr/local/include/gmime-2.0/gmime/gmime-iconv.h:24:19: iconv.h: No such file or directory In file included from /usr/local/include/gmime-2.0/gmime/gmime.h:27, from ../dbmail.h:45, from sortnull.c:28: /usr/local/include/gmime-2.0/gmime/gmime-iconv.h:31: error: syntax error before "g_mime_iconv_open" /usr/local/include/gmime-2.0/gmime/gmime-iconv.h:31: warning: type defaults to `int' in declaration of `g_mime_iconv_open' /usr/local/include/gmime-2.0/gmime/gmime-iconv.h:31: warning: data definition has no type or storage class /usr/local/include/gmime-2.0/gmime/gmime-iconv.h:99: error: syntax error before "cd" /usr/local/include/gmime-2.0/gmime/gmime-iconv.h:99: warning: function declaration isn't a prototype In file included from /usr/local/include/gmime-2.0/gmime/gmime.h:28, from ../dbmail.h:45, from sortnull.c:28: /usr/local/include/gmime-2.0/gmime/gmime-iconv-utils.h:29: error: syntax error before "cd" /usr/local/include/gmime-2.0/gmime/gmime-iconv-utils.h:29: warning: function declaration isn't a pro totype /usr/local/include/gmime-2.0/gmime/gmime-iconv-utils.h:30: error: syntax error before "cd" /usr/local/include/gmime-2.0/gmime/gmime-iconv-utils.h:30: warning: function declaration isn't a pro totype In file included from /usr/local/include/gmime-2.0/gmime/gmime.h:56, from ../dbmail.h:45, from sortnull.c:28: /usr/local/include/gmime-2.0/gmime/gmime-filter-charset.h:44: error: syntax error before "iconv_t" gmake[2]: *** [sortnull.lo] Error 1 gmake[2]: Leaving directory `/usr/dbmail_2_2_branch/modules' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/usr/dbmail_2_2_branch' gmake: *** [all] Error 2 I have glib-2.12.4, gmime-2.2.3 ---------------------------------------------------------------------- Anne - 22-Jan-07 19:07 ---------------------------------------------------------------------- I'm stuck. I always use the dbmail port... Issue History Date Modified Username Field Change ====================================================================== 22-Jan-07 11:50 Anne New Issue 22-Jan-07 12:01 Anne Note Added: 0001752 22-Jan-07 12:24 Anne Note Added: 0001753 22-Jan-07 13:21 Anne Note Added: 0001754 22-Jan-07 15:49 paul Note Added: 0001755 22-Jan-07 16:10 paul Note Added: 0001756 22-Jan-07 16:24 Anne Note Added: 0001757 22-Jan-07 16:30 Anne Note Added: 0001758 22-Jan-07 16:31 Anne Note Edited: 0001758 22-Jan-07 16:35 paul Note Added: 0001759 22-Jan-07 16:36 paul Relationship added duplicate of 0000461 22-Jan-07 17:42 Anne Note Added: 0001760 22-Jan-07 19:07 Anne Note Added: 0001761 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev
