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

[Solved] Could not create cudnn handle: CUDNN_STATUS_INTERNAL_ERROR

Error report tensorflow/stream_ executor/cuda/cuda_ dnn.cc:338] Could not create cudnn handle: CUDNN_ STATUS_ INTERNAL_ ERROR

Error code

2019-05-05 09:34:42.298865: I tensorflow/stream_executor/platform/default/dso_loader.cc:42] Successfully opened dynamic library libcublas.so.10.0
2019-05-05 09:34:42.469839: I tensorflow/stream_executor/platform/default/dso_loader.cc:42] Successfully opened dynamic library libcudnn.so.7
2019-05-05 09:34:43.086143: E tensorflow/stream_executor/cuda/cuda_dnn.cc:338] Could not create cudnn handle: CUDNN_STATUS_INTERNAL_ERROR
2019-05-05 09:34:43.100978: E tensorflow/stream_executor/cuda/cuda_dnn.cc:338] Could not create cudnn handle: CUDNN_STATUS_INTERNAL_ERROR

Solutions

First of all, it’s a big hole. I’ve found many ways on the Internet, basically changing the GPU runtime config. I find that running some programs doesn’t work; There are also requests to downgrade CUDA and cudnn versions. I tried to downgrade CUDA 10.1 all the way to 9.0, and cudnn has been changed all the time. The error still exists, and it still doesn’t work

In order to solve this problem, I try to install tensorflow GPU with docker. It is found that the program can run successfully, but it is not very convenient. I find that Anaconda uses CONDA to install tensorflow GPU in a virtual environment. Tensorflow GPU will automatically install CUDA and cudnn in this environment, and will not affect CUDA and cudnn already installed outside the ring, but the default version is relatively low, so, The best way is to specify the version to install. You only need to specify the version of tensorflow, and the versions of CUDA and cudnn will correspond

Install in virtual environment

conda install tensorflow-gpu==1.12

This simple command has been torturing for several days. CUDA cudnn tensorflow has been tried in various versions. On GitHub, many people say that they are waiting for the new version of tensorflow to be repaired. Indeed, this method can only solve the problem temporarily, and can’t migrate to a higher version, such as tensorflow 2.0, so for the time being, it’s better to use 1.12

[daily development record] pycurl Python 3 error (23),’failed writing body (0= 456)

Explain the function of static keyword and final keyword in Java in detail>>>

TypeError: string argument expected, got ‘bytes’
error(23, ‘Failed writing body (0 != 456)’)

If the above error is reported, it is caused by the following code

buff = StringIO()
self.curl.setopt(pycurl.WRITEFUNCTION, buff.write)

Note that the package path of stringio () in Python 3 is Io. Stringio

Change the above stringio() to:

buff = BytesIO()
self.curl.setopt(pycurl.WRITEFUNCTION, buff.write)

Similarly, the package path of bytesio() is Io. Bytesio

[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

[solution note] tex insert PDF compilation prompt “no boundingbox”

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

This is a problem encountered in submitting a revised version of an article recently. Two PDF images have been inserted into the Tex file. The local compilation is pdflatex, and there is no problem. However, the journal submission system is pdftex, which can’t process PDF images

pdfTeX Error: Cannot determine size of graphic in xxx.pdf (no BoundingBox).

After a simple search, it is basically to remove the options added when referring to the graphicx macro package or compile with pdflatex instead. But I didn’t add this item, and the online compiler can’t change the engine, so I can only choose the third scheme: set the required box when inserting the PDF image

First, you need to know the size of the PDF to insert. Open the PDF file with VIM at the terminal, and there will be a line indicating the box range of the PDF in front of a lot of incomprehensible garbled codes. The line of a file I used is as follows:

/MediaBox [ 0 0 929.10375 471.60375 ] /Annots [ ] /Resources 8 0 R

So insert the PDF image:

\begin{figure}
\centering
\includegraphics[width=\textwidth, bb=0 0 930 475]{xx.pdf}
\caption{xxxxx\label{fig:xx}}
\end{figure}

Among them, the width setting takes up the page space, and the range of box setting with BB should be a little larger than the box given by PDF. The specific value depends on the actual effect. Note that if the box height is too small, the top of the picture may block the top header of the page. At this time, the fourth parameter (indicating how high the box is) can be set larger

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