ruby on rails SQLite3::BusyException

ruby on rails SQLite3::BusyException

Running a rails site right now using SQLite3. About once every 500 requests or so, I get a ActiveRecord::StatementInvalid(SQLite3::BusyException: database is locked:... What's the way to fix this tha…


“MySQL server has gone away” with Ruby on Rails

After our Ruby on Rails application has run for a while, it starts throwing 500s with "MySQL server has gone away". Often this happens overnight. It's started doing this recently, with no obvious cha…


python How do I include a stacktrace in my Django 500.html page?

I'm running Django 1.0 and I'm close to deploying my app. As such, I'll be changing the DEBUG setting to False. With that being said, I'd still like to include the stacktrace on my 500.html page whe…


Using SQLite in a Python program

I have created a Python module that creates and populates several SQLite tables. Now, I want to use it in a program but I don't really know how to call it properly. All the tutorials I've found are e…


"Unknown column 'user_id' error in django view

I'm having an error where I am not sure what caused it. Here is the error: Exception Type: OperationalError Exception Value:(1054, "Unknown column 'user_id' in 'field list'") Does anyone kno…



java Hibernate: “Field 'id' doesn't have a default value”

I'm facing what I think is a simple problem with Hibernate, but can't solve it(Hibernate forums being unreachable certainly doesn't help). I have a simple class I'd like to persist, but keep getting:…


How can I process data to avoid MySQL “incorrect string value” error?

I am trying to use a Rake task to migrate some legacy data from MS Access to MySQL. I'm working on Windows XP, using Ruby 1.8.6. I have the encoding for Rails set as "utf8" in database.yml. Also, the…


Does SQLite lock the database file on reads?

I'm investigating SQLite as a storage engine, and am curious to know whether SQLite locks the database file on reads. I am concerned about read performance as my planned project will have few writes,…


Can't connect to MySQL server error 111

I installed mysql server on linux box IP=192.168.1.100 but when i try to connect to this IP it alway error(111). but use localhost and 127.0.0.1 is OK. [email protected]# ifconfig | grep "inet addr"…


python Lost connection to MySQL server during query

I have a huge table and I need to process all rows in it. I'm always getting this Lost connection message and I'm not able to reconnect and restore the cursor to the last position it was. This is basi…




django error utils sqlite3 sqlite database python mysql for table