Database error in vBulletin:

[pkuczaj]

Any thoughts? This has happened three times now. The first two times, I reboot the box within minutes of this starting, and my webmaster accounting receiving 50-80 e-mails. The third time I wasn't at my computer and I received 160 e-mails and the problem seems to have resolved itself. It happened within a 3 minute span.

Database error in vBulletin:
Link-ID == false, connect failed
mysql error:

mysql error number: 0

Date: Friday 05th of March 2004 09:22:49 AM
Script: http://baby.ourlittleuniverse.com/ (http://baby.ourlittleuniverse.com/)
Referer: http://www.ourlittleuniverse.com (http://www.ourlittleuniverse.com)
IP Address: 24.57.145.28

This is running on the following:
Dedicated server
Running two vBulleting sites on Virtual Hosts
AMD 3000, IDE 120Gig, 1 Gig RAM
Linux SuSE 9.0, Apache 1.3.28, PHP 4.3.3, MySQL 4.0.15
ALL software with the exception of vBulletin was installed by the SuSE installer with a clean install
Top users site #1 - 111 (01-26-2004 12:17 PM)
Top users site #2 - 125 (02-24-2004 12:41 PM)

MySQL Extended Stat:

+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 12 |
| Aborted_connects | 11 |
| Bytes_received | 591565312 |
| Bytes_sent | 2265447697 |
| Com_admin_commands | 52372 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 153795 |
| 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 | 5309 |
| 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 | 83151 |
| Com_insert_select | 3548 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 4 |
| Com_optimize | 0 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 6150 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 1418923 |
| Com_set_option | 332 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 332 |
| Com_show_databases | 0 |
| Com_show_fields | 332 |
| 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 | 17 |
| Com_show_variables | 13 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 249680 |
| Connections | 101444 |
| Created_tmp_disk_tables | 342 |
| Created_tmp_tables | 48374 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 36119 |
| Handler_read_first | 232651 |
| Handler_read_key | 27480877 |
| Handler_read_next | 16878690 |
| Handler_read_prev | 243351 |
| Handler_read_rnd | 7489630 |
| Handler_read_rnd_next | 48086419 |
| Handler_rollback | 0 |
| Handler_update | 347017 |
| Handler_write | 2797054 |
| Key_blocks_used | 15586 |
| Key_read_requests | 60540105 |
| Key_reads | 408304 |
| Key_write_requests | 240938 |
| Key_writes | 197413 |
| Max_used_connections | 100 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 64 |
| Open_files | 124 |
| Open_streams | 0 |
| Opened_tables | 38897 |
| Questions | 2023011 |
| 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 | 2338 |
| Select_full_range_join | 6609 |
| Select_range | 424523 |
| Select_range_check | 0 |
| Select_scan | 160902 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 2 |
| Sort_merge_passes | 0 |
| Sort_range | 70977 |
| Sort_rows | 8060747 |
| Sort_scan | 55884 |
| Table_locks_immediate | 2866315 |
| Table_locks_waited | 482 |
| Threads_cached | 0 |
| Threads_created | 101443 |
| Threads_connected | 6 |
| Threads_running | 1 |
| Uptime | 207169 |
+--------------------------+------------+

Apache Settings:
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 1
MaxSpareServers 1
StartServers 1
MaxClients 150

vBulletin version: 3.0.0 RC 2

[Zachery]

Your MySQL server was down for some reason, or couldnt connect.

[Steve Machol]

I told him that. That's why I suggested he post here for help configuring his server. :)

However he still needs to post all the info requested here:

http://www.vbulletin.com/forum/showthread.php?t=70117

[pkuczaj]

What am I missing? I thought I posted everything that was requested in that post....

I didn't think that MySQL could recover by itself from going down. If MySQL is crashed will it recover on it's own?

[Steve Machol]

Your top stats, your average and max concurrent users on your vB forum and a link to your phpinfo.php file, for instance. The easiest way to do this is to answer each numbered question.

[pkuczaj]

http://www.ourlittleuniverse.com/phpinfo.php

I listed the max users in my first post, but How do I find the average post/users from the vBulletin software?

Max Users:
Site #1 - 111 (01-26-2004 12:17 PM)
Site #2 - 125 (02-24-2004 12:41 PM)

The other thing to remember is that I have two vBulletin boards on the same machine accessing two databases on the same MySQL service on the same machine.

[eva2000]

pluczaj, do the following

1. upgrade mysql to 4.0.18
2. upgrade php to 4.3.4
3. edit or create /etc/my.cnf and place the following settings in it and restart mysql


[mysqld]
max_connections = 400
key_buffer = 32M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 64
wait_timeout = 900
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
skip-innodb

[mysqld_safe]
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M


4. upgrade apache 1.3.28 - can do this later if you want

[pkuczaj]

I've upgraded the my.cnf file with your recommendations. I can't find the rpms for the mysql, php, or the apache to these version for SuSE 9.0. But I will keep an eye out for them, and upgrade as soon as there available. I may attempt to recompile them myself on a test machine later. It'll miss tonights upgrades though. I'll keep you up-to date as to whether or not this problem recurres.


Thank you for you assistance.

pluczaj, do the following

1. upgrade mysql to 4.0.18
2. upgrade php to 4.3.4
3. edit or create /etc/my.cnf and place the following settings in it and restart mysql



4. upgrade apache 1.3.28 - can do this later if you want