xtdb icon indicating copy to clipboard operation
xtdb copied to clipboard

RuntimeExecption: Invalid ID type: java.lang.Double

Open refset opened this issue 1 year ago • 0 comments

Note that once the double gets into the log it breaks the ability to print _txs (possibly worth a separate issue?)

psql:

jdt=> INSERT into foo (_id, val) VALUES (1.00000000000000000000000000000000000000000000000000000000000, 1);
INSERT 0 0
jdt=> select * from foo;
--
(0 rows)

jdt=> select * from _txs;
ERROR:  unexpected server error during query execution
SELECT 0
jdt=> 

Docker:

xtdb.RuntimeException: Invalid ID type: java.lang.Double
        at xtdb.error$runtime_err.invokeStatic(error.clj:21)
        at xtdb.error$runtime_err.invoke(error.clj:13)
        at xtdb.error$runtime_err.invokeStatic(error.clj:17)
        at xtdb.error$runtime_err.invoke(error.clj:13)
        at xtdb.trie$__GT_iid.invokeStatic(trie.clj:42)
        at xtdb.trie$__GT_iid.invoke(trie.clj:33)
        at xtdb.indexer$$reify__25900.indexOp(indexer.clj:327)
        at xtdb.indexer$query_indexer$eval_query$reify__25955.accept(indexer.clj:399)
        at xtdb.operator.project.ProjectCursor$reify__20819.accept(project.clj:130)
        at xtdb.operator.rename.RenameCursor$reify__21628.accept(rename.clj:39)
        at xtdb.operator.table.TableCursor$fn__21969.invoke(table.clj:37)
        at xtdb.operator.table.TableCursor.tryAdvance(table.clj:35)
        at xtdb.operator.rename.RenameCursor.tryAdvance(rename.clj:29)
        at xtdb.operator.project.ProjectCursor.tryAdvance(project.clj:116)
        at xtdb.query$wrap_cursor$reify__25716.tryAdvance(query.clj:78)
        at java.base/java.util.Spliterator.forEachRemaining(Spliterator.java:332)
        at xtdb.indexer$query_indexer$eval_query__25954.invoke(indexer.clj:396)
        at xtdb.indexer$wrap_sql_args$fn__25961.invoke(indexer.clj:430)
        at xtdb.indexer$foreach_arg_row.invokeStatic(indexer.clj:413)
        at xtdb.indexer$foreach_arg_row.invokePrim(indexer.clj)
        at xtdb.indexer$$reify__25966.indexOp(indexer.clj:401)
        at xtdb.indexer.Indexer$fn__26016$index_tx_ops__26019$fn__26032.invoke(indexer.clj:623)
        at clojure.lang.AFn.call(AFn.java:18)
        at io.micrometer.core.instrument.AbstractTimer.recordCallable(AbstractTimer.java:175)
        at xtdb.indexer.Indexer$fn__26016$index_tx_ops__26019.invoke(indexer.clj:620)
        at xtdb.indexer.Indexer$fn__26016$fn__26040.invoke(indexer.clj:634)
        at xtdb.indexer.Indexer$fn__26016.invoke(indexer.clj:633)
        at xtdb.indexer.Indexer.indexTx(indexer.clj:597)
        at xtdb.log.watcher$watch_log_BANG_$reify__26256.acceptRecord(watcher.clj:53)
        at xtdb.log$tx_handler$fn__17626.invoke(log.clj:37)
        at clojure.lang.PersistentVector.reduce(PersistentVector.java:343)
        at clojure.core$reduce.invokeStatic(core.clj:6885)
        at clojure.core$reduce.invoke(core.clj:6868)
        at xtdb.log.NotifyingSubscriberHandler$fn__17659.invoke(log.clj:96)
        at clojure.lang.AFn.run(AFn.java:22)
        at java.base/java.lang.Thread.run(Thread.java:1583)
10:10:51 | WARN  xtdb.sql.plan | Table not found: foo
10:10:59 | ERROR xtdb.pgwire | An exception was caught during query result set iteration
java.lang.Exception: Unexpected type encountered by pgwire (class clojure.lang.Symbol)
        at xtdb.pgwire$json_clj.invokeStatic(pgwire.clj:451)
        at xtdb.pgwire$json_clj.invoke(pgwire.clj:372)
        at clojure.core$update_vals$fn__8943.invoke(core.clj:8017)
        at clojure.lang.PersistentArrayMap.kvreduce(PersistentArrayMap.java:429)
        at clojure.core$fn__8525.invokeStatic(core.clj:6908)
        at clojure.core$fn__8525.invoke(core.clj:6888)
        at clojure.core.protocols$fn__8257$G__8252__8266.invoke(protocols.clj:175)
        at clojure.core$reduce_kv.invokeStatic(core.clj:6919)
        at clojure.core$update_vals.invokeStatic(core.clj:8018)
        at clojure.core$update_vals.invoke(core.clj:8008)
        at xtdb.pgwire$json_clj.invokeStatic(pgwire.clj:441)
        at xtdb.pgwire$json_clj.invoke(pgwire.clj:372)
        at xtdb.pgwire$json_clj.invokeStatic(pgwire.clj:445)
        at xtdb.pgwire$json_clj.invoke(pgwire.clj:372)
        at clojure.core$comp$fn__5876.invoke(core.clj:2586)
        at xtdb.pgwire$write_json.invokeStatic(pgwire.clj:998)
        at xtdb.pgwire$write_json.invoke(pgwire.clj:997)
        at xtdb.pgwire$cmd_send_query_result$reify__33897$fn__33899.invoke(pgwire.clj:1037)
        at clojure.core$map_indexed$mapi__8638$fn__8639.invoke(core.clj:7376)
        at clojure.lang.LazySeq.sval(LazySeq.java:42)
        at clojure.lang.LazySeq.seq(LazySeq.java:51)
        at clojure.lang.RT.seq(RT.java:535)
        at clojure.lang.RT.countFrom(RT.java:650)
        at clojure.lang.RT.count(RT.java:643)
        at xtdb.pgwire$io_list$fn__33520.invoke(pgwire.clj:563)
        at xtdb.pgwire$io_record$write_record__33531.invoke(pgwire.clj:608)
        at xtdb.pgwire$cmd_write_msg.invokeStatic(pgwire.clj:815)
        at xtdb.pgwire$cmd_write_msg.invoke(pgwire.clj:803)
        at xtdb.pgwire$cmd_send_query_result$reify__33897.accept(pgwire.clj:1039)
        at xtdb.operator.project.ProjectCursor$reify__20819.accept(project.clj:130)
        at xtdb.operator.rename.RenameCursor$reify__21628.accept(rename.clj:39)
        at xtdb.operator.scan.TrieCursor$fn__19489.invoke(scan.clj:309)
        at xtdb.operator.scan.TrieCursor.tryAdvance(scan.clj:260)
        at xtdb.operator.rename.RenameCursor.tryAdvance(rename.clj:29)
        at xtdb.operator.project.ProjectCursor.tryAdvance(project.clj:116)
        at xtdb.query$wrap_cursor$reify__25716.tryAdvance(query.clj:78)
        at java.base/java.util.Spliterator.forEachRemaining(Spliterator.java:332)
        at xtdb.pgwire$cmd_send_query_result.invokeStatic(pgwire.clj:1008)
        at xtdb.pgwire$cmd_send_query_result.invoke(pgwire.clj:1000)
        at xtdb.pgwire$cmd_exec_query.invokeStatic(pgwire.clj:1141)
        at xtdb.pgwire$cmd_exec_query.invoke(pgwire.clj:1123)
        at xtdb.pgwire$cmd_execute.invokeStatic(pgwire.clj:1436)
        at xtdb.pgwire$cmd_execute.invoke(pgwire.clj:1418)
        at xtdb.pgwire$cmd_simple_query.invokeStatic(pgwire.clj:1467)
        at xtdb.pgwire$cmd_simple_query.invoke(pgwire.clj:1442)
        at xtdb.pgwire$handle_msg.invokeStatic(pgwire.clj:1494)
        at xtdb.pgwire$handle_msg.invoke(pgwire.clj:1475)
        at xtdb.pgwire$conn_loop.invokeStatic(pgwire.clj:1561)
        at xtdb.pgwire$conn_loop.invoke(pgwire.clj:1514)
        at xtdb.pgwire$connect.invokeStatic(pgwire.clj:1597)
        at xtdb.pgwire$connect.invoke(pgwire.clj:1564)
        at xtdb.pgwire$accept_loop$fn__34137$fn__34138$fn__34139.invoke(pgwire.clj:1652)
        at clojure.lang.AFn.run(AFn.java:22)
        at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572)
        at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
        at java.base/java.lang.Thread.run(Thread.java:1583)

refset avatar Aug 06 '24 10:08 refset