Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2009
    Posts
    3

    Exclamation 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
    Code:
    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.

    Thanks in advance....

  2. #2
    Join Date
    Nov 2003
    Posts
    2,934
    Provided Answers: 12
    is there any relation between killing and data corruption.
    Yes there is. A direct relation in fact, the killing of the postmaster most probably corrupted your data. I guess you'll need to restore your backups

    Why aren't you using a connection pool in Tomcat?

  3. #3
    Join Date
    Apr 2009
    Posts
    3

    thanks

    Thanks shammat. But mostly connection are made for select only not for delete or update, so y it is corrupting the data?

    We are using tomcat pooling but we dont know why it went wrong.?

    is there any way to check the connection pool's active connection?
    Last edited by arvindwill; 04-20-09 at 08:30.

  4. #4
    Join Date
    Nov 2003
    Posts
    2,934
    Provided Answers: 12
    What do you mean with "y it"?
    Sorry my english isn't that good. I don't know those special idioms.

    Quote Originally Posted by arvindwill
    Thanks shammat. But mostly connection are made for select only not for delete or update, so y it is corrupting the data?
    Because Postgres maintains a lot of information that needs to be written do disk even when you "only" select from the database.

    is there any way to check the connection pool's active connection?
    Check out the manual: PostgreSQL: Documentation: Manuals: PostgreSQL 8.3: Monitoring Database Activity

  5. #5
    Join Date
    Apr 2009
    Posts
    3

    thanks

    actually my postgres press is mostly idle and some are update... but y it causing already present data to corrupt...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •