Hi there, using typeOrm on node application I have this error when i start transaction to mysql:
(node:21) UnhandledPromiseRejectionWarning: QueryFailedError: ER_LOCK_WAIT_TIMEOUT: Lock wait timeout exceeded; try restarting transaction
at new QueryFailedError (/opt/app/node_modules/typeorm/error/QueryFailedError.js:11:28)
at Query.<anonymous> (/opt/app/node_modules/typeorm/driver/mysql/MysqlQueryRunner.js:170:45)
at Query.<anonymous> (/opt/app/node_modules/mysql/lib/Connection.js:526:10)
at Query._callback (/opt/app/node_modules/mysql/lib/Connection.js:488:16)
at Query.Sequence.end (/opt/app/node_modules/mysql/lib/protocol/sequences/Sequence.js:83:24)
at Query.ErrorPacket (/opt/app/node_modules/mysql/lib/protocol/sequences/Query.js:92:8)
at Protocol._parsePacket (/opt/app/node_modules/mysql/lib/protocol/Protocol.js:291:23)
at Parser._parsePacket (/opt/app/node_modules/mysql/lib/protocol/Parser.js:433:10)
at Parser.write (/opt/app/node_modules/mysql/lib/protocol/Parser.js:43:10)
at Protocol.write (/opt/app/node_modules/mysql/lib/protocol/Protocol.js:38:16)
at Socket.<anonymous> (/opt/app/node_modules/mysql/lib/Connection.js:88:28)
at Socket.<anonymous> (/opt/app/node_modules/mysql/lib/Connection.js:526:10)
at Socket.emit (events.js:315:20)
at addChunk (internal/streams/readable.js:309:12)
at readableAddChunk (internal/streams/readable.js:284:9)
at Socket.Readable.push (internal/streams/readable.js:223:10)
(node:21) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag `--unhandled-rejections=strict` (see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 377404)
21 - 2021-03-09T18:30:52.823Z - [ExceptionInterceptor] Database Exception - ER_LOCK_WAIT_TIMEOUT: Lock wait timeout exceeded; try restarting transaction
Error: Database Exception
at PartiesService.deleteContractParties (/opt/app/dist/apps/contracts-api/main.js:10592:19)
at runMicrotasks (<anonymous>)
at processTicksAndRejections (internal/process/task_queues.js:93:5)
at async ContractsService.update (/opt/app/dist/apps/contracts-api/main.js:11193:9)
21 - 2021-03-09T18:30:52.824Z - [ExceptionInterceptor] Catched DatabaseException exception -> throw InternalServerErrorException
21 - 2021-03-09T18:30:52.826Z - [ExceptionHandler] DatabaseException: {"type":"DatabaseException","subType":"Party","internalMessage":"ER_LOCK_WAIT_TIMEOUT: Lock wait timeout exceeded; try restarting transaction"}
Error: Database Exception
at CatchSubscriber.selector (/opt/app/dist/apps/contracts-api/main.js:1332:42)
at CatchSubscriber.error (/opt/app/node_modules/rxjs/internal/operators/catchError.js:48:31)
at MergeMapSubscriber.OuterSubscriber.notifyError (/opt/app/node_modules/rxjs/internal/OuterSubscriber.js:26:26)
at InnerSubscriber._error (/opt/app/node_modules/rxjs/internal/InnerSubscriber.js:31:21)
at InnerSubscriber.Subscriber.error (/opt/app/node_modules/rxjs/internal/Subscriber.js:72:18)
at SwitchMapSubscriber.Subscriber._error (/opt/app/node_modules/rxjs/internal/Subscriber.js:92:26)
at SwitchMapSubscriber.Subscriber.error (/opt/app/node_modules/rxjs/internal/Subscriber.js:72:18)
at /opt/app/node_modules/rxjs/internal/util/subscribeToPromise.js:10:43
at runMicrotasks (<anonymous>)
at processTicksAndRejections (internal/process/task_queues.js:93:5)some one can help me to fix it? any hint or ideas are appreciated
2 replies
Deprecated as of 10.7.0. highlight(lang, code, ...args) has been deprecated. Deprecated as of 10.7.0. Please use highlight(code, options) instead.highlightjs/highlight.js#2277
Hi all, I'm new to typeorm but I'm seeing a very strange issue with the synchronize: true functionality when I modify an entity with a ManytoMany relationship. In short, any data that is in the join table before making the entity change, is gone after.
Here is my Project Entity
@ObjectType()
@Entity("project")
export class Project extends BaseEntity {
@Field(() => Int)
@PrimaryColumn()
id: number;
@Field()
@Column("text")
name: string;
@Field({ nullable: true })
@Column("text", { nullable: true })
cluster?: string;
//project_groups
@ManyToMany((type) => Group, (group) => group.projects, { lazy: true })
@Field((type) => [Group], { nullable: true })
@JoinTable()
groups?: Group[];
}Here is my Group Entity
@ObjectType()
@Entity("group")
export class Group extends BaseEntity {
@Field(() => String)
@PrimaryColumn()
id: string;
@Field()
@Column("text")
name: string;
@Field({ nullable: true })
@Column("text")
type: string;
@Field({ nullable: true })
@Column("text", { nullable: true })
currency: string;
@Field((type) => [Project])
@ManyToMany((type) => Project, (project) => project.groups, { lazy: true })
projects: Project[];
//group_modifiers
@ManyToMany((type) => Modifier, (modifier) => modifier.group, { lazy: true })
@Field((type) => [Modifier])
@JoinTable()
modifiers: Modifier[];
}If I add a new field to either the Group or the Project, the migration is automatically run and the following queries
query: CREATE TABLE "temporary_project" ("id" integer PRIMARY KEY NOT NULL, "name" text NOT NULL, "cluster" text, "asdfa" text)
query: INSERT INTO "temporary_project"("id", "name", "cluster") SELECT "id", "name", "cluster" FROM "project"
query: DROP TABLE "project"
query: ALTER TABLE "temporary_project" RENAME TO "project"project_groups_group table has data before, and is empty after the migration is finished
How to get count and num of relation.
but it's not work
Is there any way to select only few related table columns with find() method?
I have a question on Stackoverflow, please have a look and help me. Thank you
https://stackoverflow.com/questions/66956327/typeorm-no-metadata-for-user-was-found-only-in-production
Does anyone know if it's possible to set a field to null using the save method? Is there some fancy trick that I'm unaware of? Do I need to use some sort of helper function like IsNull when you're working with the find methods?
For example...
// Let's find Jeff and get rid of his stupid middle name
const jeff = await userRepository.findOne({firstName: 'Jeff'})
jeff.middleName = null
await userRepository.save(jeff)
// Doesn't work... Jeff still has a middle nameupdate method to accomplish this, but my use case is dependent on the TypeORM events/subscribers system, and update unfortunately does not work with the event system
Using TypeOrm for the first time against an already existing schema, the table names are plural and PascalCase and the entities should be singular. Therefore I'm using
@Entity('AccessLogs')
export class AccessLog {To define the entity. When I run migrate:generate it generates a change script that tries to create that Table AccessLogs even though it already exists.
If I change the table name to lowercase:
@Entity('accesslogs')
export class AccessLog {the problem goes away - but then the mapping in the Entity decorator is wrong and a newly created database with these migrations with generate the lowercase table name, which won't match all the other existing instances of the database. Surely I can't be the first person who doesn't have lowercase or snake_case table names?
I am setting it approximately like so
const phones = [getRepository(Phone).create({model: 'iPhone'})];
getRepository(Owner).save({name: 'Alex', phones})
// insert into owners ... OK!
// but there is no insert into phones, so Alex is created without phones
Hi all, our team encounter a problem when using
@BeforeInsert() and @BeforeUpdate().
@Entity()
export class Ngo {
@Column('jsonb', { nullable: true })
onboardingData?: NgoOnboardingData;
@Column()
profileUpdated: boolean;
@OneToOne(() => NgoProfile, (ngoProfile) => ngoProfile.ngo, {
eager: true,
cascade: true,
})
ngoProfile: NgoProfile;
@BeforeInsert()
@BeforeUpdate()
setProfileUpdated() {
const updatedAtDate = this.ngoProfile.updatedAt,
reviewedAtDate = this.ngoProfile.reviewedAt,
unpublishedAtDate = this.ngoProfile.unpublishedAt;
if (
(this.onboardingData?.status?.profileEditCompleted ?? true) &&
(!reviewedAtDate || reviewedAtDate < updatedAtDate) &&
(!unpublishedAtDate || unpublishedAtDate < updatedAtDate)
) {
this.profileUpdated = true;
} else {
this.profileUpdated = false;
}
}
}We found out that when saving the ngo using Repository.save, the setProfileUpdated() was not triggered.
How to handle this case in TypeORM?
hey all, I'm getting this error I cannot for the life of me figure out. I didn't create this schema FYI.
I have a table called 'view' and it has a column named 'url'
my entity looks like
@Entity({ name: "view" })
export class View extends BaseEntity implements IView {
...
@Column()
public url?: string;
}and I postgresql describe the table and I see the url column in the table, but i'm getting this error
QueryFailedError: column View.url does not exist
No migrations are pending and the migration table is empty. Does anybody have pointers to help with this?
@ObjectIdColumn()
public _id: ObjectID;
nestjs/typeorm package allows to define retry counter, but after a few efforts application just dies. I want to keep DB-independent endpoints in work condition.
Hi!! is there anyway to trigger soft deletes in subscriber?
since it's updating the deletedAt column im using beforeUpdate and for the event type i tested UpdateEvent and RemoveEvent both
when i do a patch request everything is working fine but when it comes to delete request method both event.databaseEntity and event.entity will be undefined
hard delete is working just fine but soft delete.... any suggestion?
Hi have a problem with typeorm, I opened a question on stackoverflow here https://stackoverflow.com/questions/67960062/typeorm-type-entity-is-not-assignable-to-type-querydeeppartialentityent
Any help is appreciated