server fails to start, does not detect livecd filesystem's wal_sync_method

Bug #658857 reported by alexisabarca
22
This bug affects 3 people
Affects Status Importance Assigned to Milestone
postgresql-8.4 (Ubuntu)
Confirmed
Undecided
Unassigned

Bug Description

Binary package hint: postgresql-8.4

I installed package postgresql via apt-get and postgresql fails to start

Terminal log: txt file attached

Release:
Description: Ubuntu 10.10
Release: 10.10

ubuntu@ubuntu:~$ apt-cache policy postgresql
postgresql:
  Instalados: 8.4.5-0ubuntu10.10
  Candidato: 8.4.5-0ubuntu10.10
  Tabla de versión:
 *** 8.4.5-0ubuntu10.10 0
        500 http://mirror.netlinux.cl/ubuntu/ maverick-security/main i386 Packages
        500 http://mirror.netlinux.cl/ubuntu/ maverick-updates/main i386 Packages
        100 /var/lib/dpkg/status
     8.4.4-2 0
        500 http://mirror.netlinux.cl/ubuntu/ maverick/main i386 Packages

Error when try to start postgresql server

root@ubuntu:/home/ubuntu# /etc/init.d/postgresql start
 * Starting PostgreSQL 8.4 database server * The PostgreSQL server failed to start. Please check the log output:
2010-10-11 22:07:32 CLST LOG: el sistema de bases de datos fue apagado en 2010-10-11 22:01:44 CLST
2010-10-11 22:07:32 CLST PANIC: no se pudo abrir <<pg_xlog/000000010000000000000000>> (archivo de registro 0, segmento 0): Argumento inv?lido
2010-10-11 22:07:32 CLST LOG: el paquete de inicio est? incompleto
2010-10-11 22:07:32 CLST LOG: proceso de inicio (PID 7081) fue terminado por una se?al 6: Aborted
2010-10-11 22:07:32 CLST LOG: abortando el inicio debido a una falla en el procesamiento de inicio
                                                                                                                                                                 [fail]

dmesg log only show hardware and wifi activity, nothing related to postgresql

ProblemType: Package
DistroRelease: Ubuntu 10.10
Package: postgresql-8.4 8.4.5-0ubuntu10.10
ProcVersionSignature: Ubuntu 2.6.35-22.33-generic 2.6.35.4
Uname: Linux 2.6.35-22-generic i686
Architecture: i386
Date: Mon Oct 11 22:01:50 2010
ErrorMessage: el subproceso script post-installation instalado devolvió el código de salida de error 1
LiveMediaBuild: Ubuntu 10.10 "Maverick Meerkat" - Release i386 (20101007)
SourcePackage: postgresql-8.4
Title: package postgresql-8.4 8.4.5-0ubuntu10.10 failed to install/upgrade: el subproceso script post-installation instalado devolvió el código de salida de error 1

Revision history for this message
alexisabarca (alexisabarca) wrote :
Revision history for this message
alexisabarca (alexisabarca) wrote :

Looking other reports, i check the permissions of the main folder and are fine

root@ubuntu:/var/lib/postgresql/8.4# ls -all
total 12
drwxr-xr-x 3 postgres postgres 4096 2010-10-11 22:01 .
drwxr-xr-x 3 postgres postgres 4096 2010-10-11 22:01 ..
drwx------ 11 postgres postgres 4096 2010-10-11 22:40 main

Revision history for this message
alexisabarca (alexisabarca) wrote :

I installed ubuntu 10.10 on a desktop and installed postgresql package and worked fine, this bug only occur in live cd and live usb

Revision history for this message
vanjeje (vanjeje) wrote :

After searching for a while, it seems it is related to the file system...
I found some interesting piece of information on http://www.piware.de/2010/09/postgresql-9-0-final-released/ : so I changed some "wal" configuration in postgresql.conf (uncommented wal_sync_method, wal_buffers and wal_writer_delay), and then "/etc/init.d/postgresql start" worked !
Limited workaround since I do not know what this changes, but it is enough for my little tests on my live ubuntu usb key.

Revision history for this message
Daniel C. Axelrod (daxelrod) wrote :

Interestingly enough, this appears to be a regression. I got the same results as you did on a 10.10 livecd.

However, on a 10.04.1 livecd, postgresql-8.4 installs and starts successfully.

summary: - package postgresql-8.4 8.4.5-0ubuntu10.10 failed to install/upgrade: el
- subproceso script post-installation instalado devolvió el código de
- salida de error 1
+ server fails to start, does not detect livecd filesystem's
+ wal_sync_method
Changed in postgresql-8.4 (Ubuntu):
status: New → Confirmed
Revision history for this message
Daniel C. Axelrod (daxelrod) wrote :

In particular http://www.piware.de/2010/09/postgresql-9-0-final-released/#comment-1083 and the comment below it highlight the issue.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.