On Fri, Dec 29, 2017 at 6:11 PM Jörg Steffens <[email protected]> wrote:
> On 29.12.2017 at 16:46 wrote George Kontostanos: > > 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); > > > Yes, you are right. Unfortunately the process of creating HTML from a > Latex document do have some strange effects/errors, like adding an > underscore in same places. > > > > -- > Jörg Steffens [email protected] > Bareos GmbH & Co. KG Phone: +49 221 630693-91 > <+49%20221%2063069391> > http://www.bareos.com Fax: +49 221 630693-10 > <+49%20221%2063069310> > > Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRA 29646 > Komplementär: Bareos Verwaltungs-GmbH > Geschäftsführer: > S. Dühr, M. Außendorf, Jörg Steffens, P. Storz > > -- > You received this message because you are subscribed to a topic in the > Google Groups "bareos-users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/bareos-users/44lFovPMkJk/unsubscribe. > To unsubscribe from this group and all its topics, 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. > Cheers :) I understand, lets see how long will it take to alter the table, considering that it is around 130GB! Thanks George -- George Kontostanos NetActuate, Inc e: [email protected] p: +1 919 727 9999 (ext 3021) -- 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.
