[groonga-dev,03235] Re: mroongaで同一レコードの登録、削除、登録を行うとユニークキー重複エラー発生

Back to archive index

各務 洋 kagam****@outwa*****
2015年 5月 15日 (金) 20:43:29 JST


お世話になります、各務です。

> 再現環境下でのSHOW SLAVE STATUSのIPアドレス以外のまるまるの出力と、
> エラーが起こったイベントの前後1イベントくらいずつのマスターのバイナリーログと
> スレーブのリレーログとかもらえると深追いできるかも知れません。

採取できました。
添付できなさそうですのでメール内にテキスト形式で記述してみます。
ちょっと多いですが。


SHOW SLAVE STATUS;
+----------------------------------+----------------+-------------+-------------+---------------+------------------+---------------------+-------------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+--------------------+------------------------+-------------------------+-----------------------------+------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+---------------------+-----------------+-----------------+----------------+---------------+--------------------+--------------------+--------------------+-----------------+-------------------+----------------+-----------------------+-------------------------------+---------------+---------------+----------------
| Slave_IO_State                   | Master_Host    | Master_User | Master_Port | Connect_Retry | Master_Log_File  | Read_Master_Log_Pos | Relay_Log_File          | Relay_Log_Pos | Relay_Master_Log_File | Slave_IO_Running | Slave_SQL_Running | Replicate_Do_DB | Replicate_Ignore_DB | Replicate_Do_Table | Replicate_Ignore_Table | Replicate_Wild_Do_Table | Replicate_Wild_Ignore_Table | Last_Errno | Last_Error                                                                                                                                                                       | Skip_Counter | Exec_Master_Log_Pos | Relay_Log_Space | Until_Condition | Until_Log_File | Until_Log_Pos | Master_SSL_Allowed | Master_SSL_CA_File | Master_SSL_CA_Path | Master_SSL_Cert | Master_SSL_Cipher | Master_SSL_Key | Seconds_Behind_Master | Master_SSL_Verify_Server_Cert | Last_IO_Errno | Last_IO_Error | Last_SQL_Errno 
+----------------------------------+----------------+-------------+-------------+---------------+------------------+---------------------+-------------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+--------------------+------------------------+-------------------------+-----------------------------+------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+---------------------+-----------------+-----------------+----------------+---------------+--------------------+--------------------+--------------------+-----------------+-------------------+----------------+-----------------------+-------------------------------+---------------+---------------+----------------
| Waiting for master to send event | 192.xxx.xx.xxx | mysqlrepl   |        3306 |            60 | mysql-bin.000004 |                1271 | mysqld-relay-bin.000009 |           782 | mysql-bin.000004      | Yes              | No                |                 |                     |                    |                        |                         |                             |       1265 | Error 'Data truncated for column 't_date' at row 1' on query. Default database: 'db_test'. Query: 'INSERT INTO tbl_test_pat_0001 (t_key, t_date) VALUES ('test1', '0000-00-00')' |            0 |                 619 |            1655 | None            |                |             0 | No                 |                    |                    |                 |                   |                |                  NULL | No                            |             0 |               |           1265 
+----------------------------------+----------------+-------------+-------------+---------------+------------------+---------------------+-------------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+--------------------+------------------------+-------------------------+-----------------------------+------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+---------------------+-----------------+-----------------+----------------+---------------+--------------------+--------------------+--------------------+-----------------+-------------------+----------------+-----------------------+-------------------------------+---------------+---------------+----------------

+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------+------------------+--------------------------------------+----------------------------+-----------+---------------------+-------------------------+--------------------+-------------+-------------------------+--------------------------+----------------+--------------------+--------------------+-------------------+---------------+
| Last_SQL_Error                                                                                                                                                                   | Replicate_Ignore_Server_Ids | Master_Server_Id | Master_UUID                          | Master_Info_File           | SQL_Delay | SQL_Remaining_Delay | Slave_SQL_Running_State | Master_Retry_Count | Master_Bind | Last_IO_Error_Timestamp | Last_SQL_Error_Timestamp | Master_SSL_Crl | Master_SSL_Crlpath | Retrieved_Gtid_Set | Executed_Gtid_Set | Auto_Position |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------+------------------+--------------------------------------+----------------------------+-----------+---------------------+-------------------------+--------------------+-------------+-------------------------+--------------------------+----------------+--------------------+--------------------+-------------------+---------------+
| Error 'Data truncated for column 't_date' at row 1' on query. Default database: 'db_test'. Query: 'INSERT INTO tbl_test_pat_0001 (t_key, t_date) VALUES ('test1', '0000-00-00')' |                             |                1 | 74b2a2be-f9f4-11e4-a61b-080027a71240 | /var/lib/mysql/master.info |         0 |                NULL |                         |              86400 |             |                         | 150515 18:53:00          |                |                    |                    |                   |             0 |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------+------------------+--------------------------------------+----------------------------+-----------+---------------------+-------------------------+--------------------+-------------+-------------------------+--------------------------+----------------+--------------------+--------------------+-------------------+---------------+



マスターのバイナリーログ:
mysqlbinlog --no-defaults --base64-output=DECODE-ROWS  /var/lib/mysql/mysql-bin.000004
----------------------------------------------------------------------
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#150515 18:50:39 server id 1  end_log_pos 120 CRC32 0xe6214c43  Start: binlog v 4, server v 5.6.24-log created 150515 18:50:39
# at 120
#150515 18:51:57 server id 1  end_log_pos 223 CRC32 0xcab13bf3  Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683517/*!*/;
SET @@session.pseudo_thread_id=27116/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=1075838976/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C utf8mb4 *//*!*/;
SET @@session.character_set_client=45,@@session.collation_connection=45,@@session.collation_server=8/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
CREATE DATABASE db_test
/*!*/;
# at 223
#150515 18:52:36 server id 1  end_log_pos 619 CRC32 0x02cfcc06  Query   thread_id=27116 exec_time=0     error_code=0
use `db_test`/*!*/;
SET TIMESTAMP=1431683556/*!*/;
CREATE TABLE `tbl_test_pat_0001` (
        `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
        `t_key` VARCHAR(255) NOT NULL,
        `t_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
        PRIMARY KEY (`id`),
        UNIQUE KEY `uidx_tbl_test_t_key_t_date` (`t_key`,`t_date`)
) ENGINE=mroonga DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
/*!*/;
# at 619
#150515 18:52:59 server id 1  end_log_pos 704 CRC32 0x0cf89b7b  Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683579/*!*/;
BEGIN
/*!*/;
# at 704
# at 736
#150515 18:52:59 server id 1  end_log_pos 736 CRC32 0x032b978c  Intvar
SET INSERT_ID=1/*!*/;
#150515 18:52:59 server id 1  end_log_pos 892 CRC32 0x247cad6d  Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683579/*!*/;
INSERT INTO tbl_test_pat_0001 (t_key, t_date) VALUES ('test1', '0000-00-00')
/*!*/;
# at 892
#150515 18:52:59 server id 1  end_log_pos 978 CRC32 0x359842b6  Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683579/*!*/;
COMMIT
/*!*/;
# at 978
#150515 18:53:07 server id 1  end_log_pos 1063 CRC32 0xd0069832         Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683587/*!*/;
BEGIN
/*!*/;
# at 1063
#150515 18:53:07 server id 1  end_log_pos 1185 CRC32 0xf6b48044         Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683587/*!*/;
DELETE FROM tbl_test_pat_0001 WHERE id = 1
/*!*/;
# at 1185
#150515 18:53:07 server id 1  end_log_pos 1271 CRC32 0xe86b0a23         Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683587/*!*/;
COMMIT
/*!*/;
# at 1271
#150515 18:53:49 server id 1  end_log_pos 1377 CRC32 0x63eff456         Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683629/*!*/;
CREATE DATABASE db_test2
/*!*/;
# at 1377
#150515 18:59:49 server id 1  end_log_pos 1424 CRC32 0xf85836fc         Rotate to mysql-bin.000005  pos: 4
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
----------------------------------------------------------------------
マスターのバイナリーログログ終わり。



スレーブのリレーログ
mysqlbinlog --no-defaults --base64-output=DECODE-ROWS  /var/lib/mysql/mysqld-relay-bin.000009
----------------------------------------------------------------------
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; mysqlbinlog --no-defaults -uroot --base64-output=DECODE-ROWS  /var/lib/mysql/mysql-bin.000004
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#150515 18:50:39 server id 1  end_log_pos 120 CRC32 0xe6214c43  Start: binlog v 4, server v 5.6.24-log created 150515 18:50:39
# at 120
#150515 18:51:57 server id 1  end_log_pos 223 CRC32 0xcab13bf3  Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683517/*!*/;
SET @@session.pseudo_thread_id=27116/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=1075838976/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C utf8mb4 *//*!*/;
SET @@session.character_set_client=45,@@session.collation_connection=45,@@session.collation_server=8/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
CREATE DATABASE db_test
/*!*/;
# at 223
#150515 18:52:36 server id 1  end_log_pos 619 CRC32 0x02cfcc06  Query   thread_id=27116 exec_time=0     error_code=0
use `db_test`/*!*/;
SET TIMESTAMP=1431683556/*!*/;
CREATE TABLE `tbl_test_pat_0001` (
        `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
        `t_key` VARCHAR(255) NOT NULL,
        `t_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
        PRIMARY KEY (`id`),
        UNIQUE KEY `uidx_tbl_test_t_key_t_date` (`t_key`,`t_date`)
) ENGINE=mroonga DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
/*!*/;
# at 619
#150515 18:52:59 server id 1  end_log_pos 704 CRC32 0x0cf89b7b  Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683579/*!*/;
BEGIN
/*!*/;
# at 704
# at 736
#150515 18:52:59 server id 1  end_log_pos 736 CRC32 0x032b978c  Intvar
SET INSERT_ID=1/*!*/;
#150515 18:52:59 server id 1  end_log_pos 892 CRC32 0x247cad6d  Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683579/*!*/;
INSERT INTO tbl_test_pat_0001 (t_key, t_date) VALUES ('test1', '0000-00-00')
/*!*/;
# at 892
#150515 18:52:59 server id 1  end_log_pos 978 CRC32 0x359842b6  Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683579/*!*/;
COMMIT
/*!*/;
# at 978
#150515 18:53:07 server id 1  end_log_pos 1063 CRC32 0xd0069832         Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683587/*!*/;
BEGIN
/*!*/;
# at 1063
#150515 18:53:07 server id 1  end_log_pos 1185 CRC32 0xf6b48044         Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683587/*!*/;
DELETE FROM tbl_test_pat_0001 WHERE id = 1
/*!*/;
# at 1185
#150515 18:53:07 server id 1  end_log_pos 1271 CRC32 0xe86b0a23         Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683587/*!*/;
COMMIT
/*!*/;
# at 1271
#150515 18:53:49 server id 1  end_log_pos 1377 CRC32 0x63eff456         Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683629/*!*/;
CREATE DATABASE db_test2
/*!*/;
# at 1377
#150515 18:59:49 server id 1  end_log_pos 1424 CRC32 0xf85836fc         Rotate to mysql-bin.000005  pos: 4
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; mysqlbinlog --no-defaults -uroot --base64-output=DECODE-ROWS  /var/lib/mysql/mysql-bin.000004
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#150515 18:50:39 server id 1  end_log_pos 120 CRC32 0xe6214c43  Start: binlog v 4, server v 5.6.24-log created 150515 18:50:39
# at 120
#150515 18:51:57 server id 1  end_log_pos 223 CRC32 0xcab13bf3  Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683517/*!*/;
SET @@session.pseudo_thread_id=27116/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=1075838976/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C utf8mb4 *//*!*/;
SET @@session.character_set_client=45,@@session.collation_connection=45,@@session.collation_server=8/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
CREATE DATABASE db_test
/*!*/;
# at 223
#150515 18:52:36 server id 1  end_log_pos 619 CRC32 0x02cfcc06  Query   thread_id=27116 exec_time=0     error_code=0
use `db_test`/*!*/;
SET TIMESTAMP=1431683556/*!*/;
CREATE TABLE `tbl_test_pat_0001` (
        `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
        `t_key` VARCHAR(255) NOT NULL,
        `t_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
        PRIMARY KEY (`id`),
        UNIQUE KEY `uidx_tbl_test_t_key_t_date` (`t_key`,`t_date`)
) ENGINE=mroonga DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
/*!*/;
# at 619
#150515 18:52:59 server id 1  end_log_pos 704 CRC32 0x0cf89b7b  Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683579/*!*/;
BEGIN
/*!*/;
# at 704
# at 736
#150515 18:52:59 server id 1  end_log_pos 736 CRC32 0x032b978c  Intvar
SET INSERT_ID=1/*!*/;
#150515 18:52:59 server id 1  end_log_pos 892 CRC32 0x247cad6d  Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683579/*!*/;
INSERT INTO tbl_test_pat_0001 (t_key, t_date) VALUES ('test1', '0000-00-00')
/*!*/;
# at 892
#150515 18:52:59 server id 1  end_log_pos 978 CRC32 0x359842b6  Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683579/*!*/;
COMMIT
/*!*/;
# at 978
#150515 18:53:07 server id 1  end_log_pos 1063 CRC32 0xd0069832         Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683587/*!*/;
BEGIN
/*!*/;
# at 1063
#150515 18:53:07 server id 1  end_log_pos 1185 CRC32 0xf6b48044         Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683587/*!*/;
DELETE FROM tbl_test_pat_0001 WHERE id = 1
/*!*/;
# at 1185
#150515 18:53:07 server id 1  end_log_pos 1271 CRC32 0xe86b0a23         Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683587/*!*/;
COMMIT
/*!*/;
# at 1271
#150515 18:53:49 server id 1  end_log_pos 1377 CRC32 0x63eff456         Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683629/*!*/;
CREATE DATABASE db_test2
/*!*/;
# at 1377
#150515 18:59:49 server id 1  end_log_pos 1424 CRC32 0xf85836fc         Rotate to mysql-bin.000005  pos: 4
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
DELIMITER /*!*/;
# at 4
#150514 14:22:19 server id 2  end_log_pos 120 CRC32 0x1c200bb2  Start: binlog v 4, server v 5.6.24 created 150514 14:22:19
# at 120
#150514 14:22:19 server id 1  end_log_pos 0 CRC32 0x023922f9    Rotate to mysql-bin.000004  pos: 4
# at 167
#150515 18:50:39 server id 1  end_log_pos 120 CRC32 0xe6214c43  Start: binlog v 4, server v 5.6.24-log created 150515 18:50:39
# at 283
#150515 18:51:57 server id 1  end_log_pos 223 CRC32 0xcab13bf3  Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683517/*!*/;
SET @@session.pseudo_thread_id=27116/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=1075838976/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C utf8mb4 *//*!*/;
SET @@session.character_set_client=45,@@session.collation_connection=45,@@session.collation_server=8/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
CREATE DATABASE db_test
/*!*/;
# at 386
#150515 18:52:36 server id 1  end_log_pos 619 CRC32 0x02cfcc06  Query   thread_id=27116 exec_time=0     error_code=0
use `db_test`/*!*/;
SET TIMESTAMP=1431683556/*!*/;
CREATE TABLE `tbl_test_pat_0001` (
        `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
        `t_key` VARCHAR(255) NOT NULL,
        `t_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
        PRIMARY KEY (`id`),
        UNIQUE KEY `uidx_tbl_test_t_key_t_date` (`t_key`,`t_date`)
) ENGINE=mroonga DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
/*!*/;
# at 782
#150515 18:52:59 server id 1  end_log_pos 704 CRC32 0x0cf89b7b  Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683579/*!*/;
BEGIN
/*!*/;
# at 867
# at 899
#150515 18:52:59 server id 1  end_log_pos 736 CRC32 0x032b978c  Intvar
SET INSERT_ID=1/*!*/;
#150515 18:52:59 server id 1  end_log_pos 892 CRC32 0x247cad6d  Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683579/*!*/;
INSERT INTO tbl_test_pat_0001 (t_key, t_date) VALUES ('test1', '0000-00-00')
/*!*/;
# at 1055
#150515 18:52:59 server id 1  end_log_pos 978 CRC32 0x359842b6  Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683579/*!*/;
COMMIT
/*!*/;
# at 1141
#150515 18:53:07 server id 1  end_log_pos 1063 CRC32 0xd0069832         Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683587/*!*/;
BEGIN
/*!*/;
# at 1226
#150515 18:53:07 server id 1  end_log_pos 1185 CRC32 0xf6b48044         Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683587/*!*/;
DELETE FROM tbl_test_pat_0001 WHERE id = 1
/*!*/;
# at 1348
#150515 18:53:07 server id 1  end_log_pos 1271 CRC32 0xe86b0a23         Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683587/*!*/;
COMMIT
/*!*/;
# at 1434
#150515 18:53:49 server id 1  end_log_pos 1377 CRC32 0x63eff456         Query   thread_id=27116 exec_time=0     error_code=0
SET TIMESTAMP=1431683629/*!*/;
CREATE DATABASE db_test2
/*!*/;
# at 1540
#150514 14:22:19 server id 2  end_log_pos 1594 CRC32 0xfed305a7         Rotate to mysqld-relay-bin.000010  pos: 4
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
----------------------------------------------------------------------
スレーブのリレーログ終わり。

これでどうでしょうか?



----
各務 
kagam****@outwa*****




groonga-dev メーリングリストの案内
Back to archive index