Warning: Can't synchronize with repository "(default)" (Unsupported version control system "svn": No module named svn). Look in the Trac log for more information.

Ticket #568 (closed defect: fixed)

Opened 12 years ago

Last modified 10 years ago

CatWalk hangs in CatWalkState.createTable() when using Postgres

Reported by: nyenyec Owned by: anonymous
Priority: high Milestone: 0.9
Component: CherryPy Version:
Severity: blocker Keywords: develix
Cc:

Description

When I mount CatWalk like this:

class Root(controllers.RootController):
    catwalk = CatWalk(model)

it works with sqlite, but hangs at startup with postgres.

This used to work before I upgraded recently from r5?? to r747

Example output:

c:\local\python\turbowp>python start-turbowp.py
 1/QueryOne:  SELECT COUNT(relname) FROM pg_class WHERE relname = 'catwalk_state
_table'
 1/QueryR  :  SELECT COUNT(relname) FROM pg_class WHERE relname = 'catwalk_state
_table'
 1/Query   :  CREATE TABLE catwalk_state_table (
    id SERIAL PRIMARY KEY,
    state BYTEA
)
 1/QueryR  :  CREATE TABLE catwalk_state_table (
    id SERIAL PRIMARY KEY,
    state BYTEA
)
 1/QueryOne:  SELECT COUNT(relname) FROM pg_class WHERE relname = 'catwalk_state
_table'
 1/QueryR  :  SELECT COUNT(relname) FROM pg_class WHERE relname = 'catwalk_state
_table'
 1/Query   :  CREATE TABLE catwalk_state_table (
    id SERIAL PRIMARY KEY,
    state BYTEA
)
 1/QueryR  :  CREATE TABLE catwalk_state_table (
    id SERIAL PRIMARY KEY,
    state BYTEA
)

Using a debugger, I see that execution hangs in CatWalkState?.createTable()

Change History

comment:1 Changed 12 years ago by anonymous

  • Keywords develix added

comment:2 Changed 12 years ago by nyenyec

  • Summary changed from CatWalk in CatWalkState.createTable() when using Postgres to CatWalk hangs in CatWalkState.createTable() when using Postgres

comment:3 Changed 12 years ago by dguaraglia@…

  • Status changed from new to assigned

comment:4 Changed 12 years ago by chris.brinker@…

Just another bit I found. If I comment out the catwalk=CatWalk(model) line and let the app load fully it does. If I then uncomment the line the autoreloader does its magic and catwalk works! I hope this helps the effort :)

comment:5 Changed 12 years ago by ronald@…

  • Status changed from assigned to closed
  • Resolution set to fixed

Checked in a workaround in rev909

Note: See TracTickets for help on using tickets.