Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

OSCommerce Hangs Intermittently (CASH FOR ANSWERS!)


dwhoover

Recommended Posts

First, I am offering $100 for a quick solution to this problem, the first person to provide the diagnosis and a fix that works...gets the cash by PayPal, credit card, or however you want it!!!! :thumbsup:

 

Our web site, globalimagingsupply.com, becomes non-responsive intermittently, requiring a restart of MySQL and Apache (Windows 2003).

 

There is no pattern, no error messages (other than a VERY long wait for an error mesage to come up).

 

Maybe sessions? Database problems?

osCommerce MS2

SPPC incl. Specials By Category, Prices By Category

Vendors, Easy Populate, UPS XML, USPS Methods

Link to comment
Share on other sites

If it requires a restart of MySQL, it's likely a query. SHOW PROCESSLIST in a mysql client will give you the queries running. Take a look when it's hanging to see if it's a query.

 

http://dev.mysql.com/doc/refman/5.0/en/show-processlist.html

 

I assume you've checked MySQL and Apache error logs?

Contributions

 

Discount Coupon Codes

Donations

Link to comment
Share on other sites

How often does this happen?

How many products in your site? 6000+ or so?

I see that you have some rewrite going on. Wouldn't be suprised if it had something to do with that.

 

Has this always happened? Just recent? Any New Modifications?

Need Hosting? Just ask!

Link to comment
Share on other sites

If it requires a restart of MySQL, it's likely a query. SHOW PROCESSLIST in a mysql client will give you the queries running. Take a look when it's hanging to see if it's a query.

 

http://dev.mysql.com/doc/refman/5.0/en/show-processlist.html

 

I assume you've checked MySQL and Apache error logs?

 

 

I will check this out to see what the process list shows...good idea.

 

Thanks....

osCommerce MS2

SPPC incl. Specials By Category, Prices By Category

Vendors, Easy Populate, UPS XML, USPS Methods

Link to comment
Share on other sites

How often does this happen?

How many products in your site? 6000+ or so?

I see that you have some rewrite going on. Wouldn't be suprised if it had something to do with that.

 

Has this always happened? Just recent? Any New Modifications?

 

 

It happens about 20 times a day at its worst, and sometimes only 4 or 5 each day...

 

There are about 6000+, as you guessed!

 

There is re-writing going on...here is the relevent section from the Apache config:

 

Servername globalimagingsupply.com

RewriteEngine On

RewriteCond %{HTTP_HOST} !^www\.globalimagingsupply\.com [NC]

RewriteCond %{HTTP_HOST} !^$

RewriteRule ^/(.*) http://www.globalimagingsupply.com/$1 [L,R]

 

 

This began happening a few months ago...a few times a month, then its gotten progressively worse. No new Mods.

osCommerce MS2

SPPC incl. Specials By Category, Prices By Category

Vendors, Easy Populate, UPS XML, USPS Methods

Link to comment
Share on other sites

I just verified that it also does it when I try to access the admin page (which is SSL, and also re-written).

osCommerce MS2

SPPC incl. Specials By Category, Prices By Category

Vendors, Easy Populate, UPS XML, USPS Methods

Link to comment
Share on other sites

I will check this out to see what the process list shows...good idea.

 

Thanks....

 

 

Here is the outpu from show processlist

 

+-----+------+----------------+---------------------+---------+------+-------+--

----------------+

| Id | User | Host | db | Command | Time | State | I

nfo |

+-----+------+----------------+---------------------+---------+------+-------+--

----------------+

| 172 | root | localhost:1593 | globalimagingsupply | Sleep | 461 | | N

ULL |

| 173 | root | localhost:1595 | globalimagingsupply | Sleep | 456 | | N

ULL |

| 174 | root | localhost:1596 | globalimagingsupply | Sleep | 455 | | N

ULL |

| 175 | root | localhost:1602 | globalimagingsupply | Sleep | 449 | | N

ULL |

| 176 | root | localhost:1604 | globalimagingsupply | Sleep | 449 | | N

ULL |

| 180 | root | localhost:1624 | globalimagingsupply | Sleep | 387 | | N

ULL |

| 181 | root | localhost:1679 | NULL | Query | 0 | NULL | s

how processlist |

+-----+------+----------------+---------------------+---------+------+-------+--

----------------+

7 rows in set (0.01 sec)

 

Any thing out of the ordinary???

osCommerce MS2

SPPC incl. Specials By Category, Prices By Category

Vendors, Easy Populate, UPS XML, USPS Methods

Link to comment
Share on other sites

Here is the full output of the SHOW STATUS command:

 

mysql> show status

 

+--------------------------+-----------+

| Variable_name | Value |

+--------------------------+-----------+

| Aborted_clients | 0 |

| Aborted_connects | 0 |

| Binlog_cache_disk_use | 0 |

| Binlog_cache_use | 0 |

| Bytes_received | 2035125 |

| Bytes_sent | 5199700 |

| Com_admin_commands | 0 |

| Com_alter_db | 0 |

| Com_alter_table | 0 |

| Com_analyze | 0 |

| Com_backup_table | 0 |

| Com_begin | 0 |

| Com_change_db | 180 |

| Com_change_master | 0 |

| Com_check | 0 |

| Com_checksum | 0 |

| Com_commit | 0 |

| Com_create_db | 0 |

| Com_create_function | 0 |

| Com_create_index | 0 |

| Com_create_table | 0 |

| Com_dealloc_sql | 0 |

| Com_delete | 161 |

| Com_delete_multi | 0 |

| Com_do | 0 |

| Com_drop_db | 0 |

| Com_drop_function | 0 |

| Com_drop_index | 0 |

| Com_drop_table | 0 |

| Com_drop_user | 0 |

| Com_execute_sql | 0 |

| Com_flush | 0 |

| Com_grant | 0 |

| Com_ha_close | 0 |

| Com_ha_open | 0 |

| Com_ha_read | 0 |

| Com_help | 0 |

| Com_insert | 33 |

| 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_preload_keys | 0 |

| Com_prepare_sql | 0 |

| Com_purge | 0 |

| Com_purge_before_date | 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_revoke_all | 0 |

| Com_rollback | 0 |

| Com_savepoint | 0 |

| Com_select | 2061 |

| Com_set_option | 0 |

| Com_show_binlog_events | 0 |

| Com_show_binlogs | 0 |

| Com_show_charsets | 0 |

| Com_show_collations | 0 |

| Com_show_column_types | 0 |

| Com_show_create_db | 0 |

| Com_show_create_table | 0 |

| Com_show_databases | 0 |

| Com_show_errors | 0 |

| Com_show_fields | 0 |

| Com_show_grants | 0 |

| Com_show_innodb_status | 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_privileges | 0 |

| Com_show_processlist | 2 |

| Com_show_slave_hosts | 0 |

| Com_show_slave_status | 0 |

| Com_show_status | 2 |

| Com_show_storage_engines | 0 |

| Com_show_tables | 96 |

| Com_show_variables | 0 |

| Com_show_warnings | 0 |

| Com_slave_start | 0 |

| Com_slave_stop | 0 |

| Com_truncate | 0 |

| Com_unlock_tables | 0 |

| Com_update | 597 |

| Com_update_multi | 0 |

| Connections | 182 |

| Created_tmp_disk_tables | 0 |

| Created_tmp_files | 6435 |

| Created_tmp_tables | 267 |

| Delayed_errors | 0 |

| Delayed_insert_threads | 0 |

| Delayed_writes | 0 |

| Flush_commands | 1 |

| Handler_commit | 0 |

| Handler_delete | 0 |

| Handler_discover | 0 |

| Handler_read_first | 2143 |

| Handler_read_key | 954123 |

| Handler_read_next | 839458 |

| Handler_read_prev | 0 |

| Handler_read_rnd | 607 |

| Handler_read_rnd_next | 530924 |

| Handler_rollback | 174 |

| Handler_update | 68242 |

| Handler_write | 17901 |

| Key_blocks_not_flushed | 0 |

| Key_blocks_unused | 177155 |

| Key_blocks_used | 10 |

| Key_read_requests | 163 |

| Key_reads | 20 |

| Key_write_requests | 0 |

| Key_writes | 0 |

| Max_used_connections | 7 |

| Not_flushed_delayed_rows | 0 |

| Open_files | 58 |

| Open_streams | 0 |

| Open_tables | 107 |

| Opened_tables | 218 |

| Qcache_free_blocks | 39 |

| Qcache_free_memory | 132418896 |

| Qcache_hits | 8949 |

| Qcache_inserts | 1731 |

| Qcache_lowmem_prunes | 0 |

| Qcache_not_cached | 330 |

| Qcache_queries_in_cache | 651 |

| Qcache_total_blocks | 1376 |

| Questions | 12255 |

| Rpl_status | NULL |

| Select_full_join | 214 |

| Select_full_range_join | 0 |

| Select_range | 1 |

| Select_range_check | 0 |

| Select_scan | 1281 |

| Slave_open_temp_tables | 0 |

| Slave_running | OFF |

| Slow_launch_threads | 0 |

| Slow_queries | 0 |

| Sort_merge_passes | 0 |

| Sort_range | 27 |

| Sort_rows | 912 |

| Sort_scan | 289 |

| Table_locks_immediate | 13231 |

| Table_locks_waited | 0 |

| Threads_cached | 0 |

| Threads_connected | 7 |

| Threads_created | 181 |

| Threads_running | 1 |

| Uptime | 3507 |

+--------------------------+-----------+

156 rows in set (0.00 sec)

 

HELP!!!!!

 

mysql>

osCommerce MS2

SPPC incl. Specials By Category, Prices By Category

Vendors, Easy Populate, UPS XML, USPS Methods

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...