Raise exception [HY000][1193] Unknown system variable 'event_scheduler', when synchronizing oceanbase schema

Avatar
2012app
Created

Raise exception  [HY000][1193] Unknown system variable 'event_scheduler',  when synchronizing oceanbase schema, but when i use Navicat, it's OK

Datagrip version : DataGrip 2022.3.2, and other version before  failed

And i have tried many mysql drivers from 3xx to 5xx

why datagrip must check  'event_scheduler',  'OB' does not have this param, even i use ob driver, the error happened also

Now, i have to use Naivate when OB, datagrip when other DB, it's so troublesome

 

My mac version:  Monterey

 

 

 

 

Votes

0

Share

5 comments
Avatar
2012app
Created

It's ok now, setting introsepect useing JDBC metadata in advanced config, but too hard to find

0
Avatar
vasily chernov
Created
I see, by the way could you attach IDE logs for investigation to the original issue https://youtrack.jetbrains.com/issue/DBE-16683/Cannot-proceed-because-event-scheduler-is-disabled.-Cannot-load-from-mysql.proc.-The-table-is-probably-corrupted ?
0
Avatar
2012app
Created

Done

0
Avatar
Hylian
Created

@2012app can you post how to change the advanced configure ? I have the same problem. thank you 

0
Avatar
Jun
Created

you can click there to set introsepect .

0

Please sign in to leave a comment.