# Mysqld error and Avant fax **URL:** \ **Category:** OpenEMR Development\ **Created:** [June 10, 2009, 11:48pm UTC](https://community.open-emr.org/t/mysqld-error-and-avant-fax/6024 "2009-06-10T23:48:36Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\ **Post date:** [June 10, 2009, 11:48pm UTC](https://community.open-emr.org/t/mysqld-error-and-avant-fax/6024/1 "2009-06-10T23:48:36Z")
**[omo66](https://sourceforge.net/u/omo66/)** wrote on [Wednesday, June 10, 2009](https://sourceforge.net/p/openemr/discussion/202506/thread/6d7786e2/#c3ec): I have Avantfax/hylax fax installed both on same box along with openemr. The fax works fine sending and receiving including faxing scripts. I have noticed a sporadic very annoying mysqld error occurring randomly but delayed ~40-60 minutes after any fax activity. It results in database error: “Check that Mysqld is running. Error could not connect with Server.” EMR will down until I restart httpd. SYSTEM: Fedora9, Mysql l5 Apache 2 I have looked inside logs mysqld see below: Any idea? -------------------------------------------------------------------------------- 090403 07:52:17  mysqld started 090403  7:52:17 [Warning] option ‘max\_join\_size’: unsigned value 18446744073709551615 adjusted to 4294967295 090403  7:52:17 [Warning] option ‘max\_join\_size’: unsigned value 18446744073709551615 adjusted to 4294967295 InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 090403  7:52:17  InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait… 090403  7:52:17  InnoDB: Log file ./ib\_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib\_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait… 090403  7:52:17  InnoDB: Log file ./ib\_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib\_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait… InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 090403  7:52:18  InnoDB: Started; log sequence number 0 0 090403  7:52:18 [Note] /usr/libexec/mysqld: ready for connections. Version: ‘5.0.77’  socket: ‘/var/lib/mysql/mysql.sock’  port: 3306  Source distribution 090404  1:07:42 [Note] /usr/libexec/mysqld: Normal shutdown 090404  1:07:42  InnoDB: Starting shutdown… 090404  1:07:43  InnoDB: Shutdown completed; log sequence number 0 43655 090404  1:07:43 [Note] /usr/libexec/mysqld: Shutdown complete 090404 01:07:43  mysqld ended 090404 01:08:46  mysqld started 090404  1:08:46 [Warning] option ‘max\_join\_size’: unsigned value 18446744073709551615 adjusted to 4294967295 090404  1:08:46 [Warning] option ‘max\_join\_size’: unsigned value 18446744073709551615 adjusted to 4294967295 090404  1:08:47  InnoDB: Started; log sequence number 0 43655 090404  1:08:47 [Note] /usr/libexec/mysqld: ready for connections. Version: ‘5.0.77’  socket: ‘/var/lib/mysql/mysql.sock’  port: 3306  Source distribution 090404  1:30:36 [Note] /usr/libexec/mysqld: Normal shutdown 090404  1:30:36  InnoDB: Starting shutdown… 090404  1:30:37  InnoDB: Shutdown completed; log sequence number 0 43665 090404  1:30:37 [Note] /usr/libexec/mysqld: Shutdown complete 090404 01:30:37  mysqld ended 090411 08:13:12  mysqld started 090411  8:13:12 [Warning] option ‘max\_join\_size’: unsigned value 18446744073709551615 adjusted to 4294967295 090411  8:13:12 [Warning] option ‘max\_join\_size’: unsigned value 18446744073709551615 adjusted to 4294967295 090411  8:13:13  InnoDB: Started; log sequence number 0 43665 090411  8:13:13 [Note] /usr/libexec/mysqld: ready for connections. Version: ‘5.0.77’  socket: ‘/var/lib/mysql/mysql.sock’  port: 3306  Source distribution 090411 10:35:34 [Note] /usr/libexec/mysqld: Normal shutdown 090411 10:35:34  InnoDB: Starting shutdown… 090411 10:35:34  InnoDB: Shutdown completed; log sequence number 0 43665 090411 10:35:34 [Note] /usr/libexec/mysqld: Shutdown complete 090411 10:35:34  mysqld ended 090428 20:47:12  mysqld started 090428 20:47:12 [Warning] option ‘max\_join\_size’: unsigned value 18446744073709551615 adjusted to 4294967295 090428 20:47:12 [Warning] option ‘max\_join\_size’: unsigned value 18446744073709551615 adjusted to 4294967295 090428 20:47:12  InnoDB: Started; log sequence number 0 43665 090428 20:47:12 [Note] /usr/libexec/mysqld: ready for connections. Version: ‘5.0.77’  socket: ‘/var/lib/mysql/mysql.sock’  port: 3306  Source distribution 090428 21:34:04 [Note] /usr/libexec/mysqld: Normal shutdown 090428 21:34:04  InnoDB: Starting shutdown… 090428 21:34:05  InnoDB: Shutdown completed; log sequence number 0 43665 090428 21:34:05 [Note] /usr/libexec/mysqld: Shutdown complete 090428 21:34:05  mysqld ended 090428 21:35:10  mysqld started 090428 21:35:11 [Warning] option ‘max\_join\_size’: unsigned value 18446744073709551615 adjusted to 4294967295 090428 21:35:11 [Warning] option ‘max\_join\_size’: unsigned value 18446744073709551615 adjusted to 4294967295 090428 21:35:11  InnoDB: Started; log sequence number 0 43665 090428 21:35:11 [Note] /usr/libexec/mysqld: ready for connections. Version: ‘5.0.77’  socket: ‘/var/lib/mysql/mysql.sock’  port: 3306  Source distribution 090428 23:22:32 [Note] /usr/libexec/mysqld: Normal shutdown 090428 23:22:32  InnoDB: Starting shutdown… 090428 23:22:32  InnoDB: Shutdown completed; log sequence number 0 43665 090428 23:22:32 [Note] /usr/libexec/mysqld: Shutdown complete 090428 23:22:32  mysqld ended 090428 23:22:33  mysqld started 090428 23:22:33 [Warning] option ‘max\_join\_size’: unsigned value 18446744073709551615 adjusted to 4294967295 090428 23:22:33 [Warning] option ‘max\_join\_size’: unsigned value 18446744073709551615 adjusted to 4294967295 090428 23:22:33  InnoDB: Started; log sequence number 0 43665 090428 23:22:33 [Note] /usr/libexec/mysqld: ready for connections. Version: ‘5.0.77’  socket: ‘/var/lib/mysql/mysql.sock’  port: 3306  Source distribution 090429  0:07:26 [Note] /usr/libexec/mysqld: Normal shutdown 090429  0:07:26  InnoDB: Starting shutdown… 090429  0:07:27  InnoDB: Shutdown completed; log sequence number 0 43665 090429  0:07:27 [Note] /usr/libexec/mysqld: Shutdown complete 090429 00:07:27  mysqld ended 090503 11:45:49  mysqld started 090503 11:45:49 [Warning] option ‘max\_join\_size’: unsigned value 18446744073709551615 adjusted to 4294967295 090503 11:45:49 [Warning] option ‘max\_join\_size’: unsigned value 18446744073709551615 adjusted to 4294967295 090503 11:45:49  InnoDB: Started; log sequence number 0 43665 090503 11:45:50 [Note] /usr/libexec/mysqld: ready for connections. Version: ‘5.0.77’  socket: ‘/var/lib/mysql/mysql.sock’  port: 3306  Source distribution 090503 11:46:54 [Note] /usr/libexec/mysqld: Normal shutdown 090503 11:46:54  InnoDB: Starting shutdown… 090503 11:46:55  InnoDB: Shutdown completed; log sequence number 0 43665 090503 11:46:55 [Note] /usr/libexec/mysqld: Shutdown complete 090503 11:46:55  mysqld ended 090503 11:48:36  mysqld started 090503 11:48:36 [Warning] option ‘max\_join\_size’: unsigned value 18446744073709551615 adjusted to 4294967295 090503 11:48:36 [Warning] option ‘max\_join\_size’: unsigned value 18446744073709551615 adjusted to 4294967295 090503 11:48:36  InnoDB: Started; log sequence number 0 43665 090503 11:48:36 [Note] /usr/libexec/mysqld: ready for connections. Version: ‘5.0.77’  socket: ‘/var/lib/mysql/mysql.sock’  port: 3306  Source distribution 090503 11:49:56 [Note] /usr/libexec/mysqld: Normal shutdown 090503 11:49:56  InnoDB: Starting shutdown… 090503 11:49:56  InnoDB: Shutdown completed; log sequence number 0 43665 090503 11:49:56 [Note] /usr/libexec/mysqld: Shutdown complete 090503 11:49:56  mysqld ended 090503 11:51:10  mysqld started 090503 11:51:10 [Warning] option ‘max\_join\_size’: unsigned value 18446744073709551615 adjusted to 4294967295 090503 11:51:10 [Warning] option ‘max\_join\_size’: unsigned value 18446744073709551615 adjusted to 4294967295 090503 11:51:11  InnoDB: Started; log sequence number 0 43665 090503 11:51:11 [Note] /usr/libexec/mysqld: ready for connections. Version: ‘5.0.77’  socket: ‘/var/lib/mysql/mysql.sock’  port: 3306  Source distribution 090510 21:59:56 [Note] /usr/libexec/mysqld: Normal shutdown 090510 21:59:56  InnoDB: Starting shutdown… 090510 21:59:57  InnoDB: Shutdown completed; log sequence number 0 51974 090510 21:59:57 [Note] /usr/libexec/mysqld: Shutdown complete 090510 21:59:57  mysqld ended 090510 22:00:59  mysqld started 090510 22:01:00 [Warning] option ‘max\_join\_size’: unsigned value 18446744073709551615 adjusted to 4294967295 090510 22:01:00 [Warning] option ‘max\_join\_size’: unsigned value 18446744073709551615 adjusted to 4294967295 090510 22:01:00  InnoDB: Started; log sequence number 0 51974 090510 22:01:00 [Note] /usr/libexec/mysqld: ready for connections. Version: ‘5.0.77’  socket: ‘/var/lib/mysql/mysql.sock’  port: 3306  Source distribution 090510 22:09:59 [Note] /usr/libexec/mysqld: Normal shutdown 090510 22:09:59  InnoDB: Starting shutdown… 090510 22:10:00  InnoDB: Shutdown completed; log sequence number 0 51974 090510 22:10:00 [Note] /usr/libexec/mysqld: Shutdown complete 090510 22:10:00  mysqld ended 090510 22:10:59  mysqld started 090510 22:10:59 [Warning] option ‘max\_join\_size’: unsigned value 18446744073709551615 adjusted to 4294967295 090510 22:10:59 [Warning] option ‘max\_join\_size’: unsigned value 18446744073709551615 adjusted to 4294967295 090510 22:11:00  InnoDB: Started; log sequence number 0 51974 090510 22:11:00 [Note] /usr/libexec/mysqld: ready for connections. Version: ‘5.0.77’  socket: ‘/var/lib/mysql/mysql.sock’  port: 3306  Source distribution 090512 07:51:44  mysqld started 090512  7:51:44 [Warning] option ‘max\_join\_size’: unsigned value 18446744073709551615 adjusted to 4294967295 090512  7:51:44 [Warning] option ‘max\_join\_size’: unsigned value 18446744073709551615 adjusted to 4294967295 090512  7:51:45  InnoDB: Started; log sequence number 0 51974 090512  7:51:45 [Note] /usr/libexec/mysqld: ready for connections. Version: ‘5.0.77’  socket: ‘/var/lib/mysql/mysql.sock’  port: 3306  Source distribution 090515 15:10:39 [Note] /usr/libexec/mysqld: Normal shutdown 090515 15:10:40  InnoDB: Starting shutdown… 090515 15:10:41  InnoDB: Shutdown completed; log sequence number 0 51984 090515 15:10:41 [Note] /usr/libexec/mysqld: Shutdown complete 090515 15:10:41  mysqld ended 090515 15:11:49  mysqld started 090515 15:11:49 [Warning] option ‘max\_join\_size’: unsigned value 18446744073709551615 adjusted to 4294967295 090515 15:11:49 [Warning] option ‘max\_join\_size’: unsigned value 18446744073709551615 adjusted to 4294967295 090515 15:11:50  InnoDB: Started; log sequence number 0 51984 090515 15:11:50 [Note] /usr/libexec/mysqld: ready for connections. Version: ‘5.0.77’  socket: ‘/var/lib/mysql/mysql.sock’  port: 3306  Source distribution 090517 10:29:42  mysqld started 090517 10:29:43 [Warning] option ‘max\_join\_size’: unsigned value 18446744073709551615 adjusted to 4294967295 090517 10:29:43 [Warning] option ‘max\_join\_size’: unsigned value 18446744073709551615 adjusted to 4294967295 090517 10:29:43  InnoDB: Started; log sequence number 0 51984 090517 10:29:43 [Note] /usr/libexec/mysqld: ready for connections. Version: ‘5.0.77’  socket: ‘/var/lib/mysql/mysql.sock’  port: 3306  Source distribution 090530 13:24:58 [Note] /usr/libexec/mysqld: Normal shutdown 090530 13:24:58  InnoDB: Starting shutdown… 090530 13:24:59  InnoDB: Shutdown completed; log sequence number 0 51994 090530 13:24:59 [Note] /usr/libexec/mysqld: Shutdown complete 090530 13:24:59  mysqld ended 090530 14:13:03  mysqld started 090530 14:13:04 [Warning] option ‘max\_join\_size’: unsigned value 18446744073709551615 adjusted to 4294967295 090530 14:13:04 [Warning] option ‘max\_join\_size’: unsigned value 18446744073709551615 adjusted to 4294967295 090530 14:13:04  InnoDB: Started; log sequence number 0 51994 090530 14:13:04 [Note] /usr/libexec/mysqld: ready for connections. Version: ‘5.0.77’  socket: ‘/var/lib/mysql/mysql.sock’  port: 3306  Source distribution