MySQL Bugs: #4867: Access Violoations & Floating Point Errors

Bug #4867	Access Violoations & Floating Point Errors
Submitted:	3 Aug 2004 11:22	Modified:	1 Sep 2004 16:12
Reporter:	Khushil Dep	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Administrator	Severity:	S1 (Critical)
Version:	1.0.9	OS:	Windows (XP SP1)
Assigned to:	Michael G. Zinner	CPU Architecture:	Any

Description:
Having installed MySQL Administrator I managed to connect to my mysql database (4.0.20-log). When I try to view Health however I immediately get the following error:

Access violation at address 003A1625 in module 'libmysqladmin.dll'. Read of address 00000000

The application does not crash however and I can move through the TABS available under Health. However after a couple of seconds I get the following error which repeats every three seconds or so:

Invalid floating point operation.

How to repeat:
Clean install MySQL Administor and try it.

Suggested fix:
Unknown at present

Intrestingly I have just discovered that this behaviour is not apparent when connecting to the same version of MySQL running at home on my AthlonXP.

So it seems only to be apparent when connecting to the MySQL running on my Sun Sparc 20 at work.

I wonder if there is a bug in the Sparc port of MySQL?

The plot thickens . . .

So after about five minutes of monitoring and good response from MySQL Administrator I find the the following error message:

Access violation at address 77F57D85 in module 'ntdll.dll'. Write of address 00387066.

So to wash-up . . .

Connecting from Windows XP SP1 to a SunSPARC 20 running MySQL 4.0.20-log bring an immediate sequence of errors.

Connecting from Windows XP SP1 to a AthlonXP running Slackware 10 and MySQL 4.0.20-log bring no immediate errors but after five minutes we get the Access Violation error from ntdll.dll.

When I am at home and run the Linux version (glib 2.3) of MySQL Administrator and connect to localhost I get no problems.

Odd.

Thanks for your detailed report. We will look into this asap

Could you attach the output of SHOW VARIABLES; and SHOW STATUS; from the sun spark 20 to this bug report?

An easy was to do so is to install Query Browser 1.0.6, execute the commands, press right mousebutton on the resultset and select Export Resultset > Export As CVS File or  Export As Excel File.

Thanks a lot!

mysql> show status;
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    1
Current database: prism

+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| Aborted_clients          | 0     |
| Aborted_connects         | 0     |
| Bytes_received           | 46    |
| Bytes_sent               | 56    |
| Com_admin_commands       | 0     |
| Com_alter_table          | 0     |
| Com_analyze              | 0     |
| Com_backup_table         | 0     |
| Com_begin                | 0     |
| Com_change_db            | 0     |
| Com_change_master        | 0     |
| Com_check                | 0     |
| Com_commit               | 0     |
| Com_create_db            | 0     |
| Com_create_function      | 0     |
| Com_create_index         | 0     |
| Com_create_table         | 0     |
| Com_delete               | 0     |
| Com_delete_multi         | 0     |
| Com_drop_db              | 0     |
| Com_drop_function        | 0     |
| Com_drop_index           | 0     |
| Com_drop_table           | 0     |
| Com_flush                | 0     |
| Com_grant                | 0     |
| Com_ha_close             | 0     |
| Com_ha_open              | 0     |
| Com_ha_read              | 0     |
| Com_insert               | 0     |
| Com_insert_select        | 0     |
| Com_kill                 | 0     |
| Com_load                 | 0     |
| Com_load_master_data     | 0     |
| Com_load_master_table    | 0     |
| Com_lock_tables          | 0     |
| Com_optimize             | 0     |
| Com_purge                | 0     |
| Com_rename_table         | 0     |
| Com_repair               | 0     |
| Com_replace              | 0     |
| Com_replace_select       | 0     |
| Com_reset                | 0     |
| Com_restore_table        | 0     |
| Com_revoke               | 0     |
| Com_rollback             | 0     |
| Com_savepoint            | 0     |
| Com_select               | 0     |
| Com_set_option           | 0     |
| Com_show_binlog_events   | 0     |
| Com_show_binlogs         | 0     |
| Com_show_create          | 0     |
| Com_show_databases       | 0     |
| Com_show_fields          | 0     |
| Com_show_grants          | 0     |
| Com_show_keys            | 0     |
| Com_show_logs            | 0     |
| Com_show_master_status   | 0     |
| Com_show_new_master      | 0     |
| Com_show_open_tables     | 0     |
| Com_show_processlist     | 0     |
| Com_show_slave_hosts     | 0     |
| Com_show_slave_status    | 0     |
| Com_show_status          | 1     |
| Com_show_innodb_status   | 0     |
| Com_show_tables          | 0     |
| Com_show_variables       | 0     |
| Com_slave_start          | 0     |
| Com_slave_stop           | 0     |
| Com_truncate             | 0     |
| Com_unlock_tables        | 0     |
| Com_update               | 0     |
| Connections              | 2     |
| Created_tmp_disk_tables  | 0     |
| Created_tmp_tables       | 0     |
| Created_tmp_files        | 0     |
| Delayed_insert_threads   | 0     |
| Delayed_writes           | 0     |
| Delayed_errors           | 0     |
| Flush_commands           | 1     |
| Handler_commit           | 0     |
| Handler_delete           | 0     |
| Handler_read_first       | 1     |
| Handler_read_key         | 0     |
| Handler_read_next        | 1     |
| Handler_read_prev        | 0     |
| Handler_read_rnd         | 0     |
| Handler_read_rnd_next    | 23    |
| Handler_rollback         | 0     |
| Handler_update           | 0     |
| Handler_write            | 0     |
| Key_blocks_used          | 1     |
| Key_read_requests        | 2     |
| Key_reads                | 1     |
| Key_write_requests       | 0     |
| Key_writes               | 0     |
| Max_used_connections     | 0     |
| Not_flushed_key_blocks   | 0     |
| Not_flushed_delayed_rows | 0     |
| Open_tables              | 0     |
| Open_files               | 2     |
| Open_streams             | 0     |
| Opened_tables            | 6     |
| Questions                | 1     |
| Qcache_queries_in_cache  | 0     |
| Qcache_inserts           | 0     |
| Qcache_hits              | 0     |
| Qcache_lowmem_prunes     | 0     |
| Qcache_not_cached        | 0     |
| Qcache_free_memory       | 0     |
| Qcache_free_blocks       | 0     |
| Qcache_total_blocks      | 0     |
| Rpl_status               | NULL  |
| Select_full_join         | 0     |
| Select_full_range_join   | 0     |
| Select_range             | 0     |
| Select_range_check       | 0     |
| Select_scan              | 0     |
| Slave_open_temp_tables   | 0     |
| Slave_running            | OFF   |
| Slow_launch_threads      | 0     |
| Slow_queries             | 0     |
| Sort_merge_passes        | 0     |
| Sort_range               | 0     |
| Sort_rows                | 0     |
| Sort_scan                | 0     |
| Table_locks_immediate    | 6     |
| Table_locks_waited       | 0     |
| Threads_cached           | 0     |
| Threads_created          | 1     |
| Threads_connected        | 1     |
| Threads_running          | 1     |
| Uptime                   | 16    |
+--------------------------+-------+
132 rows in set (0.03 sec)

mysql> show variables;
ERROR 2013: Lost connection to MySQL server during query
mysql>

** Trying to work out why now **

I'm working with MySQL Administrator and if i try to access the Start up Variables this error comes up and puts the Start up Variables blank, then if i access the Service Control the error appears again but the screen with the configuration fields does come up..

Access violation at address 77F57D85 in module 'ntdll.dll'. Write of address
0040513E

Thanks.

It may be that my server setup maybe causing some problems. I intend to rebuild the SS20 and compile mysql from source and do a custom configuration instead of use the standard supplied my.cnf. I will post back if it makes a difference.

I wasn't able for to repeat with version 1.0.11.

Hi,

I got this error message too!

System:
AMD XP 2000+
1536 MB RAM
120 GB S-ATA Samsung SP1213C

Windows XP Pro SP2
Apache 2.0.52
PHP 5.0.2
MySQL 4.1.7 (essential-win)
MySQL Administrator 1.0.14

The error occures after I've edited the my.ini:
Adding of "default-collation=latin1_german1_ci"
after "default-character-set=latin1"

Now on every start of the mysql service via the Administrator this error messages occures!

Deleting of this line DOESN'T "heal" this error!

Dirk

I also was getting this same type of error (memory address different).  I found that it was not my MySQL server causing the problem, but my Apache server was the problem.  I was trying to copy a website over to the Apache web directory.  When I did I got the error (access violation in module 'ntdll.dll').  I shut down the Apache server, copied my files then restarted the server without any problems.

Hope this helps someone.