Displaying 20 results from an estimated 10000 matches similar to: "ActiveRecords question"
2017 Dec 01
1
Do we really need Solr commit as cronjob?
I am testing Solr FTS on dovecot. Read online that some suggested to run
cronjob commit every minute, and optimize once a day.
I am using Solr 7.1.0 and I see some configurations:
In /etc/default/solr.in.sh:
#SOLR_OPTS="$SOLR_OPTS -Dsolr.autoSoftCommit.maxTime=3000"
#SOLR_OPTS="$SOLR_OPTS -Dsolr.autoCommit.maxTime=60000"
Also in solrconfig.xml:
??? <autoCommit>
2018 Mar 05
1
Re: [enhancement] fts-solr low performance
>Hi,
>
>we have activated fts-solr about a week ago and immediately started to
>experience really *low* performance with MOVE and EXPUNGE commands.
>After several days of googling, tcpdumping and straceing i was able to
>find and resolve the problem.
>
>We are using Dovecot 2.2.27 from Debian Jessie (jessie-backports),
>which is doing a soft commit in solr after
2019 Apr 14
2
Solr connection timeout hardwired to 60s
sorry... I got distracted half way and forgot to put a meaningfull
subject so the archive could figure out the thread. - resending.
On 4/14/19 4:04 PM, dovecot-request at dovecot.org wrote:
>> Solr ships with autoCommit set to 15 seconds and openSearcher set to
>> false on the autoCommit.? The autoSoftCommit setting is not enabled by
>> default, but depending on how the index
2019 Apr 13
3
Solr connection timeout hardwired to 60s
On 4/13/2019 4:29 AM, John Fawcett via dovecot wrote:
> If this value was made configurable people could set it to what they
> want. However the underlying problem is likely on solr configuration.
The Jetty that is included in Solr has its idle timeout set to 50
seconds. But in practice, I have not seen this timeout trigger ... and
if the OP is seeing a 60 second timeout, then the 50
2006 Jun 15
4
testing with transactions
Hello!
I experienced problems with testing transactions which are supposed to be
rolled back, but are not, because of transactional fixtures eliminating the
inner transaction. Can this be worked around somehow without turning off
transactional fixtures? Maybe savepoints can help this?
Does anyone have any experience with savepoints to achieve nested transaction
functionality? Both Postgres
2019 Apr 14
1
[PATCH] Re: Solr connection timeout hardwired to 60s
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<div>
<br>
</div>
<blockquote type="cite">
<div>
On 14 April 2019 16:59 John Fawcett via dovecot <
<a href="mailto:dovecot@dovecot.org">dovecot@dovecot.org</a>> wrote:
</div>
2006 Apr 18
6
Postgresql and ActiveRecords problems
Hi all. I have a problem with postgresql PK columns and ActiveRecord.
The error is: PGError: ERROR: null value in column "item_id" violates
not-null.
Ok, it''s wrong to insert NULL into PK columns, but rails doing it. How
to fix? So sad..
2009 Jan 13
2
Connect multiple DB in rails project using AR
Dear all
I have a rails project which database connection is defined in
database.yml. There is a table call "servers" which have about 40
records, which is a collection of database setting (i.e. Server.name,
Server.port, Server.host)
I know the way to establish multiple connection as below...
class A < ActiveRecord::Base
end
A.establish_connection(a) # a is the database config
2007 Dec 20
3
ActiveRecords Eager Loading
Hi,
I am doing an eager loading in ruby on rails using below statement
------------------------
Article.find(:all, :include => [:asset, :vote],
:conditions=>"assets.parent_id is null",
:order=>"stat_final_ranking desc", :limit=>20)
---------------------------------------
the above statement resulted in this expensive query.
2006 Feb 28
5
Problem with paginate, include and foreign keys
Hi all,
Solaris 10
Ruby 1.8.4
Rails 1.0.0
Postgres 8.1
postgres driver 0.7.1
I''m having a problem with getting paginate() to properly pick up an FK
constraint properly.
I don''t seem to have this issue with ActiveRecord, however. Consider:
create table start_dates (
id bigserial,
start_date date unique,
max_slots int default 40,
primary key (id)
);
create
2006 Jan 10
2
Transactions with multiple databases
hi,
i have problem with transactions and multiple databases.
Object1 and Object2 are two different models/databases with different
connections, when i use only
one model:
Object1.transaction do
object1.value1 = "123456"
object1.save
do_some_error
end
it''s ok, error is produced, nothing is commited and database is unchanged.
when i use 2 models, described at
2015 Apr 14
1
Updating Solr - was Disk space usage with mdbox
So with "fts_autoindex=yes" enabled in plugins, is there anything I
should be running regularly, other than the expunge/purge, to ensure
Solr indexes are updated? I have a daily Solr optimize, and Solr
autocommit enabled.
I have an hourly "doveadm index -A *" command - is that unneeded?
--
Daniel
On 4/12/2015 6:53 AM, Timo Sirainen wrote:
> On 10 Apr 2015, at 21:55,
2013 May 09
4
recommended memory for zfs
Hello zfs question about memory.
I heard zfs is very ram hungry.
Service looking to run:
- nginx
- postgres
- php-fpm
- python
I have a machine with two quad core cpus but only 4 G Memory
I'm looking to buy more ram now.
What would be the recommend amount of memory for zfs across 6 drives on
this setup?
Also can 9.1 now boot to zfs from the installer?
(no tricks for post install)
Thanks
2019 Apr 23
3
SolrCore 'dovecot' is not available due to init failure: fieldType 'text_general' not found in the schema
https://wiki.dovecot.org/Plugins/FTS/Solr
Only offers a solr-7.7.0 solrconfig.xml, does it apply to solr-8.0.0?
On Tue, Apr 23, 2019 at 11:18 AM luckydog xf <luckydogxf at gmail.com> wrote:
> Here is solrconfig.xml, I removed comments.
> --------------------
>
> <?xml version="1.0" encoding="UTF-8"?>
> <config>
>
2019 Apr 12
2
Solr connection timeout hardwired to 60s
Looking further at tcpdumps of the Dovecot->Solr traffic and Solr
metrics it doesn't seem like there's anything suspicious apart from the
TCP windows running full and Dovecot backing of ... until it times out
and close the connection.
>From my understanding of how Dovecot operates towards Solr it will flush
~1000 documents towards Solr in /update request until it has traversed
the
2019 Apr 14
0
Solr connection timeout hardwired to 60s
On 14/04/2019 17:16, Peter Mogensen via dovecot wrote:
> sorry... I got distracted half way and forgot to put a meaningfull
> subject so the archive could figure out the thread. - resending.
>
> On 4/14/19 4:04 PM, dovecot-request at dovecot.org wrote:
>
>>> Solr ships with autoCommit set to 15 seconds and openSearcher set to
>>> false on the autoCommit.? The
2005 May 10
0
RODBC autocommit
How can I turn autocommit off using my RODBC connection to an Informix database?
I want to turn autocommit off, insert a thousand or so rows then commit.
I would appreciate any body's input on this.
2010 Feb 08
1
Acer Aspire 5739G - Wine doesn't work
Hi,
I've recently received said notebook as a gift. Currently it's running Kubuntu 9.10, however Wine just doesn't seem to work - any aplication I try to run on it gives an error message 'The program has encountered a serious problem and needs to close', whether it's a game, WinRar or an installer. In fact the only .exe files that work are the ones included in wine
2017 Mar 05
0
[enhancement] fts-solr low performance
Hi,
we have activated fts-solr about a week ago and immediately started to
experience really *low* performance with MOVE and EXPUNGE commands.
After several days of googling, tcpdumping and straceing i was able to
find and resolve the problem.
We are using Dovecot 2.2.27 from Debian Jessie (jessie-backports),
which is doing a soft commit in solr after every MOVE or EXPUNGE
command -
2006 Aug 10
6
save without commit ?
How do I get ''save'' to execute without commit?
I have tried:
ActiveRecord::Base.connection.begin_db_transaction
# do some stuff that doesn''t issue a database COMMIT statement
# then:
@myObject.save
# this issues a COMMIT but it shouldn''t! Shouldn''t it wait until I''ve
called:
ActiveRecord::Base.connection.commit_db_transaction
?
what am