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

[Bug] 'unregister job error' when I tried to drop the job after the table was dropped. #49157

Open
2 of 3 tasks
Mike0808 opened this issue Mar 17, 2025 · 0 comments
Open
2 of 3 tasks

Comments

@Mike0808
Copy link

Search before asking

  • I had searched in the issues and found no similar issues.

Version

Dorsi v2.1.6

What's Wrong?

I got an 'unregister job error' when I tried to drop the job after the table was dropped.

LogError.txt

What You Expected?

Removing job after removing table

How to Reproduce?

  1. Create test table with this settings
    ENGINE=OLAP
    DUPLICATE KEY(date)
    DISTRIBUTED BY HASH(date) BUCKETS 5
    PROPERTIES ("replication_num" = "1");

  2. Create Job
    CREATE JOB xxxxx
    ON SCHEDULE EVERY 1 DAY STARTS '2025-03-17 10:45:00'
    DO
    INSERT INTO
    xxxxxx
    SELECT

FROM xxxx

  1. Drop Table and create same table but with partitions
    ENGINE=OLAP
    DUPLICATE KEY(date)
    PARTITION BY RANGE(date)
    (
    PARTITION p01_10 VALUES [("2023-08-01"), ("2023-08-10")),
    PARTITION p11_20 VALUES [("2023-08-11"), ("2023-08-20")),
    PARTITION p21_31 VALUES [("2023-08-21"), ("2023-08-31"))
    )
    DISTRIBUTED BY HASH(date) BUCKETS 50
    PROPERTIES ("replication_num" = "1");

  2. Trying to drop job and got error

Anything Else?

No response

Are you willing to submit PR?

  • Yes I am willing to submit a PR!

Code of Conduct

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

1 participant