search

AlexGruPerm / ora_ch

Data loader from oracle to clickhouse and back.
1 stars 0 forks source link

Save error into log and change repo state to Wait. #19

Closed AlexGruPerm closed 8 months ago

AlexGruPerm commented 8 months ago

When service is asked to create new table in new database, service create db but don't have privelege to create new table in new db. And freeze with 

res = 500 - Internal Server Error - {"message":" already running id = XXX ,look at tables: ora_to_ch_tasks, ora_to_ch_tasks_tables "}

Save errors into ora_to_ch_tasks and change Repo state to Wait. Or better solve problem with grants.

AlexGruPerm commented 8 months ago

Or when table doen't exist. recreateTableCopyData Table X does not exist. Maybe you meant Y?. (UNKNOWN_TABLE)

When we use mode recreate:0, and table doesn't exist.

AlexGruPerm commented 8 months ago

Fixed by saveingError in copyTableEffect after sessCh.whereAppendIntX