ProgrammingError: relation "pgtextindex" does not exist

Bug #807227 reported by Paul Everitt
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
KARL3
Invalid
Medium
Shane Hathaway

Bug Description

The error monitor picked this up.

Fri Jun 17 13:12:33 2011 Exception when processing https://karlstaging.gocept.com/branch5/osf-relstorage/searchresults.html?body=hello Referer: https://karlstaging.gocept.com/branch5/osf-relstorage/communities/all_communities.html Traceback (most recent call last): File "/srv/osfkarltest/staging/branch5/src/karl/karl/errorlog.py", line 16, in middleware return app(environ, start_response) File "/srv/osfkarltest/staging/branch5/eggs/repoze.retry-0.9.4-py2.6.egg/repoze/retry/__init__.py", line 88, in __call__ app_iter = self.application(environ, replace_start_response) File "/srv/osfkarltest/staging/branch5/eggs/repoze.zodbconn-0.11-py2.6.egg/repoze/zodbconn/connector.py", line 21, in __call__ result = self.next_app(environ, start_response) File "/srv/osfkarltest/staging/branch5/eggs/repoze.tm2-1.0a5-py2.6.egg/repoze/tm/__init__.py", line 23, in __call__ result = self.application(environ, save_status_and_headers) File "/srv/osfkarltest/staging/branch5/eggs/repoze.who-1.0.15-py2.6.egg/repoze/who/middleware.py", line 107, in __call__ app_iter = app(environ, wrapper.wrap_start_response) File "/srv/osfkarltest/staging/branch5/eggs/repoze.bfg-1.2-py2.6.egg/repoze/bfg/router.py", line 130, in __call__ response = view_callable(context, request) File "/srv/osfkarltest/staging/branch5/eggs/repoze.bfg-1.2-py2.6.egg/repoze/bfg/configuration.py", line 1753, in _secured_view return view(context, request) File "/srv/osfkarltest/staging/branch5/eggs/repoze.bfg-1.2-py2.6.egg/repoze/bfg/configuration.py", line 1704, in _rendered_view response = view(context, request) File "/srv/osfkarltest/staging/branch5/src/karl/karl/views/search.py", line 257, in searchresults_view batch, terms = get_batch(context, request) File "/srv/osfkarltest/staging/branch5/src/karl/karl/views/search.py", line 148, in get_batch batch = get_catalog_batch_grid(context, request, **query) File "/srv/osfkarltest/staging/branch5/src/karl/karl/views/batch.py", line 135, in get_catalog_batch_grid batch = get_catalog_batch(context, request, **kw) File "/srv/osfkarltest/staging/branch5/src/karl/karl/views/batch.py", line 49, in get_catalog_batch total, docids, resolver = searcher(**kw) File "/srv/osfkarltest/staging/branch5/src/karl/karl/models/adapters.py", line 73, in __call__ num, docids = self.catalog.search(**kw) File "/srv/osfkarltest/staging/branch5/src/karl/karl/models/catalog.py", line 93, in search num, docids = self._search(*arg, **kw) File "/srv/osfkarltest/staging/branch5/src/karl/karl/models/catalog.py", line 113, in _search res = super(CachingCatalog, self).search(*arg, **kw) File "/srv/osfkarltest/staging/branch5/eggs/repoze.catalog-0.7.3-py2.6.egg/repoze/catalog/catalog.py", line 84, in search r = index.apply(index_query) File "/srv/osfkarltest/staging/branch5/src/repoze.pgtextindex/repoze/pgtextindex/index.py", line 261, in applyContains cursor = self._run_query(query) File "/srv/osfkarltest/staging/branch5/src/repoze.pgtextindex/repoze/pgtextindex/index.py", line 257, in _run_query cursor.execute(stmt, params) ProgrammingError: relation "pgtextindex" does not exist LINE 4: FROM pgtextindex, to_tsquery(E'english', E'''hello''... ^

Revision history for this message
Shane Hathaway (shane-hathawaymix) wrote :

This must have happened during the conversion or something. It simply says that the pgtextindex table did not exist at the time (June 17). The table exists now. :-)

Changed in karl3:
status: New → Invalid
Revision history for this message
Balazs Ree (ree) wrote :

Just noting that I was running into the same issue when upgrading my sandbox manually.

Revision history for this message
Balazs Ree (ree) wrote :

... and dropdb karltest; createdb -O karltest karltest does not fix the problem.

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

Other bug subscribers

Remote bug watches

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