cassandra err="line 1:13 no viable alternative at input '(' (INSERT INTO [(]...)"

[ninjaslothx]

Hey,
I've used the helm loki-stack chart to deploy loki over kubernetes.
I'm using cassandra for both chunk and index storage.
My config in the values.yaml is as follows:

    auth_enabled: false
    ingester:
      chunk_idle_period: 3m
      chunk_block_size: 262144
      chunk_retain_period: 1m
      max_transfer_retries: 0
      lifecycler:
        ring:
          kvstore:
            store: inmemory
          replication_factor: 1
    limits_config:
      enforce_metric_name: false
      reject_old_samples: true
      reject_old_samples_max_age: 168h
    schema_config:
      configs:
      - from: 2018-04-15
        store: cassandra
        object_store: cassandra
        schema: v11
        index:
          prefix: cassandra_table
          period: 168h
    server:
      http_listen_port: 3100
    storage_config:
      cassandra:
        addresses: cassandra-loki
        keyspace: lokiindex
        replication_factor: 3
        consistency: QUORUM
        auth: true
        username: cassandra
        password: <password>
      boltdb:
        directory: /data/loki/index
      filesystem:
        directory: /data/loki/chunks
    chunk_store_config:
      max_look_back_period: 0
    table_manager:
      retention_deletes_enabled: false
      retention_period: 0

Everything is up and running and for all intensive purposes I can ingest and query logs.
However I am noticing the logs are spamming with these errors:

level=error ts=2020-04-12T20:39:55.256628888Z caller=flush.go:178 org_id=fake msg="failed to flush user" err="line 1:13 no viable alternative at input '(' (INSERT INTO  [(]...)"
level=error ts=2020-04-12T20:39:55.256821392Z caller=flush.go:178 org_id=fake msg="failed to flush user" err="line 1:13 no viable alternative at input '(' (INSERT INTO  [(]...)"
level=error ts=2020-04-12T20:39:55.257012937Z caller=flush.go:178 org_id=fake msg="failed to flush user" err="line 1:13 no viable alternative at input '(' (INSERT INTO  [(]...)"
level=error ts=2020-04-12T20:39:55.257157731Z caller=flush.go:178 org_id=fake msg="failed to flush user" err="line 1:13 no viable alternative at input '(' (INSERT INTO  [(]...)"

I am using the default user cassandra, so I wouldn't think this should be any form of permission issue?
They look related to cassandra but I am at a loss for what the issue is.

[cyriltovena]

We might need to run a custom image with more debug log? Have you tried adding debug level already? Could a bad character.

[ninjaslothx]

Yea interestingly when I run at a debug level these logs do not show up at all. Then resetting the log level to default and they show up again.

[stale]

This issue has been automatically marked as stale because it has not had any activity in the past 30 days. It will be closed in 7 days if no further activity occurs. Thank you for your contributions.

[yacut]

I have the same issue with 1.4.1.

[kipsnak]

I had the same issue, until I found this issue 1769 and 1503.

I set chunks prefix and period, then restarted loki. the error gone and the problem is fixed. Everything works perfectly now.

something like below should fix yours

    schema_config:
      configs:
      - from: 2018-04-15
        store: cassandra
        object_store: cassandra
        schema: v11
        index:
          prefix: cassandra_index_
          period: 168h
        chunks:
          prefix: cassandra_chunk_
          period: 168h

[stale]

This issue has been automatically marked as stale because it has not had any activity in the past 30 days. It will be closed in 7 days if no further activity occurs. Thank you for your contributions.