failed SQL queries in the dynamic branch

[Maximilian Kossick]

Hi
Yes, I fixed the problem with the index yesterday. The key is now shorter than 
the key of some other indexes, so it should be fine.

The other two failed SQL queries, the one about the missing devices table and 
the one about the existing admin table are normal.

Cheers, Max

> Ian,
>
> I believe that maxx_k has fixed the problem with creating the index.
>
> As for the playlists table not existing - that is not a problem with
> the branch. That table should exist in trunk as of Persistent Tables
> Version 12, which is from the end of May. (revision 546372) . I would
> guess that if you were still travelling, you might have got bitten by
> the bug I recently found where Persistent and Stats table upgrades
> would only do the upgrade from 10->11, even if you were starting from
> 10 and going to 12. This will probably also have affected anyone
> upgrading from 1.4.0 to 1.4.1 (inc beta1), if my guess is right. More
> amusing still is that an upgrade to Persistent Tables version 11 is in
> fact a NOOP - it does nothing.
>
> The upgrade code for Persistent tables is fixed only in the branch, as
> with all the talk of merging, I thought it not worth the effort to
> backport it to trunk. It would also be pointless, unless anyone is
> immediately going to add more tables in trunk, as it would only help
> for future updates; that you managed to notice a previous upgrade had
> failed is purely happy coincidence.
>
> I think, from what I can tell, this is the only failure that can
> happen with the 1.4.0->1.4.1 upgrade. So, when the branch is merged
> into trunk (or, the fix backported, I suppose), everything will be
> sorted. Until then, I wonder what the effect is of not having a
> playlists table.
>
> Andrew
>
> On 15/07/06, Ian Monroe <ian at monroe.nu> wrote:
> > I use mysql 4.0.25
> >
> > amarok:   BEGIN: CollectionDB::CollectionDB()
> > amarok:     BEGIN: void CollectionDB::initialize()
> > amarok:       [ThreadWeaver] Creating pthread key, exit value is 0
> > amarok:       BEGIN: MySqlConnection::MySqlConnection(const MySqlConfig*)
> > amarok:         [CollectionDB] [MySqlConnection::MySqlConnection(const
> > MySqlConfig*)]
> > amarok:       END__: MySqlConnection::MySqlConnection(const
> > MySqlConfig*) - Took 0.048s
> > amarok:       [CollectionDB] MYSQL QUERY FAILED: Table
> > 'amarok.devices' doesn't exist
> > amarok: FAILED QUERY: SELECT COUNT( id ) FROM devices LIMIT 1 OFFSET 0;
> > amarok:       [CollectionDB] Creating DEVICES table
> > amarok:       [CollectionDB] MYSQL QUERY FAILED: Specified key was too
> > long. Max key length is 500
> > amarok: FAILED QUERY: CREATE INDEX devices_remoteshare ON devices(
> > servername, sharename );
> > amarok:     END__: void CollectionDB::initialize() - Took 0.25s
> > amarok:     [CollectionDB] INotify not available, using QTimer!
> > amarok:   END__: CollectionDB::CollectionDB() - Took 0.33s
> > amarok:   [CollectionDB] Different database stats version detected!
> > Stats table will be updated or rebuilt.
> > amarok:   [CollectionDB] MYSQL QUERY FAILED: Table 'amarok.playlists'
> > doesn't exist
> > amarok: FAILED QUERY: INSERT INTO playlists_fix SELECT
> > playlist,url,tracknum FROM playlists;
> > amarok:   [CollectionDB] MYSQL QUERY FAILED: Unknown table 'playlists'
> > amarok: FAILED QUERY: DROP TABLE playlists;
> > amarok:   [CollectionDB] Rebuilding database!
> > amarok:   [CollectionDB] Dropping media table
> > amarok:   BEGIN: void CollectionDB::createTables(bool)
> > amarok:     [CollectionDB] MYSQL QUERY FAILED: Table 'admin' already
> > exists amarok: FAILED QUERY: CREATE TABLE admin (noption VARCHAR(255),
> > value VARCHAR(255));
> > amarok:   END__: void CollectionDB::createTables(bool) - Took 0.39s
> > amarok:   [CollectionDB] INotify not available, using QTimer!
> > _______________________________________________
> > Amarok mailing list
> > Amarok at kde.org
> > https://mail.kde.org/mailman/listinfo/amarok
>
> _______________________________________________
> Amarok mailing list
> Amarok at kde.org
> https://mail.kde.org/mailman/listinfo/amarok
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 191 bytes
Desc: not available
URL: <http://mail.kde.org/pipermail/amarok/attachments/20060716/d65d7706/attachment.sig>