Q&A

  • mysql의 오류문제입니다. 아시는분 답변좀 주세요
안녕하세요

델파이 초보이고 DB도 초보여서 그런지 이 에러가 왜 나오는지 해결점을 못찾겠어요

델파이로 짠 프로그램은 mysql DB를 사용하구 컴포넌트는 제우스 컴포넌트를 사용합니다.

mysql 버전은 4.0.18 버전이구요.

데이타 타입은 InnoDB 사용합니다.

이오류메세지는 mysql폴더의 data폴더에 있는 에러 파일내용입니다.

프로그램상의 오류는 아니고 DB상에 문제로 보구있는데 설정이 틀린건지 아님 어떤 문제인지 알려주세요



--------redtiger.err 파일의 내용--------------

050302 12:55:55  MySql: Forcing close of thread 2  user: 'root'

050302 12:55:58  InnoDB: Starting shutdown...
050302 12:56:00  InnoDB: Shutdown completed
050302 12:56:00  MySql: Shutdown Complete

050302 12:57:02  InnoDB: Started
MySql: ready for connections.
Version: '4.0.18-max-nt'  socket: ''  port: 3306
050303 10:22:29  MySql: Normal shutdown

050303 10:22:31  MySql: Forcing close of thread 6  user: 'root'

050303 10:22:34  InnoDB: Starting shutdown...
050303 10:22:37  InnoDB: Shutdown completed
050303 10:22:37  MySql: Shutdown Complete

050303 10:29:00  InnoDB: Started
MySql: ready for connections.
Version: '4.0.18-max-nt'  socket: ''  port: 3306
050303 10:32:42  MySql: Normal shutdown

050303 10:32:42  InnoDB: Starting shutdown...
050303 10:32:43  InnoDB: Shutdown completed
050303 10:32:43  MySql: Shutdown Complete

050303 10:33:39  InnoDB: Started
MySql: ready for connections.
Version: '4.0.18-max-nt'  socket: ''  port: 3306
050303 10:44:24  MySql: Normal shutdown

050303 10:44:25  MySql: Forcing close of thread 1  user: 'root'

050303 10:44:25  InnoDB: Starting shutdown...
050303 10:44:28  InnoDB: Shutdown completed
050303 10:44:28  MySql: Shutdown Complete

050303 10:48:34  InnoDB: Started
MySql: ready for connections.
Version: '4.0.18-max-nt'  socket: ''  port: 3306
050303 10:50:09  MySql: Normal shutdown

050303 10:50:10  InnoDB: Starting shutdown...
050303 10:50:11  InnoDB: Shutdown completed
050303 10:50:11  MySql: Shutdown Complete

050303 10:52:55  InnoDB: Started
MySql: ready for connections.
Version: '4.0.18-max-nt'  socket: ''  port: 3306
050303 10:54:43  MySql: Normal shutdown

050303 10:54:43  InnoDB: Starting shutdown...
050303 10:54:45  InnoDB: Shutdown completed
050303 10:54:45  MySql: Shutdown Complete

050303 10:56:08  InnoDB: Started
050303 10:56:08  Can't open shared library 'mysql\app_result.dll' (errno: 0 )
MySql: ready for connections.
Version: '4.0.18-max-nt'  socket: ''  port: 3306
050303 11:36:41  MySql: Normal shutdown

050303 11:36:42  MySql: Forcing close of thread 4  user: 'root'

050303 11:36:43  InnoDB: Starting shutdown...
050303 11:36:46  InnoDB: Shutdown completed
050303 11:36:47  MySql: Shutdown Complete

050303 11:37:38  InnoDB: Started
050303 11:37:38  Can't open shared library 'mysql\app_result.dll' (errno: 0 )
MySql: ready for connections.
Version: '4.0.18-max-nt'  socket: ''  port: 3306
050303 17:54:07  MySql: Normal shutdown

050303 17:54:08  MySql: Forcing close of thread 2  user: 'root'

050303 17:54:09  InnoDB: Starting shutdown...
050303 17:54:12  InnoDB: Shutdown completed
050303 17:54:12  MySql: Shutdown Complete

050303 17:54:59  InnoDB: Started
050303 17:54:59  Can't open shared library 'mysql\app_result.dll' (errno: 0 )
MySql: ready for connections.
Version: '4.0.18-max-nt'  socket: ''  port: 3306
050310 12:04:43  MySql: Normal shutdown

050310 12:04:44  MySql: Forcing close of thread 44  user: 'root'

050310 12:04:47  InnoDB: Starting shutdown...
050310 12:04:52  InnoDB: Shutdown completed
050310 12:04:52  MySql: Shutdown Complete

050310 12:08:56  InnoDB: Started
050310 12:08:56  Can't open shared library 'mysql\app_result.dll' (errno: 0 )
MySql: ready for connections.
Version: '4.0.18-max-nt'  socket: ''  port: 3306
050321 10:14:13  InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 34967830
InnoDB: Doing recovery: scanned up to log sequence number 0 34967830
050321 10:14:13  InnoDB: Flushing modified pages from the buffer pool...
050321 10:14:13  InnoDB: Started
050321 10:14:13  Can't open shared library 'mysql\app_result.dll' (errno: 0 )
MySql: ready for connections.
Version: '4.0.18-max-nt'  socket: ''  port: 3306
050324 15:56:32  MySql: Normal shutdown

050324 15:56:34  MySql: Forcing close of thread 35  user: 'root'

050324 15:56:36  InnoDB: Starting shutdown...
050324 15:56:40  InnoDB: Shutdown completed
050324 15:56:40  MySql: Shutdown Complete

050324 15:58:12  InnoDB: Started
050324 15:58:12  Can't open shared library 'mysql\app_result.dll' (errno: 0 )
MySql: ready for connections.
Version: '4.0.18-max-nt'  socket: ''  port: 3306
050325  7:16:35  MySql: Normal shutdown

050325  7:16:36  MySql: Forcing close of thread 11  user: 'root'

050325  7:17:39  InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 37085012
InnoDB: Doing recovery: scanned up to log sequence number 0 37085012
050325  7:17:39  InnoDB: Flushing modified pages from the buffer pool...
050325  7:17:39  InnoDB: Started
050325  7:17:39  Can't open shared library 'mysql\app_result.dll' (errno: 0 )
MySql: ready for connections.
Version: '4.0.18-max-nt'  socket: ''  port: 3306
050325  9:39:47  MySql: Normal shutdown

050325  9:39:50  InnoDB: Starting shutdown...
050325  9:39:52  InnoDB: Shutdown completed
050325  9:39:52  MySql: Shutdown Complete

050325  9:40:38  InnoDB: Started
050325  9:40:38  Can't open shared library 'mysql\app_result.dll' (errno: 0 )
MySql: ready for connections.
Version: '4.0.18-max-nt'  socket: ''  port: 3306
050325 10:07:51  MySql: Normal shutdown

050325 10:07:51  InnoDB: Starting shutdown...
050325 10:07:55  InnoDB: Shutdown completed
050325 10:07:55  MySql: Shutdown Complete

050325 10:08:03  InnoDB: Started
050325 10:08:03  Can't open shared library 'mysql\app_result.dll' (errno: 0 )
MySql: ready for connections.
Version: '4.0.18-max-nt'  socket: ''  port: 3306
050325 13:02:06  InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 37276281
InnoDB: Doing recovery: scanned up to log sequence number 0 37276281
050325 13:02:06  InnoDB: Flushing modified pages from the buffer pool...
050325 13:02:06  InnoDB: Started
050325 13:02:06  Can't open shared library 'mysql\app_result.dll' (errno: 0 )
MySql: ready for connections.
Version: '4.0.18-max-nt'  socket: ''  port: 3306
050326  8:49:16  MySql: Normal shutdown

050326  8:49:17  MySql: Forcing close of thread 22  user: 'root'

050326  8:49:19  InnoDB: Starting shutdown...
050326  8:49:23  InnoDB: Shutdown completed
050326  8:49:23  MySql: Shutdown Complete

050326  8:50:20  InnoDB: Started
050326  8:50:20  Can't open shared library 'mysql\app_result.dll' (errno: 0 )
MySql: ready for connections.
Version: '4.0.18-max-nt'  socket: ''  port: 3306
050328 11:58:19  MySql: Normal shutdown

050328 11:58:22  InnoDB: Starting shutdown...
050328 11:58:25  InnoDB: Shutdown completed
050328 11:58:25  MySql: Shutdown Complete

050328 13:29:30  InnoDB: Started
050328 13:29:30  Can't open shared library 'mysql\app_result.dll' (errno: 0 )
MySql: ready for connections.
Version: '4.0.18-max-nt'  socket: ''  port: 3306
050328 16:24:31  MySql: Normal shutdown

050328 16:24:32  InnoDB: Starting shutdown...
050328 16:24:34  InnoDB: Shutdown completed
050328 16:24:34  MySql: Shutdown Complete

050328 16:25:28  InnoDB: Started
050328 16:25:28  Can't open shared library 'mysql\app_result.dll' (errno: 0 )
MySql: ready for connections.
Version: '4.0.18-max-nt'  socket: ''  port: 3306
050329 14:20:21  MySql: Normal shutdown

050329 14:20:22  MySql: Forcing close of thread 101  user: 'root'

050329 14:20:26  InnoDB: Starting shutdown...
050329 14:20:32  InnoDB: Shutdown completed
050329 14:20:32  MySql: Shutdown Complete

050329 14:21:51  InnoDB: Started
050329 14:21:51  Can't open shared library 'mysql\app_result.dll' (errno: 0 )
MySql: ready for connections.
Version: '4.0.18-max-nt'  socket: ''  port: 3306
050330 17:12:13  MySql: Normal shutdown

050330 17:12:14  MySql: Forcing close of thread 11  user: 'root'

050330 17:12:17  InnoDB: Starting shutdown...
050330 17:12:21  InnoDB: Shutdown completed
050330 17:12:21  MySql: Shutdown Complete

050330 17:13:13  InnoDB: Started
050330 17:13:13  Can't open shared library 'mysql\app_result.dll' (errno: 0 )
MySql: ready for connections.
Version: '4.0.18-max-nt'  socket: ''  port: 3306
050331 14:50:26  InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 51328131
InnoDB: Doing recovery: scanned up to log sequence number 0 51328131
050331 14:50:26  InnoDB: Flushing modified pages from the buffer pool...
050331 14:50:26  InnoDB: Started
050331 14:50:26  Can't open shared library 'mysql\app_result.dll' (errno: 0 )
050331 14:50:26  Can't open shared library 'FurQ' (errno: 0 )
MySql: ready for connections.
Version: '4.0.18-max-nt'  socket: ''  port: 3306
050404  8:54:36  MySql: Normal shutdown

050404  8:54:39  InnoDB: Starting shutdown...
050404  8:54:42  InnoDB: Shutdown completed
050404  8:54:42  MySql: Shutdown Complete

050404  8:56:34  InnoDB: Started
050404  8:56:34  Can't open shared library 'mysql\app_result.dll' (errno: 0 )
050404  8:56:34  Can't open shared library 'FurQ' (errno: 0 )
MySql: ready for connections.
Version: '4.0.18-max-nt'  socket: ''  port: 3306
050404 13:08:08  MySql: Normal shutdown

050404 13:08:09  MySql: Forcing close of thread 2  user: 'root'

050404 13:18:11  InnoDB: Started
050404 13:18:11  Can't open shared library 'mysql\app_result.dll' (errno: 0 )
050404 13:18:11  Can't open shared library 'FurQ' (errno: 0 )
MySql: ready for connections.
Version: '4.0.18-max-nt'  socket: ''  port: 3306
050411 16:38:30  MySql: Normal shutdown

050411 16:38:35  InnoDB: Starting shutdown...
050411 16:38:47  InnoDB: Shutdown completed
050411 16:38:47  MySql: Shutdown Complete

050412 16:11:02  MySql: Forcing close of thread 5  user: 'root'

050412 16:11:04  InnoDB: Starting shutdown...
050412 16:11:10  InnoDB: Shutdown completed
050412 16:11:10  MySql: Shutdown Complete
Version: '4.0.18-max-nt'  socket: ''  port: 3306
050421 14:56:52  InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 57400767
InnoDB: Doing recovery: scanned up to log sequence number 0 57400767
050421 14:56:52  InnoDB: Flushing modified pages from the buffer pool...
050421 14:56:53  InnoDB: Started
050421 14:56:53  Can't open shared library 'mysql\app_result.dll' (errno: 0 )
050421 14:56:53  Can't open shared library 'FurQ' (errno: 0 )
MySql: ready for connections.
Version: '4.0.18-max-nt'  socket: ''  port: 3306
050423 13:47:50  MySql: Normal shutdown

050423 13:47:53  InnoDB: Starting shutdown...
050423 13:47:58  InnoDB: Shutdown completed
050423 13:47:58  MySql: Shutdown Complete

050423 13:50:46  InnoDB: Started
050423 13:50:46  Can't open shared library 'mysql\app_result.dll' (errno: 0 )
050423 13:50:46  Can't open shared library 'FurQ' (errno: 0 )
MySql: ready for connections.
Version: '4.0.18-max-nt'  socket: ''  port: 3306
050423 14:31:03  MySql: Normal shutdown

050423 14:31:04  InnoDB: Starting shutdown...
050423 14:31:07  InnoDB: Shutdown completed
050423 14:31:07  MySql: Shutdown Complete

050423 14:37:27  InnoDB: Started
050423 14:37:27  Can't open shared library 'mysql\app_result.dll' (errno: 0 )
050423 14:37:27  Can't open shared library 'FurQ' (errno: 0 )
MySql: ready for connections.
Version: '4.0.18-max-nt'  socket: ''  port: 3306
050425  8:30:30  InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 58134912
InnoDB: Doing recovery: scanned up to log sequence number 0 58134912
050425  8:30:30  InnoDB: Flushing modified pages from the buffer pool...
050425  8:30:30  InnoDB: Started
050425  8:30:30  Can't open shared library 'mysql\app_result.dll' (errno: 0 )
050425  8:30:30  Can't open shared library 'FurQ' (errno: 0 )
MySql: ready for connections.
Version: '4.0.18-max-nt'  socket: ''  port: 3306
050426 11:50:39  InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 58565444
InnoDB: Doing recovery: scanned up to log sequence number 0 58566300
050426 11:50:39  InnoDB: Error: page 5 log sequence number 0 58572874
InnoDB: is in the future! Current system log sequence number 0 58566300.
InnoDB: Your database may be corrupt.
050426 11:50:39  InnoDB: Error: page 6 log sequence number 0 58589777
InnoDB: is in the future! Current system log sequence number 0 58566300.
InnoDB: Your database may be corrupt.
050426 11:50:39  InnoDB: Error: page 45 log sequence number 0 58584307
InnoDB: is in the future! Current system log sequence number 0 58566300.
InnoDB: Your database may be corrupt.
050426 11:50:39  InnoDB: Error: page 1947 log sequence number 0 58588378
InnoDB: is in the future! Current system log sequence number 0 58566300.
InnoDB: Your database may be corrupt.
050426 11:50:39  InnoDB: Error: page 0 log sequence number 0 58578538
InnoDB: is in the future! Current system log sequence number 0 58566300.
InnoDB: Your database may be corrupt.
050426 11:50:39  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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 050426 11:50:39  InnoDB: Error: page 213 log sequence number 0 58578538
InnoDB: is in the future! Current system log sequence number 0 58566300.
InnoDB: Your database may be corrupt.
050426 11:50:39  InnoDB: Error: page 216 log sequence number 0 58578538
InnoDB: is in the future! Current system log sequence number 0 58566300.
InnoDB: Your database may be corrupt.

InnoDB: Apply batch completed
050426 11:50:39  InnoDB: Flushing modified pages from the buffer pool...
050426 11:50:39  InnoDB: Started
050426 11:50:39  Can't open shared library 'mysql\app_result.dll' (errno: 0 )
050426 11:50:39  Can't open shared library 'FurQ' (errno: 0 )
MySql: ready for connections.
Version: '4.0.18-max-nt'  socket: ''  port: 3306
050426 12:45:14  InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 58566388
InnoDB: Doing recovery: scanned up to log sequence number 0 58571711
050426 12:45:14  InnoDB: Error: page 45 log sequence number 0 58584307
InnoDB: is in the future! Current system log sequence number 0 58571711.
InnoDB: Your database may be corrupt.
050426 12:45:14  InnoDB: Error: page 0 log sequence number 0 58578538
InnoDB: is in the future! Current system log sequence number 0 58571711.
InnoDB: Your database may be corrupt.
050426 12:45:14  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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
050426 12:45:15  InnoDB: Flushing modified pages from the buffer pool...
050426 12:45:15  InnoDB: Started
050426 12:45:16  Can't open shared library 'mysql\app_result.dll' (errno: 0 )
050426 12:45:16  Can't open shared library 'FurQ' (errno: 0 )
MySql: ready for connections.
Version: '4.0.18-max-nt'  socket: ''  port: 3306
050426 12:46:00  InnoDB: Error: page 216 log sequence number 0 58578538
InnoDB: is in the future! Current system log sequence number 0 58571721.
InnoDB: Your database may be corrupt.
050426 12:46:18  InnoDB: Error: page 213 log sequence number 0 58578538
InnoDB: is in the future! Current system log sequence number 0 58571721.
InnoDB: Your database may be corrupt.
050426 13:41:20  InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 58571721
InnoDB: Doing recovery: scanned up to log sequence number 0 58577055
050426 13:41:20  InnoDB: Error: page 45 log sequence number 0 58584307
InnoDB: is in the future! Current system log sequence number 0 58577055.
InnoDB: Your database may be corrupt.
050426 13:41:20  InnoDB: Error: page 0 log sequence number 0 58578538
InnoDB: is in the future! Current system log sequence number 0 58577055.
InnoDB: Your database may be corrupt.
050426 13:41:20  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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
050426 13:41:20  InnoDB: Flushing modified pages from the buffer pool...
050426 13:41:20  InnoDB: Started
050426 13:41:21  Can't open shared library 'mysql\app_result.dll' (errno: 0 )
050426 13:41:21  Can't open shared library 'FurQ' (errno: 0 )
MySql: ready for connections.
Version: '4.0.18-max-nt'  socket: ''  port: 3306
050426 13:42:56  InnoDB: Error: page 216 log sequence number 0 58578538
InnoDB: is in the future! Current system log sequence number 0 58577065.
InnoDB: Your database may be corrupt.
050426 13:46:22  InnoDB: Error: page 213 log sequence number 0 58578538
InnoDB: is in the future! Current system log sequence number 0 58577065.
InnoDB: Your database may be corrupt.
0  COMMENTS