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 -- 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.
