predictionio-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chan Lee <chanlee...@gmail.com>
Subject Re: Postgresql issue - 'relation doesnt exist'
Date Wed, 01 Feb 2017 00:07:04 GMT
That is strange. The event table should have been created when you run `pio
app new MyApp`.

Could you try re-creating your app with `pio app new MyApp2 --verbose`, and
check that table "pio_event_<your_app_id>" has been created?

On Tue, Jan 31, 2017 at 2:12 PM, Saarthak Chandra <
chandra.saarthak@gmail.com> wrote:

> I'm using postgresql
> I created the db called pio..using the created pio command...
>
> Not sure why the event table is not being created when I send the post
> request though ....
>
> On 31 Jan 2017 17:10, "Tom Chan" <yukhei.chan@gmail.com> wrote:
>
>> I don't have an answer from the top of my head, hope someone can chime in
>> and help.
>>
>> To help others debugging this, which database are you using (PostgreSQL,
>> MySQL or elasticsearch)?
>>
>> Tom
>>
>> On Tue, Jan 31, 2017 at 1:47 PM, Saarthak Chandra <
>> chandra.saarthak@gmail.com> wrote:
>>
>>> Hi,
>>>
>>> I did create a new app, and used the access key when doing a post to the
>>> event server.
>>> When i run pio app list, I do see the app that I created here
>>>
>>> [INFO] [App$]                MpApp |    1 | -my-access-key | (all)
>>>
>>>
>>> Post request I made from my terminal :
>>>
>>> curl -i -X POST http://localhost:7070/events.j
>>> son\?accessKey\=-my-access-key \
>>>
>>> -H "Content-Type: application/json" \
>>>
>>> -d '{
>>>
>>>   "event" : "$set",
>>>
>>>   "entityType" : "user",
>>>
>>>   "entityId" : "u0"
>>>
>>> }'
>>>
>>>
>>> Response I get :
>>>
>>> HTTP/1.1 500 Internal Server Error
>>>
>>> Server: spray-can/1.3.3
>>>
>>> Date: Tue, 31 Jan 2017 21:46:24 GMT
>>>
>>> Content-Type: application/json; charset=UTF-8
>>>
>>> Content-Length: 76
>>>
>>>
>>> {"message":"ERROR: relation \"pio_event_1\" does not exist\n  Position:
>>> 20"}*%*
>>>
>>> On a side note : I also checked to see that the event server was up :
>>> localhost:7070 : Shows the JSON {"status":"alive"}
>>>
>>>
>>>
>>> On Tue, Jan 31, 2017 at 4:39 PM, Tom Chan <yukhei.chan@gmail.com> wrote:
>>>
>>>> As a quick check, did you do
>>>>
>>>> pio app new MyApp1
>>>>
>>>> and what's the output when you run
>>>>
>>>> pio app list
>>>>
>>>> ? and what's the POST request you're trying that returned error 500?
>>>>
>>>> Tom
>>>>
>>>> On Tue, Jan 31, 2017 at 12:48 PM, Saarthak Chandra <
>>>> chandra.saarthak@gmail.com> wrote:
>>>>
>>>>> Hi,
>>>>>
>>>>> I am currently using Postgresql , as my storage repo for event data.
>>>>>
>>>>> However, when i do a POST using curl, to the event server at
>>>>> 'localhost:7070', I get a Http 500 error saying :
>>>>>
>>>>> {"message":"ERROR: relation \"pio_event_1\" does not exist\n
>>>>> Position: 20"}
>>>>> Shouldn't the table/relation be created automatically, and then the
>>>>> data I posted be inserted ??
>>>>>
>>>>> I was following along the tutorials here :
>>>>> http://predictionio.incubator.apache.org/templates/javaeco
>>>>> mmercerecommendation/quickstart/
>>>>>
>>>>> Thanks for your help !!
>>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> Saarthak Chandra ,
>>> Masters in Computer Science,
>>> Cornell University.
>>>
>>
>>

Mime
View raw message