Re: [General] Indexing problem with sqlite3
Hello,
On 03/22/2017 08:51 PM, Teijo wrote:
> Hello,
>
> Unfortunately patch did not solve the problem.
>
> As to SQLite3 versions, Ubuntu 16.04 it is
> SQLite version 3.11.0 2016-02-15 17:29:24
> and in Jessie
> SQLite version 3.8.7.1 2014-10-29 13:59:56
There are two similar places in sql-sqlite.c
Please make sure to fix the SQLite3 (rather than SQLite2) code branch:
case SQLITE_ERROR:
sqlite3_finalize(pStmt);
udm_snprintf(db->errstr, sizeof(db->errstr),
"sqlite3 driver: (%d) %s",
sqlite3_errcode(UdmSQLite3Conn(db)),
sqlite3_errmsg(UdmSQLite3Conn(db)));
if (!strstr(db->errstr,"unique") && !strstr(db->errstr,"UNIQUE"))
{
UdmSetErrorCode(db, 1);
return UDM_ERROR;
}
return UDM_OK;
break;
>
> Best regards,
>
> Teijo
>
> 22.3.2017, 16:52, Alexander Barkov kirjoitti:
>
>> Hello Teijo,
>>
>>
>> SQLite changed the error message in one of the recent releases,
>> from "unique" in lower case to "UNIQUE" in upper case.
>>
>>
>> Please apply this patch to src/sql-sqlite.c:
>>
>>
>>
>> -if (!strstr(db->errstr,"unique"))
>> +if (!strstr(db->errstr,"unique") &&
>> !strstr(db->errstr,"UNIQUE"))
>>
>>
>>
>>
>>
>>
>> On 03/22/2017 06:39 PM, Alexander Barkov wrote:
>>> Hello Teijo,
>>>
>>>
>>> On 03/22/2017 03:44 PM, Teijo wrote:
Hello,
I have installed Mnogosearch 3.4.1 from source both to Ubuntu 16.04 and
Debian Jessie.
In Ubuntu I cannot use Mysql as database because there seem to be some
compatibility issues with Mysql 5.7. In Jessie where Mysql version is
5.5x there are no such problems.
I thought to use Sqlite3 in Ubuntu. Database setup goes without errors
with indexer --create. But when I try to make index with simply typing
indexer, I get similar to the following:
[33572]{--} indexer from mnogosearch-3.4.1-sqlite3 started with
'/usr/local/mnogosearch/etc/indexer.conf'
[33572]{01} Error: 'DB: sqlite3 driver: (19) UNIQUE constraint failed:
url.url'
There seem to be similar problems with Sqlite3 in Jessie as well.
I am not familiar with Mnogosearch and Sqlite3 so is there something I
have missed when setting up the environment? Only changes I have
made in
indexer.conf are Dbaddress and server definitions. Dbaddress is just
that it's in the example of Sqlite3 definition in indexer.conf-dist.
>>>
>>> Which exact version of SQLite are you using?
>>>
>>>
>>> Can you please send your indexer.conf and the output for:
>>>
>>> ./indexer --sqlmon --exec="SELECT rec_id, url FROM url"
>>>
>>> to b...@mnogosearch.org
>>>
>>> Thanks.
>>>
>>>
>>>
Best regards,
Teijo
___
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general
>>> ___
>>> General mailing list
>>> General@mnogosearch.org
>>> http://lists.mnogosearch.org/listinfo/general
>>>
> ___
> General mailing list
> General@mnogosearch.org
> http://lists.mnogosearch.org/listinfo/general
___
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general
Re: [General] Indexing problem with sqlite3
Hello,
Unfortunately patch did not solve the problem.
As to SQLite3 versions, Ubuntu 16.04 it is
SQLite version 3.11.0 2016-02-15 17:29:24
and in Jessie
SQLite version 3.8.7.1 2014-10-29 13:59:56
Best regards,
Teijo
22.3.2017, 16:52, Alexander Barkov kirjoitti:
Hello Teijo,
SQLite changed the error message in one of the recent releases,
from "unique" in lower case to "UNIQUE" in upper case.
Please apply this patch to src/sql-sqlite.c:
-if (!strstr(db->errstr,"unique"))
+if (!strstr(db->errstr,"unique") && !strstr(db->errstr,"UNIQUE"))
On 03/22/2017 06:39 PM, Alexander Barkov wrote:
Hello Teijo,
On 03/22/2017 03:44 PM, Teijo wrote:
Hello,
I have installed Mnogosearch 3.4.1 from source both to Ubuntu 16.04 and
Debian Jessie.
In Ubuntu I cannot use Mysql as database because there seem to be some
compatibility issues with Mysql 5.7. In Jessie where Mysql version is
5.5x there are no such problems.
I thought to use Sqlite3 in Ubuntu. Database setup goes without errors
with indexer --create. But when I try to make index with simply typing
indexer, I get similar to the following:
[33572]{--} indexer from mnogosearch-3.4.1-sqlite3 started with
'/usr/local/mnogosearch/etc/indexer.conf'
[33572]{01} Error: 'DB: sqlite3 driver: (19) UNIQUE constraint failed:
url.url'
There seem to be similar problems with Sqlite3 in Jessie as well.
I am not familiar with Mnogosearch and Sqlite3 so is there something I
have missed when setting up the environment? Only changes I have made in
indexer.conf are Dbaddress and server definitions. Dbaddress is just
that it's in the example of Sqlite3 definition in indexer.conf-dist.
Which exact version of SQLite are you using?
Can you please send your indexer.conf and the output for:
./indexer --sqlmon --exec="SELECT rec_id, url FROM url"
to b...@mnogosearch.org
Thanks.
Best regards,
Teijo
___
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general
___
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general
___
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general
Re: [General] Indexing problem with sqlite3
Hello Teijo,
SQLite changed the error message in one of the recent releases,
from "unique" in lower case to "UNIQUE" in upper case.
Please apply this patch to src/sql-sqlite.c:
-if (!strstr(db->errstr,"unique"))
+if (!strstr(db->errstr,"unique") && !strstr(db->errstr,"UNIQUE"))
On 03/22/2017 06:39 PM, Alexander Barkov wrote:
> Hello Teijo,
>
>
> On 03/22/2017 03:44 PM, Teijo wrote:
>> Hello,
>>
>> I have installed Mnogosearch 3.4.1 from source both to Ubuntu 16.04 and
>> Debian Jessie.
>>
>> In Ubuntu I cannot use Mysql as database because there seem to be some
>> compatibility issues with Mysql 5.7. In Jessie where Mysql version is
>> 5.5x there are no such problems.
>>
>> I thought to use Sqlite3 in Ubuntu. Database setup goes without errors
>> with indexer --create. But when I try to make index with simply typing
>> indexer, I get similar to the following:
>>
>> [33572]{--} indexer from mnogosearch-3.4.1-sqlite3 started with
>> '/usr/local/mnogosearch/etc/indexer.conf'
>> [33572]{01} Error: 'DB: sqlite3 driver: (19) UNIQUE constraint failed:
>> url.url'
>>
>> There seem to be similar problems with Sqlite3 in Jessie as well.
>>
>> I am not familiar with Mnogosearch and Sqlite3 so is there something I
>> have missed when setting up the environment? Only changes I have made in
>> indexer.conf are Dbaddress and server definitions. Dbaddress is just
>> that it's in the example of Sqlite3 definition in indexer.conf-dist.
>
> Which exact version of SQLite are you using?
>
>
> Can you please send your indexer.conf and the output for:
>
> ./indexer --sqlmon --exec="SELECT rec_id, url FROM url"
>
> to b...@mnogosearch.org
>
> Thanks.
>
>
>
>>
>> Best regards,
>>
>> Teijo
>> ___
>> General mailing list
>> General@mnogosearch.org
>> http://lists.mnogosearch.org/listinfo/general
> ___
> General mailing list
> General@mnogosearch.org
> http://lists.mnogosearch.org/listinfo/general
>
___
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general
Re: [General] Indexing problem with sqlite3
Hello Teijo,
On 03/22/2017 03:44 PM, Teijo wrote:
> Hello,
>
> I have installed Mnogosearch 3.4.1 from source both to Ubuntu 16.04 and
> Debian Jessie.
>
> In Ubuntu I cannot use Mysql as database because there seem to be some
> compatibility issues with Mysql 5.7. In Jessie where Mysql version is
> 5.5x there are no such problems.
>
> I thought to use Sqlite3 in Ubuntu. Database setup goes without errors
> with indexer --create. But when I try to make index with simply typing
> indexer, I get similar to the following:
>
> [33572]{--} indexer from mnogosearch-3.4.1-sqlite3 started with
> '/usr/local/mnogosearch/etc/indexer.conf'
> [33572]{01} Error: 'DB: sqlite3 driver: (19) UNIQUE constraint failed:
> url.url'
>
> There seem to be similar problems with Sqlite3 in Jessie as well.
>
> I am not familiar with Mnogosearch and Sqlite3 so is there something I
> have missed when setting up the environment? Only changes I have made in
> indexer.conf are Dbaddress and server definitions. Dbaddress is just
> that it's in the example of Sqlite3 definition in indexer.conf-dist.
Which exact version of SQLite are you using?
Can you please send your indexer.conf and the output for:
./indexer --sqlmon --exec="SELECT rec_id, url FROM url"
to b...@mnogosearch.org
Thanks.
>
> Best regards,
>
> Teijo
> ___
> General mailing list
> General@mnogosearch.org
> http://lists.mnogosearch.org/listinfo/general
___
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general
