Re: [General] 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 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, 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
[General] Indexing problem with sqlite3
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. Best regards, Teijo ___ General mailing list General@mnogosearch.org http://lists.mnogosearch.org/listinfo/general