On Friday, December 29, 2017 at 4:19:39 PM UTC+2, George Kontostanos wrote: > Hello list, > > I upgraded my Director to Bareos 16.2.7 via source. Now, when trying to > create the suggested index from the release notes: > > CREATE INDEX PathId_JobId_FileNameId_FileIndex ON File(PathId,_JobId, > _FilenameId,_FileIndex); > > I get the following error: > > ERROR 1072 (42000): Key column '_JobId' doesn't exist in table > > mysql> desc File; > +------------+----------------------+------+-----+---------+----------------+ > | Field | Type | Null | Key | Default | Extra | > +------------+----------------------+------+-----+---------+----------------+ > | FileId | bigint(20) unsigned | NO | PRI | NULL | auto_increment | > | FileIndex | int(10) unsigned | YES | | 0 | | > | JobId | int(10) unsigned | NO | MUL | NULL | | > | PathId | int(10) unsigned | NO | | NULL | | > | FilenameId | int(10) unsigned | NO | | NULL | | > | DeltaSeq | smallint(5) unsigned | YES | | 0 | | > | MarkId | int(10) unsigned | YES | | 0 | | > | LStat | tinyblob | NO | | NULL | | > | MD5 | tinyblob | YES | | NULL | | > +------------+----------------------+------+-----+---------+----------------+ > 9 rows in set (0.01 sec) > > Any idea what I am doing wrong here? > > Thanks > > George
Hmmm, I believe the correct syntax is: CREATE INDEX PathId_JobId_FileNameId_FileIndex ON File(PathId, JobId, FilenameId, FileIndex); -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/d/optout.
