JVM while holding global locks

Chen_SunChen_Sun Registered User

When using UDL, sometimes I meet "JVM while holding global locks". Why this happend?

Here is the SQL used:

create flex external table aim_track_20190210() as copy with source OssSource(path='oss://xxxxxxx20190210*') parser fjsonparser(flatten_maps=false, record_terminator=E'\n');

create table aim_track_test4 as select m1 from aim_track_20190210 limit 2000;

Answers

  • Jim_KnicelyJim_Knicely Administrator, Moderator, Employee, Registered User, VerticaExpert
    edited February 12

    Which CREATE TABLE statement generates the error? If it's the second, can you run the SELECT part okay?

    select m1 from aim_track_20190210 limit 2000;

  • SruthiASruthiA Employee, Registered User, VerticaExpert

    Could you please share us with UDL OSSSOURCE JAVA code and share us more information on the issue. Is the CREATE flex external table query erroring out?

  • Chen_SunChen_Sun Registered User
    via Email
    Thanks for the reply. Running the second statement solved my problem. I
    am wondering why this issue happen . Is there a better solution without
    running extra statement?

    Jim_Knicely
    于2019年2月12日周二 下午9:16写道:

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file