On Friday, December 29, 2017 at 6:45:51 PM UTC+2, George Kontostanos wrote: > 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 > > http://www.bareos.com Fax: +49 221 630693-10 > > > > 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)
After 2 days of using 16.2.7 I had to revert back to 16.2.4. But the problem apparently was with the index. I was getting "mysql Waiting for table metadata lock" and no job was being processed. After deleting the index things are back to normal. Any idea why? Thanks -- 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.
