DB2 is VERY unsupported

I'm thinking support should be removed, little development, bar getting caught in other changes...

dnessett wrote:

(In reply to comment #2)

I'm thinking support should be removed, little development, bar getting caught
in other changes...

Works for me. The reason I am installing over multiple databases is I am trying to set up a testing environment against which functionality for the selenium framework is tested before submitting patches. If there is official withdrawal of support for DB2 or any other db software, that makes things simpler.

Stack trace indicates that you've been using the OLD updater, which makes sence since DB2 isn't currently supported by the new one.

(In reply to comment #3)

[...] If there is official withdrawal
of support for DB2 or any other db software, that makes things simpler.

It's not official, but since

Sorry, hit enter prematurely. Continuing my thought:

It's not official yet, but had been proposed before due to lack of active support. This may happen as soon as 1.17 simply because the new installer currently supports only three open-source databases.

For the reference:
http://www.mediawiki.org/w/index.php?title=New-installer_issues&diff=309243&oldid=309227

I've added the DB2 maintainer to this bug's CC.

dnessett wrote:

(In reply to comment #5)

Sorry, hit enter prematurely. Continuing my thought:

It's not official yet, but had been proposed before due to lack of active
support. This may happen as soon as 1.17 simply because the new installer
currently supports only three open-source databases.

For the reference:
http://www.mediawiki.org/w/index.php?title=New-installer_issues&diff=309243&oldid=309227

I've added the DB2 maintainer to this bug's CC.

Thanks for the info.

I had planned on installing the free Oracle db software and having a MW installation that runs over it, but if it is not supported, that would be unnecessary work. Is there somewhere that states the official dbs for each MW release? For example, while DB2 and Oracle may not be supported for 1.17, I would be interested if they are officially supported for 1.16.

[21:19:26] <^demon> See, I consider Oracle semi-functional.
[21:19:29] <^demon> It mostly works.

leons.petrazickis wrote:

@Max: Thanks for the CC.

I'm about to commit my outstanding changes. Looking over the diffs now. They add prepared statement support (to allow INSERT and UPDATE of more than 32k of text) and fix some issues with the schema.

I haven't looked at new installer yet unfortunately. I'm going to be advising a database class this fall that's going to be working with DB2 and PHP, and there may be some student volunteers working with me to improve DB2 support in MediaWiki.

@dan: There are issues with DB2 functionality in 1.16.

dnessett wrote:

(In reply to comment #7)

[21:19:26] <^demon> See, I consider Oracle semi-functional.
[21:19:29] <^demon> It mostly works.

My main interest is testing my code against those dbs that are considered officially supported. So, if there is a list of these (which, I suppose would depend on the release), then I will use it and stop testing against the others.

(In reply to comment #9)

(In reply to comment #7)

[21:19:26] <^demon> See, I consider Oracle semi-functional.
[21:19:29] <^demon> It mostly works.

My main interest is testing my code against those dbs that are considered
officially supported. So, if there is a list of these (which, I suppose would
depend on the release), then I will use it and stop testing against the others.

I answered this (and I think other) questions in http://article.gmane.org/gmane.science.linguistics.wikipedia.technical/49561 back in September. As far as I'm concerned, the ones worth testing and maintaining right now are:

mySQL, PostgreSQL, SQLite, Oracle.

Until DB2 and MSSQL finish their DatabaseBase subclasses and generally work (I'm aware that Postgres and Oracle still fail on some edge cases, but their completeness is far beyond the other two here), I don't see any need to test them and even less need to include them in the installer and advertise their use.

The one caveat is: while Oracle does have a working schema, DatabaseBase class and (almost complete) new installer code, the maintainer hasn't been writing patches to upgrade the database, so support is not complete and should NOT be recommended outside of development environments.

DB2 and MSSQL have code in the old installer, which may or may not work. In either case, it's not getting fixed at this point. The old installer is dead.

Marking INVALID. Reported bug was with old installer. New installer contains no DB2 support.