[BlueOnyx:04636] Re: Help with recent Installs (/var Full) (Mysql quit)

[publictv at cox.net]

This is what I found it looks like that right now is mosly about not enough space to create a pid file what ever that is and some thing about an unsigned value thats being adjusted.


[root at www ~]# tail -n 50 /var/log/mysqld.log                                                                                                   
100523  4:24:04 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100523  4:24:04 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100523  4:24:04  InnoDB: Started; log sequence number 0 43655
100523  4:24:04 [ERROR] /usr/libexec/mysqld: Error writing file '/var/run/mysqld/mysqld.pid' (Errcode: 28)
100523  4:24:04 [ERROR] Can't start server: can't create PID file: No space left on device

Number of processes running now: 0
100523 04:24:05  mysqld restarted
100523  4:24:05 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100523  4:24:05 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100523  4:24:05  InnoDB: Started; log sequence number 0 43655
100523  4:24:05 [ERROR] /usr/libexec/mysqld: Error writing file '/var/run/mysqld/mysqld.pid' (Errcode: 28)
100523  4:24:05 [ERROR] Can't start server: can't create PID file: No space left on device

Number of processes running now: 0
100523 04:24:05  mysqld restarted
100523  4:24:05 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100523  4:24:05 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100523  4:24:05  InnoDB: Started; log sequence number 0 43655
100523  4:24:05 [ERROR] /usr/libexec/mysqld: Error writing file '/var/run/mysqld/mysqld.pid' (Errcode: 28)
100523  4:24:05 [ERROR] Can't start server: can't create PID file: No space left on device

Number of processes running now: 0
100523 04:24:05  mysqld restarted
100523  4:24:05 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100523  4:24:05 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100523  4:24:05  InnoDB: Started; log sequence number 0 43655
100523  4:24:05 [ERROR] /usr/libexec/mysqld: Error writing file '/var/run/mysqld/mysqld.pid' (Errcode: 28)
100523  4:24:05 [ERROR] Can't start server: can't create PID file: No space left on device

Number of processes running now: 0
100523 04:24:05  mysqld restarted
100523  4:24:05 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100523  4:24:05 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100523  4:24:05  InnoDB: Started; log sequence number 0 43655
100523  4:24:05 [ERROR] /usr/libexec/mysqld: Error writing file '/var/run/mysqld/mysqld.pid' (Errcode: 28)
100523  4:24:05 [ERROR] Can't start server: can't create PID file: No space left on device

Number of processes running now: 0
100523 04:24:05  mysqld restarted
100523  4:24:05 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100523  4:24:05 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100523  4:24:05  InnoDB: Started; log sequence number 0 43655
100523  4:24:05 [ERROR] /usr/libexec/mysqld: Error writing file '/var/run/mysqld/mysqld.pid' (Errcode: 28)
100523  4:24:05 [ERROR] Can't start server: can't create PID file: No space left on device

Number of processes running now: 0
100523 04:24:05  mysqld restarted
100523  4:24:05 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100523  4:24:05 [Warning] option 'max_join_size': unsigned value 1844674407370955