DX Application Performance Management

  • Private Community
 View Only

  • 1.  CA Application Behavior Analytics Server - PSQL Error

    Posted Apr 30, 2015 03:42 PM

    I am having an issue with Analysis Server.  I believe it based on the pgsql database.  the pg_log has these errors:

     

    2015-04-30 19:35:59 GMT::@:[8705]: ERROR:  could not open file "base/16384/12554": No such file or directory

    2015-04-30 19:36:19 GMT::@:[8712]: ERROR:  could not open file "base/12788/12554": No such file or directory

    2015-04-30 19:36:39 GMT::@:[8716]: ERROR:  could not open file "base/1/12554": No such file or directory

     

    I have confirmed that they are in the /base directory structure.  I thought I would try the suggestion here to rebuild the database:

     

    http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec1783934.aspx

     

    but it also complains about the missing 12554 file.

     

    Looking for some suggestions.

     

    Thanks!



  • 2.  Re: CA Application Behavior Analytics Server - PSQL Error
    Best Answer

    Posted May 06, 2015 10:37 AM

    So, I guess finding out what table 12554 is first by running this on prelert db.

    select * from pg_class where oid=12554

     

    would be helpful. But I'm afraid that you may just end up doing the restore/recreate the whole db, anyways. Hopefully finding out the table in effect could help you find a pattern to the root cause. I'd check with postgresql.org and see if anyone there can help. or maybe this is a db corruption issue - Corruption - PostgreSQL wiki

    good luck~!