powered by Jive Software

Offline message table

Seeing some very strange behavior. We have a pre-production instance with less than 20 people using it. The offline message database had nearly 1 million rows it it, which simply not user generated traffic. I deleted the table contents, waited, and selected * from the table. I saw one lagit entry, and then about five minutes later, we jumped to this:

mysql> select count(*) from ofOffline;

±---------+

| count(*) |

±---------+

| 2146 |

±---------+

1 row in set (0.00 sec)

The conent of these messages is very strange. It seems to have something to do with the exchange of avitars. We have entries in this table for people who have accounts based on the fact that anyone in our ldap can log in, but we know some of these people aren’t actually chatting and aren’t even aware that the server exists yet. This has to be some sort of server generated traffic:

ddcchristinal 1882744 001371841141890 19227 <message to="ddcchristinal@im.dealer.com" from="ddckenw@im.dealer.com" id="ddckenw@im.dealer.com__ddcchristinal@im.d

ealer.com__396N5"><item id=“02a14ef4c44593167ebf31008d9066d42eb5a8f6” node

=“urn:xmpp:avatar:data”>iVBORw0KGgoAAAANSUhEUgAAAGAAAABgCAYAAADimHc4AAAKQW lDQ1BJQ0MgUHJvZmlsZQAASA2dlndUU9kWh8+9N73QEiIgJfQaegkg0

jtIFQRRiUmAUAKGhCZ2RAVGFBEpVmRUwAFHhyJjRRQLg4Ji1wnyEFDGwVFEReXdjGsJ7601896a/cdZ3 9nnt9fZZ+9917oAUPyCBMJ0WAGANKFYFO7rwVwSE8vE9wIYEAEOWAHA4WZmBEf4RALU/L09mZmoSMaz9 u4ug

GS72yy/UCZz1v9/kSI3QyQGAApF1TY8fiYX5QKUU7PFGTL/BMr0lSkyhjEyFqEJoqwi48SvbPan5iu7y ZiXJuShGlnOGbw0noy7UN6aJeGjjAShXJgl4GejfAdlvVRJmgDl9yjT0/icTAAwFJlfzOcmoWyJMkUUG e6J8

gIACJTEObxyDov5OWieAHimZ+SKBIlJYqYR15hp5ejIZvrxs1P5YjErlMNN4Yh4TM/0tAyOMBeAr2+WR QElWW2ZaJHtrRzt7VnW5mj5v9nfHn5T/T3IevtV8Sbsz55BjJ5Z32zsrC+9FgD2JFqbHbO+lVUAtG0GQ OXhr

E/vIADyBQC03pzzHoZsXpLE4gwnC4vs7GxzAZ9rLivoN/ufgm/Kv4Y595nL7vtWO6YXP4EjSRUzZUXlp qemS0TMzAwOl89k/fcQ/+PAOWnNycMsnJ/AF/GF6FVR6JQJhIlou4U8gViQLmQKhH/V4X8YNicHGX6da xRod

V8AfYU5ULhJB8hvPQBDIwMkbj96An3rWxAxCsi+vGitka9zjzJ6/uf6Hwtcim7hTEEiU+b2DI9kciWiL Bmj34RswQISkAd0oAo0gS4wAixgDRyAM3AD3iAAhIBIEAOWAy5IAmlABLJBPtgACkEx2AF2g2pwANSBe tAET

oI2cAZcBFfADXALDIBHQAqGwUswAd6BaQiC8BAVokGqkBakD5lC1hAbWgh5Q0FQOBQDxUOJkBCSQPnQJ qgYKoOqoUNQPfQjdBq6CF2D+qAH0CA0Bv0BfYQRmALTYQ3YALaA2bA7HAhHwsvgRHgVnAcXwNvhSrgWP g63w

hfhG/AALIVfwpMIQMgIA9FGWAgb8URCkFgkAREha5EipAKpRZqQDqQbuY1IkXHkAwaHoWGYGBbGGeOHW YzhYlZh1mJKMNWYY5hWTBfmNmYQM4H5gqVi1bGmWCesP3YJNhGbjS3EVmCPYFuwl7ED2GHsOxwOx8AZ4 hxwf

rgYXDJuNa4Etw/XjLuA68MN4SbxeLwq3hTvgg/Bc/BifCG+Cn8cfx7fjx/GvyeQCVoEa4IPIZYgJGwkV BAaCOcI/YQRwjRRgahPdCKGEHnEXGIpsY7YQbxJHCZOkxRJhiQXUiQpmbSBVElqIl0mPSa9IZPJOmRHc hhZQ

F5PriSfIF8lD5I/UJQoJhRPShxFQtlOOUq5QHlAeUOlUg2obtRYqpi6nVpPvUR9Sn0vR5Mzl/OX48mtk 6uRa5Xrl3slT5TXl3eXXy6fJ18hf0r+pvy4AlHBQMFTgaOwVqFG4bTCPYVJRZqilWKIYppiiWKD4jXFU SW8k

oGStxJPqUDpsNIlpSEaQtOledK4tE20Otpl2jAdRzek+9OT6cX0H+i99AllJWVb5SjlHOUa5bPKUgbCM GD4M1IZpYyTjLuMj/M05rnP48/bNq9pXv+8KZX5Km4qfJUilWaVAZWPqkxVb9UU1Z2qbapP1DBqJmpha tlq+

9Uuq43Pp893ns+dXzT/5PyH6rC6iXq4+mr1w+o96pMamhq+GhkaVRqXNMY1GZpumsma5ZrnNMe0aFoLt QRa5VrntV4wlZnuzFRmJbOLOaGtru2nLdE+pN2rPa1jqLNYZ6NOs84TXZIuWzdBt1y3U3dCT0svWC9fr 1Hvo

T5Rn62fpL9Hv1t/ysDQINpgi0GbwaihiqG/YZ5ho+FjI6qRq9Eqo1qjO8Y4Y7ZxivE+41smsImdSZJJj clNU9jU3lRgus+0zwxr5mgmNKs1u8eisNxZWaxG1qA5wzzIfKN5m/krCz2LWIudFt0WXyztLFMt6ywfW SlZB

VhttOqw+sPaxJprXWN9x4Zq42Ozzqbd5rWtqS3fdr/tfTuaXbDdFrtOu8/2DvYi+yb7MQc9h3iHvQ732 HR2KLuEfdUR6+jhuM7xjOMHJ3snsdNJp9+dWc4pzg3OowsMF/AX1C0YctFx4bgccpEuZC6MX3hwodRV2 5XjW

uv6zE3Xjed2xG3E3dg92f24+ysPSw+RR4vHlKeT5xrPC16Il69XkVevt5L3Yu9q76c+Oj6JPo0+E752v qt9L/hh/QL9dvrd89fw5/rX+08EOASsCegKpARGBFYHPgsyCRIFdQTDwQHBu4IfL9JfJFzUFgJC/EN2h TwJN

QxdFfpzGC4sNKwm7Hm4VXh+eHcELWJFREPEu0iPyNLIR4uNFksWd0bJR8VF1UdNRXtFl0VLl1gsWbPkR oxajCCmPRYfGxV7JHZyqffS3UuH4+ziCuPuLjNclrPs2nK15anLz66QX8FZcSoeGx8d3xD/iRPCqeVMr vRfu

XflBNeTu4f7kufGK+eN8V34ZfyRBJeEsoTRRJfEXYljSa5JFUnjAk9BteB1sl/ygeSplJCUoykzqdGpz WmEtPi000IlYYqwK10zPSe9L8M0ozBDuspp1e5VE6JA0ZFMKHNZZruYjv5M9UiMJJslg1kLs2qy3mdHZ Z/KU

cwR5vTkmuRuyx3J88n7fjVmNXd1Z752/ob8wTXuaw6thdauXNu5Tnddwbrh9b7rj20gbUjZ8MtGy41lG 99uit7UUaBRsL5gaLPv5sZCuUJR4b0tzlsObMVsFWzt3WazrWrblyJe0fViy+KK4k8l3JLr31l9V/ndz PaE7

b2l9qX7d+B2CHfc3em681iZYlle2dCu4F2t5czyovK3u1fsvlZhW3FgD2mPZI+0MqiyvUqvakfVp+qk6 oEaj5rmvep7t+2d2sfb17/fbX/TAY0DxQc+HhQcvH/I91BrrUFtxWHc4azDz+ui6rq/Z39ff0TtSPGRz 0eFR

6XHwo911TvU1zeoN5Q2wo2SxrHjccdv/eD1Q3sTq+lQM6O5+AQ4ITnx4sf4H++eDDzZeYp9qukn/Z/2t tBailqh1tzWibakNml7THvf6YDTnR3OHS0/m/989Iz2mZqzymdLz5HOFZybOZ93fvJCxoXxi4kXhzpXd D66t

OTSna6wrt7LgZevXvG5cqnbvfv8VZerZ645XTt9nX297Yb9jdYeu56WX+x+aem172296XCz/ZbjrY6+B X3n+l37L972un3ljv+dGwOLBvruLr57/17cPel93v3RB6kPXj/Mejj9aP1j7OOiJwpPKp6qP6391fjXZ qm99

Oyg12DPs4hnj4a4Qy//lfmvT8MFz6nPK0a0RupHrUfPjPmM3Xqx9MXwy4yX0+OFvyn+tveV0auffnf7v WdiycTwa9HrmT9K3qi+OfrW9m3nZOjk03dp76anit6rvj/2gf2h+2P0x5Hp7E/4T5WfjT93fAn88ngmb Wbm3

/eE8/syOll+AAAssUlEQVR4Ae19B3hVVbr2e1pOeg8pJCGU0CGBAIJIEVFRsGAXUYerjuVarl2vOsU68 zv2ceZax5lx1BmdGXWUsWMH6S30ACGkJ6T3nHPu+66dQwISSWIC//8/LA3nnL3XXuXr37fW+rbttZXVJ +BYO

WoQcDpg++qo9X6sYzi9Xs8xMBxFCNiPYt/HuiYEjiHgKJPBMQQcQ8BRhsBR7t7Z4/5tdricLthsNjZhM ZLP50NLSyPsvOZ0BUC/W1ubzaf6sfE/B5+x2x3mF+CBj99aW5p12zyjOuBVXfd6WuHx0Ejw2eFwOPmsE 15vq

2lT9dW30xXE+15ea2rrxwcb23c63arBP46puUHVTVHfTo7BZ55p2T82u91lXWf91uZGOFwcJ+eo561i4 zfea2k1zzgcDjMejUHjbPG0cMD+um2PdOGjRwhQp9W1lchevsQA3MvfPo8P7sAgjJ04E41N9diw/HMEh YQhc

9IsuN3BBBbQSEBsWv4JqvaVEQl2MyEhL3PyiQaYG1Z8TkByIrznCnAjKWUIUgYOg4O/d+xYg9wt6xGXM hgjx06EnUiprqvA+qV/J37sGDNhOiLDYzllH8rLC5C98mvixQt3UAiyps4hcGlw87/Cwl3YvGYpQsIjO NYTE

eQKhI9jKyzIwZa1yxAYFMzxzMam7zjOihIiUyASYH0chxOjx09DdL8kbFj/DXauXwFPcxMSBwzFqEkzE Bocvh+hXYC9qdIDBFgUVlqSi1cevR111ZWmUw8nGxbbD/c++w72le3FSw/eiJDoeDz48gcIDAwxVFlXV 423X

ngEezavtwaqeRF49zz/Plyk8D/++nY01NWYgXnJPWGRMTjrmjtw+rlXY+VX7+Hd5x/D+NlnYeSYSbA5b CgvK8BLD/8XbC437n7qTcRExYst8Mnbf8L7Lz/GdmwIIEAHvPoFkuIHwEYkbMtezrHdQOoNwPzr7sG5l 9zIs

QBb1i/Di7weQ+Cmj8nCm889hF0bVxtCUJstBLSLXH3n42+hsGQnnr7jctTXVBsu8LR6cM3DL2L6iWeTe yxuNpPowj89QIBaJRL4X3NDgxn85HkXIjwiBq6QEIRFxaK0YLcZSDMHLTFkik0M7EVLU7O5lzVnPhISB 5n7/

RJSUF60F01sL4BcNPmMC1FWmI/1n72Pd/7n1xibNdPUk6jy8M9BgNhtTsLFjuamRjozBDXZ38frrd4WZ H/3ORyBgYhKSkHRtq3YunYpkuelsw2KD3KqgKS/xX98EhkTZ2D4qImUhh5ea0JLYwNpwonhE46H0+1Gz tqVF

DEtGJgxEbEcpzPYjVd+cw+qSoox5/LrMOb4U7D6m08waNBIcIrdLj1AAPmVE1URSAPI4iedeykGDcnkB IGQwDDsIDeoSBcQVOa7/x+bXaO0Ydpp52LshBNNG+ER8QR4rvkeFt0PF1x9L2orynH315+gurwENftKy UFWO

82tDSitLIaLsryyqpit87+28TgpttYt+wIFu7ZQdI3AcXMvwN8evw/ffvgmJs86E6Ehkf5hIDwxEbWl5 XjpkZtx86Ovwu5wmXte6oZAVzAuvf4h5O/ZjnsunYXmuhacd83dmHD8qagsL0UtRaiKvgcEh+Kym36Bg FbXf

l1mbnbxnx4goL1lOxVRQ201nr5tEUFqw4ARY3HDL1+gwpSS9RcLWf5fAr5Q94cHbyVLuxFCjrnr8b8aA Eu3NNRW4et/v4Gy/D2G7QNCQxEYHMZHLPLatuIb/Pzy2aY5KXhRrYOUqv6lWNd++xGRtw8J0wdj/NTZF EVPY

NvaFcjL2YwxWdP3DyN9zAQizoUVH/4Di996Dgnxafvv6YuT95xUzGa4/O2wUen6HAgLjUDWrLn49I3ns ey9N7Fqyb+ROWMOzr/yLqQOGGY46YCGDvPjRyGAcDTMEEwqcLkDCSjKenbolzqUC/rVYQi8K43H4g4OR hABG

xwSSuqzrstCqS4rwauP3GHquCi/p867CElpQ+Fb0mpdo9UTG9+f/drQ2FCH6tISXif4HVTK5cXYTA5Qi YyNh9sZiNi0gdi29Evs3raBSneGqav7Ia5QzFn4n9i66ht88IffIvPkuRxHOziETP35i757ydkOir1FN z2Cx

NQhWPPlB8jbno0Vi99CQ301bvzFSwZBrOh/7LCf7T0etur3K8gkDAwJx09//izS0kdRVoKWQATlrBVfs hHYdjtNTwLHTgoyQkTwJ/AuvvUhZGTO4Fh9CI+JQ2HeLn73GEV+xhU3IzYmCREx/ZA2dAyVeBANVmtSQ 8ZNx

k0PPE/qDMCuXetx/6LTDMZlVeUX7sbeHVvMQL9893WsXPI+Kim+VHI2rUA9FbzGo9LS0oT0YWOx4JYH8 MpDt2DDZ4uNCPSLV1Op4z8cs4jJR0G/a+82zJy7AHPOuRIb13yJR66ahy2rlpPzyhARFsWRHiEEiPLqa yrxM

q0XASk4PAqLbn8UdtrrKnWUkfdfNdcgICE1HQtvexge2cpkkbeefhAfhP+WQ7XjinseJ4Ls1INEKLlpy qz5SE4cTIVKP4FmqawMWUUqonRZVQ5HgFHYFmV62K4H2au/plKux4CRGUgbNc4iBLa79L03sHzJB5h93 lo/A

5p7nhYvZpx8IfZQPC1+6QnTvqi8Y5EpqyJjQr7Inj1b8MTNF9NPcCDjhFNRQWNBFuCY8ZNogMRxnAc+3 7GtQ33vAQcIED4jNty0ejwEUMH2TYZdQ2Lj0NBQTwTQ2aFCtJHaykr2Gnvc7g5iHZqFwYHmXtGeHQYRM idra

vchyBFEmz2YQA0kIuTQNRmEmEGTup3UF3Y6UE7a7eIam40WDW/qGXtAEGrrqrDm249puQTitEuuw/TTF sDXQsS0tqKAXLErexU2rPgSMQnJ1tiC3Gj1eeBCAOYuuA452SuxY+Uy+jLBxLKsPFI7WVa/fbK8KB5lZ bU0t

yI+ORUbaPkUbttshhebMhCnL7geEeGR8JJYLFIxtw77j+315ZXdqW8aFDfWNtZh99Z17LCVThEHyz87u WBQ+lg00TTM3bZuP7v7CDA3KXvA4NHIy92MhpoqI8M1Uh+togHDMqn07Ni1dT3t7kCKs7FwE4EdTdjCw lyUU

kyFxSYijRaOSn1TLQG7xnBcQvJA5Odtp1vtxcDhGQgLiTbiQm3s2bmZuqUQoRR1EbSy8nM2IZw+S0raC MuKIlcV0a8pytmOQDqNQ6igHbSKGjnHnZtX07qhGTo8E6Fh0bzuQE1jJa2tz1GydxdcQUF0Nk9ESspQ4 xF3F

5g9QoAmLyUoz1cyU1TGefIrScYoKw85xHL5ZZ3of4UU5LJL0UnWG4TxWYmr1mZ6v8SGvF9NwNj75Cy1Y drkVeuT3j6fVX8qMk3dcvL43UNbXXXUj7hSOkFhDw3MKFRW8nm85hlZX2rH9MMxqcgMVfjEyfF5PLSuC HTVU

RsCukSTRRBqiFaRCWdQ12kO7LeFROehTuxu6YEIsrrgtLA3f6eZaHR0Ai/aSPn1qKwsI6VEkYID+L3EA EQjdlA0tDY1IYAUHhXRzwy6wdeEfUUlxtxT7KWRJi1vGFkbGRGLmqpqPtPIp33GwoqKjN+v4DWKJpqhR Xl5x

Llq0H6nKFLbTvVdVUI7PsdQdOpgUjqNAC8BW11ZZawnEVAQuTKS3raHokq/a2sqDBe1EsGJqQMRGRbLe y1sq9yIOIklzTMkPBqNVOhClBAgPRESGokwhiK6W3qMAHX8/P3Xo6w4D+defTdOOn0h3fmleO7hm3DGp TdgZ

Also seeing tons of these:

ddcchrisa
1884178 001371841146347 398

ddcmattb
1884179 001371841146349 396

ddcdougf
1884180 001371841146351 396

<