syncdb interval exceeded

[MarkAgar]

Hi,

We recently had a space issue with the PC where we routinely run a syncdb on the web_logs table in the canvas_logs namespace. The space issue has now been resolved but when I attempt a dap syncdb it is erroring with "The maximum interval for this request should be '30' days. The requested interval was '35' days"

Is the only solution to truncate and do a full initdb on the table?

Thanks for any suggestions

[sgergely · Accepted solution]

Hi @MarkAgar,

The reason you are getting this error message is because you are trying to download (sync) data from web_logs table that is not available. Web_logs table only provides the last 30 days of data. I guess you have last synced 35 days ago and the DAP CLI tries to use that start time. The start time is stored in the `dap_meta` table, you might want to change it to cover only 30 days and then it would be fine. Or do a snapshot and start from there.

Beware, if you are doing `dropdb` before doing a new snapshot you might loose data and would end up with the last 30 days of data only.

[MarkAgar]

Hi,

Thanks for your reply. If I query the on prem (MySQL) database for CanvasData2 I can see only a table named 'dap_meta_backup' which doesn't contain an entry for 'web_logs' - any ideas?

Regards,

Mark

[MarkAgar]

I see now the table with the metadata in it is called instructure_dap_table_sync 👍