Category Archives: Error

[Solved] Workflow Module jar package startup error: liquibase – waiting for changelog lock

1. Abnormal

Workflow module jar package startup error:

2021-02-14 13:45:13.735 [main] INFO  liquibase - Waiting for changelog lock....
2021-02-14 13:45:23.739 [main] INFO  liquibase - Waiting for changelog lock....
2021-02-14 13:45:33.744 [main] INFO  liquibase - Waiting for changelog lock....
2021-02-14 13:45:43.750 [main] INFO  liquibase - Waiting for changelog lock....
2021-02-14 13:45:53.755 [main] INFO  liquibase - Waiting for changelog lock....
2021-02-14 13:46:03.762 [main] INFO  liquibase - Waiting for changelog lock....
2021-02-14 13:46:13.767 [main] INFO  liquibase - Waiting for changelog lock....
2021-02-14 13:46:23.773 [main] INFO  liquibase - Waiting for changelog lock....

2. Reasons

Some log tables of the workflow table are locked, which may be caused by the exception that the program was not terminated normally last time.

3. Learn from the online saying that the table is locked. Just unlock it. You can execute the following statement, but you will be prompted that the table cannot be found or does not exist

#Check the locked sheet
SELECT * FROM DATABASECHANGELOGLOCK;
#Unlock
UPDATE DATABASECHANGELOGLOCK SET locked=0, lockgranted=null, lockedby=null WHERE id=1

4. Solution (check all tables ending with databasechangelock, and modify as shown in Figure 2)

Figure 1

Figure 2

zookeeper is not a recognized option [How to Solve]

zookeeper is not a recognized option

An error is reported when creating a consumer:

.\bin\windows\kafka-console-consumer.bat --zookeeper localhost:2181 --topic ads_log 
zookeeper is not a recognized option

Cause of problem:

In the new version Kafka, -zookeeper has been deleted.

Solution:

The method of starting consumers after version 0.90 is as follows:

.\bin\windows\kafka-topics.bat  --bootstrap-server localhost:9092 --topic ads_log --from-beginning
 --bootstrap-server para

Create theme: you can

.\bin\windows\kafka-topics.bat --create  --bootstrap-server localhost:9092 --replication-factor 1 --partitions 3 --topic ads

.\bin\windows\kafka-topics.bat --create  --zookeeper localhost:2181 --replication-factor 1 --partitions 3 --topic ads

end!

There is no Action mapped for namespace [/] and action name [abc_show] associated with context path [/helloStruts].

There is no Action mapped for namespace [/] and action name [abc_show] associated with context path [/helloStruts].

problem found: the page cannot be found

analysis problem: the page cannot be found. The prompt is my mapping problem. But when I was in struts When the XML file is changed from normal naming to wildcard, an error will appear, and the prompt is as follows

environment: struts 2 (version 2.5)

problem solving: it may be because of the 2.5 version, so it is more rigorous 

<!--Allow dynamic method calls, wildcard + placeholder combinations, must add this line of code Version 2.5-->
	<constant name="struts.enable.DynamicMethodInvocation"
		value="true" />
	<constant name="struts.devMode" value="false"/>

<!--Error Method for action Action is not allowed Add global-allowed-methods 
			Indicates a method that allows dynamic invocation Version 2.5-->
		<global-allowed-methods>regex:.*</global-allowed-methods>

Save and restart the server.

[Solved] Jenkins Machine install kubelet Error: authentication failed

1. Look at jenkinsfile

2. Check the error message and the authentication fails

I can see that the authentication failed, but my Jenkins machine was successful in executing the kubectl command
[root@devops ~]# kubectl get pod 
NAME                                      READY   STATUS    RESTARTS   AGE
nexus3-7b7598945f-njgpn                   1/1     Running   1          6d6h

3. Modified

My authorization file is validated by environment variables, which are placed in /etc/profile, and /etc/profile is only loaded when the user logs in, Jenkins uses Non-login when running the command

Database “C:/Users/com/test” not found, either pre-create it or allow remote database creation (not recommended in secure environments) [90149-200] 90149/90149

 

1. Download installation package

H2 official website: http://h2database.com/html/main.html

H2 tutorial: https://www.ctolib.com/docs/sfile/h2-database-doc/Quickstart/index.html

2. Install H2 database

Select the installation directory -> Click Next -> Installation -> Complete

3. Log in to H2 database

The advantage of selecting the installation version is that there is an H2 console} icon after installation. Click the icon to directly start H2 and use the default browser to access the H2 login page

However, the H2 database of win 2019-10-14 does not automatically create a test database, so you can’t log in here

The error information is as follows:

Database “C:/users/COM/test” not found, either pre create it or allow remote database creation (not recommended in secure environments) [90149-200] 90149/90149 (help)

4. Login error resolution

1. Click the small yellow icon under the taskbar and select Create a new database

Select the installation path C:\users\com

Note: H2 database is installed under C:\users\com by default (COM is the system user name)

After the creation is successful, a new test will be created in the directory mv. DB file

Test again and the connection is successful

5. Data import and export

(1) Data export

CALL CSVWRITE('D:\Hadoop\H2\hello_world.csv', 'SELECT * FROM hello_world');

(2) Data import

CREATE TABLE hello_world  AS SELECT * FROM CSVREAD('D:\Hadoop\H2\hello_world.csv')

(3) Data insertion

INSERT INTO hello_world SELECT * FROM CSVREAD('D:\Hadoop\H2\hello_world.csv');

Redis Connect Error: It was not possible to connect to the redis server(s); to create a disconnected multiple

It was not possible to connect to the redis server (s); to create a disconnected multiplexer, disable AbortOnConnectFail. SocketFailure on PING

Just add abortconnect = false to our connection string

192.168.8.233:6379,abortConnect=false

[Solved] Jupiter notebook failed to start Error: DLL load failed

Solution:

1. Check whether it is in the virtual environment

If you start the python virtual environment and run Jupiter notebook on the command line of the virtual environment, the above DLL load failed error will appear

So when you want to start Jupiter notebook in a virtual environment. First use PIP install Jupiter in a virtual environment

2. Check the configuration environment variables

Add the following two paths to the environment variable

Mac uniapp Compile Error: sass-loader [How to Solve]

Sass loader occurs when uniapp is packaged and compiled

Error message: Module build failed (from ./node_modules/@dcloudio/vue-cli-plugin-uni/packages/sass-loader/dist/cjs.js):

As shown below:

Solution: sass-loader version problem

The original version was:

"sass-loader": "^7.1.0",

Amend to read:

"sass-loader": "8.0.2",

As shown in the figure: