MySQL Forums
Forum List  »  InnoDB

Server chrases everytime
Posted by: Francisco Javier Almeida Hernández
Date: June 24, 2005 06:13AM

Hello:
I'm working with MySQL 4.1.11 max and Linux Fedora Core 2 and the server crashes each 1 or 2 days.
The log doesnt show any error. It suddenly ends. I've been starting the server a lot of times, and it crashes everytime when it has been working 1 or 2 days.
I restart it and the problem happens again.

Thats the log :
-----------------------------------------------------------------------------------
050613 14:25:57 mysqld started
050613 14:25:58 InnoDB: Started; log sequence number 0 3008612892
050613 14:25:58 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/var/mysql/mysqld.pid' (Errcode: 2)
/usr/local/mysql/bin/mysqld: ready for connections.
Version: '4.1.11-max-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Edition - Experimental (GPL)

Status information:

Current dir: /apps/data/ddbb/
Running threads: 0 Stack size: 131072
Current locks:
lock: 0x89d8a0c:


Key caches:
default
Buffer_size: 16777216
Block_size: 1024
Division_limit: 100
Age_limit: 300
blocks used: 0
not flushed: 0
w_requests: 0
writes: 0
r_requests: 0
reads: 0


handler status:
read_key: 0
read_next: 0
read_rnd 0
read_first: 2
write: 0
delete 0
update: 0

Table status:
Opened tables: 12
Open tables: 1
Open files: 3
Open streams: 0

Alarm status:
Active alarms: 0
Max used alarms: 1
Next alarm time: 0
050616 17:08:26 mysqld ended

050616 19:09:26 mysqld started
050616 19:09:27 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
050616 19:09:27 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 3656708824.
InnoDB: Doing recovery: scanned up to log sequence number 0 3656882868
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 1 row operations to undo
InnoDB: Trx id counter is 0 21801216
050616 19:09:28 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Starting rollback of uncommitted transactions
InnoDB: Rolling back trx with id 0 21800847, 1 rows to undo
InnoDB: Rolling back of trx id 0 21800847 completed
InnoDB: Rollback of uncommitted transactions completed
050616 19:09:30 InnoDB: Flushing modified pages from the buffer pool...
050616 19:09:31 InnoDB: Started; log sequence number 0 3656882868
050616 19:09:31 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/var/mysql/mysqld.pid' (Errcode: 2)
/usr/local/mysql/bin/mysqld: ready for connections.
Version: '4.1.11-max-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Edition - Experimental (GPL)

Status information:

Current dir: /apps/data/ddbb/
Running threads: 41 Stack size: 131072
Current locks:
lock: 0x8ac571c:

lock: 0x8ac3924:

lock: 0x8a7c340:

lock: 0x8a4a3a0:

lock: 0x8a155d0:

lock: 0x89e2410:

lock: 0x89daf00:

lock: 0x89e4d50:


Key caches:
default
Buffer_size: 16777216
Block_size: 1024
Division_limit: 100
Age_limit: 300
blocks used: 15
not flushed: 0
w_requests: 386
writes: 386
r_requests: 1520
reads: 15


handler status:
read_key: 235
read_next: 0
read_rnd 0
read_first: 24
write: 372
delete 0
update: 0

Table status:
Opened tables: 20
Open tables: 9
Open files: 5
Open streams: 0

Alarm status:
Active alarms: 41
Max used alarms: 41
Next alarm time: 28760
050618 13:06:10 mysqld ended

050618 14:57:44 mysqld started
No variable match for: -O 'read_buffer_size=1M'
/usr/libexec/mysqld Ver 3.23.58 for redhat-linux-gnu on i386
Use '--help' or '--no-defaults --help' for a list of available options
050618 14:57:44 mysqld ended

050618 14:59:47 mysqld started
050618 14:59:48 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
050618 14:59:48 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 4000627697.
InnoDB: Doing recovery: scanned up to log sequence number 0 4000656776
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 1 row operations to undo
InnoDB: Trx id counter is 0 26241280
050618 14:59:48 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Starting rollback of uncommitted transactions
InnoDB: Rolling back trx with id 0 26240788, 1 rows to undo
InnoDB: Rolling back of trx id 0 26240788 completed
InnoDB: Rollback of uncommitted transactions completed
050618 14:59:49 InnoDB: Flushing modified pages from the buffer pool...
050618 14:59:50 InnoDB: Started; log sequence number 0 4000656776
050618 14:59:50 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/var/mysql/mysqld.pid' (Errcode: 2)
/usr/local/mysql/bin/mysqld: ready for connections.
Version: '4.1.11-max-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Edition - Experimental (GPL)
050620 12:58:53 mysqld ended

050620 13:12:01 mysqld started
050620 13:12:02 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
050620 13:12:02 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 1 32938904.
InnoDB: Doing recovery: scanned up to log sequence number 1 32941448
050620 13:12:03 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
050620 13:12:04 InnoDB: Flushing modified pages from the buffer pool...
050620 13:12:04 InnoDB: Started; log sequence number 1 32941448
050620 13:12:04 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/var/mysql/mysqld.pid' (Errcode: 2)
/usr/local/mysql/bin/mysqld: ready for connections.
Version: '4.1.11-max-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Edition - Experimental (GPL)
050621 23:51:49 mysqld ended

050622 10:26:48 mysqld started
050622 10:26:52 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
050622 10:26:52 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 1 341687413.
InnoDB: Doing recovery: scanned up to log sequence number 1 341820123
050622 10:26:52 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
050622 10:26:54 InnoDB: Flushing modified pages from the buffer pool...
050622 10:26:55 InnoDB: Started; log sequence number 1 341820123
050622 10:26:55 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/var/mysql/mysqld.pid' (Errcode: 2)
/usr/local/mysql/bin/mysqld: ready for connections.
Version: '4.1.11-max-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Edition - Experimental (GPL)

Status information:

Current dir: /apps/data/ddbb/
Running threads: 71 Stack size: 131072
Current locks:
lock: 0x8d37d58:

lock: 0x8ab0ed8:

lock: 0x8a6bb28:

lock: 0x8a5d358:

lock: 0x8a5d2c0:

lock: 0x8a5d158:

lock: 0x89e4d70:


Key caches:
default
Buffer_size: 16777216
Block_size: 1024
Division_limit: 100
Age_limit: 300
blocks used: 0
not flushed: 0
w_requests: 0
writes: 0
r_requests: 0
reads: 0


handler status:
read_key: 582
read_next: 0
read_rnd 0
read_first: 28
write: 10
delete 0
update: 0

Table status:
Opened tables: 38
Open tables: 27
Open files: 1
Open streams: 0

Alarm status:
Active alarms: 71
Max used alarms: 71
Next alarm time: 28772
050622 10:29:14 mysqld started
050622 10:29:14 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
050622 10:29:14 [ERROR] Do you already have another mysqld server running on port: 3306 ?
050622 10:29:14 [ERROR] Aborting

050622 10:29:14 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

050622 10:29:14 mysqld ended

050622 10:33:11 mysqld started
050622 10:33:11 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
050622 10:33:11 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 1 341889607.
InnoDB: Doing recovery: scanned up to log sequence number 1 341889607
050622 10:33:11 InnoDB: Flushing modified pages from the buffer pool...
050622 10:33:11 InnoDB: Started; log sequence number 1 341889607
050622 10:33:11 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/var/mysql/mysqld.pid' (Errcode: 2)
/usr/local/mysql/bin/mysqld: ready for connections.
Version: '4.1.11-max-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Edition - Experimental (GPL)
050623 9:22:18 [ERROR] bdb: log_archive: DB_ARCH_ABS: DB_NOTFOUND: No matching key/data pair found
050623 9:22:25 [ERROR] bdb: log_archive: DB_ARCH_ABS: DB_NOTFOUND: No matching key/data pair found
050624 11:47:14 mysqld ended

050624 11:50:37 mysqld started
050624 11:50:37 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
050624 11:50:38 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 1 680888300.
InnoDB: Doing recovery: scanned up to log sequence number 1 681039137
050624 11:50:38 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
050624 11:50:40 InnoDB: Flushing modified pages from the buffer pool...
050624 11:50:42 InnoDB: Started; log sequence number 1 681039137
050624 11:50:42 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/var/mysql/mysqld.pid' (Errcode: 2)
/usr/local/mysql/bin/mysqld: ready for connections.
Version: '4.1.11-max-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Edition - Experimental (GPL)
-----------------------------------------------------------------------------------

Thanks for your help.

Options: ReplyQuote


Subject
Views
Written By
Posted
Server chrases everytime
3340
June 24, 2005 06:13AM
2097
July 06, 2005 07:20PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.