Creating cache [.ai_related_posts_cache.sqlite3]: libblas.so.3: cannot open shared object file: No such file or directory (RuntimeError)

[RalphHightower]

I've been using jekyll_ai_related_posts for about four months on @RalphHightower/blog. The following error started on January 10, 2025. I had made some configuration changes when the problem started. I backed out the changes and even did a revert back to 2025-01-10. I've tried everything that I could think of and nothing has worked.

In another repository, @RalphHightower/RalphHightower, I made a change in a markdown file and I got the same error. Since that's just a standard website and not a blog, I commented out jekyll_ai_related_posts in the Gemfile and _config.yml and the website build worked.

Thanks,
@RalphHightower

Run bundle exec jekyll build --trace --incremental --baseurl "/blog"
  bundle exec jekyll build --trace --incremental --baseurl "/blog"
  shell: /usr/bin/bash -e {0}
  env:
    GITHUB_PAGES: true
    JEKYLL_ENV: production
    JEKYLL_GITHUB_TOKEN: 
    LOG_LEVEL: debug
To use retry middleware with Faraday v2.0+, install `faraday-retry` gem
Configuration file: /home/runner/work/blog/blog/_config.yml
            Source: /home/runner/work/blog/blog
       Destination: /home/runner/work/blog/blog/_site
 Incremental build: enabled
      Generating... 
  AI Related Posts: Creating cache [.ai_related_posts_cache.sqlite3]
bundler: failed to load command: jekyll (/home/runner/work/blog/blog/vendor/bundle/ruby/3.3.0/bin/jekyll)
/home/runner/work/blog/blog/vendor/bundle/ruby/3.3.0/gems/sqlite-vss-0.1.2-x86_64-linux/lib/sqlite_vss.rb:15:in `load_extension': libblas.so.3: cannot open shared object file: No such file or directory (RuntimeError)
	from /home/runner/work/blog/blog/vendor/bundle/ruby/3.3.0/gems/sqlite-vss-0.1.2-x86_64-linux/lib/sqlite_vss.rb:15:in `load_vss'
	from /home/runner/work/blog/blog/vendor/bundle/ruby/3.3.0/gems/sqlite-vss-0.1.2-x86_64-linux/lib/sqlite_vss.rb:19:in `load'
	from /home/runner/work/blog/blog/vendor/bundle/ruby/3.3.0/gems/jekyll_ai_related_posts-0.1.4/lib/jekyll_ai_related_posts/generator.rb:194:in `setup_database'
	from /home/runner/work/blog/blog/vendor/bundle/ruby/3.3.0/gems/jekyll_ai_related_posts-0.1.4/lib/jekyll_ai_related_posts/generator.rb:19:in `generate'

[mkasberg]

Glad to hear it was working well for you for a while, and sorry to hear about the error.

It looks like the problem is happening with the sqlite-vss gem (which is a dependency of jekyll_ai_related_posts). Still, I can help you try to troubleshoot here. I don't know exactly what's wrong but I can list a few ideas you might try.

libblas.so.3 is a linear algebra library. The sqlite-vss docs have the following:

Do note that on Linux machines, you'll have to install some packages to make these options work:

sudo apt-get update
sudo apt-get install -y libgomp1 libatlas-base-dev liblapack-dev

liblapack depends on libblas so I bet that's it. Give it a try and see if it fixes the problem?

Please let me know if that's the fix, if so I'll add something to the readme here in jekyll_ai_related_posts to make this more clear.

Also, I noticed the following while looking into this:

sqlite-vss is not in active development. Instead, my effort is now going towards sqlite-vec, which is a similar vector search SQLite extension, but should be much easier to install and use than sqlite-vss.

That is not currently causing any problems, but I've written an issue for myself to look into migrating jekyll_ai_related_posts to sqlite-vec so we can take advantage of easier installation and continued development! (#2)