On Mon, Jul 22, 2013 at 2:38 PM, Philip Goetz <philgo...@gmail.com> wrote:
> I have a Perl program that we have run successfully every day for > almost the past 2 years, but which crashes today with the error > message: > > FATAL ERR: Can't do PRAGMA cache_size = 1000000: attempt to write a > readonly database > Unable to recreate the problem here with 3.7.17 or 3.8.0, unix or windows. > > The SQLite database in question is readonly (group and world have only > read permission), and always has been, and the code has always used > PRAGMA cache_size = 1000000 on it immediately after opening its > readonly connection. > > Running Perl 5.16.1 built for x86_64-linux-thread-multi on CentOS 6. > Have DBD::SQLite v. 1.39, Bundle::DBI 1.627. > The line of code that triggers the crash is > > $dbh->do($cmd) or die "FATAL ERR: Can't do $cmd: $DBI::errstr"; > > where $cmd = "PRAGMA cache_size = 1000000" > > Is there a way to set the default cache size for this sqlite db? > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users