Mailing List Archive: Catalyst: Users

experiencing SQLite crash

Index | Next | Previous | View Threaded

laurent.dami at justice

Oct 14, 2008, 11:49 PM

Post #1 of 3 (501 views)
Permalink

experiencing SQLite crash

Hi all,

I have a Catalyst app using SQLite as storage. It has been running for
several months without any problem.
Now in the last few days we has several crashes of SQLite (file gets
corrupted). This is just incomprehensible because all development and
production engineers claim that nothing has changed in application code,
nor in Catalyst, DBD::Sqlite, Apache, or operating system (Solaris), and
we can't reproduce the problem in dev. So we don't even know where to
start our investigations.

Any hints, suggestions, related info, etc. would be welcome.

The production server is running Apache 2.2.8 Solaris / Catalyst 5.7007
/ DBD::SQlite 1.13.

Thanks in advance,

Laurent Dami

david.morel at amakuru

Oct 15, 2008, 12:12 AM

Post #2 of 3 (454 views)
Permalink

Re: experiencing SQLite crash [In reply to]

Le 15 oct. 08 à 08:49, Dami Laurent (PJ) a écrit :

> Hi all,
>
> I have a Catalyst app using SQLite as storage. It has been running
> for several months without any problem.
> Now in the last few days we has several crashes of SQLite (file gets
> corrupted). This is just incomprehensible because all development
> and production engineers claim that nothing has changed in
> application code, nor in Catalyst, DBD::Sqlite, Apache, or
> operating system (Solaris), and we can't reproduce the problem in
> dev. So we don't even know where to start our investigations.
>
> Any hints, suggestions, related info, etc. would be welcome.
>
The only time I've seen SQLIte files get corrupted was because of
faulty hardware (disks, mainly)

D.Morel
_______________________________________________
List: Catalyst[at]lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst[at]lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/

peter at dragonstaff

Oct 15, 2008, 2:27 AM

Post #3 of 3 (457 views)
Permalink

Re: experiencing SQLite crash [In reply to]

Laurent Dami wrote:
> Now in the last few days we has several crashes of SQLite (file gets
> corrupted). This is just incomprehensible because all development and
> production engineers claim that nothing has changed in application code,
> nor in Catalyst, DBD::Sqlite, Apache, or operating system (Solaris), and
> we can't reproduce the problem in dev. So we don't even know where to
> start our investigations.

If you type in "dmesg" do you see any disk warnings in the system log?
"man syslogd" for more details.

Regards, Peter
http://perl.dragonstaff.co.uk

_______________________________________________
List: Catalyst[at]lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst[at]lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact lists@gossamer-threads.com