Category Archives: How to Fix

Solution of connection error report in MySQL installation

Error in finish in the last step of installation

Note: after setting, there is a common error when you press “finish”, that is, you cannot “start” The solution is to ensure that the previously installed MySQL server has been completely uninstalled; if not, check whether the previous password has been modified according to the above step, and follow the above operation; if not, back up the data folder under the MySQL installation directory, and then delete it, after the installation is completed After that, delete the data folder generated by the installation, move the backup data folder back, and restart the MySQL service. In this case, you may need to check the database and repair it once to prevent data errors.

resolvent

    uninstall the MySQL Windows XP system, delete the directory, and then install it again

Step on the pit — error reported by sqoop tool.ExportTool : Error during export

@To live better

Step on the pit — error reported by sqoop tool.ExportTool : Error during export

The error printed on the console is

19/04/19 20:17:09 ERROR mapreduce.ExportJobBase: Export job failed!
19/04/19 20:17:09 ERROR tool.ExportTool: Error during export: 
Export job failed!
	at org.apache.sqoop.mapreduce.ExportJobBase.runExport(ExportJobBase.java:445)
	at org.apache.sqoop.manager.MySQLManager.upsertTable(MySQLManager.java:145)
	at org.apache.sqoop.tool.ExportTool.exportTable(ExportTool.java:73)
	at org.apache.sqoop.tool.ExportTool.run(ExportTool.java:99)
	at org.apache.sqoop.Sqoop.run(Sqoop.java:147)
	at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
	at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)
	at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234)
	at org.apache.sqoop.Sqoop.runTool(Sqoop.java:243)
	at org.apache.sqoop.Sqoop.main(Sqoop.java:252)

finishing touch : this error indicates that the fields of MySQL and hive do not correspond or the data format is different
solution:
Step 1 : check whether the structure (field name and data type) of MySQL and hive tables are consistent.
Step 2 : check whether the data has been imported?If the data is not imported, please change the time type in MySQL and hive to string or varchar in the first step. If there is an import, but the imported data is incomplete or incorrect. It must be that your data type is inconsistent with the actual data. There are two situations. See the following three steps for details.
Step 3 : in MySQL to hive, please be sure to check whether your data contains the default line break for hive table creation ( lines terminated by '\ n' ). If yes, add hive delims replacement or hive drop import delims to the sqoop statement, as follows

#!/bin/bash
/usr/local/package/sqoop-1.4.7.bin/bin/sqoop import \
--connect jdbc:mysql://ip:3306/mysql_DB \
--username root \
--password 1q2w3e4r \
--table mysql_Table \
--delete-target-dir \
--hive-delims-replacement , \
--hive-import \
--hive-overwrite \
--hive-database hive_DB \
--hive-table hive_Table \
--hive-partition-key ymday \
--hive-partition-value 20190419 \
--fields-terminated-by '\t' \
-m 1

Step 4 : in MySQL to hive, please be sure to check whether your data contains the field separator commonly used in hive table creation ( Fields terminated by '\ t' ). If yes, the fields terminated by parameter cannot be used in the sqoop statement, and the code is as follows:

Step 5 : if there are many empty columns from hive to hive, sometimes the above error will be reported, then add input null string and input null non string in the sqoop statement, and the following code
remember ^ A, and use Ctrl + V and Ctrl + A in VI of Linux To generate, you can't copy the following ^ a
remember ^ a directly. In VI of Linux, you can't copy the following ^ a
remember ^ a directly. In VI of Linux, you can't copy the following ^ a directly

#!/bin/bash
/usr/local/package/sqoop-1.4.7.bin/bin/sqoop export \
--connect "jdbc:mysql://ip:3306/report_db?useUnicode=true&characterEncoding=utf-8" \
--username root \
--password 1q2w3e4r \
--table mysql_table \
--columns name,age \
--update-key name \
--update-mode allowinsert \
--input-null-string '\\N' \
--input-null-non-string '\\N' \
--export-dir "/hive/warehouse/dw_db.db/hive_table/ymday=20190419/*" \
--input-fields-terminated-by '^A' \
-m 1

====================================================================

@To live better

If you have any questions about the blog, please leave a message

Uiautomatiorviewer connect to the machine and click to report unexpected error while observing UI hierarchy

 

Method 1: recommend method 2

reference resources: https://www.cnblogs.com/lucky0425/p/10955252.html

Run Android uiautomatorviewer.bat , open and connect the mobile phone. The error is as follows:

Tangled for a long time, and finally solved with the method of a great God, although I don’t understand the principle, but has solved my problem, the principle later slowly study

1. Create in the e-root directory app.png text file

2. Create in the e-root directory app.uix text file

3. Perform the following ADB naming:

                  adb shell uiautomator dump /sdcard/ app.uix

                  adb pull /sdcard/ app.uix E:/ app.uix

                  adb shell screencap -p /sdcard/ app.png

                  adb pull /sdcard/ app.pngE :/ app.png

4. Operation uiautomatorviewer.bat , import file

5. Connect the mobile phone again, you can see the screen capture page of the mobile phone, but there is only one picture, which can’t run the app completely

 

Method 2

reference resources: https://blog.csdn.net/qq_ 42559334/article/details/83862323

1. In the directory of installing Android SDK, find the SDK Manager.exe , click to enter

 

 

2. Select the Android version number of the real machine, check the installation package, and click Install

 

3. After installation, restart uiautomatorviewer.bat

http://www.shangdixinxi.com/detail-1098954.html  

https://github.com/yaming116/uiautomatorview

PIP installation error: Microsoft Visual C + + 14.0 is required perfect solution

In the process of using Python development, we often need to install various modules, but we often encounter various errors in the installation process, such as: error: Microsoft Visual C + + 14.0 is required, this error is due to the lack of C + + compiler components.

There are two solutions to this problem

One is to directly download the corresponding wheel file for installation, providing three download addresses:

Tsinghua download (domestic site, fast speed) https://pypi.tuna.tsinghua.edu.cn/simple/pip/

Official download: https://pypi.org/project/face-recognition/1.0.0/#files

Python package https://www.lfd.uci.edu/~gohlke/pythonlibs/

Another solution is to install the missing components.

As for the second solution, I believe most people will download a visual studio 201x and install it as I used to. However, installing a vs takes up a lot of space, not to mention the key. Some people find it useless after installation, which is really irritating.

After all kinds of search, it was found that the C + + runtime provided by the government can be directly installed, which can be solved perfectly. The address is Microsoft Visual C + + build tools 2015

 

After downloading, double-click run to install with default settings. After the installation, go to PIP install XXX to show that the installation is successful.

 

Welcome to my personal blog: the road of machine learning

Error: Command ‘/ usr / bin / clang’ failed with exit status 1 solution for Mac OS installation

1、 Scene description

The error of installing scrapy (PIP3 install scrapy) in terminal on Mac OS system is as follows

error: command '/usr/bin/clang' failed with exit status 1

2、 Scene analysis

Since clang is used in the compiler for C at the bottom of Mac OS system, Xcode needs to be installed

3、 Solutions

Do the following in terminal

xcode-select --install

Then install scrapy

Note: I use Python 3, so I use PIP3 install sketch

Idea running error running ‘application’: solution to command line is too long

There are other idea error reporting tutorials in the personal blog. Students who need them can click the link below

https://www.itqiankun.com/article/100983585

When a new project is started in idea, it sometimes reports error running ‘application’: command line is too long. Short command line for application or aalso for spring boot default configuration. The error message is as follows

how to solve it?First, find the idea in the project/ workspace.xml File, and then find & lt; Component name = "propertiescomponent" & gt; & lt; & component & gt; tag, as shown below

and then add a line & lt; property name> to the component tag=“ dynamic.classpath "Value =" true "/ & gt; , that is to say,

in this way, when starting a project, there will be no error ☝ What's going on ☝ ؏؏

Error: cannot find module ‘webpack / lib / ruleset’_ solve

1. Error report

Error: Cannot find module 'webpack/lib/RuleSet'

In the first question, I tried to put node_ Modules folder and package- lock.json Delete the file and then NPM install it. I don’t know if it’s useful or not. Let’s take a note to solve the problem https://segmentfault.com/q/1010000012177571/a-1020000012180629
Comments below

2. After the execution, an error is reported

Error: Rule can only have one resource source (provided resource and test +

Solutions:
1 https://blog.csdn.net/weixin_ 40643648/article/details/109444867
reload webpage

3. Error report after execution

These dependencies were not found:
@videojs/vhs-utils/dist/byte-helpers in ./node_modules/video.js/dist/video.es.js
@videojs/vhs-utils/dist/containers in ./node_modules/video.js/dist/video.es.js

Solution:
Baidu found that the error was lack of dependence, so it directly solved the problem

npm install 
yarn run server

Modelsim compiles vivado IP and reports error protection region

The reason is that some IP file names of vivado seem to be VHD, but they are not written in VHD syntax. You need to compile vivado’s related libraries.

Check if the INI file of Modelsim in your project has the following libraries.
secureip = C:\modeltech64_ 10.2c\win64\xilinx_ lib/secureip
unisim = C:\modeltech64_ 10.2c\win64\xilinx_ lib/unisim
unimacro = C:\modeltech64_ 10.2c\win64\xilinx_ lib/unimacro
unifast = C:\modeltech64_ 10.2c\win64\xilinx_ lib/unifast
unisims_ ver = C:\modeltech64_ 10.2c\win64\xilinx_ lib/unisims_ ver
unimacro_ ver = C:\modeltech64_ 10.2c\win64\xilinx_ lib/unimacro_ ver
unifast_ ver = C:\modeltech64_ 10.2c\win64\xilinx_ lib/unifast_ ver
simprims_ ver = C:\modeltech64_ 10.2c\win64\xilinx_ lib/simprims_ ver

If not, you need to compile the following libraries first.

Click Tools – comparative simulation libraries on the vivado toolbar, as shown in Figure 2.

 

 

After compiling, there will be no problem in the simulation.

Error: Microsoft Visual C + + 14.0 is required to get it with Microsoft V + + comp

This problem bothered me for three hours, and finally solved. I’m sorry for the three hours of my life if I don’t write it down.

First of all, PIP install sketch, which reports an error

 error: Microsoft Visual C++ 14.0 is required. Get it with "Microsoft Visual C++ Build Tools": http://landinghub.visualstudio.com/visual-cpp-build-tools

When you see the error report, your first reaction is to download the VC + + 14.0 build tools in the prompt.

Open the link and it turns out to be vs2015 build tools. Now I understand that vs 2015 is the VC + + 14.0 in the error report.

Download an online installation package, open it and prepare. Microsoft told me that it needs about 5GB of hard disk space

I already have vs2012 in my computer. This stuff has filled up my C disk. I need to install another vs2015, WTF?

Here, although I have vs2012 in my computer, it is invalid because it requires VC + + 14.0 and the wrong version.

However, it is certain that installing vs2015 build tools can solve the problem. Let’s take a look at the solution of stack overflow

https://stackoverflow.com/questions/29846087/microsoft-visual-c-14-0-is-required-unable-to-find-vcvarsall-bat

Give up this method and start Baidu

Many people said that they could download the WHL file of scrapy and install it offline, so they downloaded one, and the error is still reported.

There is no link here, because this method is invalid.

However, many people succeeded in installing the WHL file, so I began to analyze the error report carefully, and finally found the clue

The red box in the figure shows that there is an error in building twisted. Then I can manually install the offline package of twisted?

So in http://www.lfd.uci.edu/~gohlke/pythonlibs Find the twisted installation package

Twisted‑17.9.0‑cp35‑cp35m‑win_ AMD64. WHL directly PIP install this offline WHL, and it was successful.
Finally, PIP install sketch, or install the WHL file of sketch, and it will be successful soon.

The general idea is to report an error when installing a, find the thing B of can’t build, and then manually install the offline WHL of B. If an error is reported during the process of installing B,

Then go to the next level until the installation is successful.

Successful solution of eclipse startup error Error:Could not create the Java Virtual Machine Error:A fatal exception has occurred

Error reporting process

Today, after opening eclipse, the following error occurred

problem analysis

The system is reinstalled on the computer, and then Java is also reinstalled. Useless files are generated in the computer’s C: [windows] system32, as shown in the following figure:

Problem solving

Just delete the three files above

OK, GAME OVER !

More wonderful content please pay attention to: the road of Java master

Reply to “java project” and get the following video tutorial for free

Error: bundling failed: error: unable to resolve module

When I was learning react native to load local with imgae, I encountered this problem. The code is like this

In the images folder of the root directory, there are backicon.png This picture is

According to the path configured above, the image can be located in the code, but the actual running test reported an error, and the image could not be found. Later, the test found that it was necessary to write like this

After changing to this, it can run normally, because refers to the image Login.js Different from the folder level of an image, you need to jump to the same level to find it. However, it’s not clear why you can also point out the path of the image without adding.. /.