vBulletin 3.0.7 mysql error number: 0 Link-ID == false, connect failed

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • User213029312
    Member
    • Mar 2004
    • 32
    • 4.1.x

    #16
    I, too, am having this error message and will pass it on to my host server.

    Comment

    • ridemonkey
      Senior Member
      • Jun 2001
      • 253

      #17
      This is a strange situation that has surfaced recently and seems to be vbulletin specific. Last week the 2 vbulletin installations on my server displayed this error, yet every other non-vbulletin site on the server that used mysql worked fine. A few days later this happened on another server. I just went to sitepoint.com and saw the same error.

      Comment

      • CWHeadley
        New Member
        • Dec 2004
        • 20
        • 3.0.0 Beta 3

        #18
        Originally posted by MarcoH64
        That sounds strange to me. If PHP wants to connect to MySQL, this is a server process, no clientside DNS involved in that i think.
        That is what I understand as well. If the domain name resolves and your hitting the proper IP/Domain, then the software (vBulletin) uses the config file . If the config file is correct, there won't be any DNS issues.

        I too have been getting the same error message.

        Here is the diagnosis via the AdminCP on the database:

        Aborted_clients 19152
        Aborted_connects 13072
        Bytes_received 3475274755
        Bytes_sent 2020706562
        Com_admin_commands 15821
        Com_alter_table 77
        Com_analyze 0
        Com_backup_table 0
        Com_begin 285
        Com_change_db 850012
        Com_change_master 0
        Com_check 91
        Com_commit 285
        Com_create_db 42
        Com_create_function 0
        Com_create_index 46
        Com_create_table 2766
        Com_delete 199316
        Com_delete_multi 0
        Com_drop_db 24
        Com_drop_function 0
        Com_drop_index 0
        Com_drop_table 2261
        Com_flush 1690
        Com_grant 4141
        Com_ha_close 0
        Com_ha_open 0
        Com_ha_read 0
        Com_insert 857458
        Com_insert_select 2329
        Com_kill 1
        Com_load 0
        Com_load_master_data 0
        Com_load_master_table 0
        Com_lock_tables 189949
        Com_optimize 346
        Com_purge 0
        Com_rename_table 0
        Com_repair 91
        Com_replace 20882
        Com_replace_select 0
        Com_reset 0
        Com_restore_table 0
        Com_revoke 0
        Com_rollback 0
        Com_savepoint 0
        Com_select 11108778
        Com_set_option 45092
        Com_show_binlog_events 0
        Com_show_binlogs 154
        Com_show_create 3082
        Com_show_databases 3099
        Com_show_fields 4231
        Com_show_grants 399
        Com_show_keys 1286
        Com_show_logs 0
        Com_show_master_status 0
        Com_show_new_master 0
        Com_show_open_tables 7
        Com_show_processlist 1494
        Com_show_slave_hosts 0
        Com_show_slave_status 0
        Com_show_status 2
        Com_show_innodb_status 0
        Com_show_tables 22294
        Com_show_variables 843
        Com_slave_start 0
        Com_slave_stop 0
        Com_truncate 15
        Com_unlock_tables 201235
        Com_update 570927
        Connections 1034385
        Created_tmp_disk_tables 66332
        Created_tmp_tables 392031
        Created_tmp_files 97
        Delayed_insert_threads 0
        Delayed_writes 106
        Delayed_errors 0
        Flush_commands 1
        Handler_commit 17
        Handler_delete 1007287
        Handler_read_first 1753921
        Handler_read_key 97307119
        Handler_read_next 139038222
        Handler_read_prev 503696
        Handler_read_rnd 15226099
        Handler_read_rnd_next 804670992
        Handler_rollback 370
        Handler_update 40050115
        Handler_write 5952272
        Key_blocks_used 7793
        Key_read_requests 118473663
        Key_reads 3893468
        Key_write_requests 7436788
        Key_writes 2950775
        Max_used_connections 43
        Not_flushed_key_blocks 0
        Not_flushed_delayed_rows 0
        Open_tables 64
        Open_files 123
        Open_streams 0
        Opened_tables 1469400
        Questions 15377141
        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 42796
        Select_full_range_join 215
        Select_range 460095
        Select_range_check 81
        Select_scan 5045511
        Slave_open_temp_tables 0
        Slave_running OFF
        Slow_launch_threads 0
        Slow_queries 8
        Sort_merge_passes 0
        Sort_range 201986
        Sort_rows 22242280
        Sort_scan 4030331
        Table_locks_immediate 15502004
        Table_locks_waited 9873
        Threads_cached 0
        Threads_created 1034322
        Threads_connected 5
        Threads_running 2
        Uptime 447145
        I'll be contacting My hosting company directly. What I found intersting in this diagnostic is connections.

        1034385

        I run a private club site and the membership consists of just 40 people. Thats alot of connections and My sever load is running less than 5 gigs a month.
        Last edited by CWHeadley; Thu 9 Jun '05, 8:45am.

        Comment

        • CWHeadley
          New Member
          • Dec 2004
          • 20
          • 3.0.0 Beta 3

          #19
          Bump.

          This gets no attention?

          It isn't a website or web server issue. None of My other sites have this problem.

          this is vbulletin specific.

          And its getting worse.

          Shall I submitt a ticket for this?

          Comment

          • Steve Machol
            Former Customer Support Manager
            • Jul 2000
            • 154488

            #20
            CWHeadley,

            You really should start your own thread with all the relevant info. For help with optimizing your server, please see this thread:



            Then post the requested info in a new thread in that forum.
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment

            • StewardManscat
              New Member
              • May 2004
              • 17

              #21
              Originally posted by Steve Machol

              Note, many servers are being probed for the phpBB worm these days and the MySQL server is being overloaded. This could account for these errors.
              Is there any way to confirm this is the problem? Prevent it?

              Comment

              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
              Working...