Unanswered: Postgres datacorruption problem on killing instance process
our web application which runs in tomcat will consume lot data from database. Due to many number of user the dbconnection exceeds 1000+. when we checked the postgres instance in linux server via ps -g postgres -f we have more then 1000 instance (100 dbs). so our weserver failed to establish more connection and halted. At this time we tried to shut down the postgres postmaster but that too failed. so we forcefully killed(kill <pid>) postmaster and restarted the postmaster.
we also got error such as
org.postgresql.util.PSQLException: ERROR: xlog flush request 54/AB4F8AA0 is not satisfied --- flushed only to 54/AA33D288 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:239) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)
is there any relation between this two ??
The problem is after doing this in many tables data are missing??? is there any relation between killing and data corruption.