Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SLAVE-DOWN issue on DBA_JOBS #8

Open
stoch opened this issue Apr 29, 2020 · 2 comments
Open

SLAVE-DOWN issue on DBA_JOBS #8

stoch opened this issue Apr 29, 2020 · 2 comments
Assignees

Comments

@stoch
Copy link

stoch commented Apr 29, 2020

For odpi on sbs1.int

SELECT
    WHAT, JOB, SCHEMA_USER, LAST_DATE, THIS_DATE, NEXT_DATE, TOTAL_TIME, BROKEN,
    FAILURES
FROM 
    DBA_JOBS
ORDER BY
    WHAT

grafik

{slave_down,[
{dderlodpi,run_query,6,[{file,"dderl/src/dderlodpi.erl"},{line,402}]},
{dderlodpi,exec,4,[{file,"dderl/src/dderlodpi.erl"},{line,79}]},
{odpi_adapter,process_query,3,[{file,"dderl/src/odpi_adapter.erl"},{line,742}]},
{odpi_adapter,process_cmd,6,[{file,"dderl/src/odpi_adapter.erl"},{line,307}]},
{dderl_session,spawn_process_call,8,[{file,"dderl/src/dderl_session.erl"},{line,659}]}]}

2020-04-29 18:27:37.932 [error] [dderl<0.8637.6>@odpi_adapter:process_query:777]
 query error {error,slave_down} for
 <<"SELECT\r\n WHAT, JOB, SCHEMA_USER, LAST_DATE, THIS_DATE, NEXT_DATE, TOTAL_TIME, BROKEN,\r\n FAILURES\r\nFROM\r\n DBA_JOBS\r\nORDER BY\r\n WHAT">>
 whith bind values undefined

2020-04-29 18:28:33.417 [error] [dderl<0.9902.6>@dderlodpi:exec:81]
 run_query(select CON_ID, CON_ACID, CON_ESTID, CON_NAME, CON_ESID, CON_DATESTART, CON_DATEEND, CON_SHORTID, CON_PMID from contract where CON_PMID in ('0259630091', '0559477345') and CON_SHORTID like '6%' and CON_ESID = 'A' and CON_ETID = 'IPC',undefined,select CON_ID, CON_ACID, CON_ESTID, CON_NAME, CON_ESID, CON_DATESTART, CON_DATEEND, CON_SHORTID, CON_PMID, contract.ROWID from contract where CON_PMID in ('0259630091', '0559477345') and CON_SHORTID like '6%' and CON_ESID = 'A' and CON_ETID = 'IPC')
{slave_down,[
{dderlodpi,run_query,6,[{file,"dderl/src/dderlodpi.erl"},{line,402}]},
{dderlodpi,exec,4,[{file,"dderl/src/dderlodpi.erl"},{line,79}]},
{odpi_adapter,process_query,3,[{file,"dderl/src/odpi_adapter.erl"},{line,746}]},
{odpi_adapter,process_cmd,6,[{file,"dderl/src/odpi_adapter.erl"},{line,357}]},
{dderl_session,spawn_process_call,8,[{file,"dderl/src/dderl_session.erl"},{line,659}]}]}

2020-04-29 18:28:33.417 [error] [dderl<0.9902.6>@odpi_adapter:process_query:777]
 query error {error,slave_down} for <<"select CON_ID, CON_ACID, CON_ESTID, CON_NAME, CON_ESID, CON_DATESTART, CON_DATEEND, CON_SHORTID, CON_PMID from contract where CON_PMID in ('0259630091', '0559477345') and CON_SHORTID like '6%' and CON_ESID = 'A' and CON_ETID = 'IPC'">> whith bind values []
@c-bik
Copy link
Contributor

c-bik commented Apr 30, 2020

@KarlKeiser also fix log spelling "...whith..."

@stoch
Copy link
Author

stoch commented May 26, 2020

This now works (returning an empty result):
SELECT
WHAT, JOB, SCHEMA_USER, LAST_DATE, THIS_DATE, NEXT_DATE, TOTAL_TIME, BROKEN, FAILURES
FROM DBA_JOBS
ORDER BY WHAT

CANNOT REPRODUCE RIGHT NOW!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants