Errors when running deployment/sbin/generate-social-network.sh
Closed this issue · 2 comments
paulczar commented
Here's a run of deployment/sbin/generate-social-network.sh
to show the errors I see.
--> Wake up user service "UP"
--> Wake up friend service "UP"
--> Wake up recommendation service "UP"
====> Create users
{
"timestamp": "2018-12-20T16:43:13.627+0000",
"status": 500,
"error": "Internal Server Error",
"message": "executeMany; bad SQL grammar [INSERT INTO users (first_name, last_name) VALUES($1, $2) RETURNING *]; nested exception is PostgresqlServerErrorException{code='42P01', columnName='null', constraintName='null', dataTypeName='null', detail='null', file='parse_relation.c', hint='null', internalPosition='null', internalQuery='null', line='1180', message='relation \"users\" does not exist', position='13', routine='parserOpenTable', schemaName='null', severityLocalized='ERROR', severityNonLocalized='ERROR', tableName='null', where='null'} R2dbcException{errorCode=0, sqlState='42P01'} io.r2dbc.postgresql.PostgresqlServerErrorException: relation \"users\" does not exist",
"path": "/v1/users"
}
{
"timestamp": "2018-12-20T16:43:13.941+0000",
"status": 500,
"error": "Internal Server Error",
"message": "executeMany; bad SQL grammar [INSERT INTO users (first_name, last_name) VALUES($1, $2) RETURNING *]; nested exception is PostgresqlServerErrorException{code='42P01', columnName='null', constraintName='null', dataTypeName='null', detail='null', file='parse_relation.c', hint='null', internalPosition='null', internalQuery='null', line='1180', message='relation \"users\" does not exist', position='13', routine='parserOpenTable', schemaName='null', severityLocalized='ERROR', severityNonLocalized='ERROR', tableName='null', where='null'} R2dbcException{errorCode=0, sqlState='42P01'} io.r2dbc.postgresql.PostgresqlServerErrorException: relation \"users\" does not exist",
"path": "/v1/users"
}
{
"timestamp": "2018-12-20T16:43:14.193+0000",
"status": 500,
"error": "Internal Server Error",
"message": "executeMany; bad SQL grammar [INSERT INTO users (first_name, last_name) VALUES($1, $2) RETURNING *]; nested exception is PostgresqlServerErrorException{code='42P01', columnName='null', constraintName='null', dataTypeName='null', detail='null', file='parse_relation.c', hint='null', internalPosition='null', internalQuery='null', line='1180', message='relation \"users\" does not exist', position='13', routine='parserOpenTable', schemaName='null', severityLocalized='ERROR', severityNonLocalized='ERROR', tableName='null', where='null'} R2dbcException{errorCode=0, sqlState='42P01'} io.r2dbc.postgresql.PostgresqlServerErrorException: relation \"users\" does not exist",
"path": "/v1/users"
}
{
"id": 1,
"firstName": "Man",
"lastName": "Verne"
}
{
"id": 2,
"firstName": "Charlsie",
"lastName": "Schild"
}
{
"id": 3,
"firstName": "Queen",
"lastName": "Mulholland"
}
{
"timestamp": "2018-12-20T16:43:15.660+0000",
"status": 500,
"error": "Internal Server Error",
"message": "executeMany; bad SQL grammar [INSERT INTO users (first_name, last_name) VALUES($1, $2) RETURNING *]; nested exception is PostgresqlServerErrorException{code='42P01', columnName='null', constraintName='null', dataTypeName='null', detail='null', file='parse_relation.c', hint='null', internalPosition='null', internalQuery='null', line='1180', message='relation \"users\" does not exist', position='13', routine='parserOpenTable', schemaName='null', severityLocalized='ERROR', severityNonLocalized='ERROR', tableName='null', where='null'} R2dbcException{errorCode=0, sqlState='42P01'} io.r2dbc.postgresql.PostgresqlServerErrorException: relation \"users\" does not exist",
"path": "/v1/users"
}
{
"timestamp": "2018-12-20T16:43:15.893+0000",
"status": 500,
"error": "Internal Server Error",
"message": "executeMany; bad SQL grammar [INSERT INTO users (first_name, last_name) VALUES($1, $2) RETURNING *]; nested exception is PostgresqlServerErrorException{code='42P01', columnName='null', constraintName='null', dataTypeName='null', detail='null', file='parse_relation.c', hint='null', internalPosition='null', internalQuery='null', line='1180', message='relation \"users\" does not exist', position='13', routine='parserOpenTable', schemaName='null', severityLocalized='ERROR', severityNonLocalized='ERROR', tableName='null', where='null'} R2dbcException{errorCode=0, sqlState='42P01'} io.r2dbc.postgresql.PostgresqlServerErrorException: relation \"users\" does not exist",
"path": "/v1/users"
}
{
"timestamp": "2018-12-20T16:43:16.125+0000",
"status": 500,
"error": "Internal Server Error",
"message": "executeMany; bad SQL grammar [INSERT INTO users (first_name, last_name) VALUES($1, $2) RETURNING *]; nested exception is PostgresqlServerErrorException{code='42P01', columnName='null', constraintName='null', dataTypeName='null', detail='null', file='parse_relation.c', hint='null', internalPosition='null', internalQuery='null', line='1180', message='relation \"users\" does not exist', position='13', routine='parserOpenTable', schemaName='null', severityLocalized='ERROR', severityNonLocalized='ERROR', tableName='null', where='null'} R2dbcException{errorCode=0, sqlState='42P01'} io.r2dbc.postgresql.PostgresqlServerErrorException: relation \"users\" does not exist",
"path": "/v1/users"
}
{
"id": 4,
"firstName": "Corie",
"lastName": "Shockley"
}
{
"timestamp": "2018-12-20T16:43:16.568+0000",
"status": 500,
"error": "Internal Server Error",
"message": "executeMany; bad SQL grammar [INSERT INTO users (first_name, last_name) VALUES($1, $2) RETURNING *]; nested exception is PostgresqlServerErrorException{code='42P01', columnName='null', constraintName='null', dataTypeName='null', detail='null', file='parse_relation.c', hint='null', internalPosition='null', internalQuery='null', line='1180', message='relation \"users\" does not exist', position='13', routine='parserOpenTable', schemaName='null', severityLocalized='ERROR', severityNonLocalized='ERROR', tableName='null', where='null'} R2dbcException{errorCode=0, sqlState='42P01'} io.r2dbc.postgresql.PostgresqlServerErrorException: relation \"users\" does not exist",
"path": "/v1/users"
}
{
"id": 5,
"firstName": "Shavonda",
"lastName": "Lyford"
}
{
"timestamp": "2018-12-20T16:43:16.976+0000",
"status": 500,
"error": "Internal Server Error",
"message": "executeMany; bad SQL grammar [INSERT INTO users (first_name, last_name) VALUES($1, $2) RETURNING *]; nested exception is PostgresqlServerErrorException{code='42P01', columnName='null', constraintName='null', dataTypeName='null', detail='null', file='parse_relation.c', hint='null', internalPosition='null', internalQuery='null', line='1180', message='relation \"users\" does not exist', position='13', routine='parserOpenTable', schemaName='null', severityLocalized='ERROR', severityNonLocalized='ERROR', tableName='null', where='null'} R2dbcException{errorCode=0, sqlState='42P01'} io.r2dbc.postgresql.PostgresqlServerErrorException: relation \"users\" does not exist",
"path": "/v1/users"
}
{
"timestamp": "2018-12-20T16:43:17.178+0000",
"status": 500,
"error": "Internal Server Error",
"message": "executeMany; bad SQL grammar [INSERT INTO users (first_name, last_name) VALUES($1, $2) RETURNING *]; nested exception is PostgresqlServerErrorException{code='42P01', columnName='null', constraintName='null', dataTypeName='null', detail='null', file='parse_relation.c', hint='null', internalPosition='null', internalQuery='null', line='1180', message='relation \"users\" does not exist', position='13', routine='parserOpenTable', schemaName='null', severityLocalized='ERROR', severityNonLocalized='ERROR', tableName='null', where='null'} R2dbcException{errorCode=0, sqlState='42P01'} io.r2dbc.postgresql.PostgresqlServerErrorException: relation \"users\" does not exist",
"path": "/v1/users"
}
{
"timestamp": "2018-12-20T16:43:17.384+0000",
"status": 500,
"error": "Internal Server Error",
"message": "executeMany; bad SQL grammar [INSERT INTO users (first_name, last_name) VALUES($1, $2) RETURNING *]; nested exception is PostgresqlServerErrorException{code='42P01', columnName='null', constraintName='null', dataTypeName='null', detail='null', file='parse_relation.c', hint='null', internalPosition='null', internalQuery='null', line='1180', message='relation \"users\" does not exist', position='13', routine='parserOpenTable', schemaName='null', severityLocalized='ERROR', severityNonLocalized='ERROR', tableName='null', where='null'} R2dbcException{errorCode=0, sqlState='42P01'} io.r2dbc.postgresql.PostgresqlServerErrorException: relation \"users\" does not exist",
"path": "/v1/users"
}
{
"id": 6,
"firstName": "Charity",
"lastName": "Villeneuve"
}
{
"id": 7,
"firstName": "Nelida",
"lastName": "Santoyo"
}
{
"id": 8,
"firstName": "Augustina",
"lastName": "Pilger"
}
{
"timestamp": "2018-12-20T16:43:18.254+0000",
"status": 500,
"error": "Internal Server Error",
"message": "executeMany; bad SQL grammar [INSERT INTO users (first_name, last_name) VALUES($1, $2) RETURNING *]; nested exception is PostgresqlServerErrorException{code='42P01', columnName='null', constraintName='null', dataTypeName='null', detail='null', file='parse_relation.c', hint='null', internalPosition='null', internalQuery='null', line='1180', message='relation \"users\" does not exist', position='13', routine='parserOpenTable', schemaName='null', severityLocalized='ERROR', severityNonLocalized='ERROR', tableName='null', where='null'} R2dbcException{errorCode=0, sqlState='42P01'} io.r2dbc.postgresql.PostgresqlServerErrorException: relation \"users\" does not exist",
"path": "/v1/users"
}
added ids: 12345678
====> Create 10 friendships
4 <3 1
{
"timestamp": "2018-12-20T16:43:19.109+0000",
"status": 500,
"error": "Internal Server Error",
"message": "executeMany; bad SQL grammar [SELECT * FROM Friend f WHERE user_id = $1 AND friend_id = $2]; nested exception is PostgresqlServerErrorException{code='42P01', columnName='null', constraintName='null', dataTypeName='null', detail='null', file='parse_relation.c', hint='null', internalPosition='null', internalQuery='null', line='1180', message='relation \"friend\" does not exist', position='15', routine='parserOpenTable', schemaName='null', severityLocalized='ERROR', severityNonLocalized='ERROR', tableName='null', where='null'} R2dbcException{errorCode=0, sqlState='42P01'} io.r2dbc.postgresql.PostgresqlServerErrorException: relation \"friend\" does not exist",
"path": "/v1/users/4/commands/addFriend"
}
4 <3 8
{
"timestamp": "2018-12-20T16:43:20.344+0000",
"status": 500,
"error": "Internal Server Error",
"message": "executeMany; bad SQL grammar [SELECT * FROM Friend f WHERE user_id = $1 AND friend_id = $2]; nested exception is PostgresqlServerErrorException{code='42P01', columnName='null', constraintName='null', dataTypeName='null', detail='null', file='parse_relation.c', hint='null', internalPosition='null', internalQuery='null', line='1180', message='relation \"friend\" does not exist', position='15', routine='parserOpenTable', schemaName='null', severityLocalized='ERROR', severityNonLocalized='ERROR', tableName='null', where='null'} R2dbcException{errorCode=0, sqlState='42P01'} io.r2dbc.postgresql.PostgresqlServerErrorException: relation \"friend\" does not exist",
"path": "/v1/users/4/commands/addFriend"
}
7 <3 6
{
"timestamp": "2018-12-20T16:43:21.540+0000",
"status": 500,
"error": "Internal Server Error",
"message": "executeMany; bad SQL grammar [SELECT * FROM Friend f WHERE user_id = $1 AND friend_id = $2]; nested exception is PostgresqlServerErrorException{code='42P01', columnName='null', constraintName='null', dataTypeName='null', detail='null', file='parse_relation.c', hint='null', internalPosition='null', internalQuery='null', line='1180', message='relation \"friend\" does not exist', position='15', routine='parserOpenTable', schemaName='null', severityLocalized='ERROR', severityNonLocalized='ERROR', tableName='null', where='null'} R2dbcException{errorCode=0, sqlState='42P01'} io.r2dbc.postgresql.PostgresqlServerErrorException: relation \"friend\" does not exist",
"path": "/v1/users/7/commands/addFriend"
}
4 <3 5
{
"id": 1,
"userId": 4,
"friendId": 5
}
4 <3 6
{
"timestamp": "2018-12-20T16:43:24.243+0000",
"status": 500,
"error": "Internal Server Error",
"message": "executeMany; bad SQL grammar [SELECT * FROM Friend f WHERE user_id = $1 AND friend_id = $2]; nested exception is PostgresqlServerErrorException{code='42P01', columnName='null', constraintName='null', dataTypeName='null', detail='null', file='parse_relation.c', hint='null', internalPosition='null', internalQuery='null', line='1180', message='relation \"friend\" does not exist', position='15', routine='parserOpenTable', schemaName='null', severityLocalized='ERROR', severityNonLocalized='ERROR', tableName='null', where='null'} R2dbcException{errorCode=0, sqlState='42P01'} io.r2dbc.postgresql.PostgresqlServerErrorException: relation \"friend\" does not exist",
"path": "/v1/users/4/commands/addFriend"
}
6 <3 8
{
"id": 2,
"userId": 6,
"friendId": 8
}
7 <3 7
{
"timestamp": "2018-12-20T16:43:26.685+0000",
"status": 500,
"error": "Internal Server Error",
"message": "executeMany; bad SQL grammar [SELECT * FROM Friend f WHERE user_id = $1 AND friend_id = $2]; nested exception is PostgresqlServerErrorException{code='42P01', columnName='null', constraintName='null', dataTypeName='null', detail='null', file='parse_relation.c', hint='null', internalPosition='null', internalQuery='null', line='1180', message='relation \"friend\" does not exist', position='15', routine='parserOpenTable', schemaName='null', severityLocalized='ERROR', severityNonLocalized='ERROR', tableName='null', where='null'} R2dbcException{errorCode=0, sqlState='42P01'} io.r2dbc.postgresql.PostgresqlServerErrorException: relation \"friend\" does not exist",
"path": "/v1/users/7/commands/addFriend"
}
8 <3 5
{
"timestamp": "2018-12-20T16:43:27.902+0000",
"status": 500,
"error": "Internal Server Error",
"message": "executeMany; bad SQL grammar [SELECT * FROM Friend f WHERE user_id = $1 AND friend_id = $2]; nested exception is PostgresqlServerErrorException{code='42P01', columnName='null', constraintName='null', dataTypeName='null', detail='null', file='parse_relation.c', hint='null', internalPosition='null', internalQuery='null', line='1180', message='relation \"friend\" does not exist', position='15', routine='parserOpenTable', schemaName='null', severityLocalized='ERROR', severityNonLocalized='ERROR', tableName='null', where='null'} R2dbcException{errorCode=0, sqlState='42P01'} io.r2dbc.postgresql.PostgresqlServerErrorException: relation \"friend\" does not exist",
"path": "/v1/users/8/commands/addFriend"
}
5 <3 6
{
"timestamp": "2018-12-20T16:43:29.108+0000",
"status": 500,
"error": "Internal Server Error",
"message": "executeMany; bad SQL grammar [INSERT INTO friend (user_id, friend_id) VALUES($1, $2) RETURNING *]; nested exception is PostgresqlServerErrorException{code='42P01', columnName='null', constraintName='null', dataTypeName='null', detail='null', file='parse_relation.c', hint='null', internalPosition='null', internalQuery='null', line='1180', message='relation \"friend\" does not exist', position='13', routine='parserOpenTable', schemaName='null', severityLocalized='ERROR', severityNonLocalized='ERROR', tableName='null', where='null'} R2dbcException{errorCode=0, sqlState='42P01'} io.r2dbc.postgresql.PostgresqlServerErrorException: relation \"friend\" does not exist",
"path": "/v1/users/5/commands/addFriend"
}
4 <3 8
{
"timestamp": "2018-12-20T16:43:30.302+0000",
"status": 500,
"error": "Internal Server Error",
"message": "executeMany; bad SQL grammar [SELECT * FROM Friend f WHERE user_id = $1 AND friend_id = $2]; nested exception is PostgresqlServerErrorException{code='42P01', columnName='null', constraintName='null', dataTypeName='null', detail='null', file='parse_relation.c', hint='null', internalPosition='null', internalQuery='null', line='1180', message='relation \"friend\" does not exist', position='15', routine='parserOpenTable', schemaName='null', severityLocalized='ERROR', severityNonLocalized='ERROR', tableName='null', where='null'} R2dbcException{errorCode=0, sqlState='42P01'} io.r2dbc.postgresql.PostgresqlServerErrorException: relation \"friend\" does not exist",
"path": "/v1/users/4/commands/addFriend"
}
--> Check that 6 has friends
[
{
"id": 2,
"userId": 6,
"friendId": 8
}
]
--> List Mutual friends between 8 and 7
[]
--> Recommend friends to
[]
kbastani commented
Verified as fixed.
-n --> Wake up user service
"UP"
-n --> Wake up friend service
"UP"
-n --> Wake up recommendation service
"UP"
====> Create users
{
"id": 1,
"firstName": "Mee",
"lastName": "Hill"
}
{
"id": 2,
"firstName": "Trevor",
"lastName": "Junious"
}
{
"id": 3,
"firstName": "Johana",
"lastName": "Rodes"
}
{
"id": 4,
"firstName": "Man",
"lastName": "Verne"
}
{
"id": 5,
"firstName": "Charlsie",
"lastName": "Schild"
}
{
"id": 6,
"firstName": "Queen",
"lastName": "Mulholland"
}
{
"id": 7,
"firstName": "Tana",
"lastName": "Maillet"
}
{
"id": 8,
"firstName": "Ivey",
"lastName": "Kelso"
}
{
"id": 9,
"firstName": "Cleotilde",
"lastName": "Howe"
}
{
"id": 10,
"firstName": "Corie",
"lastName": "Shockley"
}
{
"id": 11,
"firstName": "Hildegard",
"lastName": "Montelongo"
}
{
"id": 12,
"firstName": "Shavonda",
"lastName": "Lyford"
}
{
"id": 13,
"firstName": "Nery",
"lastName": "Santi"
}
{
"id": 14,
"firstName": "Ollie",
"lastName": "Berard"
}
{
"id": 15,
"firstName": "Rubin",
"lastName": "Mosquera"
}
{
"id": 16,
"firstName": "Charity",
"lastName": "Villeneuve"
}
{
"id": 17,
"firstName": "Nelida",
"lastName": "Santoyo"
}
{
"id": 18,
"firstName": "Augustina",
"lastName": "Pilger"
}
{
"id": 19,
"firstName": "Sheila",
"lastName": "Boulware"
}
-n added ids:
-n 1
-n 2
-n 3
-n 4
-n 5
-n 6
-n 7
-n 8
-n 9
-n 10
-n 11
-n 12
-n 13
-n 14
-n 15
-n 16
-n 17
-n 18
-n 19
====> Create 10 friendships
19 <3 7
{
"id": 1,
"userId": 19,
"friendId": 7
}
3 <3 13
{
"id": 2,
"userId": 3,
"friendId": 13
}
8 <3 12
{
"id": 3,
"userId": 8,
"friendId": 12
}
7 <3 8
{
"id": 4,
"userId": 7,
"friendId": 8
}
10 <3 17
{
"id": 5,
"userId": 10,
"friendId": 17
}
17 <3 1
{
"id": 6,
"userId": 17,
"friendId": 1
}
6 <3 6
{
"id": 7,
"userId": 6,
"friendId": 6
}
17 <3 11
{
"id": 8,
"userId": 17,
"friendId": 11
}
14 <3 12
{
"id": 9,
"userId": 14,
"friendId": 12
}
11 <3 8
{
"id": 10,
"userId": 11,
"friendId": 8
}
10 <3 7
{
"id": 11,
"userId": 10,
"friendId": 7
}
14 <3 15
{
"id": 12,
"userId": 14,
"friendId": 15
}
4 <3 12
{
"id": 13,
"userId": 4,
"friendId": 12
}
7 <3 14
{
"id": 14,
"userId": 7,
"friendId": 14
}
4 <3 11
{
"id": 15,
"userId": 4,
"friendId": 11
}
13 <3 13
{
"id": 16,
"userId": 13,
"friendId": 13
}
6 <3 12
{
"id": 17,
"userId": 6,
"friendId": 12
}
2 <3 10
{
"id": 18,
"userId": 2,
"friendId": 10
}
3 <3 15
{
"id": 19,
"userId": 3,
"friendId": 15
}
9 <3 9
{
"id": 20,
"userId": 9,
"friendId": 9
}
9 <3 6
{
"id": 21,
"userId": 9,
"friendId": 6
}
10 <3 12
{
"id": 22,
"userId": 10,
"friendId": 12
}
1 <3 13
{
"id": 23,
"userId": 1,
"friendId": 13
}
6 <3 19
{
"id": 24,
"userId": 6,
"friendId": 19
}
4 <3 18
{
"id": 25,
"userId": 4,
"friendId": 18
}
13 <3 9
{
"id": 26,
"userId": 13,
"friendId": 9
}
4 <3 11
{
"timestamp": "2018-12-20T19:44:17.577+0000",
"path": "/v1/users/4/commands/addFriend",
"status": 500,
"error": "Internal Server Error",
"message": "409 Friendship already exists"
}
7 <3 18
{
"id": 27,
"userId": 7,
"friendId": 18
}
18 <3 14
{
"id": 28,
"userId": 18,
"friendId": 14
}
7 <3 8
{
"timestamp": "2018-12-20T19:44:18.289+0000",
"path": "/v1/users/7/commands/addFriend",
"status": 500,
"error": "Internal Server Error",
"message": "409 Friendship already exists"
}
11 <3 19
{
"id": 29,
"userId": 11,
"friendId": 19
}
1 <3 14
{
"id": 30,
"userId": 1,
"friendId": 14
}
8 <3 19
{
"id": 31,
"userId": 8,
"friendId": 19
}
11 <3 14
{
"id": 32,
"userId": 11,
"friendId": 14
}
18 <3 18
{
"id": 33,
"userId": 18,
"friendId": 18
}
5 <3 2
{
"id": 34,
"userId": 5,
"friendId": 2
}
11 <3 17
{
"id": 35,
"userId": 11,
"friendId": 17
}
19 <3 19
{
"id": 36,
"userId": 19,
"friendId": 19
}
17 <3 4
{
"id": 37,
"userId": 17,
"friendId": 4
}
2 <3 15
{
"id": 38,
"userId": 2,
"friendId": 15
}
--> Check that 11 has friends
[
{
"id": 10,
"userId": 11,
"friendId": 8
},
{
"id": 29,
"userId": 11,
"friendId": 19
},
{
"id": 32,
"userId": 11,
"friendId": 14
},
{
"id": 35,
"userId": 11,
"friendId": 17
}
]
--> List Mutual friends between 13 and 11
[]
--> Recommend friends to
[
{
"user": {
"id": 17,
"firstName": "Nelida",
"lastName": "Santoyo"
},
"weight": 3
},
{
"user": {
"id": 4,
"firstName": "Man",
"lastName": "Verne"
},
"weight": 3
},
{
"user": {
"id": 8,
"firstName": "Ivey",
"lastName": "Kelso"
},
"weight": 3
},
{
"user": {
"id": 19,
"firstName": "Sheila",
"lastName": "Boulware"
},
"weight": 2
},
{
"user": {
"id": 10,
"firstName": "Corie",
"lastName": "Shockley"
},
"weight": 2
},
{
"user": {
"id": 13,
"firstName": "Nery",
"lastName": "Santi"
},
"weight": 1
},
{
"user": {
"id": 2,
"firstName": "Trevor",
"lastName": "Junious"
},
"weight": 1
},
{
"user": {
"id": 3,
"firstName": "Johana",
"lastName": "Rodes"
},
"weight": 1
},
{
"user": {
"id": 6,
"firstName": "Queen",
"lastName": "Mulholland"
},
"weight": 1
}
]