linux 后台日志 mysql 错误异常的解释(推荐)
1、Causedby:com.MySQL.jdbc.exceptions.jdbc4.CommunicationsException:
Thelastpacketsuccessfullyreceivedfromtheserverwas56,201,339millisecondsago. Thelastpacketsentsuccessfullytotheserverwas56,201,339millisecondsago.islongerthantheserverconfiguredvalueof'wait_timeout'.Youshouldconsidereitherexpiringand/ortestingconnectionvaliditybeforeuseinyourapplication,increasingtheserverconfiguredvaluesforclienttimeouts,orusingtheConnector/Jconnectionproperty'autoReconnect=true'toavoidthisproblem.
atsun.reflect.GeneratedConstructorAccessor257.newInstance(UnknownSource)
atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
atjava.lang.reflect.Constructor.newInstance(Constructor.java:534)
atcom.mysql.jdbc.Util.handleNewInstance(Util.java:406)
atcom.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
atcom.mysql.jdbc.MysqlIO.send(MysqlIO.java:3291)
atcom.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1938)
atcom.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)
atcom.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
atcom.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2086)
atcom.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2237)
atorg.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
atorg.hibernate.loader.Loader.getResultSet(Loader.java:1787)
atorg.hibernate.loader.Loader.doQuery(Loader.java:674)
atorg.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
atorg.hibernate.loader.Loader.doList(Loader.java:2213)
...45more
解释:
最后从服务器接收到数据包成功是56201339毫秒。最后一个数据包发送成功服务器56201339毫秒。长于服务器配置“wait_timeout”的价值。你应该考虑到期和/或有效性测试连接在应用程序中使用之前,增加服务器为客户机超时配置值,或使用连接器/J连接属性“autoReconnect=true”来避免这个问题。
Linux下/etc/mysql/mysql.cnf
mysql.cnf文件
#
#TheMySQLdatabaseserverconfigurationfile.
#
#Youcancopythistooneof:
#-"/etc/mysql/my.cnf"tosetglobaloptions,
#-"~/.my.cnf"tosetuser-specificoptions.
#
#Onecanusealllongoptionsthattheprogramsupports.
#Runprogramwith--helptogetalistofavailableoptionsandwith
#--print-defaultstoseewhichitwouldactuallyunderstandanduse.
#
#Forexplanationssee
#http://dev.mysql.com/doc/mysql/en/server-system-variables.html
#Thiswillbepassedtoallmysqlclients
#Ithasbeenreportedthatpasswordsshouldbeenclosedwithticks/quotes
#escpeciallyiftheycontain"#"chars...
#Remembertoedit/etc/mysql/debian.cnfwhenchangingthesocketlocation.
[client]
port=3306
socket=/var/run/mysqld/mysqld.sock
#Hereisentriesforsomespecificprograms
#Thefollowingvaluesassumeyouhaveatleast32Mram
#Thiswasformallyknownas[safe_mysqld].Bothversionsarecurrentlyparsed.
[mysqld_safe]
socket=/var/run/mysqld/mysqld.sock
nice=0
[mysqld]
wait_timeout=86400000
interactive_timeout=86400000
#
#*BasicSettings
#
user=mysql
pid-file=/var/run/mysqld/mysqld.pid
socket=/var/run/mysqld/mysqld.sock
port=3306
basedir=/usr
datadir=/var/lib/mysql
tmpdir=/tmp
lc-messages-dir=/usr/share/mysql
skip-external-locking
#
#Insteadofskip-networkingthedefaultisnowtolistenonlyon
#localhostwhichismorecompatibleandisnotlesssecure.
#bind-address=127.0.0.1
bind-address=0.0.0.0
#
#*FineTuning
#
key_buffer=16M
max_allowed_packet=16M
thread_stack=192K
thread_cache_size =8
#ThisreplacesthestartupscriptandchecksMyISAMtablesifneeded
#thefirsttimetheyaretouched
myisam-recover =BACKUP
#max_connections =100
max_connections =10000
#table_cache =64
#thread_concurrency =10
#
#*QueryCacheConfiguration
#
query_cache_limit=1M
query_cache_size =16M
#
#*LoggingandReplication
#
#Bothlocationgetsrotatedbythecronjob.
#Beawarethatthislogtypeisaperformancekiller.
#Asof5.1youcanenablethelogatruntime!
#general_log_file =/var/log/mysql/mysql.log
#general_log =1
#
#Errorlog-shouldbeveryfewentries.
#
log_error=/var/log/mysql/error.log
#
#Hereyoucanseequerieswithespeciallylongduration
#log_slow_queries=/var/log/mysql/mysql-slow.log
#long_query_time=2
#log-queries-not-using-indexes
#
#Thefollowingcanbeusedaseasytoreplaybackuplogsorforreplication.
#note:ifyouaresettingupareplicationslave,seeREADME.Debianabout
# othersettingsyoumayneedtochange.
#server-id=1
log_bin=/var/log/mysql/mysql-bin.log
expire_logs_days=14
max_binlog_size =100M
#binlog_do_db=include_database_name
#binlog_ignore_db=include_database_name
#
#*InnoDB
#
#InnoDBisenabledbydefaultwitha10MBdatafilein/var/lib/mysql/.
#ReadthemanualformoreInnoDBrelatedoptions.Therearemany!
#
#*SecurityFeatures
#
#Readthemanual,too,ifyouwantchroot!
#chroot=/var/lib/mysql/
#
#ForgeneratingSSLcertificatesIrecommendtheOpenSSLGUI"tinyca".
#
#ssl-ca=/etc/mysql/cacert.pem
#ssl-cert=/etc/mysql/server-cert.pem
#ssl-key=/etc/mysql/server-key.pem
[mysqldump]
quick
quote-names
max_allowed_packet=16M
[mysql]
#no-auto-rehash#fasterstartofmysqlbutnotabcompletition
[isamchk]
key_buffer=16M
#
#*IMPORTANT:Additionalsettingsthatcanoverridethosefromthisfile!
# Thefilesmustendwith'.cnf',otherwisethey'llbeignored.
#
!includedir/etc/mysql/conf.d/
lower_case_table_names=1
以上就是小编为大家带来的linux后台日志mysql错误异常的解释(推荐)全部内容了,希望大家多多支持毛票票~