Thread error HTTP Status 500

[jkim-61]

Hi, all.

I can't suddenly connect to the server.

I don't know why. This error occurs.

ApplicationLog

Actually, connection was smooth until just a few days ago.

Ubuntu 14.04, Tomcat8, Postgresql9.4..

Please help me T.T

[supandey]

Hi Jeongeun, just to confirm is PostgerSQL DB is up and running? Are you able to connect to it via PgAdminII client? Can you also share the tomcat logs?

[jkim-61]

yes, running.

What does mean this error? I deleted everything. And I installed Thingworx8. However, the same error occurs.

help me.

[supandey]

Is it possible for you attach the applicationLog and Tomcat's catalina log here? It's bit hard to check for issues just with snippets of logs.

[jkim-61]

I attach download link.(Application log, Catalina log)

log - Google Drive​

Thank you !!

[ytella]

Hi Jeongeun Kim,

I have found the following error in the application.log.

     PooledConnection that has already signalled a Connection error is still in use!

Could you please refer to the following article and make the changes accordingly?

https://www.ptc.com/en/support/article?n=CS261398&language=en&posno=1&q=PooledConnection%20that%20has%20already%20signalled%20a%20Connection%20error%20is%20still%20in%20use!&source=search

[jkim-61]

Thank you for your solution. I re-create database(thingworx) but I got this error.

T.T help me.

[ytella]

Hi Jeongeun Kim,

Could you please share the PostgreSQL logs from <postgres_install_point>\<version>\data\pg_log>

[jkim-61]

Attach postgresql main log file. Thank you in advance!

postgresql-9.4-main.log - Google Drive

[posipova]

How do you deploy your application? Do you drop the .war file in Tomcat/webapps folder or upload via the browser? The browser/UI method would not work and likely  cause this error.

JUdging by the logs your database isn't connecting either.

[jkim-61]

I copied .war file under the webapps folder..

[posipova]

Have you ever installed a different version of postgres on the same machine? And what is your current version?

[jkim-61]

The current version is 9.4.

I reinstalled Postgresql and pgadmin3 due to this error. (same version)

[posipova]

I'd ensure it was fully removed Ensuring PostgreSQL database is fully removed

[jkim-61]

Thank you for your reply. I fully removed and reinstalled it.

Each time I run pgadmin3, the following problems occur in the database. I'll need to reenter password. Is right?

[dupatel]

Jeongeun Kim​: In PostgreSQL,a password is required depends on your settings in pg_hba.conf and there are different ways you can connect - different settings in pg_hba.conf may apply.

If you have a line like this at the top your pg_hba.conf file:

local    all     all     peer

OR:

local    all     all     ident

>>Then you can connect locally without password if your system user is "postgres" and your database user is "postgres" too.

So you need to change your pg_hba.conf to fix the issue.

Here's an example:

pg_hba.conf:

TYPE  DATABASE        USER            ADDRESS                 METHOD

host    all             all             127.0.0.1/32            trust

host    all             all             ::1/128                 trust

NOTE : Trust means that anyone on address (in this case localhost) can connect as the listed user and setting is suitable for development configurations and ideally should not be used in production setup.

-Durgesh