On Sun, Dec 31, 2017 at 2:24 PM George Kontostanos < [email protected]> wrote:
> 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 > <+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 <(919)%20727-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 > Hello again and happy new year! I am really puzzled by the fact that adding a single INDEX would cause such a disaster. So, for 2 days no backups were able to complete. We had CPU and load average running very high on the database server, Percona 5.6 with SSD's in RAID1 and 92GB of RAM. The processlists were all waiting for table metadata lock. I would really appreciate some input here. 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.
