[CalendarServer-users] postgres crash?

[mattfairley at netscape.net]

Hi,

This question may not be relevant for this forum but as my only use of Potgresql relates to an implementation of the Calendar Server I thought I'd start here.

 

 I've been running Calendar Server for me and my wife on a mac mini and we share several calendars on our iphones using the mac mini as the server. Recently, the mac mini started to behave strangely in all sorts of ways and despite not wanting to, I had to resort to a reformat of the hard drive, restoring the whole machine from a time machine backup. However, since the restore, the Calendar Server no longer starts up and I get the following in my log file:

31/07/2011 23:41:18	ReportCrash[327]	Saved crash report for postgres[325] version ??? (???) to /Users/administrator/Library/Logs/DiagnosticReports/postgres_2011-07-31-234118_MyMachineName.crash


The text of the crash report is as follows:


Process:         postgres [325]

Path:            /Users/administrator/calendar/postgresql-9.0.3/_root/bin/postgres
Identifier:      postgres
Version:         ??? (???)
Code Type:       X86-64 (Native)
Parent Process:  postgres [324]


Date/Time:       2011-07-31 23:41:16.743 +0100
OS Version:      Mac OS X 10.6.8 (10K540)
Report Version:  6


Exception Type:  EXC_CRASH (SIGABRT)
Exception Codes: 0x0000000000000000, 0x0000000000000000
Crashed Thread:  0  Dispatch queue: com.apple.main-thread


Application Specific Information:
abort() called


Thread 0 Crashed:  Dispatch queue: com.apple.main-thread
0   libSystem.B.dylib             	0x00007fff897840b6 __kill + 10
1   libSystem.B.dylib             	0x00007fff898249f6 abort + 83
2   postgres                      	0x000000010028327e errfinish + 574
3   postgres                      	0x0000000100041b5c StartupXLOG + 10556
4   postgres                      	0x00000001000422f2 StartupProcessMain + 242
5   postgres                      	0x0000000100059389 AuxiliaryProcessMain + 1465
6   postgres                      	0x0000000100192ab1 StartChildProcess + 241
7   postgres                      	0x000000010019527d PostmasterMain + 2605
8   postgres                      	0x0000000100137b15 main + 933
9   postgres                      	0x00000001000008d4 start + 52


Thread 0 crashed with X86 Thread State (64-bit):
  rax: 0x0000000000000000  rbx: 0x0000000000000000  rcx: 0x00007fff5fbfdc38  rdx: 0x0000000000000000
  rdi: 0x0000000000000145  rsi: 0x0000000000000006  rbp: 0x00007fff5fbfdc50  rsp: 0x00007fff5fbfdc38
   r8: 0x00000001002f2eae   r9: 0x0000000000000000  r10: 0x00007fff897800fa  r11: 0x0000000000000206
  r12: 0x00000001004b9300  r13: 0x0000000100461d48  r14: 0x0000000000000016  r15: 0x0000000100600960
  rip: 0x00007fff897840b6  rfl: 0x0000000000000206  cr2: 0x00007fff8980f162


Binary Images:
       0x100000000 -        0x10043efff +postgres ??? (???) <47C8BA95-4A12-313B-F5FA-E39F9421BB7F> /Users/administrator/calendar/postgresql-9.0.3/_root/bin/postgres
    0x7fff5fc00000 -     0x7fff5fc3bdef  dyld 132.1 (???) <B536F2F1-9DF1-3B6C-1C2C-9075EA219A06> /usr/lib/dyld
    0x7fff807f7000 -     0x7fff807fbff7  libmathCommon.A.dylib 315.0.0 (compatibility 1.0.0) <95718673-FEEE-B6ED-B127-BCDBDB60D4E5> /usr/lib/system/libmathCommon.A.dylib
    0x7fff89735000 -     0x7fff898f6fef  libSystem.B.dylib 125.2.11 (compatibility 1.0.0) <9AB4F1D1-89DC-0E8A-DC8E-A4FE4D69DB69> /usr/lib/libSystem.B.dylib
    0x7fffffe00000 -     0x7fffffe01fff  libSystem.B.dylib ??? (???) <9AB4F1D1-89DC-0E8A-DC8E-A4FE4D69DB69> /usr/lib/libSystem.B.dylib





I'm also getting the following in my postgres log file:



FATAL:  the database system is starting up
LOG:  unexpected pageaddr 0/2058000 in log file 0, segment 4, offset 360448
LOG:  invalid primary checkpoint record
LOG:  unexpected pageaddr 0/2056000 in log file 0, segment 4, offset 352256
LOG:  invalid secondary checkpoint record
PANIC:  could not locate a valid checkpoint record
FATAL:  the database system is starting up
LOG:  startup process (PID 325) was terminated by signal 6: Abort trap
LOG:  aborting startup due to startup process failure



(Just to be clear, the extracts form the logs may not be form the same attempts to start things up - just in case anyone was looking at PIDs not being the same, etc.)


Things I've tried so far are to re-compile and re-install my version of postgres and to use pg_resetxlog, just with the 'f' switch, both to no avail.


Is it dead? Can I save it? If so how? What else can I try? My concern lies mainly around how to salvage the current data that is on our phones that hasn't been synched with the server - I can use iCal to export a backup of the calendars and restore them on a new installation but it's the data on the phones that gives me cause for concern. If I can get things back up and running again, that would be great!!


Hope you can help.


Many thanks,


Matt

 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/calendarserver-users/attachments/20110801/1ee4d08f/attachment.html>