Bug #1906

Cannot create index for path with MySQL

Added by Antony Chazapis about 12 years ago. Updated almost 11 years ago.

Status:Closed Start date:01/21/2012
Priority:Medium Due date:
Assignee:- % Done:

0%

Category:Pithos Spent time: -
Target version:-

Description

Creating the indexes on path from #1836, cause errors with MySQL:

OperationalError: (OperationalError) (1071, 'Specified key was too long; max key length is 767 bytes') 'CREATE UNIQUE INDEX idx_public_path ON public (path)' ()

History

#1 Updated by Antony Chazapis about 12 years ago

  • Assignee deleted (Sofia Papagiannaki)
  • Target version deleted (0.8.3)

This is a MySQL problem and has not been solved yet (debian 5.1, official 5.5).

#2 Updated by Antony Chazapis about 12 years ago

  • Subject changed from Cannot create index for path with MySQL. to Cannot create index for path with MySQL

#3 Updated by Antony Chazapis almost 12 years ago

  • Status changed from New to Feedback
  • Target version set to 1.0.0

#4 Updated by Vangelis Koukis about 11 years ago

  • Project changed from Pithos to Synnefo
  • Target version deleted (1.0.0)

#5 Updated by Vangelis Koukis about 11 years ago

  • Category set to Pithos

#6 Updated by Georgios Tsoukalas almost 11 years ago

  • Status changed from Feedback to Closed

Postgres is being used and recommended for Pithos.

Also available in: Atom PDF