1
2
3
4
5
6
|
mysql> show variables like
'%max_connection%'
;
| Variable_name | Value |
max_connections | 151 |
mysql>
set
global max_connections=1;Query OK, 0 rows affected (0.00 sec)
[root@node4 ~]
# mysql -uzs -p123456 -h 192.168.56.132
ERROR 1040 (00000): Too many connections
|
1
2
3
4
5
|
Last_Errno: 1062
Last_Error: Could not execute Write_rows event on table
test
.t;
Duplicate entry
'4'
for
key
'PRIMARY'
,
Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY;
the event's master log mysql-bin.000014, end_log_pos 1505
|
1
2
3
4
5
|
Last_IO_Error:
Fatal error: The slave I
/O
thread stops because master and slave have equal MySQL server ids;
these ids must be different
for
replication to work
(or the --replicate-same-server-
id
option must be used on slave but this
does not always
make
sense; please check the manual before using it)
|
1
2
3
4
|
Last_SQL_Error:
Could
not
execute
Update_rows event
on
table
test.t; Can
't find record
in '
t
', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the
event'
s master log mysql-bin.000014, end_log_pos 1708
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
#170720 14:20:15 server id 3 end_log_pos 1708 CRC32 0x97b6bdec Update_rows: table id 113 flags: STMT_END_F
### UPDATE `test`.`t`
### WHERE
### @1=4 /* INT meta=0 nullable=0 is_null=0 */
### @2='dd' /* VARSTRING(60) meta=60 nullable=1 is_null=0 */
### SET
### @1=4 /* INT meta=0 nullable=0 is_null=0 */
### @2='ddd' /* VARSTRING(60) meta=60 nullable=1 is_null=0 */
# at 1708
#170720 14:20:15 server id 3 end_log_pos 1739 CRC32 0xecaf1922 Xid = 654
COMMIT/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
|
1
2
3
4
5
6
7
8
9
10
|
[root@zs data]
# /usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my.cnf &[1] 3758
[root@zs data]
# 170720 14:41:24 mysqld_safe Logging to '/data/mysql/error.log'.
170720 14:41:24 mysqld_safe Starting mysqld daemon with databases from
/data/mysql170720
14:41:25 mysqld_safe mysqld from pid
file
/data/mysql/node4
.pid ended
170720 14:41:24 mysqld_safe Starting mysqld daemon with databases from
/data/mysql2017-07-20
14:41:25 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated.
Please use --explicit_defaults_for_timestamp server option
(see documentation
for
more
details).
/usr/local/mysql/bin/mysqld
:
File
'/data/mysql/mysql-bin.index'
not found (Errcode: 13 - Permission denied)
2017-07-20 14:41:25 4388 [ERROR] Aborting
|
1
2
3
4
5
6
|
[root@zs ~]
# mysql -uroot -p
Enter password:
ERROR 1045 (28000): Access denied
for
user
'root'
@
'localhost'
(using password: YES)
[root@zs ~]
# mysql -uroot -p
Enter password:
ERROR 1045 (28000): Access denied
for
user
'root'
@
'localhost'
(using password: YES)
|
1
2
3
4
5
6
|
CREATE
TABLE
`t` (
`a`
int
(11)
NOT
NULL
AUTO_INCREMENT,
`b`
varchar
(20)
DEFAULT
NULL
,
PRIMARY
KEY
(`a`),
KEY
`b` (`b`)
) ENGINE=InnoDB AUTO_INCREMENT=300
DEFAULT
CHARSET=utf8
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
mysql>
insert
into
t (b)
values
(
'aa'
);
Query OK, 1 row affected (0.00 sec)
mysql>
insert
into
t (b)
values
(
'bb'
);
Query OK, 1 row affected (0.00 sec)
mysql>
insert
into
t (b)
values
(
'cc'
);
Query OK, 1 row affected (0.00 sec)
mysql>
select
*
from
t;
+
-----+------+
| a | b |
+
-----+------+
| 300 | aa |
| 301 | bb |
| 302 | cc |
+
-----+------+
3
rows
in
set
(0.00 sec)
|
1
2
3
4
5
6
7
8
9
|
Caused by: java.sql.SQLException: Incorrect string value:
'\xF0\x9F\x98\x97\xF0\x9F...'
for
column
'CONTENT'
at row 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2734)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1379)
|
1
2
3
4
5
6
7
8
|
org.hibernate.util.JDBCExceptionReporter - SQL Error:0, SQLState: 08S01
org.hibernate.util.JDBCExceptionReporter - The last packet successfully received from the server was43200 milliseconds ago.The last packet sent successfully to the server was 43200 milliseconds ago,
which
is longer than the server configured value of
'wait_timeout'
. You should consider either expiring and
/or
testing connection validity before use
in
your application, increasing the server configured values
for
client timeouts, or using the Connector
/J
connection
'autoReconnect=true'
to avoid this problem.
org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
org.hibernate.exception.JDBCConnectionException: Could not execute JDBC batch update
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Connection.close() has already been called. Invalid operation
in
this state.
org.hibernate.util.JDBCExceptionReporter - SQL Error:0, SQLState: 08003
org.hibernate.util.JDBCExceptionReporter - No operations allowed after connection closed. Connection was implicitly closed due to underlying exception
/error
:
** BEGIN NESTED EXCEPTION **
|