Category Archives: How to Fix

Mybatis plus method querytotal execution error of SQL

Caused by: com.baomidou.mybatisplus . core.exceptions.MybatisPlusException : Error: Method queryTotal execution error of sql : 
 SELECT COUNT(1) FROM ( SELECT  id,third_ code,amount,target_ data,code,target_ id,target_ amount,refund_ time,refund_ res,channel,verify_ time,type,expired_ time,uid,cancel_ time,create_ time,merid,pay_ id,use_ expired_ time,status  FROM uni_ order 
 
 WHERE (code = ?AND uid IN () AND merid = ?AND channel = ?AND type = ?AND create_ time >= ?AND create_ time < ?AND status <> ?) ORDER BY id DESC ) TOTAL 
 

General SQL execution error

After reading the diary carefully, I found that the uid of SQL where condition did not pass the value

My mistake case:

The UIDs is not null, but the size is 0, so this condition is passed. But my UIDs has no value, so it is solved by adding the size judgment

Conclusion:

The condition in where may have no value, so an error will be reported: SQL execution error

 

 

Vs compilation error msb6006:“ cmd.exe ” exited with code 1.

Please note: http://blog.csdn.net/hust_ sheng/article/details/78827167

When this error occurs, the program will not crash, but the error window will display the above information~

There are a lot of blogs on the Internet to solve this kind of problem, but we can see that the reasons are different (incomplete files, insufficient administrator permissions, path containing Chinese, path containing spaces…) Because such problems are often not caused by one or even several certain reasons. Of course, we can’t rule out the consistent reasons for the compilation process of some fixed software, such as this blog

So in most cases, how can we determine the cause of the error in our own project?

look at the log information of the compilation process and the error prompt! I found that the reason for this error is that I didn’t install python

[Python error] memoryerror

Error report:
(the figure above shows the error report when the server code is running in the virtual machine)

Memory error: it involves reading, saving and writing. The memory is not enough

Solution:
check and install 64 bit python. The pandas and numpy in 64 bit Python are 64 bit, and the memory is larger.

If running in a virtual machine: set the memory size of the virtual machine (this method I use)

run again, and no more errors will be reported:

Error: nothing to do in centos7’s Yum installation

catalog

Caption:

Yum installation error description:

Solution, update Yum source:

Re install, problem solved:

 

Caption:

After installing centos7, sometimes Yum is not up-to-date. It’s better to update the yum source after installing the system. Since the yum source was not updated after installing the operating system, the following error occurred today.

Yum installation error description:

 

Solution, update Yum source:

yum -y update 

 

Re install, problem solved:

 

 

Error: eexist: file already exists

Error: eexist: file already exists, open ‘*. JS’

The wechat applet can be compiled normally, but when you start the real machine debugging, it will be reported as file already exists

Some netizens said that I have tried to upgrade wechat developer tools or restart them, but I can’t solve them.

The file I reported an error was ordered by my duplicate name. I found that when I was debugging and compiling the real machine, I still renamed the name before, and the cache could not be cleared. So I deleted the file after my duplicate name, restored the file from the recycle bin, and then debugged the real machine.

Validation error: webpack dev server invalid options

When Vue starts the project yarn serve or NPM run dev
If an error message appears when Vue starts the project: validationerror: webpack dev server invalid options
cause of the problem:
the “proxy” object value used to solve the cross domain problem in the configuration file is empty

Solution:
find config.js Modify the contents of the document（ webpack.config.js Or vue.config.js ）
find devserver and comment out the proxy in it

Idea introduces dependency and starts jar error in opening zip file

Question:

reason:

When Maven download is dependent, the jar may not be downloaded to the local normally due to network reasons. If you start the project reference, an error will be reported, and the local Maven jar cannot be used normally

terms of settlement:

There is a stupid way to find out which jars are open with errors. Find the corresponding jars in the local Maven repository and delete them, pom.xml After testing, no error will be reported

Mongodb — startup exception, error report ERROR:NUMBER 100

When doing sharding — replica set, I missed a port and wanted to restart one of mongod, but I always reported an error

 

 

[ root@centos mongodb]# mongod –port 28018 –shardsvr –replSet shard1 –dbpath=/usr/local/mongodb/shard1_ 3 –logpath=/usr/local/mongodb/shard1_ 3/shard1_ 3.log –logappend –fork
Fri Apr 11 13:24:48.136
Fri Apr 11 13:24:48.136 warning: 32-bit servers don’t have journaling enabled by default. Please use –journal if you want durability.
Fri Apr 11 13:24:48.136
about to fork child process, waiting until server is ready for connections.
all output going to: /usr/local/mongodb/shard1_ 3/shard1_ 3.log
forked process: 5281
ERROR: child process failed, exited with error number 100

I checked online and found that it seems that I used violence to shut down DB before, resulting in data locking.

You need to enter the database directory and delete it mongod.lock Then, restart. That’s it.

 

 

In addition, the correct way to close mongodb.

1.kill -2 PID

2.use admin;

  db.shutdownServer ()



More attention is paid to the official account “Python column”. The background reply to “Tencent architecture resource 1” gets the big data resources prepared by Tencent architects.

Kafka reported error shutdown broker because all log dirs in… Have failed

When using the Kafka tool, if there is one more topic to view topics, it will be deleted. Then the problem came, and Kafka service began to report an error:

ERROR Shutdown broker because all log dirs in E:\kafka\kafka_2.11-2.4.0\log have failed (kafka.log.LogManager)

Delete the topic log in the log in the directory where the error is reported, and restart Kafka to report an error. The original deletion of Kafka’s log directory can’t solve this problem, so we have to delete zookeeper zoo.cfg The dataDir directory configured in.

 

Note: if it is important data, be sure to back up!!!

Idea always reports errors when using “SVN” to associate projects Error:Cannot run Program “SVN” (in directory “path XXXXXX”): CreateProcess error = 2,

 

Using the new project tool idea interface to import SVN project, an error is reported

Error:Cannot run Program “SVN” (in directory “path XXXXXX”): CreateProcess error = 2 the system cannot find the specified file.

Error performing cleanup for cannot run program CreateProcess error = 2, cleanup/history/update all report errors.

The main reason for the error is that I didn’t install the command command when installing SVN. Just re install it.

1. Open SVN installation tool


Just go to the next step to install.

2. Re open idea to automatically match svn.exe Orders.

Click checkout to complete