Greetings,
I have a problem with one of my databases. When I try to connect to one of my 3 databases using psql it's just hangs and I can't connect. The other databases are still ok even after I get a hangup from the damaged one.
I'm sorry but I couldn't collect too much information. It simply doesn't show any error messages or warnings.
The only valuable info collected was from single user connection atempt. But I still not sure if that zero length record could be the responsible for the problem.
-bash-2.05b$ postgres -D /home/postgres/data bxs
LOG: database system was interrupted at 2005-04-15 18:01:28 BRT
LOG: checkpoint record is at 0/A0A8034
LOG: redo record is at 0/A0A8034; undo record is at 0/0; shutdown FALSE
LOG: next transaction id: 202541; next oid: 202391
LOG: database system was not properly shut down; automatic recovery in progress
LOG: ReadRecord: record with zero length at 0/A0A8074
LOG: redo is not required
LOG: database system is ready
select * from cnfg_geral; **hangs here**
By the way, pg_resetxlog doens't work too.
Has anyone seen something like this happening? Is there a way to fix it?
Thanks in advance.
Vilson
-- *José Vilson de Mello de Farias* /Analista de Sistemas// APL - IBD (Interfaces e Bancos de Dados) /
*DÍGITRO TECNOLOGIA*
*E-mail:* vilson.farias@xxxxxxxxxxxxxx <mailto:vilson.farias@xxxxxxxxxxxxxx%20>
*Messenger: *vilson.farias@xxxxxxxxxxx <mailto:vilson.farias@xxxxxxxxxxxxxx%20>
*Fone:* (0xx48) 281-7314
*Fax:* (0xx48) 281-7000
*Site:* www.digitro.com.br <http://www.digitro.com.br%20> <http://www.digitro.com.br%20>
begin:vcard fn;quoted-printable:Jos=C3=A9 Vilson de Mello de Farias n;quoted-printable:de Mello de Farias;Jos=C3=A9 Vilson org;quoted-printable:D=C3=ADgitro Tecnologia Ltda;IBD adr;quoted-printable:Capoeiras;;Sofia Quint de Souza, 167;Florian=C3=B3polis;SC;88085-040 ;Brasil email;internet:vilson.farias@xxxxxxxxxxxxxx title:Analista de Sistemas tel;work:(48) 281-7314 x-mozilla-html:TRUE url:http://www.digitro.com.br version:2.1 end:vcard
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
