[JDEV] coredump with xdb_sql and user profile changes

[Benjamin Ritcey]

Hello all,

I've run into an odd problem -- I'm running jabberd 1.4.1 and xdb_sql 
1.1 w/ MySQL -- things are working well enough (some oddities), but I 
have run into a major problem/bug --

With my setup, if a user changes their profile a couple of times (2 or 
3), it crashes the server (the client is JIM 1.10, if that matters).

In looking at the logs, I can see what appears to be some sort of memory 
corruption;

line 6593 of http://www.ritcey.com/jabber/jabberd.out shows:

xdb_file.c:251 decaching @Å$@@Å$@jabberbox.ritcey.com/crashtest2.xml

that garbage should be './spool/' -- up to that point, that's what the 
other decaching log entries read.  Right after that appears in the log, 
the next attempt to update the profile results in a coredump -- 
backtrace at http://www.ritcey.com/jabber/backtrace, but I'm not sure if 
it's valid - the damage has been done by the time it dumps core.

Oddly enough, the profile updates never take, tho the database does get 
updated (xdb_sql bug, I assume).

jabber.xml and xdb_sql.xml are also available at 
http://www.ritcey.com/jabber/ (I didn't include the files, since they 
are fairly large).

I suspect it is because of xdb_sql and its interaction with xdb_file, 
but I'm not quite sure what it is.

Frankly, I don't care about the profiles (internal, captive audience, 
accounts will be created by the admin, etc.), so if the vcard could be 
flat-out disabled to fix this, that would be fine too.

I didn't see anything like this on the mailing lists (searchable 
archives anywhere?) nor Google.

Any ideas?

Thanks for your time and a cool chunk of software.

-b