Mailing List Archive

> Click Create -- delay of exactly 300 seconds
> changing the postgres checkpoint timeout to 30 does not alter this
> so it's not a checkpoint timeout.
>

followup... postgres 7.2

there is definetly a problem talking to the data base for this
transaction.

there is one postgress process hung at...

postgres: bricolage cmtcmt [local] idle in transaction

The "in transaction" part disappears after the 300 seconds
when bric returns the blank page + nav bar

The permissions look OK and are the same for all tables
{=,postgres=arwdRxt,bricolage=arwd}

stumped!
Michael@Insulin-Pumpers.org

_______________________________________________
Bricolage-General mailing list
Bricolage-General@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bricolage-general

On Wed, 2002-03-13 at 17:12, Michael wrote:

> postgres: bricolage cmtcmt [local] idle in transaction

Huh. I wonder what that means. You might actually want to post to the
pgsql-general list about this one. I'm not sure why it would hang like
that...

David
--
David Wheeler AIM: dwTheory
david@kineticode.com ICQ: 15726394
Yahoo!: dew7e
Jabber: Theory@jabber.org
Kineticode. Setting knowledge in motion.(sm)

_______________________________________________
Bricolage-General mailing list
Bricolage-General@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bricolage-general

>
> followup... postgres 7.2
>

Tried to use Pg7.2 but somehow Bric_1.3 was complaining on install.
Didn't really try bric_1.2.1 with Pg7.2. what i did was downgrade to
pg7.1.3 and bric_1.2.1. try that.

Is anyone here using Pg7.2?




_______________________________________________
Bricolage-General mailing list
Bricolage-General@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bricolage-general

On Wed, 2002-03-13 at 19:21, Marlon Bermas wrote:

> Tried to use Pg7.2 but somehow Bric_1.3 was complaining on install.
> Didn't really try bric_1.2.1 with Pg7.2. what i did was downgrade to
> pg7.1.3 and bric_1.2.1. try that.

Yep. Works fine for me. I did find a bug, though, in bric_pgimport. I
fixed it a while, back, but don't remember if that was before the 1.3.0
release.

You can either grab Bric from CVS, or wait for the 1.2.2 and 1.3.1
releases, which should be out over the next coupla days.

Or we could try to figure out what's wrong. What errors are you getting?

Regards,

David

--
David Wheeler AIM: dwTheory
david@kineticode.com ICQ: 15726394
Yahoo!: dew7e
Jabber: Theory@jabber.org
Kineticode. Setting knowledge in motion.(sm)

_______________________________________________
Bricolage-General mailing list
Bricolage-General@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bricolage-general

Marlon Bermas wrote:
> >
> > followup... postgres 7.2
> >
>
> Tried to use Pg7.2 but somehow Bric_1.3 was complaining on install.
> Didn't really try bric_1.2.1 with Pg7.2. what i did was downgrade to
> pg7.1.3 and bric_1.2.1. try that.
>
> Is anyone here using Pg7.2?

I am. I've had no issues with it so far. Are you using
make install to install the db, or bric_pgimport?



--
--
=================================================================
-- mark at geekhive dot net --

_______________________________________________
Bricolage-General mailing list
Bricolage-General@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bricolage-general

> Marlon Bermas wrote:
> > >
> > > followup... postgres 7.2
> > >
> >
> > Tried to use Pg7.2 but somehow Bric_1.3 was complaining on install.
> > Didn't really try bric_1.2.1 with Pg7.2. what i did was downgrade to
> > pg7.1.3 and bric_1.2.1. try that.
> >
> > Is anyone here using Pg7.2?
>
> I am. I've had no issues with it so far. Are you using
> make install to install the db, or bric_pgimport?
>
Bric import...

sigh.... it appears to have something to do with browser dependency.

test setup:

host rambo -- slackware 8.0 w/linux 2.4.17 ,postgres & bricolage
host hoit -- w95 box, netscape 4.77
host pandora -- slackware 8.0 w/linux 2.4.17, netscape 4.77

when entering a story on HOIT, system hangs as previously described.
when entering a story on PANDORA, works fine.

This is really a pain.....
Michael@Insulin-Pumpers.org

_______________________________________________
Bricolage-General mailing list
Bricolage-General@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bricolage-general

On Thu, 14 Mar 2002, Michael wrote:

> host rambo -- slackware 8.0 w/linux 2.4.17 ,postgres & bricolage
> host hoit -- w95 box, netscape 4.77
> host pandora -- slackware 8.0 w/linux 2.4.17, netscape 4.77
>
> when entering a story on HOIT, system hangs as previously described.
> when entering a story on PANDORA, works fine.

Have you tried IE or Mozilla on the win95 box? Those two have gotten the
most testing under Windows... Although I'm having trouble imagining what
a browser could do to cause a hung transaction in the database!

-sam



_______________________________________________
Bricolage-General mailing list
Bricolage-General@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bricolage-general

> On Thu, 14 Mar 2002, Michael wrote:
>
> > host rambo -- slackware 8.0 w/linux 2.4.17 ,postgres & bricolage
> > host hoit -- w95 box, netscape 4.77
> > host pandora -- slackware 8.0 w/linux 2.4.17, netscape 4.77
> >
> > when entering a story on HOIT, system hangs as previously described.
> > when entering a story on PANDORA, works fine.
>
> Have you tried IE or Mozilla on the win95 box? Those two have
> gotten the most testing under Windows... Although I'm having
> trouble imagining what a browser could do to cause a hung
> transaction in the database!
>
> -sam
>
I'm having the same trouble as you imagining this :-( it is really
bizarre.

works on W95 with msie 5.50.4522.1800
does not work with w95 Netscape 4.77 -- this is very consistent,
happens every time.

works every time on the linux client Netscape 4.77
Michael@Insulin-Pumpers.org

_______________________________________________
Bricolage-General mailing list
Bricolage-General@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bricolage-general

On Thu, 14 Mar 2002, Michael wrote:

> works on W95 with msie 5.50.4522.1800
> does not work with w95 Netscape 4.77 -- this is very consistent,
> happens every time.

Hmmm, ok. Here's what I'd like you to do:

- Add these two options to bricolage.conf:

DBI_DEBUG=1
DBI_CALL_TRACE=1

- Truncate your error_log.

- Restart your server.

- Hit the server with Nestscape 4.77 and do just enough to cause the
hang.

- Stop your server.

- Copy your error_log to netscape.out and truncate it.

- Start your server.

- Hit the server with IE and do the same exact thing you did with
Netsape 4.77.

- Stop your server.

- Send the results of this command to the list, compressed if it's
large:

diff -u error_log netscape.out

If something different is happening to the database with Netscape 4.77 and
IE then we'll see it there. Of course, we'll also see a bunch of trivial
difference (IDs mostly) but it might be revealing anyway.

-sam



_______________________________________________
Bricolage-General mailing list
Bricolage-General@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bricolage-general

> On Thu, 14 Mar 2002, Michael wrote:
>
> > works on W95 with msie 5.50.4522.1800
> > does not work with w95 Netscape 4.77 -- this is very consistent,
> > happens every time.
>
> Hmmm, ok. Here's what I'd like you to do:
>
> - Add these two options to bricolage.conf:
>
> DBI_DEBUG=1
> DBI_CALL_TRACE=1
>

for each run, the following was done

stop server
rm ...../logs/bric_error_log
start server

hit entry page
login
click Story arrow
click new story

Title: netscape or msie
Slug: netscape or msie
Story Type: Story
Source: Internal Source (Rename)
Primary Category: /
Priority: Normal
Cover Date: whatever comes up

Click -- Create

netscape action:
immediate screen flicker,
Nav Bar is displayed
New Story bar + Help, MyAlerts, LogOut displayed
Properties Box with all text is shown, but the data entry boxes
themselves (including outlines) are missing
Submit and Create are displayed

after 300 seconds, screen than has Nav Bar only with the remainder of
the page completely blank.

During the 300 seconds, one of the postgres jobs appears as:
postgres: bricolage cmtcmt [local] idle in transaction

the other postgres jobs all say:
postgres: bricolage cmtcmt [local] idle

MSIE returns the second page of the story dialog

diff attached

Michael
Michael@Insulin-Pumpers.org

_______________________________________________
Bricolage-General mailing list
Bricolage-General@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bricolage-general

The following section of this message contains a file attachment
prepared for transmission using the Internet MIME message format.
If you are using Pegasus Mail, or any another MIME-compliant system,
you should be able to save it or view it from within your mailer.
If you cannot, please ask your system administrator for assistance.

---- File information -----------
File: net_msie.dif
Date: 14 Mar 2002, 11:14
Size: 9128 bytes.
Type: Unknown

On Thu, 14 Mar 2002, Michael wrote:

> ---- File information -----------
> File: net_msie.dif
> Date: 14 Mar 2002, 11:14
> Size: 9128 bytes.
> Type: Unknown

Argh, my eyes! Could you try that again with the "diff -u" command? I
find normal diffs to be nearly unreadable.

-sma



_______________________________________________
Bricolage-General mailing list
Bricolage-General@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bricolage-general