Обсуждение: Insert statement doesn't complete

Поиск
Список
Период
Сортировка

Insert statement doesn't complete

От
Trang Le
Дата:
Hi all, 

I am facing an issue.

when I run a script:
INSERT INTO mdm.etl_exception_info
SELECT
        *
FROM mdm.etl_exception_info_vw2;
after running script I check this script in pg_lock, everything ok, job
done, data is inserted. However, the session contains the script above
doesn't complete though data is inserted and job done that is verified in
pg_lock.

Could you help me on this issue?

Thanks all.

Regards,
Trang

Re: Insert statement doesn't complete

От
"David G. Johnston"
Дата:
On Saturday, August 28, 2021, Trang Le <trang.le@evizi.com> wrote:

after running script


How?
 

 I check this script in pg_lock, everything ok, job
done, data is inserted.


You can tell this from pg_lock?
 


 However, the session 


Where is this session?
 

David J.
 

Re: Insert statement doesn't complete

От
Mladen Gogala
Дата:


On 8/28/21 11:40 PM, Trang Le wrote:
Hi all, 

I am facing an issue

when I run a script:
INSERT INTO mdm.etl_exception_info
SELECT
        *
FROM mdm.etl_exception_info_vw2;

Is there any error message thrown? If there is, can you tell us? Is autocommit on? What does the log say?

after running script I check this script in pg_lock, everything ok, job
done, data is inserted. However, the session contains the script above
doesn't complete though data is inserted and job done that is verified in
pg_lock.

What does the phrase "the script above doesn't complete" mean? How do you know that the script doesn't complete? Is the script hanging?  Furthermore, what is the software version? What platform are you using?


Could you help me on this issue?

Insufficient data for a meaningful answer.



Thanks all.

Regards,
Trang
-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com