hi!
i get a lot of "OperationalError: database is locked" errors lately. what is this error related to and can this error be addressed?
thanks, raoul
I think this is the beauty of sqlite. And I think Adam would have to look into it.
Maybe we are better using MySQL or something, but I'm not sure if that's possible or how hard a transition is.
Till
On Fri, Dec 2, 2011 at 10:05 AM, Raoul Bhatia [IPAX] r.bhatia@ipax.atwrote:
hi!
i get a lot of "OperationalError: database is locked" errors lately. what is this error related to and can this error be addressed?
thanks, raoul -- ____________________________________________________________________ DI (FH) Raoul Bhatia M.Sc. email. r.bhatia@ipax.at Technischer Leiter
IPAX - Aloy Bhatia Hava OG web. http://www.ipax.at Barawitzkagasse 10/2/2/11 email. office@ipax.at 1190 Wien tel. +43 1 3670030 FN 277995t HG Wien fax. +43 1 3670030 15 ____________________________________________________________________ _______________________________________________ List info: http://lists.roundcube.net/dev/ BT/b33d0462
List info: http://lists.roundcube.net/dev/ BT/aba52c80
I haven't looked into moving to MySQL recently, but when I looked at it last, it wasn't very stable/mature. As Till said, the current errors seem to be unavoidable with the sqlite backend.
Adam
On Fri, Dec 2, 2011 at 11:00 AM, till till@php.net wrote:
I think this is the beauty of sqlite. And I think Adam would have to look into it.
Maybe we are better using MySQL or something, but I'm not sure if that's possible or how hard a transition is.
Till
On Fri, Dec 2, 2011 at 10:05 AM, Raoul Bhatia [IPAX] r.bhatia@ipax.at wrote:
hi!
i get a lot of "OperationalError: database is locked" errors lately. what is this error related to and can this error be addressed?
thanks, raoul -- ____________________________________________________________________ DI (FH) Raoul Bhatia M.Sc. email. r.bhatia@ipax.at Technischer Leiter
IPAX - Aloy Bhatia Hava OG web. http://www.ipax.at Barawitzkagasse 10/2/2/11 email. office@ipax.at 1190 Wien tel. +43 1 3670030 FN 277995t HG Wien fax. +43 1 3670030 15 ____________________________________________________________________ _______________________________________________ List info: http://lists.roundcube.net/dev/ BT/b33d0462
List info: http://lists.roundcube.net/dev/ BT/aba52c80
El vie, 02-12-2011 a las 11:05 -0600, Adam Grelck escribió:
I haven't looked into moving to MySQL recently, but when I looked at it last, it wasn't very stable/mature. As Till said, the current errors seem to be unavoidable with the sqlite backend.
Adam
It's not as hard as you'd think
Please see: http://trac.edgewall.org/wiki/SqLiteToMySql
And: http://trac.edgewall.org/wiki/MySqlDb
Some users reported sucessfull Trac instalations using MariaDB too, indeed Monty claims that MariaDB is faster than MySQL http://kb.askmonty.org/en/mariadb-versus-mysql-features
the key part is to use utf8 and InnoDB in a recent MySQL, if you don't do this, strange things could happen!
Have fun
Charly
On Fri, Dec 2, 2011 at 11:00 AM, till till@php.net wrote:
I think this is the beauty of sqlite. And I think Adam would have to look into it.
Maybe we are better using MySQL or something, but I'm not sure if that's possible or how hard a transition is.
Till
On Fri, Dec 2, 2011 at 10:05 AM, Raoul Bhatia [IPAX] r.bhatia@ipax.at wrote:
hi!
i get a lot of "OperationalError: database is locked" errors lately. what is this error related to and can this error be addressed?
thanks, raoul -- ____________________________________________________________________ DI (FH) Raoul Bhatia M.Sc. email. r.bhatia@ipax.at Technischer Leiter
IPAX - Aloy Bhatia Hava OG web. http://www.ipax.at Barawitzkagasse 10/2/2/11 email. office@ipax.at 1190 Wien tel. +43 1 3670030 FN 277995t HG Wien fax. +43 1 3670030 15 ____________________________________________________________________ _______________________________________________ List info: http://lists.roundcube.net/dev/ BT/b33d0462
List info: http://lists.roundcube.net/dev/ BT/5456fcb4
List info: http://lists.roundcube.net/dev/ BT/aba52c80