Thread: BUG #5437: Production db down
The following bug has been logged online: Bug reference: 5437 Logged by: shanmugavel Email address: shanmugavel_m@onwardgroup.com PostgreSQL version: 8.3 Operating system: linux RHEL 5 Description: Production db down Details: Hi, i'm shanmugavel I'm oracle dba now i handle the postgressql db. now i face the problem how can i resolve that the problem LOG: database system was shut down at 2007-05-14 19:47:51 BST LOG: invalid magic number 000 in log file 0, segment 0, offset 0 LOG: invalid primary checkpoint record LOG: invalid magic number 000 in log file 0, segment 0, offset 0 LOG: invalid secondary checkpoint record PANIC: could not locate a valid checkpoint record LOG: startup process (PID 9590) was terminated by signal 6: Aborted LOG: aborting startup due to startup process failure Regards, Shanmugavel M
shanmugavel wrote: > i'm shanmugavel I'm oracle dba now i handle the postgressql db. now i face > the problem > > how can i resolve that the problem > > > LOG: database system was shut down at 2007-05-14 19:47:51 BST > LOG: invalid magic number 000 in log file 0, segment 0, offset 0 > LOG: invalid primary checkpoint record > LOG: invalid magic number 000 in log file 0, segment 0, offset 0 > LOG: invalid secondary checkpoint record > PANIC: could not locate a valid checkpoint record > LOG: startup process (PID 9590) was terminated by signal 6: Aborted > LOG: aborting startup due to startup process failure I don't know what problem you face, but that's not from your log file. That's from http://archives.postgresql.org/pgsql-hackers/2007-05/msg00573.php and has nothing to do with whatever your problem is. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com
shanmugavel wrote: > The following bug has been logged online: > > Bug reference: 5437 > Logged by: shanmugavel > Email address: shanmugavel_m@onwardgroup.com > PostgreSQL version: 8.3 > Operating system: linux RHEL 5 > Description: Production db down > Details: > > Hi, > > i'm shanmugavel I'm oracle dba now i handle the postgressql db. now i face > the problem > > how can i resolve that the problem > > > LOG: database system was shut down at 2007-05-14 19:47:51 BST > LOG: invalid magic number 000 in log file 0, segment 0, offset 0 > LOG: invalid primary checkpoint record > LOG: invalid magic number 000 in log file 0, segment 0, offset 0 > LOG: invalid secondary checkpoint record > PANIC: could not locate a valid checkpoint record > LOG: startup process (PID 9590) was terminated by signal 6: Aborted > LOG: aborting startup due to startup process failure > > what sub-version of 8.3.x is this ? this database was shut down 4 years ago and just now restarted? !? thats odd. frankly, it looks like the file system holding $PGDATA got seriously stepped on and multiple database files are corrupted. got any backups?
"shanmugavel" <shanmugavel_m@onwardgroup.com> wrote: > Description: Production db down > now i face the problem > > how can i resolve that the problem > [cut and paste from an archive post from three years ago > about a non-production version under development] You've actually given no information about what problem you have or what version of PostgreSQL you're running. Please review this page: http://wiki.postgresql.org/wiki/Guide_to_reporting_problems Also, you'll get best results posting to a list which fits the topic. http://www.postgresql.org/community/lists/ Unless you have some reason to believe there's a PostgreSQL bug involved, it would be better to start a discussion of a production problem on the pgsql-admin or pgsql-general list. -Kevin