The one place for your designs
To upload designs, you'll need to enable LFS. More information
Errors during initial creation of MySQL database cluster (1.6.0)
NOTE: I DO NOT KNOW IF THIS IS RELATED TO CHANGING THE MySQL "ENGINE" from INNODB to NDBCLUSTER, but anyone's knowledge of MySQL is going to be better than mine.
When running a slightly modified dhcpdb_create.mysql, there are some errors:
ERROR 1215 (HY000) at line 1034 in file: 'dhcpdb_create.mysql': Cannot add foreign key constraint
ERROR 1215 (HY000) at line 1305 in file: 'dhcpdb_create.mysql': Cannot add foreign key constraint
ERROR 1146 (42S02) at line 1440 in file: 'dhcpdb_create.mysql': Table 'kea.dhcp4_options_server' doesn't exist
ERROR 1146 (42S02) at line 1443 in file: 'dhcpdb_create.mysql': Table 'kea.dhcp4_options_server' doesn't exist
ERROR 1146 (42S02) at line 1485 in file: 'dhcpdb_create.mysql': Table 'kea.dhcp6_options_server' doesn't exist
ERROR 1146 (42S02) at line 1488 in file: 'dhcpdb_create.mysql': Table 'kea.dhcp6_options_server' doesn't existThe modification made is as follows:
sed s:INNODB:NDBCLUSTER: < /usr/share/kea/scripts/mysql/dhcpdb_create.mysql > ~/dhcpdb_create.mysqlSoftware Versions:
Kea 1.6, Docker 19.03.1 and mysql-5.7.27/ndb-7.6.11OS:
Linux debian-10 4.19.0-5-amd64 #1 SMP Debian 4.19.37-5+deb10u1 (2019-07-19) x86_64 GNU/LinuxSee currently un-published KB article "Testing Kea and MySQL Clustering using Docker"
Full output follows:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 45
Server version: 5.7.27-ndb-7.6.11-cluster-gpl MySQL Cluster Community Server (GPL)
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MySQL [(none)]> connect kea;
Connection id: 46
Current database: kea
MySQL [kea]> source dhcpdb_create.mysql;
Query OK, 0 rows affected (0.155 sec)
Query OK, 0 rows affected (0.147 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.187 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.148 sec)
Query OK, 0 rows affected (0.176 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.151 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 1 row affected (0.003 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 0 rows affected (0.145 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 1 row affected (0.002 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 0 rows affected, 3 warnings (0.201 sec)
Records: 0 Duplicates: 0 Warnings: 3
Query OK, 0 rows affected (0.153 sec)
Query OK, 1 row affected (0.003 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 1 row affected (0.004 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 0 rows affected (0.189 sec)
Query OK, 0 rows affected (0.156 sec)
Query OK, 0 rows affected (0.206 sec)
Query OK, 0 rows affected (0.216 sec)
Query OK, 0 rows affected (0.009 sec)
Query OK, 1 row affected (0.002 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 0 rows affected (0.383 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.376 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.213 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.183 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.170 sec)
Query OK, 1 row affected (0.002 sec)
Query OK, 1 row affected (0.003 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 0 rows affected (0.170 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.176 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.191 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 1 row affected (0.006 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 1 row affected (0.003 sec)
Query OK, 8 rows affected (0.463 sec)
Records: 8 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.218 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected, 1 warning (0.005 sec)
Query OK, 0 rows affected (0.004 sec)
Query OK, 0 rows affected, 1 warning (0.001 sec)
Query OK, 0 rows affected (0.003 sec)
Query OK, 0 rows affected, 1 warning (0.001 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 0 rows affected, 1 warning (0.007 sec)
Query OK, 0 rows affected (0.002 sec)
Query OK, 1 row affected (0.003 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 1 row affected (0.004 sec)
Query OK, 1 row affected (0.002 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 0 rows affected (0.177 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.235 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.189 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.252 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.412 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.272 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.264 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 1 row affected (0.003 sec)
Query OK, 1 row affected (0.002 sec)
Query OK, 1 row affected (0.002 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 0 rows affected (0.270 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (1.127 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (1.147 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (1.126 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.128 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 1 row affected (0.002 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 0 rows affected (0.884 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.198 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.589 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.182 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.583 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected, 1 warning (0.146 sec)
Records: 0 Duplicates: 0 Warnings: 1
Query OK, 0 rows affected, 1 warning (0.135 sec)
Records: 0 Duplicates: 0 Warnings: 1
Query OK, 0 rows affected, 1 warning (0.139 sec)
Records: 0 Duplicates: 0 Warnings: 1
Query OK, 1 row affected (0.002 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 1 row affected (0.002 sec)
Query OK, 1 row affected (0.002 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 1 row affected (0.002 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 0 rows affected (0.622 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.619 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 1 row affected (0.002 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 0 rows affected (0.733 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.639 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.668 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.180 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.181 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.202 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.154 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.117 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.140 sec)
Query OK, 0 rows affected (0.013 sec)
Query OK, 0 rows affected (0.013 sec)
Query OK, 0 rows affected (0.012 sec)
Query OK, 1 row affected (0.006 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 0 rows affected (0.664 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.613 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.003 sec)
Query OK, 0 rows affected (0.002 sec)
Query OK, 0 rows affected (0.002 sec)
Query OK, 0 rows affected (0.003 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 0 rows affected (0.002 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 0 rows affected (0.002 sec)
Query OK, 0 rows affected, 1 warning (0.144 sec)
Query OK, 0 rows affected (0.152 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected, 1 warning (0.136 sec)
Records: 0 Duplicates: 0 Warnings: 1
Query OK, 1 row affected (0.002 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 0 rows affected (0.017 sec)
Query OK, 1 row affected (0.003 sec)
Query OK, 1 row affected (0.004 sec)
Query OK, 1 row affected (0.002 sec)
Query OK, 0 rows affected (0.022 sec)
Query OK, 1 row affected (0.002 sec)
Query OK, 0 rows affected (0.032 sec)
Query OK, 0 rows affected (0.032 sec)
Query OK, 0 rows affected (0.035 sec)
Query OK, 0 rows affected (0.031 sec)
Query OK, 0 rows affected (0.034 sec)
Query OK, 0 rows affected (0.048 sec)
Query OK, 0 rows affected (0.023 sec)
Query OK, 0 rows affected (0.044 sec)
Query OK, 0 rows affected (0.029 sec)
Query OK, 0 rows affected (0.032 sec)
Query OK, 0 rows affected (0.661 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.604 sec)
Records: 0 Duplicates: 0 Warnings: 0
ERROR 1215 (HY000) at line 1034 in file: 'dhcpdb_create.mysql': Cannot add foreign key constraint
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.026 sec)
Query OK, 1 row affected (0.003 sec)
Query OK, 0 rows affected (0.035 sec)
Query OK, 0 rows affected (0.029 sec)
Query OK, 0 rows affected (0.030 sec)
Query OK, 0 rows affected (0.018 sec)
Query OK, 0 rows affected (0.031 sec)
Query OK, 0 rows affected (0.032 sec)
Query OK, 0 rows affected (0.037 sec)
Query OK, 0 rows affected (0.035 sec)
Query OK, 0 rows affected (0.028 sec)
Query OK, 0 rows affected (0.030 sec)
Query OK, 0 rows affected (0.027 sec)
Query OK, 0 rows affected (0.650 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.657 sec)
Records: 0 Duplicates: 0 Warnings: 0
ERROR 1215 (HY000) at line 1305 in file: 'dhcpdb_create.mysql': Cannot add foreign key constraint
Query OK, 0 rows affected (0.007 sec)
Query OK, 1 row affected (0.004 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 0 rows affected (0.623 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.607 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.045 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.031 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.044 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.032 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.039 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.035 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.035 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.047 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.031 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.038 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.035 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.036 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.007 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.044 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.007 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.047 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.007 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.055 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.007 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.036 sec)
Records: 0 Duplicates: 0 Warnings: 0
ERROR 1146 (42S02) at line 1440 in file: 'dhcpdb_create.mysql': Table 'kea.dhcp4_options_server' doesn't exist
ERROR 1146 (42S02) at line 1443 in file: 'dhcpdb_create.mysql': Table 'kea.dhcp4_options_server' doesn't exist
Query OK, 0 rows affected (0.007 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.047 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.007 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.042 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.008 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.051 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.007 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.052 sec)
Records: 0 Duplicates: 0 Warnings: 0
ERROR 1146 (42S02) at line 1485 in file: 'dhcpdb_create.mysql': Table 'kea.dhcp6_options_server' doesn't exist
ERROR 1146 (42S02) at line 1488 in file: 'dhcpdb_create.mysql': Table 'kea.dhcp6_options_server' doesn't exist
Query OK, 0 rows affected (0.024 sec)
Query OK, 0 rows affected (0.034 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.033 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.048 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected, 1 warning (0.001 sec)
Query OK, 0 rows affected (0.002 sec)
Query OK, 0 rows affected, 1 warning (0.001 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.005 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.009 sec)
Query OK, 0 rows affected, 1 warning (0.001 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 0 rows affected (0.010 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 0 rows affected (0.015 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 1 row affected (0.004 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 0 rows affected (0.002 sec)
Query OK, 0 rows affected (0.054 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.052 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.033 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.054 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.009 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.012 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.007 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.015 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.007 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.007 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.040 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.049 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.046 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.007 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.010 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.048 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.007 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.050 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.007 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.040 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.025 sec)
Query OK, 0 rows affected (0.037 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.028 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.044 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected, 1 warning (0.001 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 0 rows affected, 1 warning (0.001 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 0 rows affected (0.005 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 0 rows affected (0.010 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.005 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.008 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected, 1 warning (0.001 sec)
Query OK, 0 rows affected (0.002 sec)
Query OK, 0 rows affected (0.009 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 0 rows affected (0.008 sec)
Query OK, 1 row affected (0.002 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 0 rows affected (0.034 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.036 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.034 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.053 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.007 sec)
Query OK, 0 rows affected (0.005 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.742 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 1 row affected (0.002 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 0 rows affected (0.005 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.004 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.007 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.037 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.004 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.003 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 0 rows affected (0.008 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.010 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.044 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.039 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.043 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.027 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.032 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.002 sec)
Query OK, 0 rows affected (0.002 sec)
Query OK, 0 rows affected (0.005 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 0 rows affected (0.005 sec)
Query OK, 0 rows affected (0.008 sec)
Query OK, 0 rows affected (0.005 sec)
Query OK, 0 rows affected (0.008 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 0 rows affected (0.005 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 0 rows affected (0.005 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 1 row affected (0.002 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MySQL [kea]> quit
Bye