Re: Indexing problem with sqlite3

Hello,

You are correct. I made the change to the wrong branch. The patch fixed 
the problem at least in Jessie, and I suppose that is the case with 
Ubuntu as well. Thank you very much!

Best regards,

Teijo

23.3.2017, 17:23, Alexander Barkov kirjoitti:

> 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 [email protected]
>>>>
>>>> Thanks.
>>>>
>>>>
>>>>
>>>>>
>>>>> Best regards,
>>>>>
>>>>> Teijo
>>>>> _______________________________________________
>>>>> General mailing list
>>>>> [email protected]
>>>>> http://lists.mnogosearch.org/listinfo/general
>>>> _______________________________________________
>>>> General mailing list
>>>> [email protected]
>>>> http://lists.mnogosearch.org/listinfo/general
>>>>
>> _______________________________________________
>> General mailing list
>> [email protected]
>> http://lists.mnogosearch.org/listinfo/general
_______________________________________________
General mailing list
[email protected]
http://lists.mnogosearch.org/listinfo/general