[Bacula-users] MySQL server has gone away during catalog backup
My catalog backup failed like this last night. The odd thing is that immediately afterwards, I have a second catalog backup running to tape, and that one worked fine. A resource problem perhaps? Any ideas what to check? 21-Jun 08:19 packrat-dir: BeforeJob: run command /etc/bacula/make_catalog_backup bacula bacula 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `File` at row: 3434402 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006) 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: mysqldump: Couldn't execute 'show fields from `FileSet`': MySQL server has gone away (2006) 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006) 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: mysqldump: Couldn't execute 'show fields from `Filename`': MySQL server has gone away (2006) 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006) 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: mysqldump: Couldn't execute 'show fields from `Job`': MySQL server has gone away (2006) 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006) 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: mysqldump: Couldn't execute 'show fields from `JobMedia`': MySQL server has gone away (2006) 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006) 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: mysqldump: Couldn't execute 'show fields from `Location`': MySQL server has gone away (2006) 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006) 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: mysqldump: Couldn't execute 'show fields from `LocationLog`': MySQL server has gone away (2006) 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006) 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: mysqldump: Couldn't execute 'show fields from `Log`': MySQL server has gone away (2006) 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006) 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: mysqldump: Couldn't execute 'show fields from `Media`': MySQL server has gone away (2006) 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006) 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: mysqldump: Couldn't execute 'show fields from `MediaType`': MySQL server has gone away (2006) 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006) 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: mysqldump: Couldn't execute 'show fields from `Path`': MySQL server has gone away (2006) 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006) 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: mysqldump: Couldn't execute 'show fields from `Pool`': MySQL server has gone away (2006) 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006) 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: mysqldump: Couldn't execute 'show fields from `Status`': MySQL server has gone away (2006) 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006) 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: mysqldump: Couldn't execute 'show fields from `Storage`': MySQL server has gone away (2006) 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006) 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: mysqldump: Couldn't execute 'show fields from `UnsavedFiles`': MySQL server has gone away (2006) 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006) 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: mysqldump: Couldn't execute 'show fields from `Version`': MySQL server has gone away (2006) 21-Jun 08:22 packrat-dir: BeforeJob: mysqldump: mysqldump: Couldn't execute 'UNLOCK TABLES': MySQL server has gone away (2006) 21-Jun 08:22 packrat-dir:
Re: [Bacula-users] MySQL server has gone away during catalog backup
Jeff Dickens wrote: My catalog backup failed like this last night. The odd thing is that immediately afterwards, I have a second catalog backup running to tape, and that one worked fine. A resource problem perhaps? Any ideas what to check? Usually this is brought about by an upgrade from MySQL 4.x to 5.0, which changed the default timeout behavior. http://wiki.bacula.org/doku.php?id=faq#mysql_server_has_gone_away -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Senior Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8A3 8E39 29E3 E2E8 8CEC - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] MySQL server has gone away during catalog backup
# mysql -V mysql Ver 14.7 Distrib 4.1.20, for redhat-linux-gnu (i686) using readline 4.3 Frank Sweetser wrote: Jeff Dickens wrote: My catalog backup failed like this last night. The odd thing is that immediately afterwards, I have a second catalog backup running to tape, and that one worked fine. A resource problem perhaps? Any ideas what to check? Usually this is brought about by an upgrade from MySQL 4.x to 5.0, which changed the default timeout behavior. http://wiki.bacula.org/doku.php?id=faq#mysql_server_has_gone_away - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] MySQL server has gone away during catalog backup
Jeff Dickens wrote: # mysql -V mysql Ver 14.7 Distrib 4.1.20, for redhat-linux-gnu (i686) using readline 4.3 I'd still give the workaround on the wiki a shot, just to make sure. -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Senior Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8A3 8E39 29E3 E2E8 8CEC - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
