Announcement

**Zachery** · Mon 7 Jun '04, 9:32am

Is the mysql server and apache server the same or are they on differnt systems ?

**JeffBeaubien** · Mon 7 Jun '04, 9:39am

Originally posted by Zachery

Is the mysql server and apache server the same or are they on differnt systems ?

Yes, the mysql server and apache server are on the same box, hence the 'localhost' in the error logs. I'm using the 'large' MYSQL config file with a startup command of:

mysqld_safe --user=mysql --bind-address=127.0.0.1 --log-error=/home/wwwroot/_log/error_mysql.log --skip-thread-priority &

The only other application using mysql at this point is Listmail (www.listmailpro.com).

You can see another discussion thread about this exact same error (which I also started) here:

404 Not Found

http://www.bsdforums.org/forums/showthread.php?s=&threadid=22480

Thanks.

**Zachery** · Mon 7 Jun '04, 9:42am

You might want to ask Eva2000 about a server configuration

**JeffBeaubien** · Mon 7 Jun '04, 10:02am

Originally posted by Zachery

You might want to ask Eva2000 about a server configuration

Who is Eva2000? This is clearly an issue about the way vBulletin is communicating with MYSQL. I really need your help on this because my shipping deadline is in two days. I've provided a lot of info here, can you please tell me what vBulletin might be doing and how to fix it? My message board has ZERO posters at this point, so that's not the problem.

**Floris** · Mon 7 Jun '04, 10:04am

Eva2000 is George, he appears to have guru knowledge of MySQL

**Scott MacVicar** · Mon 7 Jun '04, 10:07am

vBulletin does not communicate with MySQL directly. Its all done through the MySQL functions in PHP.

Do you have persistent connections enabled?
Its caused by the mysql timeout being reached and mysql kills the process.

**JeffBeaubien** · Mon 7 Jun '04, 10:25am

Heh, I still don't know who George is. I spent three hours exchanging emails with your tech support trying to retrieve my password for your forums... please, I need to have some answers and spend my time on other projects. Can you please tell me where to begin fixing this problem?

What I know is this:

1. The problem started after installing vBulletin.
2. The db that is reporting the problem is reserved for vBulletin.
3. It appears to be a vBulletin issue.
4. This is the vBulletin support chat board.

Can ya help me?

**Scott MacVicar** · Mon 7 Jun '04, 11:43am

Its not an error, its a warning message and its not something we can fix. If its a bug its a bug with PHP the scripting language which vBulletin is written in.

It means that a connection to MySQL timed out and wasn't closed by the apache process presumably as persistent connections are turned on or some other configuration problem.

You can check if they are off by opening includes/config.php and make sure
$usepconnect = 0;

**JeffBeaubien** · Mon 7 Jun '04, 11:55am

Okay, how do I contact George?

**Scott MacVicar** · Mon 7 Jun '04, 11:59am

George is in australia and only provides support via the forums. I'd try sending him a private message http://www.vbulletin.com/forum/priva...do=newpm&u=245

Did you check to see if persistent connections was off?

**JeffBeaubien** · Mon 7 Jun '04, 5:00pm

I had persistent connections set to ON. I just turned them off. Do I need to do anything to make the change active? I'm thinking not, but...

**Scott MacVicar** · Mon 7 Jun '04, 5:08pm

Nope you should see it finish once any remaining connections have timed out.

**George L** · Mon 7 Jun '04, 7:56pm

Originally posted by JeffBeaubien

Okay, how do I contact George?

someone called my name

can you post the contents of your /etc/my.cnf file ? if you don't have one can you post the output of the command (as root user in ssh telnet)

mysqladmin -u root -p variables

copy and paste output here

lately there's been alot of people setting their mysql wait_timeout at too low values i.e. 60-100 seconds! or max_allowed_packets may need increasing

Other possible reasons are outlined at http://dev.mysql.com/doc/mysql/en/Co...on_errors.html

Turning off pconnects can help too

**JeffBeaubien** · Tue 8 Jun '04, 3:10am

Hiya George, I turned off the pconnects in the includes/config.php file yesterday and am going to check it this morning (just checked it and haven't got any of those warnings in the past 6 hours). Per your request, here is my my.conf file...

[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 256M
max_allowed_packet = 1M
table_cache = 256
sort_buffer_size = 2M
read_buffer_size = 2M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size= 16M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8

# Replication Master Server (default)
# binary logging is required for replication
log-bin

# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id = 1

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

Announcement

MySQL log errors

MySQL log errors

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment