Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error with importing demo twitter feed #720

Closed
richardprice opened this issue Apr 26, 2014 · 2 comments
Closed

Error with importing demo twitter feed #720

richardprice opened this issue Apr 26, 2014 · 2 comments

Comments

@richardprice
Copy link

The demo twitter feed import in the Admin interface is failing to store any of the tweets.

Server is being run on JRE7 on Windows Server 2012R2, client on Windows 8. No firewall problems, also tested on JRE7 on Windows 7 64bit with both client and server on same machine.

The following is the request/response series which are causing the issues:

POST http://192.168.1.15:4200/_sql HTTP/1.1
Host: 192.168.1.15:4200
Connection: keep-alive
Content-Length: 768
Accept: application/json, text/plain, /
Origin: http://192.168.1.15:4200
User-Agent: Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/34.0.1847.116 Safari/537.36
Content-Type: application/json;charset=UTF-8
Referer: http://192.168.1.15:4200/_plugin/crate-admin/
Accept-Encoding: gzip,deflate,sdch
Accept-Language: en-US,en;q=0.8

{"stmt":"create table tweets ( id string primary key, created_at timestamp, text string INDEX using fulltext, source string INDEX using fulltext, retweeted boolean, "user" object(strict) as ( created_at timestamp, verified boolean, followers_count integer, id string, statuses_count integer, description string INDEX using fulltext, friends_count integer, location string INDEX using fulltext ) ) with (number_of_replicas = '0-all')"}

HTTP/1.1 500 Internal Server Error
Access-Control-Allow-Origin: *
Content-Type: application/json; charset=UTF-8
Content-Length: 108

{"error":{"message":"NoClassDefFoundError[Could not initialize class io.airlift.slice.Slices]","code":1000}}

POST http://192.168.1.15:4200/_sql HTTP/1.1
Host: 192.168.1.15:4200
Connection: keep-alive
Content-Length: 795
Accept: application/json, text/plain, /
Origin: http://192.168.1.15:4200
User-Agent: Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/34.0.1847.116 Safari/537.36
Content-Type: application/json;charset=UTF-8
Referer: http://192.168.1.15:4200/_plugin/crate-admin/
Accept-Encoding: gzip,deflate,sdch
Accept-Language: en-US,en;q=0.8

{"stmt":"insert into tweets values ($1, $2, $3, $4, $5, $6)","args":[1398526680000,"460080361267929091",false,"<a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone","RT @Nax_Rag: 東方神起9周年おめでとう!\nこれからも二人を信じて付いていきます! \n#東方神起9thAnniversary",{"followers_count":58,"verified":false,"description":"東方神起 の2人が大好き(チャンミン寄り♪)BB♡の曲も好き(テソン寄り♪)2NE1♡洋楽も聞くよ♪ 音楽に元気をもらってます。日常の事もつぶやいてるBigeast&VIP。 オバペンで マイペースですがよろしくです(゚v゚)♪","friends_count":92,"statuses_count":5401,"created_at":1360151496000,"id":"1153801358","location":""}]}

HTTP/1.1 400 Bad Request
Access-Control-Allow-Origin: *
Content-Type: application/json; charset=UTF-8
Content-Length: 575

{"error":{"message":"ValidationException[Validation failed for user_id: Invalid input for type string: {id=1153801358, location=, friends_count=92, description=東方神起 の2人が大好き(チャンミン寄り♪)BB♡の曲も好き(テソン寄り♪)2NE1♡洋楽も聞くよ♪ 音楽に元気をもらってます。日常の事もつぶやいてるBigeast&VIP。 オバペンで マイペースですがよろしくです(゚v゚)♪, verified=false, created_at=1360151496000, statuses_count=5401, followers_count=58}]","code":4003,"args":["user_id"]}}

I was able to create a table from within the online console, but any inserts also failed with the error NoClassDefFoundError[Could not initialize class io.airlift.slice.Slices]".

This is the sole Crate server on the network.

@richardprice
Copy link
Author

Yup, related to the other issue, resolved.

@lukasender
Copy link
Contributor

Solved via #722 (comment)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants