Após reiniciar o servidor do open fire, está aparecendo erro, não consigo acessar pelo browser e está sem comunicação com spark.
Observação: não sei como acessar o banco de dados e tabela.
I am not exactly sure what’s going on. I do not think that the error that you are showing is related.
My advise:
- Shut down Openfire
- Create a full backup of the Openfire directory
- Create a full backup of the Openfire database
- Check if all Openfire directories have the correct file permissions.
- Remove the file
jmxweb.jarfrom thepluginsdirectory - Restart Openfire
Funcionou obrigado, o que aconteceu?
É necessário instalar jmxweb.jav novamente?
Without more information, I cannot tell exactly what has happened. It appears that the jmxweb plugin somehow conflicted with Openfire. Without more data, it is not possible to tell exactly why.
JMXWeb is typically only used to generate and show very detailled diagnostic information about Openfire. Most people do not need it.
Agora só estou com um problema que o open fire está usando 100% de CPU.
Com 45 maquina, mas antes de aparece esse erro, ele estava com 70 maquina usando pouco cpu.
I’m sorry to hear this. Please create a couple of thread dumps while the system is running at 100% CPU. This will likely help us to diagnose the issue.
You can create thread dumps in a number of ways. As Openfire is a standard Java application, any of the ‘normal’ ways of doing this will work. We also have a Thread Dump plugin for Openfire that allows you to copy/paste the thread dumps from the admin console. Please use whatever you prefer.
Sim até ultilizo esse plugin mas não entendi a dinâmica dele.
Na propria tela: em Servidor > Gerenciador de Servidores > Dumps de Threads, faço as devidads?
Servidor ficam tão lento que nao consigo logar.
A CSRF Failure means that you have to reload the login page, and then try to log in again.
The Thread Dump screen will, on the bottom half, show a big text field that already contains a thread dump. That text only needs to be copied and sent to us.
If Openfire is so slow that the admin console does not work properly, then you may want to create a thread dump in another way. There are a lot of different ways to do this. My advice is to use a search engine to find a way to do this that fits best with your environment. Some generic advice is given at https://www.baeldung.com/java-thread-dump for example.
Mais estranho até para carregar o site do servidor demora bastante, 2 a 5 minutos, infelizmente não tenho conhecimento do java, teria algum video intuitivo?
I suspect that the high memory usage (caused by the usage of the embedded database) is a factor. In various other posts, I have suggested that you increase the amount of memory that is available to Openfire, and/or that you investigate why your database is so large. These are the most likely ways to resolve the issue that you’re having.
estou encaminhando o thread dump
thread.txt (514,3,KB)
Thanks, that is insightful. Your server seems to be ‘busy’ with doing very basic tasks, like broadcasting presence and writing to logfiles. I suspect that what we’re seeing is that the server is running out of memory, and thus must work very hard: it needs to work with a very small amount of available memory (because most of it is used). Try increasing the memory of Openfire.
Obrigado, estou ultilizando 8 GB, recomenda ultiliza quanto?
I don’t know. 8GB should be more than enough, but something is strange in your setup. Give it as much as you can, see if the problem goes away, and then investigate why it’s taking so much memory. As I said, I suspect that your database is very large, for some reason. The cause of the problem may be there.
coloquei 10 GB, estranho que no spark 4.9.2 não dava esses tipos de problemas.
Neste servidor ultilizo somente o open fire, mesmo assim não está travando, tem algo a mais que posso fazer, para não cosumiu muito processador?
You can try and investigate why the database is so big in memory. You are using the embedded database. The content of the database is stored on disk (in the embeddeddb directory). You could try and investigate that directory (it should mostly hold a large textfile with SQL data).
Poderia me orientar como faço acesso ao banco de dados, fiz pesquisar etc.
Mas ainda não conseguir acessar o baco de dados do open fire.
The embedded database is stored in the directory that I mentioned earlier: embeddeddb that is part of the Openfire directory.
It mostly is just a textfile, that can be analyzed with any text editor.
The database is a HSQLDB database. On their website, https://hsqldb.org, you may find additional tools that can help analyze the database.
Lastly, Openfire has a plugin named dbaccess that adds a simple SQL interface to the Openfire admin console. It can be very handy, but as you have reported that your admin console is very slow, it may not be the best tool for you right now.