sqlite3_adapter has conflict with new version of sqlite3 gem #35153

jasnow · 2019-02-04T19:11:04Z

Line 12 of activerecord-6.0.0.beta1/lib/active_record/connection_adapters/sqlite3_adapter.rb
is

gem "sqlite3", "~> 1.3.6"

and it conflicts with the new sqlite 1.4.0 gem release.

Getting these two messages:

LoadError: Error loading the 'sqlite3' Active Record adapter.
Missing a gem it depends on? can't activate sqlite3 (~> 1.3.6),
already activated sqlite3-1.4.0. Make sure all dependencies are added to Gemfile.

and

Gem::LoadError: can't activate sqlite3 (~> 1.3.6), already activated
sqlite3-1.4.0. Make sure all dependencies are added to Gemfile.

sponomarev · 2019-02-04T23:30:42Z

@jasnow You can specify gem "sqlite3", "~> 1.3.6" in your Gemfile explicitly OR wait the new rails version to be released OR use master directly.

The original issue was fixed in #35154

no-reply · 2019-02-04T23:37:53Z

@sponomarev any thoughts on what the work-around is for folks trying to test engines against existing rails versions?

My CI process generates rails apps to run the engine's suite against for a supported Ruby/Rails build matrix to. I've thought about adding a generator to adjust the Gemfile, but engine install breaks before any generator can run.

sponomarev · 2019-02-05T02:59:25Z

@no-reply It looks that you're running some database-related code in engine_cart:generate. I guess the only solution here is to specify sqlite3 version in your newly generated Gemfile.


        Prepare for `4.6.0` release

It was necessary to manually set the `sqlite3` Gem version after the release of version `1.4.0`. See rails/rails#35153 for more info.


        Prepare for `4.6.0` release

It was necessary to manually set the `sqlite3` Gem version after the release of version `1.4.0`. See rails/rails#35153 for more info.

femotizo · 2019-02-09T12:24:25Z

@jasnow You can specify gem "sqlite3", "~> 1.3.6" in your Gemfile explicitly OR wait the new rails version to be released OR use master directly.

The original issue was fixed in #35154

@jasnow @sponomarev
This solution worked for me
https://stackoverflow.com/a/54606137/1960924

jasnow · 2019-02-09T12:50:01Z

@femotizo - Thank you for confirming that this is real rails issue.


        Pin sqlite to avoid build issue

Related: rails/rails#35153 and rails/rails#35154


        Pin sqlite to avoid build issue (#2078)

Related: rails/rails#35153 and rails/rails#35154


        Pin sqlite

Rails 5.2.2 is incompatible with sqlite 1.4 Fixes rails/rails#35153


        Pin sqlite to ~> 1.3.13

Rails 5.2.2 is incompatible with sqlite 1.4 Refs [rails/rails#35153](rails/rails#35153)


        Pin sqlite to ~> 1.3.13

Rails 5.2.2 is incompatible with sqlite 1.4 Refs [rails/rails#35153](rails/rails#35153)


        Limit sqlite lib to 1.3.6. BUmp other deps

Rails sqlite_adapter does not work with the latest sqlite gem, as per rails/rails#35153 Bump some deps based on dependabot rec's.


        Update to engine_cart 2.2.0 & work around for rails/rails#35153

- Update engine_cart to 2.2.0 - Work around add to test_app_generator for rails/rails#35153 - Update rubocop to 0.66.0 - Update TravisCI config to test 2.6.2


        Downgrade sqlite gem

See issue rails/rails#35153


        Lock sqlite3 to < 1.4 due to Rails incompatibility

See rails/rails#35153.


        Add dependency constraint on sqlite3

sqlite3 1.4 is conflicting with sqlite3_adapter which requires 1.3.x See rails/rails#35153


        [DROP] Add dependency constraint on sqlite3

sqlite3 1.4 is conflicting with sqlite3_adapter which requires 1.3.x See rails/rails#35153


        Fix for sqlite error on test app

rails/rails#35153


        Explicitly specify compatible sqlite3 version

Also compare to rails/rails#35153


        Explicitly specify compatible sqlite3 version in Gemfiles

Squashed commit of the following: commit 9828193 Author: Vladimir Dobriakov <vladimir.dobriakov@dm.de> Date: Thu Apr 4 19:20:50 2019 +0200 Try more explicit sqlite3 gem spec for Rails 4.2 commit 7294a09 Author: Vladimir Dobriakov <vladimir.dobriakov@dm.de> Date: Thu Apr 4 19:17:48 2019 +0200 Try more explicit sqlite3 gem spec commit 6c275a2 Author: Vladimir Dobriakov <vladimir.dobriakov@dm.de> Date: Thu Apr 4 19:04:19 2019 +0200 Explicitly specify compatible sqlite3 version in Gemfiles commit c1b1bee Author: Vladimir Dobriakov <vladimir.dobriakov@dm.de> Date: Thu Apr 4 18:51:39 2019 +0200 Explicitly specify compatible sqlite3 version Also compare to rails/rails#35153


        restrict sqlite version (rails/rails#35153)


        Pin sqlite to avoid build issue (rspec#2078)

Related: rails/rails#35153 and rails/rails#35154


        Use rails 6.0.0.rc1 instead of the 6.0.0.beta-3 on CI

Also bumped sqlite from 1.3.6 to 1.4 because besides conflicting with the version that the sqlite adapter was trying to load [0], it is supported officially since rails 6 [1]. Related: [0] rails/rails#35153 [1] rails/rails#35844


        Use rails 6.0.0.rc1 instead of the 6.0.0.beta-3 on CI

Also bumped sqlite from 1.3.6 to 1.4 because besides conflicting with the version that the sqlite adapter was trying to load [0], it is supported officially since rails 6 [1]. Related: [0] rails/rails#35153 [1] rails/rails#35844


        chore: Set SQLite version explicitly

Rails SQLite 3 adaptor specifies SQLite gem version 1.3.6. Rails produces an error message if one attempts to use version 1.4.0. See rails/rails#35153 for more information.


        Use rails 6.0.0.rc1 instead of the 6.0.0.beta-3 on CI

Also bumped sqlite from 1.3.6 to 1.4 because besides conflicting with the version that the sqlite adapter was trying to load [0], it is supported officially since rails 6 [1]. Related: [0] rails/rails#35153 [1] rails/rails#35844


        Pin sqlite version to fix failing travis build

See here for more info: rails/rails#35153 and rails/rails#35154


        Pin sqlite version to fix failing travis build

See here for more info: rails/rails#35153 and rails/rails#35154


        Pin sqlite version to fix failing travis build

See here for more info: rails/rails#35153 and rails/rails#35154


        Restrict version on sqlite3 gem

There is a rails bug which causes compatability issues with 1.4 of this gem: rails/rails#35153 When new rails versions are released we can relax this requirement.


        Pin sqlite to avoid build issue (#2078)

Related: rails/rails#35153 and rails/rails#35154

rafaelfranca added the activerecord label Feb 4, 2019

sponomarev referenced this issue Feb 4, 2019

Relax sqlite3 version dependency #35154

Merged

no-reply referenced this issue Feb 4, 2019

Do we need to update install instructions? #3525

Closed

y-yagi closed this Feb 4, 2019

sponomarev referenced this issue Feb 5, 2019

Rails new with all defaults doesn't generate a working application anymore #35161

Closed

amalrik referenced this issue Feb 6, 2019

Seems that sqlite3 1.4 doesn't play well with Rails currently #9233

Merged

geluso referenced this issue Feb 7, 2019

bugfix using specific version of sqlite #staff #7

Closed

mike-burns referenced this issue Feb 8, 2019

fixes SQLite3 compatibility issue for test env. Closes #966 #967

Closed

This was referenced Feb 10, 2019

Enable to use args named like strong parameters asakusarb/action_args#25

Merged

Specify sqlite3 gem version asakusarb/action_args#26

Merged

benoittgt referenced this issue Feb 11, 2019

Fix fixtures path for model generator when using namespaced models #2077

Merged

benoittgt added a commit to benoittgt/rspec-rails that referenced this issue Feb 11, 2019

Pin sqlite to avoid build issue

03440c8

Related: rails/rails#35153 and rails/rails#35154

benoittgt referenced this issue Feb 11, 2019

Pin sqlite to avoid build issue #2078

Merged

jcoyne added a commit to sul-dlss/argo that referenced this issue Feb 11, 2019

Pin sqlite

Loading status checks…

20ee7c8

Rails 5.2.2 is incompatible with sqlite 1.4 Fixes rails/rails#35153

jcoyne referenced this issue Feb 11, 2019

Pin sqlite #1327

Merged

jcoyne added a commit to sul-dlss/pre-assembly that referenced this issue Feb 11, 2019

Pin sqlite to ~> 1.3.13

Loading status checks…

b81e696

Rails 5.2.2 is incompatible with sqlite 1.4 Refs [rails/rails#35153](rails/rails#35153)

jcoyne referenced this issue Feb 11, 2019

Pin sqlite to ~> 1.3.13 #449

Merged

jcoyne added a commit to sul-dlss/hydrus that referenced this issue Feb 11, 2019

Pin sqlite to ~> 1.3.13

Loading status checks…

f383b0f

Rails 5.2.2 is incompatible with sqlite 1.4 Refs [rails/rails#35153](rails/rails#35153)

jcoyne referenced this issue Feb 11, 2019

Pin sqlite to ~> 1.3.13 #268

Merged

guledali referenced this issue Feb 12, 2019

New Install SQLITE3 error #106

Closed

bibliotechy referenced this issue Feb 12, 2019

Bump some dependencies. Limit sqlite to 1.3.6. #309

Closed

ouranos added a commit to ouranos/mno-enterprise that referenced this issue Mar 27, 2019

Add dependency constraint on sqlite3

Loading status checks…

fab6e9d

sqlite3 1.4 is conflicting with sqlite3_adapter which requires 1.3.x See rails/rails#35153

ouranos referenced this issue Mar 27, 2019

Add dependency constraint on sqlite3 #807

Merged

ouranos added a commit to ouranos/mno-enterprise that referenced this issue Mar 27, 2019

[DROP] Add dependency constraint on sqlite3

Loading status checks…

a4dfa0a

sqlite3 1.4 is conflicting with sqlite3_adapter which requires 1.3.x See rails/rails#35153

tacataca added a commit to tacataca/impressionist that referenced this issue Mar 27, 2019

Fix for sqlite error on test app

dfcfaf7

rails/rails#35153

geekq pushed a commit to geekq/workflow-activerecord that referenced this issue Apr 4, 2019

Explicitly specify compatible sqlite3 version

Loading status checks…

c1b1bee

Also compare to rails/rails#35153

mpg-takashi-miyahara referenced this issue Apr 24, 2019

Fix sqlite3's version to 1.3.6 series #337

Merged

jturkel referenced this issue Apr 24, 2019

Upgrade to versions of Rails with more flexible sqlite dependencies #85

Merged

fwolfst added a commit to ecovillage/neseri that referenced this issue Apr 30, 2019

restrict sqlite version (rails/rails#35153)

505be3d

benoittgt added a commit to benoittgt/rspec-rails that referenced this issue May 1, 2019

Pin sqlite to avoid build issue (rspec#2078)

501df16

Related: rails/rails#35153 and rails/rails#35154

mracos referenced this issue May 4, 2019

Use rails 6.0.0.rc1 instead of the 6.0.0.beta-3 on CI #5073

Merged

ykamez referenced this issue May 25, 2019

Downgrade sqlite3 #148

Merged

This was referenced Jul 4, 2019

Fix statesman index detection gocardless/statesman#354

Merged

Use Rails 6 rc1 in CI gocardless/statesman#355

Merged

murny pushed a commit to murny/acts_as_votable that referenced this issue Jul 11, 2019

Pin sqlite version to fix failing travis build

e44ebad

See here for more info: rails/rails#35153 and rails/rails#35154

murny added a commit to murny/acts_as_votable that referenced this issue Jul 11, 2019

Pin sqlite version to fix failing travis build

6ff9b4b

See here for more info: rails/rails#35153 and rails/rails#35154

murny referenced this issue Jul 11, 2019

Pin sqlite version to fix failing travis build #198

Merged

ryanto added a commit to ryanto/acts_as_votable that referenced this issue Jul 18, 2019

Pin sqlite version to fix failing travis build

cdb1b26

See here for more info: rails/rails#35153 and rails/rails#35154

This was referenced Jul 27, 2019

OSS Gate Workshop: tokyo: 2019-07-27: takashi-miyahara: activerecord-import: Work log oss-gate/workshop#1222

Closed

Fix sqlite3's version to 1.3.6 series zdennis/activerecord-import#633

Merged

paulodiovani referenced this issue Sep 3, 2019

Bugfix / Use rails 5.0 compatible sqlite #369

Open

JonRowe added a commit to rspec/rspec-rails that referenced this issue Oct 3, 2019

Pin sqlite to avoid build issue (#2078)

a9094cb

Related: rails/rails#35153 and rails/rails#35154

Please note that GitHub no longer supports your web browser.

rails/rails

sqlite3_adapter has conflict with new version of sqlite3 gem #35153

sqlite3_adapter has conflict with new version of sqlite3 gem #35153

jasnow commented Feb 4, 2019 •

edited

This comment has been minimized.

sponomarev commented Feb 4, 2019

This comment has been minimized.

no-reply commented Feb 4, 2019 •

edited

This comment has been minimized.

sponomarev commented Feb 5, 2019

This comment has been minimized.

femotizo commented Feb 9, 2019

This comment has been minimized.

jasnow commented Feb 9, 2019

Please note that GitHub no longer supports your web browser.

rails/rails

Join GitHub today

sqlite3_adapter has conflict with new version of sqlite3 gem #35153

Comments

jasnow commented Feb 4, 2019 • edited

This comment has been minimized.

sponomarev commented Feb 4, 2019

This comment has been minimized.

no-reply commented Feb 4, 2019 • edited

This comment has been minimized.

sponomarev commented Feb 5, 2019

This comment has been minimized.

femotizo commented Feb 9, 2019

This comment has been minimized.

jasnow commented Feb 9, 2019

jasnow commented Feb 4, 2019 •

edited

no-reply commented Feb 4, 2019 •

edited