[ejabberd] pubsub_item.DAT getting big

Stephan Maihöfer sma at turtle-entertainment.de
Thu Oct 2 18:32:02 MSD 2008


hi,

> Thanks Eric! you're right.
> I was also testing with only one published.

it seems to not be the issue here unfortunately...

> Stephan, can you dump the result of the following command on 
> your debug shell:
>  > mnesia:dirty_all_keys(pubsub_state).

here you go:
[{{"3471768","example.com",[]},
  {{"3471768","example.com",[]},"http://jabber.org/protocol/nick"}},
 {{"1808257","example.com",[]},
  {{"1808257","example.com",[]},"http://jabber.org/protocol/nick"}},
 {{"3","example.com",[]},
  {"pubsub.example.com",["www.esl.eu","de","nfs-mw"]}},
 {{"3","example.com",[]},
  {"pubsub.example.com",["www.esl.eu","player","2111189"]}},
 {{"1610466","example.com",[]},
  {{"1610466","example.com",[]},"http://jabber.org/protocol/nick"}},
 {{"2579150","example.com",[]},
  {{"2579150","example.com",[]},"http://jabber.org/protocol/nick"}},
 {{"3527036","example.com",[]},
  {{"3527036","example.com",[]},"http://jabber.org/protocol/nick"}},
 {{"2514173","example.com",[]},
  {{"2514173","example.com",[]},"http://jabber.org/protocol/nick"}},
 {{"2643396","example.com",[]},
  {"pubsub.example.com",["www.esl.eu","player","2643396"]}},
 {{"3034079","example.com",[]},
  {{"3034079","example.com",[]},"http://jabber.org/protocol/nick"}},
 {{"3494111","example.com",[]},
  {{"3494111","example.com",[]},"http://jabber.org/protocol/nick"}},
 {{"2460776","example.com",[]},
  {{"2460776","example.com",[]},"http://jabber.org/protocol/nick"}},
 {{"52061","example.com",[]},
  {{"52061","example.com",[]},"http://jabber.org/protocol/nick"}},
 {{"1148705","example.com",[]},
  {{"1148705","example.com",[]},"http://jabber.org/protocol/nick"}},
 {{"2597514","example.com",[]},
  {{"2597514","example.com",[]},"http://jabber.org/protocol/nick"}},
 {{"2024212","example.com",[]},
  {{"2024212","example.com",[]},"http://jabber.org/protocol/nick"}},
 {{"1464007","example.com",[]},
  {{"1464007","example.com",[]},"http://jabber.org/protocol/nick"}},
 {{"1501189","example.com",[]},
  {{"1501189","example.com",[]},"http://jabber.org/protocol/nick"}},
 {{"638993","example.com",[]},
  {{"638993","example.com",[]},"http://jabber.org/protocol/nick"}},
 {{"3","example.com",[]},
  {"pubsub.example.com",["www.esl.eu","alpen","css","gather"]}},
 {{"1859400","example.com",[]},
  {{"1859400","example.com",[]},"http://jabber.org/protocol/nick"}},
 {{"1884788","example.com",[]},
  {{"1884788","example.com",[]},"http://jabber.org/protocol/nick"}},
 {{"2549831","example.com",[]},
  {{"2549831","example.com",[]},"http://jabber.org/protocol/nick"}},
 {{"1890186","example.com",[]},
  {{"1890186","example.com"|...},"http://jabber.org/protocol/nick"}},
 {{"3","example.com",[]},{"pubsub.example.com",[...]}},
 {{"1171578","example.com"|...},{{...}|...}},
 {{"3"|...},{...}},
 {{...}|...},
 {...}|...]

greetings,
stephan


More information about the ejabberd mailing list