Bug#311368: initdb fails, template1 not created
Hi Aart! Aart Koelewijn [2005-06-01 20:09 +0200]: It then still did not work, so I rebooted the box, which gave some problems because it did not react on 'shutdown now' or Ctrl-Alt-Del. I could only shut down whith 'init 0', which stopped when swap had to be unmounted. I then shut the power down and after that rebooted. Now everything works fine again and I update to 7.4.7-6sarge1, which now went without a problem. Duh, that sounds like a more serious problem... Good luck with fixing it. Do you mind if I close the bug now? Now if I could only find an easy way to keep the databases on both boxes synchronised ;-) You want Slony-1, a database replication tool for PostgreSQL. Unfortunately it's not yet packaged... Martin -- Martin Pitt http://www.piware.de Ubuntu Developer http://www.ubuntulinux.org Debian Developerhttp://www.debian.org signature.asc Description: Digital signature
Bug#311368: initdb fails, template1 not created
Hi Aart! Aart Koelewijn [2005-06-01 12:09 +0200]: This is weird, I first removed the postgresql package completely including /var/lib/postgres to be sure in would be a clean install and then tried to install 7.4.7-6_i386. The installation stopped at exactly the same point where the installation of the sarge1 version stopped. I anticipated that this happened because sarge1 does not touch any code that could break initdb. So it seems an older version installed ok and that newer versions then gave no problem because no new template1 had to be build. Well, the next thing I can try, I think, is to remove 7.4.7_6 and start with an older version and then try to install newer versions over that. You can, but maybe you should also check whether you installed a newer kernel recently or suffered a hardware problem (look in the syslogs for hard disk errors or run memtest86 to check memory). I leave this as unreproducible for now, there is little I can do about this. Good luck! Martin -- Martin Pitt http://www.piware.de Ubuntu Developer http://www.ubuntulinux.org Debian Developerhttp://www.debian.org -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#311368: initdb fails, template1 not created
Package: postgresql Version: 7.4.7sarge1 After upgrading from version 7.4.7 to version 7.4.7sarge1 I got the following error in autovacuum_log: [2005-05-31 03:48:21 PM] Failed connection to database template1 with error: FATAL: the database system is starting up. [2005-05-31 03:48:21 PM] Error: Cannot connect to template1, exiting. and I was not able to connect to any database anymore I then tried to reconstruct template1 by running initdb, but failed After that I removed the package 7.4.7sarge1 and removed al files in /etc/postgres/* and all files and directories in /var/lib/postgres and then reinstalled 7.4.7sarge1. The installation hangs when initdb is trying to build template1: The database cluster will be initialized with locale C. fixing permissions on existing directory /var/lib/postgres/data... ok creating directory /var/lib/postgres/data/base... ok creating directory /var/lib/postgres/data/global... ok creating directory /var/lib/postgres/data/pg_xlog... ok creating directory /var/lib/postgres/data/pg_clog... ok selecting default max_connections... 100 selecting default shared_buffers... 1000 creating configuration files... ok creating template1 database in /var/lib/postgres/data/base/1... and here it hangs. the installation is Debian Sarge regularly upgraded with new versions of all installed packages. uname -a: Linux mtack.xs4all.nl 2.6.6-1-686 #1 Wed May 12 14:57:57 EST 2004 i686 GNU/Linux I off course see this as a very critical error as it makes the use of postgres impossible. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#311368: initdb fails, template1 not created
tag 311368 unreproducible thanks Hi Aart! Aart Koelewijn [2005-05-31 16:33 +0200]: After upgrading from version 7.4.7 to version 7.4.7sarge1 I got the following error in autovacuum_log: [2005-05-31 03:48:21 PM] Failed connection to database template1 with error: FATAL: the database system is starting up. [2005-05-31 03:48:21 PM] Error: Cannot connect to template1, exiting. and I was not able to connect to any database anymore Was the server running at this time? Can you reconstruct this situation and try to strace the postmaster if it hangs? Or try to provide a stack trace if it crashes? If you need help with this, I'd be glad to assist you. creating template1 database in /var/lib/postgres/data/base/1... and here it hangs. This is especially frightening, the two sarge1 patches did not touch the initdb code. Can you please (as your normal user) do strace /usr/lib/postgresql/bin/initdb /tmp/testdb 2/tmp/initdb-trace.txt press Control-C after it hangs and send me /tmp/initdb-trace.txt? Thanks, Martin -- Martin Pitt http://www.piware.de Ubuntu Developer http://www.ubuntulinux.org Debian Developerhttp://www.debian.org signature.asc Description: Digital signature
Bug#311368: initdb fails, template1 not created
Hi! Aart Koelewijn [2005-05-31 16:33 +0200]: error: FATAL: the database system is starting up. [2005-05-31 03:48:21 PM] Error: Cannot connect to template1, exiting. and I was not able to connect to any database anymore [...] creating template1 database in /var/lib/postgres/data/base/1... and here it hangs. Oh, and just for cross-checking, this really works again if you downgrade to 7.4.7-6? Martin -- Martin Pitt http://www.piware.de Ubuntu Developer http://www.ubuntulinux.org Debian Developerhttp://www.debian.org signature.asc Description: Digital signature
Bug#311368: initdb fails, template1 not created
Hi Aart! Aart Koelewijn [2005-05-31 22:27 +0200]: I tried to downgrade, I still have the previous debs, but I never had to do it before and can't find a way to install the previous one. Two methods: dpkg -i /var/cache/apt/archives/postgresql_7.4.7-6_i386.deb or apt-get install postgresql=7.4.7-6 Both methods should happily downgrade a package. Martin -- Martin Pitt http://www.piware.de Ubuntu Developer http://www.ubuntulinux.org Debian Developerhttp://www.debian.org signature.asc Description: Digital signature