[mythtv-users] 0.22 database schema upgrade fails driver not loaded

[Chris Tepe]

Michael T. Dean wrote:
> On 11/05/2009 02:12 PM, Chris Tepe wrote:
>> I had myth 0.21 running on my CentOS 5.3 box.  Upgraded to 0.22.  
>> When I run mythtv-setup it attempts to update the schema but fails.
>> 2009-11-05 13:36:06.170 mythbackend version: 
> ...
>> 2009-11-05 13:36:06.955 New DB connection, total: 1
>> 2009-11-05 13:36:07.289 Connected to database 'mythconverg' at host: 
>> localhost
>> 2009-11-05 13:36:07.557 Closing DB connection named 'DBManager0'
>> 2009-11-05 13:36:07.930 Connected to database 'mythconverg' at host: 
>> localhost
>> 2009-11-05 13:36:08.501 Current MythTV Schema Version (DBSchemaVer): 
>> 1215
>
> Shows DB exists and connection works (as we retrieved data from it).
>
>> 2009-11-05 13:37:05.121 Newest MythTV Schema Version : 1244
>> QSqlQuery::exec: database not open
>> 2009-11-05 13:37:09.922 DB Error (Unable to perform test for database 
>> corruption before character set conversion.):
>> Query was:
>>
>> Driver error was [1/-1]:
>> Driver not loaded
>> Database error was:
>> Driver not loaded
>>
>> 2009-11-05 13:37:09.923 Database Schema upgrade FAILED, unlocking.
>> 2009-11-05 13:37:09.924 Couldn't upgrade database to new schema
>
> Now database is gone/we can't talk to it.
>
> Can you try: 
> http://www.gossamer-threads.com/lists/mythtv/users/405988#405988 and 
> report back, please?
>
> Though I can't see how any of our data could be sufficiently sized to 
> cause issues with the MySQL default of 1MiB, perhaps your distro 
> configured mysqld to use a much smaller size (to "save RAM" or 
> something).  If some distro is configuring a value on the order of 
> 1024bytes (the smallest allowed size), we could have issues after 
> 0.21-fixes (as our text is now potentially 3 times as large as it was 
> for 0.21-fixes and below).
>
> Thanks,
> Mike
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
No help.  Tried setting it to 16M and 32M.  I did have an issue with the 
qt libraries when I first upgraded.  Yum installed qt4 instead of qt44.  
I had to remove qt4 which unistalled myth then reinstalled with the qt44 
libraries.  This got me to this point.

2009-11-05 14:52:47.951 Upgrading.
2009-11-05 14:52:47.953 Newest MythTV Schema Version : 1244
QSqlQuery::exec: database not open
2009-11-05 14:52:52.604 DB Error (Unable to perform test for database 
corruption before character set conversion.):
Query was:

Driver error was [1/-1]:
Driver not loaded
Database error was:
Driver not loaded

2009-11-05 14:52:52.605 Database Schema upgrade FAILED, unlocking.
2009-11-05 14:52:52.618 Couldn't upgrade database to new schema

[root at mythcentos mythtv]# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
key_buffer = 16M
table_cache = 128
sort_buffer_size = 2M
myisam_sort_buffer_size = 8M
query_cache_size = 16M
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
max_allowed_packet = 32M

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[root at mythcentos mythtv]#