{"action":"created","issue":{"url":"https://api.github.com/repos/crate/crate-pdo/issues/68","repository_url":"https://api.github.com/repos/crate/crate-pdo","labels_url":"https://api.github.com/repos/crate/crate-pdo/issues/68/labels{/name}","comments_url":"https://api.github.com/repos/crate/crate-pdo/issues/68/comments","events_url":"https://api.github.com/repos/crate/crate-pdo/issues/68/events","html_url":"https://github.com/crate/crate-pdo/issues/68","id":249574139,"number":68,"title":"Some INSERTs seem to fail randomly","user":{"login":"christophpe","id":30923792,"avatar_url":"https://avatars1.githubusercontent.com/u/30923792?v=4","gravatar_id":"","url":"https://api.github.com/users/christophpe","html_url":"https://github.com/christophpe","followers_url":"https://api.github.com/users/christophpe/followers","following_url":"https://api.github.com/users/christophpe/following{/other_user}","gists_url":"https://api.github.com/users/christophpe/gists{/gist_id}","starred_url":"https://api.github.com/users/christophpe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/christophpe/subscriptions","organizations_url":"https://api.github.com/users/christophpe/orgs","repos_url":"https://api.github.com/users/christophpe/repos","events_url":"https://api.github.com/users/christophpe/events{/privacy}","received_events_url":"https://api.github.com/users/christophpe/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2017-08-11T08:53:34Z","updated_at":"2017-08-16T15:54:54Z","closed_at":null,"body":"**CrateDB version:** 2.0.6\r\n\r\n**JVM version:** OpenJDK 1.8.0_131\r\n\r\n**OS version / environment description:** CentOS 7 (3.10.0-514.26.2.el7.x86_64)\r\n\r\n**Problem description:**\r\nUsing PHP, some INSERT statements seem to fail randomly.\r\n\r\nRelations are to be inserted, and it seems like about 50% of the queries pass, while the rest fails.\r\n\r\nThe error message is:\r\nCrate Prepare Error: Code = 4000, Message = SQLActionException[SQLParseException: line 1:number: no viable alternative at input ',']\r\n\r\nIf you copy the queries without any change into the console in the AdminUI, every query succeeds.\r\n\r\nThe driver we use is the crate database driver (crate-pdo-0.6.3 (composer package)).\r\n\r\n**Steps to reproduce:**\r\nCREATE TABLE IF NOT EXISTS \"company\".\"relation\" (\r\n\"id_from\" STRING,\r\n\"id_to\" STRING,\r\nPRIMARY KEY (\"id_from\", \"id_to\")\r\n)\r\nCLUSTERED BY (\"id_from\") INTO 8 SHARDS\r\nWITH (\r\n\"blocks.metadata\" = false,\r\n\"blocks.read\" = false,\r\n\"blocks.read_only\" = false,\r\n\"blocks.write\" = false,\r\ncolumn_policy = 'strict',\r\nnumber_of_replicas = '1',\r\n\"recovery.initial_shards\" = 'quorum',\r\nrefresh_interval = 1000,\r\n\"routing.allocation.enable\" = 'all',\r\n\"routing.allocation.total_shards_per_node\" = -1,\r\n\"translog.durability\" = 'REQUEST',\r\n\"translog.flush_threshold_size\" = 536870912,\r\n\"translog.sync_interval\" = 5000,\r\n\"unassigned.node_left.delayed_timeout\" = 60000,\r\n\"warmer.enabled\" = true,\r\n\"write.wait_for_active_shards\" = 'all'\r\n)\r\n\r\n_INSERT that SUCCEEDS:_\r\nINSERT INTO company.relation (id_from, id_to) VALUES ('413462662023162', '1691996757702397'), ('413462662023162', '359532474088827'), ('413462662023162', '1591614901072190');\r\n\r\n_INSERT that FAILS:_\r\nINSERT INTO company.relation (id_from, id_to) VALUES ('413462662023162', '1691996757702397'), ('413462662023162', '359532474088827'), ('413462662023162', '1591614901072190'), ('413462662023162', '42199325465'), ('413462662023162', '440195839442412'), ('413462662023162', '106197822745388');"},"comment":{"url":"https://api.github.com/repos/crate/crate-pdo/issues/comments/322817101","html_url":"https://github.com/crate/crate-pdo/issues/68#issuecomment-322817101","issue_url":"https://api.github.com/repos/crate/crate-pdo/issues/68","id":322817101,"user":{"login":"dornbirndevelops","id":25949821,"avatar_url":"https://avatars0.githubusercontent.com/u/25949821?v=4","gravatar_id":"","url":"https://api.github.com/users/dornbirndevelops","html_url":"https://github.com/dornbirndevelops","followers_url":"https://api.github.com/users/dornbirndevelops/followers","following_url":"https://api.github.com/users/dornbirndevelops/following{/other_user}","gists_url":"https://api.github.com/users/dornbirndevelops/gists{/gist_id}","starred_url":"https://api.github.com/users/dornbirndevelops/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dornbirndevelops/subscriptions","organizations_url":"https://api.github.com/users/dornbirndevelops/orgs","repos_url":"https://api.github.com/users/dornbirndevelops/repos","events_url":"https://api.github.com/users/dornbirndevelops/events{/privacy}","received_events_url":"https://api.github.com/users/dornbirndevelops/received_events","type":"User","site_admin":false},"created_at":"2017-08-16T15:54:54Z","updated_at":"2017-08-16T15:54:54Z","body":"@christophpe \r\nThank you for the fast reply! I will try tomorrow!\r\n\r\nJust to get this right: the insert statement itself can remain about the same length of 6 records. I should just try to invoke it more often rapidly.\r\n\r\nDare i ask how these values are generated? And are these Insert-Statements done asynchronously?"}}
{"actor":{"display_login":"dornbirndevelops"}}