Tag Archives: ]

Database Insert error: ora-06550 [How to Solve]

Problem: an error is reported when inserting data into the database:

ORA-06550: line 1, column 7: PLS-00905: object TEST.USERINFO_INSERT is invalid

ORA-06550: line 1, column 7: PL/SQL: Statement ignored

Solution:

Debug server, error found:

Unable to find ‘struts.multipart.saveDir’ property setting. Defaulting to javax.servlet.context.tempdir

Resolution of this error: http://hi.baidu.com/fgfd0/blog/item/ed1b1c388bb4a6f4b311c721.html

Directly execute the stored procedure on the database, 9i normal, 10g error: ora-06575 package or function is in an invalid state

In Oracle SQL developer, we found dependencies, procedure_The status of insertde is invalid

Looking at the procedures item in the database, I found that many stored procedures have errors

The original error reason for this problem is: the fields in the table are changed, and the stored procedure is not changed together, so the stored procedure is wrong

 

This database table was built by elder martial brother with PD. After it was built, a tool was used to automatically generate some stored procedures. By default, this tool generated SQL server, and the elder martial brother processed it into oracle

Hehe, we need to change the stored procedure. I’ve hardly touched stored procedures before

[notes] analysis of monkey error reporting log

Today, Xiaocai saw a monkey error message sent by a group member in a test group. In fact, it is a very simple error message

Personally, I think monkey is easy to operate, but actually viewing log analysis log is also a very important link. If the error analysis is not detailed enough, it is easy to be mistaken for a program problem

Here is an example

In fact, this error log has simply told you the reason for the error

The analysis is as follows: the first line: monkey is terminated due to an error

Line 2: the error event of the error occurs at the 153 th time

The third line: send rotation event, and the degree is 0 degrees

Obviously, the error is caused by rotating the screen. Is it the problem of the software itself?Let’s analyze it next

 

First: 1. Check whether the screen rotation function in your simulator or app application is turned on

　　   2. In fact, the screen of some applications will not rotate. Even if the operation is made, it will not actually rotate. In such an event, if monkey performs the rotation, the screen will not rotate and the parameters will not change, then monkey may mistakenly report it as an error

 

If the function needs to be rotated, it is a software error. If there is no such requirement, it is actually a false alarm

At this time, 1. Reduce the proportion of such events or

        2. Skip the error execution directly and ignore the error

[troubleshooting] through the remote execution of the script by the scheduling system, the MySQL command not found exception is reported

Geeks, please accept the hero post of 2021 Microsoft x Intel hacking contest>>>

Today, when the company uses LS scheduling system (Baidu’s internal tool) to execute remote scripts, it fails every time

The content of the script is relatively simple. In fact, it is to insert the data in HDFS (AFS) into Palo (doris) database. The script is as follows:

mysql -h xxx -P 9030 -uxxx -p'xxx' -e "LOAD LABEL baijiahao.bjh_spider_view_count_${day}_${label_time} (DATA INFILE('afs://xxx/user/feed-bjh/database/spider_view_count_showx/${day}/*') INTO TABLE bjh_spider_view_count) PROPERTIES('cluster'='feed_bjh','timeout'='86400','max_filter_ratio'='0.0001')"

At first, I thought it was my script problem. I have been testing this script on the remote development machine and found that it can be executed correctly, but it will fail through the scheduling system

At first, I didn’t pay attention to the error log. Suddenly, I saw that the error in the log was:

mysql command not found

There is no problem for me to test the MySQL instruction on the development machine

After searching for information, I found that the reason for this problem is that my MySQL is installed in the data partition I set, not in the default/usr/bin/MySQL. When SSH executes commands remotely, it reads from/usr/bin, so it can’t be found

Through which mysql, I found that my MySQL path is:

alias mysql='/home/work/opt/mysql/mysql-5.6.38/bin/mysql'
    ~/opt/mysql/mysql-5.6.38/bin/mysql

Now there are two solutions:

(1) Write the full name of MySQL in the script

/home/work/opt/mysql/mysql-5.6.38/bin/mysql -h xxx -P 9030 -uxxx -p'xxx' -e "LOAD LABEL baijiahao.bjh_spider_view_count_${day}_${label_time} (DATA INFILE('afs://xxx/user/feed-bjh/database/spider_view_count_showx/${day}/*') INTO TABLE bjh_spider_view_count) PROPERTIES('cluster'='feed_bjh','timeout'='86400','max_filter_ratio'='0.0001')"

(2) To establish a soft connection, you need root permission

ln -s /home/work/opt/mysql/mysql-5.6.38/bin/mysql /usr/bin/mysql

Reference

https://blog.csdn.net/qq1124794084/article/details/77529889

The jar file rt.jar has no source attachment appears in eclipse

Original text: http://blog.csdn.net/u011514810/article/details/53196371

————————————————————————————————-

As a rookie, it is very important to check the Java source code. It’s very convenient to view the source code of a class in eclipse. Directly press and hold the CTRL + mouse click class or method, then the source code of this class or method will appear. However, before that, you need to import the source code src.zip into eclipse. This source code src.zip does not need to be downloaded. As long as you install JDK, there will be src.zip in the directory where JDK is installed. There is no need to unzip it. Let’s see how to import the source code into eclipse

1. In the eclipse interface, click window — preferences — Java — installed jres

2. Select d: Java. Lib. RT. Jar, and then select source attachment

3. Select external location, click external file, browse the directory where JDK is installed, find src.zip, click OK and finish