SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded solution

SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction MySQL sometimes reports this delay exception.I. Problem Analysis After searching for related problems on the Internet, the analysis ideas to solve these problems are summarized. Firstly, the appearance is that the execution time of SQL is too long, wh ...

Posted by jbreits on Thu, 07 Feb 2019 01:54:16 -0800

Noejs express start error: Error: Cannot find module'xxx'

Noejs express start error: Error: Cannot find module'xxx', which is due to the lack of module references. For example, I used'express-session'in my code, but did not add a'express-session' dependency to the dependencies item in the package.json file. D:\nodejs\myapp>set DEBUG=myapp & npm start      > myapp@0.0.0 start D:\n ...

Posted by aquila125 on Thu, 07 Feb 2019 00:48:17 -0800

Differences between Reset/Restart/Recycling/Refresh of IIS

 Reprinted to http://blog.csdn.net/wulex/article/details/51861972 iisreset -- The object is the entire IIS server, which stops the World Wide Web Publishing Service and restarts the service, so all websites stop the service first and then restart the service. As pointed out, iisreset will stop and start the World Wide Web Publishing Service ...

Posted by samoi on Wed, 06 Feb 2019 06:45:16 -0800

Oracle 12C R2 - New Feature - Multi-tenant: Support for Local UNDO Mode

In 12.1, all PDB s in one instance can only share the same UNDO table space. In 12.2, they all have their own undo table spaces. This new management mechanism is called the local undo model. At the same time, in previous versions, it has now become a shared undo mode. I. shared undo to local undo mode 1. Query the current mode SQL> select ...

Posted by w00kie on Wed, 06 Feb 2019 05:39:16 -0800

Spring-Boot has Transaction marked as rollback only exception

Recently, in the process of development, we encountered the problem of using Transaction marked as rollback only. We learned the reasons for the error: It should be an error caused by multiple rollbacks of transactions. Looking at the code carefully, because the project has opened a transaction in aop aspect, contro ...

Posted by hrdyzlita on Tue, 05 Feb 2019 19:15:16 -0800

Possible solutions to adb server is out of date. killing

I don't remember how many times I encountered this problem when I learned to debug Android programs with adb commands: Open Eclipse or Android Studio and find that no device can be found. Then enter the command adb shell in the dos window. The following problems occur: adb devicesadb server is out of date. killing... ...

Posted by priya_cks on Tue, 05 Feb 2019 13:48:15 -0800

iOS webview could not load Web page Domain=NSURLErrorDomain Code=-1202

error When the application is changed from http to https, an error is reported. The following is an error: NSURLSession/NSURLConnection HTTP load failed (kCFStream Error Domain SSL, -9813) or Error Domain=NSURLErrorDomain Code=-1202 "The certificate for this server is invalid. " Reason This is because your https certificate i ...

Posted by brad_langdon on Mon, 04 Feb 2019 22:21:16 -0800

Using Spring Data Neo4j(SDN)

Using Spring Data Neo4j Reference documents: https://docs.spring.io/spring-data/neo4j/docs/5.0.7.RELEASE/reference/html/#reference Use of SDN in Spring Boot The following can be added to the pom dependency: Note: SDN uses Bolt Driver connections by default. To use embedded driver or HTTP driver, you need to add depende ...

Posted by powerofphp on Mon, 04 Feb 2019 21:09:18 -0800

Put XML files into MQ in batches, and java tools to generate XML files in batches

There are a lot of MQ interfaces in the project, especially after entering the combined test, there are a lot of MQ input and withdrawal requirements. The implementation of MQ resource manager with Webshpere is too slow, and there are too many manual operations. Two tools have been written manually. One is VBA's interface file ...

Posted by common on Mon, 04 Feb 2019 11:33:16 -0800

11g serial table scan feature and direct path read direct path reading

After 11g, serial table scan is introduced, and the whole table scan is at least 5 times the value of _small_table_threshold. The database will use direct path read instead of db file scattered read. db file scattered read: To read multiple blocks from disk to discontinuous buffers in SGA, scattered read must read multiple blo ...

Posted by sspphp on Sun, 03 Feb 2019 21:09:17 -0800