I ran several hundred broker load jobs last night ...
# questions-and-troubleshooting
c
I ran several hundred broker load jobs last night in migrating from MariaDB to Starrocks 4.0. I was monitoring the success via information_schema.loads. This morning, all the jobs are missing from the table. They were there last night. ADMIN SHOW FRONTEND CONFIG shows load_history_retained_days=30. Any idea what is going on? I'm running a simple configuration with one FE and one BE all on the same physical server.
k
in docker env? service restarted? are the data still there?
c
I think I found the issue. By default starrocks keeps 1000 rows in information_schema.loads. There were 900+ administrative rows that pushed out the previous days load jobs from that table. Solution was to change label_keep_max_num in fe.conf
😀 1