|
|
| Subject: | Problem with zenbackup |
| Author: | [Not Specified] |
| Posted: | 2016-09-05 10:30 |
Hi,
I'm trying to make a backup zenoss and keep getting the error -
/opt/zenoss/bin/zenbackup -v10
DEBUG:zenbackup:Use /tmp/tmpB9jsPY/zenbackup as a staging directory for the backup
INFO:zenbackup:Getting ZEP dbname, user, password, port from configuration files.
DEBUG:CoreBackup:Writing MySQL credentials to /tmp/tmpB9jsPY/zenbackup/backup.settings
INFO:CoreBackup:Backing up the events database.
DEBUG:CoreBackup:mysqldump -uzenoss --single-transaction --routines ******** zenoss_zep
INFO:CoreBackup:Backing up event indexes.
INFO:CoreBackup:Backing up event indexes completed.
INFO:zenbackup:Backup of events database completed in 4 seconds.
INFO:CoreBackup:Backing up config files.
INFO:CoreBackup:Backup of config files completed.
INFO:CoreBackup:Backing up the ZODB.
DEBUG:CoreBackup:mysqldump -uzenoss --single-transaction --routines ******** zodb
mysqldump: Error 1194: Table 'connection_info' is marked as crashed and should be repaired when dumping table `connection_info` at row: 156116
Although such table not exists. any ideas what the problem is
| Subject: | Did you try repairing? |
| Author: | Jay Stanley |
| Posted: | 2016-09-06 08:18 |
Did you try repairing
REPAIR TABLE `tablename`;
| Subject: | Yes, I tried. as I wrote - |
| Author: | [Not Specified] |
| Posted: | 2016-09-06 08:21 |
Yes, I tried. as I wrote - such table not exists
mysql> repair TABLE connection_info;
ERROR 1046 (3D000): No database selected
| Subject: | No, that means you didn't |
| Author: | Jay Stanley |
| Posted: | 2016-09-06 15:27 |
No, that means you didn't select the database before running the repair.
| Subject: | mysql> use connection_info; |
| Author: | [Not Specified] |
| Posted: | 2016-09-06 15:32 |
mysql> use connection_info;
ERROR 1049 (42000): Unknown database 'connection_info'
| Subject: | That is the table name, not |
| Author: | Jay Stanley |
| Posted: | 2016-09-06 15:33 |
That is the table name, not the database name...
| Subject: | Since your output says it is |
| Author: | Jay Stanley |
| Posted: | 2016-09-06 15:37 |
Since your output says it is backing up ZODB, I would start there. But both zodb and zodb_session haveconnection_info tables.
And, I don't see a point to backing up the zodb_session db.
| Subject: | That's right. I think |
| Author: | [Not Specified] |
| Posted: | 2016-09-06 15:50 |
That'sright. I think connection_info is database))
mysql> use zodb;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> check table connection_info;
+----------------------+-------+----------+-----------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+----------------------+-------+----------+-----------------------------------------------------------+
| zodb.connection_info | check | warning | 10 clients are using or haven't closed the table properly |
| zodb.connection_info | check | error | Wrong bytesec: 0-0-0 at linkstart: 335058584 |
| zodb.connection_info | check | error | Corrupt
And repair:
mysql> repair table connection_info;
+----------------------+--------+----------+--------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+----------------------+--------+----------+--------------------------------------------------+
| zodb.connection_info | repair | info | Wrong bytesec: 0- 0- 0 at 335058584; Skipped |
| zodb.connection_info | repair | warning | Number of rows changed from 189672 to 189663 |
| zodb.connection_info | repair | status | OK
it's working now. Thanks a lot!
| < |
Previous Zenoss 4.2.5 SNMP trap event cannot be display |
Next How to export device configuration from one zenoss 5 instance to another. |
> |