[ 
https://issues.apache.org/jira/browse/CASSANDRA-17454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Stefan Miklosovic updated CASSANDRA-17454:
------------------------------------------
    Description: 
{code:java}
Error Messagecassandra.WriteFailure: Error from server: code=1500 [Replica(s) 
failed to execute write] message="Operation failed - received 1 responses and 1 
failures: UNKNOWN from /127.0.0.1:7000" info={'consistency': 'ONE', 
'required_responses': 1, 'received_responses': 1, 'failures': 1, 
'error_code_map': {'127.0.0.1': '0x0000'}}Stacktraceself = 
<abc.TestCQLNodes2RF1_Upgrade_indev_4_0_x_To_indev_trunk object at 
0x7f36e8ae1a60>

    def test_static_cf(self):
        """ Test static CF syntax """
        cursor = self.prepare()
    
        # Create
        cursor.execute("""
                CREATE TABLE users (
                    userid uuid PRIMARY KEY,
                    firstname text,
                    lastname text,
                    age int
                );
            """)
    
        for is_upgraded, cursor in self.do_upgrade(cursor):
            logger.debug("Querying {} node".format("upgraded" if is_upgraded 
else "old"))
            cursor.execute("TRUNCATE users")
    
            # Inserts
            cursor.execute("INSERT INTO users (userid, firstname, lastname, 
age) VALUES (550e8400-e29b-41d4-a716-446655440000, 'Frodo', 'Baggins', 32)")
            cursor.execute("UPDATE users SET firstname = 'Samwise', lastname = 
'Gamgee', age = 33 WHERE userid = f47ac10b-58cc-4372-a567-0e02b2c3d479")
    
            # Queries
            assert_one(cursor, "SELECT firstname, lastname FROM users WHERE 
userid = 550e8400-e29b-41d4-a716-446655440000", ['Frodo', 'Baggins'])
    
            assert_one(cursor, "SELECT * FROM users WHERE userid = 
550e8400-e29b-41d4-a716-446655440000", 
[UUID('550e8400-e29b-41d4-a716-446655440000'), 32, 'Frodo', 'Baggins'])
    
            assert_all(cursor, "SELECT * FROM users", 
[[UUID('f47ac10b-58cc-4372-a567-0e02b2c3d479'), 33, 'Samwise', 'Gamgee'],
                                                       
[UUID('550e8400-e29b-41d4-a716-446655440000'), 32, 'Frodo', 'Baggins']])
    
            # Test batch inserts
>           cursor.execute("""
                    BEGIN BATCH
                        INSERT INTO users (userid, age) VALUES 
(550e8400-e29b-41d4-a716-446655440000, 36)
                        UPDATE users SET age = 37 WHERE userid = 
f47ac10b-58cc-4372-a567-0e02b2c3d479
                        DELETE firstname, lastname FROM users WHERE userid = 
550e8400-e29b-41d4-a716-446655440000
                        DELETE firstname, lastname FROM users WHERE userid = 
f47ac10b-58cc-4372-a567-0e02b2c3d479
                    APPLY BATCH
                """)

upgrade_tests/cql_tests.py:74: 
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
../venv/src/cassandra-driver/cassandra/cluster.py:2618: in execute
    return self.execute_async(query, parameters, trace, custom_payload, 
timeout, execution_profile, paging_state, host, execute_as).result() {code}

> flaky dtest-upgrade.upgrade_tests.cql_tests 
> TestCQLNodes2RF1_Upgrade_indev_4_0_x_To_indev_trunk test_static_cf
> --------------------------------------------------------------------------------------------------------------
>
>                 Key: CASSANDRA-17454
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-17454
>             Project: Cassandra
>          Issue Type: Bug
>          Components: CI
>            Reporter: Stefan Miklosovic
>            Priority: Normal
>
> {code:java}
> Error Messagecassandra.WriteFailure: Error from server: code=1500 [Replica(s) 
> failed to execute write] message="Operation failed - received 1 responses and 
> 1 failures: UNKNOWN from /127.0.0.1:7000" info={'consistency': 'ONE', 
> 'required_responses': 1, 'received_responses': 1, 'failures': 1, 
> 'error_code_map': {'127.0.0.1': '0x0000'}}Stacktraceself = 
> <abc.TestCQLNodes2RF1_Upgrade_indev_4_0_x_To_indev_trunk object at 
> 0x7f36e8ae1a60>
>     def test_static_cf(self):
>         """ Test static CF syntax """
>         cursor = self.prepare()
>     
>         # Create
>         cursor.execute("""
>                 CREATE TABLE users (
>                     userid uuid PRIMARY KEY,
>                     firstname text,
>                     lastname text,
>                     age int
>                 );
>             """)
>     
>         for is_upgraded, cursor in self.do_upgrade(cursor):
>             logger.debug("Querying {} node".format("upgraded" if is_upgraded 
> else "old"))
>             cursor.execute("TRUNCATE users")
>     
>             # Inserts
>             cursor.execute("INSERT INTO users (userid, firstname, lastname, 
> age) VALUES (550e8400-e29b-41d4-a716-446655440000, 'Frodo', 'Baggins', 32)")
>             cursor.execute("UPDATE users SET firstname = 'Samwise', lastname 
> = 'Gamgee', age = 33 WHERE userid = f47ac10b-58cc-4372-a567-0e02b2c3d479")
>     
>             # Queries
>             assert_one(cursor, "SELECT firstname, lastname FROM users WHERE 
> userid = 550e8400-e29b-41d4-a716-446655440000", ['Frodo', 'Baggins'])
>     
>             assert_one(cursor, "SELECT * FROM users WHERE userid = 
> 550e8400-e29b-41d4-a716-446655440000", 
> [UUID('550e8400-e29b-41d4-a716-446655440000'), 32, 'Frodo', 'Baggins'])
>     
>             assert_all(cursor, "SELECT * FROM users", 
> [[UUID('f47ac10b-58cc-4372-a567-0e02b2c3d479'), 33, 'Samwise', 'Gamgee'],
>                                                        
> [UUID('550e8400-e29b-41d4-a716-446655440000'), 32, 'Frodo', 'Baggins']])
>     
>             # Test batch inserts
> >           cursor.execute("""
>                     BEGIN BATCH
>                         INSERT INTO users (userid, age) VALUES 
> (550e8400-e29b-41d4-a716-446655440000, 36)
>                         UPDATE users SET age = 37 WHERE userid = 
> f47ac10b-58cc-4372-a567-0e02b2c3d479
>                         DELETE firstname, lastname FROM users WHERE userid = 
> 550e8400-e29b-41d4-a716-446655440000
>                         DELETE firstname, lastname FROM users WHERE userid = 
> f47ac10b-58cc-4372-a567-0e02b2c3d479
>                     APPLY BATCH
>                 """)
> upgrade_tests/cql_tests.py:74: 
> _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
> _ 
> ../venv/src/cassandra-driver/cassandra/cluster.py:2618: in execute
>     return self.execute_async(query, parameters, trace, custom_payload, 
> timeout, execution_profile, paging_state, host, execute_as).result() {code}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to