Error on index creation - MySQL + PAMP

[ruk]

I'm running the latest PAMP on my N95-4 8GB, and everything seems to be running just fine. Except:

First I create a table:

CREATE table `civicaddress` (
`street_no` int(11) NULL,
`street_nm` char(50) NULL,
`comm_nm` char(30) NULL,
`apt_no` char(10) NULL,
`county` char(3) NULL,
`latitude` real(11,5) NULL,
`longitude` real(11,5) NULL);

This works without any problems.

Next, I attempt to create an index, and get the following error:

mysql> CREATE index `StreetNumberDex` on civicaddress  (street_no);
ERROR 7 (HY000): Error on rename of \
'.\civicaddress\civicaddress.MYI' to \
'.\civicaddress\#sql2-198-1.MYI' (Errcode: 2)

I can successfully create the index by dropping the table and creating the index at table creation time, but I don't seem to be able to create any indices after the fact.

[jhnwkmn]

Hi,

I can successfully create the index by dropping the table and creating the index at table creation time, but I don't seem to be able to create any indices after the fact.

I could repeat the problem and will look into it.

Johan

[jhnwkmn]

I can successfully create the index by dropping the table and creating the index at table creation time, but I don't seem to be able to create any indices after the fact.

I could repeat the problem and will look into it.

It seems to be so that at the index creation when MySQL renames the file civicaddress.MYI, MySQL has that file opened as well. On Unix it is fine to rename a file that is also opened, but on Symbian you cannot do that. Thus the renaming fails and therefore also the index creation. For the time being, you just have to create the index at table creation time.

Johan

[jhnwkmn]

I can successfully create the index by dropping the table and creating the index at table creation time, but I don't seem to be able to create any indices after the fact.

I've now uploaded to SourceForge a version that allows you to create indexes after the fact. You need to first install the full 1.0.2 Pamp MySQL package, then uninstall the MySQL-5_0_67 Binaries package on the phone, and finally install the sis-file in the 1.0.2b zip.

Johan