Define the method to execute in the mapper file
@Repository
public interface ZbArticleCEIResultPerformanceMapper extends BaseMapper<ZbArticleCEIResultPerformance> {
@Select({"${sql}"})
@ResultType(ArrayList.class)
List<ZbArticleCEIResultPerformance> executeQuery(@Param("sql") String sql);
}
Click “blue word” above
Pay attention to us and enjoy more dry goods!
The customer has a set of Oracle 19C DataGuard database environment. The standby side always has large gap at intervals. At the same time, LGWR (ospid: 105521) waits for event ‘DLM cross Inst call completion’ for n secs. The standby side does not provide external queries. At the same time, multi instance log applications are disabled, and the operating system resources are idle, The number of LMS processes is normal. If other nodes are shut down, leaving only the apply log does not exist. DLM is a distributed lock manager, which belongs to the core mechanism of Rac architecture. It realizes multi node resource sharing scheduling and transmits requests through the interconnect network. Here is a brief record of this case:
db alert log
PR00 (PID:109603): Media Recovery Log +ARCH/anbob1/ARCHIVELOG/2021_07_12/thread_3_seq_13586.1479.1077669291
2021-07-12T20:25:29.643687+08:00
PR00 (PID:109603): Media Recovery Log +ARCH/anbob1/ARCHIVELOG/2021_07_12/thread_2_seq_14361.1072.1077669019
2021-07-12T20:29:38.183656+08:00
LGWR (ospid: 105521) waits for event 'DLM cross inst call completion' for 1 secs.
2021-07-12T20:29:48.137737+08:00
LGWR (ospid: 105521) waits for event 'DLM cross inst call completion' for 2 secs.
2021-07-12T20:31:21.952345+08:00
rfs (PID:113884): Selected LNO:26 for T-2.S-14456 dbid 3902007743 branch 1037635587
2021-07-12T20:31:21.987333+08:00
rfs (PID:114704): Error ORA-235 occurred during an un-locked control file
rfs (PID:114704): transaction. This error can be ignored. The control
rfs (PID:114704): file transaction will be retried.
2021-07-12T20:31:43.532600+08:00
ARC2 (PID:106404): Archived Log entry 9591 added for T-2.S-14455 ID 0xe894b1bf LAD:1
2021-07-12T20:31:47.151671+08:00
rfs (PID:113882): Selected LNO:31 for T-3.S-13731 dbid 3902007743 branch 1037635587
2021-07-12T20:31:49.116049+08:00
rfs (PID:113880): Selected LNO:22 for T-1.S-13006 dbid 3902007743 branch 1037635587
2021-07-12T20:31:53.393547+08:00
ARC3 (PID:106408): Archived Log entry 9592 added for T-1.S-13005 ID 0xe894b1bf LAD:1
2021-07-12T20:32:02.346585+08:00
ARC2 (PID:106404): Archived Log entry 9593 added for T-3.S-13730 ID 0xe894b1bf LAD:1
2021-07-12T20:33:13.805344+08:00
LGWR (ospid: 105521) waits for event 'DLM cross inst call completion' for 0 secs.
2021-07-12T20:33:13.805470+08:00
LGWR (ospid: 105521) is hung in an acceptable location (inwait 0x1.ffff).
2021-07-12T20:33:21.196764+08:00
LGWR (ospid: 105521) waits for event 'DLM cross inst call completion' for 2 secs.
2021-07-12T20:33:31.310737+08:00
LGWR (ospid: 105521) waits for event 'DLM cross inst call completion' for 0 secs.
2021-07-12T20:33:41.223781+08:00
LGWR (ospid: 105521) waits for event 'DLM cross inst call completion' for 1 secs.
2021-07-12T20:33:51.205776+08:00
LGWR (ospid: 105521) waits for event 'DLM cross inst call completion' for 2 secs.
2021-07-12T20:34:01.307770+08:00
LGWR (ospid: 105521) waits for event 'DLM cross inst call completion' for 0 secs.
2021-07-12T20:34:25.440231+08:00
PR00 (PID:109603): Media Recovery Log +ARCH/anbob1/ARCHIVELOG/2021_07_12/thread_2_seq_14362.1867.1077670807
2021-07-12T20:34:44.864009+08:00
PR00 (PID:109603): Media Recovery Log +ARCH/anbob1/ARCHIVELOG/2021_07_12/thread_3_seq_13587.691.1077670845
2021-07-12T20:34:45.204773+08:00
PR00 (PID:109603): Media Recovery Log +ARCH/anbob1/ARCHIVELOG/2021_07_12/thread_1_seq_12934.1156.1077670917
2021-07-12T20:36:09.378685+08:00
LGWR (ospid: 105521) waits for event 'DLM cross inst call completion' for 2 secs.
2021-07-12T20:36:19.341635+08:00
LGWR (ospid: 105521) waits for event 'DLM cross inst call completion' for 0 secs.
2021-07-12T20:36:28.416573+08:00
LGWR (ospid: 105521) waits for event 'DLM cross inst call completion' for 0 secs.
2021-07-12T20:36:38.375742+08:00
LGWR (ospid: 105521) waits for event 'DLM cross inst call completion' for 1 secs.LGWR trace
*** 2021-07-12T20:33:43.793041+08:00 ((4))
Received ORADEBUG command (#235) 'dump KSTDUMPCURPROC 1' from process '105470'
-------------------------------------------------------------------------------
Trace Bucket Dump Begin: default bucket for process 47 (osid: 105521, LGWR)
CDB_NAME(CON_ID):CON_UID:TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP:SID:SERIAL#: [EVENT#:PID] DATA
-------------------------------------------------------------------------------
IRMSDB(4):3247498417:2021-07-12 20:33:42.784 :KJCI:kjci.c@1957:kjci_complete():4466:40278: freeing request 0x20fd651e8 (inst|inc|reqid)=(1|88|823031) with opcode=146 and completion status [DONE]
IRMSDB(4):3247498417:2021-07-12 20:33:42.784 :KJCI:kjci.c@1089:kjci_initreq():4466:40278: request 0x20fd651e8 (inst|inc|reqid)=(1|88|823032) with group (type|id)=(1|1), opcode=146, flags=0x0, msglen=56, where=[kqlmClusterMessage] to target instances=
IRMSDB(4):3247498417:2021-07-12 20:33:42.784 :KJCI:kjci.c@1091:kjci_initreq():4466:40278: 1 2
IRMSDB(4):3247498417:2021-07-12 20:33:42.784 :KJCI:kjci.c@1618:kjci_processcrq():4466:40278: processing reply 0x2cff2d4e8 for request 0x20fd651e8 (inst|inc|reqid)=(1|88|823032) with opcode=146 from callee (inst|pid|psn)=(1|36|1)
IRMSDB(4):3247498417:2021-07-12 20:33:42.784 :KJCI:kjci.c@1618:kjci_processcrq():4466:40278: processing reply 0x2cff2d718 for request 0x20fd651e8 (inst|inc|reqid)=(1|88|823032) with opcode=146 from callee (inst|pid|psn)=(2|36|1)
IRMSDB(4):3247498417:2021-07-12 20:33:42.784 :KJCI:kjci.c@1957:kjci_complete():4466:40278: freeing request 0x20fd651e8 (inst|inc|reqid)=(1|88|823032) with opcode=146 and completion status [DONE]
IRMSDB(4):3247498417:2021-07-12 20:33:42.785 :KJCI:kjci.c@1089:kjci_initreq():4466:40278: request 0x20fd651e8 (inst|inc|reqid)=(1|88|823033) with group (type|id)=(1|1), opcode=146, flags=0x0, msglen=56, where=[kqlmClusterMessage] to target instances=
IRMSDB(4):3247498417:2021-07-12 20:33:42.785 :KJCI:kjci.c@1091:kjci_initreq():4466:40278: 1 2
IRMSDB(4):3247498417:2021-07-12 20:33:42.785 :KJCI:kjci.c@1618:kjci_processcrq():4466:40278: processing reply 0x2cff2d4e8 for request 0x20fd651e8 (inst|inc|reqid)=(1|88|823033) with opcode=146 from callee (inst|pid|psn)=(1|36|1)
IRMSDB(4):3247498417:2021-07-12 20:33:42.785 :KJCI:kjci.c@1618:kjci_processcrq():4466:40278: processing reply 0x2cff2d718 for request 0x20fd651e8 (inst|inc|reqid)=(1|88|823033) with opcode=146 from callee (inst|pid|psn)=(2|36|1)
IRMSDB(4):3247498417:2021-07-12 20:33:42.785 :KJCI:kjci.c@1957:kjci_complete():4466:40278: freeing request 0x20fd651e8 (inst|inc|reqid)=(1|88|823033) with opcode=146 and completion status [DONE]
IRMSDB(4):3247498417:2021-07-12 20:33:42.785 :KJCI:kjci.c@1089:kjci_initreq():4466:40278: request 0x20fd651e8 (inst|inc|reqid)=(1|88|823034) with group (type|id)=(1|1), opcode=146, flags=0x0, msglen=56, where=[kqlmClusterMessage] to target instances=
IRMSDB(4):3247498417:2021-07-12 20:33:42.785 :KJCI:kjci.c@1091:kjci_initreq():4466:40278: 1 2**KJCJ ** ==> ( kjci)_ processcrq – kernel lock management communication cross instance call
For cross node communication, there is no known bug in MOS. First analyze the network problem. You can also do SSD from the process blocker or view the hangmgr trace. The AHF framework in Oracle 19C CRS comes with OSW.
OSW netstat data
zzz ***Tue Jul 13 00:59:51 CST 2021
...
#kernel
IpInReceives 1456201695 0.0
IpInHdrErrors 0 0.0
IpInAddrErrors 0 0.0
IpForwDatagrams 0 0.0
IpInUnknownProtos 0 0.0
IpInDiscards 0 0.0
IpInDelivers 1085210966 0.0
IpOutRequests 1007206469 0.0
IpOutDiscards 5280 0.0
IpOutNoRoutes 8 0.0
IpReasmTimeout 6333500 0.0
IpReasmReqds 408470736 0.0
IpReasmOKs 37504539 0.0
IpReasmFails 8651478 0.0
IpFragOKs 29029579 0.0Note:
currently, there are high IP reorganization failure packets, which is a cumulative value. You can view the daily changes below.
View the failure of daily IP reorganization
awk '/zzz/{d=$3"/"$4" "$5}/IpReasmFails/{curr=$2;diff=curr-prev;if(diff>5)print d,diff,prev,curr;prev=curr}' *.dat
Jul/13 00:00:16 8620039 8620039
Jul/13 00:00:46 185 8620039 8620224
Jul/13 00:01:16 242 8620224 8620466
Jul/13 00:01:46 324 8620466 8620790
Jul/13 00:02:16 279 8620790 8621069
Jul/13 00:02:46 325 8621069 8621394
Jul/13 00:03:16 325 8621394 8621719
Jul/13 00:03:46 247 8621719 8621966
Jul/13 00:04:16 246 8621966 8622212
Jul/13 00:04:46 210 8622212 8622422
Jul/13 00:05:16 327 8622422 8622749
Jul/13 00:05:46 247 8622749 8622996
Jul/13 00:06:16 238 8622996 8623234
Jul/13 00:06:46 219 8623234 8623453
Jul/13 00:07:16 262 8623453 8623715
Jul/13 00:07:46 254 8623715 8623969
Jul/13 00:08:16 179 8623969 8624148
Jul/13 00:08:46 294 8624148 8624442Note:
it can be seen that there are high IP reorganization failures at ordinary times. Let’s try to use Ping to verify the network
Using Ping authentication
— on node1
ping -s 4000 {node2-privateIP}
Note:Forget to keep the historical output here. It is found that there is 12% package loss, indicating that the current and heartbeat networks are not healthy. However, the bond made of two network cards is used. At present, it is in active backup active and standby mode. You can try to switch another network card.
Network card switching
cat /proc/net/bonding/bond0Note:
Check that the current primary card is ens9f0 and switch to the standby card ens9f1
ifenslave -c bond0 ens9f1After switching between active and standby network cards: Ping is normal, IP reorganization failure disappears, DLM cross Inst call completion does not appear, DG synchronization is normal, and the problem is solved.
The spring-boot integration redis startup project reports an error with the following message:
defining a bean of type 'org.springframework.data.redis.core.RedisTemplate' in your configuration.
orConsider defining a bean of type 'org.springframework.data.redis.core.StringRedisTemplate' in your configuration.
Modify the pom file
Change the
<dependency>
<groupId>org.springframework.data</groupId>
<artifactId>spring-data-redis</artifactId>
</dependency>
is changed to
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-redis</artifactId>
</dependency>
After modification, if you want to customize redistemplate, you can refer to the following configuration
@Bean
public RedisTemplate<String, Object> template(RedisConnectionFactory factory) {
// Create RedisTemplate<String, Object>object
RedisTemplate<String, Object> template = new RedisTemplate<>();
// Configuring the connection factory
template.setConnectionFactory(factory);
// Define the Jackson2JsonRedisSerializer serialization object
Jackson2JsonRedisSerializer<Object> jacksonSeial = new Jackson2JsonRedisSerializer<>(Object.class);
ObjectMapper om = new ObjectMapper();
// Specify the field, field, get and set to be serialized, and the range of modifiers, ANY of which are included in private and public
om.setVisibility(PropertyAccessor.ALL, JsonAutoDetect.Visibility.ANY);
// Specify the type of serialized input, the class must be non-final modified, final modified class, such as String, Integer, etc. will report an exception
om.activateDefaultTyping(LaissezFaireSubTypeValidator.instance, ObjectMapper.DefaultTyping.NON_FINAL, JsonTypeInfo.As.WRAPPER_ARRAY);
jacksonSeial.setObjectMapper(om);
StringRedisSerializer stringSerial = new StringRedisSerializer();
// redis key Serialization method used stringSerial
template.setKeySerializer(stringSerial);
// redis value Serialization method usedjackson
template.setValueSerializer(jacksonSeial);
// redis hash key Serialization method usedstringSerial
template.setHashKeySerializer(stringSerial);
// redis hash value Serialization method usedjackson
template.setHashValueSerializer(jacksonSeial);
template.afterPropertiesSet();
return template;
}
Error description
$ sqlplus/as sysdba
-bash: sqlplus: command not found
Treatment method
View environment.bash_ Profile configuration
$ find -name .bash_profile
./.bash_profile
$ pwd
/home/oracle
$ vi .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH
#add by rui on 20210715
export ORACLE_BASE=/oracle/app
export ORACLE_HOME=$ORACLE_BASE/oracle/product/12.1.0/dbhome_1 --Configuration error, change to [1]
export ORACLE_SID=rui1
export PATH=$HOME/bin:$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
[1] export ORACLE_ HOME=$ORACLE_ BASE/product/12.1.0/dbhome_ one
Open a new window and enter the command again
$ sqlplus/as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Thu Jul 15 04:42:11 2021
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL>
It can be seen that the problem has been successfully solved
the reason for this error is $oracle_ Home configuration error.
Today the toolbox reported the following error.
ORA-08103: object no longer exists
After checking the reason, there is a session operating the table, such as insert, update, etc.. And the toolbox operation happens to be in the select table, so the error is reported.
————————————————————————————
ORA-08103: object no longer exists error.
The later description is that one of the processes is performing truncate and insert actions sequentially while another process is doing a select action on the
The latter description is that one of the processes performs truncate and insert actions sequentially, while another process does select on the same table, resulting in ora-8103
metalink information:
fact: Oracle Server – Enterprise Edition 8
symptom: Error performing a SELECT statement
symptom: ORA-08103: object no longer exists
symptom: Table is being truncated by other session
symptom: Analyze table validate structure cascade returns no errors
cause: This ORA-08103 occurs on the next block read after the truncate
command.
The LOCK TABLE IN EXCLUSIVE MODE does not prevent the table from being
SELECTED from. Thus, when the query has started and while this query runs
and the truncate occurs, this ORA-08103 may surface on the next block read.
This is considered intended behavior.
When a TRUNCATE occurs the DATAOBJ# in OBJ$ gets increased by one and thus
may lead to this ORA-08103 ‘object no longer exists’
fix:
Possible solutions are:
– Use DELETE instead of TRUNCATE
– Use SELECT FOR UPDATE as this will try to lock the table
Also ora-08103 has other explanations:
Solution: ‘ORA-8103: Object no longer exists’ When Insert Into External Table after Truncate With Storage Performed
Applies to:
Oracle Server – Enterprise Edition – Version: 10.2.0.1 to 10.2.0.3
This problem can occur on any platform.
Symptoms
The following error can occur on an insert with SQL Loader into an external organized table after a truncate with storage option has been performed
ORA-08103: object no longer exists
SQL> insert
/*+ PARALLEL(a, 8)*/
into iad_o_ast_new a
select /*+ full(b) parallel(b,8)*/
* from iad_o_ast_ext b
where rownum<10000 ;
into iad_o_ast_new a
*
ERROR at line 3:
ORA-08103: object no longer exists
.
Changes
The table was truncated with storage option before the insert .
Cause
The bitmap information is not correct after truncating with the storage option. The solutions update the bitmap information in the tablespace.
Solution
There are two known solutions at this time.
1. Add another datafile to increase the size of the tablespace for the insert. You will need to still use the correct truncate option next time you truncate the table.
2. Drop the table and recreate it. You will need to still use the correct truncate option next time you truncate the table.
Do not truncate the table with the storage option.
Do not truncate the base table using:
truncate ;
truncate drop storage;
Use the following instead:
truncate reuse storage;
The web project reports an error when executing the query:
Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!
19:27:26,672 ERROR [STDERR] org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Connections could not be acquired from the underlying database!; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
19:27:26,672 ERROR [STDERR] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
19:27:26,672 ERROR [STDERR] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
19:27:26,672 ERROR [STDERR] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
19:27:26,672 ERROR [STDERR] at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
19:27:26,673 ERROR [STDERR] at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
19:27:26,673 ERROR [STDERR] at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
19:27:26,673 ERROR [STDERR] at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
19:27:26,673 ERROR [STDERR] at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:912)
19:27:26,673 ERROR [STDERR] at com.springtest.common.dao.GenericHibernateDao.find(GenericHibernateDao.java:224)
19:27:26,673 ERROR [STDERR] at com.springtest.system.service.LoginService.findTBaseUser(LoginService.java:25)
19:27:26,673 ERROR [STDERR] at com.springtest.system.action.LoginAction.login(LoginAction.java:39)
19:27:26,673 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
19:27:26,673 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
19:27:26,673 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
19:27:26,673 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
19:27:26,673 ERROR [STDERR] at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219)
19:27:26,673 ERROR [STDERR] at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
19:27:26,673 ERROR [STDERR] at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
19:27:26,673 ERROR [STDERR] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745)
19:27:26,673 ERROR [STDERR] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686)
19:27:26,673 ERROR [STDERR] at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
19:27:26,673 ERROR [STDERR] at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)
19:27:26,673 ERROR [STDERR] at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)
19:27:26,673 ERROR [STDERR] at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)
19:27:26,673 ERROR [STDERR] at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:838)
19:27:26,673 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
19:27:26,673 ERROR [STDERR] at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)
19:27:26,673 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
19:27:26,673 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
19:27:26,673 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
19:27:26,673 ERROR [STDERR] at com.springtest.common.filter.LoginFilter.doFilter(LoginFilter.java:48)
19:27:26,673 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
19:27:26,673 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
19:27:26,673 ERROR [STDERR] at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
19:27:26,674 ERROR [STDERR] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
19:27:26,674 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
19:27:26,674 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
19:27:26,674 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
19:27:26,674 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
19:27:26,674 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
19:27:26,674 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
19:27:26,674 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
19:27:26,674 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
19:27:26,674 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
19:27:26,674 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
19:27:26,674 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
19:27:26,674 ERROR [STDERR] at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
19:27:26,674 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
19:27:26,674 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
19:27:26,674 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
19:27:26,674 ERROR [STDERR] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
19:27:26,674 ERROR [STDERR] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
19:27:26,674 ERROR [STDERR] at java.lang.Thread.run(Thread.java:619)
19:27:26,674 ERROR [STDERR] Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!
19:27:26,674 ERROR [STDERR] at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
19:27:26,674 ERROR [STDERR] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
19:27:26,674 ERROR [STDERR] at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
19:27:26,674 ERROR [STDERR] at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:83)
19:27:26,675 ERROR [STDERR] at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
19:27:26,675 ERROR [STDERR] at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
19:27:26,675 ERROR [STDERR] at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
19:27:26,675 ERROR [STDERR] at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
19:27:26,675 ERROR [STDERR] at org.hibernate.loader.Loader.doQuery(Loader.java:801)
19:27:26,675 ERROR [STDERR] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
19:27:26,675 ERROR [STDERR] at org.hibernate.loader.Loader.doList(Loader.java:2542)
19:27:26,675 ERROR [STDERR] at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
19:27:26,675 ERROR [STDERR] at org.hibernate.loader.Loader.list(Loader.java:2271)
19:27:26,675 ERROR [STDERR] at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
19:27:26,675 ERROR [STDERR] at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
19:27:26,675 ERROR [STDERR] at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
19:27:26,675 ERROR [STDERR] at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
19:27:26,675 ERROR [STDERR] at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
19:27:26,675 ERROR [STDERR] at org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:921)
19:27:26,675 ERROR [STDERR] at org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:912)
19:27:26,675 ERROR [STDERR] at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
19:27:26,675 ERROR [STDERR] ... 47 more
19:27:26,675 ERROR [STDERR] Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
19:27:26,675 ERROR [STDERR] at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)
19:27:26,675 ERROR [STDERR] at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
19:27:26,675 ERROR [STDERR] at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
19:27:26,675 ERROR [STDERR] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
19:27:26,675 ERROR [STDERR] ... 66 more
19:28:29,599 ERROR [STDERR] org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Connections could not be acquired from the underlying database!; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
19:28:29,600 ERROR [STDERR] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
19:28:29,600 ERROR [STDERR] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
19:28:29,600 ERROR [STDERR] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
19:28:29,600 ERROR [STDERR] at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
19:28:29,600 ERROR [STDERR] at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
19:28:29,600 ERROR [STDERR] at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
19:28:29,600 ERROR [STDERR] at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
19:28:29,600 ERROR [STDERR] at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:912)
19:28:29,601 ERROR [STDERR] at com.springtest.common.dao.GenericHibernateDao.find(GenericHibernateDao.java:224)
19:28:29,601 ERROR [STDERR] at com.springtest.system.service.LoginService.findTBaseUser(LoginService.java:25)
19:28:29,601 ERROR [STDERR] at com.springtest.system.action.LoginAction.login(LoginAction.java:39)
19:28:29,601 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
19:28:29,601 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
19:28:29,601 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
19:28:29,601 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
19:28:29,601 ERROR [STDERR] at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219)
19:28:29,601 ERROR [STDERR] at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
19:28:29,601 ERROR [STDERR] at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
19:28:29,601 ERROR [STDERR] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745)
19:28:29,601 ERROR [STDERR] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686)
19:28:29,601 ERROR [STDERR] at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
19:28:29,601 ERROR [STDERR] at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)
19:28:29,601 ERROR [STDERR] at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)
19:28:29,601 ERROR [STDERR] at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)
19:28:29,601 ERROR [STDERR] at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:838)
19:28:29,601 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
19:28:29,601 ERROR [STDERR] at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)
19:28:29,601 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
19:28:29,601 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
19:28:29,601 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
19:28:29,601 ERROR [STDERR] at com.springtest.common.filter.LoginFilter.doFilter(LoginFilter.java:48)
19:28:29,601 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
19:28:29,601 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
19:28:29,601 ERROR [STDERR] at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
19:28:29,601 ERROR [STDERR] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
19:28:29,602 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
19:28:29,602 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
19:28:29,602 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
19:28:29,602 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
19:28:29,602 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
19:28:29,602 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
19:28:29,602 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
19:28:29,602 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
19:28:29,602 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
19:28:29,602 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
19:28:29,602 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
19:28:29,602 ERROR [STDERR] at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
19:28:29,602 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
19:28:29,602 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
19:28:29,602 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
19:28:29,602 ERROR [STDERR] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
19:28:29,602 ERROR [STDERR] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
19:28:29,602 ERROR [STDERR] at java.lang.Thread.run(Thread.java:619)
19:28:29,602 ERROR [STDERR] Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!
19:28:29,602 ERROR [STDERR] at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
19:28:29,602 ERROR [STDERR] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
19:28:29,602 ERROR [STDERR] at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
19:28:29,602 ERROR [STDERR] at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:83)
19:28:29,603 ERROR [STDERR] at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
19:28:29,603 ERROR [STDERR] at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
19:28:29,603 ERROR [STDERR] at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
19:28:29,603 ERROR [STDERR] at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
19:28:29,603 ERROR [STDERR] at org.hibernate.loader.Loader.doQuery(Loader.java:801)
19:28:29,603 ERROR [STDERR] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
19:28:29,603 ERROR [STDERR] at org.hibernate.loader.Loader.doList(Loader.java:2542)
19:28:29,603 ERROR [STDERR] at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
19:28:29,603 ERROR [STDERR] at org.hibernate.loader.Loader.list(Loader.java:2271)
19:28:29,603 ERROR [STDERR] at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
19:28:29,603 ERROR [STDERR] at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
19:28:29,603 ERROR [STDERR] at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
19:28:29,603 ERROR [STDERR] at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
19:28:29,603 ERROR [STDERR] at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
19:28:29,603 ERROR [STDERR] at org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:921)
19:28:29,603 ERROR [STDERR] at org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:912)
19:28:29,603 ERROR [STDERR] at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
19:28:29,603 ERROR [STDERR] ... 47 more
19:28:29,604 ERROR [STDERR] Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
19:28:29,604 ERROR [STDERR] at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)
19:28:29,604 ERROR [STDERR] at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
19:28:29,604 ERROR [STDERR] at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
19:28:29,604 ERROR [STDERR] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
19:28:29,604 ERROR [STDERR] ... 66 more
19:28:46,580 ERROR [STDERR] org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Connections could not be acquired from the underlying database!; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
19:28:46,580 ERROR [STDERR] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
19:28:46,580 ERROR [STDERR] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
19:28:46,580 ERROR [STDERR] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
19:28:46,580 ERROR [STDERR] at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
19:28:46,581 ERROR [STDERR] at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
19:28:46,581 ERROR [STDERR] at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
19:28:46,581 ERROR [STDERR] at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
19:28:46,581 ERROR [STDERR] at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:912)
19:28:46,581 ERROR [STDERR] at com.springtest.common.dao.GenericHibernateDao.find(GenericHibernateDao.java:224)
19:28:46,581 ERROR [STDERR] at com.springtest.system.service.LoginService.findTBaseUser(LoginService.java:25)
19:28:46,581 ERROR [STDERR] at com.springtest.system.action.LoginAction.login(LoginAction.java:39)
19:28:46,581 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
19:28:46,581 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
19:28:46,581 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
19:28:46,581 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
19:28:46,581 ERROR [STDERR] at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219)
19:28:46,581 ERROR [STDERR] at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
19:28:46,581 ERROR [STDERR] at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
19:28:46,581 ERROR [STDERR] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745)
19:28:46,581 ERROR [STDERR] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686)
19:28:46,581 ERROR [STDERR] at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
19:28:46,581 ERROR [STDERR] at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)
19:28:46,581 ERROR [STDERR] at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)
19:28:46,581 ERROR [STDERR] at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)
19:28:46,581 ERROR [STDERR] at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:838)
19:28:46,581 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
19:28:46,581 ERROR [STDERR] at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)
19:28:46,581 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
19:28:46,581 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
19:28:46,581 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
19:28:46,581 ERROR [STDERR] at com.springtest.common.filter.LoginFilter.doFilter(LoginFilter.java:48)
19:28:46,581 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
19:28:46,581 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
19:28:46,581 ERROR [STDERR] at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
19:28:46,581 ERROR [STDERR] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
19:28:46,582 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
19:28:46,582 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
19:28:46,582 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
19:28:46,582 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
19:28:46,582 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
19:28:46,582 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
19:28:46,582 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
19:28:46,582 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
19:28:46,583 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
19:28:46,583 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
19:28:46,583 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
19:28:46,583 ERROR [STDERR] at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
19:28:46,583 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
19:28:46,583 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
19:28:46,583 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
19:28:46,583 ERROR [STDERR] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
19:28:46,583 ERROR [STDERR] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
19:28:46,583 ERROR [STDERR] at java.lang.Thread.run(Thread.java:619)
19:28:46,583 ERROR [STDERR] Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!
19:28:46,583 ERROR [STDERR] at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
19:28:46,583 ERROR [STDERR] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
19:28:46,586 ERROR [STDERR] at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
19:28:46,586 ERROR [STDERR] at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:83)
19:28:46,586 ERROR [STDERR] at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
19:28:46,586 ERROR [STDERR] at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
19:28:46,586 ERROR [STDERR] at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
19:28:46,586 ERROR [STDERR] at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
19:28:46,586 ERROR [STDERR] at org.hibernate.loader.Loader.doQuery(Loader.java:801)
19:28:46,586 ERROR [STDERR] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
19:28:46,586 ERROR [STDERR] at org.hibernate.loader.Loader.doList(Loader.java:2542)
19:28:46,586 ERROR [STDERR] at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
19:28:46,586 ERROR [STDERR] at org.hibernate.loader.Loader.list(Loader.java:2271)
19:28:46,586 ERROR [STDERR] at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
19:28:46,586 ERROR [STDERR] at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
19:28:46,586 ERROR [STDERR] at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
19:28:46,586 ERROR [STDERR] at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
19:28:46,586 ERROR [STDERR] at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
19:28:46,588 ERROR [STDERR] at org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:921)
19:28:46,588 ERROR [STDERR] at org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:912)
19:28:46,588 ERROR [STDERR] at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
19:28:46,588 ERROR [STDERR] ... 47 more
19:28:46,588 ERROR [STDERR] Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
19:28:46,588 ERROR [STDERR] at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)
19:28:46,588 ERROR [STDERR] at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
19:28:46,588 ERROR [STDERR] at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
19:28:46,588 ERROR [STDERR] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
19:28:46,588 ERROR [STDERR] ... 66 more
Oracle service has been started, but an error was reported when executing the query statement. I failed to connect to the database with PLSQL tool, indicating that I did not listen. I remember that I shut down some services that you don’t often use this morning, and the PLSQL connection is normal after startup.
Baidu found that the following error information needs to be checked:
1. Wrong startup configuration: db.driverclass = oracle.jdbc.driver.oracledriver
2. Wrong database connection address: db.url = JDBC: Oracle: thin: @ 127.0.0.1:1521: orcl
3. Wrong account or password: db.user = spring
db.password = springpwd
4. No right to restrict access if the database is not started Ask. The database service or listening service is not started
5. The project does not introduce the corresponding driver jar package.
6. MySQL root does not have remote access permissions, so it needs to increase permissions.
1. Problem description
Generally speaking, pyqt can connect to MySQL database in the following format:
self.DB = QSqlDatabase.addDatabase('QMYSQL')
self.DB.setDatabaseName("school_club") # Enter the data table you want to access
self.DB.setHostName('localhost')
self.DB.setPort(3306)
self.DB.setUserName('root')
self.DB.setPassword('') # Enter the password for your own database
However, sometimes the connection fails, and debug can’t point out the error clearly. Errors can be found in the following ways.
Method 1: check the driver attached to pyqt
print(QSqlDatabase.drivers())
If ‘qmmysql’ and ‘qmysql3’ are found missing in the driver, it indicates that the error is driver missing. You can use this method to solve the problem. Because under normal conditions, the output should be as follows:
['QSQLITE', 'QMYSQL', 'QMYSQL3', 'QODBC', 'QODBC3', 'QPSQL', 'QPSQL7']
Method 2: print error information
print(self.DB.lastError().text())
This method can also get the specific part of the connection error.
2. How to solve the lack of qmmysql driver?
The author’s pyqt is installed in Anaconda environment, so the folder path to be found by the driver is special.
The general idea is to add two DLL files: qsqlmysql.dll and libmysql.dll in pyqt related folder. At the same time, these two files must be fully matched with the relevant pyqt version.
Step 1: load qsqlmysql.dll
First, open Anaconda prompt, enter the following command line, and adjust the python version to 5.12.1 (only this version comes with qsqlmysql.dll, other versions of this DLL are too difficult to find a matching one)
pip install PyQt5==5.12.1
After this step, qsqlmysql.dll has been successfully installed in the relevant folder.
Step 2: load libmysql.dll
This is relatively easy. First, find the libmysql.dll (this is the default path for MySQL installation, and the user-defined path will be found separately) in the path of C:// program files/MySQL/MySQL server 8.0/bin, and copy it.
Take my computer as an example, paste the file to the following path:
D:\Anaconda\Anaconda\Lib\site-packages\PyQt5\Qt\bin
You can choose the appropriate path according to the relative path of the above path according to the installation location of anaconda.
Restart the programming tool and print again (QSqlDatabase. Drivers()). It is found that ‘qmmysql’ and ‘qmysql3’ have successfully appeared.
During the test, the database of Aix small computer and Oracle 11g Rac is cloned to a new server, and the original disk group is remounted with the same disk number and sequence, An error is reported when starting has:
clsu-00100: operating system function: opendir failed with error data: 1
clsu-00101: operating system error message: nosuch file or directory
clsu-00103: error location: scrsearch1
clsu-00104: additional error information: can open SCR home dir SCLS_ scr_ getval
CRS-4000: Command Start failed, or completed with errors.
It literally means the problem of the operating system. Check the IP address, hosts file, and host name to see if there is any problem.
Check the current GI installation host name (the host name will be recorded when grid is installed)
CD/etc/Oracle/SCLS_ scr/
[ oracle@edbjr2p2 scls_ SCR] $LS
Rac1
current host name
$host name
Rac2
Confirm that the host name has been modified. Other ways on the Internet say that has and grid need to be reconfigured.
after looking at the process, it’s rather cumbersome. Anyway, the host is cloned. Sima is a live doctor. He directly asks his colleagues in the host group to modify the host name and IP address. After confirming that there is no problem with the hosts content, restart the system and start the cluster and database again. OK
reason:
The log has reached the maximum space on the primary copy or the disk is full.
analysis
The log block of the primary replica can only be reused after it is fixed and redo on other replicas.
So if
1. Transmission delay, due to network delay or bandwidth delay.
2. Copy redo is slow due to delay, blocking or insufficient resources.
Causes the log to grow and cannot be backed up.
log_ send_ queue_ Size: a log block that has not been received by the replica. More than one log block means delivery delay.
redo_ queue_ Size: there is no redo log block on the replica. If there is more, it means redo delay.
SELECT ag.name AS [availability_group_name]
, d.name AS [database_name]
, ar.replica_server_name AS [replica_instance_name]
, drs.truncation_lsn , drs.log_send_queue_size
, drs.redo_queue_size
FROM sys.availability_groups ag
INNER JOIN sys.availability_replicas ar
ON ar.group_id = ag.group_id
INNER JOIN sys.dm_hadr_database_replica_states drs
ON drs.replica_id = ar.replica_id
INNER JOIN sys.databases d
ON d.database_id = drs.database_id
WHERE drs.is_local=0
ORDER BY ag.name ASC, d.name ASC, drs.truncation_lsn ASC, ar.replica_server_name ASCresolvent:
1. Remove the DB from the most delayed replica and join it later.
2. If the redo thread on the replica is blocked by frequent read operations, set the replica as unreadable and change it back later.
3. If there is still space on the disk, the log file will grow automatically.
4. If the maximum space limit is reached and the disk still has space, increase the maximum space limit.
5. If the log file reaches the maximum value of 2T system and there are idle disks, add the log file.
reference material
https://docs.microsoft.com/en-US/troubleshoot/sql/availability-groups/error-9002-transaction-log-large
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ……
syntax error:
Because varchar needs to specify the length, varchar (32) checks whether the corresponding types of all fields need to add length or precision, because MySQL keywords are used. For example, using ID as the field name needs to be enclosed in quotation marks
Error 1064 (42000) from mysqldump command
Mysqldump – uroot – P library name & gt/ Backup path/backup file name. SQL;
Always report error:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘mysqldump -uroot -p bank>/ Users/F/bank_ back.sql’ at line 1
resolvent:
Input mysqldump command directly in the terminal, do not input mysqldump command after logging into the database.
Special thanks to the original author guanggulala.
[2021-06-29 09:30:55.391] [MySQL] [000071] [MySQL] you have an error in your SQL syntax; Check the manual that responses to your MySQL server version for the right syntax to use near 'insert to Dept (ID, name, PID) values ('1000','head office ',') 'at line 1