omo66 wrote on Wednesday, June 10, 2009:
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