From: Phil S. <al...@ca...> - 2004-02-10 18:37:56
|
babylon5-dir: RunBefore: /opt/mysql/bin/mysqldump: Error 1030: Got error 127 +from table handler when dumping table 'File' at row: 578963 babylon5-dir: Start Backup JobId 249, Job=Catalog_Save.2004-02-10_02.45.00 babylon5-dir: Bacula 1.32f-3 (12Jan04): 10-Feb-2004 02:46 I don't know what caused this error, so I ran manual optimize operations on all the tables. That led to the following: mysql> optimize table File; +-------------+----------+----------+-----------------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +-------------+----------+----------+-----------------------------------------------------------------+ | bacula.File | optimize | info | Wrong bytesec: 0-0-0 at 145808388; Skipped | | bacula.File | optimize | info | Found wrong stored record at 145812476 | | bacula.File | optimize | warning | Duplicate key for record at 59635108 against record at 59585544 | | bacula.File | optimize | warning | Duplicate key for record at 59635232 against record at 59585668 | | bacula.File | optimize | warning | Duplicate key for record at 59635356 against record at 59585792 | | bacula.File | optimize | warning | Duplicate key for record at 59635484 against record at 59585920 | | bacula.File | optimize | warning | Duplicate key for record at 59635608 against record at 59586044 | | bacula.File | optimize | warning | Duplicate key for record at 59635736 against record at 59586172 | | bacula.File | optimize | warning | Duplicate key for record at 59635860 against record at 59586296 | | bacula.File | optimize | warning | Duplicate key for record at 59635988 against record at 59586424 | | bacula.File | optimize | warning | Duplicate key for record at 59636112 against record at 59586548 | | bacula.File | optimize | warning | Duplicate key for record at 59636236 against record at 59586672 | | bacula.File | optimize | warning | Duplicate key for record at 59636360 against record at 59586796 | | bacula.File | optimize | warning | Duplicate key for record at 59636488 against record at 59586924 | | bacula.File | optimize | warning | Duplicate key for record at 59636612 against record at 59587048 | | bacula.File | optimize | warning | Duplicate key for record at 59636736 against record at 59587172 | | bacula.File | optimize | warning | Duplicate key for record at 59636864 against record at 59587300 | | bacula.File | optimize | warning | Duplicate key for record at 59636992 against record at 59587428 | | bacula.File | optimize | warning | Duplicate key for record at 59637120 against record at 59587556 | | bacula.File | optimize | warning | Duplicate key for record at 59637248 against record at 59587684 | | bacula.File | optimize | warning | Duplicate key for record at 59637372 against record at 59587808 | | bacula.File | optimize | warning | Duplicate key for record at 59637500 against record at 59587936 | | bacula.File | optimize | warning | Duplicate key for record at 59637624 against record at 59588060 | | bacula.File | optimize | warning | Duplicate key for record at 59637748 against record at 59588184 | | bacula.File | optimize | warning | Duplicate key for record at 59637872 against record at 59588308 | | bacula.File | optimize | warning | Duplicate key for record at 59638000 against record at 59588436 | | bacula.File | optimize | warning | Duplicate key for record at 59638124 against record at 59588560 | | bacula.File | optimize | warning | Duplicate key for record at 59638248 against record at 59588684 | | bacula.File | optimize | warning | Duplicate key for record at 59638372 against record at 59588808 | | bacula.File | optimize | warning | Duplicate key for record at 59638500 against record at 59588936 | | bacula.File | optimize | warning | Duplicate key for record at 59638624 against record at 59589060 | | bacula.File | optimize | warning | Number of rows changed from 593829 to 593800 | | bacula.File | optimize | status | OK | +-------------+----------+----------+-----------------------------------------------------------------+ 33 rows in set (2 min 11.54 sec) I don't know whether this, for Bacula, is serious or not. -- .********* Fight Back! It may not be just YOUR life at risk. *********. : phil stracchino : unix ronin : renaissance man : mystic zen biker geek : : al...@ca...|ala...@ea...|al...@no... : : 2000 CBR929RR, 1991 VFR750F3 (foully murdered), 1986 VF500F (sold) : : Linux Now! ...Because friends don't let friends use Microsoft. : |
From: Kern S. <ke...@si...> - 2004-02-27 06:30:31
|
I recommend that you use dbcheck to clean this up. On Tue, 2004-02-10 at 19:37, Phil Stracchino wrote: > babylon5-dir: RunBefore: /opt/mysql/bin/mysqldump: Error 1030: Got error 127 > +from table handler when dumping table 'File' at row: 578963 > babylon5-dir: Start Backup JobId 249, Job=Catalog_Save.2004-02-10_02.45.00 > babylon5-dir: Bacula 1.32f-3 (12Jan04): 10-Feb-2004 02:46 > > I don't know what caused this error, so I ran manual optimize operations > on all the tables. That led to the following: > > mysql> optimize table File; > +-------------+----------+----------+-----------------------------------------------------------------+ > | Table | Op | Msg_type | Msg_text | > +-------------+----------+----------+-----------------------------------------------------------------+ > | bacula.File | optimize | info | Wrong bytesec: 0-0-0 at 145808388; Skipped | > | bacula.File | optimize | info | Found wrong stored record at 145812476 | > | bacula.File | optimize | warning | Duplicate key for record at 59635108 against record at 59585544 | > | bacula.File | optimize | warning | Duplicate key for record at 59635232 against record at 59585668 | > | bacula.File | optimize | warning | Duplicate key for record at 59635356 against record at 59585792 | > | bacula.File | optimize | warning | Duplicate key for record at 59635484 against record at 59585920 | > | bacula.File | optimize | warning | Duplicate key for record at 59635608 against record at 59586044 | > | bacula.File | optimize | warning | Duplicate key for record at 59635736 against record at 59586172 | > | bacula.File | optimize | warning | Duplicate key for record at 59635860 against record at 59586296 | > | bacula.File | optimize | warning | Duplicate key for record at 59635988 against record at 59586424 | > | bacula.File | optimize | warning | Duplicate key for record at 59636112 against record at 59586548 | > | bacula.File | optimize | warning | Duplicate key for record at 59636236 against record at 59586672 | > | bacula.File | optimize | warning | Duplicate key for record at 59636360 against record at 59586796 | > | bacula.File | optimize | warning | Duplicate key for record at 59636488 against record at 59586924 | > | bacula.File | optimize | warning | Duplicate key for record at 59636612 against record at 59587048 | > | bacula.File | optimize | warning | Duplicate key for record at 59636736 against record at 59587172 | > | bacula.File | optimize | warning | Duplicate key for record at 59636864 against record at 59587300 | > | bacula.File | optimize | warning | Duplicate key for record at 59636992 against record at 59587428 | > | bacula.File | optimize | warning | Duplicate key for record at 59637120 against record at 59587556 | > | bacula.File | optimize | warning | Duplicate key for record at 59637248 against record at 59587684 | > | bacula.File | optimize | warning | Duplicate key for record at 59637372 against record at 59587808 | > | bacula.File | optimize | warning | Duplicate key for record at 59637500 against record at 59587936 | > | bacula.File | optimize | warning | Duplicate key for record at 59637624 against record at 59588060 | > | bacula.File | optimize | warning | Duplicate key for record at 59637748 against record at 59588184 | > | bacula.File | optimize | warning | Duplicate key for record at 59637872 against record at 59588308 | > | bacula.File | optimize | warning | Duplicate key for record at 59638000 against record at 59588436 | > | bacula.File | optimize | warning | Duplicate key for record at 59638124 against record at 59588560 | > | bacula.File | optimize | warning | Duplicate key for record at 59638248 against record at 59588684 | > | bacula.File | optimize | warning | Duplicate key for record at 59638372 against record at 59588808 | > | bacula.File | optimize | warning | Duplicate key for record at 59638500 against record at 59588936 | > | bacula.File | optimize | warning | Duplicate key for record at 59638624 against record at 59589060 | > | bacula.File | optimize | warning | Number of rows changed from 593829 to 593800 | > | bacula.File | optimize | status | OK | > +-------------+----------+----------+-----------------------------------------------------------------+ > 33 rows in set (2 min 11.54 sec) > > > I don't know whether this, for Bacula, is serious or not. > |
From: Phil S. <al...@ca...> - 2004-02-27 14:36:13
|
On Thu, Feb 26, 2004 at 02:58:30PM +0100, Kern Sibbald wrote: > I recommend that you use dbcheck to clean this up. I ran dbcheck on it last night and it found a lot of orphaned Paths and Filenames, but no duplicates. -- .********* Fight Back! It may not be just YOUR life at risk. *********. : phil stracchino : unix ronin : renaissance man : mystic zen biker geek : : al...@ca...|ala...@ea...|al...@no... : : 2000 CBR929RR, 1991 VFR750F3 (foully murdered), 1986 VF500F (sold) : : Linux Now! ...Because friends don't let friends use Microsoft. : |
From: Dan L. <da...@la...> - 2004-02-27 14:40:21
|
On Fri, 27 Feb 2004, Phil Stracchino wrote: > On Thu, Feb 26, 2004 at 02:58:30PM +0100, Kern Sibbald wrote: > > I recommend that you use dbcheck to clean this up. > > I ran dbcheck on it last night and it found a lot of orphaned Paths and > Filenames, but no duplicates. For what it's worth, the PostgreSQL catalog contains foreign keys which will ensure no orphans will ever exist. -- Dan Langille - BSDCan: http://www.bsdcan.org/ |
From: Kern S. <ke...@si...> - 2004-02-27 15:24:56
|
On Fri, 2004-02-27 at 15:32, Phil Stracchino wrote: > On Thu, Feb 26, 2004 at 02:58:30PM +0100, Kern Sibbald wrote: > > I recommend that you use dbcheck to clean this up. > > I ran dbcheck on it last night and it found a lot of orphaned Paths and > Filenames, but no duplicates. First make a copy of your database, then turn on modification in dbcheck, and let it get rid of the orphans. After see if MySQL still complains about duplicates. Regards, Kern |
From: Phil S. <al...@ca...> - 2004-02-27 15:32:17
|
On Fri, Feb 27, 2004 at 04:22:02PM +0100, Kern Sibbald wrote: > On Fri, 2004-02-27 at 15:32, Phil Stracchino wrote: > > On Thu, Feb 26, 2004 at 02:58:30PM +0100, Kern Sibbald wrote: > > > I recommend that you use dbcheck to clean this up. > > > > I ran dbcheck on it last night and it found a lot of orphaned Paths and > > Filenames, but no duplicates. > > First make a copy of your database, then turn on modification in > dbcheck, and let it get rid of the orphans. After see if MySQL still > complains about duplicates. I already did. It was only that one Catalog job that complained about duplicates. -- .********* Fight Back! It may not be just YOUR life at risk. *********. : phil stracchino : unix ronin : renaissance man : mystic zen biker geek : : al...@ca...|ala...@ea...|al...@no... : : 2000 CBR929RR, 1991 VFR750F3 (foully murdered), 1986 VF500F (sold) : : Linux Now! ...Because friends don't let friends use Microsoft. : |
From: Alejandro A. <ale...@te...> - 2004-02-27 11:15:07
|
I have some problems to allow bacula server to get data from bacula client. The logs shows than the password, and the communication are ok, but when i try to run the job that uses this remote procedure, i get inmediatly a message, and the backup aborts Here are some information about the configuration and logs: ---------------------------------------------------------------------------- --------- Bacula server (Linux i386/gentoo/Bacula1.29): Command: # console/run/job Logs: (messages) 27-Feb-2004 12:28 poe-dir: Last FULL backup time not found. Doing FULL backup. 27-Feb-2004 12:28 poe-dir: Start Backup JobId 21, Job=KafkaDB.2004-02-27_12.28.21 27-Feb-2004 12:28 kafka-fd: KafkaDB.2004-02-27_12.28.21 Fatal error: Bad storage command: storage address=localhost port=9103 27-Feb-2004 12:28 poe-dir: Fatal Error at getmsg.c:227 because: <filed: Socket error from Filed on Storage command: ERR=No data available 27-Feb-2004 12:28 poe-dir: KafkaDB.2004-02-27_12.28.21 Error: Bacula 1.29 (22Jan03): 27-Feb-2004 12:28 JobId: 21 Job: KafkaDB.2004-02-27_12.28.21 FileSet: KafkaDB Backup Level: Full Client: kafka-fd Start time: 27-Feb-2004 12:28 End time: 27-Feb-2004 12:28 Files Written: 0 Bytes Written: 0 Rate: 0.0 KB/s Software Compression: None Termination: *** Backup Error *** ---------------------------------------------------------------------------- --------- Bacula client (Linux i386/redhay7.3/Bacula1.33.3) Command: # sbin/bacula-fd -c bacula-fd.conf -v -f -d10 Logs: kafka-fd: filed.c:239 filed: listening on port 9102 kafka-fd: job.c:520 include file: M /db_sql ---------------------------------------------------------------------------- --------- I'm triying to backup the directory /db_sql in client, and the definition of the location are in the server configuration: FileSet { Name = "KafkaDB" Include = signature=MD5 { /db_sql } Exclude = { } } i have read the documentation and i haven't found any mistake in mi configuration. Maybe something in relation with the different versions in server and client? Something wrong in the FileSet definition? Thanks in advance! |
From: Kern S. <ke...@si...> - 2004-02-27 23:02:55
|
It appears that you are running on a pretty old server and trying to use it with a newer client. That won't work. The versions of all your Bacula components much match. On Fri, 2004-02-27 at 12:01, Alejandro Alfonso wrote: > I have some problems to allow bacula server to get data from bacula client. > The logs shows than the password, and the communication are ok, but when i > try to run the job that uses this remote procedure, i get inmediatly a > message, and the backup aborts > > Here are some information about the configuration and logs: > > ---------------------------------------------------------------------------- > --------- > Bacula server (Linux i386/gentoo/Bacula1.29): > > Command: > # console/run/job > > Logs: (messages) > 27-Feb-2004 12:28 poe-dir: Last FULL backup time not found. Doing FULL > backup. > 27-Feb-2004 12:28 poe-dir: Start Backup JobId 21, > Job=KafkaDB.2004-02-27_12.28.21 > 27-Feb-2004 12:28 kafka-fd: KafkaDB.2004-02-27_12.28.21 Fatal error: Bad > storage command: storage address=localhost port=9103 > 27-Feb-2004 12:28 poe-dir: Fatal Error at getmsg.c:227 because: > <filed: Socket error from Filed on Storage command: ERR=No data available > 27-Feb-2004 12:28 poe-dir: KafkaDB.2004-02-27_12.28.21 Error: Bacula 1.29 > (22Jan03): 27-Feb-2004 12:28 > JobId: 21 > Job: KafkaDB.2004-02-27_12.28.21 > FileSet: KafkaDB > Backup Level: Full > Client: kafka-fd > Start time: 27-Feb-2004 12:28 > End time: 27-Feb-2004 12:28 > Files Written: 0 > Bytes Written: 0 > Rate: 0.0 KB/s > Software Compression: None > Termination: *** Backup Error *** > ---------------------------------------------------------------------------- > --------- > Bacula client (Linux i386/redhay7.3/Bacula1.33.3) > > Command: > # sbin/bacula-fd -c bacula-fd.conf -v -f -d10 > > Logs: > kafka-fd: filed.c:239 filed: listening on port 9102 > kafka-fd: job.c:520 include file: M /db_sql > ---------------------------------------------------------------------------- > --------- > I'm triying to backup the directory /db_sql in client, and the definition of > the location are in the server configuration: > > FileSet { > Name = "KafkaDB" > Include = signature=MD5 { > /db_sql > } > Exclude = { } > } > > i have read the documentation and i haven't found any mistake in mi > configuration. Maybe something in relation with the different versions in > server and client? Something wrong in the FileSet definition? > > Thanks in advance! > > > > ------------------------------------------------------- > SF.Net is sponsored by: Speed Start Your Linux Apps Now. > Build and deploy apps & Web services for Linux with > a free DVD software kit from IBM. Click Now! > http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click > _______________________________________________ > Bacula-users mailing list > Bac...@li... > https://lists.sourceforge.net/lists/listinfo/bacula-users |