Could not query user's page views

[kenxt]

Summary:

I have a self-hosted canvas(prod 2024/09/23), and configed a cassandra, copyed analytics. I found the file cassandra.yml has gone, so I created a cassandra.yml, and executed "rake db:migrate" again, the system created tables in cassandra. But I could not query any user's pageviews , and the table page_views is empty in cassandra. I can access "views courses analytics", and canvas display course related data information on the page.

Steps to reproduce:

1.git analytics
2.rake db:migrate successfuly, Setting.set('enable_page_views', 'cassandra')
3.fail to rake db:migrate_pageviews_to_cassandra.
rake aborted!
Don't know how to build task 'db:migrate_pageviews_to_cassandra' (See the list of available tasks with

Expected behavior:

canvas can display course related data information in analytics pages.
administrator can query page view history.

Actual behavior:

the page view history is empty

Additional notes:

I have not found db:migrate_pageviews_to_cassandra in the list of available tasks with rake --tasks
I found some explanatory text in gems/canvas_cassandra, I'm not sure if there are more detailed explanations or guidance documents available

[kenxt]

I think I have found the answer.
I have reviewed the code content of models/page-view.rb#self.page-viewed_method:
def self.page_view_method
enable_page_views = Setting.get("enable_page_views", "false")
return false if enable_page_views == "false"
enable_page_views = "db" if %w[true cache].include?(enable_page_views) # backwards compat
enable_page_views.to_sym
end
I found that the code only determined whether enable_mage-views was enabled (based on https://github.com/instructure/canvas-lms/wiki/Settings-%28customization%29,the default value is false)
When configured as true or cache, the content of the pageviews will be written to the postgres table page_views.
So I Executed:
Setting.set('enable_page_views', 'true') or Setting.set('enable_page_views', 'db')
After restarting the Canvas service, it was found that access records could be displayed.
When I executed the log query statement:
tail - f production. log | grep page-views
I found the written SQL:
INSERT INTO "public"."page_views" ("request_id", "session_id", "user_id", "url", "controller", "action", "interaction_seconds", "created_at", "updated_at", "user_request", "render_time", "user_agent", "summarized", "account_id", "http_method", "remote_ip") VALUES ('......

So the new version of Canvas has changed the mechanism for saving pageviews, which is partially explained in gems/canvas_cassandra/Readme. It's just that the document doesn't clearly describe the changes in parameters, and I don't know if the Canvas system still supports writing pageviews to cassandra， or I haven't read it myself.

[kenxt]

The current canvas version does not support
writing page views to cassandra. dB/migrate/20240604155656_migrate_cassandra_data_to_postgres.rb is used to copy data from cassandra to postgres and set enable_page_view to db.