database.sarang.net
UserID
Passwd
Database
DBMS
ㆍMySQL
PostgreSQL
Firebird
Oracle
Informix
Sybase
MS-SQL
DB2
Cache
CUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
MySQL Q&A 30937 게시물 읽기
No. 30937
mariadb 재부팅시 초기화가 됩니다...
작성자
박창훈(hoon8675)
작성일
2016-03-19 22:49
조회수
7,076

 Docker를 이용하여 mariadb를 구동하였습니다.

몇가지 작업을 한 후 커밋 후 컨테이너를 재시작하니 초기상태로 돌아갑니다. 서버를 재부팅만 하면 맨처음 상태로되네요.

정식 이미지가 저렇길래 다른 이미지를 받아 컨테이너를 구동해보니 마찬가지입니다.

정식버전은 10.1.12, 다른 테스트 버전은 10.0 이였습니다.

무엇이 문제일까요?

 

-로그입니다-

컨테이너 종료

 

2016-03-19 22:44:34 139792407595776 [Note] mysqld: Normal shutdown
stdout
13:44:34
 
stdout
13:44:34
2016-03-19 22:44:34 139792407595776 [Note] Event Scheduler: Purging the queue. 0 events
stdout
13:44:35
2016-03-19 22:44:35 139791622432512 [Note] InnoDB: FTS optimize thread exiting.
stdout
13:44:35
2016-03-19 22:44:35 139792407595776 [Note] InnoDB: Starting shutdown...
stdout
13:44:36
2016-03-19 22:44:36 139792407595776 [Note] InnoDB: Shutdown completed; log sequence number 1616839
stdout
13:44:36
2016-03-19 22:44:36 139792407595776 [Note] mysqld: Shutdown complete

 

컨테이너 실행 후 DB 생성

 

2016-03-19 22:46:24 139698060195776 [Note] mysqld (mysqld 10.1.12-MariaDB-1~jessie) starting as process 136 ...
stdout
13:46:24
2016-03-19 22:46:24 139698060195776 [Note] InnoDB: Using mutexes to ref count buffer pool pages
stdout
13:46:24
2016-03-19 22:46:24 139698060195776 [Note] InnoDB: The InnoDB memory heap is disabled
stdout
13:46:24
2016-03-19 22:46:24 139698060195776 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
stdout
13:46:24
2016-03-19 22:46:24 139698060195776 [Note] InnoDB: Memory barrier is not used
stdout
13:46:24
2016-03-19 22:46:24 139698060195776 [Note] InnoDB: Compressed tables use zlib 1.2.8
stdout
13:46:24
2016-03-19 22:46:24 139698060195776 [Note] InnoDB: Using Linux native AIO
stdout
13:46:24
2016-03-19 22:46:24 139698060195776 [Note] InnoDB: Using SSE crc32 instructions
stdout
13:46:24
2016-03-19 22:46:24 139698060195776 [Note] InnoDB: Initializing buffer pool, size = 256.0M
stdout
13:46:24
2016-03-19 22:46:24 139698060195776 [Note] InnoDB: Completed initialization of buffer pool
stdout
13:46:25
2016-03-19 22:46:24 139698060195776 [Note] InnoDB: Highest supported file format is Barracuda.
stdout
13:46:25
2016-03-19 22:46:25 139698060195776 [Note] InnoDB: 128 rollback segment(s) are active.
stdout
13:46:25
2016-03-19 22:46:25 139698060195776 [Note] InnoDB: Waiting for purge to start
stdout
13:46:25
2016-03-19 22:46:25 139698060195776 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1616819
stdout
13:46:25
2016-03-19 22:46:25 139697292543744 [Note] InnoDB: Dumping buffer pool(s) not yet started
stdout
13:46:25
2016-03-19 22:46:25 139698060195776 [Note] Plugin 'FEEDBACK' is disabled.
stdout
13:46:25
2016-03-19 22:46:25 139698060195776 [Warning] 'user' entry 'root@mariadb-10-1-12' ignored in --skip-name-resolve mode.
stdout
13:46:25
2016-03-19 22:46:25 139698060195776 [Warning] 'proxies_priv' entry '@% root@mariadb-10-1-12' ignored in --skip-name-resolve mode.
stdout
13:46:25
2016-03-19 22:46:25 139698060195776 [Note] mysqld: ready for connections.
stdout
13:46:25
Version: '10.1.12-MariaDB-1~jessie'  socket: '/var/run/mysqld/mysqld.sock'  port: 0  mariadb.org binary distribution
stdout
13:46:26
Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
stdout
13:46:29
2016-03-19 22:46:29 139698059717376 [Warning] 'proxies_priv' entry '@% root@mariadb-10-1-12' ignored in --skip-name-resolve mode.
stdout
13:46:29
 
stdout
13:46:29
/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
stdout
13:46:29
 
stdout
13:46:29
2016-03-19 22:46:29 139698059414272 [Note] mysqld: Normal shutdown
stdout
13:46:29
 
stdout
13:46:29
2016-03-19 22:46:29 139698059414272 [Note] Event Scheduler: Purging the queue. 0 events
stdout
13:46:29
2016-03-19 22:46:29 139697275758336 [Note] InnoDB: FTS optimize thread exiting.
stdout
13:46:29
2016-03-19 22:46:29 139698059414272 [Note] InnoDB: Starting shutdown...
stdout
13:46:31
2016-03-19 22:46:31 139698059414272 [Note] InnoDB: Shutdown completed; log sequence number 1616829
stdout
13:46:31
2016-03-19 22:46:31 139698059414272 [Note] mysqld: Shutdown complete
stdout
13:46:31
 
stdout
13:46:31
 
stdout
13:46:31
MySQL init process done. Ready for start up.
stdout
13:46:31
 
stdout
13:46:31
2016-03-19 22:46:31 140354314000320 [Note] mysqld (mysqld 10.1.12-MariaDB-1~jessie) starting as process 1 ...
stdout
13:46:31
2016-03-19 22:46:31 140354314000320 [Note] InnoDB: Using mutexes to ref count buffer pool pages
stdout
13:46:31
2016-03-19 22:46:31 140354314000320 [Note] InnoDB: The InnoDB memory heap is disabled
stdout
13:46:31
2016-03-19 22:46:31 140354314000320 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
stdout
13:46:31
2016-03-19 22:46:31 140354314000320 [Note] InnoDB: Memory barrier is not used
stdout
13:46:31
2016-03-19 22:46:31 140354314000320 [Note] InnoDB: Compressed tables use zlib 1.2.8
stdout
13:46:31
2016-03-19 22:46:31 140354314000320 [Note] InnoDB: Using Linux native AIO
stdout
13:46:31
2016-03-19 22:46:31 140354314000320 [Note] InnoDB: Using SSE crc32 instructions
stdout
13:46:31
2016-03-19 22:46:31 140354314000320 [Note] InnoDB: Initializing buffer pool, size = 256.0M
stdout
13:46:31
2016-03-19 22:46:31 140354314000320 [Note] InnoDB: Completed initialization of buffer pool
stdout
13:46:31
2016-03-19 22:46:31 140354314000320 [Note] InnoDB: Highest supported file format is Barracuda.
stdout
13:46:31
2016-03-19 22:46:31 140354314000320 [Note] InnoDB: 128 rollback segment(s) are active.
stdout
13:46:31
2016-03-19 22:46:31 140354314000320 [Note] InnoDB: Waiting for purge to start
stdout
13:46:31
2016-03-19 22:46:31 140354314000320 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1616829
stdout
13:46:32
2016-03-19 22:46:32 140353545930496 [Note] InnoDB: Dumping buffer pool(s) not yet started
stdout
13:46:32
2016-03-19 22:46:32 140354314000320 [Note] Plugin 'FEEDBACK' is disabled.
stdout
13:46:32
2016-03-19 22:46:32 140354314000320 [Note] Server socket created on IP: '::'.
stdout
13:46:32
2016-03-19 22:46:32 140354314000320 [Warning] 'proxies_priv' entry '@% root@mariadb-10-1-12' ignored in --skip-name-resolve mode.
stdout
13:46:32
2016-03-19 22:46:32 140354314000320 [Note] mysqld: ready for connections.
stdout
13:46:32
Version: '10.1.12-MariaDB-1~jessie'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution

 

컨테이너 종료

 

2016-03-19 22:49:18 140354313218816 [Note] mysqld: Normal shutdown
stdout
13:49:18
 
stdout
13:49:18
2016-03-19 22:49:18 140354313218816 [Note] Event Scheduler: Purging the queue. 0 events
stdout
13:49:18
2016-03-19 22:49:18 140353529145088 [Note] InnoDB: FTS optimize thread exiting.
stdout
13:49:18
2016-03-19 22:49:18 140354313218816 [Note] InnoDB: Starting shutdown...
stdout
13:49:20
2016-03-19 22:49:20 140354313218816 [Note] InnoDB: Shutdown completed; log sequence number 1616839
stdout
13:49:20
2016-03-19 22:49:20 140354313218816 [Note] mysqld: Shutdown complete

 

 

 

 

[Top]
No.
제목
작성자
작성일
조회
30942Mysql 웹접속은 되는데 tcp ip로 접속이 안됩니다 [1]
RayYun
2016-04-01
6472
30940도와 주세요""" My-SQL 에 대하여
신경식
2016-03-24
6409
30939mysql자료를 한번봐주셔요 이게 루프에서 첫번째는 억는데 다음 루프때는 먹지 않음 이미 데이타는 있으므로 무조건 True가 나와야 하는데 false로 인식됩니다. 부탁드립니다.
임기섭
2016-03-21
7955
30937mariadb 재부팅시 초기화가 됩니다...
박창훈
2016-03-19
7076
30936mariadb를 sqlyog프로그램에서 컨트롤할때 경고문이 뜨는데 혹시 해결방법 아시는 분...
궁금이
2016-03-18
6323
30935리눅스 mysql ERROR 1045(28000)
정재완
2016-03-17
6158
30934mssql에서 mysql [1]
궁금증
2016-03-15
6276
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2023 DSN, All rights reserved.
작업시간: 0.051초, 이곳 서비스는
	PostgreSQL v16.1로 자료를 관리합니다