Error Inserting Data into Postgres DB / I/O Error Occured while sending to the backend

[kbuska]

We are having a random problem inserting data into our Postgres
database. I can't seem to reproduce the below error but its happening
to our customers quite often.

An I/O error occured while sending to the backend

Yes occurred is misspelled in this error. I can't seem to find
anything on it. I was hoping to find more in logs but the activity
logs don't contain any errors.

Follow up question, is there a log somewhere that contains the Java
Stacktrace

Any thoughts on the direction I should take to narrow the problem
down?

Cheers,
Ken

[eddy004 Edwards]

have you checked the catalina logs?

[kbuska]

Thanks for the reply. Where are those logs located?

-ken

[eddy004 Edwards]

assuming you are running Railo on Tomcat,

look under the logs directory

[GX]

Hi Eddy

Your best bet is to also check the postgres logs, assuming it is a
development environment set log level to
log_error_verbosity = verbose

this is found in the postgresql.conf file of your database, in this
file you will also find the path to the logfile, I keep mine in the
database directory in a directory pg_logs (as is default) some systems
prefer to use /var/logs/postgresql.

also check your startupcommand as this may also specify the log path.

I have seen this error message in the passed and it is most annoying
as you loose the original error message :( that is why I started using
verbose logging.

Regards

GX