Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: neutral (nike.apache.org: local policy)
From: Brett Tinling <btinling@lacunasystems.com>
Mime-Version: 1.0 (Apple Message framework v1283)
Content-Type: multipart/signed;
 boundary="Apple-Mail=_88B42F59-8B9D-4FC2-96BA-3886163A2A42";
 protocol="application/pkcs7-signature"; micalg=sha1
Subject: Re: secondary index problem
Date: Mon, 18 Mar 2013 15:02:49 -0700
In-Reply-To: <21F63D46-175E-4378-A230-B1672C320B6D@thelastpickle.com>
To: user@cassandra.apache.org
References: <D39B0F2A-201E-4ADB-ABE4-B011173339D5@lacunasystems.com>
 <1413F397-F190-4F84-B445-824654B28E90@ecyrd.com>
 <21F63D46-175E-4378-A230-B1672C320B6D@thelastpickle.com>
Message-Id: <D65D5B52-65A3-451B-8A12-FB0FF4F64E5C@lacunasystems.com>


--Apple-Mail=_88B42F59-8B9D-4FC2-96BA-3886163A2A42
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=us-ascii

Aaron,

No recipe yet.  It pops up randomly and, i think due to the nature of =
our app, goes away.

Seems like when we have updates that are large (10k rows in one mutate) =
the problem is more likely to occur.

I'll try to workout a repro...

-Brett

On Mar 18, 2013, at 10:18 AM, aaron morton wrote:

> Brett,=20
> 	Do you have some steps to reproduce the problem ? If so please =
create a ticket on jira.=20
>=20
> Cheers
>=20
> -----------------
> Aaron Morton
> Freelance Cassandra Consultant
> New Zealand
>=20
> @aaronmorton
> http://www.thelastpickle.com
>=20
> On 16/03/2013, at 11:40 AM, Janne Jalkanen <Janne.Jalkanen@ecyrd.com> =
wrote:
>=20
>>=20
>> This could be either of the following bugs (which might be the same =
thing).  I get it too every time I recycle a node on 1.1.10.
>>=20
>> https://issues.apache.org/jira/browse/CASSANDRA-4973
>> or
>> https://issues.apache.org/jira/browse/CASSANDRA-4785
>>=20
>> /Janne
>>=20
>> On Mar 15, 2013, at 23:24 , Brett Tinling =
<btinling@lacunasystems.com> wrote:
>>=20
>>> We have a CF with an indexed column 'type', but we get incomplete =
results when we query that CF for all rows matching 'type'.  We can find =
the missing rows if we query by key.
>>>=20
>>> * we are seeing this on a small, single node, 1.2.2 instance with =
few rows.
>>> * we use thrift execute_cql_query, no CL is specified
>>> * none of repair, restart, compact, scrub helped
>>>=20
>>> Finally, nodetool rebuild_index fixed it. =20
>>>=20
>>> Is index rebuild something we need to do periodically?  How often?  =
Is there a way to know when it needs to be done?  Do we have to run =
rebuild on all nodes?
>>>=20
>>> We have not noticed this until 1.2
>>>=20
>>> Regards,
>>>  - Brett
>>>=20
>>>=20
>>>=20
>>>=20
>>>=20
>>>=20
>>=20
>=20


--Apple-Mail=_88B42F59-8B9D-4FC2-96BA-3886163A2A42
Content-Disposition: attachment;
	filename=smime.p7s
Content-Type: application/pkcs7-signature;
	name=smime.p7s
Content-Transfer-Encoding: base64

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIDyzCCA8cw
ggKvoAMCAQICAQEwCwYJKoZIhvcNAQELMHsxFjAUBgNVBAMMDUJyZXR0IFRpbmxpbmcxHDAaBgNV
BAoME0xhY3VuYSBTeXN0ZW1zIEluYy4xCzAJBgNVBAgMAldBMQswCQYDVQQGEwJVUzEpMCcGCSqG
SIb3DQEJARYaYnRpbmxpbmdAbGFjdW5hc3lzdGVtcy5jb20wHhcNMTIwNDE4MDA0NzM4WhcNMjIw
NDE2MDA0NzM4WjB7MRYwFAYDVQQDDA1CcmV0dCBUaW5saW5nMRwwGgYDVQQKDBNMYWN1bmEgU3lz
dGVtcyBJbmMuMQswCQYDVQQIDAJXQTELMAkGA1UEBhMCVVMxKTAnBgkqhkiG9w0BCQEWGmJ0aW5s
aW5nQGxhY3VuYXN5c3RlbXMuY29tMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAzGmK
Zb2mneqHxPGmT21mrYRItMtFCPavjlQABrSJnlPr9s7vJODGLk5+ajblRMinjnWDlrme+4IQFP4c
lsXw7W4NuJEdVpeomwjIgn2NjriA/2pD4YUP2mY9GmVTuFBj9OK+oMuzT07JIpoEg0Lv0L3M7e5X
yIKQ79zLRM6QJxNYuTkixa8Evc+Rb3vpE8zJgElQ7SFGhTT5CALVRhOvsBBr9ocW4Mt5z/R+y56a
yicDm+mPZnVpkB0p1VXfJs2xUyiPdgPchntVS4c95AdO+BAvtrSd8jaXIjmlNgjvq4lz8rA/4MK+
+zy+CEY+D8EQ+Q52Eukx7/bJwqF4WadivwIDAQABo1gwVjAPBgNVHQ8BAf8EBQMDB/+AMBwGA1Ud
JQEB/wQSMBAGCCsGAQUFBwMEBgRVHSUAMCUGA1UdEQQeMByBGmJ0aW5saW5nQGxhY3VuYXN5c3Rl
bXMuY29tMA0GCSqGSIb3DQEBCwUAA4IBAQAL9KAB7TJz3dN8UN251BoPpWUkmCaFY7H2y+X6xTWt
ORIIUtIpyubotOukoOeysxKcPBP8PUHFPmehQkI6tvxFLiDEOhq+xw4fF0s/9KqMkMTN2g4EQCCf
66QkAALJ7aiz2sKRbwkgJ6pm3I1xH3BHGVCQfUyQ9zThsEZ49AFZ8OwUe/+fxkkiUqNhAqgS9iKI
NNb5h2OXOwbqf2KyOIexuh+3TxlZcghpFBSw/ofY7qWI7buHNbFJCstnll94FWkE9lehQMLzDjAD
+BcB+SZyI6hjd5Qz+T/XNiP7RLFZpsvfrv2cBIAJm7A2SX1UM4njK+n/FFoUs0ddGQAPYT6NMYID
MzCCAy8CAQEwgYAwezEWMBQGA1UEAwwNQnJldHQgVGlubGluZzEcMBoGA1UECgwTTGFjdW5hIFN5
c3RlbXMgSW5jLjELMAkGA1UECAwCV0ExCzAJBgNVBAYTAlVTMSkwJwYJKoZIhvcNAQkBFhpidGlu
bGluZ0BsYWN1bmFzeXN0ZW1zLmNvbQIBATAJBgUrDgMCGgUAoIIBhzAYBgkqhkiG9w0BCQMxCwYJ
KoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0xMzAzMTgyMjAyNTBaMCMGCSqGSIb3DQEJBDEWBBTY
1w7prAO1f6yy7lGxQt1amG038DCBkQYJKwYBBAGCNxAEMYGDMIGAMHsxFjAUBgNVBAMMDUJyZXR0
IFRpbmxpbmcxHDAaBgNVBAoME0xhY3VuYSBTeXN0ZW1zIEluYy4xCzAJBgNVBAgMAldBMQswCQYD
VQQGEwJVUzEpMCcGCSqGSIb3DQEJARYaYnRpbmxpbmdAbGFjdW5hc3lzdGVtcy5jb20CAQEwgZMG
CyqGSIb3DQEJEAILMYGDoIGAMHsxFjAUBgNVBAMMDUJyZXR0IFRpbmxpbmcxHDAaBgNVBAoME0xh
Y3VuYSBTeXN0ZW1zIEluYy4xCzAJBgNVBAgMAldBMQswCQYDVQQGEwJVUzEpMCcGCSqGSIb3DQEJ
ARYaYnRpbmxpbmdAbGFjdW5hc3lzdGVtcy5jb20CAQEwDQYJKoZIhvcNAQEBBQAEggEAruAxgc4D
ChJ/bD7wrXiowF0vXMvQkwWAji5yt1HZCea7ZyltxoagQJGSPvWOrnMZ2Jxget3Aev0u5F20P6/R
/ahYuX4v2F6JZZ3sQ3z+siWmPpHrYn/r//U3/b5SeAxX4Avd+hDKzMWYCmoNsYhTLSgq3S5ykzvr
eP6GIG9HzQS3HJKK2PxSQFrTn8vmooiDNmwVsUzjw/E5wvJMBspb1m9hCQzWvgBCO1I2y0rxAkPa
89s7PMTQI4WmzbOdBugPX0zBkFbGtRivc3oxsUVgbfe8xzDr4/E4QtfQ2AMzzIFGWacSBrAifErm
0IrAFx+KTFZnZPkkK+RCaPKMayhEZgAAAAAAAA==

--Apple-Mail=_88B42F59-8B9D-4FC2-96BA-3886163A2A42--